SSDT Template Reports

All SSDT created reports are displayed with the username 'SSDT'. You won't be able to change the report name, delete or have the ability to share the reports with users with a specific role because these reports are available to everyone.

SSDT Template Report Name	Definition

SSDT Template Report Name	Definition
1099 Vendor Report	Produces a report of 1099 vendor information. Allows you to filter on a YTD total and specific 1099 Type(s).
AR Billing Detail	Produces a detailed listing of Billing items.
AR Billing Summary	Produces a summary report of Billing items.
AR Detail Report	Detail listing of all billings and payments for various types of invoices.
AR Transaction Summary	Report listing the total billing and/or payment amounts for various types of invoices for one or more customer.
Account Change Report	Produces a report of account changes made via the Account Change option under Utilities.
Account Validation Report	Produces a report of invalid accounts with an explanation of why they are invalid.
Anticipated Revenue Transactions	Produces a report, sorted in account code order, containing the budget modifications made to revenue accounts.
Appropriated Amounts by Cash Account	Summary report by FUND-SCC containing appropriated amounts.
Appropriation Expense Worksheet	Summary report for appropriation accounts. Similar to the Appropriation Summary but this report also includes three prior years expended amounts.
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 three prior fiscal years. The user can select the funds to be reported
Appropriation Summary	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.
Appropriations and Receivables by Cash Account	Produces a report displaying the initial cash, prior year encumbrances, FYTD receivable, FYTD appropriated and FYTD received by cash account.
Audit Trail	Produces an 'audit trail' report when adding, deleting, or making modifications while using the programs in USAS-R.
Auditable Events	Records any audit-able events that occurred in the software. For example, the requisition approval status installation.
Budget Account Activity	Produces a detailed report of the transactions that make up the amounts in the budget accounts. The report includes expendable and expended data.
Budget Expense Worksheet	Summary report for budget accounts. Similar to the Budget Summary but this report also includes three prior years expended amounts.
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 three prior fiscal years. The user can select the funds to be reported.
Budget Summary	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.
Budget Summary MOE	Produces a budget summary report containing the accounts involved in the Maintenance of Effort.
Budget Transactions	Produces a report, sorted in account code order, containing the budget modifications made to expenditure accounts.
Budget Transactions Summarized by Appropriation	Produces a report, sorted in account code order, containing the budget modifications summarized at the appropriation account level.
Cash Account History	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.
Cash Account History Detail	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.
Cash Summary	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 - Budget	Chart of accounts displaying each budget account and its corresponding description.
Chart of Accounts - Revenue	Chart of accounts displaying each revenue account and its corresponding description.
Civil Proceedings	Produces a report of any law suits pending against the district during the reporting period.
Classic Carry Over Reconciliation	Produces a report of adjustments made while importing carryover encumbrances from Classic to Redesign.
Disbursement Detail	Produces a detailed listing of disbursements which have been processed.
Disbursement Summary	Produces a summary listing of disbursements (checks) which have been processed.
District Building Profile Report	Produces a report of the data entered under the Periodic's Building Profile option.
Error Corrections and Supplies Distributions	Produces a report of the data entered in Distributions/Error Corrections.
Federal Assistance Detail	Produces a report of the information entered in the Federal Assistance Detail program.
Federal Assistance Summary	Produces a report of the information entered in the Federal Assistance Summary program.
Financial Budget Report	Produces a summarized budget report by cash account. It sorts by FUND/SCC, then function level and then the rest of the account code.
Financial Detail	Produces a detailed report of the transactions that make up the amounts in the cash accounts. The report includes both receipt and expenditure data.
Financial Detail July 1st Cash Balances	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.
Financial Detail for Current Period	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.
Financial Report by Forecast Line Number	Produces a report containing the forecast line numbers and totals. The report will contain three prior year's actual values. It also includes the current FYTD expendable/receivable values as the first year estimate.
Fund to Fund Transfer Ledger	Produces a report containing fund to fund transfer and fund to fund advance transactions, sorted by date.
Impact on Encumbrance	Helpful in determining the transactions that make up the adjusting entries on the SSDT Classic Carryover Reconciliation report.
Inventory Pending Extract	Extract invoice data needed for the EIS pending file in Classic.
Listing of Transactions by Account	Produces a report listing accounts in numerical order including detailed expenditure and receipt transactions.
Monthly Balance	Produces a report of ending monthly cash balance for one, several or all funds for a particular month(s) or fiscal year(s).
Negative Appropriation Account	Produces a report displaying appropriation accounts that have a FYTD unencumbered balance less than zero.
Negative Budget Account	Produces a report displaying budget accounts that have a FYTD unencumbered balance less than zero.
OPU Listing	Produces a report of operational units.
Outstanding Disbursement Summary	Produces a report of outstanding disbursements based on the current period.
Outstanding Invoices by Vendor Name	Produces a report of used of outstanding invoices, default sorting by vendor name.
Outstanding Purchase Orders	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.
Post Import Vendor Report	Produces a report of vendors that did not import fully due to invalid data in classic.
Purchase Order Detail	Produces a detailed purchase order report containing information on individual purchase order items.
Purchase Order Summary	Produces a report summarizing purchase order transactions.
RAM Export	Produces a CSV file of extracted non-converted requisitions in order to upload into RAM.
RAM Export Updated	Produces a CSV file of extracted non-converted requisitions in order to upload into RAM. 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.
Receipt Ledger	Produces a report of receipt transactions by cash account, sorted by date.
Receipt Listing	Produces a report of receipt items by date.
Reduction of Expenditure Ledger	Produces a report of reduction of expenditure transactions by cash account, sorted by date.
Refund Ledger	Produces a report of refund items by cash account, sorted by transaction date.
Requisition Detail	Produces a detailed requisition report containing information on individual requisition items.
Requisition Summary	Produces a report summarizing requisition transactions.
Revenue Account Activity	Produces a detailed report of the transactions that make up the amounts in the revenue accounts. The report includes receivable and receipt data.
Revenue Account History	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.
Revenue Detail with NYP	Produces a Revenue Detail report that includes Next Year Proposed (NYP) Amounts
Revenue Expense Worksheet	Summary report for revenue accounts. Similar to the Revenue Summary but this report also includes three prior years received amounts.
Revenue Summary	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.
Revenue Summary by Fund with NYP	Produces a Revenue summary report that includes Next Year Proposed (NYP) amounts, summarized by fund.
Spending Plan Comparison	Generates a report in Five Year Forecast format comparing the estimated figures with the actual figures.
Spending Plan Monthly	Generates a report in Five-Year Forecast format listing each monthly actual amount for each line number and a FYTD total.
Spending Plan Summary	Generate a report in Five-Year Forecast format listing the current periods actual amount for each line number and a FYTD total.
Summary of Cash Balances by Fund	Summary of cash by fund and includes Fund, Description, FY Beginning Balance, FYTD Activity, MTD Activity and Current Fund Balance.
Summary of Expenditures by Fund	Summary of expenditures by fund and includes Fund, Description, FYTD Expendable, FYTD Expended, MTD Expended, Fiscal Year Encumbrances, FYTD Remaining Balance and FYTD Percent Expended
Summary of Revenues by Fund	Summary of revenue by fund and includes the FYTD receivable amount, FYTD actual receipts, MTD actual receipts, FTYD balance receivable, and FYTD percent receivable.
Title Budgets	Produces a Title Budget Report that compares current encumbrances and FYTD Expenditures with prior year's expenditures.
Transaction Ledger - Vendor Activity	Produces a transaction ledger report sorted by vendor activity.
Transfer Advance Activity	Produces a report of all transfer and advance transactions by cash account. Includes repay advance transactions.
Transfer Advance Summary	Produces a report of transfers and advances.
USAS Auditor Extract - Account	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.
USAS Auditor Extract - Transaction	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.
USAS Auditor Extract - Vendor	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.
USAS Role Listing	A listing of USAS roles and the permissions they grant
User Listing Report	Produces a report of all user accounts. Can be filtered to exclude Roles or show only enabled/disabled users.
User Listing AOS Extract	All User listing in tab delimited format
Vendor Listing	Produces report of vendors in alphabetical order with PO address, phone number, ID and YTD amount.
Vendor Master	Produces a report of vendors in alphabetical order with PO address, ID, 1099 Type and YTD amount.
Void Refund Ledger	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

