Skip to main content

Payment reconciliation

Reconciliation matches the SIG's payments against the results returned by the mobile money operator: TELECEL, Orange Money or MTN.

ToolWhereUse
Import reconciliationTransfer pageImport of the CT file: updates each payment's status
Financial ReconciliationMenu Cash Transfers → ReconciliationDetailed check of an operator statement, with discrepancy resolution

Workflow Reconciliation

Import the CT file into a transfer​

The CT file is returned by the operator after processing the ST file.

Conditions​

  • The transfer is Validated or In progress.
  • The payments to update are In progress, i.e. included in an ST file already exported.
  • Required right (Settings → Roles): Consulter les paiements.

Procedure​

  1. Open the transfer.
  2. In the quick actions, click Import reconciliation.
  3. Select the operator's CSV or Excel file and import it.

Expected columns​

ColumnContent
Beneficiary identifierBeneficiary code, phone or mobile account
statut (required)Success (reussi, success…) or failure (echoue, failed…)
Transaction IDOperator reference, optional
Failure reasonOptional

An unrecognised status is reported line by line and the payment is left unchanged.

Result​

  • A success moves the payment to Executed and debits the operator account.
  • A failure moves the payment to Failed.
  • When no payment is left In progress, the transfer becomes Completed.

Financial reconciliation​

Side menu: Cash Transfers → Reconciliation. Required right: Réconcilier les paiements.

Create a session​

  1. Start a new reconciliation.
  2. Operator: Orange Money, MTN Mobile Money or Telecel Cash.
  3. Period: start and end dates. The transfer is optional.
  4. File: statement as CSV, XLSX or XLS. A CSV template is available.
  5. Confirmation: check, then create the session.

A Completed transfer can no longer be reconciled.

Statement formats​

TELECEL (CSV with ; or Excel): ID Transfert, Téléphone, Montant (FCFA), Statut Transfert, Date, Message / Réf. Opérateur, ID Ordre Transfert, Nom Bénéficiaire, Solde Restant (FCFA).

Orange Money (CSV with ; or Excel): Transaction ID, Recipient Phone, Amount, Status, Transaction Date.

MTN (CSV with , or Excel): TransRef, MSISDN, Amount, TxnStatus, DateTime.

For TELECEL, the last value of Solde Restant (FCFA) updates the operator account balance.

Execute matching​

Click Execute matching. Each statement line is compared with the payments:

  1. TELECEL key 245{phone}-{beneficiary code}: direct match.
  2. Exact reference: direct match.
  3. Fuzzy match, by points: same phone 20; exact amount 40, or within 1% 20; same day 40, or within 3 days 20.

A score of 60 or more counts as a match.

Results​

Indicators: imported lines, matches, discrepancies, match rate, amount variance. Tabs: all, matched, discrepancies, to resolve.

ResultMeaning
Exact matchEverything agrees
Fuzzy matchScore of 60 or more, to check
Amount discrepancyPayment found, different amount
Status discrepancyPayment found, different status
Not found (internal)Operator transaction with no payment in the SIG
Not found (external)SIG payment missing from the statement

Resolve discrepancies​

Resolve one discrepancy or several at once. Choose the action and add a comment:

ActionMeaning
AcceptThe discrepancy is justified
CorrectA corrective action was taken
RejectThe discrepancy is invalid

Accepting or correcting a line the operator reports as successful debits the operator account. Rejecting has no accounting effect.

Finalize and export​

  • Finalize closes the session once discrepancies are handled.
  • Export produces the result as CSV, Excel or PDF.

Good practice​

Recommendations
  1. Import the CT file as soon as you receive it.
  2. Do not leave amount discrepancies unexplained.
  3. Comment every rejection.
  4. File the report in the transfer's Documents.

See also​