Reading Your Financial Reports

How can I read my Financial Reports?

Your financial reports are presented as groups of transactions, displayed in distinct rows. Each row represents a unique combination of a book, transaction type (product type identifier), price (proceeds/customer price), store, sale or return, and promo (if applicable). Each of the columns reference different aspects of a group of transactions. The columns presented are detailed in the Payments and Financial Reports Guide.

What do the Name and Number combinations in the menu at the top of Payments and Financial Reports represent?

If you see multiple Name and Number combinations in a menu at the top, it indicates that more than one Legal Entity has been associated with the account. Each option for selection corresponds to different Legal Entity that has been reported to and/or paid.

What does the Earned amount represent?

The earned amount represents the proceeds, net of commission, in a given period for the region and revenue type displayed. The amount will agree to the total of the associated financial report.

What is the difference between "Total Owed" and "Proceeds"?

Total Owed displays the estimated amount owed to you in the currency of each reported region and revenue type.

Proceeds is an estimate of the amount due based on converting the amount owed to your bank account currency. The actual payment may differ from the proceeds based on variances in foreign exchange rates as well as reductions for applicable withholding taxes.

What does the Balance Carried Forward amount represent?

Balance Carried Forward is made up of any prior period amounts unpaid (or returned) and carried over to the current period.

What does the Withholding Tax amount represent?

The withholding tax displayed represents amounts withheld by Apple and remitted to tax authorities in accordance with government requirements specific to the territory.

Withholding tax is specific to particular stores where transactions occurred and/or where payments are being distributed by Apple. Withholding taxes can vary based on your location, the completion of any optional tax forms, and the tax treaties entered into by your country.

What does the Input tax amount represent?

Amounts added to your payment to meet your tax requirements in certain countries. For example, Goods and Services Tax (GST) generally applies if you are either based in Australia or based outside of Australia but registered for GST.

Why don't I see any data on the Trends graph of the Summary Page?

If you have not accumulated any sales since your contract started, you won't see any data presented on the Trends graph.

If you have just started selling you won't see any sales or payment data presented until you have financial reports and payments, communicated and presented on the Earnings and Payments pages.

Payments made to you for earnings prior to July 2010 are not presented on the graph.

How can I download Financial Reports?

Financial Reports, which include payment and other financial information, are available in Payments and Financial Reports on iTunes Connect.

Click on Create Report on the top right corner, select All Regions or choose individual region, click Create Reports, and download them once it completes.

What is the best way to open the financial report? I seem to be having technical issues.

If you are using macOS, the reports will be downloaded and opened automatically.

If you are using Microsoft Windows, read the information below:

  1. Click the download button. Your browser will ask you whether it should open or save the report.
  2. Click on the save button when the dialog box appears.
  3. Once you download the file (xxx.txt.gz), double-click and WinZip should extract it. Once extracted you will have a tab-delimited text file (xxx.txt). If your system does not know how to open it, it will present you with a dialog box and the list of applications to choose from. You should select WinZip or anything equivalent to WinZip to extract the file.
  4. Launch Excel.
  5. Go to File > Open then select the file. The Import Wizard will start.
  6. In the Original data type box, select "Delimited" and click Next.
  7. In the Delimiters box, select "Tab" and click Next.
  8. Select the column that has UPC, ISRC, Vendor Identifier by holding the Shift key and clicking the columns. Once selected, in the top right hand box called Column Data Format, select "Text". The label above those three columns will change from General to Text. Click Finish.
  9. Once the file has opened, save the file as an Excel Workbook.

What are the currencies associated with Financial Reports?

There is a single currency for earnings associated with each Financial Report. You can see the currencies associated with each Financial Report on the left side of Payments and Financial Reports.

Do Financial Reports show my free transactions?

No. To obtain free transaction reporting, view daily and weekly reporting in Sales and Trends on iTunes Connect.

What does the Payment Returned amount represent?

When a payment made to you is returned, you will see the return at the top of the page highlighted in red as an amount added to the cumulative balance of what you are owed.

We will attempt to repay this amount along with all other amounts owed during the next monthly payment processing period.

We recommend that you review and make any necessary changes to your bank account information, when needed, to facilitate future payments.

Why am I missing my Financial Report for a particular month?

If nothing was purchased in a region during a month, no corresponding report for that region will be generated for download on iTunes Connect.