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.

These processes should be undertaken daily for each bank account setup

Initial Setup should be

to your main bank account or the Bank field left blank where multiple bank accounts are processes
Match Combo box to Not Matched

Field	Explanation
Bank	Select the Bank account that is to be processed
Matched	Can be used to include All, Matched, or Not Matched transactions It is usual for the dialog to be to Not Matched

Bank | [F2] to select the bank account |

The above ‘success’ message will appear, and the bank transactions will be listed

If the import fails or the dialog remains empty, there may be issues with your bank setup

Note: Cross Referenced or Dishonored transactions will not display if the Matched combo box has been

to Not Matched

Field	Explanation
	Presents an Import Dialog for the specified bank account/import file format
	Allows the coding of a single Cashbook Transaction against the Statement Transaction Amount
	Allows the Statement Transaction Amount to be matched to an existing Statement Transaction Batch, or to create a new Statement Transaction Batch
	Allows a Cross Reference Transaction to be created Future transactions will be automatically matched upon import This is also useful for automatic payments and any other recurring amounts
	Matches any newly created X-Reference transaction(s) to the imported Statement Transaction Amount creating a Statement Transaction Batch This will also refresh the display to show only Not Matched transactions if that is the Matched indicator set

Related Articles
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 ...
Cashbook Statement Browse
Purpose To provide a list of all Cashbook Statement Transaction Batches that have been entered to Vault To provide the ability to track where Cashbook Transactions have posted to To process Statement Transaction Batches Access Cashbook | Edit/View ...
Cashbook Statement Analysis of Transaction
Purpose Creates the individual Cashbook Transactions that make up a Statement Transaction Batch This dialog is used for: Coding imported Statement Transaction Amounts Manually creating a Statement Transaction Batch Cashbook Journal entries Access ...
Match: Cashbook Statement Browse
Purpose This function is used for the matching of a Statement Transaction Amount to an existing Statement Transaction Batch created in Vault. If a Statement Transaction Batch does not exist, a new batch may be created. Timing Whenever required ...
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 Cashbook | Manual Reconciliation | Manual Reconciliation Process Once ...