Common Reports utilized by auditors
Auditors request reports at end of year
- Account Trial Balance
- YTD Budget Report
- Balance Sheet Report
Auditors need a Year-to Date budget report that provides information on revenue and expenditure accounts for the year.
Auditors need an Account Trial Balance report that provides information on revenue, expenditure and balance sheet accounts for the year.
Auditors need a Balance sheet report that provides information and confirmation that the Fund Balance is in balance for the year. Assets + Liabilities = Fund Balance
Here are the steps to run an Account Trial Balance report.
Financials>General Ledger Menu> Journal Entry/History> Account Trial Balance
- Click Search and enter criteria or leave blank for all accounts
- Accept
- Click Report Options and select criteria
- Accept
- Run the report once with A in the (B)alance sheet or (A)ll accounts field and once with B
- Accept
- Select PDF or other output method.
Here are the steps run the YTD Budget Report for revenue and expenditure accounts
Financials > General Ledger Menu > Inquiries and Reports > YTD Budget Report
- Click Search
- Enter in the criteria for the accounts needed. (Org/Obj/Project, Fund, Full Account code, etc.)
- Click Accept
- Click Report Options, update as needed
- Under Additional options update as needed.Â
- Click Accept
- Click Back
- Click Display
Here are the steps run the Balance Sheet Report for Balance sheet accounts.
Financials > General Ledger Menu > End of Period > Balance Sheet
- Click Define
- Enter in the criteria for the accounts needed. (Org/Obj/Project, Fund, Full Account code, etc.) and select report options.
- Click Accept
- Click Display, Print or Save
Auditors may request reports with detail information
Year Period does not include detail in the YTD Budget Report
Trial Balance is not including detail
To give Auditor Access to Munis Financial Data