Sage 100

This is a regular Excel spreadsheet without macros that creates a Trial Balance report from G/L data for 12 months of the year. The Power Query connection behind each worksheet is viewable in Excel's Power query by selecting a cell in any of the 12 reports and using the Query ribbon's Edit button.

 Each of the queries of the form Period-XX has one step called "fnTrialBalance_Result" that it an invocation of the query function "fnTrialBalance' that can be found above the "Period-01" query in the left side bar. The "fnTrialBalance" query function can only be seen using the Advanced Editor on the Home ribbon.

To facilitate an easier understanding of the steps involved, as the raw form in the Advanced Editor isn't a good learning tool, check out the query "fnTrialBalance-01 Reveal". This query is a non-function version of the "fnTrialBalance" query function and, when selected in the left-side bar, the steps can be viewed in the right-side bar (assuming the View ribbon "Query Settings" button is selected - which usually is).