FIXED ASSET (KiOnce) Template - Caters to Double Declining & Sum-of-the-Year Digits Method

The previous Fixed Asset template shared can handle only straight line depreciation.

This current post is more on an enhancement to the previous template's capacity:

- To handle Double Declining Method & Sum of the Year Digits Method on top of the original Straight Line
- To allow handling of Residual Values (Salvage Value)
- Schedules are automated ~ Only required to key in FA register once and all respective schedules are generated automatically (after period selection) on the right hand side
- FA double entries for the period selected could be generated

Download FA-KiOnce Template

PS: The template is done using custom functions DEPRE & ACCDEPRE as per explained in another post

On the left hand side is the register for filling up the details of the respective fixed assets.

There are 3 Depreciation types

1. Type 1 = Straight line
2. Type 2 = Double Declining
3. Type 3 = Sum of the year digits method

Additional rows could be added as per required

FA double entries for the selected period could be generated by clicking on the Generate JV button

On the right hand side are the schedules which one can update accordingly through the period selection.