DocuClipper logo
Integrations

Import Bank Statement Transactions into Xero

Export bank statement transactions from DocuClipper as a Xero-ready CSV and import them into a Xero bank account.

Last updated

DocuClipper moves transactions from a converted bank statement into Xero two ways:

  • Xero CSV - download a Xero-ready CSV and import it into a bank account. No column remapping required.
  • Xero Direct Sync - push transactions straight into a Xero bank account over the Xero API, no file download. See Option B below.

Step 1: Download the Xero CSV

Download Data modal with the Output Format dropdown expanded, showing Xero CSV and Xero Direct Sync among the export options

  1. Open the project containing your converted bank statement.
  2. Click Download Data (above the Summary of Reconciliation).
  3. Under Output Format, choose Xero CSV.
  4. The default columns (Date, Description, Amount) match what Xero expects. Leave them as-is unless you have a specific reason to change.
  5. If the project holds more than one account (say, a checking account and a credit card), leave Download separate files for each account ticked. Xero imports a statement file into one bank account, so DocuClipper downloads a .zip with one CSV per account, named after the account number. Extract it first.
  6. Click Download.

Download your data dialog with Output Format set to Xero CSV for a project holding a checking account and a credit card: a note that DocuClipper detected 2 accounts and will download a zip file with one file per account, and the Download separate files for each account checkbox, ticked

Step 2: Import into Xero

  1. In Xero, go to Accounting → Bank accounts → select the account you want to import into.
  2. Click Manage account → Import a statement.
  3. Upload the CSV from step 1. With several accounts, upload each account's CSV into its own bank account.
  4. Xero shows a column-mapping preview. Since this is a Xero-format CSV, all columns are pre-mapped. Click Save.
  5. Xero imports the transactions into the bank's Reconcile tab.

Step 3: Reconcile in Xero

Imported transactions appear in the Reconcile tab with green OK buttons wherever Xero can match them to an existing contact or rule. Anything unmatched gets a Create button where you can code it on the fly.

Option B: Xero Direct Sync

If you'd rather skip the CSV entirely, push transactions straight into a Xero bank account over the Xero API.

  1. Open the project, click Download Data, and under Output Format choose Xero Direct Sync.
  2. If you haven't connected Xero yet, click Connect Xero Account and authorize DocuClipper. You'll return to this panel afterward.
  3. Pick the Xero Account (organization) and the Destination Bank Account to sync into.
  4. Click Sync to Xero. A large sync can take a few minutes (a few thousand transactions take around ten); it keeps running in the background until every transaction is handled, even if you close the window.

One sync runs at a time for each Xero organization. If you click Sync to Xero while an earlier sync to that organization is still running, DocuClipper tells you so instead of starting a second one; wait a few minutes and click it again to see the result.

When the sync finishes, the Sync Complete panel accounts for every transaction it found:

CountWhat it means
FoundTransactions in the documents you selected. Always equals the four counts below added together.
SyncedCreated in your Xero bank account by this sync.
Already in XeroSent by an earlier sync, so skipped this time.
SkippedNot sent: transactions you excluded in DocuClipper, and transactions with a zero amount, which Xero does not accept. The panel lists how many of each.
FailedSent, but Xero did not create them. The panel lists Xero's reason for each, and the Retry button under them (for example, Retry 4 failed transactions) sends just those again.

Direct Sync records each transaction the moment Xero creates it, and never sends a transaction that is already in Xero, so re-running the same period, or retrying after a failure, does not create duplicates. If Xero is briefly busy or the connection drops mid-sync, DocuClipper retries automatically in a way Xero recognises as the same request, so a retry never creates a transaction twice. Transactions you excluded in the Transactions view are not sent. Nothing downloads to your computer.

If Xero rejects a transaction (for example, its category maps to an account code Xero does not accept), fix the cause in DocuClipper, then click the Retry button in the panel.

The Sync Complete panel after a sync where 4 transactions failed: Found 27, Synced 21, Already in Xero 0, Skipped 2, Failed 4, with Xero's reasons listed under Why Xero did not create them and a Retry 4 failed transactions button

What Direct Sync creates in Xero

Direct Sync creates each transaction as a Spend Money or Receive Money bank transaction on the destination bank account, coded to its category (or your default account). In Xero they appear under the bank account's Account Transactions and count toward Balance in Xero.

They are not bank statement lines. Xero's Statement Balance, the Bank statements tab and the Reconcile tab are built only from statement lines, which come from a bank feed or an imported statement file.

Direct Sync cannot set or change Xero's Statement Balance. Xero does not let connected apps such as DocuClipper add statement lines or statement balances; only bank feeds and statement imports can. After a sync the Statement Balance stays where your last bank feed or statement import left it, and uploading the statement's summary page to DocuClipper has no effect on it.

