Explore for Billing: Financial Insights content (Early Access)

In the base configuration, Explore for Billing includes the following financial insights datasets, models, answers, and liveboards, with curated data from your InsuranceSuite applications streamed in near real-time.

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.

Benefits

Explore for Billing Financial Insights helps you analyze accounts receivable (AR) aging, AR premium activity, cash balancing, and commissions. You can monitor billing performance, spot collection issues earlier, and support better cash management and producer performance decisions.

The solution also includes transaction-level datasets in Data Studio for detailed transaction research and troubleshooting.

Lineage of Explore for Billing Financial Insights content

The following diagram shows the lineage. Click to enlarge the image.

Multiple solution fact datasets in Data Studio are published to Explore and become tables, then models, answers, and liveboards.

Guidewire created Explore for Billing Financial Insights solution datasets that live in Data Studio. They include central fact datasets with several related dimension datasets. The datasets are derived from the Billing Insurance Data Model (IDM) by applying predefined queries onto the IDM dynamically generated datasets. You can find details about the solution datasets in the Data Studio Data Dictionary. (See the Data Studio guide.)
The solution datasets are then published to Explore and used to create models. There's one Explore model for each fact dataset.
The models are the data source for answers and liveboards.

Liveboards for billing financial insights


Liveboard Name	Key Contents	Data source (Explore model)
Billing Analysis (AR Balances/Aging)	Analysis of aging receivables by month-end, producer, state, number of days past due, account, and other attributes. The number of days past due is calculated at the moment you open the liveboard. Also includes monthly ending balances for written and advanced premium.	GW - Billing AR Aging: Download data dictionary GW - Billing AR Balancing: Download data dictionary
Billing Analysis Cash Balancing	Analysis of various cash amounts by month-end, product, producer, and state.	GW - Cash Balancing: Download data dictionary
Calendar Year Billing Analysis - Commissions	Analysis of commission amounts by month-end, product, producer, underwriting company, and state.	GW - Billing Commissions - Calendar Year: Download data dictionary

Answers for billing financial insights

The following answers report various billing financial totals. They aren’t pinned to a liveboard, but are separate pivot table reports that you can view and filter. To learn more about filtering, see Explore pivot tables.


Answer Name	Key Contents
Invoice Aging Summary	Includes invoice counts and amounts by the number of days past due (30, 60, and 90): Invoice Count Invoice Amount Invoice Count Over 30 Invoice Amount Over 30 Invoice Count Over 60 Invoice Amount Over 60 Invoice Count Over 90 Invoice Amount Over 90 There are subtotals for each underwriting company, line of business, jurisdiction state, and account. The number of days past due is calculated at the moment you open the answer.
AR Premium Balancing Summary	Includes receivable totals by billing method and accounting period: Advance Premium Beginning Balance Advance Premium New Advance Premium Reclass Advance Premium Cash Credit Advance Premium Write-off Advance Premium Ending Balance Written Premium Beginning Balance Written Premium New Written Premium Reclass Written Premium Cash Credit Written Premium Write-off Written Premium Ending Balance There are subtotals for each underwriting company, product, and jurisdiction state.
Cash Activity	Includes cash totals within a specified date range: Cash Amount Unapplied Amount There are subtotals for each underwriting company, product code, and risk jurisdiction.
Disbursement Activity	Includes disbursement totals within a specified date range: Cash Amount Unapplied Amount There are subtotals for each underwriting company, product code, and risk jurisdiction.

Models for billing financial insights

For more details, see the linked pages and the Data dictionaries for Explore models.


Model Name	Key Contents	Source solution dataset from Data Studio
GW - Billing AR Aging	Includes monthly snapshots of accounts receivable aging balances, at the grain of the invoice. Calculates the number of days that an invoice is past due and buckets it into over 30, 60, or 90 days. Helps analysts create visualizations of aging balances by producer, account, line of business, and other attributes.	efr_fact_bill_accountsreceivable_aging
GW - Billing AR Balancing	Includes monthly snapshots of various accounts receivable amounts for policies, such as advance premium new, written premium reclass, and total premium write-off. The snapshots are aggregates over a period of one month, of transaction amounts from the charge context. Helps analysts visualize trends and totals of accounts receivable activities. They can analyze amounts by policy, charge pattern subtype, product, underwriting company, and other attributes.	efr_fact_bill_receivable_balance
GW - Cash Balancing	Includes monthly aggregates of billing transactions that affect cash or cash held in a pending state (suspense, unapplied, or collateral). Helps analysts create visualizations of cash amounts by month, transaction subtype, product, producer, and other attributes.	efr_fact_cash_balancing
GW - Billing Commissions - Calendar Year	Includes monthly snapshots of commissions payable to producers, at the grain of the policy. The snapshots are aggregates of transaction amounts from the producer context. Helps analysts visualize reserved, earned, and paid out commission amounts. They can analyze amounts by producer name, producer code, product, and other attributes.	efr_fact_commissions_calendaryear

Detailed transaction datasets

The following datasets contain detailed transaction-level views of accounts payable (AR) and accounts receivable (AP) transactions. The structure is a star schema: The fact dataset is related to several dimension datasets which provide attributes to describe transactions.


Dataset Name	Key Contents
efr_fact_receivable_transaction	Includes all accounts receivable transactions from the charge context. Each row represents one charge transaction event at the transaction level. For example, initial charges (premium, fees) payments (from customers or producers) write-offs, and billed charges. Includes derived balance measures that can be used for general ledger reconciliation.
efr_fact_payable_transaction	Includes all transactions from the producer context. Each row represents one producer transaction event at the transaction level. For example, payment, commission earning, reserve movement, advance, write-off, or adjustment. Includes derived balance measures that can be used for general ledger reconciliation.

The datasets are available in Data Studio. There are no base-configuration Explore models, liveboards, or answers for these datasets. However, you can use them as a starting point for detailed transaction research and troubleshooting. Use the datasets to:

Query in Data Studio to view sample data.
Curate and publish from Data Studio to query the data in external applications.
Curate and publish from Data Studio to extend Explore liveboards with detailed, transaction-level analysis.

It's important to curate and filter the base-configuration datasets before publishing them from Data Studio. The large number of transaction rows in the datasets contribute to usage limits and decreased performance in Explore. Consider which subset of transactions you want to use in Explore, then create your own dataset with filters on dates or attributes.