Skip to main content
Import Class Data from QuickBooks Desktop

Upload & update your class data from QuickBooks Desktop

Updated over 2 weeks ago

This feature is included with Fathom Pro - the plan with access to all of Fathom's features. Companies on Portfolio can be upgraded to Fathom Pro at any time.

Import Class Data from QuickBooks Desktop

When importing a QuickBooks Desktop company into Fathom, you can bring in class data for divisional analysis and reporting. This will help you filter your results further to gain more detailed insights from your classes.

You can import up to 20 classes into Fathom for a single company when importing from QuickBooks Desktop.

Notice: If you have not yet imported your QuickBooks Desktop company into Fathom, please see our 'Importing from QuickBooks Desktop' article. This article assumes you have already made the initial company import into Fathom.


Add Classes to a QuickBooks Desktop Company in Fathom

You can import your classes when you import your QuickBooks Desktop company into Fathom. If you did not import classes with the initial import, then you'll need to re-upload the company's QuickBooks Desktop file into Fathom:

  1. Open your company file in QuickBooks Desktop.

  2. Ensure that no other company files are open and that all dialogue boxes in QuickBooks are closed.

  3. Open the Fathom Desktop Connector on your machine. If you need to re-download the Fathom Desktop Connector, go to 'Update Data' in the company's Settings. Select the grey 'Update from QuickBooks Desktop' button, and you'll be taken to a page where you can re-download the Connector.

  4. If necessary, log back into the Connector.

  5. Select the + Add Files button and choose the QuickBooks Desktop file for the company.

  6. You should see your QuickBooks files listed in the Fathom Desktop Connector. If you have classes in your QuickBooks file, select Edit next to the company name in the Connector. Choose which classes you wish to import into Fathom.

  7. Select Upload to Fathom.

The import may take several minutes, depending on the file size and internet connection speeds. Once the import has been completed, you can go to 'Update Data' in your company's Settings in Fathom. In the 'Financials' section, you should see that classes have been imported next to the 'Tracking' heading.

Congratulations on importing your divisional data! Select the option below to continue to the next steps for setting up your company in Fathom.

💡Smart Tip: We recommend completing the company setup if you're setting up the company in Fathom for the first time before diving further into using divisional or class data in Fathom.


Avoid double-counting

You'll want to ensure your class tree hierarchy is set up correctly in QuickBooks to avoid double-counting in Fathom. Fathom identifies parent and child classes based on their relationship in QuickBooks, not based on name-matching.

Example: A company has created classes to designate the different regions of their business. They have a European Union (EU) class and have further subdivided the EU class by country. To further understand the company's performance in specific cities, they want to further subdivide the country classes by city. They'll want to ensure they designate the city classes as subclasses of the corresponding country class and the country classes as subclasses of the EU class.

With the above configuration, the 'Germany' parent class and the 'Germany' child class are considered separate classes; the results for 'Germany' will be double-counted.

The above configuration is correct because 'Germany' has been designated as a subclass of the 'EU' class, and the city classes have been designated as subclasses of the 'Germany' class. Fathom reads 'Germany' as one class, and results are not double-counted.


What is 'Unclassified' data?

'Unclassified data' in Fathom represents the difference between the data for the entire company and the data that has been assigned to your classes. You may have unclassified data in Fathom if there is data in your financials that has yet to be attributed to a class.

Learn more about unclassified data and how the amount is calculated in our 'Unclassified Data' article.


Update or change the classes being imported

You can update the class data that is being imported to ensure that any changes made in QuickBooks are reflected in Fathom.

You'll need to re-import the file to update the class data from QuickBooks Desktop. If you need to change the imported classes, you can edit the classes selected for import during the import process.


Next Steps

Congratulations on adding your class data to Fathom! Finish the 'Getting Started Workflow' by setting up your company for analysis, reporting, and forecasting.

What you want to do:

Next step in the process:

Want to import a budget for your QuickBooks Desktop company?

Happy with your budget and ready to begin setting up your Company Profile?

Completing the 'Using Divisions Workflow'? Choose from the options below:

What you want to do:

Where to go:

Set up divisional KPIs

Perform divisional analysis

Report on your divisions

💡Smart Tip: We recommend completing the company setup if you're setting up the company in Fathom for the first time before diving further into using divisional data in Fathom.


Learn more

Did this answer your question?