Depreciation schedule for book and tax, from your spreadsheet
Get a year-by-year tax schedule and a monthly straight-line book schedule for every asset, side by side, with the book–tax difference for your deferred-tax workpaper.
Two schedules, one list
Book depreciation is straight-line over the useful life you choose, monthly, with a full-month or mid-month convention. Tax depreciation follows MACRS (Pub 946). Assetroll shows both and the difference in basis at year end, which is what a deferred tax calculation starts from.
What you get
- Asset register with book and tax cost, depreciation for the year, accumulated depreciation and net book value.
- Roll-forward by category: opening cost, additions, disposals, closing cost; opening accumulated depreciation, expense, disposals, closing — ready for the audit file.
- Tax depreciation (MACRS GDS) with §179, bonus, half-year, mid-quarter and mid-month conventions, and a Form 4562 helper with lines 12, 14, 16, 17, 19a–j and 22.
- Monthly book journal entries as QuickBooks Online and Xero import CSVs.
- Disposals with book gain or loss, tax gain and §1245 recapture.
- Checks: duplicate IDs, guessed classes, missing dates, §179 over the limit, listed property, mid-quarter years.
Your asset list stays on your computer
Assetroll reads your spreadsheet with JavaScript in your browser tab. Nothing is uploaded and there's no account to create. Close the tab and the data is gone. Your settings (accounts, conventions) can be saved in this browser; the assets aren't.
How it works
- Drop your asset list (CSV or Excel), or try the sample, or download the template.
- Pick the tax year and your book convention, capitalization threshold and accounts.
- Fix what it flags, then print the summary, roll-forward and Form 4562 helper. With Pro, download the register, the Excel workbook and the QuickBooks or Xero journal files.
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.