What to do depends on what you need in Xero:

  • You need the Statement Balance and the Reconcile tab (the usual bookkeeping workflow): use the Xero CSV instead of Direct Sync. Download it and import it with Manage account → Import a statement (see Step 2), then reconcile each line in the Reconcile tab, where you can also code transfers between your accounts.
  • You already ran Direct Sync for those dates: import the Xero CSV for the same statements as well. In the Reconcile tab, click Match (not Create) on each statement line to pair it with the transaction Direct Sync created; Create would add a second copy. If the account already has a bank feed for those dates, skip the import: the feed's statement lines match the synced transactions the same way.

A statement imported from a CSV file has no opening or closing balance, so the Bank statements tab shows 0.00 for it. Xero's Statement Balance is the account's opening balance plus every statement line, so it is right when each day is imported exactly once. Import only dates that are not already in Xero: if a new import overlaps a period that is already there (say, months your bookkeeper imported earlier), those lines count twice. Delete the overlapping statement in the Bank statements tab and import the file again without those dates.

Download Data modal with Xero Direct Sync selected. Until a Xero organization is connected, the panel shows a Connect Xero Account prompt; after connecting, the Xero Account and Destination Bank Account selectors and the Sync to Xero button appear here

The Sync Complete panel after a Xero Direct Sync: Found 195, Synced 186, Already in Xero 0, Skipped 9, Failed 0, with the skipped transactions explained as 6 excluded in DocuClipper and 3 with a zero amount

Date format tips

Xero respects the date format set on your organization. If Xero flags dates as invalid:

  • Make sure the Xero CSV uses your Xero org's date format. Xero CSV writes dates in your team's saved export date format, the one picked in the Date Format dropdown under Excel, and the dialog's preview shows them as they will appear in the file. To change it, set Output Format to Excel once and pick the format; every later Xero CSV download uses it. See Customize Date Format.
  • For UK / AU / NZ Xero orgs, use DD/MM/YYYY. For US orgs, use MM/DD/YYYY.

Duplicates

Import each period once. Xero adds every line of an imported file as a statement line, so importing a period that is already in Xero (from an earlier import or a bank feed) counts those lines twice and throws off the Statement Balance. If that happens, delete the duplicate statement in the bank account's Bank statements tab and import again with only the missing dates. Direct Sync is different: it never sends a transaction twice.

Tips

FAQs

Should I use Xero CSV or Xero Direct Sync?

Choose the Xero CSV if you reconcile the account in Xero: only an imported statement gives Xero statement lines, a Statement Balance and the Reconcile tab. Choose Direct Sync when you just need the transactions in the account's ledger with no file to download or import; it creates Spend Money and Receive Money transactions and leaves the Statement Balance unchanged.

Do I have to map columns when importing the CSV into Xero?

No. The Xero CSV already uses the columns Xero expects (Date, Description, Amount), so the mapping preview comes through pre-filled.

Is it safe to re-run Direct Sync on the same period?

Yes. Direct Sync skips transactions that are already in Xero, so re-running won't create duplicates.

What if a sync is interrupted or some transactions fail?

Nothing is lost or doubled. Every transaction is recorded as soon as Xero creates it, short outages are retried automatically, and the Sync Complete panel shows how many failed and why. Click the Retry button (or Sync to Xero again) to send only the ones that are not in Xero yet.

Why is Synced lower than Found?

Found counts every transaction in the documents you selected. Some of them are not sent: transactions already synced earlier, transactions you excluded in DocuClipper, and transactions with a zero amount, which Xero does not accept. The Sync Complete panel shows each of these counts, so Found always equals Synced plus Already in Xero, Skipped, and Failed.

Can I sync to more than one Xero organization?

Yes. Pick the Xero Account (organization) and the destination bank account each time you sync. See Connecting multiple QuickBooks and Xero accounts.

Where do the transactions land in Xero?

It depends on the method. An imported Xero CSV becomes statement lines in the bank account's Reconcile tab, with green OK buttons where Xero can match them to an existing contact or rule, and Create where it can't. Direct Sync creates Spend Money and Receive Money transactions under Account Transactions; see What Direct Sync creates in Xero.

Can Direct Sync set Xero's Statement Balance?

No. Statement Balance only counts statement lines from a bank feed or an imported statement, and Xero does not let apps create those. Direct Sync creates bank transactions, which count toward Balance in Xero instead. To bring statement lines in, import the Xero CSV for the same statements, then Match them to the synced transactions in the Reconcile tab. See What Direct Sync creates in Xero.

Why does my imported statement show 0.00 as its start and end balance?

A CSV file carries transactions but no balances, so Xero lists the imported statement with 0.00 balances. Xero still adds its lines to the Statement Balance. If the Statement Balance looks wrong, check for dates that were imported twice (see Duplicates).