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.
When you open the Settlement Summary Template in Microsoft Excel, you might encounter a Security Warning indicating that data connections have been disabled. In order to refresh the data, you will need to enable the data connection to the file you just downloaded. To enable the connection, click Options. On the Security Alert – Data Connection dialog box select "Enable this content" and click the "OK" button.
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.
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.
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.
Save the file to your hard drive.
Refresh the Settlement Data tab
Open the Settlement Summary Template and go to the second tab, "Settlement Data."
Click anywhere within the range of cells that makes up the table