Skip to content
DetSol

Inventory & ledger practice

Why stock, sales and payroll belong on one ledger

· Updated · 6 min read · DetSol

Stock in one system, invoices in another, payroll in a spreadsheet and the bank in a browser tab. Each is fine. The problem is that answering “how did we do last month?” now requires a person to reconcile four things that were never designed to agree.

Reconciliation is a tax you pay monthly

A business running separate systems does not have four records of its finances. It has four partial records, each true about its own slice and silent about the rest, and a monthly ritual in which somebody makes them agree well enough to act on.

That ritual has a cost beyond the hours. It happens after the fact, so the figures inform next month rather than this one. It is done by one person, so the business's understanding of its own position lives in that person's head and in a spreadsheet only they can navigate. And because it is laborious, it gets done monthly at best — which means for most of any given month, nobody actually knows the net position.

What “one ledger” means concretely

Not “one big spreadsheet”, and not an accounting package bolted to the side. It means every event that moves money or value posts to the same record, at the moment it happens, as a consequence of the operational action rather than as a separate bookkeeping step.

  • Selling posts revenue and a receivable against that customer, and moves stock out.
  • Buying posts a payable against that supplier, and moves stock in when it is received.
  • Collecting a payment clears part of the receivable and increases the bank balance it was paid into.
  • Paying an operating expense reduces the bank balance and books the cost against a category.
  • Running payroll books the salary cost and the liability, and clears it when it is paid.

The point is not that any one of those is difficult. It is that when they all post to the same place, the net position is not a report someone compiles — it is a query. Nothing has to be reconciled because nothing was ever separate.

The test

Can you answer “what is my net position right now?” without opening a second system, and without asking anyone? If not, you are running multiple ledgers, whatever the software is called.

A second, harsher test: if two of your systems disagreed by a material amount today, how long would it take you to notice? In a reconciled-monthly setup the honest answer is up to a month, and the discovery happens during the reconciliation — which is to say, at the exact moment when the person doing it is most motivated to make the difference go away rather than to understand it.

The objection: “our accountant handles that”

They do, and that is not the same thing. An accountant reconciles what you give them, on the cadence you give it, for the purpose of producing statements and meeting obligations. That work is necessary and it is genuinely skilled. It is also retrospective by design.

Operational decisions do not run on that cadence. Whether to take a large order on credit from a customer, whether there is room to buy stock this week, whether a product line is actually profitable once its cost of goods is counted properly — those are decided in the moment, and in most businesses they are decided on a feeling. One ledger does not replace an accountant. It changes what the business knows in the twenty-nine days between conversations with them.

What it takes to get there

Mostly it takes refusing to add the fifth system. Every business accumulates tools honestly — each one solved a real problem on the day it was adopted — and the reconciliation burden is never visible at the moment of adoption, only in aggregate afterwards.

The practical question to ask of any new tool is not whether it does its job well. It is: what does this now need to be reconciled against, who does that, and how would we find out if it stopped being done? A tool that posts to the ledger you already have is worth more than a better tool that keeps its own.

This is the principle Stockroot is organised around: receipts, deliveries, payments, operating expenses and salary payments are each recorded once, and its stock levels, customer and supplier ledgers, dashboard and reports all read from those same records — which is why its figures agree with each other by construction rather than by effort.