Most finance teams know exactly how many laptops, vans and machines they own. Right up until year-end, when someone compares the fixed asset register against what is actually in the building and the numbers stop agreeing.

The problem is rarely carelessness. It is that the register lives in a spreadsheet, while purchases, sales and write-offs happen everywhere else. Fixed asset management in Microsoft Dynamics 365 Business Central closes that gap by recording every stage of an asset's life in the same system that runs your ledger. This guide covers how it works in practice: automated depreciation, acquisition and disposal tracking, insurance and maintenance records, and what replacing the spreadsheet register really changes.

Why the spreadsheet register keeps breaking

A spreadsheet register is a copy of reality that someone has to keep updating by hand. When an asset is bought, a purchase invoice goes through accounts payable. When it is sold, a sales invoice goes out. When it is scrapped, the warehouse might never tell finance at all. Each of those events has to be remembered and re-keyed into the register, usually by one person, usually in a hurry.

Research backs up what most accountants already suspect. Ray Panko, whose work on spreadsheet accuracy is among the most cited in the field, concluded that errors are rare on a per-cell basis, but in large spreadsheets at least one incorrect bottom-line value is very likely to be present, and that those errors are hard to detect. A register that feeds your balance sheet and your depreciation charge is exactly the kind of workbook where that matters.

Before and after: the disposed asset still on the books

Before. A distribution business sells two delivery vans in March and buys a replacement. The sale goes through as a sales invoice to "other income", and the new van is added to the register. Nobody removes the old vans. For the rest of the year, the monthly depreciation journal (copied forward from the spreadsheet) keeps charging depreciation on vehicles that are now parked on someone else's forecourt.

At year-end, the auditors ask for a physical verification of vehicles. Two are missing. The finance team spends several days tracing invoices, reversing nine months of depreciation, calculating the gain or loss on sale, and reclassifying the income. The capital allowances position also has to be revisited, because HMRC expects disposals to be included in the accounting period you sell the asset in. The accounts are delayed, and confidence in the register takes a knock.

After. The same business runs fixed assets in Business Central. When the vans are sold, the sales invoice line is posted against the fixed asset itself, or a disposal is posted through the fixed asset G/L journal. Business Central calculates the gain or loss against the asset's book value and posts it to the accounts set up in your FA posting groups. From that point the asset is marked as disposed, and the Calculate Depreciation batch job skips it automatically, because it ignores sold, blocked and inactive assets. The year-end check becomes a report rather than an investigation.

Automated depreciation calculations

Depreciation is where manual registers are most exposed, because a small formula error repeats every month. In Business Central, each asset is assigned a depreciation book with its method, start date and useful life. The system supports eight depreciation methods, including straight-line, declining-balance, combined DB1/SL, half-year convention and user-defined tables.

Each month (or quarter), the Calculate Depreciation batch job creates the journal lines for every eligible asset. Your team reviews them and posts. Because depreciation is calculated daily, you get an accurate charge for part periods, which matters when assets are bought or sold mid-month.

You can also hold more than one depreciation book per asset. That is useful if you want one book aligned with your accounting policy under FRS 102 or IAS 16 Property, Plant and Equipment, and another for internal management reporting, without maintaining two spreadsheets.

Asset acquisition and disposal tracking

The cleanest way to keep the register right is to make it impossible to buy or sell an asset without the register knowing. Business Central does this in three ways:

• Purchase invoices and orders. Set the line type to Fixed Asset and the acquisition cost posts straight to the asset card. If you buy several identical items, the system can create the asset cards for you.
• Assisted acquisition. The Acquire action on the asset card walks users through the posting, so people who don't specialise in finance can record acquisitions correctly.
• Controlled disposals. A disposal must be the final entry posted for an asset, which stops further transactions against something you no longer own. For partial disposals, you split the asset first, so the history stays traceable.

Mistakes can still happen, but they are corrected with the Cancel FA Entries batch job rather than by overwriting a cell, so the audit trail stays intact.

Insurance and maintenance records tied to assets

A spreadsheet register tends to hold cost and depreciation, while insurance schedules and service records sit in separate files. Business Central keeps them on the asset.

For insurance, you create policies and assign assets to them, either manually or automatically when acquisition costs are posted. The Insurance Statistics page shows whether a policy is over or under insured, and the Uninsured FAs report flags assets that were never assigned to a policy. When an asset is sold, its Insured flag switches off automatically, which helps you avoid paying premiums on equipment you no longer hold.

For maintenance, costs can be posted from vendor invoices with the Maintenance posting type, so repair spend is recorded against the right asset without increasing its book value. Maintenance registrations capture service dates and the service provider, and the Maintenance Next Service report tells you what is due. Over time, you build a clear picture of the true running cost of each asset, which makes replace-or-repair decisions much easier.

What replacing the spreadsheet actually changes

Moving the fixed asset register into Business Central is less about new features and more about removing the re-keying step. In practice, that means:

• One source of truth. Asset balances in the register and the general ledger come from the same postings, so they reconcile by design, and the Fixed Asset G/L Analysis report lets you prove it.
• Faster month-end and year-end close. Depreciation is generated, not rebuilt, and disposals are already reflected before anyone opens a report.
• Reporting on demand. Standard fixed asset reports cover book values, acquisitions, disposals, insurance and maintenance, ready for auditors and management.
• Less key-person risk. The process no longer depends on the one colleague who understands the workbook.

It is also worth planning the move properly. Migrating a register means cleaning up historical data, confirming each asset's book value and accumulated depreciation, and agreeing your fixed asset setup: classes, posting groups, depreciation books and methods. Getting that foundation right is what makes the automation trustworthy afterwards.

Set up fixed asset management in your Business Central system

If your fixed asset register still lives in a spreadsheet, or you are already on Business Central but not using the Fixed Assets module to its full potential, Creative Computing can help. As a Microsoft Dynamics 365 Business Central partner, our team can review your current register, migrate your assets cleanly, and configure depreciation, disposals, insurance and maintenance around the way your finance team works.

Talk to Creative Computing about setting up fixed asset management in your Business Central system, and go into your next year-end knowing every asset on the books is one you still own.