# Supplier statement reconciliation for SAP B1

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

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

## What SAP B1 does on its own

There is no statement import. Staff compare the vendor account with the supplier's statement by hand and use Internal Reconciliation to match open items.

## What you need in SAP B1

- Reconciliation authorisation

## Setting it up in SAP B1

Where to find it: Financials > Internal Reconciliation

1. Print or open the vendor account for the period.
2. Compare each line with the supplier's statement.
3. Open Financials > Internal Reconciliation.
4. Select the vendor and the open items.
5. Reconcile the items that belong together.
6. Follow up the lines that do not match.

## Good to know in SAP B1

- Business One has no statement import.
- Internal Reconciliation matches open items inside Business One. It does not read the supplier's file.
- The vendor ref no field helps match statement lines.

## How to do it in SAP B1

### How to run the vendor ageing report in SAP B1

In SAP B1, run the vendor ageing report 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-sap-business-one/

## 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 SAP B1.
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 SAP B1. We set up the connection for you.

What Pulsify does not do:

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

## Common questions

### Can Business One import a supplier statement?

No. Business One has no statement import. The check is done by hand.

### What does Internal Reconciliation do?

It matches open items on the vendor account inside Business One, for example an invoice and a payment.

### Where do I look for unmatched items?

Compare the vendor account with the statement and reconcile the open items.

### 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://help.sap.com/docs/SAP_BUSINESS_ONE/68a2e87fb29941b5bf959a184d9c6727/4509425265e16c32e10000000a114a6b.html

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