Applies to: QuickBooks Online, QuickBooks Desktop
Prerequisites: None

Summary

At Customer's PC

1. Navigate in QuickBooks Online to ....intuit.com/app/exportqbodatatoqbdt
2. Setup and begin the download
3. Copy file up to customer's company shared drive.

On QB VM (Win10, etc.)

4. Copy the file from the customer's shared drive to PC
5. Open the desired version of QuickBooks
6. Run the QuickBooks Desktop Migration tool and select the QBXML file to convert.
7. Add QDMT certificate into the new company file.
8. Check completed file and move to customer's shared drive.

Procedure

Intuit's KB for reference: https://quickbooks.intuit.com/learn-support/en-us/import-or-export-data-files/export-and-convert-your-quickbooks-online-data-to-quickbooks/01/186187

Before beginning:

- Make sure the customer is aware that this isn't perfect and there maybe alterations that need to be made like adjusting journal entries to adjust amounts that are off.
- Know what version of Quickbooks the client plans on using for the file.

- Ask the customer what they would like to name the file.

Step 1:
Have the client sign into their Quickbooks Online account. Remove "homepage" in the URL and replace it with: exportqbodatatoqbdt



Step 2:

Click on "Get Started".

Step 3:

Click Continue (Tool is installed on Win10 machines)


Step 4:

Have the customer decide what data they want to transfer over and click continue.

Step 5:
The next window will let you know that it's compiling the data into a downloadable file. This can take some time depending on the amount of data. There is no progress bar either. Intuit will send a email to notify the client the file is ready to download. Once you see that email log back into the Quickbooks Online account and repeat the above steps. After clicking continue in Step 4 you will be greeted with the screen below. Click on "Continue to Download".

Step 6:

Download the file onto the client's machine and then place the file into their Z drive.

Step 7:

Go into the Win10 machine and open file explorer and navigate to the customer's Z drive and copy the file over to the Win10 desktop. Open the version of Quickbooks the client will be using the file with and leave it open on the "No Company File Open" screen. Open the "Quickbooks Desktop Migration Tool"

Step 8:
Click "Browse" and select the file on the Desktop. Then click "Import"

Step 9:
On the next screen it will ask where you want to save it and to name the file. Save it to the desktop.

Step 10:
The process will start. You will see Quickbooks start creating the file. After a little bit it will pop up with a Application Certificate window.

Step 11:

Match the settings to what is pictured below and click "Continue". Another window will come up and select "Done."

Step 12:

Once the file is done processing:

- Add the Company name to the file in Company > My Company (If  you don't do this QB will not know how to access the file and every time you go to login it will prompt you to login to the last file that was logged in ticket #230021)

- create a local back up of the file to assimilate/shrink the .tlg.
- create a password for the Admin user of the company file

- move the .qbw file and it's corresponding .tlg file to the client's Z drive

- delete the .qbw and the QBO files from the Win10 desktop

 

Step 13:
Call client and sign into the new file with them. Make sure everything looks as it should. Change the admin password with the client. Assist in creating any additional company file accounts they may need.