How to Run a Trial Balance and Aged Reports in Dynamics 365 Business Central

In Dynamics 365 Business Central, we can check the AR and AP subledger accounts by using a report called Aged Accounts Receivable/Payable. This report shows the open transactions that currently have not been paid within the system.

Similarly, we can also print the Trial Balance, which helps us to get the total for each GL account currently being used in our system.

How To Do Aged Reports

In order to print aged reports in our Business Central environment, we can take the following steps:

Step 1 – Search “Aged Accounts Receivable” or “Aged Accounts Payable” in Business Central.

Step 2 – A small window will open up, asking us for further information on how we want to preview or print our aged reports.

  • Start by specifying the date we want our report to be aged as of.
  • Make sure the right aging method has been selected. The aging can be calculated based on several different methods, such as “Transaction Date,” “Document Date,” and “Due Date.”
  • Specify the length of the aging period. Example 30D, 60D, etc.
  • In the aging report window, we have the option to filter our report based on various options. Example: Which customer or vendor we want to see in our report, specific payment terms code, posting group etc.

Step 3 – Once the above fields have been filled, then we can either print or preview our aged reports so that we can check our customer and vendor balance.

Below I have screenshots of aged AR and AP reports.

As we can see, these reports show the balance due for each customer/vendor – meaning all those customers/vendors who have open transactions in the subledger. At the bottom, the report shows the total balance for all the open entries.

Aged Accounts Receivable report
Aged Accounts Payable report

How To Do a Trial Balance

Similar to aged reports, we can also print the trial balance in Dynamics 365 Business Central, which helps us to get the total for each GL account currently being used in our system. We can also use various filter options before we preview our reports.

Step 1 – Make sure to select the right columns to display the information for your GL accounts.

For example, the “Actual Changes” and “Actual Balances” column options for the trial balance indicate the net change and balance at date amounts according to a specific time period.

Trial Balance screen with the options for Actual Changes and Actual Balances highlighted

Step 2 – Filter the trial balance based on a variety of different options (if required). For example: we have the option to filter out our trial balance based on different options such as G/L No., G/L account type etc.

Once the filter options are specified or left blank (meaning all GL accounts should be used while printing the report) proceed to the next step.

Step 3 – Make sure that you specify the correct date range in the total date filter for the trial balance. An example has been shown for the date filter in the screenshot below.

Trial Balance screen with the option for Date Filter highlighted

Below I have attached a screenshot of the trial balance.

As we can see below, according to the columns selected, the amounts in each GL account are shown in the report. Here, the “Net Change” column shows the amounts as per the filtered date, and the “Balance” column shows the total amount as of 12/31/2024.

Trial Balance report

For a walkthrough of aged reports and trial balances in Dynamics 365 Business Central (along with some comparisons to the equivalent functionality in Dynamics GP), watch the video below.

If there are other types of reports you need training on, or if you’d like advice on how best to leverage any of the functionalities available in Dynamics 365 Business Central, feel free to contact us. We’d love to help you.

Excel Layouts for Reporting in Dynamics 365 Business Central

In this webinar, learn how to create, manage multiple layouts, and use custom Excel layouts for reporting in Dynamics 365 Business Central.

October 8
9:00 am – 9:30 am PST

Register here

Webinar - Excel Layouts for Reporting

Oct. 8
9:00 am – 9:30 am PST