Generate a depreciation schedule for several assets
generate_depreciation_scheduleUse this when the user wants a depreciation schedule template filled in for several assets or a fixed asset register: a list of assets, pasted CSV, or an attached CSV/Excel file, each with cost, date placed in service and method (straight-line, declining balance, sum-of-the-years' digits, units of production or MACRS). Returns each asset's schedule, totals by year, the IRS 40% mid-quarter test for MACRS assets, and a PDF, Excel workbook and CSV. Rows that cannot be read are listed with the reason, never dropped silently. Does not model Section 179, bonus depreciation, ADS or dispositions, and is not tax advice. Do not use for a single asset (use calculate_depreciation).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file | No | Optional fixed-asset list as a CSV, TSV or Excel .xlsx file with one asset per row, e.g. fixed-assets.xlsx. Columns like Asset, Cost, Date placed in service, Method, Life or Class, Salvage are detected from the headings. | |
| title | No | Title for the PDF and spreadsheet, e.g. "Acme LLC fixed assets 2026". | |
| assets | No | The assets: an array of objects with name, cost, placed_in_service, method, useful_life_years or property_class, salvage_value, e.g. [{"name":"Laptop","cost":2400,"placed_in_service":"2026-03-15","method":"macrs","property_class":5}]. Or pasted CSV / one asset per line text, e.g. "Laptop, 2400, 2026-03-15, 5-year". | |
| method | No | Default method for assets that do not name one, e.g. macrs or straight_line. | |
| convention | No | Default convention. For MACRS leave it out to let the 40% mid-quarter test decide per year, or pass half_year or mid_quarter. | |
| declining_rate | No | Default declining balance rate in percent, 200 or 150. | |
| placed_in_service | No | Default date placed in service for assets without one, e.g. 2026-01-01. | |
| useful_life_years | No | Default useful life in years for book methods, e.g. 5. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| assets | Yes | ||
| by_year | Yes | ||
| skipped | Yes | ||
| summary | Yes | ||
| currency | Yes | ||
| tax_note | Yes | ||
| warnings | Yes | ||
| downloads | Yes | ||
| asset_count | Yes | ||
| assumptions | Yes | ||
| skipped_count | Yes | ||
| assets_not_shown | Yes | ||
| mid_quarter_test | Yes | ||
| total_cost_basis | Yes | ||
| total_depreciation | Yes |