1. From the General Ledger screen, select the Government Reporting menu and then Missouri SDAC.
Generating the Report:
2. Enter the ending date of the quarter for which to generate the report in the Quarter End Date field. Use the mm/dd/yyyy format or click the down-arrow button to select the desired date. The default date will appear, but can be changed.
Tip: The date and time when the report was last generated (executed) for the specified quarter and the date and time when the report was last edited (if applicable) after being generated display to the right of the Quarter End Date field.
3. Enter your name in the Contact field. The name can be up to 50 characters long.
4. If an account group has been created for only those account numbers to include on the Missouri SDAC report, enter the ID for the account group in the Account Group field, or click the down-arrow button to select the correct one. To include account numbers from the entire Chart of Accounts (from only those funds specified in Step 5 below) on the Missouri SDAC report, leave this field blank.
5. Each of the funds defined by the state that are to be reported on the Missouri SDAC report appear in the Funds List on the bottom of the screen. The fund description and the state recommended fund numbers (displayed in parentheses) are listed for each fund. For each of the funds, enter the actual fund number being used to track the specified fund under the Actual Fund column, or click the down-arrow button to select the correct one. For example, enter 10 under the Actual Fund column for Fund 10 and 20 for Fund XX. Up to 30 different fund numbers can be entered for a fund. If more than one fund number is entered in the Actual Fund columns, the funds will be combined together and included under the one number on the report.
6. Click the Save button.
7. Click the Execute button to generate the report with the specified information.
8. After the report is generated, the screen listing any invalid account numbers will appear. Invalid account numbers are those that are not included within the reporting range on the report and so the amounts for those accounts will not be reported. To print a listing of the invalid account numbers, complete a print screen or a print grid. From this list, decide how to include the amounts for the invalid account numbers on the report. The invalid account numbers can be reported by completing one of the following: 1) edit the report and manually include the amounts (refer to Step 9 below); 2) complete manual journal entries to transfer the amounts to different account numbers that are within the reporting range and then regenerate the report; or 3) crosswalk invalid account numbers to ones that are within the reporting range and then regenerate the report.
Editing the Report:
9. To manually make changes to the report, click the Edit tab.
10. Make the desired changes to the report. Use the mouse or arrow keys to move around the screen. Also, select the Go menu and then the desired page to move to a specific page.
Tip: To zoom in or out while viewing the report, press the Ctrl key and use the scroll wheel on your mouse to increase or decrease the magnification.
11. After all the changes have been made to the selected report, click the Save button.
Printing the Report:
12. To print the Missouri SDAC report, click the To Printer button.
Exporting the Report:
13. To export the Missouri SDAC report to a spreadsheet file in order to copy and paste the information from this report into the Microsoft® Excel file for submission, click the Edit tab, select the File menu, and then select Export Spreadsheet. At the File to Export screen, specify the correct path (drive and folders) and file name, and then click the Save button.
14. Click the X in the upper right-hand corner to close the Missouri SDAC report screen.