Skip to main content

Payment Export

Payments can be exported in different formats for transmission to operators or reporting.

Access

  1. Side menu: Monetary Transfers > Cycles
  2. Open the relevant cycle
  3. Click on Export

Required permission: transferts.export

Export formats

Standard export

FormatDescriptionUsage
CSVText format with separatorsImport into Excel or other tools
Excel.xlsx file with formattingViewing and printing
PDFPrintable documentArchives and validation

Operator export

Specific formats for payment operators:

OperatorFormatDescription
Orange MoneySpecific CSVFormat required by Orange
Free MoneySpecific CSVFormat required by Free
WaveSpecific CSVFormat required by Wave
BankSEPA/TransferStandard banking format

Export content

Standard columns

ColumnDescription
ReferenceUnique payment reference
Beneficiary nameHousehold head name
PhoneContact number
Account numberMobile Money or bank account
AmountAmount to transfer
StatusPayment status

Additional columns

  • Household code
  • Region / Municipality
  • Program
  • Generation date

Export a complete cycle

  1. Open the cycle
  2. Click on Export
  3. Select the format
  4. Download the file

The export includes all payments from the cycle.

Export by operator

To generate separate files by operator:

  1. Click on Operator export
  2. Select the desired operators
  3. Download the files

Each operator receives a file with only their beneficiaries.

Filter the export

Before exporting, you can filter:

FilterOptions
StatusPending, Sent, Paid, Failed
Payment methodMobile Money, Bank
OperatorOrange, Free, Wave, etc.
RegionGeographic area

Transfer letter

Generate an official transfer request letter:

  1. Click on Generate letter
  2. The letter is generated in PDF
  3. Download and print

The letter contains:

  • Official header
  • Cycle summary
  • Total amount
  • Number of beneficiaries
  • Signature

Beneficiary list

Export the complete list of beneficiaries for a cycle:

  1. Click on Beneficiary list
  2. Choose the format
  3. Download

Useful for:

  • Field verification
  • Archives
  • Audits

Export history

Exports are tracked in the history:

  • Date and time
  • User
  • Format
  • Number of records

Import returns

After execution, import returns from operators:

  1. Click on Import returns
  2. Select the return file
  3. Verify the correspondence
  4. Validate the import

Payment statuses are updated automatically.

Reconciliation

To reconcile payments:

  1. Go to Reconciliation
  2. Import operator files
  3. The system identifies matches
  4. Validate the reconciliations

See Reconciliation for more details.