Year-end depreciation, from the asset list you already keep
Drop your fixed-asset spreadsheet. Assetroll works out MACRS tax depreciation with §179 and bonus, straight-line book depreciation, the roll-forward and the Form 4562 figures, and writes monthly journal entries for QuickBooks or Xero. It runs in your browser; nothing is uploaded.
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.
Why Assetroll
For small businesses, bookkeepers and accountants who keep the fixed-asset list in a spreadsheet and need year-end depreciation, book and tax, done right.
From the list you have
Drop your asset spreadsheet or a QuickBooks or Xero-style export, as CSV or Excel. Columns are recognised; missing classes are guessed and flagged for you to confirm.
MACRS by the book
IRS Pub 946 tables with half-year, mid-quarter and mid-month conventions, §179 with the limit and phase-out, and bonus by acquisition date.
Book depreciation and journals
Straight-line monthly book depreciation, and twelve balanced monthly journal entries as QuickBooks Online and Xero import files.
Roll-forward that ties
Opening, additions, disposals and closing for cost and accumulated depreciation, by category, for the year-end file.
Form 4562 helper
The figures for lines 12, 14, 16, 17, 19a–j and 22, with listed property and disposals (gain and §1245 recapture) flagged.
Checks
Duplicate IDs, guessed classes, missing dates, §179 over the limit, business use of 50% or less, and the mid-quarter test.
Simple pricing
Free to check every asset and see the year's totals. Pro for the full register, the Excel workbook and the journal files.
Free
- Import and check any number of assets
- Year totals, roll-forward totals, line 22
- Full rows for the first 10 assets, printed with a footer
- No signup, nothing uploaded
7-day pass
- 7 days of Pro, no subscription
- Full register and roll-forward, no footer
- Excel workbook, QBO and Xero journals
- For this year-end
Pro Monthly
- Every asset, every client
- Form 4562 detail and disposals
- Excel workbook, QBO and Xero journals
- Cancel anytime
Pro Yearly Best value
- Everything in Pro
- Monthly journals all year
- Costs less than 7 months of monthly
Prices in USD. Secure checkout and sales tax handled by our payment partner. Already bought? Enter your license key.
Tools & guides
- MACRS depreciation calculator for your whole asset list
- Fixed asset register template that does the depreciation
- Depreciation schedule for book and tax, from your spreadsheet
- Monthly depreciation journal entries for QuickBooks and Xero
- Section 179 and bonus depreciation for every asset
- MACRS Depreciation Tables (Half-Year) From IRS Pub 946
- MACRS Example: $10,000 of 7-Year Property, Year by Year
- Mid-Quarter Convention: The 40% Test With an Example
- Depreciation in the Year You Sell an Asset
- Book vs Tax Depreciation: Why the Numbers Differ
- MACRS Property Classes: What Goes Where
- Fixed asset depreciation software: prices compared
- A lighter DepreciationPro alternative
- A Fixed Asset Pro alternative that runs in the browser
- Your depreciation spreadsheet, without the formulas
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.