Page tree
Skip to end of metadata
Go to start of metadata

Welcome to the SSDT shared reports library.

Contains USAS template reports created and shared by other users which can be downloaded and used in your local application.

Search this documentation




Account-Based Reports

Title (downloadable rpd-json file)ExampleDescription
Budget Expenditures by Month.rpd-jsonClick Here

Sorts by full account code and monthly expenditures. Lists a budgets expenditures for each month in the calendar year

Budget Summary by Approp.rpd-jsonClick HereSubtotal by Appropriation Account. Option to exclude accounts with all zero amounts.
Budget Summary by First Number of Object.rpd-jsonClick HereSubtotal 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-jsonClick HereSubtotal by Cash Account, first 2 digits of function, first digit of object. The parameters allow for multiple funds rather than wildcard fund option.
Budget Summary Report by Fund .rpd-jsonClick HereSubtotal by Fund. Option to exclude accounts with all zero amounts.
Budget Summary by Fund-SCC - Exclude Zeros.rpd-jsonClick HereSubtotal by Fund-SCC. Similar to standard Budget Summary.Option to exclude accounts with all zero amounts.
Budget Summary by Object.rpd-jsonClick HereSubtotal by Object.Option to exclude accounts with all zero amounts. 
Budget Summary by OPU and Approp Description.rpd-jsonClick Here

Lists an OPU code followed by an appropriation account description then sorted by ascending full account codes

Budget Summary by OPU and Fund-SCC.rpd-jsonClick HereSorted by OPU then Fund-SCC then sorted by ascending full account codes.
Budget Summary with YTD Expenditures.rpd-jsonClick HereSorts by ascending full account codes. Replaces MTD expenditures with YTD expenditures
Cash Summary - Exclude Zeros.rpd-jsonClick HereCash Summary Report - FINSUMM. Excludes accounts with zero in all columns.
APPOBJSEL.rpd-jsonClick HereAppropriation Report Categorized by Object Code. Created to match Classic Report APPOBJSEL Excludes Transfers and Advances
Appropriation Summary by Fund.rpd-jsonClick HereAppropriation Report by Fund - Excludes accounts with all zero amounts,  Excludes Transfers and Advances
Appropriation Summary by Function.rpd-jsonClick HereAppropriation Summary Report - APPSUM. Subtotal by Function. Exclude accounts with all zero amounts and excludes transfers and advances
Appropriation Summary by Obj.rpd-jsonClick HereAppropriation Summary Report - Subtotal by Object. Exclude accounts with zero amounts and excludes advances and transfers
Appropriation Summary.rpd-jsonClick HereAppropriation Summary Report - Exclude accounts with zero amounts and Excludes Transfers and Advances
Appropriation Summary by Fund and Object Code Subtotals Only.rpd-jsonClick HereAppropriation Summary Report - Sorts by fund code then object code. Lists subtotals only for each object code


Budgeting Reports

Title (downloadable rpd-json file)ExampleDescription



















Transaction-Based Reports

Title (downloadable rdp-json file)ExampleDescription
Open PO Report with Account Code.rpd-jsonClick HereThe report has parameters that allow for multiple funds with use of comma separated rather than fund choice with wildcard option
PO Detail by Date.rpd-jsonClick HerePurchase order detail report sorted by ascending date. Lists purchase order's one line at a time with information about each PO
PO Detail by Full Account Code.rpd-jsonClick HerePurchase Order Detail Report. Subtotal by Full Account Code.
PO Detail by Fund and SCC.rpd-jsonClick HerePurchase order detail sorted by fund and then scc code. Also lists item descriptions
PO Detail by Fund-SCC.rpd-jsonClick HerePurchase Order Detail Report. Subtotal by full Cash account/Fund-SCC.
PO Detail by OPU.rpd-jsonClick HerePurchase order detail sorted by ascending OPU codes. Includes a page break after every OPU code
PO Detail with Item Description.rpd-jsonClick HereStandard purchase order detail that includes item description
Disbursement Summary by Check type.rpd-jsonClick HereDisbursement Summary report sorted by check type, and then check number.


Vendor-Based Reports

Title (downloadable rpd-json file)ExampleDescription
PO Detail by Vendor Number.rpd-jsonClick HerePurchase Order Deatil Report. Subtotal by Vendor Number.
PO Detail by Vendor Primary Name.rpd-jsonClick HereSorts by vendor's primary names and lists item descriptions with amounts paid


Periodic Reports

Title (downloadable rpd-json file)ExampleDescription



Miscellaneous Reports

Title (downloadable rdp-json file)ExampleDescription



  • No labels