You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

21B Fixed Asset Accelerated Depreciation Best Practice using a spreadsheet

Received Response
56
Views
4
Comments
edited Jun 10, 2021 2:05PM in Assets 4 comments

Summary

21B Fixed Asset Accelerated Depreciation Best Practice using a spreadsheet

Content

Hi Experts,
 
We have a client that wants to efficiently adjust assets using spreadsheet for around 3K lines in tax book due in two weeks in order to claim deduction.  May I ask what is the best option?  Is it cost based or useful life?
 
For Cost, use Unplanned Depreciation?
For Useful Life, use Manage Mass Cost and Rules Change?
 
The aim here is to accelerate the depreciation say if the asset has a useful life until 2025, then we'll recognize the depreciation until e.g. 2021. 
 
Please see attached.  Here we did it via UI not with spreadsheet to get the logic first.  So we are planning to do it via spreadsheet for a massive amount of data.
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!