Skip to content
SkillReady to runFinance

Depreciation Schedule Builder

Written in-house · editorially graded

Every SkillsBank offering is written in-house — never scraped or crowd-sourced — and graded against a fixed editorial rubric in a separate grading step.

Dry-run test passed · Jun 22, 2026

Trigger check passed

Editorially graded · Jun 22, 2026

Transforms a fixed-asset register (CSV or XLSX) into an audit-ready XLSX workbook with four named sheets — Input Register, Year-by-Year Schedule, Monthly Schedule, and Summary Dashboard — plus a PDF export of the dashboard. Applies Straight-Line, Declining Balance (150%/200% DB with SL crossover), Sum-of-Years-Digits, and MACRS with correct partial-year conventions (half-year, mid-month, mid-quarter), a book/tax column split, disposal entries, and rollforward reconciliation. Use when a finance team, accountant, or auditor needs a formula-driven, audit-ready depreciation model built from an existing asset register — without building it from scratch.

What you get

An installable SKILL.md file for your AI assistant. Produces an Excel workbook (.xlsx).

Works in
Claude Code · Cursor
Native — drops into .claude/skills/
Copilot · Codex · Gemini CLI
Native — reads .agents/skills/
claude.ai — web & desktop
Upload the .zip in Customize → Skills
ChatGPT
Via a Project — paste into its instructions

See it in action

A real input → output sample

Sample input
AssetID,Description,Cost,AcqDate,Life,Salvage,Method
M-001,CNC Lathe Model 4000,85000,2022-03-15,7,,200% DB
M-002,Dell PowerEdge Servers (5 units),45000,2023-11-01,,500, 
V-003,Ford Transit Van,32000,,4,2000,
O-004,Office Building Main St,1200000,2018-06-01,39,,SL
O-005,Laptop Bundle (15 units),22500,2024-09-15,,,200% DB
L-001,Parking Lot Resurfacing,18000,2024-04-01,15,,SL
BAD-001,Broken Machine,0,2024-01-01,5,0,SL
Sample output
Sample Excel output produced by the Depreciation Schedule Builder skill
Produced by an AI assistant following this skill on the sample input above.
View the full output as text
Example Output
Depreciation schedule for year-end 2024 generated in Excel file with four sheets: Input Register, Year-by-Year Schedule, Monthly Schedule, and Summary Dashboard. Summary Dashboard includes total gross cost, total accumulated book depreciation, total net book value, and current-year book and tax depreciation charges.

Goes well with

Related