Child pages
  • Report Manager

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

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

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 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.
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 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.
User Listing Report
Produces a report of all user accounts. Can be filtered to exclude Roles or show only enabled/disabled users.
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.

...

Snapshot of Report in Excel Format:

...

Anchor
tranadvact
tranadvact
Transfer Advance Activity

A listing of all transfer and advance transactions by cash account. Includes repay transactions

Snapshot of PDF Format:

Image Added

Anchor
tranadv
tranadv
Transfer Advance Summary

...