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.
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
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Gross sales at the till | ₽ | 10,000,000 | The sum of sale receipts for the period by fiscal data. The example value is illustrative. |
| Returns by receipts | ₽ | 600,000 | The sum of return receipts for the period. The example value is illustrative. |
| Discounts beyond receipts | ₽ | 0 | Only if the till records prices before discounts: otherwise 0. Empty = 0. The example value is illustrative. |
| Of them cash | ₽ | 2,400,000 | Net sales paid in cash. Empty = 0 (all non-cash). The example value is illustrative. |
| Sales in the ledger | ₽ | 9,350,000 | Revenue for the same period in the accounting or management ledger. The example value is illustrative. |
| Acquiring fee | % | 2 | The percent under the acquiring contract. Empty = 0. The example value is illustrative. |
| Bank receipts for the period (non-cash) | ₽ | 6,800,000 | The sum credited by the acquirer to the account for the period. The example value is illustrative. |
| Of them for the previous period | ₽ | 0 | Receipts 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 | ₽ | 0 | Non-cash sales of the period whose money will come in the next one. Empty = 0. The example value is illustrative. |
| Tolerance | % | 0.5 | The allowed gap in percent of net sales: your rule. Empty = 0. The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| Net sales | 10 m ₽ − 600,000 ₽ − 0 ₽ = 9.4 m ₽ |
| Gap against the ledger | 9.4 m ₽ − 9.35 m ₽ = 50,000 ₽ |
| Expected receipt | (9.4 m ₽ − 2.4 m ₽) × (1 − 2%) = 6.86 m ₽ |
| Bank for the period | receipts − for the previous period + not yet credited |
| Gap against the bank | bank 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.
Data as a table
| Measure | Amount |
|---|---|
| Till, net | 9.4 |
| Ledger | 9.35 |
| Expected non-cash | 6.86 |
| Bank for the period | 6.8 |
The reconciliation
| Metric | Value |
|---|---|
| Gross sales | 10 m ₽ |
| Returns | 600,000 ₽ |
| Discounts | 0 ₽ |
| Net sales | 9.4 m ₽ |
| Ledger | 9.35 m ₽ |
| Cash | 2.4 m ₽ |
| Non-cash | 7 m ₽ |
| Expected receipt | 6.86 m ₽ |
| Bank for the period | 6.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.