← All help articles

Xero

How to import DanScan transactions into Xero

Updated October 30, 2026

DanScan exports a CSV file in the column layout of Xero's statement import template, so you can bring a client's receipts and sales reports into Xero without retyping them.

Before you start

Step 1. Export from DanScan

  1. Sign in to DanScan and open the client's folder.
  2. Filter by category or month if needed.
  3. Select Export for Xero. The file has the columns Date, Amount, Payee, Description and Reference. The category is placed in Reference.

Step 2. Import into Xero

  1. In Xero, open the bank account you want to import into.
  2. Choose Import a statement, browse to the DanScan file and select Import.
  3. On the import options screen, check that Date is assigned to Transaction Date, Amount to Transaction Amount, Description to Description and Reference to Reference.
  4. Set the date format to MM/DD/YYYY and tick the option to skip the first line, since it contains the column headings.
  5. Save. The lines appear on the Reconcile tab, ready to match.

If your screen looks different, search Xero Central for "import a bank statement."

Xero is a trademark of Xero Limited. DanScan is not affiliated with Xero.

Try DanScan free for 14 days

A private, secure folder for every client. No credit card needed.

Start your free trial