How to Import PayPal Transaction in QuickBooks Desktop, Enterprise, Accountants

Intuit has introduced cloud computing-based software to deal with accounting issues and delays. This software is based on the integration framework that helps in facilitating all the internet-based payments and the privacy of your account. 

Manual operations are preferred to import PayPal transactions. There is only one type of payment gateway that supports online cash transactions all over the world and it is named PayPal. PayPal is the web-based payment gateway. It is the electronic option that is opposed to the paper payments like cash or check. 

As we all know that QuickBooks plays a very important role in storing and retrieving data of all types of companies —  small, medium, and entrepreneur. As QuickBooks is also used for accounting purposes in all types of businesses that’s why it is very important to import PayPal transactions in QuickBooks. So, for importing the PayPal transaction in QuickBooks, we have to add it manually. Here, in this article, we will discuss how we can import PayPal transactions in QuickBooks Desktop, Enterprise account.


Get Expert Advice to Fix All Accounting & Bookkeeping Problems

5138226

Features of QuickBooks integration with PayPal

There are many features and benefits of integrating the QuickBooks Desktop with the PayPal account. Some of them are listed below.

  • It is a time saver for the company as in this you have to add all the PayPal exchanges directly in the accounting setup. So it will save your money and time.
  • With the help of QuickBooks desktop and the PayPal integration, the customer can easily pay online from anywhere anytime all over the world with the help of MasterCard, etc.
  • Helps in easy and Quick payments of credit cards.
  • One of the best features of PayPal is security. PayPal provides security to global customers including QuickBooks. It provides a safe and secure monitor flow. It had an inbuilt application to detect and deter fraud etc and it gives the user an instant warning.

You can set QuickBooks with PayPal in just a few clicks. The integration of QuickBooks with PayPal can be done in a few steps.

Importing of the Manually Import PayPal Transaction in QuickBooks

There are three types of methods to import the data in payroll transactions manually.

Method 1: Importing the data from the app center.

Follow the following steps to import data from the app center:

  1. First, open the software and hit the apps button.
  2. Now we have to locate the sync with PayPal.
  3. Now you have to navigate to the settings in the sync PayPal app.
  4. As your above steps are completed, the new window will open in front of you.
  5. Now navigate to the manual import section and hit on the Run button to save the data and run the file.

Method 2: QuickBooks Online

Use the following steps to import data via QuickBooks online:

  1. First, you have to log in to your QuickBooks Account with the help of a user ID and Password.
  2. Navigate to the app tab and click on the, my app option to open it.
  3. Now search for the Sync with PayPal card. 
  4. Click on the settings button which is very important in sync with the PayPal app card,
  5. The new tab will open in front of you.
  6. Now, press the run button to start manual imports.
  7. After clicking on the system you have to select the date range and please set it to the range for the manual importing.
  8. Now if the report is Ok then you have to click on the run command to run the files.

Method 3: Import through PayPal app

Follow the following steps to import data with the help of pay pal app:

  • Navigate to the left menu and click on the Apps tab.
  • Now search for the option connect to PayPal.
  • Choose the option to get the app now.
  • Now, look for the case if the file is to ship.
  • Click on the install button to run the command.
  • Select Allow button to command.
  • Now you have to enter the id and the password of your account which is linked with the payroll.
  • Hit the next button to move forward.
  • Sign into your payroll account by using the id and password of the account.
  • Now hit the personal pay bank account option.
  • Track your transaction and click on the next button.
  • Set the date from which you want to start the recording of the importing data.
  • Hit the done button and come out of the screen.

List of the transaction which can’t be imported

Following are the list of the transaction which cannot be suffered.

  • Pending
  • Removed
  • Canceled
  • Partially refund
  • Paid
  • Refunded
  • Canceled 
  • Canceled transfer.
  • Withdrawal of the funds from the bank.

Import PayPal transactions in QuickBooks Desktop

The PayPal transaction allows you to keep track, of the orders tally, bank support, and the transaction on your Desktop. In order to execute the advance and the PayPal transaction you have to follow the following steps:

  1. It had the inbuilt feature that it can choose the app and search for the PayPal connection.
  2. Check for the file from QuickBooks that you want to integrate.
  3. Select the install button and wait for a while before the installation will be completed.
  4. Decide to whom you want to give the authority of performing the task.
  5. Navigate to the email option and then enter the registered email id and password.
  6. Sign in to your PayPal account and agree to all the data synchronization.
  7. Hit the return to intuit and select PayPal bank.
  8. Click on the next button to save the data and for the conversation on the business rate.
  9. Now click on the next button and you can choose the date for the transaction.
  10. Once you are done with the above steps now click an ok button to save all the changes.

