专为 Android 应用开发者打造的 Google Play 财务结算分析工具。快速汇总每月销售额、平台手续费、退款、税费和最终实际入账金额，并导出 Excel。
绝对安全！所有解析均在当前会话中加密进行，绝不会向第三方透漏。
支持从 Google Play Console 导出的标准月度收益 ZIP 报告文件。
是的，可以免费导出排版整洁的 Excel (.xlsx) 报表。
一旦开始收到 Google 的收入，很快就会出现“为什么后台金额和银行到账对不上？”的疑问。了解收入如何确认和支付，每月对账就会轻松得多。
AdSense 后台实时显示的金额是预估收入。月份结束后，Google 会剔除无效流量并审核数据，最终收入通常在次月月初计入余额。因此预估金额和最终金额可能略有差异。
10 月 1–31 日 产生预估收入(后台)
11 月上旬 10 月收入确认 → 计入余额
11 月 21 日前后 余额 ≥ 门槛时发出付款
数日后 款项到达银行AdSense 预估收入与最终收入的区别、每月付款时间表与付款门槛、付款被暂停的常见原因，以及外币收入如何记账。阅读指南 →
想要自己的版本？把下面的任务提示词粘贴到 AI 聊天中，或将技能文件保存到 AI 编程助手。其中包含我们开发此工具时整理的功能、边界情况和测试用例。
提示词和技能以英文提供，AI 工具在任何语言环境下都能很好地理解。
直接粘贴到 Claude、ChatGPT、Gemini 等 AI 聊天中即可。
You are an experienced full-stack web developer. Build a web tool called "Google Play 收益报告" that meets the requirements below.
## Goal
Build a web tool that signs in with Google, reads Google Play earnings reports from Cloud Storage and exports monthly totals of sales, fees, refunds, taxes and payouts to Excel.
## Core features
- Google OAuth sign-in with the devstorage.read_only scope
- List the Play Console report bucket (gs://pubsite_prod_...)
- Download and parse yearly earnings ZIP/CSV files
- Totals by transaction type, month and currency
- Export to Excel (.xlsx)
## Inputs
- Google sign-in
- Bucket URI and year
## Outputs
- Monthly settlement summary
- Excel file
## Edge cases and handling rules
- Explain missing bucket permissions
- Handle CSV encoding and delimiter differences
- Aggregate refunds (negative rows) and tax rows separately
- Stream large files
## Implementation requirements
- Requires a server-side implementation. Request read-only scopes and use report files only temporarily during the session.
- State the purpose of data use on the OAuth consent screen and in the privacy policy.
- Make the UI responsive and easy to use on mobile; label every input and keep everything keyboard accessible.
- Add a Copy button for results and show clear, friendly error messages for invalid input.
- Keep the core logic in functions separate from the UI so it can be unit-tested.
## Definition of done (test cases)
- Monthly totals from a sample CSV match a manual calculation
- Refunds reduce sales
- Clear error for a bucket without access
First outline your implementation plan in at most five lines, then write the complete code, and finally explain how to check the test cases above.在 Claude Code 等 AI 编程助手中保存为 .claude/skills/build-google-play-earning/SKILL.md，以后开发或修改此工具时可重复使用。
---
name: build-google-play-earning
description: Use when building or changing a Google Play 收益报告 tool. Build a web tool that signs in with Google, reads Google Play earnings reports from Cloud Storage and exports monthly totals of sales, fees, refunds, taxes and payouts to Excel.
---
# Build: Google Play 收益报告
## Goal
Build a web tool that signs in with Google, reads Google Play earnings reports from Cloud Storage and exports monthly totals of sales, fees, refunds, taxes and payouts to Excel.
## Workflow
1. Review the required features, inputs and outputs below and ask about anything missing first.
2. Implement the core logic as pure functions separate from the UI.
3. Check the logic against the test cases in the verification list.
4. Build a responsive UI with an input form, a result area and a Copy button.
5. Reproduce each edge case listed under Rules and refine the error messages.
## Core features
- Google OAuth sign-in with the devstorage.read_only scope
- List the Play Console report bucket (gs://pubsite_prod_...)
- Download and parse yearly earnings ZIP/CSV files
- Totals by transaction type, month and currency
- Export to Excel (.xlsx)
## Inputs
- Google sign-in
- Bucket URI and year
## Outputs
- Monthly settlement summary
- Excel file
## Rules
- Explain missing bucket permissions
- Handle CSV encoding and delimiter differences
- Aggregate refunds (negative rows) and tax rows separately
- Stream large files
- Requires a server-side implementation. Request read-only scopes and use report files only temporarily during the session.
- State the purpose of data use on the OAuth consent screen and in the privacy policy.
## Verification
- [ ] Monthly totals from a sample CSV match a manual calculation
- [ ] Refunds reduce sales
- [ ] Clear error for a bucket without access