Philippines: import a bank statement into Xero
Where a CSV bank statement enters Xero, from the Accounting menu to Complete import, and the ExtractPro choices that give it MM/DD/YYYY dates.
Xero Central’s CSV article asks for little: “You only need the Date and Amount fields to create bank statement lines, but reconciling your transactions is easier if you include more detail.” Source: Import a bank statement in CSV format – Xero Central, central.xero.com/s/article/Import-a-CSV-bank-statement, accessed 16 October 2026.
Accounting menu, Bank accounts
“In the Accounting menu, select Bank accounts.” The account’s own menu holds the next step: “select Import a Statement.” Source: Import a bank statement in CSV format – Xero Central, central.xero.com/s/article/Import-a-CSV-bank-statement, accessed 16 October 2026.
File to upload
“In File to upload, drag and drop a file or click Select file to choose a file from your computer, then click Next.” The CSV is written from the converted statement in ExtractPro:
- 1Output format: See more formats or customize, then Custom.
- 2File type: CSV.
- 3Date format: MM/DD/YYYY (01/15/2026).
- 4Amounts: Single column (signed).
- 5Include balance: Add Balance column unchecked, and Categories unchecked.
- 6CSV separator: Comma (,). Number format: No thousands separator (1234.56).
- 7Apply format, then download the CSV.
Amounts, balances and the row limit
On signs and decimals the article says “Show income as positive amounts and expenses as negative amounts using a negative sign in front of the amount or with brackets, for example -30.00 or (30.00). Don't use commas to show decimal places.” On balances it names “Columns containing opening and closing balances, as Xero calculates the bank balance from the transactions”. On size it says “You can’t import a CSV file with more than 100,000 rows.” Source: Import a bank statement in CSV format – Xero Central, central.xero.com/s/article/Import-a-CSV-bank-statement, accessed 16 October 2026.
Fields to assign
“If prompted, assign the columns in your import file to the matching bank statement fields in Xero, then click Next.” Of those fields, “The Transaction Date and Transaction Amount fields must be assigned to columns from your CSV file.” Source: Import a bank statement in CSV format – Xero Central, central.xero.com/s/article/Import-a-CSV-bank-statement, accessed 16 October 2026.
The date format prompt
For dates the article offers a choice: “For all dates, use one of the following date formats” is followed by three, and the second is “MM/DD/YYYY (eg 01/15/2023)”. The next prompt is “If prompted, select the date format used in your bank statement, then click Next.” Source: Import a bank statement in CSV format – Xero Central, central.xero.com/s/article/Import-a-CSV-bank-statement, accessed 16 October 2026.
Review, then Complete import
“Review the imported transactions and clear the checkbox next to any transaction you don’t want to import.” After the review comes “Click Complete import.” Source: Import a bank statement in CSV format – Xero Central, central.xero.com/s/article/Import-a-CSV-bank-statement, accessed 16 October 2026.
Frequently asked questions
The questions that come up most:
Frequently asked questions
Can income and expenses go in separate columns for Xero?
Not in Xero’s CSV import. The article says “Amount – Both income and expense amounts must be in the same column.”
Convert your first statement, free
Nothing to install, no card. Upload the PDF and download an Excel file with one transaction per row.
Try for free