Authentication

Connecting your Google Play account with Leapfin is very simple, and overall should not take more than 5-10 minutes. There are three keys that Leapfin needs to programmatically pull your financial reports on your behalf: Service Account Email, Service Account Private Key, and Google Cloud Storage Bucket ID. Please follow the instructions below step-by-step:

Your Google Play financial reports are stored in a Google Cloud Storage Bucket. To grant Leapfin access to this bucket, please perform the detailed guide below:

Step 1: Create a Service Account for Leapfin on Google Developers Console

Navigate to: https://console.developers.google.com and sign in to the Google Developers Console. If you already have a project, use the drop-down to select a project. If you don't have a project listed, please click on Create Project.

Navigate to IAM & Admin > Service Accounts > Create Service Account

Fill in the account details, copy the Service Account Email and select Create.

Click on Create Key, a JSON file containing the Private Key for Service Account would be downloaded. Copy this file to a safe location.

Sample file contents:

{
  "type": "service_account",
  "project_id": "strong-radius-250406",
  "private_key_id": "75c3e381bfcd1d986e9e232efcc1676508bbfeaa",
  "private_key": "-----BEGIN PRIVATE KEY-----\nMIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQCjc+6LRJ6w++Zw\nZ6Sd9xPrYthoTAE8vVEGqRarcyn5W5Gh+5KbYBFGH/fqAI5OuuIDGZ2HpqmIA7h\neoUTamgKULYddnJcIx9uQfi+Vxx/IZJm0QwLc8LZ5PSPOoU6hMOfibV7FBgYJrbd\nx21d29AYUk0DoAoRGZmR8hMpGUDmmm7pnZJDW08BafJyVmbC6E0iXMKCyP9cVEKw\ndDIBaqOmHsQh9FRfpKZi4wBBuEGBWrApFkGW/J53u1iDHPOhOWBrOkS2Fxg1hvpK\namOroIjruWC8E2mJuRSv2p9g+9eoIal+/kcSxEC02PFQ6pZvBf2E70rQE7PRqctdXcsTx71+VYhbXfwP19Ee3gAeci\nydaLKCtmbboXGmJ60W4b4e/eVrYnIyOMQ72bjFXHkERsllzUtKmaHr5DsQKBgHNZ\nqyo3E2XXBBJvdRGB69RSVqbvE4aU4KsU0O/iWr2zkzvn5a2RbUfVsMRQ0as5JfjU\n1CMFohme98lIx2BPXn/Ea7d8CWMhXrzPSFUgcz3Uth4cPyBraJ85qrwpKY92B70z\nYHPZ1uaG0XTViQmDatxw7UuE76TKdBDCarYJ3lSxAoGAAUTwjNBDA2XAu44f+lX2\nzwkmI2MeL+al9ryeFnkTCGXdozlFjjsKZy9k77uet0OSlMq9Y+py7TLNHPRIcJ0m\n4fTR/mgXiJJt7h/7jMiEZkZWMzcs1PmDmWX2UyY6L351BT9a9WtnS/fPqXz3HPKd\ns2JaYEg4iX3Ru1m/70W1Qj8=\n-----END PRIVATE KEY-----\n",
  "client_email": "[email protected]m",
  "client_id": "118049637170674308455",
  "auth_uri": "https://accounts.google.com/o/oauth2/auth",
  "token_uri": "https://oauth2.googleapis.com/token",
  "auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
  "client_x509_cert_url":     "https://www.googleapis.com/robot/v1/metadata/x509/leapfin-grant-access%40strong-radius-250406.iam.gserviceaccount.com"
}

Step 2: Add the Service Account on your Play Console

Navigate to https://play.google.com/apps/publish/ and click on Settings

Click on Users & Permissions and then Invite New User

Paste the Service Account Email that we created in Step 1. Assign this account with Finance role.

📘

Updated on November 2022

If you have a new version of Google Dashboard, here are the permissions you need to enable for Leapfin.

📘

After applying these changes, it takes 24 hours for the changes to take effect. Leapfin data syncs are tested after 24 hrs of these permissions being added.

Step 3: Find your Google Cloud Storage Bucket ID

You can copy your Google Cloud Storage URI by clicking the Copy Cloud Storage URI button next to the corresponding section header on the Download reports pages.

Your Cloud Storage URI begins with pubsite_prod_rev (e.g., pubsite_prod_rev_01234567890987654321).

For more detail, follow the instruction from this Google Support Documentation to locate your Google Cloud Storage Bucket ID

Step 4: Enter the necessary information into Leapfin

Please login Leapfin, and navigate to the Integrations page: https://leapfin.com/integrations

Click on Connect next to “Google Play”, the below secure form will appear where you can enter the three pieces of information Leapfin needs:

That's it! You're done!

Data Sources

Google play store offers two financial reports:

Earnings Reports is generated near the beginning of next month.

Estimated Sales Reports is generated daily by adding all transactions that were CHARGED or REFUNDED recently to the current month's file. It can take several days for all new transactions to appear.

After user connects to Google Play Store with their credentials, Leapfin then downloads those two reports from the Google Play Store periodically from your Google Cloud Storage Bucket, where the financial reports are stored.

Earnings Reports

