Canned Reports
SSDT Canned Reports | Classic Comparison | Replaces Template Report | Definition |
|---|---|---|---|
BUDLED / REVLED | SSDT Budget Account Activity Report | Generates a detailed report of transactions that make up the amounts in either the Budget accounts or the Revenue accounts per selection. The Canned report version of the Budget/Revenue Account Activity Report to increase performance. | |
PAYABL | Generates a report listing all accounts payable. | ||
ACCSTS | Contains both budget and revenue activity on a single report. | ||
AUDITS | SSDT Audit Trail | Produces a report showing the 'audit trail' of transactions when adding, deleting, or making modifications while using the programs in USAS. | |
BUDSUM | SSDT Budget Summary | Produces a report of budget account information, including expendable amount, actual expenditures, current encumbrances, and unencumbered balances. | |
CHEKPY | SSDT Disbursement Detail | Produces a report of disbursements that have been processed. | |
FINDET | SSDT Financial Detail Report | Produces a detailed report of the transactions that make up the amounts in the cash accounts. The report includes both receipt and expenditure data. | |
FUNDSUMM | Contains the general fund accounts listed by function or object, and the remaining accounts are listed by fund totals only. | ||
N/A | Generates a report listing all Group Chains with the option to include Archived group chains. | ||
PODETL | SSDT Purchase Order Detail Report | Detailed purchase order report containing information on individual purchase order items. | |
VENHIRE | Contains independent contractors' data meeting the Ohio New Hire reporting requirements. | ||
FNDREVEX | Contains MTD and FYTD activity for each Fund/Fund-SCC with calculated difference between Revenue and Expenditures. | ||
Generates a report listing the requisition approval audit trail for those requisitions in the Workflow process. This information is also available on each requisition. |
Account Activity Report
Generates a detailed report of transactions that make up the amounts in either the Budget accounts or the Revenue accounts per user's selection. The canned report version of the Budget/Revenue Account Activity Report was created to increase performance.
Save and Recall: Can be used to save the report’s parameters and recall the same options later.
Account Activity Type: Defaults to Budget being selected, but the Revenue option can be chosen.
Start/Stop dates: Select dates for output report if desired.
Format: Select format for output report. Defaults to PDF.
Include Full Account Code(s): Filter to only include transactions charged to a specific detail Account Code(s).
Include other Account Code Parameters: Filters to only include transactions charged to accounts that meet the entered parameters. Wildcards cannot be utilized in these fields. For more complex sort options, an account filter can be used.
Filter: Select an account filter to include only transactions meeting those account parameters on the report.
Show Options: This option will include a cover page that displays the report options chosen for generating the report.
Generate: Generates the report.
In addition to the standard Report Parameter selection, this report also includes the ability to update the Sort Options. For more information on how to use these options, see the Reports Manager section for the Dynamic Sort - Sort Options.
Snapshot of the reports in PDF format.
Account Payable Report
The Account Payable Report generates a report listing all accounts payable. This report is useful for determining all payable amounts as of the last day of the fiscal year, which is essential for GAAP reporting.
The Account Payable Report field defaults to June 30 of the most recently closed fiscal year. You have the option of overriding the default date. This date, along with the received date entered in the AP Invoice and the payment date, is then used to determine what items will be reported as payable amounts. Only items that have a received date before 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 before 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 you are running the report for outstanding purchase orders after the end of a fiscal year and want the report to reflect the actual amount encumbered as of June 30th, leave this option checked. If this is not needed, you may uncheck the option
Include invoice date in selection?: Leaving this unchecked will cause the report to select items with received dates prior to or equal to the user-specified date. Checking this option will include only items with both received and invoice dates before the user-specified date in the report.
Sort Options
Subtotal Options
Format: Select format for output report. Defaults to PDF.
Generate Report: Generates a current version of the report.
Snapshot of the report in PDF format.
Snapshot of the report in Excel-data format.
Account Status Report
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. The report can be run to include any posting period in the fiscal year; however, the posting period(s) included in the date range must be created under Core. The Start/End Date fields currently select transactions by posting period, so if a date within a period is selected, then all transactions related to that posting period will be included on the report.
Example
If the Start/Stop dates entered are 3/15/2021 to 4/15/2021 all qualifying transactions from the March 2021 and April 2021 posting periods will be included (3/1/2021 - 4/30/2021).
By default, all accounts are selected; however, users can narrow the results by using account dimensions or the Account Filter. The account status report is sorted by full account and activity with subtotals by activity only. It does not include accounts without transactions.
Save and Recall: Can be used to save the report’s parameters and recall options later.
Start/Stop dates: Select dates for output report if desired.
Report Format: Select format for output report. Defaults to PDF.
Include Cash Account(s): Filter to only include transactions charged to a specific Cash Account(s).
Include Full Account Code(s): Filter to only include transactions charged to a specific detail Account Code(s).
Exclude Full Account Code(s): Filter to exclude transactions charged to a specific detail Account Code(s).
Include other Account Code Parameters: Filters to only include transactions charged to accounts meeting the entered parameters. Wildcards cannot be utilized in these fields. For more complex sort options, an account filter can be used.
Filter: Select an account filter to include only transactions meeting those account parameters on the report.
Show Report Options: This option will include a cover page showing the selected report options used to generate the report.
In addition to the standard Report Parameter selection, this report also includes the ability to update the Sort Options. For more information on how to use these options, see the Reports Manager section for the Dynamic Sort - Sort Options.
Snapshot of the report in pdf format.
Audit Report
A report showing additions, deletions, and modifications to transactions with the ability to sort by username and date, as well as to use control and page breaks.
Classic Comparison: AUDITS
Save and Recall: Can be used to save report parameters and recall options later
Start/Stop dates: Required to select dates for the output report.
Select Operation: Select transaction operation(s) to be included on report:
Create - Will show transactions that have been created.
Update - Will show transactions that have been modified.
Delete - Will show transactions that have been deleted.
Select Objects: Select objects to sort on or leave blank to select all objects.
Select Specific Users: Select specific user or leave blank to select all users.
Format: Select format for output report. Defaults to PDF, but Comma Separated Values format is available.
Objects to be Audited | Included Target Types |
|---|---|
Purchase Order | PurchaseOrder, PurchaseOrderItem, and PurchaseOrderCharge |
Invoice | Invoice, InvoicePOItem, and Source |
Fund | AccountMapping |
CashAccount | CashTransaction |
Appropriation | |
ExpenditureAccount | ExpenditureAccountHistory |
RevnueAccount | RevenueAccountHistory |
BankAccount | |
DeliveryAddress | |
Opu | |
Organization | |
PostingPeriod | |
Project | |
Vendor | VendorLocation, MergedVendor |
ActivityLedger | |
Invoice | InvocieItem and InvoicePOItem |
Disbursement | DisbursementItem, DisbursementRefundItem, DisbursementInvoiceItem, DisbursmentExpenditureItem,BankTransaction |
Distribution | |
PurchaseOrder | PurchaseOrderItem, PurchaseOrderCharge |
Receipt | ReceiptIem |
Refund | RefundItem |
Requisition | RequisitionItem, RequisitionCharge, FileStore |
Building | |
CashReconciliation | CashRecItem |
CivilProceeding | |
FederalAssistanceDetail | |
FederalAssistanceSummary | |
CustomFieldDefinition | |
Role | Permission |
User | |
Budget | BudgetTransaction |
AnticipatedRevenue | AnticiaptedRevenueTransaction |
Budget Summary Report
Summary report for one, several, or all of the budget accounts. It includes the expendable amount, actual expenditures, current encumbrances, unencumbered balance, and percentage expended/encumbered.
Classic Comparison: BUDSUM
Save and Recall: Can be used to save report parameters and recall options later.
Format: Select format for output report. Defaults to PDF.
Include Cash Account(s): Filter to only include transactions charged to a specific Cash Account(s).
Include Full Account Code(s): Filter to only include transactions charged to a specific detail Account Code(s).
Exclude Full Account Code(s): Filter to exclude transactions charged to a specific detail Account Code(s).
Include other Account Code Parameters: Filters to only include transactions charged to accounts meeting the entered parameters. Wildcards cannot be utilized in these fields. For more complex sort options, an account filter can be used.
Filter: Select an account filter to include only transactions meeting those account parameters on the report.
Total As of Period: The period specified will be used to determine the period the totals will be calculated for.
Show Report Options: This option will include a cover page showing options chosen for generating the report.
Summary Report: Produces a report containing only the header, footer, subtotal, and total information.
Include only Active accounts?: Check to include only active accounts; leave unchecked to include both active and inactive.
Exclude Accounts with zero amounts?: Check to include only accounts where all relevant MTD, YTD, and FYTD amounts are zero; leave unchecked to include all accounts.
In addition to the standard Report Parameter selection, this report also includes the ability to update the Sort Options. For more information on how to use these options, see the Reports Manager section for the Dynamic Sort - Sort Options.
Snapshot of the report:
The % Exp/Enc field represents the percent of the FYTD Expendable that has been either Expended or Encumbered. This is calculated by (FYTD Expended + Encumbered)/FYTD Expendable
Disbursement Detail Report
A report listing disbursements (checks) that have been processed. The report can be generated as either a summary or a detailed report. The report can include various check types such as Accounts Payable, Refund, and Payroll, and allows you to filter by check status, including reconciled, voided, or outstanding.
Save and Recall: Can be used to save the report’s parameters and recall the saved options later.
Format: Select format for output report. Defaults to PDF.
Show Options: This option will include a cover page showing the options chosen for generating the report.
Summary Report: Produces a report containing only the header, footer, subtotal, and total information.
Select Disbursement Types: Accounts Payable, Refund, and Payroll can be selected to be included in the report.
Transaction Start & End Date: Will determine the date range for transactions included on the report. By default, all are selected.
Starting & Ending Check #: A range of check numbers can be selected if desired.
Disbursement Statuses: Outstanding, Reconciled, and Void can be selected to be included in the report. By default, all are selected.
Vendor #(s): Select a vendor number(s) if desired.
Filter: Select an account filter to include only transactions meeting those account parameters on the report.
In addition to the standard Report Parameter selection, this report also includes the ability to update the Sort Options. For more information on how to use these options, see the Reports Manager section for the Dynamic Sort - Sort Options.
Snapshot of the report
Financial Detail Report
A Detailed report of the transactions that make up the amounts in the cash accounts. The report includes both receipt and expenditure data. Allow users to enter a date range to generate the report.
Save and Recall: Can be used to save report parameters and recall options later
Report Link
The Report Direct Link is available for this report and can be utilized to generate a Financial Detail Spreadsheet with a Running Fund Balance. Format Type HTML-Table should be used for this option. For a walkthrough of how to create the Financial Detail Spreadsheet with Running Fund Balance, please click here.
Start & End Date: Required fields. Will determine the date range for transactions included on the report.
Date Range Selected
If the Start/End Dates are consistent with the Current Fiscal Year, the Beginning Cash Balance will be included on the report, and the Remaining Encumbrance column will be replaced with a Running Fund Balance. The Running Fund Balance column will also be included instead of Remaining Encumbrances when the Start Date is the first day of the current posting period. When generated for custom date ranges (ex. Monthly) the report will not include the Initial Cash Balance or a Running Fund Balance column. To run a report for a previous Fiscal Year with the Initial Balance, the Current Period should be changed to a period within that fiscal year.
Display Running Fund Balance: The Box to select Display Running Fund Balance is only available when the Start Date is either the first day of the current Fiscal year or the first day of the current posting period. If the start date is any other day, the user will receive a message:
The Running Fund Balance is calculated when generating to PDF Report Format.
Report Format: Select the report format for the desired report. Defaults to PDF format.
When using the Comma Separated Values, Excel-Data, or Excel-Fieldnames format, the output will include additional columns for the Sortable Properties:
Fund
Function
Function One Digit Level
Function Two Digit Level
Receipt
Receipt One Digit Level
Receipt Two Digit Level
Object
Object One Digit Level
SCC
Subject
Subject Two Digit Level
OPU
OPU One Digit Level
Job
IL
Forecast Line Number
Include Cash Account(s): Filter to only include transactions charged to a specific Cash Account(s).
Include Full Account Code(s): Filter to only include transactions charged to a specific detail Account Code(s).
Exclude Full Account Code(s): Filter to exclude transactions charged to a specific detail Account Code(s).
Include other Account Code Parameters: Filters to only include transactions charged to accounts that meet the entered parameters. Wildcards cannot be utilized in these fields. For more complex sort options, an account filter can be used
Total As of Period: The period specified will be used to determine the period in which the Ending Cash Balances will be calculated.
Filter: Select an account filter to include only transactions meeting those account parameters on the report.
Show Report Options: This option will include a cover page displaying the options chosen for generating the report.
Summary Report: Produces a report containing only the header, footer, subtotal, and total information.
In addition to the standard Report Parameter selection, this report also includes the ability to update the Sort Options. For more information on how to use these options, see the Reports Manager section for the Dynamic Sort - Sort Options.
Snapshot of the report with Initial Cash Balance and Running Fund Balance:
Snapshot of the report with a date range not starting at the beginning of the FY/Period and therefore displaying the remaining encumbrance column:
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. The report displays the Fund, Function, Description, Appropriation, the amount Expended, % Expended, amount Encumbered, and the Balance. The July 1 Cash Balance, Total MTD receipts, and Current Cash Balance for 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 all amounts are zero. Some accounts may have amounts that do not appear on this report (ex. Initial Cash) so all columns will appear as 0.00. These accounts are included so the totals at the bottom of the report may include all activity.
Show Report Options: This option will include a cover page displaying the options chosen for generating the report.
Format: Select the report format for the desired output. Defaults to PDF.
Submit: Generate Report
Snapshot Categorized by Function:
Snapshot Categorized by Object:
Group Chain Report
Detailed canned report showing the Group Chain and the Group Name(s) included in the Group Chain.
Checkmark
to include Group Chains that have been archived.
Select and drag the Available Group Chains from left to right, or leave blank to include all Chains not archived. To deselect, drag from right to left.
Sample PDF
Purchase Order Detail Report
Detailed purchase order report containing information on individual purchase order items.
Save and Recall: Can be used to save the report’s parameters and recall the saved options later.
Report Link
The Report Direct Link is available for this report and can be utilized to generate a spreadsheet that can be refreshed in Excel. Format Type HTML-Table should be used for this option. For a walkthrough of how to use the Report link that uses the Financial Detail Spreadsheet with Running Fund Balance as an example, please click here.
Status: User can use the dropdown to select All, Invoiceable, or Outstanding purchase orders to be reported.