API
Reconciliation results API
Read Netcash statement reconciliation results per account: totals, balance view, matched lines, mismatches, payouts and payments missing from the statement.
On this page
Overview#
Reconciliation compares money on a statement with payments in CentraPoint. Runs are created in the dashboard: Netcash merchant statements are fetched automatically (daily), and CSV statements from other gateways or banks can be imported. See Debit orders & reconciliation for how matching works. This read-only API lets your finance or ERP systems pull the results.
Requires API access and the Reconciliation plan feature (Business and Enterprise plans). The same plan feature controls the nightly Netcash statement import for every Netcash gateway.
Netcash accounts#
Every Netcash gateway can reconcile its Netcash account: Netcash Debit Orders, Netcash Pay Now (including its recurring card payments) and Netcash Creditor & Salary Payments. Add the Account service key (Netcash > Account profile > NetConnector > Account service) to the gateway under Settings > Payment providers; it is optional on Pay Now and Creditor gateways and required on Debit Orders. Gateways still set up with the retired Netcash Recurring Card module (type netcash_recurring) are reconciled like Pay Now.
- Gateways that share one Netcash merchant account use the same key and are one account: the statement is fetched once and matched against the payments and payouts of all of them. Accounts have a stable id such as
acct_3f9a1c7b20d4e5f6(one per service key; the key itself is never returned). - Statements are fetched nightly for every enabled gateway with a key, and on demand with Run now on the Reconciliation page. Runs are safe to repeat: lines are imported once and only unmatched lines are matched again (open lines of recent runs are retried on every run).
- Statement postback (recommended): once a gateway has its Account service key, its card under Settings > Payment providers shows a Statement postback URL. In the Netcash portal open Account profile > NetConnector (Connected services) > Account service, tick postback and paste the URL. When Netcash signals a new statement, CentraPoint fetches it from Netcash at once instead of waiting for the nightly fetch, which stays on as the fallback. The statement is always fetched from Netcash before anything is reconciled: what is posted to the URL is only compared with it. A posted statement Netcash does not confirm (or posted lines its statement does not have) is listed under Unverified postback - review on the Reconciliation page; it changes no payment, payout or debit order, and the API does not return it. If Netcash's statement later has those lines, they are reconciled normally. Netcash keeps one postback URL per account: for gateways that share a key, paste the URL of any one of them. The URL contains a secret, so keep it private. Netcash's intraday (interim) statements are not used: Netcash advises reconciling off the full daily statement.
How lines are matched#
| category | Netcash codes (examples) | What CentraPoint does |
|---|---|---|
collection | PNC, PNE, PNP, PNM, PIS, TDD, SDD, DCS | Matched by your payment reference (CP-…), the Pay Now RequestTrace or the debit order reference; confirms (completes) the payment. Recurring card collections are matched to the subscription's next renewal payment. When a reference names several payments (a debit order reference is shared by every month's collection), only payments presented (action date) on or before the line's date are considered: a line dated before any of them was presented confirms nothing and is an exception. The same applies to a line dated up to 3 days before a payment of that reference is presented (one no line confirmed yet) when none was presented in the 3 days before the line: it is not given to the previous month's payment. Netcash is not known to date a collection before its action date; the rule only keeps such a line from being matched a month off. Among those, the date decides first: the payments dated within 3 days of the line (otherwise the nearest month's), and among those the one with the line's amount. A payment with the line's amount a month away is never used instead; a line on September's date with a different amount is an exception (amount differs) on September's payment. A line that carries no reference at all (no Extra field and no CentraPoint reference) is compared with the payments of the account's gateways that have the same amount and are dated within 3 days (and not before the payment was presented or created; a subscription renewal counts whenever it was recorded, because CentraPoint records it when the gateway reports the charge, which can be after the statement date), only when there is a single such payment and only after every line that carries a reference: a completed payment is matched (nothing changes), a pending payment is only suggested in the line's note and the line stays unmatched. Amount and date alone never complete a payment; the gateway's confirmation or a line with the payment's reference does. A line whose reference names none of your payments (for example money of another integration on the same Netcash account) is never matched by amount and date. A line that names a payment takes it over from a line matched by amount and date alone (which then becomes an exception) only when the payment is dated within 3 days of the line (the debit order action date, otherwise the date the gateway confirmed the payment or the date it was created) and the line would confirm it itself (same amount, payment not failed or cancelled); otherwise the amount and date match stays and the line that names the payment is an exception with kind: duplicate_collection. A further line for a payment another line already confirmed is never counted twice: it is an exception with kind: duplicate_collection. A collection line that takes money out (a negative amount, for example a CSV row with a collection code and a minus sign) never confirms or completes the payment it names: it is an exception linked to no payment. |
fee | NSF, VAT | Linked to the payment it names and recorded as its fee (and net amount) when the gateway did not report one. Other fees are account fees. Netcash's documentation describes its service fees as posted in a monthly total on the 1st; a fee line without a payment reference is an account fee. |
refund | PNR, PNX, DRC | Confirms a refund CentraPoint knows about; otherwise an exception. |
unpaid | PNU, PND, PNZ, DRU, DCD | Returns, recalls and chargebacks: debit orders are marked unpaid; a completed payment is marked failed and flagged (kind: chargeback for disputes). Only a line that takes money out does this: one that brings money in or moves none (for example a CSV row described as an unpaid reversal) and a failed Ozow refund (PIZ) change no payment: an exception for you to check when the line names a payment, otherwise unmatched. A payment is returned only once: a return for a payment whose return is already on a statement, or one with the date and amount of such a return (for example the same return in a second import), is an exception and changes no payment. When the line names only a debit order reference that several payments share, only payments presented (action date) on or before the line's date are considered (a payment presented on the line's date counts). Among those, the ones with the line's amount are preferred; then the ones that may have been collected: every debit order that reached the payer's bank, whatever its status (a failed debit may have been collected and then returned, for example one marked unpaid by hand; a pending one may already have been collected before CentraPoint settles it), so only a debit that never reached the bank (rejected at load, a failed upload, or removed or cancelled before upload) is left out (other payments: failed or cancelled ones without a collection line); then, for returns, the ones whose return is not on a statement yet (a debit is returned only once: once the original's return is matched or linked, the original is no longer a candidate for a later return on the mandate, so that return can go to the re-presentation). Each step applies only if it leaves a payment. Unless exactly one payment is left, the line is an exception and no payment is changed; a payment that was collected is not preferred over one that may have been, because that would be a guess. The same applies to refund and fee lines on a shared reference (without the return step). A return for a debit order that is already failed changes nothing. Decline codes (PNU, PNW, PVU, PFD, PME, PGD, PIF) never change a payment (kind: decline). A 0.00 decline is an information line (ignored), except on the completed first payment of a subscription. A decline on a pending or failed payment is matched. On a completed payment it is matched only when the payment's collection (for a subscription: a renewal's) is on a statement on a later day than the decline, or the gateway itself confirmed the payment on a later day (a payment CentraPoint completed from a statement line or a debit order settlement does not count as confirmed by the gateway); a collection on the same day does not count, because the statement does not show which came first. Otherwise it is an exception (for example a declined subscription renewal). Completed payments whose collection never appears are still reported as not_received. |
disbursement | CRP, DCP, CRT, SAL, SAD, CRU, SRU, CRJ | Creditor and salary payments, matched to your payout by its PAY-… reference (or amount and action date). The debit marks the payout paid; a return or rejection (for example CRU, SRU or CRJ) marks it failed and releases the credit note. Money received that only carries a PAY-… reference, without a Netcash creditor or salary code, is left unmatched for you to link. |
payout | BTR, BRT | Settlements to your own bank account. Recorded; a returned transfer (BTU, BRR) is flagged. |
other | OBL, CBL, authorisations | Balances and information lines. Other money lines need attention. |
When a Creditor & Salary Payments gateway's statement is reconciled (its Account service key is set and your plan includes reconciliation), its creditor and salary batches also send each payout's PAY-… reference to Netcash as Extra 1 (batch file field 301), which Netcash documents as returned on the statement. Batches of other gateways do not include that field. After the first live payout batch of a reconciled gateway, check its upload report in the Netcash portal (the file must be accepted with that field) and that the next statement shows the PAY-… reference on the payment line. Without it, payouts are matched by amount and action date only, which cannot tell payouts of the same amount apart.
The run object#
{
"id": "cmg3r7c0n0013run0001abcd",
"source": "netcash_statement",
"account": {
"id": "acct_3f9a1c7b20d4e5f6",
"providers": [
{
"id": "cmg3prov0000paynow000001",
"name": "Card payments",
"type": "netcash_paynow"
},
{
"id": "cmg3prov0000recur0000002",
"name": "Subscriptions",
"type": "netcash_paynow"
},
{
"id": "cmg3prov0000credit000003",
"name": "Payouts",
"type": "netcash_creditor"
}
]
},
"statementDate": "2026-09-24T22:00:00.000Z",
"periodStart": "2026-09-23T22:00:00.000Z",
"periodEnd": "2026-09-24T22:00:00.000Z",
"status": "exceptions",
"lineCount": 42,
"matched": 38,
"unmatched": 1,
"notReceived": 1,
"exceptions": 2,
"totals": {
"receipts": 48250.5,
"fees": 612.4,
"refunds": 499,
"payouts": 33000,
"settlements": 33000,
"disbursements": 12000,
"unpaids": 350
},
"openingBalance": 1203.55,
"closingBalance": 2992.65,
"balance": {
"opening": 1203.55,
"collections": 48250.5,
"unpaids": -350,
"refunds": -499,
"fees": -612.4,
"disbursements": -12000,
"settlements": -33000,
"other": 0,
"closing": 2992.65,
"computedClosing": 2992.65,
"difference": 0
},
"trigger": "cron",
"error": null,
"createdAt": "2026-09-25T02:00:03.000Z",
"completedAt": "2026-09-25T02:04:11.000Z"
}| Field | Type | Description |
|---|---|---|
idrequired | string | Run ID. |
sourcerequired | string | netcash_statement or csv_upload. |
accountrequired | object | null | Netcash runs: id (acct_…, null for runs from before accounts) and the providers (id, name, type) sharing the account. Null for CSV imports. |
statementDaterequired | string | null | End of the statement period (or its start when no end is known). |
periodStart, periodEndrequired | string | null | Statement period. |
statusrequired | string | See Run statuses. |
lineCountrequired | integer | Statement lines imported. |
matchedrequired | integer | Lines matched to a CentraPoint payment or payout. |
unmatchedrequired | integer | Lines no payment or payout could be found for. |
notReceivedrequired | integer | Number of not_received and not_debited items. |
exceptionsrequired | integer | Items that need attention: mismatches, unmatched lines and not_received payments. |
totalsrequired | object | See Totals. |
openingBalance, closingBalancerequired | number | null | From the statement's opening and closing balance lines, when present. |
balancerequired | object | Signed balance view: opening, collections, unpaids, refunds, fees, disbursements (payouts), settlements, other, closing, computedClosing (opening plus every line) and difference (closing minus computedClosing; non-zero means lines are missing). |
triggerrequired | string | null | cron (nightly import, also when Netcash signals the requested statement), postback (a statement fetched from Netcash to confirm one posted to the Statement postback URL, for example one requested by other software using the same Account service key), manual (Run now or a CSV import) or admin (started by CentraPoint on your behalf). Null for runs from before this field. |
errorrequired | string | null | Why a run failed. |
createdAt, completedAtrequired | string | When the run started and finished. |
Run statuses#
| status | Meaning |
|---|---|
processing | The statement has been requested or is being imported. |
failed | The import failed; see error. |
balanced | Completed and nothing needs attention. |
exceptions | Completed and at least one item needs attention (exceptions > 0). |
Totals#
Positive sums of the statement lines in each category: receipts (collections), fees, refunds, payouts and settlements (both: transfers to your bank), disbursements (creditor, salary and refund payouts, net of returns) and unpaids (returned debit orders, reversals, chargebacks and declines). Settlements, unlinked fees and balance lines are counted in totals but are not items.
Items#
GET /api/v1/reconciliation/runs/{id} adds an items array: one item per statement line (except ignored lines such as account fees, settlements and balances; fees linked to a payment are included), plus not_received and not_debited items (these have id: null).
| Field | Type | Description |
|---|---|---|
idrequired | string | null | Statement line ID (null for not_received / not_debited). |
statusrequired | string | See Item statuses. |
matchStatusoptional | string | Raw line status: matched, unmatched, exception or ignored. |
categoryrequired | string | See categories. |
kindrequired | string | null | How the line was resolved: collection, renewal, fee, refund, chargeback, reversal, decline, duplicate_collection, unpaid, payout_paid, payout_returned, settlement, balance, offline_payment or manual. |
codeoptional | string | null | Netcash transaction type code (or the CSV code column). |
transactionId, payoutId, payoutReferencerequired | string | null | The matched payment or payout. |
referencerequired | string | null | The CentraPoint payment reference when matched, otherwise the reference on the statement line. |
externalReferencerequired | string | null | From the payment link or EFT order of the matched payment. |
expectedAmountrequired | number | null | The CentraPoint payment amount (payouts: negative payout amount). |
statementAmountrequired | number | null | Signed: positive for money in, negative for money out. Null for not_received. |
daterequired | string | null | Statement line date. |
descriptionrequired | string | null | Statement line description (or the payment description for not_received). |
noterequired | string | null | Why the item has this status. |
Item statuses#
| status | Meaning | Needs attention |
|---|---|---|
matched | The line confirms a CentraPoint payment (a pending payment it confirms is completed). | No |
amount_mismatch | Matched by reference, but the amount differs. | Yes |
exception | Matched, but something else is wrong; see note (e.g. money received for a failed payment, a second collection for a payment that is already confirmed, a reversal after completion, or a refund CentraPoint doesn't know about). | Yes |
unmatched_receipt | Money in that can't be tied to a payment. Includes deposits that look like an EFT order until staff approve it. | Yes |
unmatched_debit | Money out (unpaid, reversal, refund, creditor or salary payment) that can't be tied to a payment or payout. | Yes |
not_received | A payment CentraPoint completed that no statement line confirms. See below. | Yes |
not_debited | A payout CentraPoint shows as paid (Creditor gateway of the account) that no debit on the statement confirms after 3 days. | Yes |
When not_received applies#
- Only for Netcash statement runs (
source: netcash_statement) that have completed (not CSV uploads). - Only for completed payments of the account's Netcash Pay Now (including recurring card payments) or Debit order gateways, paid within the statement period (runs from before accounts: all of them).
- Only once they are more than 3 days old (relative to the end of the period, or now if earlier), to allow for settlement delays.
- Only payments not matched to any statement line. At most 500 are listed per run.
List runs#
/api/v1/reconciliation/runs| Field | Type | Description |
|---|---|---|
fromoptional | string (YYYY-MM-DD) | Runs started on or after this day (South African time). |
tooptional | string (YYYY-MM-DD) | Runs started on or before this day. |
accountoptional | string | Only runs of this Netcash account (acct_…). |
sourceoptional | string | netcash_statement or csv_upload. |
limitoptional | integer | 1–100, default 20. Newest first. |
curl -X GET "https://app.centrapoint.co.za/api/v1/reconciliation/runs?from=2026-09-01&to=2026-09-30" \
-H "Authorization: Bearer $CENTRAPOINT_API_KEY"Returns { "data": [ run, … ] } without items.
Get a run#
/api/v1/reconciliation/runs/{id}curl -X GET "https://app.centrapoint.co.za/api/v1/reconciliation/runs/cmg3r7c0n0013run0001abcd" \
-H "Authorization: Bearer $CENTRAPOINT_API_KEY"{
"id": "cmg3r7c0n0013run0001abcd",
"source": "netcash_statement",
"account": {
"id": "acct_3f9a1c7b20d4e5f6",
"providers": [
{
"id": "cmg3prov0000paynow000001",
"name": "Card payments",
"type": "netcash_paynow"
},
{
"id": "cmg3prov0000recur0000002",
"name": "Subscriptions",
"type": "netcash_paynow"
},
{
"id": "cmg3prov0000credit000003",
"name": "Payouts",
"type": "netcash_creditor"
}
]
},
"statementDate": "2026-09-24T22:00:00.000Z",
"periodStart": "2026-09-23T22:00:00.000Z",
"periodEnd": "2026-09-24T22:00:00.000Z",
"status": "exceptions",
"lineCount": 42,
"matched": 38,
"unmatched": 1,
"notReceived": 1,
"exceptions": 2,
"totals": {
"receipts": 48250.5,
"fees": 612.4,
"refunds": 499,
"payouts": 33000,
"settlements": 33000,
"disbursements": 12000,
"unpaids": 350
},
"openingBalance": 1203.55,
"closingBalance": 2992.65,
"balance": {
"opening": 1203.55,
"collections": 48250.5,
"unpaids": -350,
"refunds": -499,
"fees": -612.4,
"disbursements": -12000,
"settlements": -33000,
"other": 0,
"closing": 2992.65,
"computedClosing": 2992.65,
"difference": 0
},
"trigger": "cron",
"error": null,
"createdAt": "2026-09-25T02:00:03.000Z",
"completedAt": "2026-09-25T02:04:11.000Z",
"items": [
{
"id": "cmg3line000000000000001",
"runId": "cmg3r7c0n0013run0001abcd",
"status": "matched",
"matchStatus": "matched",
"category": "collection",
"kind": "collection",
"code": "PNC",
"reference": "CP-20260924-9F3A1C7B",
"externalReference": "ORDER-1001",
"transactionId": "cmg3tx00000000000000001",
"payoutId": null,
"payoutReference": null,
"expectedAmount": 499,
"statementAmount": 499,
"date": "2026-09-24T00:00:00.000Z",
"description": "Pay Now card CP-20260924-9F3A1C7B",
"note": "Confirmed by statement"
},
{
"id": "cmg3line000000000000002",
"runId": "cmg3r7c0n0013run0001abcd",
"status": "matched",
"matchStatus": "matched",
"category": "fee",
"kind": "fee",
"code": "NSF",
"reference": "CP-20260924-9F3A1C7B",
"externalReference": null,
"transactionId": "cmg3tx00000000000000001",
"payoutId": null,
"payoutReference": null,
"expectedAmount": 499,
"statementAmount": -14.97,
"date": "2026-09-24T00:00:00.000Z",
"description": "Pay Now fee CP-20260924-9F3A1C7B",
"note": "Fee 14.97 recorded on CP-20260924-9F3A1C7B"
},
{
"id": "cmg3line000000000000003",
"runId": "cmg3r7c0n0013run0001abcd",
"status": "amount_mismatch",
"matchStatus": "exception",
"category": "collection",
"kind": "collection",
"code": "PNC",
"reference": "CP-20260924-41D07E2A",
"externalReference": "ORDER-1002",
"transactionId": "cmg3tx00000000000000002",
"payoutId": null,
"payoutReference": null,
"expectedAmount": 1200,
"statementAmount": 1100,
"date": "2026-09-24T00:00:00.000Z",
"description": "Pay Now card CP-20260924-41D07E2A",
"note": "Amount differs: statement 1100.00 vs transaction 1200.00"
},
{
"id": "cmg3line000000000000004",
"runId": "cmg3r7c0n0013run0001abcd",
"status": "matched",
"matchStatus": "matched",
"category": "disbursement",
"kind": "payout_paid",
"code": "CRP",
"reference": "PAY-000042",
"externalReference": null,
"transactionId": null,
"payoutId": "cmg3payout0000000000042",
"payoutReference": "PAY-000042",
"expectedAmount": -1500,
"statementAmount": -1500,
"date": "2026-09-24T00:00:00.000Z",
"description": "Creditor payment | PAY-000042",
"note": "Payout PAY-000042 debited - marked paid"
},
{
"id": "cmg3line000000000000005",
"runId": "cmg3r7c0n0013run0001abcd",
"status": "unmatched_receipt",
"matchStatus": "unmatched",
"category": "collection",
"kind": null,
"code": "PNE",
"reference": null,
"externalReference": null,
"transactionId": null,
"payoutId": null,
"payoutReference": null,
"expectedAmount": null,
"statementAmount": 75,
"date": "2026-09-24T00:00:00.000Z",
"description": "Pay Now EFT",
"note": "Money received with no CentraPoint payment"
},
{
"id": null,
"status": "not_received",
"category": "collection",
"kind": null,
"reference": "CP-20260920-7C21A9F0",
"externalReference": "ORDER-0990",
"transactionId": "cmg3tx00000000000000003",
"payoutId": null,
"payoutReference": null,
"expectedAmount": 250,
"statementAmount": null,
"date": null,
"description": "Website hosting",
"note": "Completed in CentraPoint but not on the statement after 3 days"
}
]
}List statement lines#
/api/v1/reconciliation/lines| Field | Type | Description |
|---|---|---|
statusoptional | string | open (unmatched and exceptions), matched, unmatched, exception or ignored. |
categoryoptional | string | collection, unpaid, refund, fee, disbursement, payout or other. |
accountoptional | string | Only lines of this Netcash account (acct_…). |
runIdoptional | string | Only lines of this run. |
from, tooptional | string (YYYY-MM-DD) | Statement line date range. |
limit, startingAfteroptional | integer, string | Page size (1–100, default 20) and cursor (nextCursor of the previous page). Newest line date first. |
curl -X GET "https://app.centrapoint.co.za/api/v1/reconciliation/lines?status=open&account=acct_3f9a1c7b20d4e5f6" \
-H "Authorization: Bearer $CENTRAPOINT_API_KEY"{
"data": [
{
"id": "cmg3line000000000000005",
"runId": "cmg3r7c0n0013run0001abcd",
"status": "unmatched_receipt",
"matchStatus": "unmatched",
"category": "collection",
"kind": null,
"code": "PNE",
"reference": null,
"externalReference": null,
"transactionId": null,
"payoutId": null,
"payoutReference": null,
"expectedAmount": null,
"statementAmount": 75,
"date": "2026-09-24T00:00:00.000Z",
"description": "Pay Now EFT",
"note": "Money received with no CentraPoint payment"
}
],
"hasMore": false,
"nextCursor": null
}List Netcash accounts#
/api/v1/reconciliation/accountsYour Netcash accounts (gateways grouped by Account service key) with the last run, open items and a 30-day balance view.
curl -X GET "https://app.centrapoint.co.za/api/v1/reconciliation/accounts" \
-H "Authorization: Bearer $CENTRAPOINT_API_KEY"{
"data": [
{
"id": "acct_3f9a1c7b20d4e5f6",
"object": "reconciliation_account",
"providers": [
{
"id": "cmg3prov0000paynow000001",
"name": "Card payments",
"type": "netcash_paynow"
},
{
"id": "cmg3prov0000recur0000002",
"name": "Subscriptions",
"type": "netcash_paynow"
},
{
"id": "cmg3prov0000credit000003",
"name": "Payouts",
"type": "netcash_creditor"
}
],
"lastRun": {
"id": "cmg3r7c0n0013run0001abcd",
"status": "completed",
"startedAt": "2026-09-25T02:00:03.000Z",
"finishedAt": "2026-09-25T02:04:11.000Z",
"error": null
},
"lastStatement": {
"runId": "cmg3r7c0n0013run0001abcd",
"periodStart": "2026-09-23T22:00:00.000Z",
"periodEnd": "2026-09-24T22:00:00.000Z"
},
"unmatched": 1,
"unmatchedAmount": 75,
"exceptions": 1,
"notReceived": 1,
"balance": {
"periodDays": 30,
"opening": 1203.55,
"collections": 48250.5,
"unpaids": -350,
"refunds": -499,
"fees": -612.4,
"disbursements": -12000,
"settlements": -33000,
"other": 0,
"closing": 2992.65,
"computedClosing": 2992.65,
"difference": 0
}
}
]
}Webhook#
reconciliation.completed is sent when a run finishes matching. Its data is a summary: runId, status, exceptions, lineCount, statementDate, totals, account (as on the run) and summary (matched, unmatched, notReceived and the balance view). Fetch the run for the items. See Webhooks.
Errors#
| Status | error | When |
|---|---|---|
| 400 | invalid_request | from or to not YYYY-MM-DD, unknown status, category or source, or an invalid startingAfter. |
| 403 | plan_restricted | Plan lacks the API or Reconciliation. |
| 404 | not_found | No run with this ID, or no Netcash account with this account id, in your organisation. |
| 401 / 429 / 500 | unauthorized / rate_limited / internal_error | See Errors |