To reconcile a cash book:

1. Select Nominal Ledger and the company you want from the main menu.

   The Nominal Ledger Menu is displayed.

2. Select Cash Book Menu.

   The Cash Book Menu is displayed.

3. Select Reconcile Cash Book.

   The Reconcile Cash Book form is displayed.

4. Input a reference number.

   Note: If you do not know the reference number, it can be searched for using the Ellipsis button.

   The following fields are automatically populated:

   • Suffix
   • Narrative
   • Reference
   • Posting Date
   • Reconcile Text
   • Reconcile Values (Grid)



5. Input the following fields:

   • Bank account - the journal type field will automatically be displayed.
   • Suffix
   • Narrative (automatically displayed but can be updated)
   • Reference (automatically displayed but can be updated)
   • Posting date (automatically displayed but can be updated)
   • Reconcile text (automatically displayed but can be updated)

The Reconcile button will be enabled.

6. Enter values for each payment type and click Reconcile.

   Note: The Petty cash field displays how much cash to leave in the till. This can be changed if necessary.

   The Enter Petty Cash Quantities form is displayed.

7. Input the quantities of cash as held in petty cash and click Ok.

   Note: A message is displayed at the bottom of the form indicating the total amount of funds that should be in petty cash

   The Confirm Cash Book Reference Reconciliation form is displayed.

8. Click Confirm.

   The postings are done.

Reconcile Cash Book Form

This form enables you to reconcile the account (transfer the amount of cash entered in the suspense account to the actual bank account).  It is is displayed when you select Nominal Ledger > Cash Book Menu > Reconcile cash book. 

Menubar and Toolbar

Menu	Icon	Description
File > View Summary		Displays the Cash Book Reference Summary Display form.
File > Change Printer	—	Changes your current printer.
File > Exit		Returns to the Cash Book menu.
Tools > Reconcile		Reconcile the current cash book entry and display the Confirm Cash Book Reference Reconciliation form.
Help > Help		Displays this help file in your default browser.

Reference Number: The cash book reference number you want to reconcile.

Details Group:

Bank account: The nominal ledger code that the cash is to be posted to.

Journal type:  Always displays Default journal type.  This cannot be changed.

Variance account: The account that any variance is to be posted to.

Suffix: Suffix to be displayed in all transactions.

Narrative: A description of the reconciliation.

Reference: You can input your own free form reference in this field.

Posting date: The date that the cash book entries were posted.

Reconcile text: Free form field that you can use to input reconciliation text.

Reconcile Values Group:

Payment type: The type of payments that were done for the specific cash book reconciliation.

Note: Right-click a payment type to display the View summary dialog box.

Value: The amounts, per payment type, that are being reconciled.

Note: Values entered in the grid are black when they reconcile exactly, blue when they are within the variance limits and red when they are outside the variance limit.

Key:

The key to the colour-coded items in the grid is as follows:

Value is outside variance limit. In red, and the Reconcile button will be disabled.

Value is within variance limit: (In blue.) Variance is within the limit.

Value reconciles exactly: There is an exact reconciliation.

When the value fits the criteria, the user can click the Reconcile button and the reference is deemed to be reconciled. The reference will also be closed at this point.