Child pages
  • SSDT Template Reports
Skip to end of metadata
Go to start of metadata

Template SSDT Reports

SSDT has provided several template reports (listed above).  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 The list of SSDT created reports will continue growing as we add more template report definitions.  A downloadable crosswalk of the Template Reports and their Classic Counterpart is available here.

SSDT Template Report Name

Classic Report Comparison

Definition

1099 Vendor ReportN/AProduces a report of 1099 vendor information. Allows you to filter on a YTD total and specific 1099 Type(s).
AR Billing DetailN/AProduces a detailed listing of Billing items.
AR Billing SummaryN/AProduces a summary report of Billing items.
AR Detail ReportARDETLDetail listing of all billings and payments for various types of invoices.
AR Transaction SummaryARTRANReport listing the total billing and/or payment amounts for various types of invoices for one or more customer.

Account Change

ACTCHGProduces a report of account changes made via the Account Change option under Utilities.
Account ValidationVALACTProduces a report of invalid accounts with an explanation of why they are invalid.
Anticipated Revenue TransactionsN/AProduces a report, sorted in account code order, containing the budget modifications made to revenue accounts. 
Appropriated Amounts by Cash AccountN/ASummary report by FUND-SCC containing appropriated amounts.
Appropriation Expense WorksheetAPPWRKSummary report for appropriation accounts.  Similar to the Appropriation Summary but this report also includes three prior years expended amounts.
Appropriation HistoryAPPHISProduces 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 SummaryAPPSUMProduces 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 AccountAPPR_RCVBL
APPCOM

Produces a report displaying the initial cash, prior year encumbrances, FYTD receivable, FYTD appropriated and FYTD received by cash account.

