munis reports for auditors june 2014. agenda alternative use for mtd project budget report roll up...
TRANSCRIPT
![Page 1: MUNIS REPORTS FOR AUDITORS June 2014. Agenda Alternative use for MTD Project Budget Report Roll up to specific object position Determine Accounts Receivable](https://reader030.vdocuments.us/reader030/viewer/2022032313/56649e6a5503460f94b67ad1/html5/thumbnails/1.jpg)
MUNIS REPORTS FOR AUDITORSJune 2014
![Page 2: MUNIS REPORTS FOR AUDITORS June 2014. Agenda Alternative use for MTD Project Budget Report Roll up to specific object position Determine Accounts Receivable](https://reader030.vdocuments.us/reader030/viewer/2022032313/56649e6a5503460f94b67ad1/html5/thumbnails/2.jpg)
Agenda• Alternative use for MTD Project Budget Report
• Roll up to specific object position• Determine Accounts Receivable and Unearned Revenue
• Flexible Period Earnings Report• Payments Report – Revenues • Consolidated Balance Sheet• Alternative use for AFR Report
• Report Fund 2 Groups in AFR Format
![Page 3: MUNIS REPORTS FOR AUDITORS June 2014. Agenda Alternative use for MTD Project Budget Report Roll up to specific object position Determine Accounts Receivable](https://reader030.vdocuments.us/reader030/viewer/2022032313/56649e6a5503460f94b67ad1/html5/thumbnails/3.jpg)
MTD Project Budget ReportCan be used to report one project or multiple projects in one report.
![Page 4: MUNIS REPORTS FOR AUDITORS June 2014. Agenda Alternative use for MTD Project Budget Report Roll up to specific object position Determine Accounts Receivable](https://reader030.vdocuments.us/reader030/viewer/2022032313/56649e6a5503460f94b67ad1/html5/thumbnails/4.jpg)
• Great for those times you need to total your fringe cost
• Descriptions pull from first object code in series• Option is not available in YTD Budget Report
MTD Project Budget ReportRoll Up Object Codes
![Page 5: MUNIS REPORTS FOR AUDITORS June 2014. Agenda Alternative use for MTD Project Budget Report Roll up to specific object position Determine Accounts Receivable](https://reader030.vdocuments.us/reader030/viewer/2022032313/56649e6a5503460f94b67ad1/html5/thumbnails/5.jpg)
• Seg Find: Fund 2 and Active Accounts Only
• Use to validate projects at the end of each quarter for CDIP.
• Use to create End of Year entries for Accounts Receivable and Unearned Revenue.
• A Period 13 report prior to adjusting entries needs to be generated and retained for audit purposes. It cannot be re-created after the Accounts Receivable and Unearned Revenue entries have been made.
MTD PBR-Accounts Receivable and Unearned Revenue Entries
![Page 6: MUNIS REPORTS FOR AUDITORS June 2014. Agenda Alternative use for MTD Project Budget Report Roll up to specific object position Determine Accounts Receivable](https://reader030.vdocuments.us/reader030/viewer/2022032313/56649e6a5503460f94b67ad1/html5/thumbnails/6.jpg)
MTD PBR-Accounts Receivable and Unearned Revenue Entries
This report will be generated prior to making Period 13 Fund 2 entries. A copy should be retained for auditing purposes.
![Page 7: MUNIS REPORTS FOR AUDITORS June 2014. Agenda Alternative use for MTD Project Budget Report Roll up to specific object position Determine Accounts Receivable](https://reader030.vdocuments.us/reader030/viewer/2022032313/56649e6a5503460f94b67ad1/html5/thumbnails/7.jpg)
This report can be exported to Excel.
Report is extremely useful for auditing payroll details by Project Code.
Flexible Period Earnings Report
![Page 8: MUNIS REPORTS FOR AUDITORS June 2014. Agenda Alternative use for MTD Project Budget Report Roll up to specific object position Determine Accounts Receivable](https://reader030.vdocuments.us/reader030/viewer/2022032313/56649e6a5503460f94b67ad1/html5/thumbnails/8.jpg)
Flexible Period Earnings Report
![Page 9: MUNIS REPORTS FOR AUDITORS June 2014. Agenda Alternative use for MTD Project Budget Report Roll up to specific object position Determine Accounts Receivable](https://reader030.vdocuments.us/reader030/viewer/2022032313/56649e6a5503460f94b67ad1/html5/thumbnails/9.jpg)
Payments Report
This is available if district utilizes the General Billing/AR module of Munis.
![Page 10: MUNIS REPORTS FOR AUDITORS June 2014. Agenda Alternative use for MTD Project Budget Report Roll up to specific object position Determine Accounts Receivable](https://reader030.vdocuments.us/reader030/viewer/2022032313/56649e6a5503460f94b67ad1/html5/thumbnails/10.jpg)
Payments Report - Detail
Reports payments by receipt.
![Page 11: MUNIS REPORTS FOR AUDITORS June 2014. Agenda Alternative use for MTD Project Budget Report Roll up to specific object position Determine Accounts Receivable](https://reader030.vdocuments.us/reader030/viewer/2022032313/56649e6a5503460f94b67ad1/html5/thumbnails/11.jpg)
Payments Report-Batch/Deposit
Reports payments by deposit total in most cases.
![Page 12: MUNIS REPORTS FOR AUDITORS June 2014. Agenda Alternative use for MTD Project Budget Report Roll up to specific object position Determine Accounts Receivable](https://reader030.vdocuments.us/reader030/viewer/2022032313/56649e6a5503460f94b67ad1/html5/thumbnails/12.jpg)
Consolidated Balance Sheet Set-Up
Confirm that each fund is assigned a fund type.
G=Governmental P=Proprietary
![Page 13: MUNIS REPORTS FOR AUDITORS June 2014. Agenda Alternative use for MTD Project Budget Report Roll up to specific object position Determine Accounts Receivable](https://reader030.vdocuments.us/reader030/viewer/2022032313/56649e6a5503460f94b67ad1/html5/thumbnails/13.jpg)
• Select Consolidated• Select Find • Select Green Check or Enter to find All• Define Reporting year/period• Enter Fund Type (G or P) – Critical!!
Consolidated Balance Sheet
![Page 14: MUNIS REPORTS FOR AUDITORS June 2014. Agenda Alternative use for MTD Project Budget Report Roll up to specific object position Determine Accounts Receivable](https://reader030.vdocuments.us/reader030/viewer/2022032313/56649e6a5503460f94b67ad1/html5/thumbnails/14.jpg)
Consolidated Balance Sheet
This report should match the Statement of Net Assets.
![Page 15: MUNIS REPORTS FOR AUDITORS June 2014. Agenda Alternative use for MTD Project Budget Report Roll up to specific object position Determine Accounts Receivable](https://reader030.vdocuments.us/reader030/viewer/2022032313/56649e6a5503460f94b67ad1/html5/thumbnails/15.jpg)
• Use to report Fund 2 Grants in the AFR Format – generate by Local, State, Federal
• Downside – report does not clearly identify which codes are selected. Manually label after printing. (i.e. Fund 2 Project Range 1000-1999)
Annual Financial Report
![Page 17: MUNIS REPORTS FOR AUDITORS June 2014. Agenda Alternative use for MTD Project Budget Report Roll up to specific object position Determine Accounts Receivable](https://reader030.vdocuments.us/reader030/viewer/2022032313/56649e6a5503460f94b67ad1/html5/thumbnails/17.jpg)
Many thanks to…Amy Smith, CPA, CSFO, MBAChief Operating/Financial OfficerWoodford County Public Schools
Mrs. Smith originally prepared and presented the information in this document for the June 2013 Auditor Training.
Thank you, Amy!