Discuss a project

DL-054 · Case study

Order and cash-on-delivery reconciliation for an African retailer

A retail business operating across online channels needed to understand fulfilment, failed deliveries and final cash collections.

Client
Name withheld
Location
Nigeria
Industry
Consumer retail
Capabilities
01Audit03Build
01

Challenge

  • Delivered, returned and unpaid orders were tracked in different systems.
  • Cash-on-delivery transactions required manual reconciliation with courier remittances.
02

Environment

  • Shopify, Jumia Seller Center exports and local courier systems.
  • Internal finance software, bank exports and warehouse order records.
03

Intervention

  • Created a normalized operational data model using available APIs and structured exports.
  • Designed matching logic between orders, proof of delivery and courier remittances.
  • Built an exception dashboard for missing payments, returns and unmatched settlements.
04

Outcome

  • Finance and operations teams share the same view of delivery and collection status.
  • Outstanding remittances and fulfilment exceptions become easier to investigate.
Orders, courier events and cash remittances unified into an exception-based finance workflow.ORDERSShopify / JumiaCOURIER EVENTSDeliveryDATA MODELNormalizedMATCHINGRemittancesEXCEPTIONSFinance view
  1. 01ORDERSShopify / JumiaCOURIER EVENTSDelivery
  2. 02COURIER EVENTSDeliveryDATA MODELNormalized
  3. 03DATA MODELNormalizedMATCHINGRemittances
  4. 04MATCHINGRemittancesEXCEPTIONSFinance view
Fig. 01Delivery-to-cash reconciliationOrders, courier events and cash remittances unified into an exception-based finance workflow.Scale NTS

Stack and services.

Stack02

  • Shopify
  • Jumia

Services used01

Tell us what has to work.

A senior engineer reads every brief. Describe the system, what it runs on today and what happens when it fails.

Discuss a project