Study guide

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

Red Seal Parts Technician Interprovincial Exam

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: Occupational Health, Safety & Emergency Procedures

1.1 Workplace Health & Safety Regulations, Hazard Assessment, and Emergency Protocols 1.2 WHMIS 2015 / GHS, Safety Data Sheets (SDS), and Hazardous Product Handling 1.3 Ergonomics, Safe Lifting Techniques, Repetitive Strain Prevention, and PPE

2 Chapter 2: Tools, Equipment & Trade Organization

2.1 Hand, Measuring & Precision Inspection Tools 2.2 Material Handling Equipment Operation, Inspection & Maintenance 2.3 Workflow Organization, Dealer Management Systems (DMS) & Professional Communication 2.4 Power Tools, Bench Test Equipment & Business Machines 2.5 Mentoring Apprentices, Workplace Learning & a Harassment-Free Workplace

3 Chapter 3: Retail Customer Service & Merchandising

3.1 Counter Sales Techniques, Active Listening & Needs Assessment 3.2 Retail Merchandising, Showroom Displays & Point-of-Sale (POS) Optimization 3.3 Retail Transaction Processing, Cash Controls & Over-the-Counter Policies

4 Chapter 4: Wholesale, Commercial & Internal Customer Relations

4.1 Wholesale Accounts, B2B Relationship Management & Fleet Support 4.2 Internal Service Support: Partnering with Shop Technicians & Service Advisors 4.3 Collision Repair Support, Hot-Shot Deliveries & Urgent Bay Dispatch 4.4 Wholesale Technical Support, Training Events & Product Clinics

5 Chapter 5: Customer Support, Warranties & Returns Management

5.1 Resolving Customer Complaints, De-Escalation & Service Recovery 5.2 Warranty Administration, Defect Inspection & Claim Verification 5.3 Customer Returns, Restocking Policies & Core Return Criteria 5.4 No-Fee Value-Added Services, Obsolete-Part Sourcing & After-Sales Follow-Up 5.5 Product Improvement Programs (PIP), Parts Recalls & Technical Service Bulletins

6 Chapter 6: Parts Identification & Specification

6.1 Vehicle & Equipment Identification: VIN, PIN & Serial Number Decoding 6.2 Part Numbering Schemes, Casting Marks, Engineering Codes & Supersessions 6.3 Fasteners, Thread Systems (UNC/UNF/Metric/NPT), and Pitch Measurement 6.4 Identification of Bearings, Seals, Gaskets, Belts & Hydraulic Hoses 6.5 Identifying Parts Function by Motive and Operating System 6.6 Filtration, Fluids & Lubricants: Reading Specifications and Matching Applications

7 Chapter 7: Catalogues, Procurement & Sourcing Strategies

7.1 Electronic Parts Catalogues (EPC), Exploded Diagrams & Interchange Systems 7.2 OEM vs Aftermarket, Rebuilt, Remanufactured & Performance Parts 7.3 Inventory Searching, Multi-Branch Networks & Emergency Sourcing (VOR Orders) 7.4 Purchasing Procedures, Special Orders & Supplier Selection

8 Chapter 8: Material Handling, Storage & Dangerous Goods

8.1 Warehouse Layout, Golden Zone Slotting & Racking Safety 8.2 Transportation of Dangerous Goods (TDG), Placarding & Hazmat Storage 8.3 Preservation, ESD Protection & Storage of Sensitive Components

9 Chapter 9: Inventory Control Models & Stock Optimization

9.1 Min/Max Systems, Reorder Point (ROP) Formulas & Safety Stock 9.2 ABC Inventory Classification & Velocity Management 9.3 Cycle Counting, Physical Inventory Audits & Discrepancy Reconciliation 9.4 Inventory Turnover (Turns), Dead Stock Disposal & Shrinkage Prevention

10 Chapter 10: Shipping, Receiving & Staging Operations

10.1 Receiving Inspections, Bills of Lading & Damaged Freight Procedures 10.2 Stock Put-Away, Bin Location Architecture & Overstock Management 10.3 Order Picking, Staging, Packaging & Outbound Carrier Manifesting 10.4 ETA Verification, Order Tracking & Expediting Inbound Freight

11 Chapter 11: Promotional Sales & Pricing Formulas

