Depreciation schedule template for accounting

A depreciation schedule turns the cost of a long-term asset into a clear series of accounting entries. Instead of recording the entire purchase as an expense immediately, a business allocates the asset’s depreciable value across the period in which it is expected to provide benefits. This makes reports easier to understand and gives owners a practical record for financial statements, budgeting and tax preparation.

A reusable spreadsheet is especially helpful when a business owns computers, vehicles, machinery, office furniture, shop fittings or specialised equipment. The right worksheet can track purchase dates, asset categories, depreciation methods, accumulated depreciation and written-down values without requiring calculations to be rebuilt every month.

What the schedule should contain

A useful fixed asset register begins with an identifying section. Include an asset number, description, supplier, invoice reference, location, responsible department and purchase date. For an Australian business, it is also sensible to record the amount paid in Australian dollars and show whether the figure includes or excludes GST, depending on the reporting purpose.

The financial fields should include the original cost, estimated residual value, useful life, depreciation method, depreciation start date and current book value. A schedule may also include the asset’s serial number, warranty expiry, insurance details and disposal date. These extra columns help connect the spreadsheet to purchasing records and make an annual review less time-consuming.

A strong template separates historical information from calculated fields. Users should enter the asset details and assumptions in one area, while formulas calculate the depreciation expense, accumulated depreciation and closing written-down value. This reduces accidental overwriting and makes it easier to copy the structure for a growing asset register.

For businesses already tracking transactions in a separate workbook, an accounting ledger template can complement the fixed asset schedule. The ledger records the related cash or payable transaction, while the depreciation worksheet records the non-cash expense and the changing value of the asset.

Choosing a depreciation method

Straight-line depreciation is often the easiest method to explain and maintain. It spreads the depreciable amount evenly over the asset’s useful life. The basic formula is:

Annual depreciation = (Cost − Residual value) ÷ Useful life

For example, a $12,000 piece of equipment with a $2,000 residual value and a five-year useful life would produce annual depreciation of $2,000. A monthly schedule would generally divide that annual amount across twelve periods, with adjustments for the date the asset was placed into service.

The diminishing-value method produces a larger expense in the earlier years and smaller amounts later. It can be appropriate where an asset loses value quickly or provides greater economic benefit when new. A spreadsheet should show the opening written-down value, applicable rate, current-period depreciation and closing written-down value for each reporting period.

The units-of-production method links depreciation to usage rather than time. It may suit manufacturing equipment, delivery vehicles or other assets where hours, kilometres or production units provide a better measure of consumption. The worksheet needs an estimated total capacity and a field for actual use during each period.

Accounting depreciation and tax depreciation do not always follow the same method or useful life. A business may use one set of figures for financial reporting and another for its Australian tax return. Keeping separate accounting and tax columns prevents a book value from being confused with a tax written-down value.

Australian records and tax considerations

In Australia, the Australian Taxation Office generally provides guidance about effective lives, depreciating assets and methods such as prime cost and diminishing value. Tax treatment can also depend on the asset type, business structure, date acquired, private use and concessions available at the time. A template should support those decisions, but it should not replace advice from a registered tax agent.

GST treatment deserves careful attention. A GST-registered business may record the asset cost excluding recoverable GST for many accounting purposes, while a business that cannot claim the full credit may need a different treatment. The schedule should include a GST status column and a note explaining whether the recorded cost is GST-inclusive or GST-exclusive.

The timing of the first depreciation charge should be defined clearly. An asset may be purchased in June but not installed or available for use until July. In that situation, the schedule should distinguish the invoice date from the date the asset was placed in service. This is particularly useful around the Australian end of financial year on 30 June, when businesses review additions and prepare tax records.

Small businesses in Sydney, Melbourne or Brisbane may have a mixture of office technology, fit-out costs and motor vehicles, while a farm or regional enterprise may hold plant, irrigation equipment or heavy machinery. The same spreadsheet framework can accommodate these assets, provided each category has an appropriate useful life, method and supporting documentation.

Building formulas that stay reliable

A monthly depreciation schedule should calculate the number of depreciable periods rather than relying on manual entries. A common structure includes columns for opening book value, additions, disposals, depreciation expense and closing book value. The closing figure can be calculated as:

Closing book value = Opening book value + Additions − Disposals − Depreciation

The formula should include a safeguard so depreciation stops when the book value reaches the residual value. It should also stop after the useful life ends. Without these controls, a copied formula can continue reducing an asset below its intended minimum value.

Partial-year depreciation needs a consistent policy. Some businesses calculate by month, while others use daily calculations for greater precision. A template can include a start month and end month, then calculate the eligible fraction of the year. Whichever approach is selected should be applied consistently and documented in the worksheet instructions.

Disposals should not be handled by simply deleting a row. Keep the original cost, accumulated depreciation, proceeds, disposal date and resulting gain or loss. Mark the asset as disposed and exclude it from future depreciation calculations. Preserving the row creates an audit trail and helps reconcile the asset register with the general ledger.

Use data validation for depreciation methods, asset categories and GST status. Protect formula cells, freeze the header row and add a separate assumptions tab. Conditional formatting can highlight assets that are fully depreciated, missing a purchase date, approaching disposal or carrying an unusual negative balance.

Reviewing the register throughout the year

A depreciation schedule is most valuable when it is updated as transactions occur, rather than reconstructed at tax time. Each new asset should be added after the invoice, delivery record and payment details have been checked. A monthly or quarterly review can identify missing purchases, duplicated entries and assets that are no longer in service.

Reconcile the total cost and accumulated depreciation in the register to the corresponding general ledger accounts. If the figures differ, investigate whether an asset was posted directly to repairs, whether a disposal was omitted or whether a journal entry used the wrong account. The reconciliation should be saved with the reporting records.

Physical checks are also worthwhile. A business with equipment spread across a warehouse in Perth, a retail site in Adelaide and an administrative office in Canberra may discover that an asset has moved, been replaced or become unusable. Updating the location and condition fields makes the register more accurate and supports insurance and risk management.

The worksheet can also support management decisions. Comparing an asset’s age, maintenance cost and remaining book value may reveal when replacement planning is needed. A vehicle with a low accounting value may still be operational, while a newer machine may have a high book value but require expensive repairs. Depreciation is therefore one part of a broader asset-management process.

For classroom learning, bookkeeping practice or small-business administration, reusable financial worksheets can make abstract concepts easier to apply. A complementary learning resource may help students or new business owners strengthen their understanding of journals, ledgers and financial statements before adapting a schedule to real records.

Making the template practical for daily use

Start with a clean workbook containing an instructions tab, an asset register, a depreciation calculation sheet and a summary report. The instructions should explain whether costs include GST, which depreciation method is being used, how partial periods are calculated and which cells users are expected to edit.

The summary page can show total original cost, current-period depreciation, accumulated depreciation and net book value by category. Separate totals for vehicles, computer equipment, furniture, buildings and plant can help management review investment levels. A filterable register is usually more useful than a visually complex dashboard.

Keep a copy of the original template before entering live data, then save dated versions as the register changes. Store invoices, contracts and disposal evidence using file names that match the asset numbers. This makes the spreadsheet easier to verify during an accountant’s review, an audit or an insurance claim.

Before relying on the completed schedule, check formulas using a sample asset and calculate the result manually. Review the first month, a full year, the final depreciation period and a disposal scenario. A few test cases can reveal errors that might otherwise affect many rows.

Download a reusable spreadsheet, customise the headings for your business and enter assets from the current financial year first. With consistent records, protected formulas and regular reconciliation, the schedule becomes a dependable part of everyday accounting rather than a rushed end-of-year task.