Worked examples - cash on delivery and card payments
Real numbers for cash collected at the door (short payments, who carries the loss, short remittances, aging) and for card payments (overpayments held as credit, refunds, voids, fees, net to you and the card surcharge).
On this page
The numbers below were run through the same rules NemiRoute uses. Cash on delivery (COD) money is your customer's goods money, collected by your driver for them: it is never taxed and never your income. Your delivery charge is invoiced as usual. Background: Collect cash on delivery from drivers and How money moves.
The receiver pays less than the COD amount
A COD order is for $90.00. At the door the receiver pays $80.00, so the driver picks a reason for the difference (Short paid, Overpaid, Customer refused or Other).
| What happened | Open exception? | What the customer (shipper) is owed |
|---|---|---|
| The driver chose Customer refused (the receiver refused part of the goods) | No: the missing $10.00 is recorded as not owed | $80.00 |
| Any other reason (for example Short paid) | Yes: the row shows Receiver short $10.00 under Exceptions | decided below |
| You pick Short payment... then Write off $10.00 | Closed: you absorb the $10.00 and the driver is not charged | $90.00: the $80.00 collected plus $10.00 you credit |
| You pick Short payment... then Nothing more was owed | Closed | $80.00 |
An over-collection is never a debt: $95.00 collected on a $90.00 order is $5.00 over, and the customer is credited the $95.00.
The driver hands in less than they collected
A driver collected $80.00, $50.00 and $30.00 during the day (the $30.00 last) and hands in $145.00 of $160.00 when you click Receive cash. The $15.00 missing is charged to the newest collection first (the cash touched last is the likeliest to be missing): the $30.00 collection becomes a Short $15.00 exception. A bigger gap moves back: handing in $110.00 leaves $50.00 missing, so $30.00 on the last collection and $20.00 on the one before it. Handing in more than was collected only shows as an Over by variance.
Under Exceptions, open Resolve... and pick Write off $15.00 or, when Deduct shortfalls from driver pay is on, Deduct $15.00 from the driver's pay. The deduction is a line COD shortfall SHP-2043 of -$15.00 in their open pay period, once per collection. A driver's shortfall is the courier's loss, not the customer's: the customer is still credited everything the receivers paid. See Worked examples: driver pay.
Aging with a reminder window
Cash still in a driver's hands is coloured by age against Remind after (days) in COD settings (2 days until you change it). With a 3-day window:
| Days in hand | Shows as |
|---|---|
| 0 to 2 | normal |
| 3 to 5 | amber |
| 6 or more (twice the window) | red |
A card payment bigger than the invoice
A customer pays $113.00 by card on a $100.00 invoice. The invoice is paid and the extra $13.00 is held as customer credit.
| Event | Invoice | Customer credit |
|---|---|---|
| Card payment of $113.00 | paid, $100.00 | $13.00 |
| You refund $20.00 | reopened for $7.00 | $0.00: the credit goes back first, then the invoice |
| You void the invoice instead and choose Keep $113.00 as customer credit for their next invoices | voided | the whole $113.00 becomes credit (the other choice refunds the card) |
Card payments are undone only by a Refund (the money goes back to the card). A payment under dispute cannot be refunded or voided; once a dispute is lost, the amount is taken back the same way, credit first.
What a card payment nets
With the platform's standard fees (your plan can differ: Payments settings shows the fees that apply to you under What you pay per payment), a customer pays a $113.00 invoice in Canadian dollars by card:
| Line | Calculation | Amount |
|---|---|---|
| Charged to card | $113.00 | |
| Platform fee | 1 % of $113.00 | $1.13 |
| Card processing fee | 2.9 % + $0.30 = $3.277 + $0.30 | $3.58 |
| Fees kept | $4.71 | |
| Net to you | $108.29 |
The invoice is paid for the full $113.00. A bank debit (pre-authorized debit) of $1,000.00 costs a platform fee of $10.00 (1 %, at most $25.00) and a processing fee of $5.00 (1 % + $0.30, at most $5.00): $15.00 in all. Fees can never be more than the payment itself.
With Add a card surcharge on at 2 %, the same card payment adds a Card surcharge of $2.26, so the customer pays $115.26. At 3 % the surcharge is held to the 2.4 % ceiling for CAD: $2.71. It is also never more than your card processing cost, never added for customers billed in Québec, and never added on bank debit or auto-pay. The setting is only offered for CAD and USD, with a ceiling of 2.4 % for CAD and 3 % for USD. If you refund part of a payment, the fees come back in proportion.
Fees over several invoices
One card charge can pay several invoices. The card fee on the charge is split between them in proportion to what each took, so the parts add up to the real fee to the cent: a $3.35 fee on invoices of $200.00, $100.00 and $50.00 is $1.91 + $0.96 + $0.48. A $1.00 fee over parts of $33.33, $33.33 and $33.34 is $0.33 + $0.33 + $0.34: the odd cent goes to the largest remainder.
Related articles
- How-toCard payments and StripeConnect your company's Stripe account so customers can pay invoices by card, follow the setup states, and see each card payment, its fees and refunds.
- Page guideCard paymentsWhat customers paid by card or bank debit online, the fees taken, refunds and disputes, and what reaches your Stripe balance, with the per-payment ledger and refunds.
- How-toCollect cash on delivery from driversSee which driver holds how much COD cash, receive it when they hand it in, and sort out shortfalls and disputes.
- Page guideCOD cashCash on delivery from collection to hand-in: the totals, the Cash in hand, Collections, Exceptions and Remittances tabs, receiving cash, disputes, shortfalls, short payments and COD settings.
- How-toRecord and reverse paymentsRecord cheques, bank transfers and cash on one or several invoices, send receipts, undo a payment recorded by mistake and find any payment.
- ConceptHow money moves in NemiRouteThe path of every dollar: an order's price and tax, the invoice, card, bank debit, manual and cash-on-delivery payments, credit, credit notes and refunds, statements and aging, and driver and staff pay from completed work.
- ConceptWorked examples - driver payReal numbers for pay plans: per delivery, per km, rush and wait time, percent of order, hourly with Ontario and British Columbia overtime, guarantees and floors, own-vehicle allowance, route pay, COD shortfall deductions and a contractor's statement with GST/HST.
Still stuck?
Tell us what you were trying to do. A person reads every message.