Bank statements
Bank statement PDF to Xero CSV
Turn PDF bank statements into reviewable CSV rows for Xero imports when the bank only gives you statement PDFs or limited CSV history.
When Xero users end up with statement PDFs
The common trigger is historical cleanup. The bank feed does not go back far enough, the bank only exports recent CSV, or the client has a closed account archive where the remaining history is stored as monthly PDFs.
Shape the CSV for Xero review and mapping
Xero's manual import flow lets users map CSV columns to statement fields. A dependable first pass is to keep a transaction date, a readable payee or description field, and one signed amount column. Some Xero setups also keep an optional reference field, but the critical cleanup check is still whether the rows are transaction-only and the amounts are numeric.
- Date
- Payee or Description
- Amount
- Optional reference for cleaner reconciliation
Keep the import review-first
Review before import matters just as much for Xero as it does for QuickBooks. Users should compare row count against the statement, confirm money out stays negative and money in stays positive, and remove summaries, running balances, or card-subaccount noise that should not become statement lines.
Trust and file-quality guidance
Original PDFs work best, but clear scans and phone photos can still be tested if the transaction table is readable. No bank login is required for DocuRows, and redacted files are fine as long as transaction dates, text, and amounts remain visible.
Xero-ready review example
Date,Payee,Amount,Reference 2026-04-02,ACH PAYMENT ACME SUPPLY,-128.44,APR-2026 page 2 2026-04-03,CLIENT DEPOSIT,2400.00,APR-2026 page 2 2026-04-04,MONTHLY SERVICE FEE,-12.00,APR-2026 page 3
This is a reviewable CSV shape, not a promise that every Xero account uses the exact same column mapping. Confirm the mapping in Xero before import.
FAQ
Does Xero need one Amount column or separate debit and credit columns?
Xero's own CSV guidance centers on a clean amount field and correct mapping. A single signed Amount column is the safest review shape unless the specific import template you use asks for something else.
Can I upload a scanned statement instead of an original PDF?
Yes, if the transaction table is readable. Scans and photos just need more review because OCR can blur dates, wrapped descriptions, and signs.
Can I redact account numbers before testing?
Yes. Redacted files are fine as long as the transaction rows remain visible.
Turn a statement file into reviewable rows
Upload a PDF, scan, screenshot, or clear photo and review the rows before downloading CSV.