Detail 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' to 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 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 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 when adding, deleting, or making modifications while using the programs in USAS-R

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 to 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 three prior year's 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 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 account UI.

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

Chart of accounts listing that displays each budget account and its corresponding description.

Chart of Accounts - Revenue

Chart of accounts listing that displays each revenue account and its corresponding description.

Civil Proceedings

Contains court case data pending against the district during the reporting period.

Classic Carry Over Reconciliation

This report summarizes the differences between Classic's imported carryover encumbrances and the Redesign'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 with 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 with 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's 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 that make up the federal program monies for the fiscal year reported. User may choose fiscal year under Query Options.

Federal Assistance Summary Report

The report indicates whether a district has expended or received more or less than $750,000 in federal program monies for the fiscal year reported. User may choose 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:

Financial Detail

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 for but does not include beginning and ending balances

TIP: The default start and end dates are for the current period. However, you may overwrite these parameters to your desired start and ending dates.

Snapshot of Report in EXCEL Format:

Financial Detail Report July 1st Cash Balances

Detailed report of the transactions that make up the amounts in the cash accounts. The report includes both receipt and expenditure data. It includes the beginning and ending cash balances for each cash account and will generate for the entire fiscal year.

TIP: The Remaining Encumbrance amounts showing on the report are only for Purchase Order transactions dated within the current fiscal year.

