Public Shared USAS Reports Library
Welcome to the SSDT shared reports library.
Contains USAS template report definitions created and shared by other users which can be downloaded and used in your local application. Click on the name of the .rpd-json file to download the definition. Each report definition contains an example (PDF) of what the report looks like once generated.
Search this documentation
Account-Based Reports
Title (downloadable rpd-json file) | Example | Description |
|---|---|---|
Sorts by full account code and monthly expenditures. Lists a budgets expenditures for each month in the calendar year | ||
Subtotal by Appropriation Account. Option to exclude accounts with all zero amounts. | ||
Subtotal by Object first digit. Ex. All 100s, 200s, 300s, etc. Can be used with Account Filter. Option to exclude accounts with all zero amounts. | ||
Budget Summary by Fund, Function, Object with Fund Choice.rpd-json | Subtotal by Cash Account, first 2 digits of function, first digit of object. The parameters allow for multiple funds rather than wildcard fund option. | |
Subtotal by Fund. Option to exclude accounts with all zero amounts. | ||
Subtotal by Fund-SCC. Similar to standard Budget Summary.Option to exclude accounts with all zero amounts. | ||
Subtotal by Object.Option to exclude accounts with all zero amounts. | ||
Lists an OPU code followed by an appropriation account description then sorted by ascending full account codes | ||
Sorted by OPU then Fund-SCC then sorted by ascending full account codes. | ||
Sorts by ascending full account codes. Replaces MTD expenditures with YTD expenditures | ||
Cash Summary Report - FINSUMM. Excludes accounts with zero in all columns. | ||
Appropriation Report Categorized by Object Code. Created to match Classic Report APPOBJSEL Excludes Transfers and Advances | ||
Appropriation Report by Fund - Excludes accounts with all zero amounts, Excludes Transfers and Advances | ||
Appropriation Summary Report - APPSUM. Subtotal by Function. Exclude accounts with all zero amounts and excludes transfers and advances | ||
Appropriation Summary Report - Subtotal by Object. Exclude accounts with zero amounts and excludes advances and transfers | ||
Appropriation Summary Report - Exclude accounts with zero amounts and Excludes Transfers and Advances | ||
Appropriation Summary by Fund and Object Code Subtotal Only.rpd-json | Appropriation Summary Report - Sorts by fund code then object code. Lists subtotals only for each object code. May want to check the "summary report" option to show just fund/object | |
Revenue Summary Report - Written to exclude accounts with zero amounts for all columns. District runs instead of SSDT Revenue Summary to prevent seeing all the extra accounts with no activity. | ||
Budget Summary report with the option of choosing range of objects i.e.: begin obj 100 end obj 299 | ||
Budget Summary report with the option to choose multiple dimensions separated by a comma i.e.: Obj 412,413. Developed to use for multiple objects | ||
Cash Summary Report with option to choose multiple funds separated by a comma i.e.: 001,002,006. Developed to use for multiple funds | ||
Revenue Summary - Multiple funds separated by comma.rpd-json | Revenue Summary Report - Allows you to enter more than one fund separed by a comma i.e. 001,300,006 |
Budgeting Reports
Title (downloadable rpd-json file) | Example | Description |
|---|---|---|
Fiscal & Year to Date Expenditure amounts report, for general fund salary accounts only, sorted and totaled by function. Same as - BWCRPT Classic Report. Treasurer uses the totals to put into a spreadsheet to calculate the BWC payment. This report is built so you can use it for various funds and objects even though typically you would use 1% object. We have placed this report here as it could be used for budgeting purposes as well as in the Periodic reports area | ||
|
| This report is formatted to include the Budget Expense Worksheet accounts with amounts Expended set to anything Greater than zero. |
This report should be run as a summary report! Lists cash accounts with their Fiscal Year to Date expendable, expended, encumbrance, and unencumbered balance | ||
Lists cash accounts by full budget account code with their Fiscal Year to Date expendable, expended, encumbrance, and unencumbered balance | ||
Contains changes made to expenditure accounts initial estimates. The report is built so you can view changes made to initial estimates when applying proposed amounts for initial temporary (full year/not full year) and/or permanent transaction types. Adjustment type transactions are not included on this report. 'Full Year' indicates whether or not full year was checked and 'Replaced' indicates the temporary amounts was replaced with a permanent amount. | ||
Contains changes made to revenue accounts initial estimates. The report is built so you can view changes made to initial estimates when applying proposed amounts for initial temporary (full year/not full year) and/or permanent transaction types. Adjustment type transactions are not included on this report. 'Full Year' indicates whether or not full year was checked and 'Replaced' indicates the temporary amounts was replaced with a permanent amount. |
Transaction-Based Reports
Title (downloadable rdp-json file) | Example | Description |
|
|
|---|---|---|---|---|
The report has parameters that allow for multiple funds with use of comma separated rather than fund choice with wildcard option |
|
| ||
Purchase order detail report sorted by ascending date. Lists purchase order's one line at a time with information about each PO |
|
| ||
Purchase Order Detail Report. Subtotal by Full Account Code. |
|
| ||
Purchase order detail sorted by fund and then scc code. Also lists item descriptions |
|
| ||
Purchase Order Detail Report. Subtotal by full Cash account/Fund-SCC. |
|
| ||
Purchase order detail sorted by ascending OPU codes. Includes a page break after every OPU code |
|
| ||
Standard purchase order detail that includes item description |
|
| ||
Disbursement Summary report sorted by check type, and then check number. |
|
| ||
Financial Detail July 1 Cash Balances With Page Break.rpd-json | Financial Detail report that includes fiscal year cash balances with a page break after every new Fund-SCC code |
|
| |
Standard Financial Detail that sorts by ascending OPU code |
|
| ||
Financial Detail that lists transactions by date in ascending order with subtotals for each fund-scc. Also includes the current period's beginning and ending balances |
|
| ||
Standard financial detail sorted by cash account (Fund-SCC) then by OPU code. Separates revenue and expenditures |
|
| ||
Financial Detail Sorted By Fund-SCC and OPU With Separated Revenue and Expenditures.rpd-json | Financial Detail that separates revenue and expenditures by OPU code. Also separates full account code into individual columns. Separates revenue and expenditures into separate columns. Vendor number and vendor name added to report |
|
| |
Use this report before each check run to compare against paper invoices entered to be sure everything has been included in the check run |
|
| ||
This is a daily requisition report of what has been entered into the system. You can run this report daily to see what needs converted to PO’s and mailed/ordered/etc. |
|
| ||
Outstanding Requisitions not yet converted will be reported while including a column for requisitions that have attachments. |
|
| ||
Financial Detail Sorted By Fund and SCC Code With Separated Full Account Codes.rpd-json | Financial Detail sorted by cash account (Fund-SCC) with full account codes separated into individual columns. Includes purchase order amounts and remaining encumbrance |
|
| |
Financial Detail Sorted By Fund-SCC With Current Balances.rpd-json | Financial Detail Sorted by cash account (Fund-SCC) with the current period's current fund balances. Also has a page break after each cash account |
|
| |
Financial Detail Sorted By Fund-SCC Code With Separated Full Account Codes.rpd-json | Financial Detail sorted by fund and then SCC code. Features the full account code separated into individual columns |
|
| |
Financial Detail Sorted By Fund-SCC then Full Account Code.rpd-json | Financial Detail that sorts by cash account(Fund-SCC) and ascending full account codes. Includes vendor name and number |
|
| |
Financial Detail Sorted By Fund Then SCC With Current Balances and Separated Account Codes.rpd-json | Financial Detail that sorts by fund then SCC code and has full account codes in individual columns. Has the current month's beginning and ending balances |
|
| |
Receipt listing report with one line per receipt number with details about each receipt |
|
| ||
Receipt listing report that includes both Receipts and Reductions of Expenditures. (RX) |
|
| ||
SSDT Financial Detail Report July 1 Cash Balances - Type Subtotals.rpd-json | Financial Detail Report that includes fiscal year cash balances, sorted and subtotaled by Type (PO, Check, Receipt) Keep in mind this reports begins on July 1 through the period you choose so it could be a very lengthy report. |
|
| |
A listing of all transfer and advance transactions by cash account. Will show Advance Repayment transactions. |
|
| ||
Click Here |
|
|
|
Vendor-Based Reports
Title (downloadable rpd-json file) | Example | Description |
|---|---|---|
Purchase Order Deatil Report. Subtotal by Vendor Number. | ||
Sorts by vendor's primary names and lists item descriptions with amounts paid |
Periodic Reports
Title (downloadable rpd-json file) | Example | Description |
|---|---|---|
Financial Detail Report - Used for Project Cash Requests for Grant Funds | ||
Compliance report - compares Estimated Revenues and Expenditures against Actual Revenues and Expenditures. | ||
Fiscal & Year to Date Expenditure amounts report, for general fund salary accounts only, sorted and totaled by function. Same as - BWCRPT Classic Report. Treasurer uses the totals to put into a spreadsheet to calculate the BWC payment. This report is built so you can use it for various funds and objects even though typically you would use 1% object. | ||
Revenue Information used for uploading to a third party five year forecasting company | ||
Expense Information used for uploading to a third party five year forecasting company | ||
Select summary on generate screen Financial Detail Report with option to select multiple fund/scc separated by comma. |
Requisition Approval Workflow
Title (downloadable rdp-json file) | Example | Description |
|---|---|---|
Requisition Detail report showing requisitions with Workflow Approval Status set to Approved. | ||
Report displays the Groups and Groups Chains set up for the Requistion Approval Workflow. | ||
Report displays the Groups, Group Chains and the Users for the Requisition Approval Workflow. | ||
User Listing report showing the User's roles and Group Chains. |