Manual Bank Reconciliation

Manual Bank Reconciliation allows you to compare and clear down transactions against your bank statement.

This can also be done automatically. See Automatic Bank Reconciliation.

Open Accounts.
On the Home menu, click Bank Enquiry.
Right-click on the bank you want to reconcile, and select Uncleared.
Tick the Reconcile box next to the item you want to reconcile. Untick to unreconcile the item. You can also use Actions: Select All and Deselect All.

You can filter the transactions to locate the ones you need. Ticked items will remain ticked even when a filter is applied.

Once the items selected match the items shown on your bank statement and the Cleared Closing Balance matches your bank statement, you are ready to remove the items from the Uncleared Screen into the Cleared Screen.

Note If you find an item has not been posted, you can add the posting post the item and then after refreshing the screen carry on with your bank reconciliation.
Click on Actions from the top menu bar, and select Save from the list. The total boxes will now be updated and the items moved to Cleared.
Click Bank Reconciliation then Cleared. All of the items you previously selected will be displayed here.

Tip You can remove any items added by mistake by unticking the box, select Actions then Save. The item will be removed and will show in Uncleared.
Click on Actions, and select Clear Down.
Click Next.
Select the date that your reconciliation is being done up to. Print your Cleared and Unpresented items.

Note Once your cleardown is complete you will not be able to print these transactions.
Select Cleardown and, all cleared items will now be moved to the History file.

Reconciliation Totals

B/fwd Balance: This figure is updated once unpresented items have been reconciled and moved from Cleared Items into History, this figure should match your previous bank statement balance.
Balance: This is the balance at current date taking into account all opening balances plus all payments and receipts ie the cash book balance.
B/fwd Cleared Closing Balance: This figure will reflect the reconciled items that have been ticked and moved into Cleared Items. It should match your opening statement balance.
Cleared Closing Balance: This is the total of all the items you have reconciled (ticked) to your Bank Statement, and should replicate your closing Bank Statement Balance, this figure will be updated as individual items are reconciled.
Unpresented Items: This is the total figure of the unpresented payments and receipts combined for the selected bank.
Unpresented Payments: This is the total of all the unpresented payments for the selected bank. Unpresented Receipts: This is the total of the unpresented receipts for the selected bank. The unpresented totals will update whilst reconciling items.

Viewing the items in History:

Click on Bank Reconciliation and select History from the drop down list, you are able to search for items listed.

Filtering transactions

From: Enter the date you wish to search from or select from the calendar, only items from this date will be displayed, click Refresh to action the search.
To: Enter the date you wish to search up to, only items up to this date will be displayed.
Matter: Enter the matter you wish to search for unpresented transactions.
Branch: You are able to select the relevant Branch from the drop down list.
Type: This search will allow you to search by posting type, please see appendix for the full list of posting types.
Description: If you know the description of the posting, enter it here.
Amount: This defaults to All, if you wish to only search by either a payment or a receipt, choose from the drop down list next to All, enter the amount you wish to search for.

Note When using the search facility, you will need to click on the Refresh button to action the search. To remove the search from the screen, delete the information you have previously entered and click on the Refresh button, and all items will be displayed.