Your depreciation spreadsheet, without the formulas
Keep your asset list in Excel. Assetroll applies the IRS tables and conventions, §179 and bonus, and builds the roll-forward and journals each year.
What home-made depreciation spreadsheets usually get wrong
- The mid-quarter test. If more than 40% of a year's additions were in Q4, every asset that year changes table.
- Bonus rates by acquisition date. 2025 has two rates (40% and 100%) depending on when the asset was acquired.
- Disposals. The year-of-sale fraction differs by convention; same-year disposals get nothing.
- Roll-forward ties. Opening + additions − disposals = closing, for cost and accumulated depreciation.
- Monthly journals that add up to the year to the cent.
Use the Excel template or your own columns.
FAQ
What does Assetroll do?
It reads your fixed-asset list and works out this year's tax depreciation (MACRS GDS with §179 and bonus), straight-line book depreciation, a roll-forward by category, the Form 4562 line figures, disposal gains, and monthly depreciation journal entries.
Is my data uploaded?
No. Your file is read by JavaScript in your browser tab and never sent to us or anyone else. Assets aren't stored, so closing the tab clears them. Your settings (year, conventions, account names) can be saved in this browser.
Which files can I use?
CSV, tab-separated or Excel with one row per asset. Description, placed-in-service date and cost are required. Asset ID, category, MACRS class, §179, bonus %, business use %, disposal date and proceeds, book life and salvage are optional. Download the template to see the layout.
What's free?
Importing and checking any number of assets, the year's totals (book, tax, §179, bonus, MACRS), the roll-forward totals, the Form 4562 line 22 total and every check, plus full rows for the first 10 assets. Pro shows and exports everything: the full register, roll-forward by category, the Form 4562 detail, the Excel workbook and the QuickBooks and Xero journal files.
What isn't covered?
State depreciation adjustments, AMT, ADS, the §280F luxury-auto caps, amortization of intangibles and like-kind exchanges. Listed property and vehicles are flagged so you can apply those rules. It doesn't file anything.
Is this tax advice?
No. Assetroll does the arithmetic from IRS Publication 946 and the Form 4562 instructions on the data you provide. Check the figures, and ask your tax adviser about elections. It isn't affiliated with the IRS, Intuit or Xero.