Fixed Assets are a separate part of the Xero system, which can lead to some inconsistencies. Dext Precision connects to the Fixed Assets register in Xero and compares it with the general accounting ledger to highlight where records may be out of sync.
WARNING: Fixed Assets is available for Xero clients only.
- Fixed Asset Accounts
- Draft Assets
- Fixed Asset Account Reconciliation
- Depreciation Account Reconciliation
- Depreciation Run
Fixed Asset Accounts
Go to a Xero Client Overview page then go to Clean Up – Fixed Assets.
Dext Precision looks at general ledger Accounts that have an Account Type of FIXED, and then looks for mapped Asset Types in the Fixed Asset register. Accounts need to be selected as the Fixed Asset Account, Depreciation Expense Account or Accumulated Depreciation Account of at least one Asset Type to be considered “mapped”.
Precision then checks the balance of any unmapped Accounts – if any are non-zero then this should be considered a genuine issue that needs immediate attention.
Draft Assets
Dext Precision searches the fixed asset register for draft assets and lists them here for convenience. This section is a good place to start if the asset types are not reconciling in the section above.
Fixed Asset Account Reconciliation
This section cycles through all of the accounts in Xero’s general ledger that are specified as the Fixed Asset Account in the Fixed Assets register. It compares their balance with the combined totals of the Purchase Price of all assets associated with it, up to the Reporting Date, and highlights any that don’t match. You can expand each Asset type to compare transaction history of the Account with the Asset activity.
Depreciation Account Reconciliation
Similar in logic to the Fixed Asset Account Reconciliation, this section cycles through all of the accounts in Xero’s general ledger that are specified as the Accumulated Depreciation Account in the Fixed Assets register. It compares their balance with the combined totals of the “Depreciation Value” of all assets associated with it, up to the Reporting Date, and highlights any that don’t match. The Depreciation Value is a calculation of the difference between the Purchase Price and Accounting Book Value of an asset.
Depreciation Run
This simple check compares the Reporting Period specified at the top of the insight with the “Last Depreciation Date” in the Fixed Asset Register, and shows an error if they don’t match.