Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Fixed Asset Depreciati...
Finance forum
Unanswered

Fixed Asset Depreciation Reducing Balance - Fiscal vs Calendar (Monthly)

Posted on by 3
Hi all,

I have some troubles with the setup of Reducing balance for Fixed Assets.

Case:
Company : Fiscal year 1/10/2024 – 30/9/2024 (is also the setup in my GL)

Reducing balance 10%

Depreciation profile:
 
Books:
10/15F
 
When we acquire a fixed asset on 1/10 è you can see that the depreciations run perfectly.
(Book 10/15Fiscal) Because it runs in the same period as the fiscal year.
After 12months it’s depreciated for 8.000 € ( 10% of 80.000)
 
 

But if we acquire a fixed asset on 1/5 è the depreciation value changes with the fiscal year and if we take the sum of everything it’s = 7.805,58  (instead of the correct 8.000 €)
It's a difference of +- 200 €
 

 
Is it possible to have monthly the same amount for 12 months? – doesn’t matter when you acquired the fixed asset.
Or is it not possible with reducing balances?
 
Such as in my Excel example?
If period 1 would be also 1/5/2024.
 


Thanks in advance for your feedback!
 
Categories:
  • Suggested answer
    Fixed Asset Depreciation Reducing Balance - Fiscal vs Calendar (Monthly)
    No, it's unfortunately not possible if you use the same book for all assets. Based on looking at the depreciation logic in F&O and Microsoft's documentation. 
     
    You will have to make a customization to how depreciation is calculation, or use multiple depreciation books with separate calendars. But I'd check with a local CPA first.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,576 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,815 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans