Before importing your PayPal file in the .csv format into QuickBooks, the following two steps must be completed:
NB: the steps described below relate to a personal PayPal account.
Step 1: Download transactions from PayPal
- Sign in to your PayPal account.
- Select Home in the upper left then enter the start and end period.
- Select the small down arrow next to Reports and select Export activity.
- On the Activity download page, start to create a report.
- Customize the Report type then the Period again and select the Format TAB for tabulation.
- Select the blue Create report button.
- You will receive your file to be downloaded by email but it is also available on this same page in the Activity reports table.
- Select download and retrieve your file in the bottom left of your screen in .txt format.
Step 2: Review your file
- Open your file in .txt format.
- Select Edit then Select all.
- Select Edit again then select Copy.
- Open a new Microsoft Excel workbook then paste the data from your .txt format file into it.
- Review the data that you want to import into your QuickBooks account.
- Save the Excel workbook in .csv format. No additional modification is needed for you to be able to import your file as it is.
- Import it into QuickBooks.
Step 3: Import your PayPal file into QuickBooks
- Open your QuickBooks account.
- Go to Ma compta, select Opérations, then select Opérations bancaires (Accès direct).
- Select Upload transactions manually at the bottom of your page if you have not yet added a bank account in QuickBooks.
- Otherwise, select the small down arrow next to the Update button and select File upload.
- Select the file to be uploaded or select to Browse your hard disk.
- Retrieve it and select Next in the bottom right.
- On the next page, select +Add to create the account into which you are going to dump your PayPal transactions, preferably, select Banking and not Cash.
- If this is not the first time that you are importing your PayPal data, select the account that you have already created and select Next in the bottom right.
- We recommend that you check the First row in file is a header row box.
- Select the date format that matches your file.
- For the Description field, select the matching term from the file.
- For the field: Amount, ensure you have the same title in your file.
- In the original document, i.e. your file in .csv format, the amounts appear in a single column => select 1 Column.
- In the original document, the amounts are positioned over two columns (Debit-Credit) => select 2 Column.
- Une fois de plus, vérifiez bien les opérations avant de cliquer sur Importer en bas à droite. Décochez ensuite les opérations que vous ne souhaitez pas importer dans QuickBooks, puis cliquez sur Suivant. Confirmez sur le message suivant.
Félicitations ! Le fichier bancaire a bien été importé dans QuickBooks..