Import Journal

The Import Journal feature allows users to upload transaction data in bulk in .csv format instead of entering transactions manually one by one.

Column	Data Type	Description
date	datetime	required The recorded transaction date. e.g. 2026-01-01 12:00:00
form_number	string	required The transaction identity. e.g. INVOICE/202601/0001
coa_number	string	required The chart of account number. e.g. 100.01
coa_name	string	required The chart of account name. e.g. Cash
subledger	string	The subledger references of the transaction. e.g. Supplier Name for Account Payable, Customer Name for Account Receivable
description	description	required The description about the transaction
debit	number	required-if credit: 0 The debit amount
credit	number	required-if debit: 0 The credit amount

Excel Template

• Download Excel Template
• Download Excel Sample

Scenarios

• Success Scenarios
  • 4.1.S1. User can import journals successfully.
• Failure Scenarios
  • 4.1.F1. Journal import fails when user is not authenticated.
  • 4.1.F2. Journal import fails when required fields are empty.
  • 4.1.F3. Journal import fails when COA number or COA name does not match any record.
  • 4.1.F4. Journal import fails when debit and credit amounts are not balanced.
  • 4.1.F5. Journal import fails when the date format is invalid.
  • 4.1.F6. Journal import fails when rows with the same form number contain different dates.