Audit TrailAUDITSProduces an 'audit trail' report when adding, deleting, or making modifications while using the programs in USAS-R.
Auditable EventsN/ARecords any audit-able events that occurred in the software.  For example, the requisition approval status installation. 
Budget Account ActivityBUDLED

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 WorksheetBUDWRKSummary report for budget accounts.  Similar to the Budget Summary but this report also includes three prior years expended amounts.
Budget HistoryBUDHISProduces 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 SummaryBUDSUMProduces 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 MOEMONTHLYCD's BUDSUMMOEProduces a budget summary report containing the accounts involved in the Maintenance of Effort.
Budget TransactionsN/AProduces a report, sorted in account code order, containing the budget modifications made to expenditure accounts.  
Budget Transactions Summarized by AppropriationRECAPPProduces a report, sorted in account code order, containing the budget modifications summarized at the appropriation account level.
Cash Account HistoryN/AProduces 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 DetailN/AProduces 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 SummaryFINSUMMProduces 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 - BudgetCHARTChart of accounts displaying each budget account and its corresponding description.
Chart of Accounts - RevenueCHARTChart of accounts displaying each revenue account and its corresponding description.
Civil ProceedingsUSAEMSEDT's CVLPRCProduces a report of any law suits pending against the district during the reporting period. 
Classic Carry Over ReconciliationN/AProduces a report of adjustments made while importing carryover encumbrances from Classic to  Redesign.
Disbursement DetailDetailed CHEKPYProduces a detailed listing of disbursements which have been processed.
Disbursement SummarySummary CHEKPYProduces a summary listing of disbursements (checks) which have been processed.
District Building InformationUSAEMSDB's BLDRPTProduces a report of the data entered under the Periodic's Building Profile option.
Error Corrections and Supplies DistributionsRECCOR, RECDISProduces a report of the data entered in Distributions/Error Corrections.
Federal Assistance DetailUSAEMSEDT's FEDDETProduces a report of the information entered in the Federal Assistance Detail program.
Federal Assistance SummaryUSAEMSEDT's FEDSUMProduces a report of the information entered in the Federal Assistance Summary program.
Financial Budget ReportBUDSELProduces a summarized budget report by cash account. It sorts by FUND/SCC, then function level and then the rest of the account code.
Financial DetailFINDET

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 BalancesFINDET (include July 1st cash balance)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 PeriodFINDET (includes period beginning and ending 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 beginning and ending cash balances but will only generate for the current period.
Financial Report by Forecast Line NumberUSASFFProduces 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 LedgerRECLED's RECTRNProduces a report containing fund to fund transfer and fund to fund advance transactions, sorted by date.
Impact on EncumbranceN/AHelpful in determining the transactions that make up the adjusting entries on the SSDT Classic Carryover Reconciliation report.  
Inventory Pending ExtractN/AExtract invoice data needed for the EIS pending file in Classic.
Listing of Transactions by AccountACTRPT

Produces a report listing accounts in numerical order including detailed expenditure and receipt transactions.

Monthly BalanceBALMONProduces a report of ending monthly cash balance for one, several or all funds for a particular month(s) or fiscal year(s).
Negative Appropriation AccountNEGAPPProduces a report displaying appropriation accounts that have a FYTD unencumbered balance less than zero.
Negative Budget AccountNEGBUDProduces a report displaying budget accounts that have a FYTD unencumbered balance less than zero.
OPU ListingOPULSTProduces a report of operational units.
Outstanding Disbursement SummaryN/AProduces a report of outstanding disbursements based on the current period.
Outstanding Invoices by Vendor NameOutstanding INVLSTProduces a report of used of outstanding invoices, default sorting by vendor name. 
Outstanding Purchase OrdersN/AProduces a report of the outstanding purchase orders based on the current period.
SSDT Post Import Closed Purchase Orders with Remaining BalanceN/AProduces 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 BalanceN/AProduces a report of purchase orders that are Invoiceable but do not have a remaining balance.
Post Import Vendor ReportN/AProduces a report of vendors that did not import fully due to invalid data in classic.
Purchase Order DetailPODETLProduces a detailed purchase order report containing information on individual purchase order items.
Purchase Order SummaryPOSUMMProduces a report summarizing purchase order transactions.
RAM ExportN/AProduces a CSV file of extracted non-converted requisitions in order to upload into RAM.
RAM Export UpdatedN/A

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 LedgerRECLEDProduces a report of receipt transactions by cash account, sorted by date.
Receipt ListingRECLSTProduces a report of receipt items by date.
Reduction of Expenditure LedgerRECLED's RECEXPProduces a report of reduction of expenditure transactions by cash account, sorted by date.
Refund Ledger

RECLED's

RECREF

Produces a report of refund items by cash account, sorted by transaction date.
Requisition DetailREQDETProduces a detailed requisition report containing information on individual requisition items.
Requisition SummaryREQSUMProduces a report summarizing requisition transactions.
Revenue Account ActivityREVLEDProduces a detailed report of the transactions that make up the amounts in the revenue accounts.  The report includes receivable and receipt data.
Revenue Account HistoryREVHISProduces 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 Expense WorksheetREVWRKSummary report for revenue accounts.  Similar to the Revenue Summary but this report also includes three prior years received amounts.
Revenue SummaryREVSUMProduces 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.
Spending Plan ComparisonSM12's SM2CMPGenerates a report in Five Year Forecast format comparing the estimated figures with the actual figures.
Spending Plan MonthlySM12's SM2MONGenerates a report in Five-Year Forecast format listing each monthly actual amount for each line number and a FYTD total. 
Spending Plan SummarySM12's SM2MGenerate 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 FundFNDCASH

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

Summary of Expenditures by FundFNDEXP

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 FundFNDREV

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 BudgetsTBUDGETProduces a Title Budget Report that compares current encumbrances and FYTD Expenditures with prior year's expenditures.
Transaction Ledger - Vendor ActivityTRNLEDProduces a transaction ledger report sorted by vendor activity.
Transfer Advance ActivityN/AProduces a report of all transfer and advance transactions by cash account. Includes repay advance transactions.
Transfer Advance SummaryTRANADVProduces a report of transfers and advances.
USAS Auditor Extract - AccountUSASAUD's ACCTAUD

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 - TransactionUSASAUD's TRANAUDExtracts 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 - VendorUSASAUD's VENAUDExtracts 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 ListingVENLSTProduces report of vendors in alphabetical order with PO address, phone number, ID and YTD amount.
Vendor MasterVENSSNProduces a report of vendors in alphabetical order with PO address, ID, 1099 Type and YTD amount.
Void Refund LedgerRECLED's RECVODProduces 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.

Classic Comparison: ARDETL

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.

Classic Comparson: ARTRAN

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.

Classic Comparison: VALACT


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

Classic Comparison: APPWRK

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

Classic Comparison: APPHIS


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.

Classic Comparison: APPSUM

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.

Classic Comparison: APPR_RCVBL, APPCOM

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

Classic Comparison: AUDITS



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.

Classic Comparison: BUDLED

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:


Snapshot of Report in Excel-Data 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.

Classic Comparison: BUDWRK

Snapshot of Report in PDF 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.

Classic Comparison: BUDHIS



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.

Classic Comparison: BUDSUM

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.

Classic Comparison: MONTHLYCD's BUDSUMMOE report



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.

Classic Comparison: RECAPP

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.

Classic Comparison: FINSUMM



Chart of Accounts - Budget

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

Classic Comparison: CHART



Chart of Accounts - Revenue

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

Classic Comparison: CHART



Civil Proceedings

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

Classic Comparison: USAEMSEDT's CVLPRC



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.

Classic Comparison: Detailed CHEKPY

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.

Classic Comparison: CHEKPY

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.

Classic Comparison: USAEMSDB's District Building Profile report



Error Corrections and Supplies Distributions

A report summarizing transactions entered in Distributions/Error Corrections.

Classic Comparison: RECCOR, RECDIS



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. 

Classic Comparison: USAEMSEDT's Federal Assistance Detail (FEDDET) report


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.

Classic Comparison: USAEMSEDT's Federal Assistance Summary (FEDSUM) report


Financial Budget Report

Summary report of budget account data.  Sorted by FUND/SCC, then FUNCTION and then the rest of the account.

Classic Comparison: BUDSEL

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

Classic Comparison: FINDET

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.

Classic Comparison: FINDET

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.

Classic Comparison: FINDET

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.

Classic Comparison: USASFF

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.

Classic Comparison: RECLED's Fund-to-Fund Transfer Option

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.

Classic Comparison: N/A



Inventory Pending Extract

The Redesign does not have an equipment inventory system available yet so the Redesign has to extract existing invoice data that can then 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.   

(tick) 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.

The reference number of the disbursement is included on the extract.  Currently, the check number is not included because it could be duplicated if a district has multiple bank accounts set up.

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.

Classic Comparison: ACTRPT

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).