11.1 Suggestive Selling, Upselling & Related Item Kit Building 11.2 Pricing Formulas: Markup vs. Gross Margin Calculations & Conversions 11.3 Matrix Pricing, Tiered Discounts & Core Pricing Dynamics 11.4 Digital Marketing: Platforms, Target Markets & Compliant Promotion

12 Chapter 12: Financial Controls, Documentation & Trade Accounting

12.1 Invoicing, Customer Credit Terms & Payment Processing 12.2 Three-Way Match: Purchase Orders, Packing Slips & Vendor Invoices 12.3 Credit Memos, Core Adjustments & Canadian Sales Taxes (GST/HST/PST) 12.4 Day-End Reports, Payment Method Reconciliation & Cash Over/Short 12.5 Customer Records, Payment Data & Privacy Compliance (FOIP, CASL, DNCL)

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

Key Takeaways Explain This Topic AI

Sub-task E-16.04 has two performance criteria: balance invoices, cash, debit, credit card and e-transfer receipts, and reconcile daily transactions according to company policies and procedures.

The RSOS lists methods of payment as cash, credit card, cheques, debit card, e-transfer, in-house charge, COD, FOB, gift cards, prepaid credit, digital wallet services, and vouchers — each settles through a different channel and must balance separately.

Cash is reconciled net of the opening float: physical cash counted minus the float equals net receipts, which is then compared to the system’s recorded cash sales.

A variance is posted to the Cash Over/Short general ledger account and documented — never absorbed personally by a technician or made good from the next day’s float.

The RSOS names ROA (received on account), terms of payment, central billing and GAAP as the financial practices underpinning day-end reporting.

Last updated: September 2026

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.

  • Tender Balanced against Common variance cause
  • Cash Physical count, net of the opening float Incorrect change given; a sale rung to the wrong tender
  • Debit Terminal batch settlement total A transaction voided at the terminal but not in the DMS
  • Credit card Terminal batch settlement total, by card type A manual imprint or phone authorization not entered
  • E-transfer Bank notification confirmations Transfer received but the invoice never marked paid
  • Cheques Physical cheques on hand, listed individually A cheque covering multiple invoices split incorrectly

In-house charge Accounts receivable posting to the customer account A charge sale posted to the wrong account number

Gift cards / vouchers / prepaid credit Liability account movement A voucher redeemed but not deducted from the liability

COD Driver remittance against the delivery manifest Driver returned the part but the COD invoice stayed open

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: Net Cash Receipts = Total Physical Cash Counted − Opening Float \text{Net Cash Receipts} = \text{Total Physical Cash Counted} - \text{Opening Float} Net Cash Receipts = Total Physical Cash Counted − Opening Float Variance = Net Cash Receipts − System Recorded Cash Sales \text{Variance} = \text{Net Cash Receipts} - \text{System Recorded Cash Sales} Variance = Net Cash Receipts − 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 1{,}620.00 - \text{\textdollar}250.00 = \text{\textdollar}1{,}370.00 1 , 620.00 − $ 250.00 = $ 1 , 370.00

Variance: 1,370.00 − $ 1,390.00 = − $ 20.00 1{,}370.00 - \text{\textdollar}1{,}390.00 = -\text{\textdollar}20.00 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:

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.

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:

  • Report What it proves
  • Daily sales journal Every invoice raised, by tender and by sales category
  • Cash / tender balancing sheet Each tender balanced individually; variance posted to Cash Over/Short
  • Terminal batch settlement Card totals agree with the processor before the batch closes
  • Accounts receivable posting Charge sales added and ROA payments applied to the correct accounts

Open invoice / suspended ticket report Nothing left un-invoiced overnight — the classic source of "missing" stock

Inventory movement / cost of sales Units sold relieved from inventory at cost, so on-hand quantities are current

Gross profit summary Margin achieved by category, exposing unauthorized discounting

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:

Card terminal batches settled and confirmed before the terminal is secured.

Deposit prepared, recorded, and moved to the safe or drop under the department's dual-control policy.

Float counted back to its standard amount and secured separately from the deposit.

All point-of-sale sessions logged out so no transaction can be posted under an absent operator.

Reports printed or archived to the retention period the business is required to keep for tax and audit purposes.

Loading diagram... Parts Department Day-End Balancing and Reconciliation