You bought equipment, a car, or furniture for your business — and you treat it as a one-time expense that’s already behind you. Then you calculate profit as if that purchase no longer affects your money. This is one of the most expensive mistakes small businesses make. Let’s break down what fixed asset accounting is, why without it your profit is an illusion, and how to stop calculating depreciation by hand in Excel.

What is fixed asset accounting in plain words?

Fixed assets are everything a business buys not to resell, but to use for a long time: equipment, vehicles, furniture, computers, tools, premises. Unlike goods you buy and sell within a week, a fixed asset works for years and wears out gradually.

Fixed asset accounting is a system that answers four questions:

• What you own (a full list of assets with values and responsible people);
• What it’s worth now after wear and tear;
• How fast it wears out and when it will need replacing;
• What it actually costs your business every month.

The last point is the most important. And it’s the one most often ignored.

The hidden trap: why your profit is smaller than it looks

Imagine an entrepreneur who bought a car for $12,000 to deliver orders. The car will serve about 5 years, then needs replacing. That means it «wears out» by roughly $200 a month ($12,000 ÷ 60 months).

Now suppose the business brings in «$1,000 a month». The owner is happy: a thousand dollars of profit. But that’s not true. $200 of that thousand isn’t profit — it’s the car wearing out. The real result is closer to $800.

And that’s not the whole problem. If the owner spends the full «thousand» every month, then five years later something unpleasant happens: the car dies and there’s no money for a new one. Where did it go? It was never there — the owner was quietly eating their own capital, taking $200 of someone else’s money for their own profit every month.

This is what depreciation does: it spreads the asset’s cost across its entire service life, so that every month you see the real cost of working with that equipment. Without it:

• you overestimate profitability and your business margin;
• you make decisions (raise salaries, lower prices, take a loan) based on inflated numbers;
• you don’t set aside money to replace assets — and one day you’re left with no money and no equipment.

Fixed asset accounting isn’t bureaucracy for the accountant. It’s a tool that shows where your real money is. (We touched on this logic in «Profit or Illusion?» — fixed assets are the same effect, just stretched over years.)

Why doesn’t Excel work for fixed asset accounting?

While you have two or three assets, a spreadsheet still holds up. But at a dozen objects the problems begin:

• Manual depreciation calculation. Every month you have to remember to calculate wear for each object, by the right method, for the right period. One formula error and all the following numbers are wrong.
• Easy to forget. Excel won’t remind you it’s time to record depreciation. Miss a month and the books drift.
• No link to accounting. You calculated wear in a table — but the journal entries have to be made separately, by hand, all over again. Double work and a double chance of mistakes.
• Two bases diverge. Accounting depreciation and tax depreciation are calculated by different rules. In Excel that means two parallel tables that are almost impossible to keep in sync.
• Problems during audits and inspections. When the tax office or an investor asks for an asset card with full history, you won’t assemble it quickly from a spreadsheet.

Excel doesn’t know what a «fixed asset» is. To it, these are just numbers in cells. An accounting system knows.

What does a fixed asset card look like in the system?

In ERPJS each asset is a separate card holding everything about the object:

• Inventory number — unique, so no object gets lost or duplicated;
• Name and description — what the object is;
• Initial cost and purchase date;
• Commissioning date — depreciation counts from here;
• Category and type — for grouping and the correct accounting accounts;
• Department and responsible person — who’s accountable and where the asset is;
• Supplier and warranty — where to turn if something breaks.

This isn’t just a reference list. Each card is linked to the books, to depreciation, and to reports — all in one place.

How does automatic depreciation work?

Instead of manual formulas, the system calculates wear itself. You choose a depreciation method for each asset category, and from there the system computes the amount and immediately creates the accounting entries (charges wear to expenses and accumulates it), updates the residual value, and logs the operation in the journal.

ERPJS supports three methods:

1. Straight-line — the asset wears evenly, the same amount each period. The most common and simplest.
2. Declining balance (accelerated) — more wear at the start of service, less later. Suited to equipment that becomes obsolete quickly.
3. 100% at once — the entire cost is written off in one go. Convenient for inexpensive objects.

The accrual period is flexible — month, quarter, or year, whatever suits you. Instead of manual formulas in Excel, the system calculates wear itself and maintains it for each object without you doing the math.

Why two parallel models — accounting and tax?

Here’s a function most simple solutions don’t have. The real wear of equipment and tax depreciation are different things. Tax rules often dictate their own terms and rates that don’t match how the asset actually wears out.

ERPJS lets you run two parallel accounting models at the same time: one shows the real economic picture (for management decisions), the other the tax view (for reporting). The same asset, two perspectives, no duplication across tables.

For the business this means you see both true profitability and a correct tax base — without two separate Excel files that forever diverge.

How to record commissioning and disposal?

Commissioning is a separate action: you fix the date the asset starts working, and the system automatically makes the right entries (moving the value from capital investments to fixed assets).

Disposal — when an asset is sold, written off, or liquidated — is handled by a document. The system writes off the accumulated wear and residual value itself, and in case of a sale records the revenue. All with correct entries, no manual posting.

Every such operation goes into the journal — you always have a full history for each object: when it was bought, commissioned, how much was depreciated, and when and how it was disposed of.

Conclusion

Fixed assets are where small businesses most often fool themselves: counting as profit the money that is actually equipment wearing out. Fixed asset accounting restores an honest picture: how much you really earn, what working with your assets costs, and when to set money aside for replacement.

ERPJS automates the whole routine — from the asset card and depreciation calculation by three methods to accounting entries and two parallel accounting models. Instead of manual spreadsheets you get a system that counts real money.

Want to see how this works on your assets? Request a demo — we’ll show you.

Frequently Asked Questions

What are fixed assets in plain words?

They’re everything a business buys for the long term, not for resale: equipment, vehicles, furniture, computers, tools. They work for years and wear out gradually, so their cost isn’t written off at once but spread across the whole service life through depreciation.

Why does depreciation affect profit if the money is already spent?

Because the asset wears out and will eventually need replacing. If you ignore monthly wear, you overestimate profit and eat your capital without noticing. Depreciation shows the true cost of working with an asset and the real profitability of the business.

Which depreciation methods does ERPJS support?

Three: straight-line (even wear), declining balance (accelerated, more at the start), and 100% at once (for inexpensive objects). The method is chosen per asset category, the period — month, quarter, or year.

Can accounting and tax depreciation be kept separately?

Yes. ERPJS runs two parallel accounting models at the same time for one asset — management (real economics) and tax (by tax rules). No need for two separate tables that drift apart.

Does the system calculate depreciation automatically?

Yes. You choose a method for each asset category, and the system calculates the wear amount, creates the accounting entries, and updates the residual value itself — without manual formulas in Excel.

Is ERPJS suitable for small business?

Yes. Fixed asset accounting in ERPJS is designed for small and medium business with a standard depreciation scheme. For large companies with complex analytics, some functions are tailored to the specific case.