Move Banktivity data into QuickBooks on a Mac. Export a QIF from Banktivity, convert it to a QBO Web Connect file, and import it already reconciled.
No account needed for your first conversions. We never store your bank login.
To move Banktivity data into QuickBooks, open the ledger and choose File, then Export To, then Quicken Format (QIF), set the start and end dates, and save the file. Upload that QIF to the converter at the top of this page and download a .qbo Web Connect file, which QuickBooks Online and QuickBooks Desktop import as a bank feed. QuickBooks reads no Banktivity format and no QIF, so the conversion is the step that connects them.
Last updated July 2026. Banktivity is a Mac first personal finance app, and its QIF export is one of the better ones in that category. That matters, because Mac users are usually the ones stuck: Quicken for Mac has had no QIF export since 2007, so a Banktivity user actually has a cleaner route into QuickBooks than a Quicken for Mac user has.
Most people making this move are freelancers and small business owners on a Mac who ran everything in one Banktivity ledger, personal and business together, and now need the business side in software an accountant can open. Splitting the two is worth doing before you import, not after, and the spreadsheet output is the easiest place to do it.
| Banktivity export | Menu path | Covers | Use it for |
|---|---|---|---|
| Quicken Format (QIF) | File, Export To, Quicken Format (QIF) | A whole ledger with a date range | Migrating to QuickBooks, after converting to QBO |
| CSV | File, Export Selected Transactions | One account, the transactions you selected | A quick spreadsheet extract |
| Tax Exchange Format (TXF) | File, Export To, Tax Exchange Format (TXF) | Tax categorized amounts | TurboTax and similar tax software |
| Banktivity document | Your Documents folder | Everything, in Banktivity's own format | Nothing outside Banktivity |
Built for the QIF files Quicken and finance tools actually export, checked before it exports.
The converter adds up the transactions it parsed and matches that to your file total before you export, so nothing is silently dropped.
Valid OFX 1.02 with QuickBooks Web Connect headers. Online and Desktop import it as a standard bank feed.
Date, payee, and amount are read straight from the QIF tags, so there is nothing to map and no layout to match.
Bulk upload for catch-up and cleanup work. Each file gets its own reconciliation check and its own exports.
Mixed date formats, apostrophe years, currency symbols, and split lines in a QIF are cleaned up and summed before the .qbo is built.
One conversion, three files: the .qbo for QuickBooks, an XLSX to review, and a CSV for everything else.
Three steps. No column-mapping wizard.
Drag in a .qif export from Quicken, your bank, or another finance tool. Any QIF type works.
Every transaction is parsed and checked against your file total. You see the rows before exporting.
Download the .qbo and import it as a Web Connect bank feed. Excel and CSV are in the same download.
The specifics that decide whether the import is clean. If your case is not here, message us in chat.
Open the Banktivity ledger you want to export and choose File, then Export To, then Quicken Format (QIF). Banktivity asks for a starting and ending date for the data. Set the range, save the .qif somewhere you will find it, and you have a plain text copy of the register that other software can read. CSV export works differently: it covers one account at a time and only the transactions you have selected.
Two practical notes. Choose the date range deliberately rather than exporting everything, because you almost never want a full personal history inside a business QuickBooks file. And confirm the saved file is not zero bytes before you close Banktivity, which is the cheapest possible check and catches a surprising number of failed exports.
No. QuickBooks cannot open a Banktivity document, and it cannot read QIF in any version, on Mac or Windows. QuickBooks Online and Desktop accept QBO (Web Connect), QFX, OFX and CSV for bank transaction imports. So the working path is Banktivity to QIF to QBO, and the QIF to QBO conversion is what the tool above does.
QuickBooks Desktop for Mac is no longer sold to new US subscribers, which caught out a lot of Mac bookkeepers. If you are moving off Banktivity today on a Mac, QuickBooks Online is realistically the destination, and QBO Web Connect files import into it perfectly well from any browser.
Banktivity is personal finance software with budgeting, net worth tracking and investment features. QuickBooks is double entry accounting built for businesses, with invoicing, payroll integration, 1099s, sales tax and an accountant view. If you file a Schedule C or a business return, you want the accounting system. If you are tracking a household, Banktivity does that job better and for less money.
For reference, Banktivity's published plans in July 2026 are Bronze at $6.99 per month, Silver at $8.99 and Gold at $10.99, all billed annually, with a 30 day trial. QuickBooks Online starts at $38 per month for Simple Start. That gap is not a rip off, it is two different products: nobody prepares a business tax return from a budgeting app, and nobody needs a chart of accounts to track groceries.
No, and you should not. Import the current fiscal year and the prior one into QuickBooks as live transactions, and keep older years as Excel or CSV archives. A business QuickBooks file loaded with a decade of personal spending produces reports nobody can use and makes the register slow to work in.
Set the date range at export time in Banktivity, which is easier than trimming afterward. If you have already exported everything, convert the QIF to Excel, delete the rows outside your period and the personal accounts, and convert what remains. That is also the cleanest moment to separate business from personal, before anything reaches the accounting system.
Banking style registers convert cleanly. Investment registers do not convert usefully to QBO or OFX, because those banking formats have no field for share quantities, prices per share, or cost basis. Convert investment accounts to Excel instead, where every field survives, and keep them as an archive rather than forcing them into QuickBooks.
QuickBooks is not a portfolio tracker, so this is the normal outcome rather than a workaround. Bank and credit card activity goes into QuickBooks, investment history stays in a spreadsheet next to the year end broker statements, and your preparer works from both.
Go to Transactions, then Bank transactions, choose Upload from file, select the .qbo file, and map it to the right account. The rows land in the For Review tab exactly like a downloaded bank feed, with dates, amounts and descriptions intact. Because QBO carries a unique ID per transaction, re-importing an overlapping range does not create duplicates.
QuickBooks Online rejects uploads over 350 KB. That covers thousands of transactions, but a full multi year export can exceed it, in which case split the QIF by year before converting and upload oldest first. Full steps, including the common import errors, are on the QIF to QuickBooks Online page.
Compare the transaction count and ending balance in the Banktivity register for your date range against the converted output. If both match, the migration is complete. Nothing in the QIF format warns you when an export clipped early or a hidden filter was applied to the register, so this check is yours to run.
The converter reconciles what it parsed against the file's own totals and shows you that before the download, which is where a dropped split or a misread date shows up. Finding it at that point costs a minute. Finding it after the QuickBooks import means deleting transactions out of a live register instead.
Upload a QIF export, get a QuickBooks-ready .qbo back in seconds. No card to try it.
For the solo bookkeeper running a monthly close in QuickBooks.
USD / month
billed $288 yearly
For a firm or finance team converting across many clients and currencies.
USD / month
billed $888 yearly
For multi-bookkeeper firms managing many client books at scale.
USD / month
billed $2,988 yearly
