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, tagged, deleted, downloaded and shared with specific roles. The SSDT template reports may be generated, tagged, 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.

The Create Forms option allows the user to create alternate versions of forms like Direct Deposit Notices or Payroll Checks, they can add their own "Form" and then the dropdown will show these. The "how" of setting this up is in the works in the future.

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.

From the Report menu, select 'Report Manager'.
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 .
2. Report Direct Link:
  1. The Show Report Link icon will become available for any report parameters saved via the Save and Recall option. The icon will open a window containing a direct hyperlink to execute the report. The link may be bookmarked, sent via email, placed on a web page, etc.
  2. Include Parameters?: This checkbox can be used to include all of the current parameters in the report link. When used, the report link will always use the original saved parameters. If this is not checked, the report link data will be run with the currently saved parameters for the Save and Recall name. If the saved parameters are changed and saved, the changes will affect future invocations of the link.
  3. The Report Direct Link can also be used in Excel as a Web Query (Get Data from Web) to pull data directly from the application without downloading the output. In this case, one of the HTML (Table or FieldName) output formats should be selected. When used in Excel, these output formats can be understood and formatted as a sheet. A web query in Excel this way can also be refreshed on demand.
  4. A username is required to access the report via direct link.
  5. The report direct link can be shared with other users. Each user will be required to login with their USAS-R credentials when the report link is accessed.
3. Summary Report will generate a summary version of the current report. The summary will include any property designated as a Control Break or a Control Header and the related total and subtotal amounts.
4. Show Report Options includes a printout of the report options selected for the report run. This option applies for PDF format only.
5. Job Scheduler icon
  1. Allows you to schedule a report to run as a background or periodic job and automatically emailed to specified person. Please click here for further details on how to schedule a report run based on a cron expression.

Report Generation Options and Dynamic Sort

The Report Generation Options are split into three separate tabs - Report Options, Query Options, and Sort Options. These options can be updated when generating report to define format, filters, sort and subtotals on the report. Information entered and/or updated in all three tabs will be saved in the 'Most Recent' Save and Recall and can be saved when creating a custom Save and Recalls. Users can navigate through these three tabs by clicking the tab names across the top or by using the left and right arrows below the options.

Report Options - These report options define the general format settings and the title on the report. These will be standard for all template reports
1. Format - Defines the output type of the Report generated
  1. PDF
  2. Comma Separated Values (CSV)
  3. Tab Separated Values
  4. Excel - Includes fonts and formatting
  5. View(html) - View report in a web page
  6. HTML-Table - Most commonly used with Report link option. Will display data in a simple table on a web page
  7. HTML-Fieldnames - Can also be used with Report link option. Will display data in a simple table on a web page and where the headers include field names that can be used for importing data back into Redesign.
  8. Plain Text
  9. Jasper Report Design
  10. Excel-Data - Standard Excel spreadsheet of information. Summary Report and Control break options will not be included in this format type
  11. Excel-Fieldnames - Standard Excel spreadsheet of information where the headers include field names that can be used for importing data back into Redesign. Summary Report and Control break options will not be included in this format type
