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.