Supplier statement reconciliation for Dynamics 365 Finance

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.

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. More about supplier statement reconciliation in Pulsify.

What Pulsify does not do

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

More help

• Supplier statement reconciliation for Kinetic
• Supplier statement reconciliation for IFS Cloud
• Supplier statement reconciliation for CloudSuite Industrial
• Invoice approvals for Dynamics 365 Finance
• Invoice capture for Dynamics 365 Finance
• Supplier credit notes for Dynamics 365 Finance
• All Dynamics 365 Finance how-to guides

Sources

Last checked 2026-10-19.

• learn.microsoft.com/en-us/dynamics365/finance/accounts-payable/vendor-invoices-overview