Cashbook Statement Reconciliation

Purpose

This process ensures that the Vault Cashbook bank balance agrees to the closing balance of your bank statements

Timing

This should be done on a daily basis

Access

1. Cashbook | Manual Reconciliation
   
2.  | Manual Reconciliation
   

Process

Once transactions have been imported and coded, the bank should be reconciled

Field	Explanation
Bank	[F2] to  the required bank account
Statement Number	Prepopulates
Reconciled Date	Enter yesterday's date [Y] or the last business day
Closing Balance	Enter the closing balance from your bank statement
Current Balance	Prepopulates
Difference	Calculation of the Closing Balance and Current Balance Difference must be 0.00 for the dialog to save and transactions to reconcile

The Manual Reconciliation dialog should then close

If an error message appears:

1. Check that the Bank / Statement Number / Reconciled Date and Closing balance is entered correctly
   
2. Check that the transactions in the results grid have the expected Reconciled Status
   If not, highlight the required transaction and double click to change the Reconciled Status

• Related Articles

• Importing Cashbook Bank Transactions

  Purpose To import Statement Transaction amounts into Vault so they can be processed through the cashbook Processing will convert the Statement Transaction Amount to a Statement Transaction Batch. Timing These processes should be undertaken daily for ...

• Bank Details

  Purpose Records the Bank Account Details for each Bank Account that will be used to process bank transactions for the company Access Cashbook | Edit/View Bank Details Dialog Details Details Specific Fields Field Explanation Account Number Bank ...

• GL Cashbook Out Of Balance

  Purpose The General Ledger bank balance should always be the same amount as the Cashbook bank balance. When a discrepancy is identified, it is important to identify and resolve the issue. Timing This should be completed as soon as a discrepancy is ...

• Day Start Processing Checklist

  Cashbook Menu Explanation Check Edit/View Electronic Cashbook Transactions [Import] and process the Cashbook transactions for the previous day Repeat process for each bank account Manual Reconciliation Reconcile each bank account by entering the ...

• Month End Processing Checklist

  The significance of Month End Procedures It is important that checks are made at the time of month end reset, (usually the first working day of a new month) that will ensure the continued integrity of the systems. A brief description of each ...