Reconcile Bank Accounts

Use the Reconcile command on the Action menu associated with the Bank Account form to reconcile the statements received from your bank with those on the Cashbook bank records. You can match unreconciled transactions with items on your statement and make additional entries for items, such as bank charges, not already posted to the account.

Make sure your bank entries are up to date. We recommend you post outstanding recurring entries using the Post Recurring command on the Utilities menu. If the application detects outstanding recurring entries, a message will appear asking if you want to post them before you continue with the reconciliation.

When you have completed details of the statement date, number and balance, the Unreconciled Entries form displays a grid showing all unreconciled transactions. You compare the transactions on your the statement received from your bank with those in the grid. Use the scroll bars to navigate the view. To perform an action, select one of the following commands from the Action menu. For some commands, you first click to select the transaction in the grid.

Use this command	To
Print	Print the transaction details shown for the selected account. You can also press F2 for this command.
Post	Add another posting for the account for a transaction that appears on the statement but not in your Cashbook. You can also press F5 for this command.
Zoom	Zoom to display further levels of detail associated with the transaction highlighted in the grid. Use this to display individual transactions that make up a batch. You can also press F8 for this command.
(Un)Tick	Select or deselect the transaction highlighted in the grid. You can also press the SPACEBAR for this command. When you 'tick' an item, a line number appears in the Line column. This is incremented, in tens, for each subsequent line you tick. You can change the number if required. The line number determines the order in which you can view reconciled items. It is therefore possible to sort reconciled transactions on the screen in the same order as they appear on the bank statement.
Change Line	Change the line number associated with the transaction highlighted in the grid.

Reconciliation Entries

Box	Description
Input By	The name of the person maintaining the reconciliation record. The user name as defined on the User Profiles form in the System module is used as a default entry. You can select a different user name from the list.
Reconciliation Date	The date of the reconciliation. This defaults to the system date which you can accept or amend.
Statement Date	The date on the statement you have received from the bank. This defaults to the system date. If the date on your bank statement is different, overtype the date.
From and To Statement No.	The range of statement numbers for the reconciliation. The From Statement No. box shows the number of the next statement to be reconciled. This is determined by the entry in the Next Statement Number box on the Controls form associated with the Bank Account form. The To Statement No. box defaults to the same as the 'from' statement number. You can amend this if required.
B/Fwd Balance	The balance brought forward from the previous reconciliation.
Statement Balance	The balance at the end of the statement you have received from the bank. This determines the balance remaining for reconciliation. When the balance after marking entries for reconciliation matches the statement balance you enter here, you can complete the reconciliation.