Import receipts, payments, contra and journals from a spreadsheet

When there are many vouchers to enter, fill the template spreadsheet and import it. The screen shows every row, marks the ones in error, and saves nothing until each voucher balances. Each voucher is saved as if typed by hand.

Accounting Cash and bank vouchers
3 min read
Updated October 20, 2026

For Accountant

Where

The Receipt voucher, Payment voucher, Contra voucher and Journal voucher screens each have Import next to Add. Choose Import, and if your company has more than one series, choose the series the new vouchers should use.

Import

Download the template
Who
Accountant
Where
Import > Template
What changes
A spreadsheet with the columns the screen expects. Receipts, payments and contra share one template; journals have their own.
Fill it
What changes
One row per ledger. Rows of the same voucher share the Date and Voucher no (your own number: it becomes the voucher's reference). Each row has the Ledger, an optional Sub ledger, the Amount and the Amount type (debit D or credit C).
Needs
Each voucher must balance. For a payment: exactly one credit row (the account the money left) and one or more debit rows (the ledgers paid). For a receipt: exactly one debit row (the account the money went into) and one or more credit rows. For a journal: the debits equal the credits.
Upload it
Where
Import > Upload, choose the .xlsx file
What changes
The rows appear in a grid, each voucher in its own colour. A problem in the header (a missing column) is listed instead of the rows. Rows in error are marked: "Data not imported, Please see error list". Delete a row in error, or correct the spreadsheet and upload again.
Save
What changes
Each voucher is saved in turn, with the series you chose, the local currency and the date on its rows. "Data import completed successfully."

Example: two payments in one spreadsheet

On the Payment voucher screen's Import, a spreadsheet with these rows, all with the same Date, makes two payment vouchers:

Voucher no	Ledger	Amount	Amount type
P-01	Bank current account	25,000	C
P-01	Office rent	20,000	D
P-01	Electricity	5,000	D
P-02	Cash in hand	3,000	C
P-02	Stationery	3,000	D

P-01 has one credit row (the bank the money left) and two debit rows that add up to the same 25,000; P-02 has one credit and one debit. Each voucher gets the next number of the series you chose, and P-01 and P-02 are kept as their references. If P-02 had a second C row, or its rows did not add up, the grid would mark it in error and nothing would be saved until you correct it.

What is checked

Check	Message
A voucher does not balance	Debit and credit amount should be same (with the voucher's date and number)
A payment has not exactly one credit row and at least one debit row (or the reverse for a receipt)	Data not imported, Please see error list
A row has no date, number, ledger, amount or amount type	Data not imported, Please see error list
No series chosen	A required field is empty
Nothing to save	Please provide data details to save the transaction.