DocuClipper logo
Bank Statements

Downloading Bank Transactions

Download converted bank transactions from the Transactions view and export to any supported format - Excel, CSV, QBO, IIF, QIF, OFX, QFX, Xero, Sage, MYOB, Relate, or NetSuite - with custom columns and date formats.

Last updated

DocuClipper exports converted bank transactions to Excel (.xlsx), CSV, QuickBooks Web Connect (.qbo), QuickBooks Desktop IIF, Quicken QIF, OFX, QFX, Xero, Sage, MYOB, Relate, and NetSuite from the Download Data button in the top-right of any project's transactions view.

Inside the download dialog you choose the sort order, which uploaded statements to include, and the output format. The options below the format depend on the format you pick: Excel gives you column sets, a CSV or XLSX file type, a date format and two Advanced Options, while QuickBooks (Web Connect), QFX and OFX ask for the bank account details. QuickBooks (Web Connect), QFX, OFX, the accounting-app CSV formats (Xero, Sage, MYOB, Relate, NetSuite, QIF) and your saved custom formats also ask, when your selection holds more than one account, whether to download one file per account.

How do I open the DocuClipper download dialog?

  1. Open the project containing your converted statement(s).
  2. Click Download Data in the top-right of the transactions view.
  3. Pick an Output Format, set its options, and click the download button at the bottom of the dialog. The button stays in view at the bottom of your screen while you scroll through the options and the preview.

The Download your data dialog with Output Format set to Excel and All columns: File Type CSV or XLSX, the Date Format dropdown open on DD/MM/YYYY, MM/DD/YYYY and YYYY-MM-DD and outlined in red with the note "Pick the format your Excel region uses", Advanced Options with Split multiline descriptions into separate columns and Include statement summary (period dates + balances), and a preview of the first rows

Download options

These options are at the top of the dialog:

OptionWhat it controls
Active FiltersThe filters set on the transactions table. Excel, Xero CSV, Sage, MYOB, Relate, NetSuite and QIF downloads contain only the rows that match them.
Sort ByDate, or Original Document Order (the order the rows appear on the statement). Applies to the same formats as Active Filters.
Sort DirectionAscending or Descending.
DocumentsWhich uploaded statements to include in the export.
Output FormatExcel, QuickBooks (Web Connect), OFX, QFX, Xero CSV, Xero Direct Sync, Sage Cloud CSV, Sage CSV, MYOB CSV, Relate CSV, QuickBooks Desktop IIF, Quicken QIF, or NetSuite.

QuickBooks (Web Connect), OFX, QFX, QuickBooks Desktop IIF and Xero Direct Sync always send every included transaction of the selected documents, in date order, because the destination sorts and matches them itself. Excluded rows (the Included switch turned off on the transactions table) are never part of a download in any format.

Options for each format

Output FormatOptions in the dialog
ExcelA column set (All columns, Basic - date, description, amount, or a saved custom format), File Type (CSV or XLSX), Date Format, and Advanced Options: Split multiline descriptions into separate columns and Include statement summary (period dates + balances), which puts a summary block above each statement period, with each file's periods in date order. A preview of the first rows. Every account in your selection goes into one file; with a saved custom format and more than one account, you can tick Download separate files for each account instead (unticked by default). On a credit card statement with several cards, All columns and Basic - date, description, amount add a cardholder column (see Credit Card Statements With Multiple Cardholders). When you added or corrected transactions by hand in the transactions view, both column sets end with a source column that marks those rows added by hand or edited by hand; rows read from the statement are left blank.
QuickBooks (Web Connect)Bank, Account type (Checking / Savings or Credit Card), Routing number (checking only), Account number, Currency. Download separate files for each account when the selection holds more than one account (ticked by default).
OFX, QFXThe same as QuickBooks (Web Connect), without the Bank field.
Xero CSV, Sage CSV, Sage Cloud CSV, MYOB CSV, Relate CSV, NetSuiteA fixed column list for that destination, shown as Columns:, and a preview of the first rows. Download separate files for each account when the selection holds more than one account (ticked by default), because each of these apps imports a file into one bank account.
QuickBooks Desktop IIFQuickBooks Desktop Edition (United States or Canada), Source Account, Source Account Type, and the destination (map to transaction category or use a fixed account name). See IIF for QuickBooks Desktop.
Quicken QIFDownload separate files for each account when the selection holds more than one account (ticked by default).
Xero Direct SyncThe connected Xero Account and the Destination Bank Account. See Import into Xero.

