The Cashbook can display an unlimited number of banks at one time to perform a reconciliation on or to enquire on.
|
Resources |
The actual display takes the form of a spreadsheet and by moving your mouse pointer over the form, you can perform several tasks on the displayed entries.
Also provided is a summary form that will display all Cashbooks' balances and bank balances.
To view the Cashbook display spreadsheet you must select the Bank you require by using the navigation arrows.
|
Field |
Value |
|
Bank Code |
Select or enter the Cashbook Bank Code you want to display the bank reconciliation for. |
|
Ref/Chq Number |
The transaction reference/cheque number. |
|
Date |
The transaction date. |
|
Description |
The transaction description. |
|
Amount |
The transaction amount. |
|
Status |
The transaction status - The status can be un-reconciled, reconciled, reconciled in error, reversed or locked. |
|
Reconciled Amount |
The amount the transaction is reconciled with on the bank statement. |
|
Variance |
The difference between the transaction amount and the reconciled amount. |
|
Status Description |
The description of the current status of the transaction. The status can be un-reconciled, reconciled, reconciled in error, reversed or locked. If interfaced with RecXpress and the transaction is reconciled in RecXpress, (RX) followed by the status of the transaction in RecXpress is displayed. The status of the transaction in RecXpress can be Exact Match, Matched With Error, Matched Amount, More Than One Amount, Multiple Match and Many CB to One Bank Entry. |
|
Comments |
Editable field to allow the user to enter any comments relevant to the transaction. |
|
Button |
Select |
|
Refresh |
Select the Refresh button to update the bank reconciliation with any new entries that were posted after accessing the bank reconciliation, without having to scroll off the bank code to another bank code and back or close and re-open the form. |
|
Close Bank |
Select the Close Bank button to close the bank reconciliation for the particular bank code. |
|
Close |
Select the Close button to close the Bank Reconciliation. |
The Cashbook window lets you view transactions and balances and perform multiple functions with these transactions:
Transactions data - cheque number, date, description, amount, status, reconciled amount and variance.
Transaction details - double click on any row and all details for the transaction will be displayed.
The transaction status - The status can be open, reconciled, reconciled in error or reversed.
The Cashbook and bank statement balance - the balances displayed will be for the date range displayed under the Cashbook toolbar.
History Transactions – Transactions that have been cleared from the Cashbook transaction file and placed in the Cashbook history file.
Bank reconciliation - change the status of an entry 'on the fly'
Lock/Unlock – lock and unlock reconciled entries.
Reversals - reverse transaction entries posted in Cashbook
Adjustments – perform quick and easy adjustments of entries reconciled in error.
Print the Cashbook
Reconcile Range - reconcile a range of entries.
Search - search for entries by several different fields.
Calculate - select a range of transactions and get a quick total.
Note:
Transactions
cannot be Reconciled/Un-reconciled under the following circumstances:
You cannot change the entry status when you have sorted by Status or Reconciliation amount. You can sort by date and then use the filter to show only un-reconciled entries.
When another user is logged in to the same Bank you cannot Reconcile/Un-reconcile.
Tip:
There
are two ways to speed up the Reconciliation:
Clear the reconciled transactions to History so you do not display a large volume of entries in the bank reconciliation.
Change the sort order of the bank reconciliation to Date.