Import financial data from QuickBooks Desktop

To import data from a QuickBooks Desktop file (.qbw), you must download and install the Fathom Desktop Connector. After installation, you can upload data from your QuickBooks files into Fathom.

You can import a maximum of 3000 accounts and 96 months (8 years) of financial data into Fathom, though we recommend importing up to 60 months (5 years) for best performance.

📝 Note: QuickBooks Desktop companies will be automatically imported onto a Fathom Pro plan and cannot be downgraded to a Portfolio plan. QuickBooks Desktop companies can access Fathom Pro features, like the Analysis tools, Reports, Forecast, and Insights Dashboard.

Which versions of QuickBooks Desktop does Fathom integrate with?

The Fathom Desktop Connector will work with any recent version of QuickBooks Desktop from the US, United Kingdom, and Canada. We support versions from the current year and the three years prior. This includes Pro, Premier (all editions), Simple Start, and Enterprise Solutions.

We do not integrate with any version of QuickBooks Desktop for Mac. In cases where we do not integrate directly, we suggest using Excel to import your data.

Can I import QuickBooks Desktop in a hosted or server environment?

The Fathom Desktop Connector can be used in hosted or server environments. The Connector application (.exe) file and the QuickBooks file (.qbw) need to be stored on the same physical drive. Typically the Connector needs to be 'allowed' to run and access files in the environment.

We recommend contacting your network administrator or IT professional to see if they can allow the Fathom Desktop Connector to run in your environment.

If your company files are hosted on a hosting provider such as Rightworks (formerly Right Networks), Cloud9, or InsynQ, please contact your account manager or their support team to request that the Fathom app be 'allowed' in their hosted environment.

For more information on this, please refer to:
Using the Fathom Desktop Connector (in a hosted or server environment).

Install the Fathom Desktop Connector

To install the Connector and import financial data from QuickBooks Desktop:

On the My Companies page in Fathom, select the green Add button.
Choose Company
Select QuickBooks and Continue
Choose Desktop Connector and click Next
Download the Connector

📝 Note: See our 'Using the Fathom Desktop Connector' article for more information about the Connector.
Open the Fathom Desktop Connector to launch it.
The Desktop Connector will ask you to enter your Fathom credentials.
Once you’ve entered your Fathom credentials, select the Fathom organisation you want to import to if you can access multiple Fathom organizations.
You’re now ready to import your QuickBooks Desktop files into Fathom.

⚠️ Error Alert: Is the Fathom Desktop Connector not launching? Please see our Desktop Connector issues article.

Connect Fathom to your QuickBooks Desktop file

After launching the Desktop Connector, follow these steps to import your company data into Fathom:

Start QuickBooks and open your company file.

❗Notice: You must open the QuickBooks file (.QBW file) on your machine and select the file from the Fathom Desktop Connector using the same file pathway. The file pathway is determined by the location of the QuickBooks file. To check the location of the QuickBooks file, you can open the file in QuickBooks and use the 'F2' key or 'Ctrl +1' to reveal the file's exact location.
Login as the 'Administrator'.

💡 Smart Tip: To connect Fathom to the company file initially, you must be the Administrator user. There is only one administrator per QuickBooks Desktop file. You can set up the Desktop Connector to allow ‘Accountant' users to perform subsequent updates of the file.
Ensure that there are no other company files open and that all dialogue boxes in QuickBooks are closed.
Within the Fathom Desktop Connector, click + Add Files to select your QuickBooks file. This should be the same file you opened in QuickBooks.
QuickBooks will ask you to grant permission to the Desktop Connector. Return to the QuickBooks program and grant permission before proceeding.
Choose 'Yes, always; allow access even if QuickBooks is not running' to make connecting easier next time.
Return to the Desktop Connector.
1. If you have classes in your QuickBooks file, you’ll be asked to select which classes you wish to import into Fathom. You can import up to 20 classes. Once you’ve selected your classes, click Confirm Selection.
You should see your QuickBooks files listed in the Fathom Desktop Connector. Select Upload to Fathom.

Fathom will then securely extract the data from your QuickBooks Desktop file, along with your selected classes, if applicable. This may take several minutes, depending on the file size and internet connection speeds.

After the file is uploaded to Fathom, you’ll be prompted with a message that will take you to your ‘My Companies’ page in Fathom. You should see the company listed on the ‘My Companies’ page, where you can access the settings, analysis, reports, and forecasting tools.

Continue setting up your company in Fathom

⚠️ Error Alert: Trying to connect your QuickBooks Desktop company to Fathom and receiving an error? Please see our QuickBooks Desktop connection issues article.

What if I am the accountant and not the administrator on the company file?

The administrator is the only user who can make the initial connection, but they can set it up so that other users can make subsequent connections.

For this approach to work, the file owner will need to be comfortable creating a new user and performing an initial connection to the Fathom Desktop Connector in their environment. Alternatively, you could ask them to briefly change the Administrator password and send you the file so that you can facilitate this process for them.

The steps for the Administrator to follow are:

Log in to the company file as administrator
Create a new user with the ‘Accountant’ role (if you don’t have one already).
While logged in as the Administrator and with the company file open, go through the normal process to import using the Fathom Desktop Connector.
When selecting the access permissions, select to access the company file using the new ‘Accountant’ user.

Update your QuickBooks Desktop Company in Fathom

To update your financials from QuickBooks Desktop, you’ll need to use the Fathom Desktop Connector to re-import the QuickBooks Desktop file.

Open your company file in QuickBooks Desktop.
Ensure that there are no other company files open and that all dialog boxes in QuickBooks are closed.
Open the Fathom Desktop Connector on your machine.
1. If you need to re-download the Fathom Desktop Connector, you can do so by going to Update Data in the company’s Settings.
2. Select the grey ‘Update from QuickBooks Desktop’ button, and you’ll be taken to a page where you can re-download the Connector.
If necessary, log back into the Connector.
Select the + Add Files button and choose the QuickBooks Desktop file for the company.
You should see your QuickBooks files listed in the Fathom Desktop Connector. Select Upload to Fathom.

Next steps

Congratulations on connecting your QuickBooks Desktop company to Fathom! Continue in the 'Getting Started Workflow' to finish setting up your company for analysis, reporting, and forecasting. Choose from the next workflow steps below:

What you want to do:	Next step in the setup process:
Did you miss out on importing your classes with your company? You can still do so.	Import Class Data into Fathom
Want to import a budget for your company?	Import a Budget from Excel
Happy with the above and ready to begin setting up your Company Profile?	Set up your Company Profile

💡Smart Tip: If you want to consolidate several companies in Fathom, we recommend importing and completing the setup process for each company before creating a consolidated group.

Additional knowledge & common questions

Import financials from QuickBooks Desktop