# Supplier statement reconciliation for Sage X3

Sage X3 has no built-in supplier statement reconciliation. Pulsify reads each supplier statement, checks every line against your bills and credits and names what does not agree.

Supplier statement reconciliation means checking a supplier's supplier statement against the bills and credits in your books, so nothing is missing or paid twice.

## What Sage X3 does on its own

No built-in supplier statement matching was confirmed in Sage X3. You print the supplier account and compare it with the statement. A partner add-on, SynergERP Advanced Remittance, matches statement items and is listed on the Sage marketplace for South Africa.

- No built-in statement matching confirmed.

## What you need in Sage X3

- Sage X3 A/P-A/R accounting

## Setting it up in Sage X3

Where to find it: Financials > Invoices > Purchase invoices

1. Print the supplier account for the statement period.
2. Tick off each statement line against an invoice, credit memo or payment.
3. Enter missing invoices on Purchase invoices or Supplier invoices.
4. Enter missing credit memos as the credit memo invoice type.
5. Match payments and credit memos to invoices so the balance agrees.

## Good to know in Sage X3

- The Supplier invoice and payment history report lists invoices by status.
- An old v6.5 community thread asks for AP reconciliation and has no answer.
- Credit memo matching to the original invoice depends on the LETAUTCNO parameter at validation.

## How to do it in Sage X3

### How to run the supplier aged balance in Sage X3

In Sage X3, run the supplier aged balance as at your chosen date. Check the total ties to your accounts payable balance and look at items over 30 days. Full guide: https://www.pulsify.tech/how-to/run-an-aged-payables-report-in-sage-x3/

## What Pulsify adds

1. Forward the statement to Pulsify. It recognises supplier statements.
2. Pulsify reads the period, opening and closing balance and every line.
3. Each line is checked against the supplier's documents in Pulsify and bills and credits from Sage X3.
4. Lines that do not agree are named with a reason.
5. A person checks the balance and marks the statement reconciled.

Pulsify connects to Sage X3. We set up the connection for you.

What Pulsify does not do:

- Nothing on a statement is written to Sage X3.
- A person always presses Mark as reconciled.

## Common questions

### Can Sage X3 reconcile a supplier statement?

No built-in statement matching was confirmed. Compare the printed supplier account to the statement. A partner add-on, SynergERP Advanced Remittance, matches statement items.

### Which report lists open supplier invoices?

The Supplier invoice and payment history report has three filters: All, Open or unpaid and With payments.

### How are credit memos matched to invoices?

At accounting validation, the LETAUTCNO parameter decides whether the credit memo and its original invoice match automatically.

### How often should I reconcile statements?

Monthly for your biggest suppliers, before the payment run. Start with the suppliers you pay the most.

## Sources

- https://online-help.sagex3.com/erp/12/en-us/Content/OBJ/ARP_SPAYHIS.htm
- https://communityhub.sage.com/us/sage_x3/f/general-discussion/78088/ap-reconciliation
- https://za-marketplace.sage.com/en-ZA/apps/91403/synergerp-advanced-remittance

Source: https://www.pulsify.tech/supplier-statement-reconciliation-for-sage-x3/ (last checked 2026-10-19)