2. Page Size - When generating options for print, like PDF, this will determine the size of the page used in the output file. Options include standard Page sizes like Letter or Legal.
3. Orientation - Select page orientation as Portrait or Landscape for the report.
4. Name - The entered text will will appear as the Title at the top of each page of the report.
5. Summary Report will generate a summary version of the current report. The summary will include any property designated as a Control Break or a Control Header and the related total and subtotal amounts.
6. Show Report Options includes a printout of the report options selected for the report run. This option applies for PDF format only.
Query Options - The Query Options determine how to filter the information that will be included on the report. The Query Parameters vary by report and can be customized by modifying the Report Template.
Sort Options - The Sort Options will determine how the information in the report is sorted, subtotaled, and if there will be page breaks.
1. Sortable Properties - Any Properties that are included in the report definition would be available to use as a Sortable Property (see the Select Properties section of the Custom Report Creator page for information). These include fields that would appear as the report columns along with any additional properties that are suppressed. In order to choose properties to sort on, users can click and drag the property to the 'Select Properties' box on the Sort Options. To move multiple Sortable Properties at once, click the check box in front of each property then click and drag the properties together. When dragging and dropping properties into the list of Selected Properties, the property being added can be placed anywhere within the list. Once properties are added to the Selected Properties they cannot be reordered. Instead, remove the property then re-add. When re-adding the property, place it in the desired order within the list.
2. Selected Properties - The properties showing in this section will determine the order in which the report will be sorted. The property listed highest in the list will determine the first sort priority. By default, the report will show the Selected properties based on the Sort Priority order defined on the report definition.
  1. Ascending - When checked the sort on this property will display in Ascending order - from smallest to largest for numerical fields and A to Z for alphabetical fields. If the box is unchecked, the sort on this property will be displayed in Descending order - from largest to smallest for numerical fields and Z to A for alphabetical fields.
  2. Control Break - When checked for a property, the property will be bolded and included as a report sub header each time that property changes. This will also add subtotals each time the property changes for any numerical fields that are configured with the Sum Function.
  3. Page Break- When checked for a property, the report will advance to a new page each time the property changes.

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.

From the Report Menu select 'Report Manager'
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 .
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.

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

Delete Saved Report

Allows you to delete the report definition you created.

From the Report Menu select 'Report Manager'
Click on beside the desired report
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.

From the Report Menu select 'Report Manager'
Click on beside the desired report
Save the report on your computer. Enter a filename but leave the 'save as type' in .RPD-JSON format.
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.

From the Report Menu select 'Report Manager'
Click on beside the desired report. A window will open listing all the Roles currently on the user's system
Check beside the desired Roles to grant access to this saved report.
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

Scheduling a Report to Run via a Cron Job

To schedule a template or custom report to run for a specific day and/or time, the job scheduler icon can be used in the 'Generate Report' window. This is a one-time setup which will then generate the report based on the cron expression and automatically email it to a specified recipient. You can use a free online cron expression generator to generate your cron expression.

Example: Generate a Financial Summary report for the cafeteria fund to be emailed to the Cafeteria manager every Monday morning.

Click to open the Generate Report window for the Cash Summary Report
Enter the desired parameters. For our example, enter 006-0000 in the 'FUND-SCC' parameter.
Click on the job scheduler icon which will open the Schedule Report window
1. Job Name: Defaults to what is displayed in the 'Name' parameter. You can overwrite the default job name.
  
  The Job Name must be unique for each scheduled cron job. For example, if I'm creating several Cash Summary reports, each one based on a different FUND-SCC, the Job Name cannot be the same for each Cash Summary report. If I create separate Cash Summary reports for the Cafeteria Manager and Band Director, the Job Name for the Cafeteria Manager may be 'Cash Summary Report - Cafeteria' and the Job Name for the Band Directory may be 'Cash Summary Report - Band'.
2. Cron Expression: is a command set up to run periodically at fixed times, dates, or intervals. Cron Expressions can be set up by using a free online cron expression generator (see links below). Here is an example of a Cron expression to be run every Monday at 7:00 AM
  1. https://www.freeformatter.com/cron-expression-generator-quartz.html
  2. http://www.cronmaker.com/
3. Send Output to: enter the email of the intended recipient; you can enter multiple email addresses by separating each with a comma.
A pop-up message will briefly appear stating the job has been created. Cancel or 'x' out of the 'Generate Report' window.
The job is stored under UTILITIES/Job Scheduler. It will be displayed here until the job completes (if there is an end time specified in the cron expression) or if the job is deleted using .

