Bookmark this page Print this page

Bulk Reconcile Cashbook Items (i.e. how to auto-reconcile a number of un-reconciled cashbook items)

For example, start with a number of un-reconciled Cashbook entries, something like those shown below for a supplier called “TRAVEL INSURANCE”....

At the end of the month or other period when you’re ready to bulk reconcile them go to the Sales Ledger and create a new single invoice for any sum (e.g. £9999.99) as shown below...

Save this invoice and return to the scrolling view, where you should select the “Signpost” button option to “Auto Reconcile”. Don’t worry that it shows the wrong amount that you just entered – click “OK”...

You will then see a “Reconcile Entry” pop-up, like that shown below, which will display the actual amount of un-reconciled cash in the Cashbook as “Previous cash”. You now know what the invoice amount should really be instead of the wrong amount (e.g. 9999.99). Note the correct figure and click “Cancel”


Double-click the invoice to re-open it, and change its amount to the “Previous cash” value. Save and return to the scrolling view. Re-select the option to “Auto Reconcile”, which will now be for the correct amount of un-reconciled items in the Cashbook, but CHANGE ITS AMOUNT TO ZERO as shown below (i.e. because you want to use the “Previous cash” in the Cashbook, rather than create a new Cashbook entry). Click “OK” to proceed.

On the “Reconcile Entry” pop-up, as shown below, simply click “OK” to auto-reconcile all the “Previous cash” (i.e. all existing items in the Cashbook for this supplier or client) against this invoice.