Import PayPal transactions into QuickBooks

You can download PayPal transactions directly into QuickBooks.

1. Log in to your PayPal account.
2. Click the My Account tab, then click the word History (History appears under Request Money).
3. Click the small More link at the right corner of the list, then select Download History.
4. Choose your date range, either Custom Date Range or Last Download to Present from the drop-down list.
5. Choose File Type to Download, file would be QuickBooks (.iif).
6. Click Download History.
7. When prompted to enter the account names, enter the account names exactly as they appear in the Company's chart of accounts:
   • Name of PayPal Account.
   • Name of Other Expenses Account.
     • Be sure that the expense account being used is not a sub-account of another expense account or it will be turned into a bank account when it is imported into QuickBooks.
     • If Accounts Payable balances are being paid by PayPal transactions, you can enter the name of your Accounts Payable account here, but the Vendor names in PayPal must match the names in QuickBooks.
   • Name of Other Income Account.
     • Be sure that the income account being used is not a sub-account of another income account or it will be turned into a bank account when it is imported into QuickBooks.
     • If Accounts Receivable balances are being paid by PayPal transactions, you can enter the name of your Accounts Receivable account here, but the Customer names in PayPal must match the names in QuickBooks.

       Note: You will have to fill in all of the boxes, or you will receive a message from PayPal stating: You must complete the above fields to download your log.

8. Save the iif to the desktop.
9. From the QuickBooks File menu, select Utilities>Import >IIF Files.
10. Select the iif file located on the Desktop.
11. Click Open.

If this solution does not resolve the issue, please review other available QuickBooks support options for additional guidance. You can also read and post messages relating to your issue on the QuickBooks Community forums.