In order to use the Cron job you must have the Email Notification Services Module installed System/Modules. Once it is installed the Email Configuration must be completed, System/Configuration. If you are unsure of what to enter in the configuration please consult your IT dept.

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 Parameter	Definition
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
Exclude Accounts with Zero Amounts? (true/false)	'T' or 'True to include only accounts where all relevant MTD, YTD, and FYTD amounts are zero; 'F' or 'False' to include only accounts where all relevant MTD, YTD, and FYTD amounts are not zero. This parameter is included on the Cash Account Summary, Budget Account Summary, Appropriation Account Summary, Revenue Account Summary template reports.
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 (%)
Filter Name	Enter a filter name (what was created in Utilities/Account Filters). The filter name is case sensitive.
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
Total As of Period (If a date is specified FYTD, MTD and Encumbrance amounts will be calculated as of that period)	Enter a date (mm/dd/yyyy) you would like to run the report for for a certain posting period. NOTE: This parameter is relevant to account based reports. The as of period parameter will return amounts as of a specific period (ex. FYTD or MTD totals), but will not limit transactions on accounts. If using with a report that is transaction based, this parameter will need to be used in combination with Start and Stop dates to filter the transactions that are included.
Start Date/End Date	Enter a starting and/or ending date Click here for complete list of date shortcuts. Examples: 010118, 01012018,01/01/2018, 1/1/18 Example: 'm' for first day of current month and 'h' for last day of current month Example: 'p' for first day of current period and 'd' 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 Void	Enter 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 than	Enter an amount to generate a report with Year-to-Date amounts greater than what is entered

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 Report	N/A	Produces a report of 1099 vendor information. Allows you to filter on a YTD total and specific 1099 Type(s).
Account Change	ACTCHG	Produces a report of account changes made via the Account Change option under Utilities.
Account Validation	VALACT	Produces a report of invalid accounts with an explanation of why they are invalid.
Anticipated Revenue Transactions	N/A	Produces a report, sorted in account code order, containing the budget modifications made to revenue accounts.
Appropriated Amounts by Cash Account	N/A	Summary report by FUND-SCC containing appropriated amounts.
Appropriation Expense Worksheet	APPWRK	Summary report for appropriation accounts. Similar to the Appropriation Summary but this report also includes three prior years expended amounts.
Appropriation Summary	APPSUM	Produces a summary report for one, several, or all of the appropriation accounts. It includes the expendable amount, actual expenditures, current encumbrances, unencumbered balance, and percentage expended/encumbered.
Appropriations and Receivables by Cash Account	APPR_RCVBL	Produces a report displaying the initial cash, prior year encumbrances, FYTD receivable, FYTD appropriated and FYTD received by cash account.
Audit Trail	AUDITS	Produces an 'audit trail' report when adding, deleting, or making modifications while using the programs in USAS-R.
Auditable Events	N/A	Records any audit-able events that occurred in the software. For example, the requisition approval status installation.
Budget Account Activity	BUDLED	Produces a detailed report of the transactions that make up the amounts in the budget accounts. The report includes expendable and expended data.
Budget Expense Worksheet	BUDWRK	Summary report for budget accounts. Similar to the Budget Summary but this report also includes three prior years expended amounts.
Budget Summary	BUDSUM	Produces a summary report for one, several, or all of the budget accounts. It includes the expendable amount, actual expenditures, current encumbrances, unencumbered balance, and percentage expended/encumbered.
Budget Summary MOE	MONTHLYCD's BUDSUMMOE	Produces a budget summary report containing the accounts involved in the Maintenance of Effort.
Budget Transactions	N/A	Produces a report, sorted in account code order, containing the budget modifications made to expenditure accounts.
Budget Transactions Summarized by Appropriation	RECAPP	Produces a report, sorted in account code order, containing the budget modifications summarized at the appropriation account level.
Cash Account History	N/A	Produces a report of cash account history sorted by FUND-SCC. User enters fiscal year(s) and the report generated includes the FUND-SCC, description, beginning balance, FYTD expended and FYTD received.
Cash Account History Detail	N/A	Produces a report of cash account history detail sorted by FUND-SCC. User enters fiscal year(s) and the report generated includes FUND-SCC, Description, Month, Beginning Balance, Expended, Received and Ending Balance.
Cash Summary	FINSUMM	Produces a summary report for one, several, or all of the cash accounts. It includes the fund beginning balance, MTD and FTD expenditures and receipts, current fund balance, current encumbrances and the unencumbered fund balance.
Chart of Accounts - Budget	CHART	Chart of accounts displaying each budget account and its corresponding description.
Chart of Accounts - Revenue	CHART	Chart of accounts displaying each revenue account and its corresponding description.
Civil Proceedings	USAEMSEDT's CVLPRC	Produces a report of any law suits pending against the district during the reporting period.
Classic Carry Over Reconciliation	N/A	Produces a report of adjustments made while importing carryover encumbrances from Classic to Redesign.
Disbursement Detail	Detailed CHEKPY	Produces a detailed listing of disbursements which have been processed.
Disbursement Summary	Summary CHEKPY	Produces a summary listing of disbursements (checks) which have been processed.
District Building Information	USAEMSDB's BLDRPT	Produces a report of the data entered under the Periodic's Building Profile option.
Error Corrections and Supplies Distributions	RECCOR, RECDIS	Produces a report of the data entered in Distributions/Error Corrections.
Federal Assistance Detail	USAEMSEDT's FEDDET	Produces a report of the information entered in the Federal Assistance Detail program.
Federal Assistance Summary	USAEMSEDT's FEDSUM	Produces a report of the information entered in the Federal Assistance Summary program.
Financial Budget Report	BUDSEL	Produces a summarized budget report by cash account. It sorts by FUND/SCC, then function level and then the rest of the account code.
Financial Detail	FINDET	Produces a detailed report of the transactions that make up the amounts in the cash accounts. The report includes both receipt and expenditure data.
Financial Detail July 1st Cash Balances	FINDET (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 Period	FINDET (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 Number	USASFF	Produces a report containing the forecast line numbers and totals. The report will contain three prior year's actual values. It also includes the current FYTD expendable/receivable values as the first year estimate.
Fund to Fund Transfer Ledger	RECLED's RECTRN	Produces a report containing fund to fund transfer and fund to fund advance transactions, sorted by date.
Impact on Encumbrance	N/A	Helpful in determining the transactions that make up the adjusting entries on the SSDT Classic Carryover Reconciliation report.
Inventory Pending Extract	N/A	Extract invoice data needed for the EIS pending file in Classic.
Listing of Transactions by Account	ACTRPT	Produces a report listing accounts in numerical order including detailed expenditure and receipt transactions.
Monthly Balance	BALMON	Produces a report of ending monthly cash balance for one, several or all funds for a particular month(s) or fiscal year(s).
Negative Appropriation Account	NEGAPP	Produces a report displaying appropriation accounts that have a FYTD unencumbered balance less than zero.
Negative Budget Account	NEGBUD	Produces a report displaying budget accounts that have a FYTD unencumbered balance less than zero.
OPU Listing	OPULST	Produces a report of operational units.
Outstanding Disbursement Summary	N/A	Produces a report of outstanding disbursements based on the current period.
Outstanding Invoices by Vendor Name	Outstanding INVLST	Produces a report of used of outstanding invoices, default sorting by vendor name.
Outstanding Purchase Orders	N/A	Produces a report of the outstanding purchase orders based on the current period.
SSDT Post Import Closed Purchase Orders with Remaining Balance	N/A	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	N/A	Produces a report of purchase orders that are Invoiceable but do not have a remaining balance.
Post Import Vendor Report	N/A	Produces a report of vendors that did not import fully due to invalid data in classic.
Purchase Order Detail	PODETL	Produces a detailed purchase order report containing information on individual purchase order items.
Purchase Order Summary	POSUMM	Produces a report summarizing purchase order transactions.
RAM Export	N/A	Produces a CSV file of extracted non-converted requisitions in order to upload into RAM.
RAM Export Updated	N/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 Ledger	RECLED	Produces a report of receipt transactions by cash account, sorted by date.
Receipt Listing	RECLST	Produces a report of receipt items by date.
Reduction of Expenditure Ledger	RECLED's RECEXP	Produces 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 Detail	REQDET	Produces a detailed requisition report containing information on individual requisition items.
Requisition Summary	REQSUM	Produces a report summarizing requisition transactions.
Revenue Account Activity	REVLED	Produces a detailed report of the transactions that make up the amounts in the revenue accounts. The report includes receivable and receipt data.
Revenue Expense Worksheet	REVWRK	Summary report for revenue accounts. Similar to the Revenue Summary but this report also includes three prior years received amounts.
Revenue Summary	REVSUM	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.
Spending Plan Comparison	SM12's SM2CMP	Generates a report in Five Year Forecast format comparing the estimated figures with the actual figures.
Spending Plan Monthly	SM12's SM2MON	Generates a report in Five-Year Forecast format listing each monthly actual amount for each line number and a FYTD total.
Spending Plan Summary	SM12's SM2M	Generate a report in Five-Year Forecast format listing the current periods actual amount for each line number and a FYTD total.
Summary of Cash Balances by Fund	FNDCASH	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	FNDEXP	Summary of expenditures by fund and includes Fund, Description, FYTD Expendable, FYTD Expended, MTD Expended, Fiscal Year Encumbrances, FYTD Remaining Balance and FYTD Percent Expended
Summary of Revenues by Fund	FNDREV	Summary of revenue by fund and includes the FYTD receivable amount, FYTD actual receipts, MTD actual receipts, FTYD balance receivable, and FYTD percent receivable.
Title Budgets	TBUDGET	Produces a Title Budget Report that compares current encumbrances and FYTD Expenditures with prior year's expenditures.
Transaction Ledger - Vendor Activity	TRNLED	Produces a transaction ledger report sorted by vendor activity.
Transfer Advance Activity	N/A	Produces a report of all transfer and advance transactions by cash account. Includes repay advance transactions.
Transfer Advance Summary	TRANADV	Produces a report of transfers and advances.
USAS Auditor Extract - Account	USASAUD'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 - Transaction	USASAUD's TRANAUD	Extracts the Transaction data into a tab separated value format. This file is used by the State Auditor's Office to help in the auditing process.
USAS Auditor Extract - Vendor	USASAUD's VENAUD	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.
User Listing Report		Produces a report of all user accounts. Can be filtered to exclude Roles or show only enabled/disabled users.
Vendor Listing	VENLST	Produces report of vendors in alphabetical order with PO address, phone number, ID and YTD amount.
Vendor Master	VENSSN	Produces a report of vendors in alphabetical order with PO address, ID, 1099 Type and YTD amount.
Void Refund Ledger	RECLED's RECVOD	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:

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 accounts with an explanation of why the accounts are considered invalid. You may choose to exclude account with zero 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 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 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 and revenue 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.

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

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.

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.

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.

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.

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

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

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 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 and 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 and includes Fund, Description, FYTD Expendable, FYTD Expended, MTD Expended, Fiscal Year Encumbrances, FYTD 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 and 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 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 PDF 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

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

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

User Listing Report

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

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

Miscellaneous Information

Public USAS Reports Library

The Public USAS Reports Library contains USAS template reports created and shared by other users which can be downloaded and used in your local application. A link to the Public USAS Reports Library can be found under the Help menu in USAS-R.

The Public Shared USAS-R Reports Library contains downloadable rpd-json file definitions, a PDF example of each report, and a description of each report.

To download a .rpd-json file, click on the file name and save to your desktop or file. Once saved, you can then import this file into your Report Manger using the 'Import Report' option in the Report Manager.