Glossary - Planning and finance

Ledger reconciliation

Ledger reconciliation is the process of checking a reported figure - revenue, fees, margin - against an independent record such as the payment processor payout or the accounting ledger, then tracing any variance until it is explained to zero. An ecommerce operator uses it to prove the dashboard is real before making decisions on it.

Reconciliation variance = reported figure − ledger anchor (reconciled when the variance is explained to zero)

Variable	What it covers
Reported figure	The number your analytics or store dashboard claims - net revenue, fees, refunds, margin.
Ledger anchor	The independent record: payment processor payouts, the bank statement, the accounting ledger. It must not be produced by the system being checked.

Worked example

Analytics net revenue (quarter)A$412,300

Ledger net revenue (processor payouts + accounting)A$408,750

= Variance to explain (0.9% of revenue)A$3,550

Traced: refunds posted to the wrong period−A$2,100

Traced: duplicate test orders never voided−A$980

Traced: uncaptured authorisation counted as paid−A$470

= Variance explained, figure reconciledA$3,550 → A$0

Example numbers. The three traced lines sum exactly to the variance - that, not "close enough", is the finish line.

What is a good reconciliation variance?

Zero - this is one metric where the honest benchmark exists, because a variance is not "small enough", it is either explained or it is not. A 1% gap can hide two large offsetting errors. What does vary by store is where variances come from: refund timing, gift cards, multi-currency conversion, how the processor nets its fees, subscription proration. The harder your mix, the more anchors you need. The Math shows what finished looks like: a $5.76M store with 40,099 orders reconciled to the dollar, with provenance on every figure.

Ledger reconciliation vs related metrics

Metric	What it measures	How it differs from reconciliation
P&L statement	Revenue down to profit for a period.	The report being checked - reconciliation is the audit that makes the P&L worth reading.
Attribution model	Which channel gets credit for a sale.	Modelled credit vs measured money. Attribution can never be reconciled to a ledger; revenue, fees and refunds can.
Net margin	Profit after all costs, as a share of revenue.	The line that inherits every unreconciled error above it - reconciliation is what keeps it honest.
Contribution margin	Revenue minus variable costs.	The figure most worth anchoring: a CM built on unreconciled revenue or missing fees misprices every scale decision.

Common mistakes

Reconciling once, then trusting forever. Drift returns with every new SKU, market, app and fee change - tie-out is a cadence, not a project.
Treating a small variance as noise. A 1% gap is often two big errors cancelling. Explain it or it will move.
Reconciling revenue only. Fees, shipping charges and refunds each need their own anchor - the margin is wrong even when the top line matches.
Using the dashboard as its own anchor. Checking a system against a report it generated proves nothing. The anchor must be independent: processor, bank, ledger.
Coalescing missing costs to zero to force the tie-out. A gap shown as a gap is honest; a gap filled with a zero flatters the margin and poisons every figure downstream.

Ledger reconciliation FAQ

Payment processor payouts and the accounting ledger - records the store platform does not produce. The bank statement is the final backstop, because money that never arrived is not revenue.

Every reporting cycle - monthly at minimum, and before any decision that leans on the numbers. Reconciling continuously keeps each variance small and traceable instead of a year-end archaeology dig.

Payout lag, processor fees netted out before the deposit, refunds and chargebacks, and currency conversion all sit between an order and the bank line. Reconciliation names each of those pieces explicitly.

P&L statement Net margin Contribution margin Attribution model All 14 free tools →

Every figure in Blufire reconciles to an independent anchor before it ships - the tie-out story on The Math shows a $5.76M store, 19,217 customers and 40,099 orders reconciled to the dollar.

Updated July 2026