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

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 ageing 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 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 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 will give a different view of the vendor ledger than the Aged Accounts Payable report. Note: If you haven't set up accounting periods, Business Central won't know which fiscal year to use. It will either show the year-to-date from the most recent fiscal year or just select the 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 Ageing 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 extra credit memos will be shown as an un-applied amount. 317
Vendor - List Shows basic information for vendors, such as the vendor posting group, discount and payment information, priority level and 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

See also

Analysing Financial Statements in Microsoft Excel
Work with Dimensions
Managing Fixed Assets
Local Functionality Overview
Accountant Experiences in Dynamics 365 Business Central

Find free e-learning modules for Business Central here