1) Log into your PayPal account and download a statement in CSV format.
2) Open the CSV file and delete any rows that don’t contain transactions with “Completed”, “Cleared”, “Refunded”, “Partially Refunded” or “Reversed” status in the Status column.
3) Save the CSV file.
4) In your Xero company, go to “Accounting” tab and select “Bank Accounts”.
5) Select your PayPal account on the dashboard, click “Manage Account” on the right, and select“Import a Statement”.
6) Click “Browse” and locate your CSV file.Click“Import”.
7) Now you will need to assign (map) your statement data as shown below:
- “Date” to “Transaction Date”
- “Name” to “Payee”
- “Gross” to “Transaction Amount”
- “Transaction ID” to “Reference”.
Leave other lines Unassigned.
8) Click “Save”, then click “OK”.
Your gross PayPal sales are now imported to Xero. If you are having trouble with Xero recognizing your CSV file format, try to re-save the file and import again.
To properly report your PayPal sales, you will also need to import PayPal fees. For our step-by-step guide on importing PayPal fees, click here for Part 2 of this blog.