Understanding PSP Reports
Each PSP produces settlement files in a different format, with different column names, date formats, decimal separators, and transaction types. NjiaPay normalises all of them into the same column structure so you can reconcile across providers in a single spreadsheet.
This section explains what you will find in each PSP's raw settlement file, the different types of rows it contains, and how they map to NjiaPay's reconciliation reports.
Supported PSPs
Adyen
Settlement details report with per-transaction fee breakdowns across 9 distinct row types: Settled, Refunded, Chargeback, ChargebackReversed, SecondChargeback, MerchantPayout, Fee, InvoiceDeduction, and SettledReversed.
How NjiaPay Uses PSP Data
When you upload a PSP settlement file, NjiaPay:
- Parses the CSV according to the PSP's specific format (date formats, decimal separators, column names)
- Classifies each row as either a transaction (payment, refund, chargeback) or a non-transaction item (payout, fee, dispute hold)
- Normalises the data into NjiaPay's unified column structure (
psp_type,psp_gross_amount,psp_net_amount, etc.) - Matches transaction rows against NjiaPay records using the PSP reference ID
Transaction rows appear in the Successful Payments or Refunds, Chargebacks & Pending reports. Non-transaction rows appear in the Fees & Settlements report.
exists_in_psp = False) because NjiaPay does not yet ingest their settlement files.