Model: GW - Cash Balancing (Early Access)

The GW - Cash Balancing model includes monthly aggregates of billing transactions that affect cash or cash held in a pending state (suspense, unapplied, or collateral). Analysts can use it to create visualizations of cash amounts by month, transaction subtype, product, producer, 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 - Cash Balancing model is built from a fact table and multiple dimension tables, as shown in the diagram.

Fact:
  • efr_fact_cash_balancing
Dimensions:
  • efr_dim_bill_suspensepayment
  • efr_dim_bill_unappliedfund
  • efr_dim_bill_disbursement
  • efr_dim_bill_basemoneyreceived
  • efr_dim_bill_account
  • efr_dim_bill_producer
  • efr_dim_bill_policyperiod
  • efr_dim_bill_policy

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.

Line item aggregates

The model includes monthly aggregates for various line item amounts, such as cash, suspense, and unapplied.

Cash balancing formulas

The model includes formulas that summarize how cash moves through the billing system each month, including cash paid out, cash received, and the resulting net cash position. These formulas also capture producer-related cash flows, suspense activity, and the proportion of cash that remains unapplied.

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.

Related information