Accounts payable reports and analytics
Business Central has built-in reports and analytics that can help you manage your accounts payable. The tools go beyond traditional reporting constraints, and make it easy to design various types of reports.
Reports
The following table describes some key reports for accounts payable. The reports are designed to help different roles in the finance departments make informed decisions.
| To... | Open in Business Central (CTRL+select) | Learn more | ID |
|---|---|---|---|
| Maintain information about the vendor. | Vendor - List | About Vendor - List | 301 |
| Analyse and reconcile vendor balances at the end of a period. | Vendor - Detail Trial Balance | About Vendor - Detail Trial Balance | 304 |
| This is a legacy report for aged accounts payable. We recommend that you use Aged Accounts Payables report instead. | Vendor - Summary Ageing | About Vendor - Summary Ageing | 305 |
| Analyse outstanding purchase orders to understand expected purchase volume. Forecast your monthly expected costs and expenses. | Vendor - Order Summary | About Vendor - Order Summary | 307 |
| Analyse outstanding purchase orders and understand expected purchase volume from vendors. Compare overall outstanding receipts with the expected receipt date and highlight overdue back orders. | Vendor - Order Detail | About Vendor - Order Detail | 308 |
| Analyse the effect of vendors on cash flow, and prioritise vendor payments. | Vendor - Top 10 List | About Vendor - Top 10 List | 311 |
| Track vendor performance and ensure that your company gets the best value for money. | Purchase Statistics | About Purchase Statistics | 312 |
| Analyse item purchases per vendor to manage inventory procurement and improve supply chain processes. Assess the relationship between discounts, cost amounts, and volume of item purchases. | Vendor/Item Purchases | About Vendor/Item Purchases | 313 |
| Check payments before you create payment files and post the journal. | Vendor Pre-Payment Journal | About Vendor Pre-Payment Journal | 317 |
| Get a checklist of all vendor ledger entries where the invoice is in dispute and the On Hold field isn't blank. | Payments on Hold | About Payments on Hold | 319 |
| Track your outstanding payables and manage your vendor relationships. | Vendor - Balance to Date | About Vendor - Balance to Date | 321 |
| Analyse vendor balances at the end of each period. Monitor unpaid invoices, and prioritise payments for overdue accounts. Easily reconcile vendor subledgers against payables accounts in the general ledger, assuming that direct posting is disabled. | Aged Accounts Payable | About Aged Accounts Payable | 322 |
| Analyse the closing balance of vendors at the end of the period and reconcile the vendor subledger against the payables accounts in the general ledger. | Vendor - Trial Balance | About Vendor - Trial Balance | 329 |
Analyse your payment practice
You can use the Payment Practice| page to show how quickly you pay your vendors. You can base the report on a specific period, or by the size of the vendor company in terms of its number of employees. Some countries require this report.
For more information, go to the Payment practices page.
Explore finance reports with Report Explorer
To get an overview of the reports that are available for finance, choose All Reports on your Home page. This action opens the Role Explorer, which is filtered to the features in the Report & Analysis option. Under the Finance heading, choose Explore.
To learn more, go to Finding pages and reports with the role explorer.
See also
Ad hoc analysis on finance data
Financial analytics
Purchasing analytics
Accountant Experiences in Dynamics 365 Business Central