This interface allows BRP dealers to capture Trial Balance data from QuickBooks and related count data from DX1 and then send that data to the TrueTrack Composite Reporting system either manually or automatically if using QuickBooks Online
Requirements and notes:
This feature is for BRP dealers only and requires a signed BRP integration agreement, if you have not signed this agreement please contact your DX1 Account Manager.
Dealers must already be registered with TrueTrack in order to submit data. Please contact support@truetracksolution.com
The Composite Reports interface can be accessed by clicking on the Accounting Tile in DX1 (QuickBooks Online dealers) or by using the DX1 Accounting App (QuickBooks Desktop)
Steps required to extract and submit data to TrueTrack
1. Log into the DX1 Accounting App or from DX1 click the Accounting tile
2. Click on the “Composite Reports” tab, on this page you will have the option to either review previously extracted data or extract a new dataset for a given month.
3. Select the Year / month you wish to extract data for.
4. Click the “Get QB Data” button, this will connect to QBs and extract the Trial Balance data for the selected month. Review the account balances that were pulled in, if you see any concerns you need to resolve them in QuickBooks and then click the “Get QBs Data” button again to reimport the account balances.
5. Click the “Get DX1 Data” button, this will connect to the DX1 database and extract the non financial numbers (Associated Count) for unit inventory and sales, Review the numbers pulled in from DX1, you can add or edit these numbers if necessary right in the form. If you do make any changes be sure to click “Save Changes” before you leave.
6. The extracted data (Trial Balance and DX1 Counts) will be saved as a snapshot in the DX1 database and displayed on the screen for review and future reference.
7. Once the data has been extracted from QBs and DX1 and you are happy with it, click the "Submit to TrueTrack" button. On the next page you will have the option to upload the data for the previously selected month or for several months, just select the month range you wish to submit data for and then click "Submit" to send the data to TrueTrack. If your data is uploaded successfully you will get a message stating so, if you get a message indicating that accounts are not mapped you will need to contact TrueTrack to get those accounts updated or added.
8. QBO dealers only - From the "Submit to TrueTrack" screen dealers using QBO have the option to "Keep my data updated in the TrueTrack system". Turning this feature On means that DX1 will automatically pull data from DX1 and QBO and send it to TrueTrack every day so it no longer needs to be done manually.
- If QBs GL accounts were ever synced to DX1 with account numbers you must leave account numbers turned On in QBs. If this is the case go to your QBs settings and turn Account Numbers back On then try again.
- If the Trial Balance report includes accounts that are now inactive in QBs and were never synced to DX1 you need to re activate those accounts in QBs and sync them to DX1, you can then deactivate them again in QBs.
- If you are not using account numbers you can not have two accounts in QBs with the exact same name even if they are in different account hierarchies. To address this re name one of the accounts in QBs and re sync the accounts to DX1.