Can I import converted statements into Xero or QuickBooks?

Yes. Use the Xero bank statement CSV preset (signed amount column) or the QuickBooks bank CSV preset (Date, Description, Credit, Debit) from the export menu, then run the import inside your accounting software.

Do you support AutoCount and SQL Accounting?

The AutoCount-ready and SQL Accounting-ready presets arrange columns (DD/MM/YYYY dates, DR/CR amounts, reference field) to match those systems' bank-transaction import grids. Check the mapping on your first import — column names can vary by version.

Should I use CSV or Excel for imports?

Use CSV for direct imports. Use Excel when you need review, tagging, or cleanup before import.

Import Bank Statement to Accounting Software

Pick an export preset instead of remapping columns

The export menu on every conversion includes accounting presets. The Xero preset produces a bank statement CSV with Date (DD/MM/YYYY), a signed Amount column (money in positive, money out negative), Description, and Reference — the layout Xero's bank statement import expects. The QuickBooks preset uses the four-column bank format: Date, Description, Credit, Debit.

For Malaysian desktop systems, the AutoCount-ready preset exports Date, Description, Ref No, Debit, and Credit, and the SQL Accounting-ready preset exports Date, Description, Reference, DR, and CR — so the columns line up with the import grids those systems show. Verify the mapping on your first import, then reuse it every month.

Match the import columns

If your system is not covered by a preset, use generic CSV. Most accounting systems need date, description, amount, debit, credit, and reference fields. Some want one signed amount column; others want debit and credit split. Export, 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.

CSV or Excel?

Use CSV when your accounting workflow already has import templates. Use Excel when a client, reviewer, or accountant needs to approve the rows first.

Step by step

How to do it

01
Convert the PDF
Upload the bank statement PDF and review the extracted rows.
02
Pick an export preset
Choose Xero, QuickBooks, AutoCount, SQL Accounting, or generic CSV.
03
Confirm the mapping
Check date format and debit/credit signs match your accounting system.
04
Import a test batch
Import a small batch first, then reconcile against the bank balance.

Checklist

Use this workflow

01Convert the bank PDF and review the extracted rows.
02Pick the export preset for your accounting software, or generic CSV.
03Confirm date format and amount signs.
04Import a small batch first and verify the column mapping.
05Reconcile against the bank balance.

Import Bank Statements to Accounting Software

Convert a statement now