Feature

QuickBooks IIF and CSV Import for Migration in FreshLedger Pro

If you are leaving QuickBooks Desktop because Intuit discontinued your version, raised your subscription price, or pushed you toward QuickBooks Online, you need a way to move your data without retyping years of history. FreshLedger Pro reads QuickBooks IIF files directly to import your chart of accounts, customers, vendors, items, and historical transactions. For data from Xero, Wave, Sage, FreshBooks, or a spreadsheet, the CSV importer handles the same job with field-mapping you control. There is no paid "migration service," no waiting on a consultant, and no per-record fee. You buy FreshLedger Pro once for $799, install it on your Windows machine, and run the import yourself. The result is a real double-entry general ledger with your opening balances tied out, your customer and vendor records intact, and your transaction history searchable and reportable from day one.

Buy FreshLedger Pro — $799

How it works

The migration path depends on where your data lives. From QuickBooks Desktop (Pro, Premier, or Enterprise, US editions), open your company file and use File > Utilities > Export > Lists to IIF Files for master records, and File > Utilities > Export > Transactions for historical activity. QuickBooks writes a tab-delimited IIF file that FreshLedger Pro reads natively. In FreshLedger Pro, choose File > Import > QuickBooks IIF, select the file, and the importer parses the !ACCNT, !CUST, !VEND, !INVITEM, !TRNS, and !SPL records into the equivalent FreshLedger tables. Account types are mapped automatically (Bank, Accounts Receivable, Other Current Asset, Fixed Asset, Accounts Payable, Credit Card, Equity, Income, Cost of Goods Sold, Expense). You review the mapping preview, fix anything ambiguous, and commit. Debits and credits are preserved exactly as exported, so your trial balance should reconcile to the QuickBooks balance sheet on the cutover date. For CSV imports, you export lists and transactions from your current system as CSV. FreshLedger Pro's CSV wizard lets you map each source column to a target field: account name, date, reference, memo, debit amount, credit amount, customer, vendor, class, tax code. You save the mapping as a template, so subsequent imports from the same source run in one click. For opening balances when no transaction history is being imported, post a single dated journal entry as of your cutover - typically the first day of a fiscal year or quarter - debiting and crediting each account to its tie-out balance, with the offset to Opening Balance Equity, then close that account to Retained Earnings. After import, run a Trial Balance and a Balance Sheet for the cutover date and compare line-by-line to the source system's reports. Fixed assets imported from QuickBooks come in as historical cost; you then set up MACRS depreciation schedules (5-year, 7-year, 27.5-year residential, 39-year commercial) inside FreshLedger Pro's fixed-asset module.

Why it matters

Data portability is not a nice-to-have. The IRS requires taxpayers to retain books and records that support items shown on returns for at least three years from the filing date, and longer in cases involving substantial understatement, unfiled returns, or fraud (IRC Section 6501). If your accounting software vendor sunsets your version or your subscription lapses, you still owe the ability to produce general ledger detail, sales tax workpapers, depreciation schedules, payroll registers supporting Form 941 and Form 940 filings, and 1099-NEC backup. Being trapped in a format you cannot read is a real audit-defense problem. The IIF format, while officially deprecated by Intuit in newer QuickBooks Online flows, remains the most complete plain-text export from QuickBooks Desktop, and it preserves the double-entry structure that GAAP and IRS recordkeeping standards expect. CSV import matters for the same reason in reverse: you should never be forced to retype prior-period transactions just because vendor A and vendor B disagree on file format. Manual re-entry also creates real risk - transposed digits change a 1099-NEC threshold determination, a missed transaction skews cost of goods sold, and a wrong opening balance throws off every subsequent reconciliation. A clean, reviewed bulk import with a tied-out trial balance is auditable. Retyping is not. FreshLedger Pro's importers exist so that the act of changing software does not become a tax compliance event.

Compared to other accounting software

