SSDT Template Reports
All SSDT created reports are displayed with the username 'SSDT'. You will not be able to change the report name, delete the report, or have the ability to share the reports with users with a specific role. These reports are available to everyone.
SSDT Template Report Name | Definition |
|---|---|
Produces a report of 1099 vendor information. Allows you to filter on a YTD total and specific 1099 Type(s). | |
Produces a detailed listing of Billing items. | |
Produces a summary report of Billing items. | |
Detailed listing of all billings and payments for various types of invoices. | |
Report listing the total billing and/or payment amounts for various types of invoices for one or more customers. | |
Produces a report of account changes made via the Account Change option under Utilities. | |
Produces a report of invalid accounts with an explanation of why they are invalid. | |
Produces a report, sorted in account code order, containing the budget modifications made to revenue accounts. | |
Summary report by FUND-SCC containing appropriated amounts. | |
Summary report for appropriation accounts. Similar to the Appropriation Summary, but this report also includes three prior years' expended amounts. | |
Produces a report showing appropriation accounts, current FYTD Expendable, FYTD Actual Expended, as well as total expenditures by appropriation account for each of the three prior fiscal years. The user can select the funds to be reported | |
Produces a summary report for one, several, or all of the appropriation accounts. It includes the expendable amount, actual expenditures, current encumbrances, unencumbered balance, and percentage expended/encumbered. | |
Produces a report displaying the initial cash, prior year encumbrances, FYTD receivable, FYTD appropriated, and FYTD received by cash account. | |
Produces an 'audit trail' report when adding, deleting, or making modifications while using the programs in USAS. | |
Records any audit-able events that occurred in the software. For example, the requisition approval status installation. | |
Produces a detailed report of the transactions that make up the amounts in the budget accounts. The report includes expendable and expended data. | |
Summary report for budget accounts. Similar to the Budget Summary, but this report also includes three prior years' expended amounts. | |
Produces a report showing budget accounts, current FYTD Expendable, FYTD Actual Expended, as well as total expenditures by budget account for each of the three prior fiscal years. The user can select the funds to be reported. | |
Produces a 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. | |
Produces a budget summary report containing the accounts involved in the Maintenance of Effort. | |
Produces a report, sorted in account code order, containing the budget modifications made to expenditure accounts. | |
Produces a report, sorted in account code order, containing the budget modifications summarized at the appropriation account level. | |
Produces a report of cash account history sorted by FUND-SCC. User enters fiscal year(s) and the report generated includes the FUND-SCC, description, beginning balance, FYTD expended, and FYTD received. | |
Produces a report of cash account history detail sorted by FUND-SCC. User enters fiscal year(s) and the report generated includes FUND-SCC, Description, Month, Beginning Balance, Expended, Received, and Ending Balance. | |
Produces a summary report for one, several, or all of the cash accounts. It includes the fund beginning balance, MTD and FTD expenditures and receipts, current fund balance, current encumbrances, and the unencumbered fund balance. | |
Chart of accounts displaying each budget account and its corresponding description. | |
Chart of accounts displaying each revenue account and its corresponding description. | |
Produces a report of any lawsuits pending against the district during the reporting period. | |
Produces a report of adjustments made while importing carryover encumbrances from Classic to Redesign. | |
Produces a detailed listing of disbursements that have been processed. | |
Produces a summary listing of disbursements (checks) that have been processed. | |
Produces a report of the data entered under the Periodic Building Profile option. | |
Produces a report of the data entered in Distributions/Error Corrections. | |
Produces a report of the information entered in the Federal Assistance Detail program. | |
Produces a report of the information entered in the Federal Assistance Summary program. | |
Produces a summarized budget report by cash account. It sorts by FUND/SCC, then function level, and then the rest of the account code. | |
Produces a detailed report of the transactions that make up the amounts in the cash accounts. The report includes both receipt and expenditure data. | |
Report of the transactions that make up the amounts in the cash accounts. The report includes both receipt and expenditure data. It also includes the July 1st cash balances through the ending period or date entered. | |
Report of the transactions that make up the amounts in the cash accounts. The report includes both receipt and expenditure data. It also includes the beginning and ending cash balances, but will only generate for the current period. | |
Produces a report containing the forecast line numbers and totals. The report will contain the three prior years' actual values. It also includes the current FYTD expendable/receivable values as the first year estimate. | |
Produces a report containing fund to fund transfer and fund to fund advance transactions, sorted by date. | |
Helpful in determining the transactions that make up the adjusting entries on the SSDT Classic Carryover Reconciliation report. | |
Extract invoice data needed for the EIS pending file in Classic. | |
Produces a report listing accounts in numerical order, including detailed expenditure and receipt transactions. | |
Produces a report of the ending monthly cash balance for one, several, or all funds for a particular month(s) or fiscal year(s). | |
Produces a report displaying appropriation accounts that have a FYTD unencumbered balance less than zero. | |
Produces a report displaying budget accounts that have a FYTD unencumbered balance less than zero. | |
Produces a report of operational units. | |
Produces a report of outstanding disbursements based on the current period. | |
Produces a report of used of outstanding invoices, default sorting by vendor name. | |
Produces a report of the outstanding purchase orders based on the current period. | |
SSDT Post Import Closed Purchase Orders with Remaining Balance | Produces a report of purchase orders that are not invoiceable but have a remaining balance. This could be caused by partial invoices dated after full invoices. |
SSDT Post Import Outstanding Purchase Orders with Zero Balance | Produces a report of purchase orders that are Invoiceable but do not have a remaining balance. |
Produces a report of vendors that did not fully import fully to invalid data in Classic software. | |
Produces a detailed purchase order report containing information on individual purchase order items. | |
Produces a report summarizing purchase order transactions. | |
Produces a CSV file of extracted non-converted requisitions to upload into the RAM software. | |
Produces a CSV file of extracted non-converted requisitions to upload into the RAM software. The Updated RAM Export has been added to USAS per LACA's request. Please do not use this new report to send your RAM extracts to LACA unless they have instructed you to do so. | |
Produces a report of receipt transactions by cash account, sorted by date. | |
Produces a report of receipt items by date. | |
Produces a report of the reduction of expenditure transactions by cash account, sorted by date. | |
Produces a report of refund items by cash account, sorted by transaction date. | |
Produces a detailed requisition report containing information on individual requisition items. | |
Produces a report summarizing requisition transactions. | |
Produces a detailed report of the transactions that make up the amounts in the revenue accounts. The report includes receivable and receipt data. | |
Produces a report showing revenue accounts, current FYTD Receivables, FYTD Actual Received, as well as total receipts by revenue account for each of three prior fiscal years. The user can select the funds to be reported. | |
Produces a Revenue Detail report that includes Next Year Proposed (NYP) Amounts | |
Summary report for revenue accounts. Similar to the Revenue Summary, but this report also includes the three prior years' received amounts. | |
Produces a summary report for one, several, or all of the revenue accounts. It includes the receivable amount, actual receipts, balance receivable, and FYTD percent received. | |
format | |
Generates a report in the Financial Forecast format comparing the estimated figures with the actual figures. | |
Generates a report in the Financial Forecast format listing each monthly actual amount for each line number and a FYTD total. | |
Generate a report in Financial Forecast format listing the current period's actual amount for each line number and a FYTD total. | |
Summary of cash by fund includes the Fund, Description, FY Beginning Balance, FYTD Activity, MTD Activity, and Current Fund Balance. | |
Summary of expenditures by fund includes the Fund, Description, FYTD Expendable, FYTD Expended, MTD Expended, Fiscal Year Encumbrances, FYTD Remaining Balance, and FYTD Percent Expended | |
Summary of revenue by fund includes the FYTD receivable amount, FYTD actual receipts, MTD actual receipts, FTYD balance receivable, and FYTD percent receivable. | |
Produces a Title Budget Report that compares current encumbrances and FYTD Expenditures with the prior year's expenditures. | |
Produces a transaction ledger report sorted by vendor activity. | |
Produces a report of all transfer and advance transactions by cash account. Includes repay advance transactions. | |
Produces a report of transfers and advances. | |
Extracts the Account data into a tab-separated value format. This file is used by the State Auditor's Office to help in the auditing process. | |
Extracts the Transaction data into a tab-separated value format. This file is used by the State Auditor's Office to help in the auditing process. | |
Extracts the Vendor data into a tab-separated value format. This file is used by the State Auditor's Office to help in the auditing process. | |
A listing of USAS roles and the permissions they grant. | |
Produces a report of all user accounts. Can be filtered to exclude Roles or show only enabled/disabled users. | |
All User listing in tab-delimited format | |
Produces a report of vendors in alphabetical order with PO address, phone number, ID, and YTD amount. | |
Produces a report of vendors in alphabetical order with PO address, ID, 1099 Type, and YTD amount. | |
Produces a report of voided refunds by cash account, sorted by date. |
1099 Vendor Report
Produces a report of 1099 types and their address information, Tax ID #, Tax ID Type (EIN or SSN), and YTD amounts are correct. You have the option to include all 1099 types regardless of YTD amounts or those meeting the IRS requirement. You may also run the report for specified 1099 Types (i.e. royalty payments).
Snapshot of the report in PDF format:
AR Billing Detail
Produces a detailed listing of Billing items.
Snapshot of report in PDF format:
AR Billing Summary
Produces a summary report of Billing items including the remaining amount.
Snapshot of report in PDF format:
AR Detail Report
Detailed listing of all billings and payments for various types of invoices.
Snapshot of report in PDF format:
AR Transaction Summary
Report listing the total billing and/or payment amounts for various types of invoices for one or more customers.
Snapshot of report in PDF format:
Account Change Report
Produces a report of account changes made via the Account Change option under Utilities.
Snapshot of report in PDF format:
Account Validation Report
Listing of invalid (Active) accounts with an explanation of why the accounts are considered invalid. You may choose to enter 'true' for the Exclude Accounts with Zero Amounts query parameter to only list invalid accounts with amounts.
Anticipated Revenue Transactions
Produces a report, sorted in account code order, containing the budget modifications made to revenue accounts.
Snapshot of PDF Format:
Appropriated Amounts by Cash Account
Summary report by FUND-SCC containing appropriated amounts.
Snapshot of report in PDF format:
Appropriation Expense Worksheet
Summary report for appropriation accounts. Similar to the Appropriation Summary, but this report also includes the three prior years' expended amounts
Snapshot of Report in PDF format:
Appropriation History
Produces a report showing appropriation accounts, current FYTD Expendable, FYTD Actual Expended, as well as total expenditures by appropriation account for each of the three prior fiscal years. The user can select the funds to be reported
Snapshot of Report in PDF format:
Appropriation Summary
Summary report for one, several, or all of the appropriation accounts. It includes the expendable amount, actual expenditures, current encumbrances, unencumbered balance, and percentage expended/encumbered.
Snapshot of Report in CSV format:
Appropriations and Receivables by Cash Account
Displays the Initial Cash, Prior Year Encumbrances, FYTD Receivable, FYTD Appropriated and FYTD Received by cash account. The last column shows a calculation of these fields: Initial Cash plus(+) FYTD Receivable minus(-) Carry Over (Prior Year) Encumbrance minus(-) FYTD Appropriated Appropriated amounts.
Snapshot of Report in PDF Format:
Audit Trail
An 'audit trail' report is generated when adding, deleting, or making modifications while using the programs in USAS.
Auditable Events Report
Records any auditable events that occurred in the software. For example, the requisition approval status was installed.
Snapshot of Report in PDF format:
Budget Account Activity Report
Detailed report of the transactions that make up the amounts in the budget accounts. The report includes expendable and expended data.
TIP: The default start and end dates are for the current period. However, you may overwrite these parameters with your desired start and ending dates.
Snapshot of Report in PDF Format:
Budget Expense Worksheet
Summary report for budget accounts. This report is similar to the Budget Summary, but it also includes the three prior years' expended amounts. When the user enters a date in the Total As Of Period, the totals generated will be the FYTD totals for the date entered. For example, if you enter 3/23/21 in this Total As Of Period, the Budget Expense Worksheet will generate the FYTD columns for the fiscal year 2021.
Snapshot of Report in PDF format:
Snapshot of Report in Excel-Data Format:
Budget History
Produces a report showing budget accounts, current FYTD Expendable, FYTD Actual Expended, as well as total expenditures by budget account for each of the three prior fiscal years. The user can select the funds to be reported.
Budget Summary
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.
Snapshot of Report in Excel Format:
Budget Summary MOE
Produces a budget summary report containing the accounts involved in the Maintenance of Effort - IDEA.
The following expenditure data is pulled for the IDEA MOE report:
Fund: 001-300, 400-499, 504, and 532.
Function: 1230-1239, 1240-1249, 1280, 1290, 1330-1339, 1350, 2140-2149, 2150-2159, 2180-2187, 2416, 2417, 2821 and 3412.
Object: 100 -190, 200-292, 400-499, 500-590, 600-690, and 844.
Budget Transactions
Produces a report, sorted in account code order, containing the budget modifications made to expenditure accounts in the system.
Snapshot in PDF Format:
Budget Transactions Summarized by Appropriation
Produces a report, sorted in account code order, containing budget adjustments summarized at the appropriation level.
Snapshot in PDF Format:
Cash Account History
Cash account history sorted by FUND-SCC. User enters fiscal year(s) and the report generated includes the FUND-SCC, description, beginning balance, FYTD expended, and FYTD received.
Snapshot in PDF Format:
Cash Account History Detail
Cash account history detail sorted by FUND-SCC. User enters fiscal year(s) and the report generated includes FUND-SCC, Description, Month, Beginning Balance, Expended, Received, and Ending Balance.
Snapshot in PDF Format:
Cash Summary
Summary report for one, several, or all of the cash accounts. It includes the fund beginning balance, MTD and FTD expenditures and receipts, current fund balance, current encumbrances, and the unencumbered fund balance.
Chart of Accounts - Budget
A chart of accounts listing that displays each budget account and its corresponding description.
Chart of Accounts - Revenue
A chart of accounts listing that displays each revenue account and its corresponding description.
Civil Proceedings
Contains details regarding pending court cases with the district during the reporting period.
Classic Carry Over Reconciliation
This report summarizes the differences between Classic software's imported carryover encumbrances and the Redesigned USAS's calculated amount. This is a one-time import report. The adjustments are derived by taking the carryover encumbrance imported from Classic, calculating the carryover encumbrance according to the Redesign's more correct calculations, and finding the difference between the two amounts. Please click here to go to the Post Import Procedures section of the Appendix and scroll down to the 'Differences in Carryover Encumbrances' section for further information on the Classic Carryover Reconciliation Report.
Snapshot of PDF Format:
Disbursement Detail
Detailed listing of disbursements (checks) which have been processed.
Generate Report Options:
Tips
To generate a report of 'outstanding' checks, enter a status of O.
Voided disbursements will be displayed as positive amounts on the report showing a void status. You will need to manually subtract the voided amount from the grand total or exclude the voided disbursement if you want a report containing true expended amounts.
Disbursement Summary
Listing of disbursements (checks) which have been processed.
Generate Report Options:
Tips
To generate a report of 'outstanding' checks, enter a status of O.
Voided disbursements will be displayed as positive amounts on the report showing a void status. You will need to manually subtract the voided amount from the grand total or exclude the voided disbursement if you want a report containing true expended amounts.
Snapshot of Report in CSV Format:
District Building Profile Report
A report of the data entered under the Periodic Building Profile option.
Error Corrections and Supplies Distributions
A report summarizing transactions entered in Distributions/Error Corrections.
Federal Assistance Detail Report
The report details the FUND/SCC and amounts entered by the user that includes the federal program monies for the fiscal year reported. Since October 1, 2024, the federal Single Audit threshold has increased from $750,000 to $1 million in federal expenditures for fiscal years starting after Oct. 1, 2024. The User may choose the fiscal year under Query Options.
Federal Assistance Summary Report
The report will show if the federal Assistance Over Threshold is met for the fiscal year, indicating the district has received more than the threshold. Since October 1, 2024, the federal Single Audit threshold has increased from $750,000 to $1 million in federal expenditures for fiscal years starting after Oct. 1, 2024. The user may choose the fiscal year under Query Options.
Financial Budget Report
Summary report of budget account data. Sorted by FUND/SCC, then FUNCTION, and then the rest of the account.
Snapshot of the report in PDF format: