12.4 Day-End Reports, Payment Method Reconciliation & Cash Over/Short

12.4 Day-End Reports, Payment Method Reconciliation & Cash Over/Short

Task 16 of the Red Seal Occupational Standard, Processes financial transactions, carries 7 of the 120 exam questions, and its final sub-task, E-16.04 Processes day-end reports, is where every transaction of the day is proven. The two performance criteria are short and unambiguous:

• E-16.04.01P — invoices, cash, debit, credit card and e-transfer receipts are balanced according to company policies and procedures.
• E-16.04.02P — daily transactions are reconciled according to company policies and procedures.

Balancing and reconciling are not the same activity. Balancing asks whether each tender total matches what the system says it should be. Reconciling asks whether the day's total activity ties out across sales, payments, and the accounts they landed in.

---

Every Tender Balances Separately

The RSOS range of variables lists the methods of payment a parts counter accepts: cash, credit card, cheques, debit card, e-transfer, in-house charge, COD, FOB, gift cards, prepaid credit, digital wallet service, and vouchers. They do not settle through the same channel, so they cannot be balanced as one number.

Red Seal Exam Focus: A single day can balance in total while three tenders are individually wrong — a cash sale mistakenly rung as debit makes cash short and debit over by the same amount. Balancing tender by tender is what surfaces that, and it is why the standard names the tenders separately in the performance criterion.

---

Reconciling Cash: Net of the Float

The opening float (also called the till float or change fund) is the department's own money, placed in the drawer so change can be given. It is not revenue and it is never part of the day's receipts.

The calculation is therefore always in this order:

$\text{Net Cash Receipts} = \text{Total Physical Cash Counted} - \text{Opening Float}$

$\text{Variance} = \text{Net Cash Receipts} - \text{System Recorded Cash Sales}$

A positive variance is over; a negative variance is short.

Worked example. The opening float is $250.00. The physical count at close is $1,620.00. The system's day-end report shows recorded cash sales of $1,390.00.

• Net cash receipts: $1{,}620.00 - $250.00 = $1{,}370.00$
• Variance: $1{,}370.00 - $1{,}390.00 = -$20.00$

The drawer is $20.00 short, and the float of $250.00 is returned to the drawer for the next day rather than being deposited.

Red Seal Exam Trap: Failing to deduct the float before comparing to recorded sales makes the drawer appear to be over by the full float amount. In the example above, that error produces an apparent $230.00 surplus and would send the department looking for a phantom overage.

---

Posting Cash Over/Short

A variance is not made to disappear. It is posted to a dedicated general ledger account — Cash Over/Short — and documented on the balancing sheet with the date, the operator, the amount, and any known explanation.

Two behaviours are always wrong, and both appear as distractors on the exam:

1. A technician personally making up a shortage out of pocket. This conceals a process failure, removes the department's ability to find the cause, and in most jurisdictions employers cannot require it.
2. Carrying an overage forward in the drawer to offset a future shortage. This inflates the next day's float, corrupts both days' reconciliations, and creates unrecorded cash.

The value of a Cash Over/Short account is diagnostic. Small random variances in both directions are normal handling noise. A consistent shortage on one operator's shift, or a pattern of round-number variances, is a signal that warrants investigation.

---

Charge Sales, ROA and Central Billing

The RSOS lists the financial practices behind day-end reporting: ROA (received on account), terms of payment, central billing, and GAAP (generally accepted accounting principles).

Three distinctions matter at close of day:

• A charge sale is revenue but not cash. An in-house charge sale increases sales and increases accounts receivable. It must never appear in the cash tender total.
• A payment received on account (ROA) is cash but not revenue. When a wholesale customer walks in and pays down an outstanding statement balance, cash increases and accounts receivable decreases. The revenue was already recognized when the original invoice was raised, so counting an ROA as a sale double-counts it.
• Central billing routes invoices for certain national or fleet accounts to a central payer rather than the local customer, so those invoices leave the local receivable ledger and must be excluded from local collection follow-up.

Under GAAP accrual accounting, revenue is recognized when the sale occurs and the part is delivered, not when the money arrives. That principle is exactly why charge sales and ROA sit on opposite sides of the day-end report.

---

The Day-End Report Set

A typical parts department close produces several reports, and knowing what each proves is the tested knowledge:

That sixth row is the link back to inventory control. Every invoice finalized at day end relieves stock from the DMS. A suspended or un-invoiced ticket leaves the part physically gone but still showing on hand, which surfaces weeks later as an unexplained cycle-count variance. Closing the day cleanly is therefore an inventory-accuracy control as much as a financial one.

---

Securing the Close

The day-end routine finishes with the physical and system controls covered in Section 2.4:

1. Card terminal batches settled and confirmed before the terminal is secured.
2. Deposit prepared, recorded, and moved to the safe or drop under the department's dual-control policy.
3. Float counted back to its standard amount and secured separately from the deposit.
4. All point-of-sale sessions logged out so no transaction can be posted under an absent operator.
5. Reports printed or archived to the retention period the business is required to keep for tax and audit purposes.