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. 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-R | |
BUDSUM | SSDT Budget Summary | Produces a report of budget account information including expendable amount, actual expenditures, current encumbrances and unencumbered balances | |
Canned Reports#Disbursement Disbursement Detail Report | CHEKPY | SSDT Disbursement Detail | Produces a report of disbursements which 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. |
...
Snapshot of the reports in pdf format.
...
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).
...
Snapshot of the report in pdf 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.
| Info |
|---|
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). |
...
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.
...
Save and Recall: Can be used to save report parameters and recall options later
Start/Stop dates: Required to select dates for 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 | |
OganizationOrganization | |
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.
...
| Info |
|---|
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) which have been processed. The report can produce a summary or a detailed report. The report can include various types of checks, including Accounts Payable, Refund and Payroll, and allows for various check statuses to be chosen (reconciled, voided or outstanding.)
...
Save and Recall: Can be used to save report parameters and recall options later.
Format: Select format for output report. Defaults to PDF.
Show 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.
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
| Info |
|---|
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.
| Info |
|---|
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. When generated for custom date ranges (ex. Monthly) the report will not include the Initial Cash Balance. 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. |
...
Snapshot of the report with Initial Cash Balance:
...
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.
...
Snapshot Categorized by Object:
...
Group Chain Report
Detailed canned report showing the Group Chain and the Group Name(s) included in the Group Chain.
...
Select and drag Available Group Chains from the left to right or leave blank to include all Chains not archived. To deselect, drag from right to left.
Checkmark
to include Group Chains that have been archived.
Sample PdfPDF
...
Purchase Order Detail Report
Detailed purchase order report containing information on individual purchase order items
...
Save and Recall: Can be used to save report parameters and recall options later
| Info |
|---|
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. |
...
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 report:
...
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. New Hire Reporting Center. 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:
...
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
Report for specific posting period (blank means current period) i
Date format acceptable. i.e. MM/YYYY MM-YYYY MM/DD/YY
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)
...
Requisition Approval Report
The Requisition Approval Report is available when the Workflows module is enabled. The report will display the requisition audit trail for all requisitions that are currently in the Workflow Approval process based on the parameters the user chooses.
Save and Recall: Can be used to save report parameters and recall options later
Report Format: Select the format for report. The report defaults to PDF.
Show Options: This option will include a cover page showing options chosen for generating the report.
Select Actions: Select and drag the Actions available (Submitted, Approved, Rejected, Recalled, Cancelled) from left to right or leave blank to include all Actions. To deselect, drag from right to left.
Select Statuses: Select and drag the Statuses available (InProgress, Approved, Rejected, Cancelled, Undefined) from left to right or leave blank to include all Statuses. To deselect, drag from right to left.
Starting & Ending Requisition #: A range of requisition numbers can be selected if desired.
Select Users: Select and drage drag the available User from left to right or leave blank to include all Users. To deselect, drag selection from right to left.
Generate: Generates the report.
...