Comparing Trial Balance and Aging Reports between Dynamics SL and Dynamics 365 Business Central

Overview

The video shows where the trial balance reports that Dynamics SL users know can be found in Business Central. It starts with the SL trial balance reports, then opens the matching reports in Business Central and previews the detailed trial balance.

It then covers the summary trial balance with comparison to last year or to budgets, the aged accounts receivable report with its date and customer class options, and the ways to output a report, including export to Excel for further analysis.

Key points

• The detailed trial balance shows balances and the transactions posted to each GL account. You can filter to specific accounts or ranges, and print each account on a new page.
• The Business Central trial balance is similar to the summary trial balance in SL.
• The summary trial balance compares current year values to last year or to budgets. Budget comparison requires budgets to be configured in Business Central.
• The summary trial balance can show variance as a percentage and supports rounding options.
• The aged accounts receivable report lets you choose the date to age the report and age by transaction date or due date. You can filter to customer classes and view overdue balances.
• An aged accounts payable report for vendors is available alongside the AR aging report.
• Reports can be exported to Excel for further analysis and visuals, or sent to PDF or Word.

Features

Quotes

• 0:48 “In the available options to select, you can see how both the trial balance, which is similar to the summary trial balance in SL,”
• 1:38 “I have the ability to compare values from last year or if I have configured budgets in Business Central, I could compare to the”
• 2:29 “If I select the aging report option for AR, similar to SL, I can select a date that I want to age the report”
• 3:09 “In Excel, I can easily perform additional analysis or create different visuals for the data.”