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 Settlement Summary Template
The Settlement Summary Template provides a simplified display of
details by each order using a Microsoft Excel Pivot Table. The
pivot table is built from the settlement text 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.0 report or create a new copy each
time.
Download the Settlement Report Flat File V2.0
Go to
Reports > Payments > Past
Settlements.
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
PC Users: from the Data toolbar select "Refresh"
Mac Users: from the Data pull-down menu select "Refresh
Data"
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.
PC Users: Click "Import."
Mac Users: Click "Get Data."
The range of cells will populate with the data from the flat
file text document.
Refresh the Summary Report tab
Click the "Summary Report" tab
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"
The pivot table will load the data from the Settlement Data
tab.
Sign in to use the tool and get personalized help (desktop browser required).
Sign In