The Date Format dropdown offers DD/MM/YYYY, MM/DD/YYYY and YYYY-MM-DD. A team admin's choice is saved for everyone on the team, and every format that writes dates in a chosen format uses it: Excel, Xero CSV, Sage CSV, Sage Cloud CSV, MYOB CSV and Relate CSV. See Customize Date Format.

The preview shows the first rows as the file will hold them: the chosen documents, filters, sort order and date format. It updates when you change any of them.

Supported output formats

Pick the format from the Output Format dropdown that matches where the data is going. You can re-download the same job in a different format as many times as you need - credits are only consumed at conversion, not at download.

Spreadsheet formats

Selecting Excel lets you pick a column set and then download it as XLSX or CSV with the File Type option.

OptionExtensionBest for
Excel, File Type XLSX.xlsxAnalysis, filtering, pivots. Preserves column types.
Excel, File Type CSV.csvFeeding into databases, scripts, or any tool that reads CSV.
Custom columns.csv / .xlsxA saved column layout (order and header names) matching a downstream system. In the second dropdown under Output Format, choose All columns, Basic - date, description, amount, or a saved custom format. See Configuring custom columns below.

Accounting software formats

Cross-link to the matching import guide for step-by-step setup in each destination.

FormatExtensionUse withGuide
QuickBooks (Web Connect).qboQuickBooks Online, QuickBooks Desktop (Web Connect import)QBO for QuickBooks Online · QBO for QuickBooks Desktop
QuickBooks Desktop IIF.iifQuickBooks Desktop (direct list/transaction import)IIF for QuickBooks Desktop
Quicken QIF.qifQuicken cash, asset, and liability accounts, and older accounting appsQIF for Quicken
OFX.ofxSage, MYOB, and other tools that accept plain OFX bank files(no guide yet)
QFX.qfxQuicken checking, savings, and credit card accounts (Web Connect import)QFX for Quicken
Xero CSV.csvXero bank reconciliation importImport into Xero
Xero Direct Sync- (API)Pushing transactions straight into Xero without a fileImport into Xero
Sage CSV.csvSage 50Import into Sage
Sage Cloud CSV.csvSage Business CloudImport into Sage
MYOB CSV.csvMYOB(no guide yet)
Relate CSV.csvRelate Accounts(no guide yet)
NetSuite.csvNetSuite bank statement importImport into NetSuite

The Download modal with the Output Format dropdown open, showing the full bank-statement export format list: Excel, QuickBooks (Web Connect), OFX, QFX, Xero CSV, Xero Direct Sync, Sage Cloud CSV, Sage CSV, MYOB CSV, Relate CSV, QuickBooks Desktop IIF, Quicken QIF, and NetSuite.

Accented and non-English letters

Payees and descriptions keep their original letters in DocuClipper and in the Excel (XLSX and CSV) exports, so CAFÉ MÜNCHEN stays CAFÉ MÜNCHEN.

QBO, OFX, QFX, IIF, and QIF files are read by QuickBooks and Quicken as plain ASCII. For those formats DocuClipper converts each accented letter to its closest plain letter instead of dropping it: CAFÉ MÜNCHEN becomes CAFE MUNCHEN and SMØRREBRØD becomes SMORREBROD. Nothing is removed, so the names stay readable after import.

How to pick

  • QuickBooks Online → QuickBooks (Web Connect)
  • QuickBooks Desktop → IIF for full control (account mapping), QuickBooks (Web Connect) for a faster bank-feed-style flow
  • Xero → Xero CSV, or Xero Direct Sync to push without a file
  • Sage → Sage CSV (Sage 50) or Sage Cloud CSV (Sage Business Cloud)
  • Quicken → QFX for checking, savings, and credit card accounts; QIF only for cash, asset, and liability accounts
  • MYOB / Relate / NetSuite → the matching CSV format above
  • Anything else / unsure → Excel or CSV

Configuring custom columns

