erased from the General Ledger Table Validation report when the month is closed. Important! Use this option with caution and with the help of Munis Technical Support personnel. Rerun the Full validation in the General Ledger Tables Validation program until only warnings appear Run the Account Balance for balance sheet accounts in summary and confirm beginning and ending fund balances are zero Run the Account Trial Balance for all accounts in summary and confirm beginning and ending fund balances are zero Print a Balance Sheet report in summary (consolidated) and in detail for each fund through the period being closed: Confirm each fund’s assets=liabilities + fund balance. Record the AP control account balances. Record the Inventory account balances. Record the FA account balance. Record the expenditure control account balance. Record the revenue control account balance. Note: Run the Account Trial Balance for all accounts in detail to use if reconciliations below show differences between the modules and the Account Balance totals and export to Microsoft Excel so you can sort by source journal. Reconcile accounts receivable by: Completing the Detail Receivables by Date report. Comparing the AR/GL Reconciliation Report by Fund to the Account Trial Balance Accounts Receivable control account for each fund. Comparing the Invoice Detail Report Summary by Charge Code to the Account Trial Balance Revenue Accounts. Reconcile accounts payable by comparing the Invoice History by GL Account Report to the Account Trial Balance for the AP Control Account. Reconcile: History By Fund Invoice Selection–Only Open Invoices Year/Period equals Period Being Closed Last check date is the last day of the month to be closed Reconcile assets by comparing the Asset History by GL Account report for active assets and capitalized assets to the Account Trial Balance fixed asset account totals. Reconcile inventory by comparing the Perpetual Inventory Report to Account Trial Balance. Running the GL Table Validation, the Trial Balance for All Accounts, and then Trial Balance for Balance Sheets Accounts completes the prove process for accounts. When you run the Trial Balance for All Accounts, the control accounts are ignored and the subsidiary ledger takes their place. When run the Trial Balance for Balance Sheet Accounts, the control accounts take the place of the subsidiary ledger. If either are out of balance, then there is an issue with control accounts not equaling the subsidiary ledger. The General Ledger
erased from the General Ledger Table Validation report when the month is closed. Important! Use this option with caution and with the help of Munis Technical Support personnel. Rerun the Full validation in the General Ledger Tables Validation program until only warnings appear Run the Account Balance for balance sheet accounts in summary and confirm beginning and ending fund balances are zero Run the Account Trial Balance for all accounts in summary and confirm beginning and ending fund balances are zero Print a Balance Sheet report in summary (consolidated) and in detail for each fund through the period being closed: Confirm each fund’s assets=liabilities + fund balance. Record the AP control account balances. Record the Inventory account balances. Record the FA account balance. Record the expenditure control account balance. Record the revenue control account balance. Note: Run the Account Trial Balance for all accounts in detail to use if reconciliations below show differences between the modules and the Account Balance totals and export to Microsoft Excel so you can sort by source journal. Reconcile accounts receivable by: Completing the Detail Receivables by Date report. Comparing the AR/GL Reconciliation Report by Fund to the Account Trial Balance Accounts Receivable control account for each fund. Comparing the Invoice Detail Report Summary by Charge Code to the Account Trial Balance Revenue Accounts. Reconcile accounts payable by comparing the Invoice History by GL Account Report to the Account Trial Balance for the AP Control Account. Reconcile: History By Fund Invoice Selection–Only Open Invoices Year/Period equals Period Being Closed Last check date is the last day of the month to be closed Reconcile assets by comparing the Asset History by GL Account report for active assets and capitalized assets to the Account Trial Balance fixed asset account totals. Reconcile inventory by comparing the Perpetual Inventory Report to Account Trial Balance. Running the GL Table Validation, the Trial Balance for All Accounts, and then Trial Balance for Balance Sheets Accounts completes the prove process for accounts. When you run the Trial Balance for All Accounts, the control accounts are ignored and the subsidiary ledger takes their place. When run the Trial Balance for Balance Sheet Accounts, the control accounts take the place of the subsidiary ledger. If either are out of balance, then there is an issue with control accounts not equaling the subsidiary ledger. The General Ledger
munis_gl_month_end.docx