Downloading PayPal transactions
When you're downloading your PayPal report from PayPal, it's really important you download the correct report. This article explains how to do that. You'll first need to sign into your PayPal Business account - once you've done that, you can follow the instructions below to download the report you need.
In this article:
Where you have transactions of multiple different currencies in your PayPal account, you will need to use the alternative PayPal report detailed in the bottom section of this support article.
Downloading PayPal transactions (standard option)
(1) Within your PayPal account, select 'Activity', then select 'All reports'.
(2) Click 'Activity download' on the left-hand side (Important: do NOT select 'Statements').
If it is a personal PayPal account, rather than a business PayPal account, click here to get to the screen in PayPal that you need to download this report.
(3) In the filter bar at the top of the report (see below), select:
• Transaction type - select 'All transactions'
• Date range - select the range required
• Format - select 'CSV'
Then click 'Create Report'.
(4) Once the report has finished generating, click 'Download'.
Once you've downloaded the file, don't edit or resave it, or change the file format from .CSV to .XLS/.XLSX, as it may stop the file uploading properly to ExpensePlus.
(5) Upload the .CSV file to your PayPal Payment Processor Account within ExpensePlus (find out more).
Downloading PayPal transactions (where transactions are in multiple currencies)
(1) Within your PayPal account, on the left-hand side select 'Activity', then select 'All Reports'.
(2) Select the 'Performance' tab, then select 'Financial summary report'.
(3) Select the 'Date range' and 'Currency', then click 'Create Report'.
(4) Do NOT click 'Download report'; instead, select 'View all transactions'.
(5) Then click 'Download report' and select the 'CSV' option.
(6) Then upload this .CSV file to your PayPal Payment Processor Account within ExpensePlus (find out more).
Once you've downloaded the file, don't edit or resave it, or change the file format from .CSV to .XLS/.XLSX, as it may stop the file uploading properly to ExpensePlus.
To better understand the Bank Reconciliation functionality, please watch the module overview video here.