Snapshot of report in PDF format

Financial Detail for Current Period

Detailed report of the transactions that make up the amounts in the cash accounts. The report includes both receipt and expenditure data. It includes the beginning and ending cash balances but will only generate for the current period.

Snapshot of Report in PDF Format:

Financial Report by Forecast Line Number

Contains the forecast line numbers and totals, including current FYTD expendable/receivable values as the first year estimate.. Also includes three prior year's actual values.

Snapshot of Report in CSV Format:

Fund to Fund Transfer Ledger

Contains fund to fund transfer and fund to fund advance transactions, sorted by date.

Snapshot of Report in PDF Format:

Impact on Encumbrance Report

It generates a report on the impact encumbrances have on the system. This report is helpful in determining the transactions that make up the adjusting entries on the SSDT Classic Carryover Reconciliation report.

Inventory Pending Extract

For those districts that are not using Redesign Inventory yet, an extract of existing invoice data in USAS-R can be imported into the EIS pending file in Classic. The data will be pre-formatted in CSV format. Classic EIS's EISIMPR program can be used to import the data into the existing pending file in classic's EIS system.

Please click here for step-by-step instruction on how to extract inventory data out of Redesign and import the data into the classic EIS pending file.

The EIS Classic Integration Module and the EIS Classic Integration Configuration must be set before running the Inventory Pending Extract file.

Snapshot of report in CSV format:

Listing of Transactions by Accounts Report

Listing of accounts in numerical order including detailed expenditure and receipt transactions for a given time period with any PO that is still outstanding/invoiceable.

TIP: The default start and end dates are for the current period. However, you may overwrite these parameters to your desired start and ending dates.

Monthly Balance Report

Ending monthly cash balance for one, several or all funds for a particular month(s) or fiscal year(s).

Snapshot of Report in PDF Format:

Negative Appropriation Account

Displays appropriation accounts that have a FYTD unencumbered balance less than zero.

