如何将交易收据与可以在iTunes Connect中下载的财务报告相关联? [英] How to correlate transaction receipts to Financial Report which can download in iTunes Connect?

问题描述

是否可以将来自付款对象的收据与财务报告，销售报告或银行对帐单中收到的信息进行关联?

Is there a way to correlate receipts from the payment object to information received in either the financial reports, sales reports or bank statements?

无论验证成功与否，我都会在数据库中记录所有购买信息.当我在iTunes connect中查看财务报告时，发现我又收到了3笔付款.我的问题是我怎么知道谁需要赔偿?

I record all purchase info in my database whatever verifying is success. When I check the financial reports in iTunes connect, I found I have received 3 more payment. My problem is how can I know who need compensated?

Apple的收据包括数量，product_id，transaction_id，purchase_date，original_transaction_id，original_purchase_date，app_item_id，version_external_identifier，bid，bvrs.

Apple's Receipt include quantity, product_id, transaction_id, purchase_date, original_transaction_id, original_purchase_date, app_item_id, version_external_identifier, bid, bvrs.

财务报告包括开始日期，结束日期，UPC，ISRC/ISBN，供应商标识符，数量，合作伙伴份额，扩展的合作伙伴份额，合作伙伴份额货币，销售或退货，Apple标识符，艺术家/表演/开发者/作者，标题标签/工作室/网络/开发人员/发布者，网格，产品类型标识符，ISAN/其他标识符，销售国家/地区，预购标志，促销代码，客户价格，客户币种.

Financial report include Start Date, End Date, UPC, ISRC/ISBN, Vendor Identifier, Quantity, Partner Share, Extended Partner Share, Partner Share Currency, Sales or Return, Apple Identifier, Artist/Show/Developer/Author, Title Label/Studio/Network/Developer/Publisher, Grid, Product Type Identifier, ISAN/Other Identifier, Country Of Sale, Pre-order Flag, Promo Code, Customer Price, Customer Currency.

推荐答案

我有一个(免费)工具可以为Google&亚马逊应用商店，目前正在增加对苹果的支持(2014年6月30日).它使您可以按应用程序或单个应用程序内购买来分摊销售额，而不考虑币种.目前，这对于亚马逊和苹果来说尤其困难.您可以在此处找到代码: https://github.com/eggheadgames/app_earnings .您需要安装Ruby才能运行它.

I have a (free) tool to do this for Google & Amazon app stores, and am currently adding support for Apple (30 June 2014). It allows you to apportion sales by app or individual in-app purchases, regardless of currency. This is currently quite difficult for Amazon and Apple especially. You can find the code here: https://github.com/eggheadgames/app_earnings. You'll need Ruby installed to run it.

2019年11月更新:对于苹果公司，我现在使用付费服务 appfigures.com ，该服务通过应用内购买和应用提供购买信息，并已验证为实际付款押金.我仍然使用自己的Google&工具；亚马逊(因为AppFigures仅与Apple对帐).我尚未通过供应商文件格式调整来使上述存储库保持最新状态，但是如果您在下面或在复制本中进行评论，则无需花费太多时间.

Update Nov 2019: For Apple I now use a paid service, appfigures.com, which provides purchase info by in-app purchase and app, verified back to actual payment deposits. I still use my own tool for Google & Amazon (as AppFigures only reconciles for Apple). I haven't kept the above repo up-to-date with vendor file format adjustments I've made, but if you comment below, or in the repro, it won't take much nudging.

这篇关于如何将交易收据与可以在iTunes Connect中下载的财务报告相关联?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！