Report Bundles

Report Bundles are used to generate a report or group of reports on demand or at scheduled intervals to be sent via email or to the File Archive.

Automatically Generated Report Bundles

SSDT Report Bundles will automatically generate reports to the Utilities/File Archive when certain actions trigger the events. USAS-R contains one standard SSDT Report Bundle for SSDT Monthly Reports.

SSDT Monthly Reports Bundle

By viewing the SSDT Monthly Reports bundle, you can see the detail of what event triggers the reports and exactly what reports are created from this bundle and sent to the File Archive. 

Click on  to view the specific Report Bundle:

The SSDT Monthly Reports bundle is triggered when a Posting Period is closed. See the following section for a full list of included reports.

Monthly Reports Included

All FYTD/MTD report totals generated with the "As of period" of the Posting Period that was closed.

Redesign Report

Compare to Classic Report

Parameters

Redesign Report

Compare to Classic Report

Parameters

SSDT Appropriation Summary

APPSUM

All Appropriation Accounts

SSDT Monthly Balance Report

BALMON

All Cash Accounts for each fiscal year

SSDT Budget Account Activity Report

BUDLED

All Budget Activity - posting period Start/End dates

SSDT Budget Summary

BUDSUM

All Expenditure Accounts

SSDT Cash Summary 

FINSUMM

All Cash Accounts

SSDT Disbursement Detail

CHEKPY

All Disbursement Types, All Statuses - posting period Start/End dates

SSDT Cash Reconciliation Report

CSHREC

Summary of Details entered in Periodic > Cash Reconciliation for corresponding month and year

SSDT Financial Detail Report

FINDET

All Activity for posting period Start/End dates

SSDT Financial Summary by Fund Report

FUNDSUMM

Categorized by Function, Excludes Zero Amount Accounts

SSDT Negative Appropriation Account Report

NEGAPP

All Appropriation Accounts with a negative FYTD Unencumbered Balance

SSDT Negative Budget Report

NEGBUD

All Expenditure Accounts with a negative FYTD Unencumbered Balance

SSDT Outstanding Disbursement Summary

CHEKPY

Disbursements that are Outstanding as of the posting period

SSDT Outstanding Purchase Orders

PODETL

Purchase Orders with a Remaining Encumbrance as of the posting period

SSDT Purchase Order Detail

PODETL

All Purchase Orders with a transaction date in the posting period

SSDT Receipt Ledger Report

RECLED

All Receipts

SSDT Void Refund Ledger Report

RECVOD



SSDT Fund to Fund Transfer Ledger Report

RECTRN



SSDT Reduction of Expenditure Report

RECEXP

All Reduction of Expenditures with a transaction date in the posting period

SSDT Refund Ledger Report

RECREF

All Refunds with a transaction date in the posting period

SSDT Error Corrections and Supplies Distributions

RECCOR

All Distributions/Error Corrections with a transaction date in the posting period

SSDT Budgeting Transactions Summarized by Appropriation

RECAPP

All Budgeting Transactions with a transaction date in the posting period

SSDT Revenue Summary

REVSUM

All Revenue Accounts

SSDT Transfer Advance Summary

TRANADV

All Transfer/Advance activity for the current fiscal year

SSDT Transaction Ledger - Vendor Activity

TRNLED

All vendor transaction activity for posting period Start/Stop dates 

SSDT User Listing AOS Extract



All User listing in tab delimited format 

SSDT Vendor Listing

VENLST

All Vendors

SSDT Revenue Account Activity Report

REVLED

All Revenue Activity - Posting Period Start/End dates

SSDT Calendar Year End Reports Bundle

By viewing the SSDT Calendar Year End Reports bundle, you can see the Event details of what triggers the reports and what reports are created and sent to the File Archive. 

Click on  to view the specific Report Bundle:



