Google PlayStore 

Overview 

Google PlayStore integration for RevRec is currently in early access. If not already done, contact RevRec Support to join the Early Adopter Program and enable this feature.

RevRec's Google Play Store integration automates revenue recognition for your Google Play Store subscriptions. It syncs detailed subscription transaction data from your Google Play Store's Subscriber report, on a daily basis, and applies the revenue recognition rules based on the subscription's duration. Here are some key differences between Google Play Store's Sales and Finance Reports and RevRec Google Play Store Integration:

Google Play Store's Sales and Finance Reports RevRec Google Play Store Integration
Aggregated, summary app sales data Detailed transaction level data
Monthly update Daily update
Cash Payments focused Out-of-Box Revenue Recognition Solution
Manual process to prepare Journal Entry Automated Journal Entry generation
Need to consolidate with other sales channels (E.g. Google Play Store, direct sale website, etc) One revenue subledger, for all your subscriptions sales

Sync Overview 

It is important to understand the key terms used in RevRec and how it leverages them from the Google Play Store Reports.

Earnings Report Fields RevRec Fields
Transaction Date Order Date and Billing Date, and Service Start Date.
Description Order Number, Subscription ID, Reference Invoice Number, and Invoice Number. Description value is constrained up to the last digit before the ".." for Customer ID.
Amount
(Merchant Currency)
Sales Order amount, billing amount and expense amount, depending on the transaction type
Merchant Currency Customer, Sales Order and Billing currency.
Transaction Type The transaction type "Charge" is utilized for Order creation, "Charge refund" is employed for Credit Note generation, "Google fee" is designated for Expense booking, and "Google fee refund" is employed to decrease Expense associated with a refund.
SKU(Stock Keeping Unit) ID Product Code. User needs to use SKU id for setting up the Google Play Store products in RevRec.

Prerequisites 

Log in to your Google Play Store Connect and retrieve the following details that are essential to connect the two applications:

  • Create a Google service account, Service Account ID and Create Key. Click the link here to learn how to set up a service account.
  • Create a user under the service account with Finance role.
  • Identify your Google Cloud Storage Bucket ID.

Connecting Google Play Store and RevRec 

You can connect your RevRec site with your Google Play Store data, along with other subscription sales channels such as Chargebee.

Note
  • Only users with Admin role access can set up the Google Play Store integration.
  • A single RevRec site can only connect to one Google Play Store.

Follow these steps to integrate RevRec with your Play Store account:

  1. After logging in to your RevRec site, navigate to the right environment with which you are integrating Google PlayStore.
  2. Click Sync > Connect to other systems icon.
  3. On the Connect your data pop-up, select Sales > Google PlayStore.
  4. On the Configure Play Store screen, specify the following details:
    • Google service account user, private key and Google Cloud Storage Bucket ID.
    • Click Connect.
  5. Setup Products using the SKU Id and define the duration of service.
  6. Configure accounting rules.Define the accounting rules for revenue recognition of your mobile subscription products, and expense policy for the Google platform fee charge (e.g. point-in-time or pro-rata).
  7. Enable multi currency and configure your home currency.

RevRec will automatically import Play Store's Subscriber data on a daily basis to generate sales order, invoice, customer and product, with a new field Channel set to Google Play Store.

Revenue and Expense Recognition 

Revenue and direct sale cost recognition for mobile subscriptions follow the same ASC 606/IFRS 15 guidelines. In Google earnings report, there is one row per transaction and the amount collected from the customer or deduction made by Google is reflected in the column 'Amount (Merchant Currency)' against transaction type. Let's look at some example:

Description Transaction Date Transaction Type Amount
(Merchant Currency)
GPA.1103xxxx-61646..0 01-Oct-22 Charge $120
GPA.1103-2129-8818-61646..0 01-Oct-22 Google fee -$12

Revenue 

RevRec recognizes the amount in merchant currency where the transaction type is Charge or Charge Refund as the total transaction price for revenue recognition. This is the gross revenue before the deduction of Google Platform fee.

Note

You need to set up products using the SKU ID contained in the Earnings report as product code, and define the product duration/term information in the RevRec.

With Example 1 above, RevRec recognizes $120 as total transaction price for revenue recognition. If the product's term is 12 months, $12 revenue will be recognized in each month based on a ratable method.

Google Platform Fee 

RevRec recognizes the amount in merchant currency where transaction type is 'Google Fee' as the transaction cost for expense recognition. With Example 1 above, RevRec recognizes $12 Google Platform fee as an expense. The net amount that the merchant can receive will be $120-$12 = $108.

Note

Since the amount reported in the earnings report is always exclusive of the tax, the same calculation will be used for tax exclusive or inclusive countries.

You can set the accounting policy for the platform fee in RevRec's expense policy configuration, to apply either point-in-time or pro-rata recognition method.

Other Use Cases 

New Subscription 

Each subscription transaction record on the earning report is treated as a sales order. RevRec establishes the total transaction price based on the merchant currency amount, before the deduction of Google Platform fee. Additionally, the system matches the SKU ID to the preset product information in RevRec, and applies the configured accounting rules for the product for revenue and expense recognition.

Invoice 

Each transaction on the Subscriber report reflects payment activities on the play Store, and is processed as an invoice.

Renewal 

RevRec treats renewal as a new order based on the new subscription start date. Renewal will have the same Subscriber ID.

Discount 

Discount is considered to be reflected directly in the merchant amount. As a result, there is no separate discount line item in invoice or sales order.

Refund and Cancel 

Play Store allows for full or partial refund when a user cancels a subscription, in which case RevRec reverses the cumulative or partial revenue recognized and adjust the deferred revenue.

Refunds are processed as credit notes in RevRec. The refunds are recognized based on the subscription product's service start and end date, with the cumulative impact recognized in the current open period.

Refunds on subscriptions also include the reversal of platform charge. RevRec will recognize the platform charge associated with the refunds and recognize the cumulative impact for the charge in the current open period.

Change of Plan 

Play Store allows users to change a subscription plan with following treatment during the active period of a subscription:

  1. IMMEDIATE_WITH_TIME_PRORATION ( the default treatment in Google Play)
  2. IMMEDIATE_AND_CHARGE_PRORATED_PRICE
  3. IMMEDIATE_WITHOUT_PRORATION
  4. DEFERRED
  5. IMMEDIATE_AND_CHARGE_FULL_PRICE

RevRec currently supports treatments 1, 3, and 4. Treatment 2, 5 are not supported due to the unavailability of the service end date. A partial refund is issued for the remaining period of the existing plan and a new charge is issued for the new plan. RevRec will stop revenue recognition for the existing subscription and recognize revenue for the new plan starting at the time of plan change.

Was this article helpful?
Loading…