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.

Notes:

  1. If Reference is blank, a new reference will be automatically assigned. For successive lines with the same reference, use '+' as Reference.
  2. If Reference is specified, it must match the pattern in Setup->Transaction References. You can mix automatic and manual references in the same file.


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