|
QuickBooks provides you with a unique way to manage the business with strategy and security. QuickBooks Online is also known for its best features. You can access QuickBooks online from anywhere anytime however, QuickBooks Desktop is widely used. Many users are using QuickBooks Desktop and while working they also need to convert QuickBooks Desktop to QuickBooks Online.
Dancing Numbers helps small businesses, entrepreneurs, and CPAs to do smart transferring of data to and from QuickBooks Desktop. Utilize import, export, and delete services of Dancing Numbers software.
The below article informs you about the process of converting QuickBooks Desktop to QuickBooks online.
What are the Benefits of Converting QuickBooks Desktop File to QuickBooks Online?
- Reports can be easily compared to the previous year to the current year.
- Importing data to the online version is not chargeable.
How to Convert QuickBooks Desktop to Online
QuickBooks Online is used by every small and medium-sized business owner, also is one of the most useful editions. QuickBooks Online can be accessed from anywhere to make the work easier. Even you can back up the data anywhere anytime. Below are the methods to convert QuickBooks Desktop to QuickBooks Online.
Method 1: Verify Data
In this method first, you need to verify the data. To do so follow the below points
- Go to File >> Utilities >>> Verify.
- If there is any issue occurred while verifying the data then you will be asked to Rebuild the data.
- After rebuilding the data, again verify to see if the issue has been resolved or not.
Method 2: Save Company File in QuickBooks Online Format
Open the QuickBooks Desktop and create the company file copy which is compatible with the QuickBooks online. To do the same, go to options Files >>> Utilities >>> and finally go to the Copy Company files option for QuickBooks online. Now, save the file on your Desktop. It helps to create a new QuickBooks file with the extension “OE.qbw“.
Method 3: How to Import QuickBooks Desktop to QuickBooks Online
Once the above two steps are done then you can easily import QuickBooks Desktop Online via Internet explorer.
- Go to option “Company” >>> select option “more” >>> and at last select Import QuickBooks Desktop Data.
- Now select the option “File” which you want to import and let the process complete.
- Once the importing process finished, you will get a confirmation email.
How to Convert QuickBooks Desktop File to QuickBooks online
Step 1: Checking the File Requirements
- You can import data to QuickBooks within 60 of subscription. If it is more than 60 days then try for the below steps.
- Convert the subscription to 180 days.
- Using the new email setup to QuickBooks Online subscription verify the data.
Step 2: Preparing the Data
- Before proceeding ahead, finish all your outstanding tasks such as bank accounts, inventory, and payroll, etc.
- Update your complete data before converting, here you can also delete the unwanted data.
- Take the back up of your data in the data file. Now, in the QuickBooks Desktop file go to File option >>>backup company >>>Create local backup option.
Step 3: Create a QuickBooks Online Account
- Once work associated with data finished, create a QuickBooks online account and provide the important data required such as email address, Name, mob number, and password.
- When the above step is completed log out of the account.
Step 4: Open QuickBooks Desktop
- After logging out, the new QuickBooks Online account open QuickBooks Desktop to export the data. Don’t forget to download the recent update.
- For that simply go to the Help menu and click on QuickBooks update.
- Now, click on the Company menu and select Export Company file to QuickBooks online.
Step 5: Log in to QuickBooks Online Account Again
- After selecting Export company file to QuickBooks online after login to the new account. The system will ask you if you want to export your existing inventory.
- You should be aware that QuickBooks online values inventory using the FIFO method which is (first in, first out).
- The inventory will be calculated using the same method from the given start data if you click on yes to the value.
Step 6: Choose QuickBooks Online Company
- Now from the drop-down select the QuickBooks online company where you want to import data
Step 7: Copy Data File
- After selecting the company file, copy the data file there, which takes some time.
- After copying all data you will get a notification and you need to click on OK.
- You need to send an email confirmation regarding the same once your data is ready in QuickBooks online, also you need to ask to complete the setup.
- Before start working on QuickBooks online check if the data has been exported properly. You may also run a profit and loss statement and balance sheet report then can compare with QuickBooks Desktop and Online.
- You will get an email notification once data is ready.
- Now, click on Complete your setup which takes you to log in to QuickBooks Online and review the data.
Features and Data Move from QuickBooks Desktop to QuickBooks Online
Find out how your books will move from QuickBooks Desktop to QuickBooks Online. When you switch from QuickBooks Desktop to QuickBooks Online, you may notice differences in how your books appear. Don’t worry, we’ll help you understand how your books were moved.
Terminology
QuickBooks Desktop is using different types of terms than QuickBooks online for menu options, features, lists, items, transactions types, reports and other.
Find the list of terminology differences between QuickBooks Desktop and QuickBooks Online:
QuickBooks Desktop Term | QuickBooks Online Term |
---|---|
Bank Feeds | Online Banking / Bank Transactions |
Documents / Doc Center | Attachments |
Scheduled Payroll | Run Payroll |
Unscheduled Payroll | Run Payroll Bonus Only |
Payment Reminders | Reminders / Automatic invoice reminders |
Income Tracker | All Sales |
Bill Tracker | Vendors window |
Upload & Review Bills | Receipts |
Schedule Online Payment | Online Bill Pay |
Forecast | Budgets |
Budgets | Budgets |
Reconcile | Reconcile |
Inventory Parts | Inventory |
Non-inventory Parts | Non-inventory |
Assemblies | Bundles (Products & services) |
Groups | Bundles (Products & services) |
Other Charges | Not available in QuickBooks Online |
Subtotals | Subtotal |
Discounts | Not available in QuickBooks Online |
Payments | Not available in QuickBooks Online |
Services | Services |
Jobs | Sub-customers Projects |
Items | Products and services |
Memorized transactions | Recurring transactions |
Leads | Not available in QuickBooks Online |
Price Levels | Not available in QuickBooks Online |
Billing Rate Levels | Not available in QuickBooks Online |
Other Names | Not available in QuickBooks Online |
Vendors | Vendors (for all Vendors) Contractors (for Vendors tracked for 1099) |
Fixed Asset Items | Not available in QuickBooks Online |
Sales Reps (Customer & Vendor Profile Lists) | Not available in QuickBooks Online |
Vendor Types (Customer & Vendor Profile Lists) | Not available in QuickBooks Online |
Job Types (Customer & Vendor Profile Lists) | Not available in QuickBooks Online |
Customer Messages (Customer & Vendor Profile Lists) | Not available in QuickBooks Online |
Ship Via (Customer & Vendor Profile Lists) | Not available in QuickBooks Online |
Vehicles (Customer & Vendor Profile Lists) | Manage vehicles |
Templates | Custom Form Styles |
Add/Edit Multiple List Entries | Not available in QuickBooks Online |
Customers | Customers |
Employees | Employees |
Classes | Classes (and Locations) |
Chart of Accounts | Chart of Accounts |
Customer Types (Customer & Vendor Profile Lists) | Customer Types |
Terms (Customer & Vendor Profile Lists) | Terms |
Payment Methods (Customer & Vendor Profile Lists) | Payment Methods |
Memorized reports | Custom reports |
Scheduled reports | Custom reports |
Commented reports | Not available in QuickBooks Online |
Custom reports | Custom reports (QuickBooks Online Advanced) |
Company Snapshot | Business Snapshot |
Job & Item Estimates vs Actuals | Not available in QuickBooks Online |
Bills | Expenses Bills Vendor Credits |
Credit Card Charges | Expenses Credit Card Credits |
Item Receipts | Expenses Bills |
Sales Orders | Not available in QuickBooks Online |
Credit Memos | Credit Memos Refund Receipts Delayed Credits |
Batch Invoices | Batch transactions (QuickBooks Online Advanced) |
Receipt Management | Receipts |
Adjust Quantity/Value on Hand | Inventory Quantity Adjustment |
Make General Journal Entries | Journal Entries |
Make Deposits | Bank Deposits |
Transfer Funds | Transfer |
Enter Statement Charges | Not available in QuickBooks Online |
Statements | Statements |
Estimates | Estimates |
Invoices | Invoices |
Receive Payments | Receive Payments |
Sales Receipts | Sales Receipts |
Checks | Checks |
Purchase Orders | Purchase Orders |
Pay Bills | Pay Bills |
Undeposited Funds | Undeposited Funds Payments to deposit |
Use Register (For Banks/Accounts) | View Register |
Edit > Preferences | Settings (gear) > Account and settings Settings (gear) > Payroll settings |
My Company | Settings (gear) > Account and settings |
Weekly Timesheet | Time Entries (If you have the Time tab) Weekly Timesheet (if you don’t have the Time tab) |
Time / Enter Single Activity | Time Entries (If you have the Time tab) Single Time Activity (if you don’t have the Time tab) |
Calendar | Not available in QuickBooks Online |
Set Up Users | Manage Users |
To Do List | Tasks (QuickBooks Online Advanced) |
Reminders | Not available in QuickBooks Online |
Letters | Not available in QuickBooks Online |
Customer Groups | Not available in QuickBooks Online |
When You Move from QuickBooks Desktop to QuickBooks Online, What is not Imported?
When switching from QuickBooks Desktop to Online most of your data will import. Below are the few items that won’t convert and it includes:
- Account Reconciliation Reports for Banks and Credit Cards: As soon as you switch to QuickBooks Online, you must re-enter your reconciliations from the point where you left them. If you don’t delete the files, you can still access older reconciliation reports from your desktop version if you need them.
- Audit Trail: You can only keep a duplicate of your desktop version and the data it contains in order to preserve your past audit trail. However, QuickBooks Online will now offer a better audit trail for you.
- Recurring Credit Card Charges: Your current recurring credit card transactions must be stopped in the Merchant Center. Create recurring sales receipts in QuickBooks Online to rebuild them after that is finished.
- Inventory from QuickBooks for Mac: If you have access to a Windows-based computer, you can transfer your inventory there even though you can’t do so from a Mac.
- Reports: Numerous reports in QuickBooks Online might take the place of several that you have been using in the desktop version. The ideal answer is to find a new QuickBooks Online report and start using it.
Looking for a professional expert to get the right assistance for your problems? Here, we have a team of professional and experienced team members to fix your technical, functional, data transfer, installation, update, upgrade, or data migrations errors. We are here at Dancing Numbers available to assist you with all your queries. To fix these queries you can get in touch with us via a toll-free number
+1-800-596-0806 or chat with experts.
Video Tutorial for Convert QuickBooks Desktop to QuickBooks Online
Frequently Asked Questions (Faqs)
What is a QuickBooks Online Account?
Accounts for QuickBooks Online can be accessed entirely online with a web browser. The sign-in and account information are separate from QuickBooks Desktop.
Does QuickBooks Online Sync with QuickBooks Desktop?
No, QuickBooks Desktop is completely independent of QuickBooks Online.
How much time it will take to move?
The size of your company file affects how long it takes to transfer your data to QuickBooks Online. Until the move is done, keeps QuickBooks Desktop running.
What occurs to the Data I Already Have in QuickBooks Desktop?
Simply copy the data to QuickBooks Online, and nothing changes. You will now enter fresh data into QuickBooks Online.
The data in your QuickBooks Desktop company file will still be kept by you, but you can only access it if your QuickBooks Desktop subscription is still valid. Learn how to move your QuickBooks Desktop file to QuickBooks Online.
How to Verify that Your Data is Imported Correctly?
Run a profit and loss or balance sheet report in both QuickBooks Desktop and Online, then compare the two.
How to Create a New Company File in QuickBooks Online?
Under your QuickBooks Online account, you can have multiple companies. You’ll need a paid subscription for each company, but you use the same sign-in information for all of them. Here’s how to add or create a new company.
How will Changing Inventory Methods Impact Your Business?
Using FIFO, QuickBooks Online calculates inventory costs as of the inventory start date. Existing transactions from this date forward are also subject to a FIFO recalculation. In order to prevent having to file revised tax returns, it is advised to choose an inventory start date that is the first day after your company’s most recent tax filing period.
Additionally, you must inform the IRS of your new inventory costing method.
What do You need to do if You don’t Bring over Your Inventory?
You can choose No, don’t turn on inventory, and stop tracking quantity on hand during the move if you’d prefer not to use FIFO or switch on inventory in QuickBooks Online. Later, you can change these settings, but doing so requires creating new inventory items. If you require help with this decision then get in touch with your accountant.