The process of recalculating the data in Dext needs to happen when any changes take place in Xero or QuickBooks Online if required, before the next sync or when a date range is changed in the checks or reports. Recalculating is required in order to update the data for that period to display the updated information.
When to recalculate depends on where you are in the product and the situation which requires updating the data.
Areas in Dext that offer the option to ‘recalculate’:
What you need to know:
- Your clients need to be linked, this enables the ability to sync to Xero/QuickBooks Online so the recalculation process can happen accurately.
Workflow Templates (In Progress)
Let’s take a look at how the recalculation process happens for Workflows in progress.
Once a workflow has been started and as you work through the tasks, you may need to go to Xero/QuickBooks Online to make the relevant updates. Once you make these changes in Xero/QuickBooks Online these will need to be updated in Dext. The next time you open that workflow in Dext a message will pop up asking if you want to recalculate to update the workflow for these changes.
Data Health Cleanup Tools
Checks available to improve data quality we identify as Data Health & Insights. These are found under Data Health for the client.
Note: Data Health & Insights is available to purchase as an add on for your subscription if you’re on the Advanced plan. If you’re an existing Precision user, you’ll also have access to this.
The checks are are:
- Control Accounts
- Bank Reconciliation (Xero Only)
- Duplicate Contacts
- Multi-Coded Contacts
- Contact Defaults (Xero Only)
- Dormant Accounts
- Duplicate Transactions
- Fixed Assets (Xero Only)
- Historical Changes
- Lock date history
- Unreconciled transactions (QuickBooks Online Only)
- VAT return checks
- Corporation Tax
- Entertainment
These checks have options to change to Reporting date once you open them to review the transactions. If you do make any changes to the Reporting date then you’ll need to click the Recalculate button to see these changes take effect.
The Recalculate button is located on each check at the top right of the page.
Data Health Insight Tools
Insights includes checks that allow for deeper analysis of the data in a client account. Once data quality has been improved these tools will become a lot more valuable and provide visibility to help support a client to grow their business. You can find these under Insights on the client account.
Note: Data Health & Insights is available to purchase as an add on for your subscription if you’re on the Advanced plan. If you’re an existing Precision user, you’ll also have access to this.
These tools are:
- Aged Balances
- Activity Stats
- Benchmarking
- Cost Analysis
- Sales Analysis
- Metrics
- Custom Reports
- Report Creator
- ABN Validation (AUS Only)
These checks have options to change to Reporting Date once you open them to review the transactions. If you do make any changes to the Reporting Date then you’ll need to click the Recalculate button to see these changes take effect.
The Recalculate button is located on each check at the top right of the page.