Snapshot of Report in PDF Format:

Negative Budget Account

Displays budget accounts that have a FYTD unencumbered balance less than zero. The report sorts and subtotals by FUND level first, then FUND-SCC.

Snapshot of Report in PDF Format:

OPU Listing

A report of operational units.

Snapshot of Report in PDF Format:

Outstanding Disbursement Summary

Detailed disbursement report that allows the user the option to generate it for a particular period and it will reflect the outstanding disbursement amounts as of that period.

Outstanding Invoices by Vendor Name

Report of outstanding invoices, default sorting by vendor name.

Snapshot of Report in PDF Format:

Outstanding Purchase Orders

Detailed purchase order report that allows the user the option to generate it for a particular period and it will reflect the encumbered amounts as of that 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.

Post Import Vendor Report

This report lists the vendors that did not fully import due to invalid data in Classic. This is a one-time import report.

Purchase Order Detail

Detailed purchase order report containing information on individual purchase order items

Snapshot of Report in PDF Format:

Purchase Order Summary

Report summarizing purchase order transactions.

Snapshot of Report in PDF Format:

RAM Export

Produces a CSV file of extracted non-converted requisitions in order to upload into RAM.

RAM Export Updated

Produces a CSV file of extracted non-converted requisitions in order to upload into RAM. 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.

The Updated RAM Export includes the Requisition Header Description and Created Date fields.

Receipt Ledger

Receipt transactions by cash account, sorted by date. This report includes receipt 'RC' types only.

Snapshot of Report in PDF Format:

Receipt Listing

A report of receipt items by date. This report includes both Receipts (RC) and Reduction of Expenditures (RX).

Snapshot of Report in PDF Format:

Reduction of Expenditure Ledger

Reduction of expenditure transactions by cash account, sorted by date.

TIP: The default start and end dates are for the current period. However, you may overwrite these parameters to your desired start and ending dates.

Snapshot of Report in PDF Format:

Refund Ledger

Refund items by cash account, sorted by transaction date.

TIP: The default start and end dates are for the current period. However, you may overwrite these parameters to your desired start and ending dates.

Snapshot of Report in PDF Format

Requisition Detail

Detailed requisition report containing information on individual requisition items.

Requisition Summary

Report summarizing requisition transactions.

Snapshot of Report in PDF Format:

Revenue Account Activity

Detailed report of the transactions that make up the amounts in the revenue accounts. The report includes receivable and receipt data.

TIP: The default start and end dates are for the current period. However, you may overwrite these parameters to your desired start and ending dates.

Snapshot of Report in PDF Format

Revenue Account History

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.

Revenue Detail with NYP

Revenue Summary detailed report with Next Year Proposed Column included.

Revenue Expense Worksheet

Summary report for revenue accounts. This report is similar to the Revenue Summary but it also includes three prior year's received amounts.

Snapshot of Report in PDF format:

Revenue Summary

Summary report for one, several, or all of the revenue accounts. It includes the receivable amount, actual receipts, balance receivable, and FYTD percent received.

Snapshot of Report in EXCEL Format:

Revenue Summary by Fund with NYP

Revenue Summary report sorted by Fund with Next Year Proposed column included.

Spending Plan Comparison

The Spending Plan Comparison will generate a report comparing the estimated figures with the actual figures. The estimated figures are pulled from the user's estimates entered in the Periodic<Spending Plan menu. The report will print three lines per Five-Year Forecast line number: one for the estimated amount, one for the actual amount and the third line will print the difference between the estimated and actual amounts. The totals for the estimate figures entered will show on lines 1.070, 2.070, 2.080 and 4.500.

Spending Plan Monthly

The Spending Plan Monthly will generate a report in the same line number format as the Five-Year Forecast. It will list each monthly actual amount for each line number and will include a FYTD total.

Spending Plan Summary

