SSDT Template Reports
- Former user (Deleted)
- Pat Zelei
- Former user (Deleted)
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 |
|---|---|
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. | |
Detail 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 customer. | |
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 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-R. | |
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 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 law suits 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 which have been processed. | |
Produces a summary listing of disbursements (checks) which have been processed. | |
Produces a report of the data entered under the Periodic's 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 three prior year's 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 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 import fully due to invalid data in classic. | |
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 in order to upload into RAM. | |
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. | |
Produces a report of receipt transactions by cash account, sorted by date. | |
Produces a report of receipt items by date. | |
Produces a report of 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 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. | |
Produces a Revenue summary report that includes Next Year Proposed (NYP) amounts, summarized by fund. | |
Generates a report in Five Year Forecast format comparing the estimated figures with the actual figures. | |
Generates a report in Five-Year Forecast format listing each monthly actual amount for each line number and a FYTD total. | |
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 by fund and includes Fund, Description, FY Beginning Balance, FYTD Activity, MTD Activity and Current Fund Balance. | |
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 revenue by fund and 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 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 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
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.