Looker Finance Explore Update — GL Actual Ending Balance (New)

We are excited to share that the Looker Finance Explore has been updated with a new suite of fields for calculating cumulative ending balances as of a specific accounting period. These fields are now live and available for use.

What’s New

The new GL Actual Ending Balance measure (found under Metrics > Balance As Of) returns the cumulative sum of GL Actuals for balance sheet accounts — Assets, Liabilities, and Equity — as of a period you specify. Expense and revenue accounts are intentionally excluded from this measure; the existing GL Actual Amount and Project Cost Amount measures remain the appropriate fields for those.

Two new parameters control the calculation, both found under Dimensions - Dates > Specialty:

Balance As Of Accounting Period — enter the period you want balances through in YYYY-MM format. For example, 2025-05 returns the cumulative balance through the end of May. The default is set to 2025-06.

Balance Include Period 13 Adjustments — only relevant for June periods. Set to Yes (default) to include both P12 and P13 and return the final adjusted June balance, or No to return the pre-adjustment P12-only balance. Prior year Period 13 entries are always included regardless of this setting as they are necessary for an accurate cumulative balance.

To Get Started:

1. Open the Finance Explore and add the GL Actual Ending Balance measure
2. Set Balance As Of Accounting Period to your target period
3. For June periods, use the Balance Include Period 13 Adjustments toggle to get your preferred view
4. Add any COA dimensions to slice the balance as needed

We hope these new fields provide greater flexibility and insight for your financial reporting and analysis. 

Sincerely,