Edit

Share via

Accounts payable reports and analytics

  • Article

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 of the key reports for accounts payable.

Report Description ID
Aged Accounts Payable Shows overdue balances for vendors in time intervals. The overdue amounts can show by due date, posting date, or by document date. You can choose to show the amounts in local currency (LCY) and print details of the overdue documents. The time intervals can have headings with dates or with number of dates overdue, relative to the specified aging by type.
This report is the main report for reconciling vendor ledger to G/L. Assuming that you don't post directly to the payables account for the vendor posting group, this report is a specification of the amounts in the general ledger.		 322
Vendor - Balance to Date Shows the vendor balance by the ending date of the specified date range. You can choose to display the vendor balance in your local currency (LCY). Select the Include Unapplied Entries field to show entries that were closed by the ending date but were unapplied (opened) at a later date. Select the Show Entries with Zero Balance to show vendors with a balance of zero by the ending date of the date filter. The date filter applies to the detailed vendor ledger entries for the entries in the report. If a payment was made after the ending date, and the payment was applied to invoices within the date range, the report includes the invoice. The report includes the invoice because it wasn't closed before the ending date. 321
Vendor - Trial Balance Shows the net changes for vendors for the period specified in the date filter, and the net change year-to-date for the corresponding fiscal year. The report is grouped by vendor posting groups and gives a different view of the vendor ledger than the Aged Accounts Payable report. Note: If you don't set up accounting periods, Business Central doesn't know which fiscal year to use. It shows the year-to-date from the most recent fiscal year, or just the selected period. The date might not be from the beginning of a year. 329
Vendor - Detail Trial Balance Shows all the vendor ledger entries within the specified date filter. The report shows the vendor's beginning balances relative to the date filter. 304
Purchase Statistics Shows purchase statistics for each vendor. This includes information for five periods, starting on the date that you specify.
The report includes the total purchases, payments, finance charges, and discount information including the payment discounts taken and lost. Statistics are calculated for purchases before the date entered, at three one-month intervals from the date entered, and for a period including all purchases made after the third one-month interval.
This report can also be used in accounts payable as it's easier to do a quick look-up of posted payments, discounts, and other transactions for a given vendor.		 312
Vendor - Summary Aging Legacy report for aged accounts payable. We recommend that you use Aged Accounts Payables report instead. You can choose a period length and a date to use for an overdue per date. 305
Payments on Hold Shows vendor ledger entries where the On Hold field isn't blank. 319
Vendor Pre-Payment Journal Shows the payment journal with payment discount and tolerance information. The report can be used to check payments before creating payment files and posting the journal. Note: The report shows payment discounts incorrectly when multiple credit memos were used in an application. In this case, the payment discounts for the extra credit memos are shown as unapplied amounts. 317
Vendor - List Shows basic information for vendors, such as the vendor posting group, discount and payment information, and priority level. The report also shows the vendor's default currency, and the vendor's current balance (in LCY). Use the report, for example, to maintain information about the vendor. 301

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.

Example of reports on the finance role center

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

Find free e-learning modules for Business Central here