The SSDT Calendar Year End Reports bundle will be sent to the Calendar Year Reports Archive when the December posting period is closed.  The Calendar Year Report Archive will also store the copy of the 1099 print files (XML), the copy of the 1099 submission extract file (TAP), the transmitter report (TXT) if the district is submitting the files to the IRS themselves, and the 1099 report (PDF) when these are processed by the user. See the following section for a full list of included reports.

Calendar Year End Reports Included

The following reports generate with Start/Stop dates for the calendar year.

Redesign Report or File

Compare to Classic Report

Parameters

Redesign Report or File

Compare to Classic Report

Parameters

1099-NEC Extract Report.pdf



PDF report showing 1099-NEC data generated when user generates the 1099 Extracts.

1099-MISC Extract Report.pdf



PDF report showing 1099-MISC data generated when user generates the 1099 Extracts.

School_1099.xml



File used to print the 1099 files.

School_1099.tap



1099 File Extract file.

1099Result.txt



The transmitter report.  Will only generate/store report if the district is submitting the files to the IRS themselves.

1099 Vendor Report - All Vendors

F1099

All 1099 vendors regardless of YTD amount

1099 Vendor Report

F1099

1099 Vendors with YTD amount of 600+

SSDT Budget Account Activity Report

BUDLED

All Budget Activity

SSDT Budgeting Transactions Summarized by Appropriation

RECAPP

All Budgeting Transactions

SSDT Disbursement Summary

CHEKPY

All Disbursement Types, All Statuses

SSDT Error Corrections and Supplies Distributions

RECCOR

All Distributions/Error Corrections

SSDT Financial Detail Report

FINDET

All Activity

SSDT Fund to Fund Transfer Ledger Report

RECTRN



SSDT Purchase Order Detail

PODETL

All Purchase Orders

SSDT Receipt Ledger Report

RECLED

All Receipts

SSDT Reduction of Expenditure Report

RECEXP

All Reduction of Expenditures

SSDT Refund Ledger Report

RECREF

All Refunds

SSDT Revenue Account Activity Report

REVLED

All Revenue Activity

SSDT Transaction Ledger - Vendor Activity

TRNLED

All vendor transaction activity

SSDT Void Refund Ledger Report

RECVOD



SSDT Fiscal Year End Reports Bundle

By viewing the SSDT Fiscal Year End Reports bundle, you can see the detail of what event triggers the reports and exactly what reports are created from this bundle and sent to the Fiscal File Archive. 

Click on  to view the specific Report Bundle:



The SSDT Fiscal Year End Reports bundle is triggered when when the last posting period of the fiscal year is closed. The reports will be included in the Fiscal File Archive and triggered by the event of FiscalPeriodCloseCompletedEvent. This bundle includes any reports relevant to the end of the fiscal year that will not already be included in the SSDT Monthly Reports bundle for the last period of the fiscal year (ex. Budget Summary, Cash Summary, etc). See the following section for a full list of included reports. 

Fiscal Year End Reports Included

The following reports generate with Start/Stop dates for the fiscal year. 

Redesign Report

Compare to Classic Report

Parameters

Redesign Report

Compare to Classic Report

Parameters

SSDT Budget Account Activity Report

BUDLED

All Budget Activity

SSDT Disbursement Summary

CHEKPY

All Disbursement Types, All Statuses

SSDT Financial Detail Report

FINDET

All Activity

SSDT Purchase Order Detail

PODETL

All Purchase Orders

SSDT Receipt Ledger Report

RECLED

All Receipts

SSDT Void Refund Ledger Report

RECVOD



SSDT Fund to Fund Transfer Ledger Report

RECTRN



SSDT Reduction of Expenditure Report

RECEXP

All Reduction of Expenditures

SSDT Refund Ledger Report

RECREF

All Refunds

SSDT Error Corrections and Supplies Distributions

RECCOR

All Distributions/Error Corrections

SSDT Budgeting Transactions Summarized by Appropriation

RECAPP

All Budgeting Transactions

SSDT Transaction Ledger - Vendor Activity

TRNLED

All vendor transaction activity

SSDT Revenue Account Activity Report

REVLED

All Revenue Activity

