Import Journal Excel

Expected Excel Format

Upload the General Journal Excel file exported from your ERP. The system expects:

  • A header row containing: Date, Particulars, Account Code, Voucher, Voucher No, Debit(TK), Credit(TK)
  • Sub-ledger row immediately after each entry line:
    Subledger : [Name], Amount : TK …
  • All narration rows (Paid to…, Sales as per…) are skipped automatically

⚠️ Account codes in the Excel must already exist in the Chart of Accounts. Run seed_coa.py first if you haven't.

Back to Journal