June 12, 2026 · 5 min read
How to Prepare Bank Statement CSV Files for Xero
A bookkeeping workflow for turning PDF bank statements into clean CSV rows that can be reviewed before Xero import preparation.
Extract the transaction rows
Start by converting each PDF statement into structured rows. The basic fields to review are date, description, debit, credit, and balance.
Check column consistency
Before preparing data for Xero, make sure credits and debits are consistently represented. Mixed signs or merged amount columns can cause reconciliation problems later.
Use warnings as a review queue
Warnings are not failures. They are a checklist of rows that need human review before the CSV becomes part of a bookkeeping workflow.