Worksheet to Compare Month End Report Totals
Recommended Steps to Month End Reconciliation
1. Verify that all Activity has been Posted. [Financial Management → Post Activity → Turn on ALL activity types → Turn
off any Ranges → Run Report] If “No Records Selected” returned then all activity has been posted.
2. All Recommended reports can be found in OpenRDA – Financial Management → Reports → Month End Reports
3. Run Check Controls Report for Current Month & Fiscal Year – Fill in totals on worksheet
Account Code Totals refer to the Balance Sheet Control codes (frequently this is 602 for Expenditures and 302 for
Revenue, but can be different for your organization)
4. Run Expenditure Summary Report for Current Fiscal Month & Fiscal Year as well as FUND – Fill in totals on
worksheet
5. Run Revenue Summary Report for Current Fiscal Month & Fiscal Year as well as FUND – Fill in totals on worksheet
6. Run Expenditure Activity Report – Turn on ALL flags at Top of Range Screen – Turn on Select Posted ONLY – Set
Optional Sort Level 1 to FD – Range on Sort Level 1 [In the From/To fields enter the FUND you are reconciling]
Range on Fiscal Year – Month – Run Report --- Fill in totals on worksheet
7. Run Revenue Activity Report – Turn on ALL flags at Top of Range Screen – Turn on Select Posted ONLY – Set
Optional Sort Level 1 to FD – Range on Sort Level 1 [In the From/To fields enter the FUND you are reconciling]
Range on Fiscal Year – Month – Run Report --- Fill in totals on worksheet
8. Run Expenditure Detail Report – Turn on ALL flags at Top of Range Screen – Turn on Select Posted & Distributed
ONLY – Range on Fiscal Year – Month –Select Detail Ranging Button – Range on FUND [In the From/To fields enter
the FUND you are reconciling] –SAVE -- Run Report (NOTE: This can take some time to run based on volume of
data -may want to AutoArchive to save and view from archives) --- Fill in totals on worksheet
9. Run Revenue Detail Report – Turn on ALL flags at Top of Range Screen – Turn on Select Posted & Distributed ONLY
– Range on Fiscal Year – Month –Select Detail Ranging Button – Range on FUND [In the From/To fields enter the
FUND you are reconciling] –SAVE -- Run Report (NOTE: This can take some time to run based on volume of data
-may want to AutoArchive to save and view from archives) --- Fill in totals on worksheet
10. On the worksheet all Estimated Revenue [Green] totals should match, all Revenue [Orange] totals should match, all
Appropriation [Blue] totals should match, all Expenditure [Pink] totals should match