SSDT Civil Proceedings

USAEMSEDT

All pending law suits against the district during the fiscal year reported on Periodic Menu

SSDT Federal Assistance Detail

USAEMSEDT

All detailed Federal program monies received and expended during the fiscal year reported on Periodic Menu

SSDT Federal Assistance Summary

USAEMSEDT

Summary of Federal program monies received and expended during the fiscal year reported on Period Menu

SSDT USAS Auditor Extract - Account

USASAUD

Extraction of the Accounts to be sent to AOS for the fiscal year

SSDT USAS Auditor Extract - Transaction

USASAUD

Extraction of Transaction data files including Disbursements and Receipts

SSDT USAS Auditor Extract - Vendor

USASAUD

Extraction of Vendor files

SSDT 1099 Multiple Return Type Archive

By viewing this bundle, you can see the detail of what event triggers the reports and exactly what reports are created from this bundle and sent to the Calendar Year Reports Archive. 

Click on  to view the specific Report Bundle:

The SSDT 1099 Multiple Return Type Archive bundle creates a PDF report for 1099 when multiple types are selected. The reports will be included in the Calendar File Archive and triggered by the event of Multiple1099CreatedEvent. This bundle includes the SSDT 1099 Extract Report.

SSDT 1099 Submission Report Archive

By viewing this bundle, you can see the detail of what event triggers the reports and exactly what reports are created from this bundle and sent to the Calendar Year Reports Archive. 

Click on  to view the specific Report Bundle:

The SSDT 1099 Submission Report Archive bundle generates backup file for 1099 Report. The reports will be included in the Calendar File Archive and triggered by the event of Form1099CreatedEvent. This bundle includes the SSDT 1099 Extract Report and SSDT Downloaded File Backup.

SSDT Transmitter Summary Report Bundle

By viewing this bundle, you can see the detail of what event triggers the reports and exactly what reports are created from this bundle and sent to the Calendar Year Reports Archive. 

Click on  to view the specific Report Bundle:

The SSDT Transmitter Summary Report bundle creates a copy of the Transmitter Report for districts submitting 1099s to the IRS themselves. The reports will be included in the Calendar File Archive and triggered by the event of TransmitterCreatedEvent. This bundle includes the SSDT Downloaded File Backup.

Disable Automatically Generated Report Bundles

Only Administrators and USAS Managers are able to Enable and Disable automatically generated SSDT Report Bundles.

The check box in on the grid for each report bundle will determine if the Report Bundle is enabled or disabled. If the bundle is disabled then the reports will not be sent to File Archive. 

To disable a report bundle from going to File Archive, simply uncheck it:.

The SSDT Monthly Reports bundle is Enabled by default. 

Enabled:

Disabled:

View Reports in the Monthly Reports Archive

To view the reports, go to Utilities/File Archive/Monthly Reports Archive tab. The grid will contain a row for each Month that reports have been generated for. To view/download the Reports included in the Monthly Reports bundle, click on the row in the grid to open the detail on the right side of the page. Reports can be downloaded by clicking the generate  icon.

The Description of the Monthly Report bundle can be modified by clicking the edit  icon.

Monthly Report Bundles can be deleted by users with Administrative access by clicking the delete  icon. 

If a Posting Period is re-opened, the Monthly Bundle will automatically run again when the period is closed.  If a monthly report bundle already exists in the archive a second copy of the reports will be added to the existing Monthly reports. To avoid this, delete the first Monthly Reports bundle before re-closing the reopened posting period to prevent duplicate copies of reports from being stored for that month OR disable the Monthly Reports bundle prior to re-closing the posting period to retain the original reports. Currently you cannot delete individual reports from within a monthly archive. 



View Progress of Report Generation in the Job Scheduler

When the Monthly Reports bundle is triggered, Administrative users have the ability to view the job in the Utilities/Job Scheduler grid. This grid can be used to track the Status of the reports as they are generated. The Monthly Reports will be generated one by one in sequential order. Once all reports have been generated and sent to the File Archive, the Status will show "Completed." Click on the Job Scheduler grid to view the most up to date status.

