Quickbooks Mac
Moving your financial data and everyday workflows to QuickBooks Online means leaving behind old desktop limitations. The following sections walk through the most common migration and setup questions and show how to handle them inside today’s QuickBooks Online web interface.
Moving accounting data into QuickBooks Online
If you are coming from an older desktop program (such as a previous QuickBooks edition or Quicken), you may find that direct file imports are not supported. These programs often use proprietary formats that QuickBooks Online cannot read.
From Quicken (any version)
Quicken files are not directly importable into QuickBooks Online. Instead, you can export your Quicken data to a QIF (Quicken Interchange Format) file, then use a third‑party conversion service or tool to create a QuickBooks Online‑compatible CSV or IIF file. QuickBooks Online supports importing lists and transactions from CSV files through the Gear icon > Import Data. Validate your CSV carefully; mismatched columns will cause errors.
From another QuickBooks edition (Mac or Windows, any year)
Older QuickBooks editions for Mac or Windows do not open natively in QuickBooks Online. Your safest path is to:
- Update the original company file to the latest available version of that desktop product.
- Run a Rebuild Data and then Verify Data from the File menu.
- Export your lists and transactions to Excel or CSV, or use the migration tool within the desktop software (if available) to create a QuickBooks Online migration file.
- In QuickBooks Online, go to the Gear icon > Import Data, select the type of data you’re bringing in, and follow the on‑screen steps.
If opening the original file fails, consider starting fresh in QuickBooks Online and manually entering opening balances. Intuit’s support site offers step‑by‑step articles for migrating from specific desktop editions; search for “Move to QuickBooks Online” for the most current guide.
Reconciling accounts after a move
Reconciliation discrepancies are common after a migration. Your opening balances might not match your actual bank statement, or previously cleared transactions may appear unreconciled.
Fix an incorrect opening balance
If your beginning balance is wrong, go to the Gear icon > Chart of Accounts, find the account, and select View register. Locate the opening balance entry (it often shows as “Opening Balance” with a date equal to your QuickBooks start date). Edit the amount and save. Then initiate a new reconciliation from the Gear icon > Reconcile to pick up the corrected balance.
Clear unreconciled transactions in bulk
QuickBooks Online does not have a one‑click “uncheck all” or lump‑sum reconciliation feature, but you can quickly adjust the register:
- Open the account register (Gear icon > Chart of Accounts > Account history).
- Click the Funnel icon to filter by Status = Uncleared.
- Click each transaction’s checkmark column (a tick icon) to mark it as cleared (C). Alternatively, use the reconciliation screen’s Finish later option to come back and clear groups at your next session.
If you have hundreds of unreconciled items, consider whether they should really be cleared. A cleaner approach is to enter a single journal entry dated as of the statement date that nets all old, immaterial differences to zero, then reconcile to that journal entry.