When importing from QuickBooks Online into Fathom, you can optionally choose to import data for selected classes, locations, departments, businesses, properties, stores etc. Fathom does not import customer data, customer types, jobs or projects.
First select the period range for import > then click 'Import'
Then choose which classes and locations you wish to import for analysis. You can select to import a maximum of 20 class options per company.
After selecting class options, click on ‘Confirm selection’ to start the import process.
(The import of data for each class may take up to 1 minute - depending on the number of monthly periods to be imported).
While the import is occurring, you can proceed on with using Fathom. Click ‘Continue using Fathom’ to proceed. A notification will appear to let you know when this import is complete.
Updating Class Data from QuickBooks
To update the financial results for a company and associated results for each class option, you can choose for Fathom to automatically update every day from QuickBooks. This ensures that the results in Fathom keep in sync with the results in QuickBooks.
To do this, go to ‘Step 1 - Update Data’ of the company settings > Select the check box 'Automatically update every day'.
Importing Class Data for an Existing Company
To import classes for an existing company in Fathom, go to ‘Step 1 - Update Data’ of the company settings > then click on ‘Edit’ to select which classes, departments or locations you wish to include in your analysis.
Some more information about class analysis for Quickbooks can be found in this step-by-step guide: Tracking Class Analysis for Quickbooks
Why do I have 'Unclassified' data in Fathom?
Any company data that has not been allocated to a division will be shown as 'Unclassified'.
'Unclassified' data in Fathom represents the difference between the data for the entire company, and data that has been assigned to your classes.
Full company total = 100
Class A = 25
Class B = 25
Class C = 25
Fathom will then assign a value of '25' as an unclassified amount. The sum of class results and the 'unclassified' amount will be the full company results.
Why is the data that is 'Unclassified' showing an incorrect value?
Fathom does not retain or recognise the class hierarchy from QuickBooks. Each class is a distinct entity without any relationship to other imported classes.
This means that if you import both parent and child classes, the "unclassified" amount can actually become negative, because the sum of the parent and child classes is actually larger than the full company total.
Full company total = 100
Child A = 25
Child B = 25
Child C = 25
Parent of A, B, and C = 75
In this example, the correct 'Unclassified' amount should be 25 (100 - 75). However, if you import both the child and parent classes, the amounts will be double-counted, and the data attributed to classes will = 150, which is larger than the full company total. The unclassified amount will then be shown as -50 in Fathom.
It is important that you do not import both parent and child classes at once. In QuickBooks, the parent class sums the amounts from any child classes. If both the parent and child class are imported into Fathom, then amounts will be double-counted.
We recommend just importing the child classes into Fathom. This will allow you to drill into the most detail when viewing your company data, and will ensure that the 'Unclassified' amount is correct.