In this video, we’re going to talk about trial balance reports in GP and then look at how you can print similar reports in Business Central.
In my GP system, I’ve printed out the detailed trial balance for a specific period of time and included all accounts. I can easily see balance information as well as detailed transactions that were posted to each account. In addition to the detailed trial balance, I’ve also printed out the historical aged trial balance and receivables, allowing me to easily see aging information for each of my customers and drill into any customers that may have overdue balances that I need to collect on.
Now let’s look at Business Central and how we can view and print similar trial balance reports. To navigate to the trial balance reports for General Ledger, we will select the search icon and enter in trial balance. In the available options to select, you can see we have both the trial balance, which is similar to the summary trial balance in GP, as well as the detailed trial balance.
In the detailed trial balance report options window, I’ve indicated that I’d like a new page per GL account. Also in the filter area we can filter to a specific account or range accounts similar to how you would in GP. Now let’s preview the report and see how the information looks.
Here I can see the balance information as well as the detailed transactions posted to the account. I can scroll through the report and see each account is printed on a new page. Now let’s look at the summary trial balance.
The summary trial balance report has some different options to select from. I have the ability to compare values from last year or if I have configured budgets and Business Central I could compare to the balances that would have been budgeted.
Below I’ve selected to include actual and comparison balances and display the variance as a percentage. I’m also rounding to the nearest dollar for simplicity sake. Again, I can filter to a specific range of accounts as well as entering a date range for the report.
You can see on the summary trial balance how it compares this year’s balance to last year, as well as displaying the variances as a percentage. In addition to previewing the report on the screen, I could also send the report to PDF or Word, or let’s look at what it would look like if it was in Excel. I’ll mark the print to Excel option and preview the report again.
In Excel I can easily perform additional analysis or create different visuals for the data. Next, let’s look at the aging report for customers. In this search field I will type Aged Accounts. In the list you can see both the AP and AR aging reports. If I select the aging report option for AR similar to GP, I can select a date that I want to age the report as of, and if I want to age by transaction date or due date.
I can also select to print the report in detail. If I had migrated my customer class information over as posting groups, I could also filter the report to a specific customer class. Now I can view the aging information for each customer and focus on a specific customer or customers with balances overdue.
And that’s a quick look at trial balance reports in Business Central.