Prepare, review, then import in Xero

How to Import a Bank Statement to Xero

BSC can produce a generic CSV from a statement that converts successfully. It does not connect to Xero or confirm the final import. Review the converted data, then follow Xero current import documentation and map the file inside your own organization.

  • Generic CSV preparation
  • Manual Xero import
  • No direct synchronization

Start with a reviewed conversion

This guide does not create a second upload flow. Use the linked real tool, then return to the instructions.

Bank statement to CSV

Review the statement data first

A CSV can be structurally valid and still be wrong for a particular ledger. Reconcile it before using Xero.

Check opening and running context

Use the original statement to understand the period and any printed balance information.

Check transactions

Compare dates, descriptions, amounts, direction and the total number of rows.

Keep a clean copy

Save the original BSC download before adapting headers or signs for the Xero import.

Complete the import in Xero

Xero controls supported formats and the import interface. Use the official page linked below for the current requirements.

Open the correct bank account

Make sure the destination account and statement period are correct.

Upload and map the CSV

Match the date, description and amount fields shown by Xero.

Inspect the preview

Stop if signs, dates or rows do not match the source statement.

How to complete this task safely

  1. 1

    Produce a validated CSV

    Convert one PDF and download the result only after required checks pass.

  2. 2

    Reconcile the file

    Compare the CSV with the statement and adapt only what the Xero format requires.

  3. 3

    Import through Xero

    Follow Xero current instructions, map columns and review the preview before completion.

Limits and failure boundaries

  • BSC does not connect to Xero or create transactions in a Xero organization.
  • A generic BSC CSV may require column mapping or controlled editing.
  • Xero is the authority for current accepted formats and import behavior.

Safe usage rule

Keep the original PDF and compare the transaction count, dates, descriptions, amount direction and balances before relying on any converted file. A successful download is not a substitute for your own financial review.

Xero: import data into XeroCurrent supported statement formats and import guidance from Xero.

Frequently asked questions

Can BSC send transactions directly to Xero?

No. BSC provides downloadable files only. The final import happens manually in your Xero account.

Which BSC format should I start with?

Use the CSV download for a simple table, then check Xero current official format requirements and map it carefully.

How do I avoid duplicate transactions?

Check the statement period, destination account and Xero preview before adding records. BSC cannot see existing Xero transactions.

What if the converted file has an unresolved row?

Do not import it. Return to the original statement and resolve the source or conversion issue first.

Start with a reviewed statement file

Keep the source statement, review the converted rows, and stop whenever the evidence is not clear enough for a safe result.

Bank statement to CSV