Earnings Reports is generated near the beginning of next month and contains detailed reports of transactions of your apps.

To understand what the Earnings Report entails, you can read more about it here.

Leapfin imports each row from the Earnings Report as googleplay-earnings-transaction record. If the Transaction Type is "Charge", or "Charge refund", or "Google fee", or "Google fee refund", Description is a unique identifier for those record. Otherwise, if Transaction Type is "Tax", or "Tax refund", Description is NOT unique for those records.

sample data

{
    "Sku Id": "com.company.editor.value.1",
    "Hardware": "u5y901te",
    "Tax Type": "Arkansas IRRF Withholding Tax",
    "Product id": "com.company.editor",
    "Buyer State": "TX",
    "Description": "TXA.2322-XXXX-xxxx-XXXX",
    "Refund Type": "",
    "Product Type": "1",
    "Buyer Country": "US",
    "Product Title": "Arkansa Credit",
    "Buyer Currency": "USD",
    "Transaction Date": "Nov 14, 2017",
    "Transaction Time": "3:22:34 AM PST",
    "Transaction Type": "Tax",
    "Buyer Postal Code": "66045143",
    "Merchant Currency": "USD",
    "Amount (Buyer Currency)": "-0.30",
    "Currency Conversion Rate": "1.000000",
    "Amount (Merchant Currency)": "-0.30"
}

Estimated Sales Report

Estimated Sales report is generated daily by adding all transactions that were CHARGED or REFUNDED recently to the current month's file. It can take several days for all new transactions to appear.

To understand what the Estimated Sales Report entails, you can read more about it here.

Leapfin imports each row from the Estimated Sales Report as googleplay-sales-transaction record. Order Number is a unique identifier for records with Financial Status as "Charged", or "Refunded".

sample data

{
    "SKU ID": "com.company.editor.something.1",
    "Item Price": "7.20",
    "Product ID": "com.companny.editor",
    "Device Model": "iPhone13",
    "Order Number": "GPA.3219-9292-xxxx-xxxxx",
    "Product Type": "mobile",
    "City of Buyer": "",
    "Product Title": "Company Credit",
    "Charged Amount": "9.00",
    "State of Buyer": "",
    "Taxes Collected": "1.80",
    "Country of Buyer": "USA",
    "Currency of Sale": "USD",
    "Financial Status": "Charged",
    "Order Charged Date": "2020-03-01",
    "Postal Code of Buyer": "",
    "Order Charged Timestamp": "1583021187"
}

Mapping Logics

googleplay-earnings-transaction

Leapfin imports each row on Google Play's Earnings Transaction Report as an googleplay-earnings-transaction record.

When mapping data, Leapfin creates Invoices, LineItems, Refunds, Tax, Payment, and Settlement records based on the transaction type of the record.

Creating an Invoice

Leapfin creates an invoice when googleplay-earnings-transaction.Transaction Type is "Charge"

Creating a LineItem

Leapfin creates a lineitem object when googleplay-earnings-transaction.Transaction Type is "Charge"

Creating a Refund

Leapfin creates a refund object when googleplay-earnings-transaction.Transaction Type is "Charge Refund"

Creating a Tax

Leapfin creates a tax object when googleplay-earnings-transaction.Transaction Type is "Tax"

🚧

NOTE

There are multiple tax records for each line-item. These records have both positive and negative amounts (see example here). It is unclear whether these taxes are for "Charge" or "Google fee", or whether they should be addition or subtraction from "Charge" or "Google fee" amounts.

Therefore, following assumptions are made:

• All taxes are associated with the "Charge"
• "Charge" amount + sum of ("Tax" amount) gives the tax inclusive totalAmount of invoice

Creating a Tax Refund

Leapfin creates a refund object when googleplay-earnings-transaction.Transaction Type is "Tax Refund"

Creating a Payment

Leapfin creates a payment record when googleplay-earnings-transaction.Transaction Type is "Charge"

Creating a Fee

Leapfin creates a fee record when googleplay-earnings-transaction.Transaction Type is "Google fee"

Creating a Fee Refund

Leapfin creates a refund object when googleplay-earnings-transaction.Transaction Type is "Google fee refund"

Creating a Payout

Leapfin creates a settlement record if we are using googleplay-earnings-transaction to map data

googleplay-sales-transaction

Leapfin imports each row on Google Play's Sales Transaction Report as an googleplay-sales-transaction record.

When mapping data, Leapfin creates Invoices, LineItems, Refunds, Tax, and Payment records based on the Financial Status of the record.

Creating an Invoice

Leapfin creates an invoice when googleplay-sales-transaction.Financial Status is "Charged"

Creating a lineitem

Leapfin creates a lineitem record when googleplay-sales-transaction.Financial Status is "Charged"

Creating a Refund

Leapfin creates a refund record when googleplay-sales-transaction.Financial Status is "Refund"

Creating a Tax

Leapfin creates a tax record when googleplay-sales-transaction.Financial Status is "Charged"

Creating a Tax Refund

Leapfin creates a tax refund record when googleplay-sales-transaction.Financial Status is "Refund"

Creating a Payment

Leapfin creates a payment record when googleplay-sales-transaction.Financial Status is "Charge"