Search intent: Users need a reliable CSV from PDF statements for Xero reconciliation.

Xero bank statement imports work best when the CSV has clean dates, clear descriptions, and predictable amount columns. If your bank only provides PDFs, the conversion step should be followed by cleanup and review before the file is imported.

In this guide
What Xero needs from a statement CSV How to reduce reconciliation work Before importing to Xero Step-by-step workflow Practical checklist Common mistakes FAQ

What Xero needs from a statement CSV

Xero imports depend on consistent dates, descriptions, and amount values. A file that mixes formats or contains OCR mistakes will slow down reconciliation because the user has to correct problems after import.

A good conversion workflow should prepare the CSV before it reaches Xero: clean merchant labels, confirm withdrawals and deposits, remove duplicate periods, and flag unclear rows.

How to reduce reconciliation work

The fastest workflow is to review the statement in a transaction workspace before importing. Use filters for missing categories, recurring vendors, possible duplicates, and unusual amounts.

If the same vendors appear every month, saved categorization rules can turn repeated cleanup into a review step instead of manual typing.

Before importing to Xero

Check that the statement date range does not overlap with a bank feed already connected in Xero. If the same period already exists, import only the missing dates or skip the duplicate statement.

For accountant handoff, include notes about personal expenses, reimbursable costs, missing receipts, and any transactions that require client confirmation.

Step-by-step workflow

1
Convert the PDF statement into extracted transactions.
2
Review date and amount columns for consistency.
3
Clean descriptions and merchant names.
4
Apply categories or saved import profile preferences.
5
Review missing receipts and recurring vendor groups.
6
Export a Xero-ready CSV or accountant CSV.
7
Import into Xero and reconcile against the bank statement.

Practical checklist

No duplicate statement periods.
Opening and closing date range is clear.
Descriptions are readable enough for matching.
Amounts use the expected sign style.
Unclear rows are noted before handoff.

Common mistakes to avoid

Importing a statement period already covered by a live bank feed.
Using a CSV format that does not match Xero import mapping.
Leaving subscriptions and recurring vendors unreviewed.

FAQ

Can I convert old PDF statements for Xero catch-up bookkeeping?
Yes. Convert each statement period, check for overlap, then import only the periods missing from the Xero file.
What if a bank statement has pending transactions?
Avoid importing pending rows unless they are confirmed on the final statement. Pending rows often create reconciliation mismatches.
Should I categorize before or after Xero import?
For simple files you can categorize in Xero. For messy PDF conversions, categorizing before export often saves time and reduces import errors.

Prepare the file before it reaches accounting software

Use the converter to prepare a Xero-ready CSV, then upgrade for rules, receipts, and audit readiness.

Convert a statement Compare plans