User Generated Report Bundles

Creating a Report Bundle

To Create a new Bundle of reports, click on  option.

  1. From the menu, select 'Report' and click on 'Report Bundles.'

  2. Click on image-20240222-195741.png

    1. Report Bundle Name: Name of the Report Bundle that will show in the grid and on scheduled Report Bundles.

    2. Description: Option to add additional description detail that will show in grid by default

    3. Tags: Tags are user-defined words that mean something to the user to help categorize report definitions. For example, a tag could be 'YEAREND' or 'MONTHLY' reports.  Then they can use these tags for several other reports , enabling them to search for them easily in the Grid.

       

  3. To create a bundle of Reports, click on image-20240222-195830.png

     or start typing the report name under Select the Report to Add to the Bundle.

    1. SSDT Template Reports and Custom Reports in the Reports manager are available to add to Report Bundles

    2. The following Canned Reports are also available to add to Report Bundles

      1. SSDT Accounts Payable Report

      2. SSDT Account Status Report

      3. SSDT Amend Certificates Report

      4. SSDT Appropriations Resolution Report

      5. SSDT Audit Report

      6. SSDT Budget Summary Report

      7. SSDT Certificate Available Balances Report

      8. SSDT Disbursement Detail Report

      9. SSDT Financial Detail Report

      10. SSDT Financial Summary By Fund

      11. SSDT Purchase Order Detail Report

      12. SSDT Revenues and Expenditures Report

    3. The SSDT Cash Reconciliation report is also available to add to a Report Bundles

      1. When adding this report to a bundle it must be scheduled to run on the PostingPeriodCloseCompleted event so that the report is able to determine which month should be used.

  4. Once selected, this report will then show under Click + to Add this report with the desired Report Options to the Bundle. This grid will show one row for each of the saved parameters (created from the "Save and Recall" option) that exists for the chosen report. Use the image-20240222-195932.png  icon to select which version of the report to add to the Report Bundle.

  5. The report will show that it has been added to the 'Reports currently in the Bundle' box below.

     

  6. To add more reports to the bundle, select another report from the 'Select the Report to Add to the Bundle' option. Then click the image-20240222-200005.png next to the report under 'Add this Report with the desired Report Options to the Bundle' box.  This report will then show with the others in 'Report currently in the Bundle' box.

     

  7. To modify the report parameters for reports included in the Report Bundle, click on the icon next to the report in the grid at the bottom of the pop up window.

  8. Update the report parameters as needed

    1. Click image-20240222-200130.png to save the updated report parameters

    2. Click image-20240222-200149.png to continue with the original report parameters

    3. Click image-20240222-200208.pngto generate the report on demand with the entered parameters 

  9. Click on image-20240222-200447.png to save the Report Bundle. 

  10. To Exit out of the report bundles selecting option, click on the x in the right had corner.

  11. After the Report Bundle has been created, it will show in the Report Bundle Manager grid.

Search/View Report Bundles

The Report Bundle grid allows the user to search for existing report bundles. Report Bundles can be filtered using the headings on each column. 

Click on the  icon to view the Report Bundle. From this view, the option to Edit the reports or add additional reports can be accessed by clicking on and the option to clone the report bundle can be accessed by clicking on image-20240222-201819.png .

Edit Report Bundles

By default, users with Administrator, SYSMAN_USER, or USAS_MANAGER access can edit ANY report bundles. Users with other roles can edit Report Bundles that they created.

 

  1.  To change the Report Bundle details or reports included, locate the Report Bundle in the grid and click on the edit image-20240222-200609.png  icon.

     

  2. To edit the report parameters of a report that is included in the Report Bundle, select the report to edit and click on  in the grid on the pop up window.

     

  3. Update the report parameters as needed. Updates made to the parameters on this page will only affect the report when it is run from this Report Bundle.

    1. Click image-20240222-200130.pngto save the updated report parameters

    2. Click