Skip to content
Enjoy complimentary data migration when switching from your existing bookkeeper or CPA to Institution.

Bookkeeping & finance

Cash on delivery: reconcile carrier collections to the orders they settle

Track delivered orders, customer collections, carrier deductions and remittances so cash on delivery balances do not disappear inside shipping costs.

By Institution3 minute readPublished View sources
In this guide

Identify who collected the customer money

For each cash-on-delivery order, record the expected amount, carrier collection reference and delivery outcome. Confirm which company owes the merchant a remittance after collection and under what settlement terms. A delivered status does not necessarily show the amount collected. A failed delivery may leave stock traveling back while no customer payment was ever received.

Shopify lists cash on delivery among manual payment methods and explains that manually paid orders require a payment-status update after payment is received. Apply that distinction to the business's actual carrier arrangement. Agree which evidence permits staff to mark an order paid and how the books track collected money that the carrier has not yet transferred.

References: Shopify: Manual payment methods

Rebuild the remittance from its order detail

Obtain a carrier statement that identifies collections by order or tracking number, with adjustments and deductions shown separately. Match those identifiers to the order register. Where the carrier uses a different reference, retain a stable mapping instead of matching solely on amount. Equal order values are common and can conceal a misapplied receipt.

Assume a hypothetical remittance covers customer collections of $4,500, collection charges of $90 and separately identified freight of $210. The bank receipt is $4,200. The $300 difference needs the two documented deductions; it should not reduce every customer's payment allocation. Confirm whether the carrier's invoice and statement represent the same charges before entering both as expenses.

Separate corrections relating to earlier remittances. A current statement may reverse a previous collection or adjust a freight charge. Link it to the original order or invoice so the current delivery cohort does not absorb an unexplained amount.

Investigate delivery and collection mismatches

Review delivered orders with no collection record, collections with no matched order and orders marked paid without carrier support. Ask the operations team to confirm the delivery evidence and any customer exception. A driver may report a refusal, a partial collection or a change of delivery arrangement. Each case needs a documented resolution under the merchant's agreement.

For refused deliveries, connect the return shipment to the original inventory issue. Keep the product unavailable until its location and condition support release. Review return freight separately from the original collection fee. If the carrier collected money and later refunded the customer, obtain both events and determine who funded the refund before changing the merchant's receivable.

Age the amount due from the carrier

Build an opening-to-closing schedule of supported carrier collections, remittances and approved deductions. Age unpaid collections from the date defined by the settlement agreement. The total should reconcile to the relevant clearing or receivable balance under the accountant's policy, with timing items distinct from disputed charges or missing collections.

Use an exception owner who can obtain carrier statements and pursue claims. Give finance a forecast based on the carrier's actual payment schedule, then compare expected receipts with bank activity. At contract review, bring evidence of late remittances, incomplete order detail and recurring deductions. Those records support a practical discussion about reporting and settlement terms without treating all carrier-held cash as immediately available.

Sources

Requirements and product details can change. Check the linked guidance for the facts that apply to your situation.

Related reading

Need help with this work?

General information, not personalized accounting, tax, legal, or investment advice. Have the appropriate qualified professional review decisions that depend on your circumstances.