Fixed asset register and Schedule II depreciation in Excel, with an AI agent

Short answer: Under Schedule II of the Companies Act 2013, each asset is depreciated over its Part C useful life, with a residual value of not more than 5% of cost. On WDV the usual rate is 1 − (residual ÷ cost)^(1 ÷ life). Plant on double or triple shift gets 50% or 100% more for that period. Additions and sales are pro rata by days, and the register must tie to the ledgers before the PPE schedule goes in the accounts.

A fixed asset register is easy to roll forward when nothing unusual happens. The trouble at year end comes from the rows that don't fit: freight in the ledger but not in the register, an invoice entered twice, a laptop bought after 31 March, a machine with no shifts recorded.

Here is the method from a recent tutorial, then an agent rolling 42 assets forward for a machine-tool company near Pune, with 18 addition rows and three sales. It tied the register to the ledgers and got the sales right, but four rows needed a follow-up, and its total is ₹3,525 below ours because of how it measured remaining life.

The tutorial this is based on

Automate Fixed Assets Register | Depreciation Working & Fixed Assets Schedule by Professional's Legacy, published 12 July 2026 (in Hindi and Urdu). Builds an asset-by-asset WDV register and schedule from three input sheets in Power Query, with a 5% residual and a shift uplift. It presents the rate formula and shift factors as policy without citing a law, uses a year ending 31 March 2022 and doesn't cover sales. We added sales, the ledger tie-out and the Schedule II references.

How do you roll a fixed asset register forward under Schedule II?

  1. Work out each asset's rate from its useful life in Part C of Schedule II: rate = 1 − (residual ÷ cost)^(1 ÷ life). The video's example: a 10-year life and a 5% residual give 25.89%. A 15-year life gives 18.10%.
  2. Set up three input sheets: the opening register (code, sub code, life, date put to use, cost, accumulated depreciation, shifts), the year's new assets, and additions to existing assets with the parent's code.
  3. Opening assets: depreciation = opening WDV × rate × shift factor (1.5 for double shift, 2 for triple). Stop at 5% of cost: an asset already at or below that gets nothing.
  4. New assets: cost × rate × days in use ÷ 365 × shift factor, counting from the date put to use to 31 March. Freight, installation and other costs of bringing the asset to use go into its cost.
  5. Additions to an existing asset: work out the parent's remaining life on the day the addition goes into use, turn it into a rate with the same formula, and pro-rate by days. The video uses no shift factor here.
  6. Sales (not in the video): charge depreciation up to the date of sale, take out the cost and the accumulated depreciation, and book the proceeds less the WDV at sale as profit or loss.
  7. Append the three sheets into one register and group it by category for the PPE schedule: opening cost, additions, disposals, closing cost, accumulated depreciation, net block and last year's net block. Tie each category's cost and accumulated depreciation to the trial balance.

Where it usually goes wrong

How an AI agent does it from Slack

We gave the agent four files for a made-up company near Pune, Avani Precision Tools: the opening register of 42 assets with lives, shifts and the board's depreciation policy; the year's additions, new and to existing assets; the three sales; and the fixed-asset ledgers from the trial balance. Every company, name, tax number and amount in these files is made up. The agent works in Slack, where it shows up as Mnemio AI, because Accountant AI is built on Mnemio AI.

The message in SlackRoll Avani Precision Tools' fixed asset register forward to 31 March 2026 with these additions and sales, using our Schedule II policy in the register file, tie it to the ledgers and give me the PPE schedule and the depreciation entry. Don't post anything.
Slack request to roll a fixed asset register forward to 31 March 2026, with four files
The request with the four files.

What the agent did

  1. Read the four files, rolled the 42 assets forward one by one and wrote a workbook.
  2. Tied the additions to the ledgers: added ₹54,000 of freight to the machining centre's cost, and took out a laptop put to use on 2 April 2026 and a second entry of the same invoice.
  3. Worked out the three sales (profit ₹4,74,447.35) and wrote the depreciation and disposal entries without posting them.
  4. Hung the CCTV cameras on a 305/4 that isn't in the register, didn't flag the machine with no shifts or 303/1, and listed the wrong codes in its shift note.
  5. When asked about those four rows, it treated the cameras as a new asset, said it had assumed single shift for 215/1 and gave a double-shift figure, put 303/1 at nil and corrected its note. Its total, ₹27,04,890.15, is ₹3,525 below ours because it measured remaining life from 1 April.
The agent's ledger tie-out: ₹54,000 of freight added to the machining centre, an April laptop and a duplicate invoice taken out
The tie-out: ₹54,000 of freight on the machining centre added to its cost, and the April laptop and the duplicate invoice taken out.

What it found

The rows that needed a decision, after one follow-up
RowProblemFix
Plant additionsRegister ₹18,40,000, ledger ₹18,94,000₹54,000 freight added to 216/1
Laptop INV-2305Put to use 2 April 2026Out: FY 2026-27
Laptop INV-2231Entered twiceOne removed
CCTV cameras, ₹48,000Parent 305/4 not in the registerNew asset, 5 years; confirm
215/1 CNC turning centreShifts blankSingle shift assumed; ask
303/1 split ACWDV ₹3,540, below the floor of ₹5,900Nil; earlier years ₹2,360 too much
Three salesProceeds in a holding ledgerProfit ₹4,74,447.35
The agent's first notes on shifts, the 5% floor and additions to existing assets
First reply, wrong in places: the shift note names codes that aren't in the register and machines that run one shift (its figures used the register), 303/1 is missing from the floor list, and the cameras go on a 305/4 that doesn't exist.
The agent's disposal entry and the ₹4,74,447.35 profit on three sales
The three sales: cost and accumulated depreciation out, the proceeds cleared, profit ₹4,74,447.35.
John's follow-up with four checks, and the agent's answer that there is no 305/4 in the register
Follow-up: there is no 305/4. It treats the cameras as a new asset over five years (₹14,166.18), as we would, but guesses what the preparer meant instead of asking.
The agent's answer on 303/1: nil depreciation, and ₹2,360 too much in earlier years
303/1: nil this year, and earlier years took ₹2,360 too much. The 5% floor is the company's policy; Schedule II caps residual value at 5%. Whether to write the ₹2,360 back is for the auditor.
The agent's corrected PPE table: depreciation ₹27,04,890.15 and closing net block ₹1,32,12,859.28
Corrected: ₹27,04,890.15 for the year. Ours is ₹27,08,414.93: for the three additions to existing assets, it measured the parent's remaining life from 1 April.

What you still check

Questions accountants ask

How do you work out the WDV rate under Schedule II?

Schedule II gives useful lives and limits residual value to 5% of cost; it doesn't give rates. The usual formula is rate = 1 − (residual ÷ cost)^(1 ÷ life), which gives 18.10% for 15 years, 25.89% for 10, 45.07% for 5 and 63.16% for 3.

How does extra shift depreciation work?

For plant and machinery used on double shift, depreciation for that period goes up by 50%; on triple shift, by 100%. Items Schedule II marks NESD (no extra shift depreciation) don't get it. Take the shifts from the plant head each year.

What if an asset's WDV is already below 5% of cost?

Charge nothing. A floor formula would give a negative figure; take nil and find out why earlier years took too much. Schedule II limits residual value to 5% of cost, and a company that uses a different figure has to disclose why.

Hand this job to an agent

Bring one of your own files to a 30-minute call and watch an agent do it.

Book a 30-min demo