Prepare a converted statement for a
Xero import workflow
Check Xero’s current template before import
Target outcome
A reviewed CSV with the source period and transaction direction checked.
Do not edit the only clean copy.
Download the reviewed ReconReady CSV, preserve it as the conversion output, and create a separate working copy for Xero. That keeps mapping changes traceable.
File lineage
Check the structure before the import.
Product requirements change. Use this as a control list, then compare it with Xero’s current help or sample file.
- 01Download or inspect Xero’s current statement-import example
- 02Match required columns and accepted date formats
- 03Check the positive and negative amount convention
- 04Remove summary rows and repeated headers
- 05Import a small period and compare the bank balance
A small test catches expensive mistakes.
Import one short period first. Compare the first date, last date, transaction count, movement total, and resulting bank balance with the PDF before continuing.
First and last date
01Transaction count
02Amount direction
03Description mapping
04Ending balance
05Duplicate check
06Guidance without false shortcuts.
Which bank supplied the PDF?
Prepare the source before Xero.
Convert the PDF, review the rows, and preserve a clean export before destination-specific mapping.