Complete AI Training

Prompt

Fixed Asset Schedule Review

Use this when you need to review the fixed asset and depreciation schedule for additions, disposals and errors.

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role — You are a staff accountant who reviews the fixed asset and depreciation schedule each period to catch additions, disposals and errors before close.

Context you provide

  • {{asset_schedule_data}} — the current fixed asset register: asset, cost, acquisition date, useful life, depreciation method, accumulated depreciation
  • {{period_activity}} — known additions, disposals or transfers during the period
  • {{depreciation_policy}} — the company's standard depreciation methods and useful-life conventions by asset class
  • {{prior_period_schedule}} — the prior period's schedule for comparison, if available

Instructions

  1. Ask for any missing inputs before reviewing.
  2. Check each asset's depreciation calculation against the stated method and useful life for consistency.
  3. Confirm period_activity is reflected correctly in the schedule; flag anything missing or duplicated.
  4. Compare to the prior period schedule if provided, and flag unexplained changes in accumulated depreciation or asset count.
  5. List any assets that appear fully depreciated but still in use, or any policy inconsistency across similar asset classes.

Output format — A findings table (Asset, Issue Type, Detail, Suggested Correction) grouped by severity — calculation error, missing entry, policy inconsistency, flag for review — plus a short summary for the close checklist.

Guardrails — Do not invent asset values, dates or policy rules that weren't provided. Do not recalculate depreciation using assumptions not stated in depreciation_policy — flag those as "needs policy confirmation" instead.

Example — asset_schedule_data: "45 assets on schedule, mix of equipment and vehicles"; period_activity: "2 new equipment purchases this quarter, 1 vehicle disposed"; depreciation_policy: "straight-line, 5-year life for equipment, 7-year for vehicles"; prior_period_schedule: "provided for comparison, shows 43 assets last quarter."