Child pages
  • Canned Reports
Skip to end of metadata
Go to start of metadata
SSDT Canned ReportsClassic ComparisonDefinition
Account Payable ReportPAYABLGenerates a report listing all accounts payable
Account StatusACCSTSContains both budget and revenue activity on a single report
Financial Summary by Fund ReportFUNDSUMMContains the general fund accounts listed by function or object and the remaining accounts are listed by fund totals only
Vendor New HireVENHIREContains independent contractors data meeting the Ohio New Hire reporting requirements
Revenues and Expenditures ReportFNDREVEXContains MTD and FYTD activity for each Fund/Fund-SCC with calculated difference between Revenue and Expenditures

Account Payable Report

The Account Payable Report generates a report listing all accounts payable. This report is particularly useful in determining all payable amounts as of the last day of the fiscal year (necessary for GAAP reporting).

The Account Payable Report field defaults to June 30 of the last fiscal year closed. You have the option of overriding the default date. This date, along with the received date entered in AP Invoice, and the payment date are then used in determining what items will be reported as payable amounts. Only items that have a received date prior to the date entered and a paid date after the date entered, or have not yet been paid, will be reported. For example when determining payable amounts as of the end of a fiscal year, the "Date" would be set to June 30, XXXX. The report would then display any items that have been invoiced with a received date prior to June 30 but have not yet been paid or the paid date is after June 30.

  • Date: defaults to June 30 of the last fiscal year closed.
  • Flag items as not encumbered as of this date?: If running the report for outstanding purchase orders after the end of a fiscal year and the report should show the actual amount which was encumbered as of June 30th then this should be left checked. Otherwise, uncheck this option. 
  • Include invoice date in selection?: Leaving this unchecked will cause the report to select items with received dates prior or equal to the user specified date. Checking this option will cause the report to select items with both received and invoice dates prior to the user specified date. 
  • Sort Options
  • Subtotal Options
  • Format: Select format for output report. Defaults to PDF.
  • Generate Report: Generates a current version of the report.

Account Status

The Account Status Report combines both budget and revenue activity on a single report. The report shows receipt, expenditure, purchase order, and invoice information.

The default date range is the current posting period. By default all accounts are selected but the user can narrow down accounts by utilizing the account dimensions listed. The account status report is sorted by full account, activity and subtotaled only by activity. It does not include accounts without transactions.


This account status report is slightly different from the Legacy ACCSTS report as it does not include account status or cash position blocks.


Financial Summary by Fund Report

A summarized financial report using one print line for each cash balance record, sorted by Fund. This report contains the general fund accounts listed by function or object and the remaining accounts are listed by fund totals only. Displays Fund, Function, Description, Appropriation, Expended, % Expended, Encumbered, Balance. The July 1 Cash Balance, Total MTD receipts and Current Cash Balance (all funds) are displayed at the end of the report.


  • Categorize Fund by: This option applies specifically to the General fund accounts. The General fund can be summarized by either Function or Object codes.
  • Exclude Zero Amount Accounts: This option will exclude accounts where amounts in all columns would be zero.
  • Show Report Options:This option will include a cover page showing options chosen for generating the report.
  • Format: Select format for output report. Defaults to PDF.
  • Submit: Generate Report

Snapshot Categorized by Function:


Snapshot Categorized by Object:

Vendor New Hire

The Vendor New Hire program allows for reporting of independent contractors to the Ohio New Hire reporting center.  Requirements and specifications can be found here: https://newhire-reporting.com/OH-Newhire/default.aspx.  The program will create a report listing all vendors with payments of at least $2,500.00 for the calendar year based off the reported date entered.  Vendors must have the "Report Status" field set to 'reportable' under the 'New Hire' section of the vendor record in order for the Vendor New Hire report to include them.  Other Vendor fields that may be filled in include:

  • ID#
  • Birth Date
  • Begin Date
  • Months

The report generated may be used to submit data to the New Hire Reporting Center.  An outline of the proposed processing for Vendor New Hire reporting is available here.

The data pulls the calendar year data based on the current period. If your current period is January 2019 but you want a report of CY2018's data, you must temporarily change the current period to December 2018.


  • Reported Date:This date is populated on the vendor's 'Last Reported Date' field  when the actual option runs
  • Projection Report: When checked, it will generate the report but it does not update the 'reported' flag or 'last reported date' fields on the vendor record 
  • Calculate date payments begin (if blank): When checked, it will calculate the date payments began using the payment information from the current calendar year's disbursements.  It will not auto populate the beginning payment date on the vendor's 'begin date' field.  If unchecked, it will look for the 'begin date' field on the vendor record.  If blank, it will generate an error on the report.  
  • Available Vendors, Force Vendors to be included and Remove Selected:  From 'Available Vendors', you may select a particular vendor you want included on the report in order to force the vendor to be included on the report  Use the 'remove selected' to remove any from the list.  After you have selected all vendors to be included, check the 'Force Vendors' box in order to include them on the report.
  • Show Report Options: This option will include a cover page showing options chosen for generating the report.

  • Format: Select format for output report. Defaults to PDF.

  • Generate Report: Generates a current version of the report.



Revenues and Expenditures Report

The Revenue and Expenditure report displays month-to-date and fiscal year-to-date activity by Cash Account (FUND-SCC) or Fund (accounts with SCC 0000-8999 will roll up  into the 0000 SCC for that fund).  The report subtotals on Object for Expenditure accounts and shows the difference between Revenue and Expenditures for each Cash Account or Fund. Each Object level includes the description of the Appropriation level Object. The report also contains the annual budget, encumbrances, and unencumbered balance figures.

  • Report By: Select to subtotal report by Cash Account or Fund.
  • Include Fund-SCC(s): Use to filter report to show specific Fund-SCC(s). When entering multiple Fund-SCCs use commas (no space) to separate.
  • Collapse Revenue
    • Y: collapse account to 4-digit receipt code level
    • N: do not collapse accounts
    • A: Collapse accounts to 2-digit receipt code level
  • Collapse Expenditure
    • Y: collapse account to object code level
    • N: do not collapse accounts
    • A: collapse all accounts to 1-digit object code level
  • Collapse Salary/Benefit
    • Checked: collapse all salary to single line and all benefit accounts to single line
    • Unchecked: do not collapse salary/benefit accounts
  • Track PTD Amounts
    • Checked: Include PTD amounts on the report
    • Unchecked: Excludes PTD amounts on the report
  • Exclude Zero Amount Accounts
    • Checked: Report will exclude accounts that have no activity within the Fiscal Year
    • Unchecked: Report will include all accounts 
  • Filter Name: filter the report based on an existing Account Filter
  • Show Report Options: This option will include a cover page showing options chosen for generating the report.

  • Format: Select format for output report. Defaults to PDF.

  • Report for a specific posting period (leaving it blank will default to the current period)

  • No labels