You can build your own column set for Excel and CSV exports and save it for reuse.

  1. Set Output Format to Excel.
  2. In the second dropdown below it, click + Create New Export Format. A new format named configuration 1 (or the next free number) opens in Configure Columns with Date, Description and Amount columns.
  3. Type a name in Configuration name so you can find the format again.
  4. Click Add Column and pick its Field (only fields DocuClipper extracts are listed). Cardholder gives each transaction's cardholder on credit card statements with several cards. A Transaction Type column writes the Credit Label on money in and the Debit Label on money out.
  5. Click a column's name (the pencil) to rename it to whatever your downstream system expects, and drag the handle to reorder columns.
  6. With a Debit or Credit column, Leave Debit and Credit cells empty instead of 0 controls the cell of the other direction: ticked, a deposit leaves its Debit cell empty (what the QuickBooks Online 4-column import expects); unticked, it writes 0. New formats start with it ticked.

Every change is saved as you make it, and the format is offered the next time you export, to everyone on your team. Each format is saved separately, so a teammate's format with the same name never replaces yours.

Understanding ZIP downloads

DocuClipper bundles the output in a ZIP file when:

  • A QuickBooks (Web Connect), QFX, OFX, Xero CSV, Sage CSV, Sage Cloud CSV, MYOB CSV, Relate CSV, NetSuite or QIF download covers more than one account and Download separate files for each account is ticked (the default): one file per account, named after the account number. The same applies to a saved custom format when you tick the checkbox.
  • A QuickBooks (Web Connect) or OFX file would be larger than about 250 KB: it is split into several files. A QFX file for Quicken is never split: each account downloads as one .qfx, however long the statement.

IIF downloads, and Excel downloads with All columns or Basic, are always a single file holding every account.

Always extract the ZIP before importing into QuickBooks or Quicken. These apps won't read the file through the archive. See DocuClipper exports data in zip file for details.

Statements waiting for pages

A statement whose job ran out of pages has not been converted, so it has no transactions to download yet. If you open Download Data for it, DocuClipper says the job is waiting for pages and what to do next, with a link to the job. Add pages, open the job and click Resume processing, then download. See Exceeding Page Limit And Adding More Pages.

Very large projects

A project download includes every document you leave selected under Documents, and projects with thousands of statements export in one file. If a download would take too long to build, DocuClipper stops it and shows This export took too long to build. Select fewer documents under Documents and download the project in a few smaller batches.

Re-downloading

Downloads are regenerated on demand. Closing the tab or clicking away doesn't lose your data. Open the project again, click Download Data, and re-export with the same or different settings.

FAQs

Which output formats does DocuClipper support?

Excel (.xlsx or .csv, with all columns, the basic set, or your own custom columns), QuickBooks Web Connect (.qbo), QuickBooks Desktop IIF, Quicken QIF, OFX, QFX, Xero CSV, Xero Direct Sync, Sage CSV, Sage Cloud CSV, MYOB CSV, Relate CSV, and NetSuite. Pick the format from the Output Format dropdown in the download dialog. See Supported output formats above for which to use with each destination.

Can I choose which columns appear in my export?

Yes. With Output Format set to Excel, pick + Create New Export Format in the column-set dropdown to build a custom column set, rename headers to match your downstream system, and save it for reuse. The accounting formats (Xero CSV, Sage, MYOB, Relate, NetSuite) use the fixed columns their destination expects.

Why does DocuClipper give me a ZIP file instead of a single file?

A download comes as a ZIP when the selection covers more than one account and Download separate files for each account is ticked (QuickBooks Web Connect, QFX, OFX, Xero CSV, Sage CSV, Sage Cloud CSV, MYOB CSV, Relate CSV, NetSuite and QIF), or when a QuickBooks (Web Connect) or OFX file would be larger than about 250 KB and is split. A saved custom format downloads as a ZIP when you tick the checkbox. Untick it to get one combined file. IIF, and Excel with All columns or Basic, always download as a single file holding every account.

Do I have to extract the ZIP before importing?

Yes. QuickBooks and Quicken will not read files through the archive. Extract the ZIP first, then point the import at the unzipped data file.

Can I sort transactions before exporting?

Yes, for Excel and the CSV formats. Set Sort By to Date or Original Document Order, and Sort Direction to Ascending or Descending. QuickBooks (Web Connect), OFX, QFX and IIF files are always written in date order.

Can I re-download a file later?

Yes. Downloads are regenerated on demand, so closing the tab does not lose your data. Reopen the project, click Download Data, and export again with the same or different settings.