How to Get a Depreciation Report

A depreciation report is one of the most important documents in your financial toolkit. It directly affects your tax liability and the accuracy of your balance sheet. Understanding this report and how to create it is key for good financial management. This guide provides the information you need and step-by-step instructions for creating a depreciation report using accounting software, your accountant's services, or a simple spreadsheet.

What Is a Depreciation Report (and Why Do You Need One)?

A depreciation report, often called a depreciation schedule, lists your business's fixed assets and shows how their value has decreased over time. Fixed assets are tangible items you own that have a useful life of more than a year, such as vehicles, machinery, buildings, and computers. Depreciation is the accounting process of spreading the cost of these assets over their useful life.

This report is more than just a record. It's a critical tool for several business functions. A good depreciation schedule shows the story of your company's physical assets.

A typical depreciation report includes several key data points for each asset:

• Asset Description: A clear, specific name for the asset (e.g., "2023 MacBook Pro M2").
• Purchase Date / Date Placed in Service: The day you started using the asset for business.
• Cost Basis: The original purchase price plus any costs to get it ready for use (like shipping, taxes, and installation fees).
• Useful Life: The estimated number of years the asset will be productive for your business, often guided by IRS publications.
• Depreciation Method: The formula used to calculate the expense, such as Straight-Line or Modified Accelerated Cost Recovery System (MACRS).
• Accumulated Depreciation: The total depreciation expense recorded for the asset since it was placed in service.
• Book Value: The asset's remaining value on your books (Cost Basis minus Accumulated Depreciation).

Without this report, your financial picture is incomplete. Its main purposes are:

• Tax Compliance and Planning: Depreciation is a non-cash expense you can deduct on your tax return, lowering your taxable income. An accurate report ensures you claim the correct amount and can defend it in an audit.
• Accurate Financial Statements: Depreciation expense goes to your income statement, and accumulated depreciation reduces the value of assets on your balance sheet. Without it, your profitability will be overstated and your company's net worth will be incorrect.
• Strategic Business Decisions: Knowing the book value and remaining useful life of your assets helps you decide when to repair, replace, or upgrade them. This helps with capital budgeting and managing cash flow.
• Business Valuation: If you plan to sell your business, apply for a loan, or attract investors, they will want to see an accurate valuation of your assets, which requires a proper depreciation schedule.

Gathering the Right Information: The Foundation of Your Report

Your depreciation report is only as good as your asset records. Before you can create a schedule using any method, you need to collect detailed information for every fixed asset your business acquires.

Start by making a master list of your fixed assets. For each item, you must have the following details documented and supported by records like invoices and receipts:

• Specific Asset Description: Avoid general names. Instead of "Computer," use "Dell OptiPlex 7000, Serial # XYZ123." This prevents confusion if you own multiple similar assets.
• Date Placed in Service: This is a critical date for tax purposes and can be different from the purchase date. It's the day the asset was ready for its intended use in your business.
• Full Cost Basis: This isn't just the price on the receipt. It includes every cost needed to make the asset ready for service. For a new commercial printer, this could be the purchase price, sales tax, a delivery fee, and the cost of the technician who set it up.
• Estimated Useful Life: For tax purposes in the U.S., useful life is set by the IRS under the MACRS framework, which assigns assets to specific property classes (e.g., computers are generally 5-year property, and office furniture is 7-year property).
• Salvage Value (for book purposes): This is your estimate of what the asset will be worth at the end of its useful life. For tax depreciation (MACRS), salvage value is assumed to be zero. For financial reporting using methods like straight-line, it is a factor.

Keeping a dedicated folder-either physical or digital-for fixed asset receipts is a good practice. When you buy a qualifying asset, immediately save the invoice and add the item's details to your master asset list. This organized approach will save you a lot of time later.

Method 1: Using Accounting Software to Create a Report

For most businesses, using accounting software is the most efficient and reliable way to manage fixed assets and create a depreciation report. Dedicated modules or features automate calculations, reduce errors, and connect with your general ledger.

For Xero Users

Xero has a fixed asset register that simplifies depreciation management. Once an asset is registered, Xero can automatically calculate depreciation, post the journal entries, and create a report.

Here’s the process:

