CB Statement Import

Navigator > Tasks > Cash Book > Bank Reconciliation > Select Reconciliation > Import button

Import data, such as statements exported from online banking, into the Statement grid. See CB Bank Statement Import Set-up.

If Match After Import is Selected for the Bank Account, statement lines are automatically matched with unreconciled transactions and Rules.

After import, click Apply Rules to apply matching rules to the statement. (See CB Bank Reconciliation for details.)

Accredo provides sample import definition files for major New Zealand banks. You can also setup a statement import definition in the CB Statement Import Designer.


Fields
Definition File	Cash Book Import definition files can be setup using CB Statement Import Designer. They consist of MaxBasic code designed to provide access to data objects. Click Open In Designer to open the selected file in the CB Statement Import Designer.
Import File	The file name and path of the data to be imported. Specify the name and path of the file to import, or click Select File `(F2)` to search for the file`.`
Date of Last Import	The date a statCB Bank Statement Import Set-upement was last imported for the Bank Account.
Excel Worksheet	Available for Microsoft Excel Import Files. Select the worksheet to import from. Note: Do not use apostrophes (') in worksheet names, as this can cause problems.

CB Confirm Import

If any transaction date in the import file is on or before the Date of Last Import you are prompted with the date range in the file for your desired action.

Import Transactions dated after ...

This selection displays if some transactions in the file are later than the date of last import.

Selected (default) Import will only import the transactions after the date shown.

Unselected Import will import all transactions regardless of date.

Import

Import all or the selected records from the file.

Cancel

Cancel the import.