QuickBooks Online accepts IIF imports for lists only in limited cases, and Intuit's official guidance steers users toward their paid migration assistance or third-party conversion services that often run several hundred dollars per company file. Full historical transaction migration into QBO from QuickBooks Desktop is notoriously incomplete: budgets, reconciliation history, and certain custom fields routinely drop. Xero does not read IIF at all. Xero's migration path is either their own conversion service (priced per company and per year of history) or third-party tools like Movemybooks, Dataswitcher, and Jet Convert, again at additional cost. Wave has no IIF importer and offers only basic CSV import for transactions, with no journal-level import for opening balances - users frequently end up entering historical balances by hand. QuickBooks Desktop itself reads IIF, but only newer editions, and Intuit has restricted IIF imports in recent versions over data-integrity concerns. FreshLedger Pro takes the opposite stance: IIF and CSV are first-class import paths included in the $799 one-time license. There is no per-file fee, no migration consultant, and no per-year-of-history charge. You can re-run the import as many times as needed in a sandbox copy until your trial balance ties out, then commit to your live file.

Honest limitations

The IIF importer reads US-edition QuickBooks Desktop files; it does not parse the encrypted .QBB or .QBW binary formats directly, so you must export to IIF first. Attached documents, audit-trail history, and reconciliation status flags are not carried over - reconciled status must be re-marked after import or treated as a starting point. Budgets, memorized transactions, and custom form templates do not import. Payroll history imports as journal-level postings only; per-employee paycheck detail with tax-by-tax breakdowns must be re-keyed if you need pre-cutover paychecks editable in FreshLedger's payroll module. Multi-currency transactions import at the historical posted amount in home currency; FX rate history is not reconstructed. FreshLedger Pro is Windows-only, so the import itself must be run on a Windows machine or a Windows VM on macOS.

Ready to own your books?

One-time-purchase accounting software with built-in payroll, full depreciation handling, and a free Accountant Edition for your CPA.

Buy FreshLedger Pro — $799

One-time purchase. No subscription. Free Accountant Edition included.

Frequently asked questions

Which QuickBooks Desktop versions can I migrate from?
FreshLedger Pro's IIF importer has been tested against IIF files exported from QuickBooks Desktop Pro, Premier, and Enterprise, US editions, from roughly the 2015 release through the current year. Because IIF is a documented tab-delimited text format, older exports generally work too, though very old files sometimes use account-type codes that need manual review in the mapping preview. Canadian and UK editions export IIF in the same shape but with different default account types and tax codes; those import but require more mapping attention. We do not read encrypted .QBW or .QBB files directly - you must open the company file in QuickBooks and export to IIF first.
Can I migrate from Xero, Wave, or FreshBooks?
Yes, through the CSV importer. Export your chart of accounts, customer list, vendor list, and a general ledger detail report from your current system as CSV. In FreshLedger Pro, the CSV wizard walks you through mapping source columns to target fields - account, date, debit, credit, memo, reference, customer or vendor, class. Save the mapping as a reusable template. For opening balances without full transaction history, post a single dated journal entry to set each account to its tie-out balance with the offset to Opening Balance Equity, then close that to Retained Earnings. Run a trial balance to confirm the import matches your source reports.
Will my reconciliation history come across?
No. The IIF format does not export per-transaction reconciliation status with the cleared-date detail needed to reconstruct historical bank reconciliations inside another system. After import, your imported bank and credit card transactions will appear as un-reconciled. The practical workflow is to treat your cutover date as a fresh starting point: confirm the cutover bank balance ties to your last reconciled QuickBooks statement, then reconcile forward from there using statements you download from your bank. Pre-cutover statements remain auditable in your archived QuickBooks file, which you should retain for the IRS recordkeeping window.
How much does migration cost compared to QuickBooks Online or Xero conversion services?
It is included in the $799 one-time FreshLedger Pro license. There is no per-company-file fee, no per-year-of-history fee, and no separate migration package. By contrast, Intuit-recommended QuickBooks Desktop to QuickBooks Online conversion services and Xero's recommended conversion partners typically charge several hundred dollars per company file, sometimes more if you have multiple years of history or payroll. If your import does not tie out on the first attempt, you can re-import into a sandbox copy of your FreshLedger company file as many times as you need at no additional cost until the trial balance reconciles.
Do I need accounting knowledge to run the migration?
Some. FreshLedger Pro is a real double-entry general ledger, not an invoice-only tool, so you should be comfortable reading a trial balance and a balance sheet, and you should understand the difference between a debit and a credit on each account type. If you currently rely on QuickBooks because someone else set it up and you only enter invoices and pay bills, the migration is doable but plan to either work with your bookkeeper for cutover or budget reading time for the included accounting primer. Once the file is set up and tied out, day-to-day data entry is straightforward.