1. Register the Asset: Go to Accounting > Advanced > Fixed assets. Click "New Asset" and enter all the details you gathered: asset name, purchase date, cost, depreciation method, and useful life.
2. Set Depreciation Rules: Xero allows you to set up depreciation for both tax (e.g., Double Declining Balance at 200%) and financial reporting (e.g., Straight-Line) purposes. You fill in the asset's start date and select the correct method.
3. Run the Depreciation Schedule: Once assets are registered, Xero automatically calculates the schedule. To see the report, go to Accounting > Reports and select "Depreciation Schedule." You can filter the report by date to see depreciation for a specific period and a full forecast. Xero can also post monthly depreciation journals for you, keeping your books up to date.

For QuickBooks Users

Depreciation handling in QuickBooks can differ. QuickBooks Desktop (Premier and Enterprise) includes a Fixed Asset Manager (FAM) tool that tracks assets and calculates depreciation expenses. QuickBooks Online, however, does not have an automated depreciation scheduler. QB Online users typically use one of three approaches:

1. Manual Journal Entries: You or your accountant calculate the depreciation expense (often in a spreadsheet) and periodically record it in QBO with a journal entry debiting Depreciation Expense and crediting Accumulated Depreciation. This is simple but requires manual work.
2. Third-Party Apps: The QuickBooks App Store offers specialized fixed asset management apps that integrate directly with QBO. These apps track assets and sync depreciation entries automatically, providing the functions missing from the core product.
3. Accountant's Tools: Many business owners let their CPA handle the final depreciation calculation. The CPA uses professional tax and accounting software to create the schedule and then provides a single annual journal entry to record in QuickBooks.

Method 2: Working with Your CPA or Accountant

For many businesses, having a CPA or accounting professional handle depreciation reporting is the most practical choice. Tax rules for depreciation-especially with complex concepts like bonus depreciation, Section 179 expensing, and luxury vehicle limits-are complicated and change often. An expert makes sure you stay compliant and get the best tax deductions.

Your role in this process is to provide your accountant with clear, organized records. At the end of the year, they will ask for a list of all fixed assets purchased or sold during that period. The master asset list you created earlier, along with supporting invoices, is exactly what they need.

The benefits of this method are significant:

• Access to Expertise: Your accountant knows the tax code well. They understand the details of MACRS and how to apply special depreciation rules that you might miss.
• Professional Tools: Accountants use advanced professional software, such as Drake Tax or Thomson Reuters CS Suite, made for these complex calculations, which connect directly into the business tax return preparation process.
• Strategic Insight: The accountant’s role turns data into decisions. They can advise you on whether it’s better to expense an asset immediately under Section 179 or depreciate it over a number of years, based on your company's tax situation. This advice is where true value comes from.

Method 3: Creating a Depreciation Schedule in Excel (For Basic Needs)

If you have only a few simple assets and are comfortable with spreadsheets, you can build your own depreciation schedule in Excel or Google Sheets. This method gives you total control but is manual and has a higher chance of error. It is best for internal record-keeping rather than formal tax filing preparation without a final review.

To build a simple straight-line depreciation schedule, follow these steps:

1. Set Up Your Columns: Create a spreadsheet with columns for: Asset Description, Date in Service, Cost Basis, Useful Life, Salvage Value, Annual Depreciation, Accumulated Depreciation (Year 1, 2, 3…), and End-of-Year Book Value.
2. Input Your Asset Data: Fill in the first five columns with the main information for each of your fixed assets.
3. Calculate Annual Depreciation: In the "Annual Depreciation" column, enter the straight-line formula: =(Cost Basis - Salvage Value) / Useful Life. For example, a 5,500 machine with a 500 salvage value and a 5-year life would have an annual depreciation of $1,000.
4. Track Accumulated Depreciation and Book Value: For each year, the accumulated depreciation is the sum of all depreciation claimed to date. The book value is calculated as =Cost Basis - Accumulated Depreciation. Your table should show the book value decreasing to the salvage value at the end of the asset's useful life.

Excel also includes financial functions like SLN (Straight-Line), DB (Fixed-Declining Balance), and SYD (Sum-of-Years' Digits) that can automate the calculations. However, note that this manual approach doesn't easily follow the mandatory MACRS rules required for U.S. tax filings, which involve specific conventions and percentage tables.

Final Thoughts

Creating and maintaining a depreciation report is a basic accounting task. Whether you use software like Xero, work with a CPA, or manage a simple spreadsheet, having this report is important for tax planning, financial accuracy, and making strategic decisions.

Keeping up with the complex tax rules for depreciation-like Section 179 limits or the latest bonus depreciation phase-outs-can take a lot of time. We built Feather AI to give tax professionals instant, citation-backed answers to these questions, turning hours of research into a simple query. It helps you focus on advising your clients or company about asset strategy, not just looking up the rules.