How to reconcile cash, UPI, and card payments at day-end

Day-end reconciliation means comparing what the billing system recorded with what the counter actually collected, payment method by payment method. It answers one question: did the money received match the sales recorded? When they agree, the day is trustworthy. When they do not, the difference — short cash, excess cash, a missed UPI payment, an unposted refund — is the clue that points to what needs fixing.

The sales total is the value of what was sold. Collections are what was actually received. A ₹1,000 sale paid by UPI adds ₹1,000 to the UPI total, not to the cash drawer. A ₹500 sale paid partly in cash and partly by card adds to both totals. Until each method is separated, comparing the sales number with the drawer is comparing the wrong things.

The expected total for a shift starts from the opening float. Add cash sales, subtract cash refunds, and add or subtract recorded cash movements. The result is the amount that should be in the drawer. This is the number the counted cash is compared against — it is built from the system's own records, which is why complete and correctly coded transactions matter.

Cash reconciliation works forward: opening float recorded at shift start, plus cash sales, minus cash refunds, plus or minus cash movements (cash added to or removed from the drawer during the day). Count the physical drawer and compare. The difference is the cash variance for the shift — short if there is less than expected, excess if there is more.

UPI reconciliation compares the UPI payments recorded at the counter with the transaction list from the UPI provider or payment gateway. A payment can be recorded but fail to settle, or settle without being recorded if the QR was scanned directly. The cash UPI card reconciliation at day-end is the point where these two views are matched and any gap investigated.

Card payments follow the same logic: compare the card total recorded in the system with the terminal or acquirer settlement report. Timing differences matter — a card transaction approved today may settle in the batch tomorrow — so the comparison is against the terminal's transaction log, not just the settled amount.

Mixed payments split one sale across two or more methods, for example cash plus card, or UPI plus credit. The system must keep each part visible under its own method. If mixed payments are flattened into one category, both the cash and the card totals will be wrong by the same amount in opposite directions — easy to hide, hard to find later.

Credit sales and partially paid invoices are collections that have not happened yet. A ₹2,000 invoice with ₹500 paid and ₹1,500 outstanding should count ₹500 as collected, not ₹2,000. Keeping outstanding balances visible prevents the day's collections from being overstated and the next day's from being confused with new sales.

Refunds reduce collections and should reduce the relevant payment method. Cancelled invoices remove the sale from the day's totals. Reversals undo a previous recording. If these are not reflected consistently, the sales total can look correct while the money does not agree with any provider statement.

A short drawer means less cash than expected; an excess drawer means more. Both are recorded as the shift variance, and every unexplained variance should be recorded rather than treated as normal. A factual note — a specific refund, a counted denomination, a suspected counting error — turns the variance into a usable record instead of a mystery.

Reconcile at the level the close happens. A shift close compares that shift's expected cash with its counted cash. A whole-day close rolls up the shifts and the day's payment mix. If a problem appears only at the day level, look at which shift introduced it; if it appears inside a shift, look at that shift's transactions.

When the variance exceeds the configured approval threshold, the close needs a variance note and manager approval before it is final. Keeping approvals and notes on record means the day-end history shows not just the numbers but who recorded them and why the difference happened.

Nox-Billings records the pieces this routine needs: cashier shifts with opening and closing cash, expected cash built from opening cash, cash sales, cash refunds, and recorded cash movements, the calculated variance, variance notes, and approval when the configured threshold is exceeded. The day-end summary rolls up shift totals, payment mix, and variances, and reports are exportable. Nox-Billings records what the counter entered — the operator compares UPI and card totals with provider records, and settlement reconciliation stays with the provider statements.