Import Transactions

Spreadsheet Headers Prior to converting to Comma Separated Values file (csv)

Processing | A | B | C | D | E | F | G | H | I | J | K | L
Journal | Reference (must match pattern in Setup->Transaction References) | Date (Check csv for 4 digit year) | Memo/ Desc | Amount (Minus = Credit, Plus = Debit) | Account Code | Tax type_id (Use lookup tool) | Dim1_ref (leave blank – for advanced users) | Dim2_ref (leave blank – for advanced users) | Person_type id (Name =0 Supplier =3 Customer =2) | Person_id (Use lookup tool or actual name if Name=0) | Comments (Optional) |
Deposit | Reference (must match pattern in Setup->Transaction References) | Date (Check csv for 4 digit year) | Memo/ Desc | Amount (Always positive) | From Account Code | Tax type_id (Use lookup tool) | Dim1_ref (leave blank – for advanced users) | Dim2_ref (leave blank – for advanced users) | Person_type id (Name =0 Supplier =3 Customer =2) | Person_id (Use lookup tool or actual name if Name=0) |  |
Payment | Reference (must match pattern in Setup->Transaction References) | Date (Check csv for 4 digit year) | Memo/ Desc | Amount (Always positive) | To Account Code | Tax type_id (Use lookup tool) | Dim1_ref (leave blank – for advanced users) | Dim2_ref (leave blank – for advanced users) | Person_type id (Name =0 Supplier =3 Customer =2) | Person_id (Use lookup tool or actual name if Name=0) |  |
Bank Statement Format | Reference (must match pattern in Setup->Transaction References) | Date (Check csv for 4 digit year) | Memo/ Desc | Payment amount (Always positive) (blank if deposit amount present) | Deposit amount (Always positive) (blank if payment amount present) | Account code | Tax type_id (Use lookup tool) | Dim1_ref (leave blank – for advanced users) | Dim2_ref (leave blank – for advanced users) | Person_type id (Name =0 Supplier =3 Customer =2) | Person_id (Use lookup tool or actual name if Name=0) | Branch_id (debtor_no)

Examples: Use the csv file templates available under the templates folder for each type of processing.

Account codes in the csv file templates come from the en_GB (United Kingdom) Chart of Accounts.

Journal processing …. templates/journal_en_GB.csv

Deposit processing …. templates/deposit_en_GB.csv

Payment processing …. templates/payment_en_GB.csv

Bank statement format …. templates/bank_en_GB.csv

Sales Order/Invoice processing …. templates/salesinvoices_two_invoices_multiitems_cash_sale_paymentid4.csv

Sales Order/Invoice processing …. templates/salesinvoices_two_invoices_multiitems_credit_sale_paymentid1.csv

Sales Order/Invoice processing …. templates/single_line_salesinvoices.csv