You can use Automatic Bank Reconciliation using the XML Gateway to import your bank statement. You will need to contactALB to set this up your electronic statement format.
To manually reconcile your bank, highlight the bank you wish to reconcile and select Bank Reconciliation and Uncleared. Uncleared will display all unpresented items for the bank you have selected.
The left hand side of the screen has various searching facilities and the right hand side of the screen will display all unpresented items.
Search by Transaction Details
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.
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.
To use the Bank Reconciliation:
Select the item you wish to reconcile by clicking in the box against the posting, this will enter a tick into the box.
If you wish to unreconcile an item, click again and this will remove the tick.
Once you are happy that the items selected match the items shown on your bank statement, and the Cleared Closing Balance matches your bank statement.
You are now 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 open up a posting screen, post the relevant 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.
Tick on Bank Reconciliation and select Cleared, all of the items you previously selected will be displayed here.
If you need to remove an item selected in error, click on the tick box to remove the tick, go to Actions and click Save, the item will now be removed and will show in Uncleared.
To update the cleared items and transfer them to History:
Click on Actions, and select Clear Down.
Select the date that your reconciliation is being done up to (if you forward post client transactions you may only want the reconciliation to show unpresented items up to a specific date). Print your cleared and unpresented items.
Note Once your cleardown is complete you will not be able to print these transactions.
To view the items in History:
Click on Bank Reconciliation and select History from the drop down list, you are able to search for items listed.