Identification
Unique asset ID, vendor, invoice number, and acquisition date to support traceability during audits and reconciliations.
A clear worksheet ensures accurate tax reporting, simplifies audits, and preserves evidence for basis and deduction calculations while supporting timely claims and amendments.
Common preparers and users range across internal accounting, tax preparers, and external auditors.
The worksheet is a working record used during year-end close, tax filing, and any IRS examination or financial review.
Unique asset ID, vendor, invoice number, and acquisition date to support traceability during audits and reconciliations.
Detailed purchase price and capitalizable items such as installation, freight, and sales tax to establish starting basis for depreciation.
IRS property class, applicable GDS/ADS election, and placed-in-service convention to ensure correct lifecycle and deduction timing.
Selected depreciation method and useful life in years, with notes on elections like Section 179 or bonus depreciation.
Per-year depreciation entries, prorations for partial years, and accumulated totals for each asset.
Disposition dates, sales proceeds, and gains or losses documented for retirements and sales.
Save a locked PDF copy that preserves layout and calculations for offline review and long-term storage.
Maintain a formula-based spreadsheet allowing year-over-year rollups and audit trails of cell-level calculations.
Use CSV for data import into accounting systems and for bulk reconciliation or analytics.
Retain a signed copy (electronic or physical) showing preparer attribution and sign-off date.
| Field | Configuration |
|---|---|
| Asset ID | Auto-numbering, required |
| Placed-in-Service | Date field, MM/DD/YYYY |
| Depreciation Method | Dropdown with IRS options |
| Preparer Signature | Required eSignature field |
Choose a platform that supports fillable PDFs, formula fields, and secure eSignature with an audit trail.
Configure role-based access, versioning, and export settings so signed worksheets are reproducible and meet evidentiary requirements.
Complete worksheet by year-end close for accurate reporting.
Attach or reference totals when filing Form 1040, 1120, or partnership returns by Apr 15 (or extended date).
File Form 1040X or corresponding amendment within three years of original filing if corrections needed.
Election must be made on the timely filed return for the year the property is placed in service.
Retain supporting documents for the IRS-recommended minimum period.
Document invoice, vendor, and cost basis immediately after purchase.
Confirm the operational date that triggers depreciation start.
Compute annual depreciation and reconcile to accounting ledger.
Report totals on tax schedules when submitting the return.
| Criteria | Spreadsheet Ledger | Tax Schedule Attachment |
|---|---|---|
| Purpose | detailed asset tracking | tax reporting summary |
| Level of detail | high detail | summarized totals |
| Use case | monthly reconciliations | annual tax filing |
| Sign-off required | often yes | typically preparer signature |
| signNow | DocuSign | Adobe Sign | PandaDoc | HelloSign | |
|---|---|---|---|---|---|
| Starting Price | $8/user/mo | $15/user/mo | $14/user/mo | $19/user/mo | $15/user/mo |
| Free Trial | 7-day free trial | Varies by plan | Varies by plan | Varies by plan | Varies by plan |
| Bulk Send | Yes | Yes | Yes | Yes | Yes |
| Audit Trail | Yes | Yes | Yes | Yes | Yes |
| HIPAA Compliant | Yes | Yes | Yes | No | No |
| Envelope Cap | No cap | 100 envelopes/user/year | Varies | Varies | Varies |
A small CPA prepares asset schedules for clients at year-end to support Form 4562 entries.
A property manager tracks building improvements and cost segregation allocations annually.
A tax preparer populates depreciation fields, validates elected treatments, and signs to attest accuracy; the preparer should retain copies of supporting invoices and workpapers for audit defense.
The controller reviews totals, reconciles to the general ledger, and signs off on internal financial reporting; this role ensures depreciation is reflected correctly in financial statements.