This is what happens in the video
If you post manually in Business Central, your vendor ledger entries can drift out of sync with your general ledger. You can check this with the built-in report “Reconcile Customer and Vendor Accounts,” which compares the balance on your vendor total account in the chart of accounts against the actual vendor ledger entries.
Set the same date filter on both the chart of accounts and the report so the numbers line up. The report shows quantities per vendor posting group, so you can reconcile each vendor total account one to one and spot any differences that need handling.
Why reconcile vendor ledger entries in Business Central
Business Central lets you post manually in many different ways. That flexibility is useful, but it also means your vendor ledger entries can end up not matching what is recorded on your chart of accounts. To make sure everything corresponds correctly, you can reconcile your vendor ledger entries against the relevant accounts.
Finding the vendor total account in the chart of accounts
Start in your chart of accounts and locate your vendor total account. In this example the balance sits at around 1 million. From here you can also set a date filter if you want to see the balance at a specific point in time, for instance the end of last month.
Running the Reconcile Customer and Vendor Accounts report
Business Central includes a report called Reconcile Customer and Vendor Accounts. This is the tool you use to check that your ledger entries match the chart of accounts.
The important thing here is the date filter. The date filter you set in the report should match the date filter you used when viewing the chart of accounts. If the two filters do not align, you are comparing two different points in time and the reconciliation will not make sense.
Reading the reconciliation results
The report reconciles across many different accounts, including your vendor total at the end. You can see the quantities per vendor posting group. If you use several different vendor total accounts in your chart of accounts, you can reconcile each of them directly, one to one.
If there is a difference, the report makes it visible, so you know exactly what you need to handle in your system.
Q&A
Which report reconciles vendor ledger entries in Business Central?
Use the built-in report called “Reconcile Customer and Vendor Accounts.” It compares the balance on your vendor total account in the chart of accounts against your actual vendor ledger entries.
Why should I reconcile my vendor ledger entries?
Because Business Central allows manual posting in many ways, your vendor ledger entries can drift out of sync with your chart of accounts. Reconciling confirms that the entries correspond correctly and reveals any differences you need to handle.
How do I make sure the report shows the right numbers?
Set the same date filter in the report as the one you used in the chart of accounts. If you want to check the balance at the end of last month, apply that date in both places so you are comparing the same point in time.
Can I reconcile multiple vendor total accounts?
Yes. If you use several different vendor total accounts in your chart of accounts, the report lets you reconcile each one directly, one to one, with quantities shown per vendor posting group.