Successful Payments

The Successful Payments report is the core of your reconciliation. It contains every successful payment processed through NjiaPay, each shown with its reconciliation status. A transaction in this report is either:

• Matched: found in both NjiaPay and the PSP settlement file (exists_in_njia = True, exists_in_psp = True). All columns are populated, including PSP amounts, fees, and break flags.
• Unmatched: exists in NjiaPay but no corresponding PSP settlement record was found yet (exists_in_njia = True, exists_in_psp = False). Only the NjiaPay columns are filled; all PSP columns and break flags are empty.

When to Use This Report

• As your primary reconciliation worksheet. Filter to see matched vs. unmatched at a glance
• To review processing fees charged by each PSP on matched transactions
• To calculate your net revenue after fees and currency conversion
• To identify amount breaks, i.e. discrepancies between what NjiaPay recorded and what the PSP settled
• To track which successful payments are still awaiting settlement confirmation

Column Reference

The report has three groups of columns: NjiaPay side (what NjiaPay recorded), PSP side (what the PSP settlement file says), and Break flags (discrepancy indicators).

NjiaPay Columns (always populated)

PSP Columns (populated only when matched)

These columns are filled when exists_in_psp = True. When the transaction is unmatched, they are all empty.

Reconciliation & Break Columns

Example Data

Below is an example mixing both matched and unmatched rows. Matched rows have all columns filled and break flags set to True/False, while unmatched rows have empty PSP columns and empty break flags.

NjiaPay side

PSP side (for matched rows only)

Unmatched rows (ACME_ORDER_50116, 54770, 60268, 59279) have no PSP data. They are awaiting settlement file upload.

How to Read This Report

Quickly Separate Matched from Unmatched

In your spreadsheet, filter or sort by the exists_in_psp column:

• True rows are fully reconciled. Both sides agree (check break flags for exceptions)
• False rows are still awaiting PSP settlement confirmation

A quick summary formula:

Matched count:    =COUNTIF(report[exists_in_psp], "True")
Unmatched count:  =COUNTIF(report[exists_in_psp], "False")
Match rate:       =COUNTIF(report[exists_in_psp], "True") / COUNTA(report[exists_in_psp])

Understanding the Fee Breakdown (Matched Rows Only)

For each matched transaction, you can calculate the effective fee rate:

Fee Rate = psp_total_costs / psp_gross_amount * 100

For example, a transaction with psp_gross_amount = 40.0 GBP and psp_total_costs = 0.84 GBP has an effective fee rate of 2.1%.

Understanding Currency Conversions

When the PSP converts currencies (e.g. NZD to EUR for settlement), you will see:

• njia_currency = NZD and psp_gross_currency = NZD (original currency matches)
• psp_exchange_rate = 0.484 (the NZD-to-EUR rate applied)
• psp_net_currency = EUR (the settlement currency after conversion)
• psp_net_amount = 14.0 (what lands in your EUR account)

The formula is: psp_net_amount = (psp_gross_amount * psp_exchange_rate) - psp_total_costs

Understanding Break Flags (Matched Rows Only)

Break flags only appear on matched rows. break_created_month = True is normal and expected. It means the NjiaPay transaction was recorded in a different month than the PSP settlement batch. PSPs typically settle in batches that may lag behind the actual transaction date by days or weeks.

When to investigate:

• break_gross_amount = True: the PSP settled a different amount than NjiaPay recorded. Check for partial refunds, chargebacks, or currency rounding.
• break_currency = True: the currencies don't match. This can happen with certain PSP configurations.

Why Are Some Successful Payments Unmatched?

Common reasons a successful payment may not yet have a PSP settlement match:

Tips for Working with This Report

Calculate Net Revenue by Currency (Matched Only)

=SUMIFS(report[psp_net_amount], report[psp_net_currency], "USD", report[exists_in_psp], "True")

Calculate Unmatched Exposure by Currency

=SUMIFS(report[njia_amount], report[njia_currency], "USD", report[exists_in_psp], "False")

Calculate Total Fees by PSP

=SUMIFS(report[psp_total_costs], report[psp_type], "AdyenGlobal", report[psp_cost_currency], "USD")

Find Transactions with Amount Breaks

Filter to exists_in_psp = True AND break_gross_amount = True to see all discrepancies at a glance.

Related Reports