The Bank Reconciliation Import requires a header row, but columns can be in any order.
Click here to download a Sample import file
Required columns
Every transaction row must have:
| Column | Accepted header names |
| Date | Date, Transaction Date, TransactionDate |
| Amount | Amount or separate debit/credit columns (see below) |
If you do not use a single Amount column, you can use:
| Debit | Amount (debit), Debits |
| Credit | Amount (credit), Credits |
Debit amounts are treated as negative; credit amounts as positive. If both debit and credit are present, they are combined.
Optional columns
Only date, amount, type, payee/name, and memo-related fields (particulars, code, reference, memo, other party account) are used on the imported transaction. Other columns are accepted but are not read.
| Column | Accepted header names |
| Transaction ID | Unique Id |
| Type | Type, Tran Type, Description, Source Code (payment type) |
| Payee / name | Details, Payee, Other Party, Transaction Details |
| Particulars | Particulars, TP part |
| Code | Code, Analysis Code, TP code |
| Reference | Reference, TP ref |
| Memo | Memo, Memo/Description |
| Cheque number | Cheque Number |
| Foreign currency | ForeignCurrencyAmount |
| Conversion charge | ConversionCharge |
| This party account | This Party Account, Account number, Card, Account Number |
| Card used | Card Used |
| Other party account | Other Party Account, OP Bank Account Number, Origin |
| Serial | Serial |
| Transaction code | Transaction Code |
| Batch number | Batch Number |
| Originating bank/branch | Originating Bank/Branch |
| Processed date | Processed Date, Process Date, ProcessedDate, Processed |
| OP reference | OP ref |
| OP particulars | OP part |
| OP code | OP code |
| OP name | OP name |
| Balance | Balance |
| Credit plan name | Credit Plan Name |
| Foreign details | Foreign Details |
| City | City |
| Country code | Country Code |
Date Format
If creating a csv to manually import transactions into the bank reconciliation, please make sure that the dates are in the dd/mm/yyyy format and that the leading zeros have not been dropped.
This can be done by selecting the cells, right clicking and selecting Format Cells. Select Custom and locate the format you require - which can then be edited in the Type field.
