How to combine App Store and Google Play revenue reports

Write the question above your spreadsheet before importing anything. Are you comparing customer spending, developer proceeds, or money paid into your bank account? Give each a separate label.

For an operating view in AppCradle, the relevant sources are Apple’s Sales and Trends reports and Google Play earnings reports. They support monitoring the business, but their combined total should not be presented as a bank payout reconciliation.

• Name the measure explicitly: for example, imported store proceeds.
• Keep a separate worksheet for payouts if that is also part of your workflow.
• Record the source report beside each subtotal so another person can reproduce it.

Choose a complete period and the same set of products on both platforms. Create a small mapping between Apple app and subscription identifiers, Android package names, and your own product names. A renamed app should not accidentally become a second product in your report.

Apple’s downloaded Sales and Trends files are compressed, tab-delimited reports. Extract the file and import it using a tab separator. Preserve identifiers as text when your spreadsheet offers that choice, then keep the original download unchanged for reference.

Use explicit start and end dates, and document the timezone behind each source. Put original amounts and currency codes in separate columns. If your reporting currency differs, keep the converted amount and the conversion method alongside them.

Do not add a USD amount to an EUR amount and label the result revenue. Equally, avoid assuming that a dashboard’s converted amount will match the exchange rate used for a later payout.

Make a list of the dates and reports you expect to see, then compare it with what you imported. A missing report is an unresolved gap. Keep that gap visible instead of filling it with zero.

When replacing a report with a newer download, replace the same source period in your working data rather than appending a second copy. Retain the signs on refunds and adjustments, and check that each source subtotal still reconciles before combining stores.

• The report periods and selected products match.
• Each amount has a known currency and revenue definition.
• Overlapping downloads have not duplicated a period.
• Missing dates and incomplete imports are listed beside the result.

Create a company workspace, add the credentials for each store, and choose the apps you want to track. Import the available history, inspect the import status, and select your company’s reporting currency before comparing the two platforms.

AppCradle refreshes configured store statistics daily and lets you inspect incomplete imports. Store report availability still determines how current the numbers are. Use the store filters to investigate a change, then export the report for your team.