21B Fixed Asset Accelerated Depreciation Best Practice using a spreadsheet

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.