Free Excel download • Use online • Print or share
A Depreciation Worksheet is a formal accounting and tax-compliance document that records the systematic allocation of a tangible business asset's cost over its useful life. For each depreciable asset, the worksheet captures the acquisition date, full cost basis, elected depreciation method, useful life, salvage value, annual depreciation charges, accumulated depreciation to date, and current net book value. It functions as the authoritative supporting schedule behind the depreciation expense line on both financial statements and tax returns — the document that proves every deduction is calculated correctly, applied consistently, and traceable to a specific asset.
Unlike a simple list of assets, a properly maintained depreciation worksheet reconciles book depreciation (governed by GAAP or IFRS) against tax depreciation (governed by MACRS in the US, CCA classes in Canada, or Capital Allowances in the UK), tracks mid-period disposals and gain or loss recognition, and carries a signed preparer and reviewer attestation. This free Word download gives you a structured, auditor-ready starting point you can edit online and export as PDF for tax filing, lender due diligence, or year-end financial statement preparation.
Without a maintained depreciation worksheet, businesses routinely leave deductions on the table, overstate asset values on the balance sheet, and face avoidable adjustments during IRS examinations or external audits. A missing or inaccurate schedule is one of the most common triggers for IRS audit adjustments to small-business returns — examiners cross-check the depreciation expense on the income statement against the fixed-asset schedule, and gaps in documentation shift the burden of proof to the taxpayer. Lenders and investors request fixed-asset schedules as a standard part of due diligence; an unsigned or incomplete worksheet signals weak internal controls and can slow or derail a financing process. The worksheet also protects you operationally: when an asset is sold or scrapped, the gain or loss calculation depends entirely on the net book value on the schedule — without one, disposal accounting becomes a guessing exercise with real tax consequences. This template gives you a signed, method-documented, period-reconciled schedule that satisfies tax authorities, auditors, and lenders without requiring custom work for every asset class.
| If your situation is… | Use this template |
|---|---|
| Depreciating a single asset class using straight-line over its useful life | Straight-Line Depreciation Worksheet |
| Accelerating deductions on vehicles or equipment using the declining-balance method | Declining-Balance Depreciation Schedule |
| Tracking depreciation on real property and improvements over 27.5 or 39 years | Real Property Depreciation Worksheet |
| Expensing qualified property in full in the year of purchase under Section 179 | Section 179 Deduction Worksheet |
| Applying bonus depreciation for eligible new or used property | Bonus Depreciation Schedule |
| Managing depreciation across a full portfolio of fixed assets | Fixed Asset Register |
| Recording disposal, sale, or trade-in of a depreciable asset mid-year | Asset Disposal Worksheet |
Why it matters: These costs are capitalizable and increase the depreciable base. Leaving them out understates depreciation deductions over the asset's life and may overstate taxable income.
Fix: Review the vendor invoice, freight bill, and any installation invoices together before recording cost basis. Sum all costs required to bring the asset to its intended location and condition.
Why it matters: MACRS recovery periods often differ significantly from GAAP useful lives — a 5-year MACRS class for equipment may have a 7-year book life. Treating them as identical produces deferred-tax errors on financial statements.
Fix: Maintain separate columns for book depreciation and tax depreciation from day one. Reconcile the two at year-end to compute the temporary difference for deferred-tax purposes.
Why it matters: Proceeds in excess of net book value are taxable income. Failing to record them understates taxable income and creates a balance-sheet error where a fully disposed asset continues to carry a book value.
Fix: At the time of disposal, record proceeds, remove the asset's cost and accumulated depreciation, and book the resulting gain or loss to the appropriate income statement account.
Why it matters: A change in useful life estimate is a prospective accounting change — the remaining net book value must be spread over the revised remaining life from the change date. Continuing on the original schedule produces incorrect depreciation in every subsequent period.
Fix: On the revision date, note the change, recalculate annual depreciation as (Net Book Value minus Salvage) ÷ Revised Remaining Life, and update all forward periods in the schedule.
Why it matters: An unsigned depreciation worksheet has no audit trail. IRS examiners and external auditors routinely request signed schedules as evidence of internal control over fixed-asset reporting.
Fix: Build the signature block into the standard template and make counter-signature a required step in the period-close checklist before any depreciation is posted to the general ledger.
Why it matters: MACRS requires a half-year, mid-quarter, or mid-month convention depending on asset type and timing. Using the wrong convention overstates or understates the first and final year's deduction and can trigger IRS adjustments.
Fix: Check IRS Publication 946, Table A, for the applicable convention before computing Year 1 depreciation. If more than 40% of total depreciable property is placed in service in Q4, the mid-quarter convention applies to all personal property that year.
In plain language: Records the unique asset ID, a plain-language description, asset category, physical location, and the department or cost center responsible for it.
Asset ID: [ASSET-001] | Description: [24-inch CNC Milling Machine] | Category: [Manufacturing Equipment] | Location: [Plant B, Bay 3] | Department: [Operations]
Common mistake: Using informal nicknames instead of standardized asset IDs. Without consistent identifiers, tracing an asset across purchase orders, insurance records, and tax schedules becomes difficult during audits.
In plain language: States the date the asset was placed in service and the full cost basis — including purchase price, freight, installation, and any capitalized setup costs.
Date Placed in Service: [YYYY-MM-DD] | Purchase Price: $[X] | Freight and Installation: $[X] | Total Cost Basis: $[X]
Common mistake: Recording only the invoice price and omitting freight, installation, and sales tax from the cost basis. Understating cost basis reduces allowable depreciation and can trigger adjustments on audit.
In plain language: Identifies the depreciation method applied to the asset — straight-line, declining-balance, sum-of-years-digits, or MACRS — and the authority or policy under which it was elected.
Depreciation Method: [Straight-Line / MACRS 5-Year / 200% Declining Balance] | Authority: [IRC §168 / Company Policy dated DATE] | First-Year Convention: [Half-Year / Mid-Month]
Common mistake: Applying different methods to similar assets in the same class without documentation. Tax authorities require consistency within asset classes — inconsistent treatment can trigger reclassification and penalties.
In plain language: Sets the estimated useful life in years for book purposes and, where different, the statutory recovery period for tax purposes.
Book Useful Life: [7] years | IRS MACRS Recovery Period: [5-Year Property] | Applicable Asset Class: [IRS Asset Class 00.12 — Information Systems]
Common mistake: Using the same useful life for both book and tax without noting the difference. Book and tax depreciation commonly diverge — treating them as identical creates deferred-tax errors in financial statements.
In plain language: Records the estimated residual value at end of useful life. For tax depreciation under MACRS, salvage value is treated as zero; for GAAP book depreciation, a realistic estimate is required.
Estimated Salvage Value (Book): $[X] | Salvage Value for Tax Purposes: $0 (MACRS — IRC §168(b)(4)) | Basis for Estimate: [Dealer quote / Historical average / Management estimate]
Common mistake: Setting salvage value to zero for book purposes when a realistic residual exists. This inflates annual depreciation expense, overstates asset consumption, and understates net income.
In plain language: Shows the year-by-year depreciation expense calculation, including the formula applied, the depreciable base, and the resulting annual charge for each period.
Year [1]: Depreciable Base $[X] × Rate [20%] = Annual Depreciation $[X] | Year [2]: Remaining Book Value $[X] × Rate [20%] = $[X] | [Continue for full useful life]
Common mistake: Rounding individual year calculations independently rather than carrying the exact figure forward. Compounded rounding errors can cause the total accumulated depreciation to differ from the depreciable base at the end of useful life.
In plain language: Tracks the running total of all depreciation charged to date and the resulting net book value at the end of each accounting period.
Period End: [YYYY-MM-DD] | Accumulated Depreciation to Date: $[X] | Net Book Value: $[COST BASIS minus ACCUMULATED DEPRECIATION]
Common mistake: Failing to update accumulated depreciation when an asset's useful life is revised. A mid-life change in useful life estimate requires a prospective recalculation from the revision date — not a restatement of prior periods.
In plain language: Documents the date and method of disposal, proceeds received, remaining net book value at disposal, and the resulting gain or loss recognized.
Disposal Date: [YYYY-MM-DD] | Disposal Method: [Sale / Trade-In / Write-Off] | Proceeds: $[X] | Net Book Value at Disposal: $[X] | Gain/(Loss): $[PROCEEDS minus NET BOOK VALUE]
Common mistake: Removing the asset from the register without recording the gain or loss. Unreported disposal gains are taxable income; unrecorded losses inflate asset balances and produce inaccurate financial statements.
In plain language: Records the name, title, and signature of the person who prepared the worksheet and the authorized reviewer or approver, confirming the information is accurate and complete.
Prepared by: [NAME], [TITLE] | Date: [YYYY-MM-DD] | Reviewed and Approved by: [NAME], [TITLE] | Date: [YYYY-MM-DD] | I attest that the information contained in this worksheet is accurate to the best of my knowledge.
Common mistake: Omitting the reviewer signature and treating the worksheet as a self-certified document. A signed preparer-and-reviewer attestation is required for audit trails, IRS examination responses, and lender due-diligence packages.
Enter a sequential or coded asset identifier, a plain-language description, the asset category (e.g., office equipment, vehicle, leasehold improvement), and the physical location and cost-center code.
💡 Use a coding convention that matches your accounting system — e.g., 'VEH-2026-003' for the third vehicle acquired in 2026 — so the worksheet auto-links to the general ledger.
Enter the date the asset was placed in service — not the purchase-order date or invoice date — and sum all capitalized costs: invoice price, freight, installation, testing, and applicable taxes.
💡 For leasehold improvements, include the cost of permits and architect fees in the cost basis; they are depreciable as part of the improvement.
Select the method appropriate for the asset class and jurisdiction — straight-line for GAAP book purposes, MACRS for US tax, capital allowances for UK tax. Record the authority (IRC section, accounting policy reference, or HMRC class) in the method field.
💡 Keep book and tax depreciation on separate rows or columns from the start — blending them in a single calculation creates reconciliation headaches at year-end.
Enter the book useful life in years and, where different, the IRS or statutory recovery period. For book depreciation, record a realistic salvage value based on dealer quotes or historical disposal data — not zero unless supportable.
💡 IRS Publication 946 lists the MACRS class lives for common asset types. Cross-reference it before assigning a recovery period to avoid a class-life mismatch.
Apply the elected formula to compute each year's depreciation charge. For straight-line: (Cost minus Salvage) ÷ Useful Life. For declining-balance: remaining book value × fixed rate. Carry the exact figures forward without rounding until the final period.
💡 Build the full depreciation table through the asset's entire useful life when you first enter the asset — this surfaces any errors in your useful-life or rate assumptions before they appear in a tax filing.
At each month-end or year-end close, add the current period's charge to accumulated depreciation and subtract from cost basis to derive net book value. Confirm the net book value matches the general ledger balance for that asset account.
💡 A variance between the worksheet's net book value and the GL balance signals an unrecorded addition, disposal, or impairment — investigate before signing financial statements.
When an asset is sold, traded in, or written off, enter the disposal date, proceeds, net book value at disposal, and the resulting gain or loss. Remove the asset from the active register and flag it as disposed.
💡 For mid-year disposals, calculate the partial-year depreciation up to the disposal date using the half-year, mid-quarter, or mid-month convention that matches the convention used at acquisition.
Have the person who completed the worksheet sign the attestation block, then route it to a senior accountant, CFO, or authorized officer for review and counter-signature before filing or presenting to third parties.
💡 Date each signature separately — the preparer date and reviewer date should reflect the actual workflow, not be backdated to the period-end date.
A depreciation worksheet is a formal accounting document that records each depreciable business asset's acquisition cost, elected method, useful life, salvage value, annual depreciation charge, accumulated depreciation, and net book value period by period. It serves as the supporting schedule behind the depreciation expense line on both financial statements and tax returns, and is typically required by auditors, lenders, and tax authorities as evidence that deductions are properly calculated and documented.
The worksheet supports all common methods: straight-line (equal annual charges), declining-balance (a fixed rate applied to remaining book value), sum-of-years-digits (an accelerated method weighting earlier years more heavily), and MACRS (the IRS-mandated method for US tax purposes). For Canadian tax, the worksheet can accommodate CCA class rates. The method elected should be documented in the worksheet and applied consistently within each asset class.
Most accounting software generates depreciation schedules automatically, but a standalone worksheet remains valuable for three reasons: it provides a portable, auditor-readable schedule that does not require software access; it allows you to reconcile book and tax depreciation side by side; and it documents the assumptions — useful life, salvage value, method — that drove the software's calculations. Tax professionals and auditors routinely request printed depreciation schedules even when software is in use.
Tangible assets with a useful life greater than one year that are used in a trade or business are generally depreciable. Common examples include machinery, vehicles, computers, furniture, buildings, and leasehold improvements. Land is not depreciable. Inventory, personal-use assets, and assets placed in service and disposed of in the same year are also generally excluded. In the US, intangible assets like patents and software are amortized rather than depreciated, though the worksheet structure is nearly identical.
Book depreciation follows GAAP (or IFRS) and is designed to match an asset's cost to the periods it generates revenue — the method and life should reflect economic reality. Tax depreciation follows IRS rules (MACRS in the US) and is designed to incentivize capital investment through accelerated deductions. The two schedules often diverge significantly, creating temporary differences that must be tracked for deferred-tax accounting on financial statements.
MACRS — Modified Accelerated Cost Recovery System — is the depreciation method the IRS requires for most tangible property placed in service after December 31, 1986. It assigns assets to recovery classes (3, 5, 7, 10, 15, 20, 27.5, or 39 years) and applies declining-balance rates with a switch to straight-line when straight-line yields a larger deduction. IRS Publication 946 provides the class-life tables. Real property uses the straight-line method over 27.5 years (residential rental) or 39 years (non-residential).
Section 179 allows you to deduct the full cost of qualifying equipment and property in the year of purchase rather than spreading it over the recovery period. It is most advantageous when you have sufficient taxable income to absorb the deduction and when the asset qualifies — generally tangible personal property and certain software, but not buildings or land. The annual deduction limit for 2024 is $1,220,000 with a phase-out beginning at $3,050,000 of total qualifying property placed in service. Bonus depreciation is an alternative for property that does not qualify for Section 179.
A depreciation worksheet used as a supporting schedule for a tax return, financial statement audit, or lender package should carry the signature of the preparer and an authorized reviewer. The signature block creates an audit trail confirming who prepared the schedule, when it was reviewed, and that the information was attested as accurate. Unsigned schedules submitted in response to an IRS examination are typically accepted but may prompt additional scrutiny.
Depreciation reduces taxable income by the amount of the annual deduction, lowering the current-year tax liability. On the income statement, it appears as a non-cash operating expense that reduces net income. On the balance sheet, accumulated depreciation offsets the gross asset value to show net book value. Because tax and book depreciation often differ, companies carrying both schedules must record deferred tax liabilities (when book income exceeds taxable income) or deferred tax assets (when taxable income exceeds book income).
A fixed asset register is a comprehensive inventory of all company-owned assets — including non-depreciable items like land — tracking location, condition, insurance value, and responsible department. A depreciation worksheet focuses specifically on the depreciation calculations and tax/book reconciliation for depreciable assets. Both documents are needed: the register for asset management, the worksheet for accounting and tax compliance.
The balance sheet shows the net book value of all fixed assets as a single line item — property, plant, and equipment net of accumulated depreciation. A depreciation worksheet is the supporting detail behind that line, showing how each asset's value was calculated. Auditors and lenders always request the worksheet to verify the balance-sheet figure.
An amortization schedule allocates the cost of intangible assets — patents, trademarks, customer lists, software — over their useful lives, following the same logic as depreciation but governed by different tax code sections (IRC §197 for acquired intangibles). A depreciation worksheet covers tangible property. Businesses with both tangible assets and intangibles need both schedules.
A cash flow statement adds back depreciation as a non-cash charge under operating activities because depreciation reduces net income without consuming cash. The depreciation worksheet provides the exact figure added back. Without an accurate worksheet, the cash flow statement's operating-activities section will not reconcile to the income statement.
Heavy equipment, tooling, and production lines with high cost bases require multi-method schedules that separately track MACRS tax depreciation and GAAP straight-line book depreciation for each asset class.
Residential rental property depreciates over 27.5 years and commercial property over 39 years under MACRS, with cost segregation studies used to reclassify components to shorter recovery periods and accelerate deductions.
Server hardware, data-center equipment, and internally developed software each carry different recovery periods and may qualify for bonus depreciation or Section 179, requiring careful classification on the worksheet.
Office furniture, leasehold improvements, and computer equipment are the primary depreciable assets; the worksheet supports lease-term useful-life limitations on improvements and tracks the office-use percentage for mixed-use assets.
US tax depreciation is governed by MACRS under IRC §168. Most personal property falls into 5-year or 7-year classes; non-residential real property uses a 39-year straight-line schedule. Section 179 (IRC §179) and bonus depreciation (IRC §168(k)) allow accelerated first-year deductions subject to annual limits and phase-down schedules. The half-year convention applies to most personal property unless the mid-quarter convention is triggered by placing more than 40% of property in service in Q4.
Canadian tax depreciation uses Capital Cost Allowance (CCA) governed by the Income Tax Act and administered through CCA classes (e.g., Class 8 at 20%, Class 10 at 30%, Class 1 buildings at 4%). The half-year rule limits the deduction to 50% of the normal CCA in the year of acquisition. Accelerated Investment Incentive (AII) provisions introduced in 2018 allow an enhanced first-year CCA for eligible property. Quebec follows federal CCA rules but applies provincial corporate tax adjustments.
UK businesses claim Capital Allowances rather than depreciation for tax purposes, governed by the Capital Allowances Act 2001. The main pool Annual Investment Allowance (AIA) allows 100% deduction on qualifying plant and machinery up to £1,000,000 per year. Writing Down Allowances (WDA) apply at 18% (main rate pool) or 6% (special rate pool, including integral building features and long-life assets). Book depreciation under FRS 102 or IFRS follows useful-life estimates set by management and does not affect tax directly.
EU member states each set their own statutory depreciation rates for tax purposes — Germany's AfA tables, France's amortissement fiscal, and Spain's tablas de amortización all prescribe asset-class rates that differ materially from each other and from IFRS book depreciation. IFRS (mandatory for listed companies) requires useful-life depreciation under IAS 16 with annual impairment testing. GDPR is not directly relevant to depreciation worksheets, but any worksheet containing employee asset-custody data should be stored in line with local data retention policies.
| Path | Best for | Cost | Time |
|---|---|---|---|
| Use the template | Small businesses and freelancers with straightforward fixed assets and a single depreciation method | Free | 30–60 minutes per asset at setup; 15 minutes per period close |
| Template + legal review | Businesses with multiple asset classes, mixed book and tax methods, or first-year Section 179 and bonus depreciation elections | $150–$500 for a CPA or tax professional review | 1–3 days |
| Custom drafted | Real estate investors with cost segregation studies, manufacturers with complex asset pools, or businesses under IRS examination | $500–$3,000+ for CPA-prepared schedules or cost segregation analysis | 1–4 weeks |
This document is one of 3,000+ business & legal templates included in Business in a Box.
Access over 3,000+ business and legal templates for any business task, project or initiative.
Customize your ready-made business document template and save it in the cloud.
Share your files and folders with your team. Create a space of seamless collaboration.
"Fantastic value! I'm not sure how I'd do without it. It's worth its weight in gold and paid back for itself many times."
"I have been using Business in a Box for years. It has been the most useful source of templates I have encountered. I recommend it to anyone."
"It has been a life saver so many times I have lost count. Business in a Box has saved me so much time and as you know, time is money."
Stop downloading documents. Start operating with clarity. Business in a Box gives you the Business Operating System used by over 250,000 companies worldwide to structure, run, and grow their business.
Free Forever Plan · No credit card required
