Quote-Hour Checkup / Resources / Quoting and reconciliation

Excel ledger vs automated reports: why you should not maintain the same data twice

Published 2026-09-28 · Keywords: Excel ledger, automated reports, quote reconciliation, double data entry, distributor reconciliation · All money and hour figures are estimates

Lots of companies say "we have gone digital" when what they mean is "we keep a tidy Excel ledger". A ledger is not fake digitisation — it is second-hand accounting. This piece sets out where the two sets of books diverge, when Excel is still the right answer, and when you should let the data record itself.

Every money and hour figure below is an estimate, and every one can be recomputed with a local command (kept in-house; ask us and we will send the run record).

1. What a ledger really is: hand-copied, second-hand data

Enquiries, quotes, orders and reconciliations start life inside the process (chat, email, ERP, paper). Someone then copies them into Excel at a fixed point in time. Three things sit in between:

1. Delay — it happens today, it gets logged tomorrow or at the weekend;
2. Definition — whoever copies decides what counts ("does this one count as an enquiry?");
3. Loss — the person copying only copies the columns they happen to use.

A ledger's greatest value is that it summarises for a human; its greatest cost is that every single record passes through a pair of hands.

So we never ask "do you have a ledger?". We ask one thing: how many times do you enter the same record?

2. Put a number on the logging itself

Take the most common flow: enquiry to quote (building the quote document). Use one reproducible set of inputs: 4 people involved, 25 runs a week, 12 minutes per run.

• Today: 20 hours/week to 1,040 hours/year;
• How much of that is "logging and checking" is judged step by step, on site — we will not guess on a client's behalf (which is exactly why the engagement starts with a 30-minute interview).

Three scenarios (estimates):

The base case, monthly: 52 hours/month about CNY 2,392/month.

Note the basis of that table: it is measured in process time, not headcount. The extra time a ledger takes is already buried inside the same flow.

3. What the cost difference between the two sets of books looks like

Same inputs (single flow, public-cloud deployment, no system-integration surcharge):

• Suggested project fee: CNY 18,000 (the company floor);
• Operations subscription: CNY 2,000 – 2,160/month;
• First-year cash outlay (estimate): CNY 42,000 – 43,920;
• Diagnostic fee: CNY 3,000 (single flow; credited 100% against a delivery project signed within 60 days).

Against the books of one front-line quote clerk (estimate): monthly salary CNY 6,000, fully loaded monthly cost CNY 7,800, annual cost of the role CNY 93,600.

Put simply: handing one flow to a system costs about CNY 44,000 in the first year, close to half of one front-line role's annual cost (CNY 93,600). That gap of CNY 49,600 is a sanity anchor, not the basis of our pricing.

4. When to keep using Excel

Excel is not the enemy. In these cases a spreadsheet remains the right call:

The one-line test: is this sheet the only carrier of process data? If yes, the process itself is worth turning into the record. If it is only a summary for humans to read, keep it.

5. What actually needs to die is the second entry

Many projects go wrong at the first step: buy a system, then make the business adapt to it.

We work the other way round: find the point where the same record is entered a second time, and remove it. Three tests, no more:

1. Did this data already exist inside the process? (If yes, it should not be entered again.)
2. Who is the second entry for? (If it is only a summary, it can be generated.)
3. When the second, manual entry is wrong, who pays? (Reconciliation differences, mis-quoted orders — that is the cost.)

You do not need to "go digital". You need to delete one entry.

6. Three steps to judge it yourself

1. Pick your highest-frequency flow (the one with a ledger is the best candidate);
2. Count four figures: people involved, times per week, minutes per run, monthly cost of the role (or the hourly cost directly);
3. Run the same calculation we did.

The command behind every money and hour figure in this piece runs locally, with no network and no data leaving your machine; ask us and we will send the run record for that set of inputs. The hourly cost used here is CNY 46 = monthly salary CNY 8,000 / 21.75 days / 8 hours. Swap in your own four numbers and you have your own version.

Next step (free): if you are not sure how much of that flow a system can genuinely absorb, we do a 30-minute interview and judge it step by step — the verdict is yours to keep, and whether you work with us is your call.

Not sized your own process yet? Run the free 30-second Quote-Hour Checkup.

Figures in this article are estimates and follow the same definition we quote under; contribution rates and salaries vary by country and sector, and the actual saving is subject to the on-site walkthrough and the Baseline Confirmation both sides sign. References and credentials available in person.