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?
- Open the project containing your converted statement(s).
- Click Download Data in the top-right of the transactions view.
- 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.

Download options
These options are at the top of the dialog:
| Option | What it controls |
|---|---|
| Active Filters | The filters set on the transactions table. Excel, Xero CSV, Sage, MYOB, Relate, NetSuite and QIF downloads contain only the rows that match them. |
| Sort By | Date, or Original Document Order (the order the rows appear on the statement). Applies to the same formats as Active Filters. |
| Sort Direction | Ascending or Descending. |
| Documents | Which uploaded statements to include in the export. |
| Output Format | 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, 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 Format | Options in the dialog |
|---|---|
| Excel | A 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, QFX | The same as QuickBooks (Web Connect), without the Bank field. |
| Xero CSV, Sage CSV, Sage Cloud CSV, MYOB CSV, Relate CSV, NetSuite | A 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 IIF | QuickBooks 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 QIF | Download separate files for each account when the selection holds more than one account (ticked by default). |
| Xero Direct Sync | The 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.
| Option | Extension | Best for |
|---|---|---|
| Excel, File Type XLSX | .xlsx | Analysis, filtering, pivots. Preserves column types. |
| Excel, File Type CSV | .csv | Feeding into databases, scripts, or any tool that reads CSV. |
| Custom columns | .csv / .xlsx | A 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.
| Format | Extension | Use with | Guide |
|---|---|---|---|
| QuickBooks (Web Connect) | .qbo | QuickBooks Online, QuickBooks Desktop (Web Connect import) | QBO for QuickBooks Online · QBO for QuickBooks Desktop |
| QuickBooks Desktop IIF | .iif | QuickBooks Desktop (direct list/transaction import) | IIF for QuickBooks Desktop |
| Quicken QIF | .qif | Quicken cash, asset, and liability accounts, and older accounting apps | QIF for Quicken |
| OFX | .ofx | Sage, MYOB, and other tools that accept plain OFX bank files | (no guide yet) |
| QFX | .qfx | Quicken checking, savings, and credit card accounts (Web Connect import) | QFX for Quicken |
| Xero CSV | .csv | Xero bank reconciliation import | Import into Xero |
| Xero Direct Sync | - (API) | Pushing transactions straight into Xero without a file | Import into Xero |
| Sage CSV | .csv | Sage 50 | Import into Sage |
| Sage Cloud CSV | .csv | Sage Business Cloud | Import into Sage |
| MYOB CSV | .csv | MYOB | (no guide yet) |
| Relate CSV | .csv | Relate Accounts | (no guide yet) |
| NetSuite | .csv | NetSuite bank statement import | Import into 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.
- Set Output Format to Excel.
- 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.
- Type a name in Configuration name so you can find the format again.
- 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.
- Click a column's name (the pencil) to rename it to whatever your downstream system expects, and drag the handle to reorder columns.
- 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.
Related
- Customize Date Format
- Import into QuickBooks Online
- Import into QuickBooks Desktop (IIF)
- Import into QuickBooks Desktop (Web Connect)
- Import into Quicken (QFX)
- Import into Quicken (QIF)
- Import into Sage
- Import into Xero
- DocuClipper exports data in zip file
- Credit Card Statements With Multiple Cardholders