Statements that print 1.234,56 or 1 234,56, into Xero

Xero’s CSV import doesn’t accept a comma as the decimal mark, and it wants one signed amount per line. Statements from many countries print amounts as 1.234,56, 1 234,56 or R 1 234,56, with dates like 03.03.2026. Fixing that by hand in a spreadsheet is slow, and a find-and-replace on commas is easy to get wrong.

How Carrytick reads the amounts

• The separator two digits from the end is the decimal mark, and every other separator (dot, comma, space, no-break space, apostrophe) is grouping. So 1.234,56, 1 234,56, 1,234.56 and 1'234.56 all become 1234.56.
• Currency marks before or after the number are removed: €, £, R, $ and codes such as EUR, ZAR, GBP, SGD, CHF.
• Negative amounts in brackets, with a minus sign or with a DR suffix are all understood.
• Dates in dd.mm.yyyy, dd/mm/yyyy, yyyy-mm-dd and “03 Mar 2026” are recognised, and the Xero file uses dd/mm/yyyy.

Carrytick works out the number format from all the amounts on the statement, and every row is then checked against the printed running balance. If a number was read the wrong way, the balance check fails on that row and you see it before importing.

Output

A Xero bank statement CSV (Date, Amount, Payee, Description, Reference) with plain 1234.56 amounts, or QuickBooks Online CSV. Text PDFs only; nothing is uploaded.

More guides

• Xero bank statement CSV import format, explained
• Convert UK bank statement PDFs to Xero CSV
• Convert Australian and NZ bank statement PDFs to Xero CSV
• Check a run of bank statements for missing pages and months

Carrytick is independent and not affiliated with or endorsed by Xero. Xero is a trademark of Xero Limited.