This article applies to selling in: United States

Payments Statement View

Policies and Requirements Features and Fees Managing FBA Inventory Business Analytics Resources
The Settlement Summary Template provides a simplified display of details by each order using a Microsoft Excel pivot table. View the Payments Statement View report.

The pivot table is built from the settlement Flat File V2 report. The flat file report displays fee and sale amounts for each order on separate rows. The pivot table enables you to see a summary of all fees and sales for a specific order in one row. Follow these steps to take advantage of the pivot table in the Settlement Summary Template.

Download the Settlement Summary Template.

    Click the link above and save the file to your hard drive or open it with Microsoft Excel and save it. You can reuse the same template each time you download a Settlement Report Flat File V2 report or create a new copy each time.

Download the Settlement Report Flat File V2

  1. Go to Reports > Payments > Past Settlements and locate the latest Settlement Report Flat File V2.
  2. Click the Download Flat File V2 button next to the settlement period you selected. If there is no Download button, click the Request Report button and return to the Past Settlements page in a few minutes.
  3. Save the file to your hard drive.

Refresh the Settlement Data tab

  1. Open the Settlement Summary Template and go to the second tab, "Settlement Data."
  2. Click anywhere within the range of cells that makes up the table
    • PC Users: from the Data toolbar select "Refresh"
    • Mac Users: from the Data pull-down menu select "Refresh Data"
  3. A dialog box will ask you to locate the text file you would like to import. Select the Settlement Report Flat File V2 that you downloaded.
The range of cells will populate with the data from the flat file text document.

Refresh the Summary Report tab

  1. Click the "Summary Report" tab
  2. Click anywhere within the range of cells that makes up the pivot table
    • PC Users: from the Data toolbar select "Refresh"
    • Mac Users: from the Data pull-down menu select "Refresh Data"
  3. The pivot table will load the data from the Settlement Data tab.

Payments Statement View


Sign in to use the tool and get personalized help (desktop browser required). Sign in


Was this article helpful?
Thank you for your feedback
How can we improve this help page? Note: This form doesn’t create a support case. Please specify what you think is wrong with the content itself.
1000
What was helpful?
1000
Thanks again for your help!
Thank you for your feedback. If you have more questions, please Contact Us.

Reach Hundreds of Millions of Customers

Start Selling On Amazon


© 1999-2020, Amazon.com, Inc. or its affiliates