QBD > QBO conversions: Maximum size
Are you converting a QuickBooks Desktop data file to a QuickBooks Online company? Make sure that the data file is under 350K targets.
Historically, the maximum was based on the file size…now it has changed to targets. What are targets? Targets are the number of detail (or split) lines on a transaction. For example, if a check is split between two expense accounts, that transaction represents two targets. Read more about targets here and here.

How many targets are in the QB Desktop file you’re converting? Press F2 in the QuickBooks Desktop file to find out. If it’s greater than 350,000…then the data is too large to import to QuickBooks Online.
Tips for a successful conversion
- Review the features of QuickBooks Online to make sure appropriate functionality is available for the type of business.
- Follow the QuickBooks Online blog to keep up with the latest changes
- Look for QBO apps that share data and extend the range of capability.
- You cannot import some data such as company settings, memorized transactions, budgets, custom fields, sales form templates, payroll, inventory, price levels and sales tax rates. Read more about this here.
- Paycheck transactions import as checks.
- QB Desktop data files with multi-currency turned on can not be imported to QBO.
- Check whether your QB Desktop data file is in good shape for conversion
- F2 and confirm target count is less than 350K
- File > Utilities > Rebuild Data
- File > Utilities > Verify Data
- Confirm there are no errors or file corruption
- If not already done, create the new QBO company.
- Send data from QB Desktop. Company > Export Company File to QBO. Follow on-screen instructions to log in and select the QBO company to send the data to.
- Warning! This will overwrite all data in the selected QBO company.
- Verify data import
- Receive confirmation email that data has been successfully imported.
- Run accrual-basis Balance Sheet and P&L reports for All Dates in both QB Desktop & Online. Confirm that amounts match.
Related Posts on Redmond Accounting CA
-
Contemplating a Conversion to QuickBooks OnlineContemplating a Conversion to QuickBooks Online QuickBooks is America's most popular small business accounting software. Millions of businesses use either QuickBooks Desktop (install the program on your computer) or QuickBooks Online (log in from a browser). In recent years, QuickBooks Online has become the favorite for new businesses. With its anywhere-access and automatically-updated features, even existing businesses using QuickBooks Desktop are converting to QuickBooks Online.…
-
The new QBO is headed your way!The new QBO is headed your way! QuickBooks Online (QBO), the #1 small business cloud accounting solution, is in its final phase of converting existing users to the new interface. If your QBO subscription hasn't been converted, it will be soon. Run your whole business a new and better way in the cloud. Work from anywhere, anytime with data that…
-
QBO Certification at QB Connect ConferenceQBO Certification at QB Connect Conference Join our own Laura Redmond at QB Connect on October 21 - 22nd as she teaches what you need to know to pass the QBO Certification exam. You will learn: Navigation (where everything is and how to do everything) Transactions (discussing how to enter financial transactions and what type there are) Reporting Troubleshooting Accountant…
-
Discover the New QuickBooks OnlineDiscover the New QuickBooks Online This training is designed to help accounting professionals learn about the New QuickBooks Online! An Introduction to the New User Interface and Design Training Courses Course Materials QuickBooks Online continued to change drastically over the next few months. But this documents its earliest release!
-
Time Travel is HereTime Travel is Here Over 5.6 million customers globally use QuickBooks Online (QBO). Keeping that data secure is a top priority for Intuit, the makers of QBO. QuickBooks Online automatically backs up your data with the same level of security used by banks and financial institutions. Whenever there are changes to your QBO data, it is saved in multiple locations…
-
Which QuickBooks is right for you?Which QuickBooks is right for you? Intuit's mission is to "simplify the business of life". They do that by creating innovative accounting and tax solutions. The most well-known is QuickBooks, but there are actually many versions and offerings with slight variations. As cloud accounting experts, we thought we'd summarize the web-based solutions to help you determine which QuickBooks is right for you.…
-
QuickBooks Connect 2014QuickBooks Connect 2014 QuickBooks Connect 2014 is not your typical accounting conference. Held from October 21-23rd in San Jose, CA, it is a chance for everyone that uses QuickBooks in their business to “connect” and learn more about how to: Start your business Run and grow a successful business Save time and grow your accounting practice Build and market your…
-
Intuit Launches the Completely New QuickBooks OnlineIntuit Launches the Completely New QuickBooks Online We've been working closely with the folks at Intuit this year. As they developed the brand-new QuickBooks Online, we were busy both learning it and creating the accountant training videos, activity handbooks, CPE quizzes, and certification exams. Read today's official announcement in the Wall Street Journal: "I was happy with QuickBooks Online before,…
-
QuickBooks Online Tips & TricksQuickBooks Online Tips & Tricks We work in QuickBooks Online and in other cloud-based apps all day long. There are a number of shortcuts and tricks that make our work easier. Here are our favorites: 1. Work in more than one browser tab at a time. If you’re working in QBO, then you are working in a browser. We get…