Let's Work It Out: The Importance of Reconciliation
Melinda Ordway and Marcia Bohinc - Technical Assistance Bureau


All too frequently, headlines around the Commonwealth have reported the occurrence of missing money, misappropriations, or unauthorized spending in cities and towns. While the risk that a community may fail to detect fraud or otherwise safeguard its assets is a very real and critical problem, perhaps the strongest internal control for managing the situation is the performance of regular accounting reconciliations.

The Division of Local Services (DLS) has continually preached the importance of conducting frequent and prompt reconciliations. A reconciliation involves comparing two separately controlled sets of records to verify whether related account balances agree. This fundamental accounting process helps identify any unusual postings that could be caused by bookkeeping errors, or worse, by deception. The process of proving that transactions are in balance is essential for ensuring the integrity of general ledger data and mitigating fraud.


As a best practice, every community should conduct reconciliations of its two largest assets, cash and receivables, at least monthly to ensure records are accurate and no money is missing. However, the local volume of transactions may dictate that these reconciliations occur weekly, or even daily, given how time-consuming it can be to determine the source of discrepancies.

As the custodian of all revenues, tax titles, and tax possessions, the treasurer must keep a timely and accurate cashbook and reconcile this comprehensive journal of receipts and payments (including bank deposits and withdrawals) against bank statements each month. The collector maintains listings of the community’s various outstanding receivables, each of which is based on a receivable control. In this record of original entry, it begins with the initial tax commitment and tracks each processed collection, abatement, exemption, and tax title transfer, and is adjusted for each issued refund, resulting in the outstanding receivable balance.

After the treasurer and collector have internally reconciled their records, they should provide the balances to the accounting officer for comparison with the general ledger. The financial officers should then meet to discuss any identified discrepancies (caused by missing information, keying errors, timing differences, etc.) with the goal of resolving them. The results of these reconciliations should be reported to the community’s central manager or executive body to verify they were done and provide explanations for any outstanding variances.

Beyond cash and receivables, there are other bookkeeping records that must be periodically reconciled with the general ledger. These include the treasurer’s debt schedule and payroll with holdings, the assessors’ commitment and overlay charges, and other municipal and school department revenue and expenditure records.



To provide guidance and reinforce accountability, local officials should formally adopt a reconciliation policy that identifies each reconciliation to be conducted, assigns responsibilities, establishes deadlines, and requires the results be reported to the chief administrative or executive officer. Sample policies can be found in manuals posted on the Technical Assistance Bureau’s webpage. It should be every community’s goal to prioritize and complete regular reconciliations. Apart from the risk of potentially undetected revenue losses, the lack of timely reconciliations could delay or otherwise negatively impact the certification of free cash by DLS. It could also delay an audit engagement and result in a comment in the audit firm’s management letter.