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 |
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. |
Log in to your Google Play Store Connect and retrieve the following details that are essential to connect the two applications:
You can connect your RevRec site with your Google Play Store data, along with other subscription sales channels such as Chargebee.
Follow these steps to integrate RevRec with your Play Store account:
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 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 |
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.
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.
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.
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.
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.
Each transaction on the Subscriber report reflects payment activities on the play Store, and is processed as an invoice.
RevRec treats renewal as a new order based on the new subscription start date. Renewal will have the same Subscriber ID.
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.
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.
Play Store allows users to change a subscription plan with following treatment during the active period of a subscription:
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.