Syntha Lab RU

Sales reconciliation: till, ledger, acquiring and payout

Reconciles the net sales at the till (gross minus returns and discounts) with the amount in the ledger, and the expected non-cash receipt (non-cash sales minus the acquiring fee) with the real receipts on the account. It accounts for the settlement lag, shows the gaps, compares with the tolerance and counts the effective fee that explains the difference with the bank.

Data quality and data owners For whom: Retail financial control and accounting.

Calculate on your data →

At a glance

What question does it answer?
Whether the till, the ledger and acquiring money match.
What data is needed?
Gross sales, returns, discounts, cash.
How to read the result?
Two gaps separately: till with ledger and expectation with bank; the effective fee. Example on the default values: Net sales at the till: RUB 9.4 million; Gap between the till and the ledger: +RUB 50,000; Gap between the till and the ledger, %: +0.53%; Non-cash sales: RUB 7 million. The figures are illustrative: enter your own to see your result.

Why and how to reason

The till gives net sales of 9.40 m RUB, the ledger 9.35 m RUB: a gap of RUB 50,000. Of non-cash 7.00 m RUB at a 2% fee 6.860 m RUB was expected, the bank gave 6.80 m RUB: a difference of −RUB 60,000, the effective fee 2.86%.

When to use it

At month closing and when checking an acquiring contract.

How to read the result

Two gaps separately; compare the effective fee with the contractual one.

Common mistakes

Sales and receipts are compared without the settlement lag; manual reports instead of fiscal data.

What data is needed?

  • Gross sales, returns, discounts, cash.
  • The ledger, the fee and bank receipts.

Inputs

FieldUnitValue in the exampleMeaning
Gross sales at the till₽10,000,000The sum of sale receipts for the period by fiscal data. The example value is illustrative.
Returns by receipts₽600,000The sum of return receipts for the period. The example value is illustrative.
Discounts beyond receipts₽0Only if the till records prices before discounts: otherwise 0. Empty = 0. The example value is illustrative.
Of them cash₽2,400,000Net sales paid in cash. Empty = 0 (all non-cash). The example value is illustrative.
Sales in the ledger₽9,350,000Revenue for the same period in the accounting or management ledger. The example value is illustrative.
Acquiring fee%2The percent under the acquiring contract. Empty = 0. The example value is illustrative.
Bank receipts for the period (non-cash)₽6,800,000The sum credited by the acquirer to the account for the period. The example value is illustrative.
Of them for the previous period₽0Receipts that came in this period for the sales of the previous one. Empty = 0. The example value is illustrative.
Sales of the period end not yet credited₽0Non-cash sales of the period whose money will come in the next one. Empty = 0. The example value is illustrative.
Tolerance%0.5The allowed gap in percent of net sales: your rule. Empty = 0. The example value is illustrative.

How it is calculated

StepFormula
Net sales10 m ₽ − 600,000 ₽ − 0 ₽ = 9.4 m ₽
Gap against the ledger9.4 m ₽ − 9.35 m ₽ = 50,000 ₽
Expected receipt(9.4 m ₽ − 2.4 m ₽) × (1 − 2%) = 6.86 m ₽
Bank for the periodreceipts − for the previous period + not yet credited
Gap against the bankbank for the period − the expected receipt

Worked numbers

Default values from the app; in the interactive version you enter your own.

Net sales at the till
9.4 m ₽Gross − returns − discounts.
Gap between the till and the ledger
+50,000 ₽Net sales at the till − sales in the ledger.
Gap between the till and the ledger, %
+0.53 %
Non-cash sales
7 m ₽
Expected non-cash receipt
6.86 m ₽Non-cash sales × (1 − fee).
Bank receipt for the period
6.8 m ₽Bank − receipts for the previous period + not yet credited.
Gap against the bank
−60,000 ₽
Effective fee from the receipts
2.86 %1 − the receipt for the period ÷ non-cash sales: compare with the contractual one.
Reconciliation: till, ledger, expectation and bank, m RUB
Bar chart: Till, net 9.4, Ledger 9.35, Expected non-cash 6.86, Bank for the period 6.80246810Till, netTill, netAmount: 9.49.4LedgerLedgerAmount: 9.359.35Expected non-cashExpected non-cashAmount: 6.866.86Bank for the periodBank for the periodAmount: 6.86.8
Data as a table
MeasureAmount
Till, net9.4
Ledger9.35
Expected non-cash6.86
Bank for the period6.8

The reconciliation

MetricValue
Gross sales10 m ₽
Returns600,000 ₽
Discounts0 ₽
Net sales9.4 m ₽
Ledger9.35 m ₽
Cash2.4 m ₽
Non-cash7 m ₽
Expected receipt6.86 m ₽
Bank for the period6.8 m ₽

The till and the ledger differ by 50,000 ₽: reconcile return receipts, discounts and the date the sales are posted in the ledger.

The bank differs from the expected by 60,000 ₽: check the fee (effective 2.86% against the contractual 2%), holds, card refunds and the settlement lag.

The settlement lag is not entered: the money for the sales of the last days usually comes in the next period, without it the correction against the bank is not exact.

What to do with the result: look for the gap by dates: a table by days quickly shows which day the shift falls on; for platforms use the platform report reconciliation (the “Platform report reconciliation” calculation).

A typical mistake: comparing sales and receipts without the settlement lag. Take till data from fiscal documents and not from manual shift reports.

Nuances and limits

  • Comparing without the settlement lag.
  • Taking manual shift reports.
  • Not checking the fee.

Terms used

Calculate on your data →