Get Business Central fixed assets off the spreadsheet

What Business Central fixed assets covers

Every asset gets a fixed asset card. It holds the class, subclass, location, responsible employee and serial number. Behind the card sit one or more depreciation books. Each has its own method, start date and useful life. So one machine can carry a book value for accounts and another for tax.

You post acquisitions, depreciation, write-downs, appreciation and disposals through the fixed asset G/L journal. You can also post them directly from a purchase invoice. Each posting lands in the asset ledger. It also lands in the general ledger accounts named by the posting group. That keeps the balance sheet and the register in agreement.

When a company needs Business Central fixed assets work

The usual sign is a depreciation workbook that only one person understands. Month end waits on it. Someone types the journal by hand. Nobody is sure the register still matches the balance sheet. More assets, a new lender or an audit request brings the problem to light.

Companies that move from Dynamics GP, NAV or QuickBooks also need this work. Asset history rarely converts cleanly. Cost, accumulated depreciation and remaining life have to arrive together. Otherwise, the first depreciation run gives numbers that differ from the old system.

How we set up fixed assets in Business Central

We start with your capitalization policy and the classes you report on. Then we design posting groups. Each class then hits the right cost, depreciation and expense accounts. We create depreciation books for each reporting basis. Allocation keys split the expense across departments through dimensions where you need that.

First, we load existing assets into a sandbox with configuration packages and opening journals. Then we run depreciation there for a period you have already closed. We compare the result with your workbook line by line. Only when the two agree do we repeat the load in the live company.

What you have after Business Central fixed assets setup

You finish with a fixed asset register that ties to the general ledger. Your team gets a Calculate Depreciation routine to run in a few clicks. You also get saved journal templates for acquisitions and disposals. Purchase invoices can create the acquisition entry directly. So a new asset is capitalized the moment the vendor bill is posted.

Reporting comes with it. We set up the standard book value and projected value reports for your classes. Management may want asset totals beside the rest of the numbers. Then we add Power BI or financial report rows. A short written procedure covers the monthly run, disposals and transfers.

Mistakes that spoil a Business Central fixed assets setup

The most common fault is loading net book value as a single figure. Without separate cost and depreciation entries, the gain or loss on sale is wrong later. Another is forgetting the G/L integration options on the depreciation book. The asset ledger then updates while the general ledger stays untouched.

Depreciation dates cause trouble too. A starting date that does not match the old system shifts every later period. We also see companies create one posting group for everything. Then they struggle to report by class. These are easy to get right at setup. They are awkward to repair after several periods are posted.

Business Central fixed assets questions

Are fixed assets included in the Essentials license?

Yes. Fixed assets is part of the financial management area that comes with Essentials. Users who post asset journals need a full license. People who only look up asset cards can often use a Team Members license.

Can one asset carry both a book and a tax depreciation schedule?

Yes. You attach more than one depreciation book to the asset. Each has its own method and useful life. Usually one book links to the general ledger. The others are kept for tax or internal reporting and create no ledger entries.

Which depreciation methods does Business Central support?

Standard methods include straight-line, declining-balance and combinations of the two. User-defined tables cover schedules that follow a fixed pattern. A manual method covers land and other assets with no schedule.

How do we bring existing assets across from our old system?

We load each asset card. Then we post opening entries for acquisition cost and accumulated depreciation through a journal. After that, we run a trial depreciation in a sandbox. We compare it with your old figures. Only then do we post in the live company.

Can depreciation be split across departments?

Yes. Allocation keys on the posting group divide depreciation expense between accounts and dimension values. So a shared building or vehicle can charge several departments. Dimensions on the asset card also flow to every entry for that asset.

Related finance services

Fixed assets rarely stand alone. These pages cover the ledger that Business Central fixed assets post to. They also cover the budget they feed. Last, they cover the migration work that brings in asset history. Read them to plan your setup. Then send us your asset list, and we will say how to load it. For the product detail, see Fixed assets in Business Central on Microsoft Learn.