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

[Asirra Suguitan]

Dear Colleagues,

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,

*Asirra Suguitan*
Associate Vice Chancellor and Campus Controller
Business & Financial Services
http://bfs.ucr.edu/
[image: ucr-logo-email]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://scotmail.ucr.edu/pipermail/msoadm/attachments/20260610/6dc616fb/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 12023 bytes
Desc: not available
URL: <https://scotmail.ucr.edu/pipermail/msoadm/attachments/20260610/6dc616fb/attachment-0001.png>