Match the import columns
Most accounting systems need date, description, amount, debit, credit, and reference fields. Some systems want one signed amount column. Others want debit and credit split.
Export the format your accounting tool expects, then map the columns during import.
Clean references before import
Bank descriptions often include IBG, DuitNow, cheque, merchant, and loan references in one field. A clean export keeps the original description and separates references when the bank layout allows it.
Bridge to Imbangan and client workflows
Use CSV when your accounting workflow already has import templates. Use Excel when a client, reviewer, or accountant needs to approve the rows first.
Checklist
Use this workflow
- 01Convert the bank PDF to CSV or Excel.
- 02Confirm date format and amount signs.
- 03Map columns inside the accounting software.
- 04Import a small batch first.
- 05Reconcile against the bank balance.