Classic Comparison: BALMON

Snapshot of Report in PDF Format:



Negative Appropriation Account

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

Classic Comparison: NEGAPP

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.

Classic Comparison: NEGBUD

Snapshot of Report in PDF Format:


OPU Listing

A report of operational units.

Classic Comparison: OPULST

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. 

Before running this report, temporarily change your current period to the period you want disbursement amounts reflected in and you can leave the parameters empty when generating the report. 




Outstanding Invoices by Vendor Name

Report of outstanding invoices, default sorting by vendor name.

Classic Comparison: INVLST

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. 

Before running this report, temporarily change your current period to the period you want encumbrances reflected in and you can leave the parameters empty when generating the report.  One of the filters hard-coded in the report will search for any POs with a remaining encumbrance not equal to 0 for the current period...so basically it will look for all outstanding purchase orders as of the end of the current period you have selected.



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

Classic Comparison: PODETL

NOTE:

An outstanding PODETL in Classic will not match the Redesign's Purchase Order Detail report run with "invoiceable = true".  This is because Classic's definition of outstanding includes POs with a status of new, partially filled, partially paid and completely filled.  The Redesign did not carry forward these statuses.  The Redesign report will not include any POs that are completely filled, only those POs that are still able to be invoiced (invoiceable = true). In order to get the same results as the Classic PODETL for outstanding POs in a particular month, you have to run 2 reports in redesign.  Along with the outstanding PO detail report you have to look at all payables associated with that month's POs.

Snapshot of Report in PDF Format:


Purchase Order Summary

Report summarizing purchase order transactions.

Classic Comparison: POSUMM

NOTE:

An outstanding POSUMM in Classic will not match the Redesign's Purchase Order Summary report run with "invoiceable = true".  This is because Classic's definition of outstanding includes POs with a status of new, partially filled, partially paid and completely filled.  The Redesign did not carry forward these statuses.  The Redesign report will not include any POs that are completely filled, only those POs that are still able to be invoiced (invoiceable = true). In order to get the same results as the Classic POSUMM for outstanding POs in a particular month, you have to run 2 reports in redesign.  Along with the outstanding PO summary report you have to look at all payables associated with that month's POs.


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.

Classic Comparison: RECLED's Receipt option A

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).

Classic Comparison: RECLST

Snapshot of Report in PDF Format:


Reduction of Expenditure Ledger

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

Classic Comparison: RECLED's Reduction of Expenditure option

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.

Classic Comparison: RECLED's Refund option

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.

Classic Comparison: REQDET



Requisition Summary

Report summarizing requisition transactions.

Classic Comparison: REQSUM

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.

Classic Comparison: REVLED

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.

Classic Comparison: REVHIS


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.

Classic Comparison: REVSUM

Snapshot of Report in EXCEL Format:



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.

Classic Comparison: REVWRK

Snapshot of Report in PDF format:




Spending Plan Comparison

The Spending Plan Comparison will generate a report comparing the estimated figures with the actual figures. 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. total for The total for the estimate figures will show on lines 1.070, 2.070, 2.080 and 4.500.

Classic Comparison: SM12's SM2CMP


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. 

Classic Comparison: SM12's SM2MON


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. 

The query parameters displayed require entries to be made. 

The FYTD totals on the report will be determined by the 'Fiscal Year' entered. The MTD totals on the report will be determined by the month or range of months entered.


Classic Comparison: SM12's SM2M


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.

Classic Comparison: FNDCASH

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.  

Classic Comparison: FNDEXP

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.

Classic Comparison: TBUDGET

Snapshot of Report in PDF Format:



Transaction Ledger - Vendor Activity

Transaction ledger report sorted by vendor activity.

Classic Comparison: TRNLED

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 repay transactions

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.

Classic Comparison: TRANADV

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)

Classic Comparison: USASAUD's ACCTAUD



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)

Classic Comparison: USASAUD's TRANAUD



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)

Classic Comparison: USASAUD's VENAUD



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.

Classic Comparison: VENLST

Snapshot of Report in PDF Format:



Vendor Master

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

Classic Comparison: VENSSN

Snapshot of Report in CSV Format:


Void Refund Ledger

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

Classic Comparison: RECLED's Void Refund of Receipts option


  • No labels