Depreciation Schedule Builder
Les comptables, DAF et propriétaires d'entreprises utilisent ce prompt lors de l'acquisition de nouveaux équipements, véhicules ou autres immobilisations et ont besoin d'un tableau d'amortissement pluriannuel précis pour les rapports financiers, la budgétisation et la planification fiscale.
Prompts
You are a fixed asset accounting specialist with expertise in [ACCOUNTING STANDARD] depreciation rules. I need you to build a complete depreciation schedule for the following fixed asset.
Asset details:
- Asset name/description: [ASSET NAME]
- Asset category: [ASSET CATEGORY] (e.g., machinery, vehicle, computer equipment, building improvement, intangible)
- Acquisition cost: [COST] [CURRENCY]
- Acquisition date: [ACQUISITION DATE]
- Useful life: [USEFUL LIFE] years
- Salvage / residual value: [SALVAGE VALUE] [CURRENCY]
- Depreciation method: [METHOD] (straight-line or declining balance)
- Declining balance rate (if applicable): [DECLINING BALANCE RATE]%
- Fiscal year end: [FISCAL YEAR END]
- Partial year convention: [CONVENTION] (half-year, mid-month, or full-year)
Build the depreciation schedule with the following columns for each year:
| Year | Period Start | Period End | Beginning Book Value | Depreciation Expense | Accumulated Depreciation | Ending Book Value |
|------|-------------|------------|---------------------|---------------------|--------------------------|-------------------|
**Calculations to include:**
1. **Year 1 Proration**
- If the asset was acquired mid-year, apply the [CONVENTION] convention to calculate the partial-year depreciation amount
- Show the calculation clearly (e.g., 'Asset placed in service October 1 — Q4 only = 3/12 of annual expense')
2. **Straight-Line Method** (if selected)
- Annual depreciation = (Cost − Salvage Value) / Useful Life
- Show this formula explicitly in your output
3. **Declining Balance Method** (if selected)
- Annual depreciation = Beginning Book Value × Rate
- Switch to straight-line in the year where straight-line produces a higher amount
- Show the crossover year explicitly
4. **Summary Statistics**
- Total depreciation over asset life
- Effective annual depreciation rate
- Year the asset is fully depreciated
- Average book value over the asset life
5. **Journal Entry Template**
- Provide the standard annual journal entry to record depreciation:
Debit: Depreciation Expense — [ASSET CATEGORY]
Credit: Accumulated Depreciation — [ASSET CATEGORY]
6. **Tax vs. Book Note** (if applicable)
- If [ACCOUNTING STANDARD] is GAAP or IFRS, note that tax depreciation (MACRS in the US, CCA in Canada) may differ and recommend consulting a tax advisor for the tax schedule.
Present the schedule as a clean table followed by the summary statistics and journal entry template.Variables du Prompt
Remplacez chaque placeholder par vos informations spécifiques :
[ACCOUNTING STANDARD][ASSET NAME][ASSET CATEGORY][COST][CURRENCY][ACQUISITION DATE][USEFUL LIFE][SALVAGE VALUE][METHOD][DECLINING BALANCE RATE][FISCAL YEAR END][CONVENTION]Ce que vous obtiendrez
Un tableau d'amortissement année par année montrant la valeur comptable de début, la charge annuelle, l'amortissement cumulé et la valeur comptable de fin pour chaque période — ainsi qu'un modèle d'écriture, des statistiques récapitulatives et une note sur les différences fiscales/comptables.
💡 Conseil d'Expert
Exécutez ce prompt deux fois — une fois en mode linéaire et une fois en mode dégressif — puis comparez les résultats. La méthode produisant un amortissement plus élevé en début de vie réduit le revenu imposable plus tôt, ce qui peut avoir des avantages significatifs en termes de flux de trésorerie.
Outils IA Compatibles
Claude
Best for detailed multi-method comparisons and explaining the declining balance crossover logic; Claude will catch common errors like applying declining balance to intangibles where straight-line is required under IFRS.
ChatGPT
Use the Code Interpreter feature to have ChatGPT write and execute the calculations in Python — this produces a downloadable table and is useful for high-value assets where you want to verify every decimal.
Microsoft Copilot
Excellent choice if you work in Excel — Copilot can generate the schedule using Excel formulas (DB, SLN, DDB functions) directly in your spreadsheet, making it easy to update when asset details change.