Convert a PDF bank statement for Xero

If your bank offers a usable CSV or OFX export, you may be able to import that directly into Xero. For US and Canadian Xero organisations, native PDF import may also cover the job. Our regional import guide explains that option.

StatementClear helps when the PDF is the useful record you have, the spreadsheet export needs cleaning up, or you want to review and send recurring statements from the same place.

1. 1

   Upload the statement

   Choose the PDF downloaded from your bank, or use a CSV or Excel export. Start with one account and one currency so the output has a clear destination. A digital PDF usually gives cleaner source material than a scan.

2. 2

   Review the extracted transactions

   Check the first and last dates, the number of rows and the money in and out. Compare against the original statement. Balance checks are available where the source supplies balance figures; a passed check doesn't replace review of the document.

3. 3

   Choose direct delivery or CSV

   Create your free account to finish. For direct delivery, authorise Xero, select the organisation and eligible bank account, and review the posting preview. Choose CSV for older history or if you prefer to import the file yourself.

4. 4

   Finish reconciliation in Xero

   Confirm that the expected period has arrived, then reconcile in Xero. Check any overlap with native feeds or earlier manual imports. A file arriving in Xero isn't the same as the account being fully reconciled.

StatementClear normalises dates and amounts, checks signs and uses available balance data to flag inconsistencies. Saved mappings help with repeat CSV and Excel exports. Overlap checks compare against previous uploads to the same StatementClear feed.

Those checks don't provide a complete view of lines delivered by other applications or native bank feeds. Pick the missing date range carefully and compare it with Xero before importing. If a scan is faint, cut off or ambiguous, correct the source or extracted values before completing the job.

Complete your first statement free, with no card required. For a bigger one-off job, the founder-assisted catch-up offer is £19 for a batch agreed in advance. Recurring plans start at £19 per month for one organisation and one feed, with unlimited statements.

Choose monthly or yearly billing for recurring imports, or contact us to agree a one-off batch. See the plans and request catch-up help.