Download the guide to scale and streamline your bookkeeping business. See articles customized for your product and join our large community of QuickBooks users. Add the transaction from the PayPal side first to get more detailed information, such as vendor name and address, into QuickBooks.
Recent Posts
You can find the settings by clicking on the three dots on the right of the PayPal tile. At the moment, this integration does not support multiple PayPal integrations at once. An active PayPal account is required to use the PayPal Connector by QuickBooks. If you haven’t already, create a PayPal account before continuing. Simply, go through each transaction, and select Match. This means that this transaction is actually a transfer from the checking (operating) account to the PayPal account.
Once the PayPal account is connected importing paypal transactions into quickbooks online to QBO, you will see “money-in” and “money-out” transactions in the Banking section. Let us take a look at some of the top advantages of automation over manual data entry. At this time, the Connect to PayPal app doesn’t support multi-currency (currency conversion) transactions and reconciliation. Learn how to add and match downloaded banking transactions.
I’ve also shown you how to enter payments made with PayPal in QuickBooks Online correctly. But remember, a lot of business owners use PayPal for much more than just making payments to vendors. Some use PayPal to receive payments from customers.
Our teams are working on providing automation options so you can add your transactions quicker. In these cases, you’ll see the default PayPal Sales line item and the description with the item name from PayPal. This way, the transaction is still imported with details provided. Here’s a video instruction, showing you how to reconcile a bank account. Select the checking (operating) in the Banking section and look for money-out transactions with the same date and amount as the PayPal expenses. If you decide to use your checking (operating) account as the primary payment account, link PayPal with QuickBooks Online.
Enable Auto-Add feature
When importing transactions from PayPal, Connect to PayPal matches the items on a transaction with products/services within QuickBooks. You’ll need a PayPal Business account to sync with QuickBooks Online. Personal PayPal accounts typically don’t offer the necessary features for seamless integration. If you currently have a personal account, you might need to upgrade it to a business account within your PayPal settings. If the QBO – PayPal data sync method using the bank feed doesn’t appeal to you, then read on for another alternative that doesn’t involve using an app. This is how I booked PayPal sales when I was using QuickBooks Desktop (QBD).
(Blowing a kiss your way!) This change is more in line with PayPal’s “Keep It Simple” tag line. Now if the feed could come in by currency account instead of all merged into one feed, I’d be waving my arms and yelling “whoop, Whoop, WHOOP!”. If you decide to use a credit card as the primary payment account, then I have good news; you don’t need to link PayPal with QuickBooks Online. When a credit card is your PayPal’s primary payment account, your PayPal transactions are pulled directly into your credit card’s bank feeds in QBO. When you set up your PayPal account for the first time, you have the option of linking your credit card or your checking account to PayPal as the primary payment account. PayPal will use that primary payment account to withdraw money in order to pay vendors.
- It’s best to keep business and personal finances separate.
- You can find the settings by clicking on the three dots on the right of the PayPal tile.
- Mid-February, the PayPal data sync began importing net of service fees.
- I have asked Quickbooks about it and they said it is a PayPal issue – and am on the phone with PayPal now.
For this example, I chose to setup three rules – one for foreign transactions, another for payments than attracted GST and the last rule for Ontario HST sales. I chose to NOT “automatically add to books” so I can review the transactions before posting. I also left the memo blank so the customer name from the bank feed description will be added to the memo area of the QBO sales receipt. A quick and dirty way to book your PayPal digital sales using the QBO bank feed is to setup a few bank rules in QBO. I personally don’t need the customer’s name in the QBO customer list but I do need it on the sales receipt.
Community
Depending on your selection, PayPal expenses will be recorded differently in QBO. Utilize QuickBooks Online’s bank rules feature to automate the categorization of recurring PayPal transactions. For example, you can create a rule that automatically categorizes all PayPal fees as “Bank Charges” or all sales from a specific platform as “Online Sales.”
I use my business PayPal account to buy items online and to receive payment for consultations. To ensure all entries are accounted for correctly and no duplicates, you can categorize and match them. Once done, you’ll want to reconcile them to ensure your books are correct. Class Tracking is a feature that allows you to categorize your transactions into specific classes, such as departments, locations, or projects.
- You can check on details for each transaction here.
- This makes the workflow for the QBO – PayPal data sync seamless.
- Most QuickBooks Online plans (Simple Start, Essentials, Plus, and Advanced) allow you to connect third-party apps like PayPal.
- If you still have some trepidation, you can try exploring our 30-day free trial.
Categorize PayPal expenses in the Banking section.
I post a reclassifying journal entry to move my foreign sales to a foreign sales income account because the bank feed only defaults to one service item as mentioned above. This is the BEST OPTION if you use PayPal mainly for sales transactions AND use the U.S. version of QBO. The app pulls PayPal data into QBO providing the gross sale amount along with any discounts or PayPal sales fees by customer. It automatically creates a sales receipt in QBO and syncs the transaction details. When your PayPal transactions appear in QuickBooks, you’re ready to review, add, exclude, or undo them.
How to change the synchronization settings for my PayPal and QuickBooks Online connection?
The transaction in this example was a USD purchase. The $35 shows up in the PayPal bank feed as CAD and QBO will not let you change the CAD value. It will let you change the USD value or the currency exchange rate but not the CAD value. Setting the currency rate to 1 is not correct and you shouldn’t do it as the two currencies are not at or near par.
Let’s embark on a journey to integrate your PayPal and QuickBooks Online accounts, unlocking a world of efficiency for your business. This is great if you have a lot of recurring sales but ask yourself if you want to pull in data from individual sales of one time customers. Buying something using PayPal as your payment method is free unless it is transacted in a foreign currency. There will a 2.9% + fixed fee based on currency if payment is funded by a credit card or Visa debit card. There will be a cross-border fee of $2.99 for payments to the U.S. or Europe and $4.99 fee to any other country.
In these cases, you can manually import transaction data. Alright, let’s dive right into getting your PayPal transactions seamlessly integrated into QuickBooks Online! It can feel like a chore to manually enter everything, so this guide will walk you through the various methods step-by-step. Did you know that you can save hours of data entry by syncing your QuickBooks Online with PayPal?
1: Automatic Data Import
This helps you track and analyze your financial performance by class, giving you a more detailed understanding of your business’s financial health. Yes, upon initial setup, you will be asked if you would like to import up to 6 months of historical transactions. Once you determine the starting date, click import, and your transactions will start coming into your QuickBooks account. You can bulk select incoming PayPal transactions to add or match them in QuickBooks, saving you time.