The setting of QuickBooks in order to import from the PayPal

Following are the steps to import the data from QuickBooks to PayPal:

  • First, you have to create a new bank account.
  • Give the name of the PayPal account to the new account that you create earlier.
  • Now create the expense account which is named PayPal fees.
  • Create the income account which is named PayPal sales.
Import the data from QuickBooks to PayPal

Steps to use the .IIF file

The activities which are done are to add PayPal account balance as well as subtract funds from the accounts. Following are the steps to use the .IIF file.

  • First, you have to log in to your payroll account with the help of a login ID and Password.
  • Navigate to the account tab and then click history.
  •  Click on the download history and then set the range of the data.
  • Navigate to the file type option and click on the QuickBooks .iif file.
  • Hit the history to download the file.
  • Enter the name of the account.
  • Enter the name of the PayPal account.
  • Name the other expenses account.
    • Be ensure that the expense account is not the sub-account of all the expense accounts.
    • Add the name of the balances related to pay accounts must be entered in PayPal but if you enter the name of the vendor is enter then it must be entered in QuickBooks.
  • Other types of the income account name
    • Be ensure that the income account is not the subaccount of any other income account because if it is deposited in QuickBooks then it is converted to the bank account.
    • In the case of a PayPal transaction, you can enter the name of the account here but the name of the customer in PayPal is entre in the QuickBooks.
  • After completing the above procedure you have to save your file as a .iif file on your desktop.
  • Navigate to the QuickBooks file menu and then select the utilities from the list of menus.
  • In utilities hit the import button and then select the IIf files.
  • Now locate the IIF file on your system where you store it.
  • Hit the open button to mail it

Importing the PayPal transaction in QuickBooks self-employed

One of the methods of importing the transaction is self-employed. If we select both methods then there are chances of duplicity. Following are the steps to import the PayPal transaction in QuickBooks self-employed.

  • The word currently means that the data is imported in QuickBooks self-employed.
  • Choose the symbol for the profile.
  • Now hit the import button to import the data.
  • Now follow the onscreen steps to import the data.
  • Once all the above steps are done, now you have to hit the Ok button to close it.

Importing of PayPal transactions in QuickBooks with the help of CSV file.

In case you want to enter the data manually but don’t want to use the above method in that case you need to export your PayPal history with the CSV file. It indicates that the transaction will not import.

In case you don’t want to import data and upgrade it manually then you have to follow the following steps to import PayPal transactions in QuickBooks with the help of a CSV file.

  • First, you have to log in to your PayPal account with the help of credentials that is by using your registered login ID and Password.
  • Navigate to the account tab and select history from the list of options.
  • Now go to the history tab and download the history of the transaction.
  • Once you are done with the above step, so now from the drop-down menu of history, you have to select the date range.
  • The range of the date is to be selected as the last date to the present date.
  • Now you have to select the type of file and from the drop-down menu, you have to select all the activities.
  • Once you are done with the above all then just click on the downloaded file.

FAQ


1. How can I import missing transactions into QuickBooks?

To import missing transactions into QuickBooks you have to follow the following steps:

1. First, you have to go to the accounting menu.
2. From the banking drop-down select the chart o accounts.
3. Now navigate to the uncategorized expense account.
4. Once you are done with the above step now hit the run button to run the report.
5. Now you have to look for the missing number in the transaction.
6. If you found any un match then just move them to the correct account.

2. What to do if you are not able to find the downloaded transaction in QuickBooks Online?

Following are the procedural steps to find the downloaded transaction in QuickBooks Online:

1. First, you have to get the latest transaction. In case you are not able to see the
2. Transaction then you have to download the latest one by yourself.
3. Navigate to the banking menu and then hit the account option in that.
4. Click on the account tab and review your account history.
5. Now check for the uncategorized account.

3. What are IIF files in QuickBooks?

IIF stands for Intuit Interchange Format. It is the ASCII text, tab-separated value type file which is used by QuickBooks to import, export list, or the transaction. Due to these types of files, it is easy to transfer the data to and from different platforms to manage the company records in QuickBooks. It is very helpful in importing and exporting data.

This article covers what is very important at the time of the transaction in the company. 

If you encounter an issue while working on any transaction in QuickBooks. So, you just go ahead and contact us. We are there to assist you or help you to accomplish the task with utmost ease. Simply, call us toll-free at…… 

Get Expert Advice to Fix All Accounting & Bookkeeping Problems

5138226
Phone

+18665400865