munis reports for audit june 2015. agenda alternative use for mtd project budget report roll up to...

MUNIS REPORTS FOR AUDITJune 2015

Agenda• Alternative use for MTD Project Budget Report

• Roll up to specific object position• Determine Accounts Receivable and Unearned Revenue

• Flexible Period Earnings Report for grant analysis• Payments Report – Revenues • Consolidated Balance Sheet• Alternative use for AFR Report

• Report Fund 2 Groups in AFR Format

• Major Funds Report – 5% & 10% rules• Calculate Sick/Vacation Liability

MTD Project Budget ReportCan be used to report one project or multiple projects in one report.

• 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

• 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

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.

This report can be exported to Excel.

Report is useful for auditing payroll details by Project Code.

Flexible Period Earnings Report

Flexible Period Earnings Report

Payments Report

This is available if district utilizes the General Billing/AR module of Munis.

Payments Report - Detail

Reports payments by receipt.

Payments Report-Batch/Deposit

Reports payments by deposit total in most cases.

Consolidated Balance Sheet Set-Up

Confirm that each fund is assigned a fund type.

G=Governmental P=Proprietary

• Select Consolidated from the Balance Sheet Report screen

• Select Find • Select Green Check or Enter

to find All• Define Reporting year/period• Enter Fund Type (G or P) –

Critical!!

Consolidated Balance Sheet

Consolidated Balance Sheet

This report should match the Statement of Net Position.

• 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

Major Fund Reports – 5% & 10%

Major Fund Reports – 5% & 10%• Click Define, flag both Governmental & Proprietary

• Then Green Checkmark & Process• Click 5% Output & print • Click 10% Output & print• Give these to your auditor. It will save them a step.

Calculate Accrued Sick/VacationRun this BEFORE applying raises for next year!!!

Calculate Accrued Sick/Vacation

Calculate Accrued Sick/Vacation

Questions after the training can be sent to the following e-mail address:

finance.reports@education.ky.gov

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!