You can use the
Condense Data Utility in QuickBooks Desktop (In the menu bar, click File, then Utilities and then Condense Data) to condense company file data.
To do this task:
In the menu bar, select File and then Utilities and then Condense Data.
In the first window of the wizard, select Transactions before a specific date and enter the appropriate date.
Put a checkmark in the checkbox labeled: Optional: Create a report showing which transactions cannot be removed.
Click Next and select the radio button Create one summary journal entry (recommended).
Click Next and select the radio button Summarize inventory transactions (recommended).
Click Next and select the transaction groups you wish to be removed.
Click Next and select the unused list entries you wish to be removed.
Click Next and click the Begin Condense button. BIG NOTE This does not start the Condense: it starts the report.
Few other helpful tips before handling this task and also before converting to QBO:
backup of your QuickBooks company file Update QuickBooks (Help menu > Update QuickBooks)
Verify and Rebuild Data (File menu > Utilities > Verify and Rebuild Data)
(do it a couple of times if it’s huge or old file)
You must use Internet Explorer to move your company data from QuickBooks Online to QuickBooks Desktop edition.
To export data:
From the home page screen > company gear (upper right corner) > tools > export data
Click on the screenshot below to enlarge it
The export to desktop provides you with a local copy file that must be opened in desktop within 10 days. Exporting data to QuickBooks desktop edition or creating a local copy has several known issues.
In some cases, it would be better to just start with entering opening balances from Balance Sheet or Trial Balance (if transferring in during the fiscal year).
MUST DO: Print (and download to Excel) all major reports from QBO. Do not forget Sales Tax reports and Inventory related reports if applicable.
Do not forget to CANCEL your QBO subscription. Make sure account is NOT suspended.
Here are some helpful links, you must read (twice) before starting this project:
Save your data to Excel
Convert QuickBooks Online company file to QuickBooks desktop Weekly Price Check US CA UK AU (Plus Plan)
USA Canada UK
USD 23.97 per month CAD 14.50 per month GBP 15.00 per month AUD 21.00 per month
USD 23.97 per month USD 12.01 per month
(Conversion) USD 23.30 per month
(Conversion) USD 16.60 per month
It’s not possible to import a QuickBooks desktop backup file directly into QuickBooks Online.
If you only have a backup and don’t have QuickBooks desktop installed on your computer, you will first need to install a trial version of QuickBooks on your computer.
Follow the steps below:
Download and install a QuickBooks Trial:
Windows Desktop Trial Link:
http://http-download.intuit.com/http.intuit/Downloads/2012/Latest/Setup_QuickBooksPro2012.exe (License # 7482-8847-2621-492 / Product # 204-992)
Mac Desktop Trial Link:
Skip (or exit) the “getting started” interview.
In the QuickBooks trial, choose File > Open or Restore Company to open the backup file. (File > Open Company in Mac)
After it’s restored, take these two steps (also read related articles below)
STEP 1 > In QuickBooks for Windows, choose Help > Update QuickBooks.
STEP 2 > After the update is complete, restart QuickBooks, choose Company > Export Company File to QuickBooks Online.
Click on the screenshot below to enlarge it
Then, follow the rest of import instructions:
Import into QuickBooks Online from QuickBooks Desktop for Windows
Survival Guide – Import to QuickBooks Online from QuickBooks Desktop
Import into QuickBooks Online from QuickBooks Desktop for Mac
You can, but it comes all kinds of hurdles. It is not recommended at this time.
If you have to, please read these two articles.
Convert QuickBooks Online company file to QuickBooks desktop
If you read the following instructions, it’s clear they have not made new improvements in this area for few years now.
Detailed instructions ………… Note: You must log in as the QuickBooks Administrator to convert your company file and
you must be using Internet Explorer to access QuickBooks Online.
Lists & Transactions ……….vi
Change the Browser Mode to IE8 Compatibility View.
Unlike QuickBooks desktop version (where you can create as many multiple company files as you want), QuickBooks Online is per one company file subscription. You can only have one business or company file in one paid subscription account. You can add multiple companies with additional PAID subscriptions under your same login account.