We discovered a critical issue with our fixed asset depreciation calculations after our external auditors flagged discrepancies in our financial statements. When we changed the depreciation method on several fixed assets from straight-line to declining balance last quarter, the system only applied the new method going forward - it didn’t recalculate historical depreciation.
This has created significant audit trail problems. Our asset values on the balance sheet don’t match what they should be if the declining balance method had been applied from the acquisition date. The auditors are requiring us to restate prior periods, but D365 doesn’t seem to have a straightforward way to retroactively apply depreciation method changes.
Here’s what we see in the asset book:
Asset: EQUIP-2023-045
Original method: Straight line (applied Jan-Sep 2024)
New method: Declining balance (applied Oct 2024-present)
Accumulated depreciation: $45,000 (should be $52,300)
Net book value: Overstated by $7,300
We need to correct about 180 assets with similar issues. The depreciation method change limitation is causing compliance problems with our audit requirements. Has anyone found a way to handle retroactive depreciation adjustments while maintaining proper audit documentation in D365?
Our auditors are insisting on restatement because the original method selection was an error, not a change in estimate. We should have been using declining balance from the start based on the asset usage patterns, but it was incorrectly set up during implementation. So this is more of a correction than a prospective change. That’s why we need to retroactively adjust. What’s the proper procedure for posting these correction journals while maintaining the link to the fixed assets?
This is helpful. One concern I have is whether the revaluation journals will flow through to our prior period financial statements correctly. We’re on a calendar year, and some of these corrections impact Q1-Q3 2024. Will the revaluation journal entries post to the current period only, or is there a way to post them to the historical periods they relate to? Our auditors need to see the corrections reflected in the correct periods for their restated financials.
For error corrections like this, you need to use the Fixed Asset revaluation journals, not regular depreciation journals. The revaluation process lets you adjust both the asset value and accumulated depreciation while maintaining the connection to the fixed asset record. This preserves the audit trail better than posting to GL directly.
Create a revaluation journal for each affected asset, calculate the difference between actual accumulated depreciation and what it should have been, and post the adjustment. Document the business reason in the journal description. You’ll also need to update the depreciation method in the asset book going forward so future calculations are correct.
I work on the audit side and have seen this situation multiple times. Beyond the technical posting mechanics, you need to focus heavily on documentation for compliance. Your auditors will want to see: (1) detailed calculation worksheets showing the correct depreciation under the proper method, (2) variance analysis explaining the difference for each asset, (3) management memo documenting why this is an error correction vs. estimate change, and (4) evidence of when the error was discovered and how it was communicated to stakeholders.
The audit trail in D365 should clearly show the original transactions, the revaluation adjustments, and supporting documentation attached to each journal entry. Make sure you’re using the document attachment functionality to link your calculation worksheets to the journal entries in the system.