Xero
How to import DanScan transactions into Xero
This page is provided in English.
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
- Only documents with an amount are included, so ask clients to enter the amount when they upload.
- Expenses are exported as negative amounts and sales reports as positive amounts.
- Xero imports up to 1,000 lines at a time. For larger folders, export one month at a time.
Step 1. Export from DanScan
- Sign in to DanScan and open the client's folder.
- Filter by category or month if needed.
- 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
- In Xero, open the bank account you want to import into.
- Choose Import a statement, browse to the DanScan file and select Import.
- On the import options screen, check that Date is assigned to Transaction Date, Amount to Transaction Amount, Description to Description and Reference to Reference.
- Set the date format to MM/DD/YYYY and tick the option to skip the first line, since it contains the column headings.
- 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