Many businesses prefer to receive payments by PayPal and want to easily import these transactions into QBO. In this article we write in details how to import PayPal transactions into QuickBooks Online using Business Importer.
Import PayPal transactions into QuickBooks Online using Business Importer: several steps
Step 1 Download the file from PayPal
Go to your PayPal account and download the file with transactions you want to import into QBO.
You will need to do the following:
- Login to your PayPal account
- Change setting to your file:
Go to My acccount => History => Download History
Choose Customise Download Fields and mark with “V” all fields below.
Click on the Save button.
3. Select the Date range and the type of your file. Choose File type for download – Comma Delimited – Completed Payments.
4. As soon as your report is generated, save it on your computer.
Step 2 Upload your file to start import PayPal transactions into QuickBooks Online
Sign in to Business Importer and connect it to QuickBooks Online.
Go to Import tab. Upload your Excel file or paste the DropBox or Google.Drive link. Click on the Next button.
Step 3 Create mapping – then you can follow the same steps as for Sales Receipts import.
Select Company (you want to import to) and Entity (Sales Receipts), and connect Provider’s labels to Your Labels. Press the Next button.
Note: Use Mapping Helper to map your columns correctly.
Step 4 Review
Review if the information is entered correctly and click on the Next button.
Note: Make changes directly in the preview table if necessary.
Step 5 Import log
Your import is scheduled. Don’t wait until it’s done. Get an e-mail notification.