Model: GW - Billing AR Aging (Early Access)

The GW - Billing AR Aging model includes monthly snapshots of accounts receivable aging balances, at the grain of the invoice. It calculates the number of days that an invoice is past due and buckets it into over 30, 60, or 90 days. Analysts can use the model to create visualizations of aging balances by producer, account, line of business, and other attributes.

Note: This functionality is available only to customers who have signed up for our Early Access (EA) program. Talk to your Guidewire representative to learn more about our eligibility criteria for EA programs. Note that EA capabilities may or may not become part of our future offerings.

Source tables

The GW - Billing AR Aging model is built from a fact table and multiple dimension tables, as shown in the diagram.

Fact:

efr_fact_bill_accountsreceivable_aging

Dimensions:

efr_dim_bill_producer
efr_dim_bill_policyinfo
efr_dim_bill_account
efr_dim_bill_month

From each table, Guidewire selected specific columns to include in the model. They’re typical columns used in reporting and analysis. For details about each column in the model, see the Data dictionaries for Explore models.

Invoice-level amounts

The model includes the following amounts for each invoice:

Month-to-date (MTD) billed
MTD paid
MTD written off
Ending balance

Aging days formula

The model calculates the number of days each invoice is past due, in a formula called Aging Days. The calculation is supported by other formulas that convert dates into a useable data type. For example, the snapshot date, transaction period, and payoff period.

Note: Formulas are created on the model in Explore. They aren’t part of the source tables in Explore or Data Studio. Each formula performs a calculation and the result is an additional column in the model. For a list of all formula columns and their expressions, see the Data dictionaries for Explore models.

Invoice aggregate formulas

Several of the model columns aggregate the invoice-level data. The Invoice Amount formulas calculate monthly remaining amounts due on invoices. The Invoice Count formulas count the number of invoices. The aggregates include:

All invoices
Invoices past due by over 30, 60, or 90 days
All past due invoices

Snapshot parameter

The Snapshot parameter is created on the model in Explore. Use it in liveboards and searches to select the month for which you want to view aging details. Input a year and month in the format YYYYMM. For example, 202408 for August 2024.