How To Import PayPal Transactions into QuickBooks

How to Setting Up QuickBooks to Import from PayPal in a Simple Way? 

The Preparation for the .iif import: 

In QuickBooks, make another Bank account named?PayPal Account? 

Make an Expense account named?PayPal Fees? 

Make an Income account named?PayPal Sales? 

How to Utilize the .iif File in PayPal Transactions? 

PayPal action incorporates the adds to and deducts resources from your PayPal account balance. Customer portions increase your equilibrium and PayPal charges decay your equilibrium. Exactly when you import the movement using the .iif, the extensions in your equilibrium are recorded into a solitary compensation record, and lessens in your equilibrium are recorded in a solitary business record. 

During the import cycle, QuickBooks will endeavor to arrange with customer names being imported with existing customer names in QuickBooks. In case a match isn't found, the customer name will be added to the Other Names List. 

Instructions to Download Your .iif from PayPal in QuickBooks 

Sign in to your PayPal account. 

Go to the My Account tab and select the History 

Pick Download History. 

Pick a date range. 

Under File Types for Download, pick a QuickBooks record (.iif). 

Tap on the Download History. 

At the point when the screen is shown to enter account names, enter them unequivocally as they appear in your Company's framework of records: Name of PayPal Account and Name of Other Expenses Account. 

Be sure that the business record being used is everything except a sub-record of one more business record or it will be changed into a monetary equilibrium when it is brought into QuickBooks. 

If Accounts Payable equilibrium is being paid by PayPal trades, you can enter the name of your Accounts Payable record here, in any case, the Vendor names in PayPal should facilitate with the names in QuickBooks. 

Name of other Income Account. 

Be sure that the installment account being used is not a sub-record of one more compensation record or it will be changed into a monetary equilibrium when it is brought into QuickBooks. 

On the off chance that the Accounts Receivable equilibrium is being paid by PayPal trades, you can enter the name of your Accounts Receivable record here, yet the Customer names in PayPal should organize with the names in QuickBooks. 

Save the .iif to the workspace. 

Under the QuickBooks File menu, you need to pick Utilities, click on the Import and go to IIF Files. 

Pick the iif report arranged on the Desktop. 

Tap on the Open. 

At the point when this is done, you should have almost or the aggregate of your trades brought into QuickBooks. 

Just "wrapped up" trades are imported. 

PayPal trades with one of the going with circumstances with not be imported: 

Discounted 

Forthcoming 

Paid 

Midway Refunded 

Eliminated 

Dropped 

Moreover, any Transaction of the going with Types will not be imported: 

Dropped Fee 

Discount 

Pull out Funds to a Bank Account 

Add Funds from a Bank Account 

Dropped Transfer 

Instructions to Utilizing the CSV File 

In case you are enthused about physically entering the trades that didn't import you ought to convey your PayPal history into a CSV archive. You would then have the option to sort the report to show you the trades that didn't import. 

Sign in to your PayPal account. 

Tap on the My Account tab, by then, click the word History 

Pick Download History. 

Pick your date range, either Custom Date Range or Last Download to Present beginning from the drop list. 

Pick File Types for Download, the record would be Comma Delimited? All Activity 

Tap on the Download History. 

To a great extent the size of the trade history report doesn't download expeditiously anyway, PayPal will email you when your log? (trade history report) is ready for download. 

Right, when you open the CSV archive you will see different segments. The two that you will sort by are the Status and the Type fragments. 

First sort by Status. Whatever was not Completed will not import and ought to be entered actually. 

Next sort the Completed trades by Type since a couple of these didn't import as of late referred to. 

If it is an excess of endeavor to enter all of these trades truly, you can summarize your passage by adding the whole of the bank trades into one total. Any trades having to do with your costs like Cancelled Fee can be added into one entire and booked to the PayPal Fees Account. Any trades having to do with your Customer bargains like Refunds can be added into one sum and booked to the PayPal Sales Account. 

All trades you should discover in QuickBooks and you can start to oblige. You can get every one of the subtleties of your record balance beginning at a particular point just from PayPal.