# Supplier statement reconciliation for Business Central

Business Central 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 Business Central does on its own

Business Central has no supplier statement reconciliation. Payables reports such as Vendor - Balance to Date and the vendor ledger entries show what you owe, and a person compares them with the supplier's statement.

## What you need in Business Central

- Finance permissions

## Setting it up in Business Central

Where to find it: Vendor - Balance to Date (search for it)

1. Run Vendor - Balance to Date for the statement date.
2. Or open Vendor Ledger Entries for the vendor and filter by date.
3. Compare each line with the supplier statement.
4. Post any missing invoices or credit memos.
5. Apply payments to the open invoices so the balance agrees.

## Good to know in Business Central

- Vendor - Detail Trial Balance lists all ledger entries in a date filter.
- Payments on Hold lists vendor ledger entries where the On Hold field is not blank.
- Aged Accounts Payable Excel (report ID 4403) buckets entries by due date.

## How to do it in Business Central

### How to run the Aged Accounts Payable report in Business Central

In Business Central, run the Aged Accounts Payable 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-business-central/

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

What Pulsify does not do:

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

## Common questions

### Can Business Central match a supplier statement automatically?

Not automatically. Run Vendor - Balance to Date or look at vendor ledger entries and compare them with the statement by hand.

### Which report shows what I owe by due date?

Aged Accounts Payable Excel, report ID 4403. Set Aged as of and Period length. The older report 322 is marked legacy in the report list.

### 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://learn.microsoft.com/en-us/dynamics365/business-central/payables-reports

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