Accounts Payable Reports and Analytics in Business Central
To help you manage your accounts payable in Business Central, standard reports and analytics are built in. It moves beyond traditional reporting constraints to help you efficiently design various types of reports.
Reports
--- author: edupont04
ms.topic: include ms.date: 04/01/2021 ms.author: edupont
The following table describes some of the key reports in accounts payable reporting.
| Report | Description | Id |
|--|--|--|
| Aged Accounts Payable |Shows overdue balances for vendors in overdue time intervals. The overdue amounts can be shown by due date, posting date, or by document date as needed. 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 have not allowed direct posting to the accounts used in the vendor posting groups' payables account, this report is a specification of the amounts you find 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 have been closed by the ending date but have been un-applied (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 you have payments later than the ending date that have been applied to invoices in within the date range, the invoices will appear in the report as they have not been closed as by the ending date. | 321 |
| Vendor - Trial Balance | Shows the net changes for vendors for the period specified in the date filter as well as the net change year-to-date for the fiscal year corresponding to the period selected. The report is grouped by vendor posting groups and will give a different view of the vendor ledger than the Aged Accounts Payable report. Note: If you haven't set up any accounting period, the system will not know what fiscal year to use and will either show year-to-date from the most recent fiscal year defined or just select the period, which may or may not be from 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 |---
author: edupont04
ms.topic: include ms.date: 07/13/2021 ms.author: edupont
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 as set overdue per date.|305|
| Payments on Hold| Shows vendor ledger entries where the On Hold field is not 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 will show payment discounts incorrectly when multiple credit memos have been used in an application. In this case, the payment discount for the additional credit memos will be shown as an un-applied amount.| 317 |
| Vendor - List|Shows various kinds of basic information for vendors, such as vendor posting group, discount and payment information, priority level and the vendor's default currency, and the vendor's current balance (in LCY). The report can be used, for example, to maintain the information in the Vendor table.|301|
See also
Analyzing Financial Statements in Microsoft Excel
Work with Dimensions
Managing Fixed Assets
Local Functionality Overview
Accountant Experiences in Dynamics 365 Business Central
--- author: edupont04