Settlement report enables you to view settled or unsettled Sale, Credit, Delayed Capture, and Voice Authorization transactions, and transaction counts and totals. This report is useful for reconciling transactions with bank statements and reports.
Settled means that the processor has transferred the funds into (or out of Credit transactions) your merchant bank account. Current transactions (those with today's date) are not settled until your processor settles them at the daily settlement time. Refer to settlement times for each processor.
Transactions are posted to your merchant bank account 48 to 72 hours (typically) after being approved for settlement. Settlement occurs for all batches submitted within the 24-hour "settlement day". For example, for a particular processor, all transactions from 9 PM Monday night through 9 PM Tuesday night occur during that "day".
To access the Settlement Report page, navigate to Reports -> Standard -> Settlement.
Be sure to enter information for all fields denoted by an asterisk.
PayPal Manager enables you to save commonly used reports as templates. This enables you to run the saved reports without having to specify the settings each time.
If you want to save this report as a template so that you can use it again, enter a name for this report template in the Save Template As field. If this is a template you are editing, then the name specified earlier will appear here.
Specify a Date Range for the report. If you specify a fixed time from the drop-down menu, PayPal Manager adjusts the 24-hour time period to the processor's settlement times. You can match the processor's 24-hour day by selecting a specific custom time.
Specify the Time Zone for your search time.
Select the Host Processor from the drop-down menu for which you want to view the settlement report.
Select a Settlement Status for the transactions. Select from All Transactions, Settled Transactions, or Unsettled Transactions.
Specify the Transaction Type you want to generate a report for. Select from All Settleable, Credits, or Sales and Delayed Captures. (All choices except All Settleable display the total amount settled or unsettled.)
For Transaction Mode, specify whether to display Live or Test transactions. When creating saved templates, the transaction mode is always Live. For scheduled templates, the transaction mode can be Live or Test.
If you want to download your search results, click on the radio box next to Download Report, and select a Format from the drop-down menu. You have the following options:
ASCII Text. Enables you to download the results in ASCII text format. This option does not include any headings, thereby enabling you to import the data to a spreadsheet or to an accounting or reconciliation application.
ASCII Text with Headings. Enables you to download the results in ASCII text format, with headings.
To generate the report, you have the following options:
If you want to use this report as a template only and not generate a report, click Save Template.
If you want to generate a report, click Run Report.
If you have selected to download the report, then you will see a pop-up box that offers you an option to either open or save the result text in the format you selected.