Reconciling COD payouts in Tunisia: match courier transfers to orders

A delivered order is not necessarily a bank transfer you have received. COD reconciliation connects three things: money collected on your parcels, agreed deductions and funds actually credited to your account. Keeping those stages separate reveals what is still outstanding. Start with one statement and one shipment group instead of searching for a single unexplained balance across months of unrelated movements.

Separate parcel status from payment status

A delivered parcel may not yet be included in a payout. A transfer announced on a statement may also not be visible in the bank account at the same moment. Retain the delivery date, statement allocation date and actual receipt date separately. Do not overwrite one with another. Define whether paid means the customer paid the driver or the courier paid your business.

Confirm the collection arrangement directly with your provider. The COD information in the INTIGO FAQ and the Tunisian Post parcel service provides reference points. Schedules and deductions depend on your agreement; one company’s published timing is not a rule for all carriers.

Create a register with stable references

Keep your internal order identifier and tracking number in separate columns. Add the courier, amount requested from the customer, agreed fees, parcel outcome and payout batch reference. Customer name or phone alone is insufficient because someone can order twice. Preserve references as text when they begin with zero, avoiding spreadsheet conversions that silently change their meaning.

Archive the original statement before cleaning it. Trimming surrounding spaces in a working copy may be appropriate, but deleting part of a reference to force a match is not. Document each transformation. If the same tracking reference appears to match two orders, place those lines in an exception list rather than choosing a convenient match.

Match references before comparing totals

1. Identify the carrier, period and statement reference.
2. Link each statement line to a known tracking number.
3. Separate unknown references, duplicates and open parcels.
4. Verify the amounts collected on completed deliveries.
5. Deduct documented charges once.
6. Compare the expected net with the bank transaction and preserve any difference.

A different amount should not disappear from your worksheet. It may reflect an extra service, an amount changed at delivery or a data error. Record the explanation and supporting document. Until that exists, the item remains under review rather than becoming an automatically accepted expense or proven debt owed by the courier.

A worked example of a short payout

A fictional store has ten delivered parcels, each with a total customer collection of 60 TND. That amount includes everything the customer agreed to pay. Gross collection is 10 × 60 = 600 TND. Illustrative delivery fees are 6 TND per parcel, totalling 60 TND, plus 4 TND for two returns on the same statement. Expected net payout is 600 − 60 − 4 = 536 TND.

Movement	Amount	Evidence
Delivered parcel collections	600 TND	Ten tracking references
Documented fees	64 TND	Statement and agreement
Expected net	536 TND	Reconciliation calculation
Transfer received	500 TND	Bank entry
Unresolved difference	36 TND	Outstanding reconciliation item

These are teaching figures rather than actual carrier charges. Do not immediately write off the 36 TND as a loss, and do not mark the batch fully paid just because a transfer exists. Ask whether the difference represents a partial payment, a disputed charge or a line omitted from the batch.

Record partial payments without rewriting history

Record the 500 TND on its actual receipt date with its reference, leaving the balance visible. A later transfer is a new movement, not a reason to increase the earlier payment as though all funds arrived that day. Where one transfer covers several statements, keep its allocation documented. The same dinar must not settle two batches.

Matjri order and finance tools can help organise references and settlements. Check the fields and workflow available to your account rather than assuming every courier file is automatically reconciled. Original statements and bank evidence remain necessary to establish what you actually received.

Organise exceptions into actionable follow-up

Classify differences as unknown references, changed amounts, unexplained charges, missing announced transfers or partial payouts. Assign an owner and next review date. Send only relevant references and amounts to the courier rather than exporting your entire customer database. A concise evidence file is easier to investigate than disconnected screenshots with no clear question.

Age outstanding balances from the agreed due date. The order date is not always the starting point for settlement timing. Check your opening balance at the beginning of each month as well: repeatedly carrying an old difference into new statements obscures its origin and can lead to chasing the wrong batch.

Questions about COD reconciliation

Can I close the financial record as soon as an order is delivered?

No. Delivery and settlement rely on different evidence. Complete the logistics record according to the facts, then keep the financial balance open until the payment and deductions are matched.

What if the statement has no parcel references?

Request a file or batch reference that permits matching. Do not allocate the amount randomly. Retain the transfer as temporarily unallocated, with its evidence, until sufficient information arrives.

What should I reconcile first?

Choose one statement, its bank transfer and the associated delivered orders. Describe every difference and its possible explanation before adding the next statement to your working process.