The fixed assets reconciliation check in Data Health & Insights connects with the fixed assets register in Xero and compares it with the general ledger to highlight where records may be out of sync.
To access it, go to a client's account and select Data Health in the left navigation, then select Fixed assets under Cleanup. Use the Reporting Date field at the top of the page to set the period all checks are calculated against.
Important: The fixed assets reconciliation check is available for Xero clients only.
Who can use this check
The fixed assets reconciliation check is available to practices on Practice Essentials and Practice Advanced plans with the Data Health & Insights add-on.
Fixed Asset Accounts
The Fixed Asset Accounts check looks at general ledger accounts with an account type of FIXED and checks whether they're mapped to an asset type in Xero's fixed assets register. An account is considered mapped if it's set as the Fixed Asset Account, Depreciation Expense Account, or Accumulated Depreciation Account for at least one asset type.
Any unmapped accounts are listed as suggestions and the card shows an amber warning. If any unmapped account has a non-zero balance, this should be treated as a genuine issue that needs immediate attention.
Dismissing and undoing suggestions
To dismiss suggestions, select the accounts you want to dismiss using the checkboxes in the table, then select Dismiss Suggestions. Select Select All to select every suggestion at once.
Dismissed accounts move to the Dismissed tab. To reinstate a dismissed account, select the Dismissed tab and select Undo next to the relevant item.
Draft Assets
The Draft Assets check surfaces any fixed assets in the Xero fixed assets register with a status of Draft. Unregistered draft assets can cause reconciliation discrepancies in the Fixed Asset Account Reconciliation check, so this is a useful first place to look if asset types aren't reconciling.
Expand the card to see the full list. Each asset shows Asset Type, Purchase Date, Purchase Price, Book Value, Status, Original Invoice ID, and a View in Xero link.
The list is view-only in Dext. To resolve a draft asset, select View in Xero to open it directly in Xero's fixed assets register.
Fixed Asset Account Reconciliation
The Fixed Asset Account Reconciliation check compares the balance of each general ledger account set as a Fixed Asset Account in Xero against the combined purchase prices of all assets associated with it, up to the Reporting Date. If any account's balance doesn't match, the card shows a red warning and the count of unreconciled accounts.
Expand the card to see each asset type. Select an asset type to expand it and compare Asset Transactions and Account Transactions side by side — including the date, imbalance amount, and individual transaction detail.
Depreciation Account Reconciliation
The Depreciation Account Reconciliation check works on the same logic as Fixed Asset Account Reconciliation, but for accounts set as the Accumulated Depreciation Account in Xero. It compares each account's balance against the combined depreciation values of all associated assets up to the Reporting Date.
Depreciation Value is the difference between an asset's Purchase Price and its Accounting Book Value. If any account's balance doesn't match, the card shows a red warning and the count of unreconciled accounts. Expand the card to compare Asset Depreciation Balance against Account Balance for each asset type.
Depreciation Run
The Depreciation Run check compares the Reporting Date set at the top of the page against the Last Depreciation Date in Xero's fixed assets register. If these don't match, the card shows a red warning with the message "Last Depreciation Date and Reporting Date supplied do not match" — indicating depreciation may need to be run in Xero before the period's accounts are finalised.
Select View in Xero to open the fixed assets register in Xero directly.
Syncing and recalculating data
To update the fixed assets reconciliation check, use the buttons at the top of the page:
Sync — pulls the latest data from Xero into Dext
Recalculate — reruns the checks against the data already pulled into Dext
If you've made changes in Xero, select Sync first, then Recalculate to see updated results.