The Spending Plan Summary will generate a report in the same line number format as the Five-Year Forecast. It will list the current periods actual amount for each line number and will include a FYTD total.

Summary of Cash Balances by Fund

Summary of cash by fund report which includes Fund, Description, FY Beginning Balance, FYTD Activity, MTD Activity and Current Fund Balance.

Snapshot of Report in PDF Format:

Summary of Expenditures by Fund

Summary of expenditures by fund report which includes Fund, Description, FYTD Expendable, FYTD Expended, MTD Expended, Fiscal Year Encumbrances, FYTD (Expendable) Remaining Balance and FYTD Percent Expended.

Snapshot of Report in PDF Format:

Summary of Revenues by Fund

Summary of revenue by fund report which includes the FYTD receivable amount, FYTD actual receipts, MTD actual receipts, FTYD balance receivable, and FYTD percent receivable.

Classic Comparison: FNDREV

Snapshot of Report in PDF Format:

Title Budgets

Produces a report that compares current encumbrances and FYTD Expenditures with prior year's expenditures.

Snapshot of Report in PDF Format:

Transaction Ledger - Vendor Activity

Transaction ledger report sorted by vendor activity.

TIP: The default start and end dates are for the current period. However, you may overwrite these parameters to your desired start and ending dates.

Snapshot of Report in Excel Format:

Transfer Advance Activity

A listing of all transfer and advance transactions by cash account. Includes Classic's advances and (Legacy) repay transactions.

Please refer to the USAS Public Shared Report Library for the report definition & snapshot example of a report that will include Redesign's Advance Repayments.

Snapshot of Report in PDF Format:

Transfer Advance Summary

A brief summary of fiscal year-to-date amounts posted to transfer or advance accounts by Fund/SCC.

Snapshot of Report in PDF Format:

USAS Auditor Extract - Account

USAS Auditor Extract-Account will extract 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. Normally, this extract is run annually as a part of the fiscal year end closing procedure. It should be run after all processing is completed for the fiscal year and email to the following AOS email: ISA-SchoolSW@auditor.state.oh.us The email's subject line should also be formatted as "999999_YEAR_USAS-R" replacing the nines with your IRN and "YEAR" with the 4 digit fiscal year end (i.e. IRN999_2021_USAS-R)

USAS Auditor Extract - Transaction

USAS Auditor Extract-Transaction will extract 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. Normally, this extract is run annually as a part of the fiscal year end closing procedure. It should be run after all processing is completed for the fiscal year and emailed to the following AOS email: ISA-SchoolSW@auditor.state.oh.us The email's subject line should also be formatted as "999999_YEAR_USAS-R" replacing the nines with your IRN and "YEAR" with the 4 digit fiscal year end (i.e. IRN999_2021_USAS-R)

USAS Auditor Extract - Vendor

USAS Auditor Extract-Vendor will extract 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. Normally, this extract is run annually as a part of the fiscal year end closing procedure. It should be run after all processing is completed for the fiscal year and emailed to the following AOS email: ISA-SchoolSW@auditor.state.oh.us The email's subject line should also be formatted as "999999_YEAR_USAS-R" replacing the nines with your IRN and "YEAR" with the 4 digit fiscal year end (i.e. IRN999_2021_USAS-R)

USAS Role Listing

Produces a report of all USAS roles and the permissions they grant.

User Listing Report

Produces a report of all user accounts. Can be filtered to exclude Roles or show only enabled/disabled users.

Snapshot of Report in PDF Format:

User Listing AOS Extract

Produces a report of all user accounts using the tab delimited format as AOS requested.

Vendor Listing

Report of vendors in alphabetical order with PO address, phone number, ID and YTD amount.

Snapshot of Report in PDF Format:

Vendor Master

Report of vendors in alphabetical order with PO address, ID, 1099 Type and YTD amount

Snapshot of Report in CSV Format:

Void Refund Ledger

Report of voided refunds by cash account, sorted by date.