# Supplier statement reconciliation for Dynamics 365 Finance

Dynamics 365 Finance 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 Dynamics 365 Finance does on its own

Dynamics 365 Finance has no supplier statement reconciliation in the Microsoft help. The Vendor open transactions report lists open items at a date, and a person compares it with the supplier's statement by hand.

## What you need in Dynamics 365 Finance

- Accounts payable role

## Setting it up in Dynamics 365 Finance

Where to find it: Accounts payable > Reports > Vendor aging

1. Run the Vendor open transactions report for the statement date.
2. Compare each invoice and credit with the supplier statement.
3. Enter missing invoices through an invoice journal or pending vendor invoice.
4. Enter missing credit notes as invoices with a credit amount.
5. Run Vendor aging to check the total agrees.

## Good to know in Dynamics 365 Finance

- Vendor open transactions lists invoice number, voucher number, amounts and payment due date.
- Vendor aging can age by Transaction date, Due date or Document date.
- Aging period definitions are kept on their own page and can be reused.

## How to do it in Dynamics 365 Finance

### How to run the Vendor aging report in Dynamics 365 Finance

In Dynamics 365 Finance, run the Vendor aging 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-dynamics-365-finance/

## 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 Dynamics 365 Finance.
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 Dynamics 365 Finance. We set up the connection for you.

What Pulsify does not do:

- Nothing on a statement is written to Dynamics 365 Finance.
- A person always presses Mark as reconciled.

## Common questions

### Can Finance reconcile a supplier statement?

No reconciliation tool was found. Use the Vendor open transactions report and compare it by hand, or use a partner tool outside Finance.

### Can I age the vendor balance by due date?

Yes. Run Vendor aging and pick Transaction date, Due date or Document date, then set intervals or an aging period definition and the Balance as of date.

### 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/finance/accounts-payable/vendor-invoices-overview

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