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 Flat File V2.0 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 column. 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 >
Settlement Reports and locate the latest Settlement Report Flat File
V2.0
Click the "Download" button.
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.
Inicia sesión para utilizar la función y obtener asistencia personalizada (se necesita un navegador de escritorio).
Iniciar sesión