Accounts Receivable Reports and Analytics in Business Central
To help you manage your accounts receivable 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 receivable reporting.
| Report | Description | Id |
|---|---|---|
| Aged Accounts Receivables | Shows the amount outstanding with customers broken down into time intervals for the overdue time. The report also displays the part of the customers' balance that is not due and can be shown with or without document details for each customer. This report is the main report for reconciling customer ledger to G/L. Assuming you have not allowed direct posting to the accounts used in the customer posting groups' receivables account, this report is a specification of the amounts you find in G/L. | 120 |
| Customer Statement | Generates a customer statement for a specified time interval. It's usually sent to the customers to give them an overview of outstanding amounts and also as a reminder to pay any overdue amounts. You can choose to show the overdue amounts in a separate section. You can include an ageing band similar to the one used in the Aged Receivables report. For the ageing band, you typically set 30D, which means 30 days intervals such as30, 60, 90, and 90+ days overdue, from the ending date, or 1M+CM, which will be the current month in a separate interval and then monthly intervals for the preceding months. Note: In the customer list, this report also has a separate action, Scheduled Statements. This option does not filter to the customer you have selected. It's the same report but used when you want to send statement to all/more customers. You can filter the report so that it shows only entries that are still open for the customer. To apply the filter when you're setting up the report, in the Statement Style field, choose Open Items. | 1316 |
| Customer - Balance to Date | Shows the open customer ledger entries until the ending date. This report shows similar content as the customer statement but with no indication if the entry is overdue. Note: The date filter will be applied to the detailed customer ledger entries. This means that 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 per the ending date. | 121 |
| Customer - Trial Balance | Shows the net changes for customers 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 customer posting groups and will give a different view of the customer ledger than the Aged Account Receivables 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. | 129 |
| Customer - Detail Trial Balance | Shows all the customer ledger entries within the specified date filter. This report is generally used to check that all entries for a specific customer are accounted for, or other internal checks on customer ledgers. | 104 |
| Customer - Payment Receipt | Creates a payment receipt for each customer ledger entry of type Payment. If the payment has been applied to invoices, the invoices will be specified; otherwise, it will just state the payment amount as unapplied. This report is used to send to customers that want documentation for receipt of payment. | 211 |
| Reconcile Customer and Vendor Accounts | Shows the G/L entries resulting from posting customer and vendor entries split per G/L account and posting groups. This report is used for reconciling the balances on customer and vendor ledgers to general ledger balances. | 33 |
| Customer - Summary Ageing Simp. | This is a legacy version of an accounts receivables ageing report. We recommend you use the Aged Accounts Receivables report instead. | 109 |
| Sales Statistics | Shows amounts for sales, profit, invoice discount, and payment discount in LCY, and the profit percentage for each customer. The costs and profits are given as both the original and adjusted amounts. The original costs and profits are those values that were calculated at the time of posting, and the adjusted costs and profits reflect changes to the original costs of the items in the sales. The cost adjustment amount shown in the report is the difference between the original cost and the adjusted cost. The figures are divided into three periods. You can select the length of the period, starting on a selected date. There are also columns for amounts before and after the three periods. Use the report to analyse earnings from an individual customer and earnings trends, for example. In the US, Canada, and Mexico, this report is not available. Instead, use the Customer Sales Statistics (10047) report. This report can also be used in accounts receivable as it's easier to do a quick look-up of posted payments, discounts, and sales for a given customer. |
112 |
| Customer List | Shows various kinds of basic information for customers, such as customer posting group, discount group, finance charge and payment information, salesperson, the customer's default currency and credit limit in your local currency (LCY), and the customer's current balance (in LCY). The report can be used, for example, to maintain the information in the Customer table. | 101 |
See also
Analysing Financial Statements in Microsoft Excel
Work with Dimensions
Managing Fixed Assets
Local Functionality Overview
Accountant Experiences in Dynamics 365 Business Central
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for