How to Track Fixed Assets Without an ERP

By Gregg Hopfeldt · 2025-05-20

You do not need an ERP to maintain a defensible fixed asset register. You need the right structure, the right records, and the discipline to maintain both.

Most businesses that track fixed assets in spreadsheets fail audits not because their depreciation math is wrong, but because the assumptions behind the math are undocumented, inconsistent, or missing entirely.

The Purpose

A fixed asset register exists to answer one question from an auditor: prove that this depreciation deduction is legitimate.

The answer requires four things:

1. Original cost, supported by invoice or capitalization policy
2. Placed-in-service date, documented as the date the asset became operational
3. Depreciation method and rate, applied consistently across similar assets
4. Business-use percentage, especially for vehicles and listed property

If your register cannot produce these four elements on demand, the deduction is at risk regardless of whether the calculation itself is correct.

The Non-Negotiables

IRS Publication 946 establishes the recordkeeping requirements for fixed assets. These rules apply whether you use a spreadsheet, standalone software, or a full ERP system.

What you must track for each asset

• Asset identity: Name, description, unique ID or tag number
• Acquisition cost: Purchase price plus taxes, shipping, installation, and any cost required to make the asset operational
• Placed-in-service date: The date the asset was ready and available for use — not the purchase date
• Business-use percentage: The portion of the asset used for business or income-producing activity
• Depreciation method: Straight-line, declining balance, MACRS, or another permitted method
• Recovery period: The useful life or MACRS class life for the asset
• Accumulated depreciation: Total depreciation claimed to date
• Disposal details: Date disposed, sale price, remaining book value, gain or loss

What you must retain

• Invoices or purchase contracts that establish cost basis
• Documentation of the placed-in-service date
• Records of business-use percentage for vehicles and listed property
• Election forms for Section 179 or bonus depreciation
• Disposal records and gain/loss calculations

The IRS requires that records be retained long enough to support recapture exposure — typically the recovery period of the asset plus three years.

Land is never depreciable. If your register includes land as a depreciable asset, the entire schedule is suspect.

The Boring Math

Straight-line depreciation

Annual Depreciation = (Cost − Salvage Value) ÷ Useful Life

Declining balance depreciation

Double Declining Balance Rate = 2 ÷ Recovery Period

150% Declining Balance Rate = 1.5 ÷ Recovery Period

Periodic Depreciation = Beginning Book Value × Rate

You must switch to straight-line when it yields an equal or larger deduction.

MACRS depreciation

MACRS depreciation = Unadjusted Basis × Table Rate from IRS Publication 946, Appendix A

Common recovery periods:

• 5-year: Automobiles, computers, office equipment
• 7-year: Office furniture, fixtures, most equipment
• 15-year: Land improvements, qualified leasehold improvements
• 27.5-year: Residential rental property
• 39-year: Nonresidential real property

Mid-quarter convention trigger: If more than 40% of your total MACRS basis is placed in service in the last three months of the tax year, you must use the mid-quarter convention instead of half-year.

Section 179 deduction

Section 179 allows immediate expensing of qualifying property in the year placed in service.

2025 Limits:

• Maximum deduction: $2,500,000
• Phaseout begins at: $4,000,000 of qualifying property placed in service
• SUV limit: $31,300

Section 179 property must be used more than 50% for business in the year placed in service.

Bonus depreciation

For certain qualified property acquired after January 19, 2025, the bonus depreciation rate is 100%.

The order of operations

Deductions must be applied in the correct sequence:

1. Section 179 first
2. Bonus depreciation second
3. Regular MACRS third

The Platform Decision

A spreadsheet can calculate depreciation. It cannot enforce compliance.

What spreadsheets do well

• Calculate straight-line and declining balance depreciation
• Sum columns and produce totals
• Export to formats auditors can read

What spreadsheets fail to do

• Enforce consistency: A rate change applies to some rows but not others; formula drift accumulates over time
• Preserve audit trail: A changed cell overwrites the prior value; a deleted row disappears with no record
• Flag incomplete records: Missing placed-in-service dates or business-use percentages do not trigger validation errors
• Handle disposals correctly: Assets continue depreciating after disposal; gain/loss calculations require manual reconstruction
• Separate book from tax: One schedule serves both purposes, creating confusion and audit exposure

The Failure Points

The Steps

Establish the foundation

1. Define your capitalization threshold — the minimum cost at which an expenditure becomes a fixed asset rather than an expense. Common threshold: $5,000.
2. Document depreciation policies for each asset category: method, recovery period, and whether MACRS applies for tax purposes.
3. In Simple Fixed Assets, configure depreciation methods, asset lives, and limits before adding assets.
4. Anchor all depreciation calculations to your specific financial year-end.
5. Configure Depreciation Settings by Category: set the Rate (%) and Method for each asset type.
6. Click Save Configuration to lock in the settings before adding assets.

Enter assets correctly

1. Enter individual assets using Smart Entry for guided single entry, or Import CSV to migrate existing spreadsheets.
2. For each asset, verify the placed-in-service date, cost basis, business-use percentage, and category are correct.

Maintain the register

1. Record disposals as they occur using Assets → Trade / Dispose. A disposal requires: disposal date, sale price, accumulated depreciation at disposal, and resulting gain or loss.
2. Reconcile the register to financial statements at each period end: Opening Balance + Additions − Disposals − Depreciation = Closing Balance.
3. Use filters and groups to isolate categories and confirm depreciation calculations match expectations.
4. Conduct periodic physical verification.

Close the year

1. Complete all disposals before year-end rollover.
2. Generate an audit report that traces opening to closing balance.
3. Run the Year-End Rollover to carry the ending accumulated depreciation forward as the new year's opening balance.

Common Concerns

Can I use one depreciation schedule for both book and tax?

No. GAAP and IRS Publication 946 use different methods, recovery periods, and conventions. Maintain separate schedules.

What if I don't have the placed-in-service date for older assets?

Establish the best available evidence: operational memos, installation records, insurance policies, or contemporaneous notes. Document your basis for the date you select.

How do I handle partial business use?

Track the business-use percentage for each asset where use is mixed. Multiply the depreciable basis by the business-use percentage to determine the deductible portion. If business use falls to 50% or less, recapture may apply.

How long must I retain fixed asset records?

Retain records for the recovery period of the asset plus three years to cover recapture exposure.

A defensible fixed asset register answers the auditor's question without manual reconstruction. Every deduction traces to documented inputs. Every asset has a placed-in-service date, a method, a rate, and a business-use percentage. Disposals are recorded before depreciation continues. Book and tax schedules are separate. The audit trail is complete.

This is the compliance backbone that spreadsheets cannot provide. It is achievable without an ERP — through structured process, disciplined entry, and records that survive scrutiny.

When you're ready, get started with a register.

Stay Depreciated,

Gregg