Configuring Pricing for the GL Examples

Use My MATRIXX to create the General Ledger (GL) account types, GL transaction profiles, and so forth, required to recreate the GL examples.

This topic explains how to configure MATRIXX to obtain the GL journal entries shown in both the immediate revenue recognition and consumption-based revenue recognition examples. This topic is useful as a model for configuring your own GL journal entries. These steps reflect the tasks explained in the discussion about configuring pricing to generate GL records.

Figure 1 shows the steps to complete in My MATRIXX to configure GL to produce the journal entries in the examples.
Figure 1. GL Components

1 - Define the Example GL Account Types

Figure 2 shows the GL account types used in both the immediate revenue recognition and consumption-based examples.
Figure 2. Example Account Types
Use My MATRIXX to create these GL account types:
  • Cash Clearing
  • Prepaid Liability
  • Deferred Revenue
  • Revenue
  • Tax

For more information about creating GL account types, see the discussion about creating a GL account type in My MATRIXX Help.

2 - Define the Example GL Transaction Types

Figure 3 shows the GL transaction types used for subscriber actions in both the immediate revenue recognition and consumption-based examples.
Figure 3. Example GL Transaction Types
Use My MATRIXX to create these GL transaction types, identified with these integers:
  • 10 — Top-up
  • 20 — Purchase offer with deferred revenue recognition
  • 21 — Purchase offer with immediate revenue recognition
  • 30 — Tax collection
  • 40 — Revenue recognition upon asset consumption
  • 41 — Immediate revenue recognition upon offer activation

For information about creating GL transaction types, see the discussion about creating a GL transaction type in My MATRIXX Help.

3 - Define the Example GL Transaction Profiles

Use My MATRIXX to create the GL transaction profiles listed in GL Example Transaction Profiles.
Table 1. GL Example Transaction Profiles
Transaction Profile Name Debit Account Credit Account Breakage Account GL Transaction Type IsDeferred Status
Payment Cash Clearing Prepaid Liability 10
Purchase_ConsumptionBased Prepaid Liability Deferred Revenue 20
Purchase_ConsumptionBased Deferred Revenue Revenue Breakage 40 Yes
Purchase_Immediate Prepaid Liability Revenue 21
PreactivePurchase_ImmediateAtActivation Prepaid Liability Deferred Revenue 20
PreactivePurchase_ImmediateAtActivation Deferred Revenue Revenue Breakage 41 Yes
TaxCollection Prepaid Liability Tax 30

For more information about creating GL transaction profiles, see the discussion about creating a GL transaction profile in My MATRIXX Help.

4 - Define the Example GL Transaction Profile Selectors

For a typical list of the GL transaction profiles used by a complete GL double-entry system, see the discussion about balance impact to GL account mapping.

Use My MATRIXX to create these GL transaction profile selectors, listed with their normalizer logic:
  • Define a Selector_Charge selector to use for the Charge balance impact:
    • If EventType=Purchase and ProductOfferExternalId="Data Offer", then select the Purchase_ConsumptionBased transaction profile.
    • If EventType=Purchase, ProductOfferExternalId="Unlimited 1-Day Offer" and HasDeferredRevenueRecognition=1, then select the PreactivePurchase_ImmediateAtActivation transaction profile.
    • If EventType=Purchase, ProductOfferExternalId="Unlimited 1-Day Offer" and HasDeferredRevenueRecognition=0, then select the Purchase_Immediate transaction profile.
  • Define a Selector_Tax GL transaction profile selector to use for the Tax balance impact:
    • Select the TaxCollection transaction profile.
  • Define a Selector_Grant GL transaction profile selector to use for the Grant balance impact type:
    • If EventType=BalanceTopUp, then select the Payment transaction profile.
For more information about creating GL transaction profile selectors, see the discussion about creating a GL transaction profile selector in My MATRIXX Help.

5 - Define the Example GL Transaction Profile Selector Mappings

Use My MATRIXX to create these GL transaction profile selector mappings:
  • Map the charge balance impact type to the Selector_Charge GL transaction profile selector.
  • Map the grant balance impact type to the Selector_Grant GL transaction profile selector.
  • Map the tax balance impact type to the Selector_Tax GL transaction profile selector.
For more information about creating GL transaction profile selector mappings, see the discussion about creating a GL transaction profile selector mapping in My MATRIXX Help.

6 - Define the Example GL Account Selectors

Figure 4 shows the GL account names to be used in the journal entries in the discussion on immediate revenue recognition example (Purchase in Pre-Active State GL Activity table).
Figure 4. GL Account Names to Use

GL account selectors map account types to an account name. In the example use cases, revenues for voice, data, SMS, and MMS, track separately. Because there are multiple accounts, sometimes you must create a normalizer table to select the account. Where necessary, the normalizer table logic used in the account selector is provided.

Use My MATRIXX to create the GL account selectors listed in Example GL Account Selectors. Use the accounts defined in the transaction profiles as the account types.
Table 2. Example GL Account Selectors
Account Selector to Create Account Type Account Selected/Normalizer Table Logic
Selector_Cash CashClearning 10000
Selector_PrepaidLiability PrepaidLiability 20000
Selector_DeferredRevenue DeferredRevenue If ProductOfferExternalId="Data Offer" or "Unlimited 1-Day Offer", then use 30001.
Selector_Revenue Revenue If ProductOfferExternalId="Data Offer" or "Unlimited 1-Day Offer", then use 40001.
Selector_Revenue Breakage 80001
Selector_Tax Tax 90000

For more information about creating GL account selectors, see the discussion about creating a GL account selector in My MATRIXX Help.