Convert a bank statement to CSV for QuickBooks & Xero
If your bank doesn't offer a CSV download — or only goes back a few months — you can build the import file yourself from the PDF statement. Here's how to get the columns right.
What accounting tools expect
QuickBooks, Xero, Wave and most others import a simple CSV with, at minimum, three columns:
- Date — one consistent format (e.g.
2024-03-01). Mixed formats are the #1 cause of failed imports. - Description — the payee / memo text.
- Amount — a single signed column (debits negative, credits positive), or sometimes separate Debit/Credit columns.
A Balance column is optional and usually ignored on import, but it's handy for checking your work.
Step 1 — Get a clean table out of the PDF
Open the LINGYANG converter and drop in your statement. It reads the PDF on your device and detects the Date, Description, Amount and Balance columns. Crucially, it produces one signed Amount column and a single consistent date format — exactly what importers want.
Build your import file in under a minute. No upload, no signup.
Open the converter →Step 2 — Review and fix
Scan the detected rows. Remove any header or summary lines that slipped in, confirm the signs (money out negative, money in positive), and check the running balance matches the statement. Editing happens right in the table before you export.
Step 3 — Export to CSV
Choose CSV and download. You'll get a tidy file with Date, Description, Amount, Balance headers.
Step 4 — Import into your accounting tool
- QuickBooks Online: Transactions → Bank transactions → Upload from file → map Date / Description / Amount.
- Xero: Accounting → Bank accounts → Manage account → Import a statement → map the columns.
- Wave / others: look for "Upload statement" or "Import transactions" and map the same three columns.
If an import is rejected, it's almost always a date-format mismatch — re-export with the date style your tool expects and try again.
Why on-device matters here
Bookkeepers convert clients' statements. Doing it in the browser means the client's file never touches a third-party server, so you stay on the right side of confidentiality while still getting a clean import file. Try it free →
Key takeaways
The cleanest accounting CSV uses one signed Amount column, normalized dates, plain-text descriptions and no formula-like cells that spreadsheet tools could execute.
- Most accounting imports expect consistent dates and one signed amount column.
- Payments, deposits and fees should keep their signs after export.
- Formula-like descriptions must be escaped so spreadsheets treat them as text.
- Always import a small sample first before committing a full month or year.
Before you export
- Prefer a text-based PDF downloaded directly from online banking.
- Review dates, descriptions, signs, amounts and balances against the original statement.
- Export a small sample first if you plan to import into accounting software.
- Keep statement contents in Local Mode when privacy, client confidentiality or compliance matters.
Frequently asked questions
Should I export CSV or QBO?
Use CSV when your accounting tool has a flexible importer. Use QBO when you specifically need QuickBooks Web Connect.
What columns should the CSV include?
At minimum: Date, Description and Amount. Balance, reference and account columns are useful for review.
Can LINGYANG export Xero-ready files?
Yes. The statement converter can export spreadsheet formats and accounting-oriented files including Xero CSV.
Next step: The cleanest accounting CSV uses one signed Amount column, normalized dates, plain-text descriptions and no formula-like cells that spreadsheet tools could execute.
Open the CSV workflow →