Child pages
  • Report Manager
Skip to end of metadata
Go to start of metadata

Report Manager Grid

Predefined SSDT template report definitions as well as user-created reports are displayed under Report Manager. A template report is basically a 'starter' report available for you to generate as is or customize to your specifications.  Previously saved report definitions may be generated, viewed, renamed, deleted, downloaded and shared with specific roles.  The SSDT template reports may be generated, viewed and downloaded only.  However, when a user views a SSDT template report definition, it will take them to the 'Custom Report Creator' option where they can edit the report options, allowing them to save the edited report definitions, enter filters and save it under a new report name.  Their username will be tied to the newly created report.  Listed below is the Report Manager grid with some of the SSDT's available template reports.  Please click on SSDT Template Reports for a complete listing of all available template reports. 

Generate and Download Report

Automatically generates the report as is, allowing you to save or recall desired report settings, select the format, orientation, and name of the report before it is generated.

  1. From the Report menu, select 'Report Manager'.
  2. Click on beside the desired report. This is the 'Generate and Download Report' option which automatically generates the report as is, allowing you to save or recall desired report settings, select the format, orientation, name of the report and query parameters before it is generated. (Please see 'Query Parameters section for more details).
    1. Save and Recall options: 
      1. Most Recent: By default, it will remember the entries you made from your previous report run.
      2. Default: If you want to select the 'default' settings of the report, select 'default' from the drop down menu. 
      3. To Save current report settings (in order to be used again), select the blank option and enter a save name.  Once you tab off the field, the 'save' icon will be active.  Click on  to save your report and parameter settings.  Your saved report name will now be included in the 'save and recall' drop down menu.  To delete an existing saved report, select the saved report and click on .

         

Open Report Definition in Detail Report View

Opens a template or existing custom report definition details in order for you to see all of the options chosen for the report.  You can then modify it by adding, changing or deleting properties or filters so you get the report you want.  Save the changes you made under a new report name in order to create a custome report.  You can then regenerate the new report as needed.

  1. From the Report Menu select 'Report Manager'
  2. Click on beside the desired report to make any changes.  To save the changes under a new report name, enter a report name in the 'Save As' box and click on .

  3. Click on 'Report Manager' and your report will be displayed in the Report Manager grid.

Step-by-Step Instructions on how to create a custom report from a template report can be found in the Appendix.

Edit Report Name, Description and Tags

Click on any report you created in order to rename it, edit the description of the report or the edit the tag names associated with the report.

  1. From the Report Menu, select 'Report Manager' 
  2. Click on to edit the name, description or tag of the report you created.  
  3. Your report will be found in the 'Home menu' and in 'Report Manager'.

Tags

The "Tag" is a field you can use to categorize your reports.  You can enter as many values as you want, just separate them by commas; see example below.  

You can easily filter the report manager grid by a tag to limit the grid to help you find the reports you're looking for faster.

Delete Saved Report

Allows you to delete the report definition you created.

  1. From the Report Menu select 'Report Manager'
  2. Click on beside the desired report
  3. The user will be given a confirmation box to confirm the deletion. 

Download Report Definition

Allows you to  download the report definition to your computer so it can be sent to others via email where they can then import it into the Report-Detail to be generated as well as save the report to show in their 'Report Manager' grid.

  1. From the Report Menu select 'Report Manager'
  2. Click on  beside the desired report
  3. Save the report on your computer.  Enter a filename but leave the 'save as type' in .RPD-JSON format.
  4. Email it as an attachment.

Share Saved Report via a Role 

Allows you to share a saved report definition with users who have a specific role.  For example, if you create a Budget Summary Report for grant accounts and want to share the report with your building principals (who all have an existing role called "Principals"), you will select the 'Principal" role in this option and your report will be displayed under each of the principal's Report Manager.

  1. From the Report Menu select 'Report Manager'
  2. Click on beside the desired report. A window will open listing all the Roles currently on the user's system
  3. Check beside the desired Roles to grant access to this saved report.
  4. Click on to save the change and click on to return to the Report Manager grid and not assign the report to a role.
    1. Any user with the checked Role will now see the report in their 'Report Manager'.

Favorite

If you use a report frequently, checkmark the box in the 'Favorite' column. When you log into USAS-R, it displays your "Favorites" on your home page so you can quickly and easily access them

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 printable crosswalk of the Template Reports and their Classic Counterpart is available here.

SSDT Template Report Name

Classic Report Comparison

Definition

Account Change RequestACTCHGProduces 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.
Appropriation Expense WorksheetAPPWRKProdudes a report of current fiscal year amounts and is helpful in determining appropriations for the coming fiscal year.
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/A
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 WorksheetBUDWRK
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
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 acciunt 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 differences from importing carryover encumbrances from Classic and Redesign calculated carryover encumbrances.
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.
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 Report

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 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 Invoices by Vendor NameOutstanding INVLSTProduces a report of used of outstanding invoices, default sorting by vendor name. 
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.
Receipt LedgerRECLEDProduces a report of receipt transactions by cash account, sorted by date.
Receipt ListingRECLSTPrroduces 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 WorksheetREVWRK
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

Produces a summary of expenditures by fund and includes Fund, Description, FY Beginning Balance, FYTD Activity, MTD Activity and Current Fund Balance.

Summary of Expenditures by FundFNDEXPProduces a summary of revenue 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 FundFNDREVProduces a summary report for one, several, or all of the cash accounts. It includes the receivable amount, actual receipts, balance receivable, and FYTD percent received.
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 SummaryTRANADVProduces a report of transfers and advances.
USAS Auditor Extract - AccountUSASAUD's ACCTAUD

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

USAS Auditor Extract - TransactionUSASAUD's TRANAUDUSASAUD Tranaction 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.
USAS Auditor Extract - VendorUSASAUD's VENAUDUSASAUD 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.
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.

Account Change Report

Produces a report of account changes made via the Account Change option under Utilities.

Classic Comparison: N/A

Generate Report Options:

Snapshot of report in PDF format:



Account Validation Report

Listing of invalid accounts with an explanation of why the accounts are considered invalid.

Classic Comparison: VALACT

Generate Report Options:


Appropriation Expense Worksheet

Listing of appropriation accounts displaying current year amounts.

Classic Comparison: APPWRK

Generate Report Options:


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.

Classic Comparison: APPSUM

Generate Report options:

Snapshot of Report in CSV format:


Appropriations and Receivables by Cash

Displays the initial cash, prior year encumbrances, FYTD receivable, FYTD appropriated and FYTD received by cash account.

Classic Comparison: APPR_RCVBL

Generate Report Options:

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

Generate Report Options:


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

Generate Report Options:

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

Generate Report Options:

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

Generate Report Options:



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.

Classic Comparison: None

Generate Report Options:


Cash Account History Detail

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

Classic Comparison: None



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

Generate Report Options:


Chart of Accounts - Budget

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

Classic Comparison: CHART

Generate Report Options:


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

Generate Report Options:


Carry Over Reconciliation

Contains differences, if any,  from importing carryover encumbrances from Classic and Redesign calculated carryover encumbrances.  A one-time import report.

Classic Comparison: N/A



Disbursement Detail

Detailed listing of disbursements (checks) which have been processed.

Classic Comparison: Detailed CHEKPY

Generate Report Options:



Disbursement Summary

Listing of disbursements (checks) which have been processed.

Classic Comparison: CHEKPY

Generate Report Options:

  • Tips
    • To generate a report of 'all disbursements' within a specified date range, you must enter all statuses (O,R,V).  For example, if you want to see all checks for the month of November, enter 11/01/2018 - 11/30/2018 and statuses O,R,V and it will generate all disbursements issued during that time frame.
    • To generate a report of 'outstanding' checks, enter a status of O.
    • The 'Or Reconciled After Date' default to 'd' which means the disbursements that are reconciled after the end of the current period.  This parameter can be used in conjunction with the status parameter.  For example, if you want a listing of outstanding checks for November but you reconciled some in December, by leaving this parameter default to 'd', those December checks will appear on the November report because they were outstanding in November.

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

Generate Report Options:



Federal Assistance Detail Report

The report details the FUND/SCC and amounts that make up the federal program monies for the fiscal year reported.  

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

Generate Report 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.

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

Generate Report Options:


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

Generate Report Options:

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.

Classic Comparison: FINDET

Generate Report Options:

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

Generate Report Options:

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

Generate Report Options:

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

Generate Report Options:


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 will contain an import option allowing the user to import the data into the existing pending file in classic's EIS system.

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

Classic Comparison: N/A

General Report Options:

Snapshot of report in CSV format:




Listing of Transactions by Accounts Report

Listing of accounts in numerical order including detailed expenditure and receipt transactions.

Classic Comparison: ACTRPT

Generate Report Options:

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

Generate Report Options:


Negative Appropriation Account

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

Classic Comparison: NEGAPP

Generate Report Options:

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

Classic Comparison: NEGBUD

Generate Report Options:

Snapshot of Report in EXCEL Format:


OPU Listing

A report of operational units.

Classic Comparison: OPULST

Generate Report Options:

Snapshot of Report in PDF Format:


Outstanding Invoices by Vendor Name

Report of outstanding invoices, default sorting by vendor name.

Classic Comparison: INVLST

Generate Report Options:

Snapshot of Report in PDF Format:


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.


Generate Report Options:

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.


Generate Report Options:

Snapshot of Report in PDF Format:


Receipt Ledger

Receipt transactions by cash account, sorted by date.

Classic Comparison: RECLED's Receipt option

Generate Report Options:

Snapshot of Report in PDF Format:


Receipt Listing

A report of receipt items by date.

Classic Comparison: RECLST

Generate Report Options:

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

Generate Report Options:

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

Generate Report Options:

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

Generate Report Options:



Requisition Summary

Report summarizing requisition transactions.

Classic Comparison: REQSUM

Generate Report Options:

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

Generate Report Options:

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

Generate Report Options:

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

Classic Comparison: SM12's SM2CMP

Generate Report Options:


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

Generate Report Options:


Spending Plan Summary

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

Classic Comparison: SM12's SM2M

Generate Report Options:



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.

Classic Comparison: FNDCASH

Generate Report Options:

Snapshot of Report in PDF Format:


Summary of Expenitures by Fund

Summary of cash by fund and includes Fund, Description, FYTD Expendable, FYTD Expended, MTD Expended, Fiscal Year Encumbrances, FYTD Remaining Balance and FYTD Percent Expended

Classic Comparison: FNDEXP

Generate Report Options:

Snapshot of Report in PDF Format:



Summary of Revenues by Fund

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

Classic Comparison: FNDREV

Generate Report Options:

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

Generate Report Options:

Snapshot of Report in PDF Format:



Transaction Ledger - Vendor Activity

Transaction ledger report sorted by vendor activity.

Classic Comparison: TRNLED

Generate Report Options:

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:


USAS Auditor Extract - Account

USASAUD 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

Classic Comparison: USASAUD's ACCTAUD

Generate Report Options:




USAS Auditor Extract - Transaction

USASAUD 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

Classic Comparison: USASAUD's TRANAUD

Generate Report Options:



USAS Auditor Extract - Vendor

USASAUD 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

Classic Comparison: USASAUD's VENAUD

Generate Report Options:

Transfer Advance Summary

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

Classic Comparison: TRANADV

Generate Report Options:


Vendor Listing

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

Classic Comparison: VENLST

Generate Report Options:

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

Generate Report Options:

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

Generate Report Options:


Query Parameters options included on SSDT Template Reports

When generating a report, the 'Generate Report' box contains a section called "Query Parameters' allowing the user to enter one or more parameters to filter their reports on. Each template report offers different query parameters.  The following query parameters are available:

Query ParameterDefinition
1099 Types

Enter one or more of the following types to include on the report; separate multiple types with a comma

Types include:

Non 1099, Non Employee Compensation, Rents, Other Income, Medical and Health Payments, Royalty Payments, Attorney Gross Proceeds

Account(s)

Enter the full account on the report.

Example: PO Detail report, enter the full budget account (001-2510-640-0000-000000-300-00-000)

Active only (True/False)'T' or 'True' to include only active account; 'F' or 'False' to include both active and inactive
Amended only (true/false)'T' or 'True' to include only amended Purchase Orders; "F' or 'False' to exclude amended Purchase Orders;
Converted (true/false)'T' or 'True' to include requisitions converted to a purchcase order; 'F' or 'False' to include only outstanding requisitions
Created Start/End Date

Enter a starting and/or ending date the transaction was posted to the system;

Examples: 010118, 01012018,01/01/2018, 1/1/18,

Example: 'm' for first day of current period and 'h' for last day of current period

Example: 'f' for first day of fiscal year and 'l' for last day of fiscal year

Example: 't' for today

Created Users(s)Enter the username(s) of who created the requisition. Use a comma to enter more than one username
Default Payment Types

Enter the vendor's default payment type. Choose between 'check' or 'electronic'.

Exclude Full Account Code(s)Must enter the full account code you want to exclude; can't use partial codes or wildcards (%)
Fiscal Year(s)Fiscal year data to include on the report. Use a comma to enter more than one FY; leave blank to include all FYs
Full Account Code(s)

Must enter the full account code; can't use partial codes or wildcards (%)

Cash Example: 006-0000

Appropriation Example: 006-3100-500-0000

Budget Example: 006-3120-560-0000-000000-000-00-000

Revenue Example: 006-1511-0000-000000-000

Fund

Func

Rcpt

Obj

SCC

Subj

OPU

IL

Job

Enter the account code dimension to include on the report

  • use a comma to select more than one fund Example: 200,300
  • use % for a wildcard Example: 5%2
  • leave blank to include all funds
Invoiceable (true/false)True or 'T' to include transactions that are invoiceable; Enter false or 'F' to include transactions that aren't invoiceable; leave blank to include both
Start Date/End Date

Enter a starting and/or ending date

Examples: 010118, 01012018,01/01/2018, 1/1/18,

Example: 'm' for first day of current period and 'h' for last day of current period

Example: 'f' for first day of fiscal year and 'l' for last day of fiscal year

Example: 't' for today

Starting/Ending Transaction #Enter a beginning and/or ending transaction number albeit a check, purchase order, requisition, etc.
Status(es): Outstanding, Reconciled or VoidEnter the full status name or first letter of the status to include on the report; use a comma to select more than one status
Type(s): Accounts Payable, Refund or Payroll,Enter the full name of the 'type(s)' to include on the report; use a comma to select more than one type
Username(s)Enter system username to filter specific user's transactions
Vendor Default Payment Type(s)Enter 'Check' or 'Electronic' to select type of vendor to include on report; leave blank to include both types
Vendor #(s)Enter the vendor number(s) to include on the report; use a comma to enter more than one vendor number.
YTD Total greater thanEnter an amount to generate a report with Year-to-Date amounts greater than what is entered
  • No labels