Depreciation Scheduler
Maintains a fixed asset register and runs depreciation end-to-end — processes additions and disposals, calculates depreciation with proration, and outputs a full schedule plus a ready-to-post journal entry. For controllers and accountants managing fixed assets each period.
Depreciation Scheduler
Before You Begin
- Your fixed asset register as Excel or CSV (or start fresh).
- The
xlsxskill available for building the workbook. - Optional: an additions file and/or a disposals file for the period (CSV or Excel).
- The depreciation method to use (defaults to straight-line) and the period-end date.
- Optional: non-standard useful lives, residual values, or a capitalization threshold.
How It Works
- Ask the skill to run depreciation. Example prompts:
- "Update the fixed asset register for Q1 2025."
- "Run depreciation, straight-line, prorate by days."
- "Add these new assets and process the disposal of A042."
- The skill loads the existing register and validates each row, flagging any missing acquisition date, cost, or useful life.
- The skill processes additions — assigns new Asset IDs, applies category-default useful lives, and confirms anything non-standard.
- The skill processes disposals — depreciates to the disposal date pro-rata, computes gain/loss (proceeds − NBV), and marks the asset Disposed.
- The skill calculates period depreciation — straight-line by default (or declining balance), with proration for mid-period additions and disposals.
- The skill builds the workbook across five sheets.
- The skill produces the journal entry summary — DR depreciation expense / CR accumulated depreciation for the period total.
What You Get
fixed-asset-register-[period].xlsx(5 sheets):- Sheet 1 — Full asset register: all active assets with updated accumulated depreciation and NBV.
- Sheet 2 — Period depreciation schedule: cost, opening NBV, depreciation this period, closing NBV, with a total row that is the JE amount.
- Sheet 3 — Additions this period: new assets with first-period depreciation.
- Sheet 4 — Disposals this period: disposed assets with gain/loss.
- Sheet 5 — Fully depreciated assets: active assets at or below residual value, flagged for write-off review.
- A journal entry summary as a plain-text block for the period.
Troubleshooting
Related use cases
Turns how an accounting task was actually performed into an evidence-grade, sourced record — every action, every piece of context, and the rationale behind each, with gaps flagged rather than invented. For controllers and teams documenting close processes for audit or handoff.
Maintains a fixed asset register and runs depreciation end-to-end — processes additions and disposals, calculates depreciation with proration, and outputs a full schedule plus a ready-to-post journal entry. For controllers and accountants managing fixed assets each period.
Turns a folder of invoices and receipts (PDF or image) into a clean, categorized expense spreadsheet — vendor, dates, tax, and totals extracted, anomalies flagged, source files renamed. For bookkeepers, accountants, and anyone prepping expenses for the books.