Thank you! I am a volunteer treasurer for a non-profit agency. I have ZERO training in accounting. I have learned Quickbooks through the school of hard knocks. You, sir, are the BEST teacher I have found when it comes to tutorials about using Quickbooks. I love how you highlight the area of the screen you are referring to. I love how you speak clearly and simply. I love how empowered I feel right now. You have gained a new subscriber!!!!
Hi Hector! Thank you so much for your content, you’re so good at explaining. What if when you link PayPal, and the client had already deposited money from PayPal into the checking account, which is linked so already added to QBO? How do you not double deposit? I ended up deleting the original link and starting with a new transaction date
Hi Hector and everyone! Wondering if there is a best case approach for the following (seemingly very common) scenario: You send payments using PayPal, pulling the funds from a bank account also linked to QB, as opposed to using your PayPal balance. The transaction will show on both "accounts". I thought it would make sense to be able to match them, so you can reconcile both accounts, however when speaking with a QB support rep, they told me you can "only match transactions under the same bank account", thus making the option impossible, to match your PayPal account transaction, with the Bank transaction, even though they are the same. If you were to categorize both, the transaction would be duplicated, which is obviously a problem. The rep suggested I "exclude" categorizing the transactions from either the bank, or the PayPal account... It just doesn't seem right to me... Thoughts?
@@preciousmoyyoNo workaround unfortunately. Strangely some transactions I can match, but general rule of thumb is I exclude one of the two… Doesn’t seem correct but I hope there will be a fix for this soon.
At 5:40 I notice your Sales Receipt shows "Deposit To" field directed to "Undeposited Funds". My system is automatically set up this way as well. The problem is all my Paypal Income seems "trapped there" in my reviewed transactions and when I create a Customer Transaction History. While in my regular bank account deposit transactions I can see my funds posted in the appropriate bank. How do I get my Paypal Sales Receipts to end up in "PayPal Bank". We are a small nonprofit and much of our income comes from automatic monthly Paypal Sales that we designate as donations. We appreciate any advice you can provide.
@@leighbrett I gave up. I haven't touched it. I ended up disconnecting my Paypal and was looking for a new accountant too. If you have a solution that would be awesome. The end of the year will be here soon, and I will need to get a whole year's worth of transactions posted to do our year end reports.
René T I’m trying out saasant to do my data catch up will ,et you know how it goes but . Side note if you are manually posting sales receipts to undeposited funds then when you got to bank deposit to select the sales receipt make sure that window has deposit to paypal and not checking account PayPal should be set up as a bank
Thank you Hector! I have been using your recommended CSV to QBO addon and the entries are different in the journal. I have some testing to do to figure it out. GOOD INFO! You are helpful to many!
First of all, thank you for your wonderful content and for trying to help with Paypal. It's such a nightmare as far as bookkeeping for a client goes....I constantly struggle with this! I do have a question though, hopefully you can answer: So if I accept the payment as a sales receipt, how do I go in and adjust for adding the sales tax and delivery fees? Should I just accept as a deposit and go in and adjust it from there. QBO doesn't give the option to go in and split the transaction if I do that on the normal bank feed screen. I appreciate any and all advise. Trying to finish up a 2021 nightmare! LOL!
I have a question but first I must say you are incredible and explain things so well. Thank You. I use Paypal for my sales but all money is swept into my bank at the end of each day. If I connect Paypal and create a rule for all Paypal transactions to me set as Deposit or Sales Receipt, how do I handle my connected bank account which shows all my Paypal sweeps as deposits? How do I handle the bank reconciliation for deposits if I am already recording the Paypal transactions as Sales. I hope this makes sense. I am getting confused and don't want to make double entries for money received.
Great video and very eye opening. One of the struggles I have with my clients is the mixing of personal with business related expenses in PayPal. It’s difficult to wean them off commingling funds. One of the most frustrating things is that when I copy and paste the PayPal URL from the transaction memo line to view the PayPal details you need to login to PayPal and as far as I know PayPal doesn’t not offer third-party login capability for us accountants to log into a clients PayPal account to be self serving.
thanks, Hector! I finally got my brain around this. Question: I am helping out a friend and he has categorized a bunch of transactions into the wrong category in PayPal. (I assume he has reconciled them) I want to move it to a new category as income. Can I do this simply and/or is there a video I can watch? Much appreciated. Gracias!
How do you match the item sold in Paypal to the Products & Services item in QBO so everything is categorized to the correct income account? We have 15-20 products and can't have them all go to one income account "Paypal Sales" or another account that you can edit in the Bank settings. The Square app in QBO allows you to map/match Square items to QBO products for easy recording. The way it looks now, we have to manually edit each sales receipt to add the correct QBO product
Wow, this is an extremely helpful video. I learned a lot. One follow-up question: what is the reasoning behind whether a PP transaction (or any) is categorized as a sales receipt or a deposit? Are there merits to one over the other?
I am learning a lot from your tutorials - thank you! I am a new Quickbooks user trying to get everything set up properly. I use Shopify, with Paypal as my merchant card processor. I cant integrate Shopify at this time because we also take international transactions. If they change that later, would I get duplicate entries from Paypal and Shopify?
Hector, great video. Are you able to do a video on reconciling your PayPal account? I connected my PayPal account to QuickBooks using the same steps but there is a difference between my beginning and ending balance.
Service income received to personal paypal account.Then he deposit the same from PayPal account to business's bank account.how to match this transaction from bank to invoice
Thank you for your video. Very well done! One question: are there advantages to classifying a PayPal sale as a receipt rather than as a transfer ? I ask because all of customer receipts are already handled by my website and I will never send a receipt from QBO.
I have my PayPal account linked to QBO, and on the Banking > Transactions page it shows the payer's name in the description column before I add the transaction. When I expand the transaction, the payer's name also shows in the Bank Detail followed by other data (transaction ID, corresponding PayPal link, etc.). Once I add the transaction, the payer's name doesn't show anywhere, neither the memo nor the description. As QB is receiving data of who the payer is from the bank, how can I set the memo and/or description to match the bank detail?
I love your incredibly clear tutorials! For a nonprofit that accepts donations via PayPal, would you recommend we just create a rule (as you described at about 13:25) that enters the "money in" as a deposit? We are currently hosting livestream music videos, accepting many very small donations via PayPal (intended as tips for the performers), and in some cases we are paying some of the performers via PayPal. Do you have any advice on how best to do this in QB?
@@HectorGarciaCPA Would you create a bill for amounts you want to pay OUT of PayPal? Or will that effectively create the transaction twice: first, my manual entry of bill and payment via my PayPal account, AND second PayPal's bank feed that includes money out?
As usual - very helpful. What about the PAYPAL app that added transactions directly to the books? I have a client who was connected that way, but the sync failed and I can not find how to reconnect. Thanks for any help
Hi Hector, i have watched you a few times, but was confused. I have now subscribed and clicked the bell. I would to say thank you for your videos. I have a problem with Paypal; it does not load any transactions and is so annoying. I have deleted and added PayPal, but still no feeds. Their CSV file is not at all compatible with QB (why?)....i need this info, can you suggest anything. I'm in UK using QB online plus.
Hello Hector, thank you for this video, very helpful. I'm interested in this but when receiving payments from multiple currencies from Paypal. Furthermore, I like how you used the Rules so that all incoming sales are made as a Deposit automatically - time saving. I would like to use this rule, but a good proportion of the incoming are Purchase returns (let's say a fifth). Without using the 'Undo' and then recategorising as a Purchase return, is there a way that you can think of please to handle this scenario?
Thank You Hector! My question is: My business has 3 accounts; Operating, Taxes, Profit. Can I allocate a portion of each sale into multiple accounts under a rule?. Looking forward to hearing back, thanks!
Thanks Hector!! I had no idea that we could hook Paypal up as a regular bank feed!! I also didn't realize the difference between the two ADD buttons. Very handy.
Hector do you know why the download from paypal into QuickBooks for review would have a debit and credit for each transaction? Paypal account is used for sales of product should only be a credit - paypal fees.
Hey Hector, this was an awesome video. I have a question, if I connect my paypal to my quickbooks account, will I be able to match those expenses from my bank transactions? I hope that makes sense thank you.
Amazing video, my only question is when the transaction is split, does the PayPal fee categorize the expense to bank fees? or can you choose where that expense goes to? thank you. This video was exactly what I was looking for.
Your videos are fantastic!!! Can you offer best practice suggestions for how to sync paypal invoices so that products/services are also synced in quickbooks? Sales Receipts are only dumped into Paypal Sales.
I'm really enjoying your videos, my husband is self employed and uses paypal for everything and I'm wanting to be a bit more organized for him. If my PayPal transactions include shipping and tax, will QB automatically categorize them like it does with the PayPal fee?
Thanks for the video. It's very thorough. When setting up a PayPal account and asked what name to give the account, what if there is already an existing account? We've been manually entering the transactions and I don't see on the video if an existing account can be used. Thank you.
So helpful! This was exactly the information I was looking for. It does lead to another question which is: my PayPal income comes from sales through a website. In state sales have sales tax but out of state sales do not. Whether or not the customer pays sales tax is determined at the website level. How can I include sales tax in the PayPal records (through QB) so that when I need to remit to the state all the information is captured in one place?
When I review the transactions before importing into the Paypal register, it shows the gross amount minus the PayPal fees for the net. The problem is that when I run a report on my customers (in my case donors), it subtracts the fees from their donations so they don't get full credit for their donation. Before, it used to import the Gross and fees on two different lines in the register. How do I get QBO to automatically add both the gross amount of a payment and the fee for the payment on two separate lines in the register instead of combining for just one net amount? Thanks in advance.
my quckbooks online doesn't add the paypal memo with the link to look at it directly in paypal. Also my sales receipts don't show the amount and gross amount minus the paypal fee. Is there a different way this is set up? My paypal fees and sales receipts come in all separately.
great video! Please cover more about Paypal - how to add missing information to a sales receipt that paypal imported into the REVIEW section or into the REGISTER (when customer's name or details of their purchase are missing). Thanks!
My version of Quickbooks online does not bring in transaction ID and other info from Paypal when I connect QBO with Paypal. Am I missing something. When I click on a deposit transaction, I have no drop down window that asks me if I want to create a Sales Receipt, Deposit, or Transfer. I'm also not getting Bank details link that you can click to take you to Paypal transaction.
How do you fix a different currency Paypal transactions on Quickbook Online? My Paypal is synced on QB and all transactions would appear in USD even though some of those transactions are in Pesos.
Hector, new here and I have Webgility but I’m confused about this PayPal thing. I don’t have them importing my PayPal transactions but they do import my eBay transaction detail as we only use PayPal with my eBay store. I use my regular bank account for my pos sales and website sales. Should I have webgility download my PayPal info as well?
Thanks so much for all the wonderful info you have taught me. What I seem to cannot find is adding ebay fees to the sales receipts as a (-) in order to show total profit for each item I sell on ebay. Can this be done or should I do it on just a monthly basis? Am I trying to complicate each sale by doing this? I inherited a huge amount of inventory and will need to show that on items sold, I am making a profit or on others I am not. Thanks in advance for any advice.
When you have two or three Paypal transactions (mostly receving PayPal sales), is this a good approach? I see a transaction in Quickbooks, it's sales receipt (they are split deposit transactions -> Gross - Paypal fee = Net amount)....Is it ok to just add new customer manually and click "add", or do I need to create a new invoice and then match/close that invoice with a new Paypal transaction? I tried this way with creating invoices, but expenses are automatically transfered "undeposited funds"
Would you just be using the transfer option in QuickBooks online to show the money moving from Paypal to the checking account it is deposited to, so you can reconcile each account? What is the best way to show these transfers and deposits between the two accounts?
Hector is this specific for QBO advanced or can you create sales receipts directly from the bank feeds in PayPal for qbo plus because I do not see this option currently. Could you please advise?
Question: I see the option to choose to make the transaction a sales receipt in my connected PayPal bank, however the option isn't available for my Venmo Bank account. Is there a workaround for this, or does it require that I manually enter a sales receipt for the transaction and then match it with the existing transaction? If that is the case, it may be easier to just enter the data straight from the Venmo account statement.
@@HectorGarciaCPA I almost did not expect a reply, because the post is a few years old, but I was pleasantly surprised! Thank you for the quick response! 😊 I'm disappointed that I have to make a receipt for each transaction but toggling windows isn't so bad. Your videos are excellent btw. I appreciate this resource!
Hector, I have a scenario where there's a fixed price for the widget but the customer can make multiple payments. Now in desktop I had created an invoice for the full amount and then each time a payment came in I would apply the payment against the open invoice. Can this be done in QBO? Additionally, sometimes a customer may qualify for a discount however they have already paid in full. Do you have a demo of the refund that is created in PayPal?
Additionally I concur with James Jones from a couple of days ago that the Add button is definitely no longer there. I did go to the chart of accounts and tried connecting to the bank account that way (as I already had a PayPall Bank account) but it still hasn't come up for me to enter my login credentials.
1) you can create an invoice and do partial payments, yes 2) there is no mechanism to automate early pay discounts like desktop does 3) no demo on paypal refunds
How do you account for transactions like the Paypal withdrawals and deposits that have been done with the credit card? Like the instant withdrawals where there is a fee taken for using the card.
Very useful, I do need some support with eBay sales in PayPal. I just realized beginning last November sales tax was being charged to the eBay customer and PayPal is taking it out. I'm curious what the best practice is for this. Technically eBay charged the customers on my sales receipt and PayPal takes it out in a separate transaction. I had three sales for November and I added the three sales tax transactions charged me from PayPal but for some reason I'm still not reconciling my monthly statement. Somewhere I've done something wrong. A tutorial on this little issue would be a huge blessing. :)
@@HectorGarciaCPA Well I totally understand. I guess I just needed to watch your video and get my brain out of the high stress I went back in and looked at all three sales receipts and then I looked at all three sales tax transactions. On one of them I changed the payment method and when I changed it back to what the other two transactions had in the payment method - now it is reconciling! Whew, this stuff drives me crazy! Thanks for your videos, they are truly very helpful!
Hi Hector. Thank you for another great video! In your video , is PayPal classified as a VENDOR ? Are Customers who pay via PayPal automatically added or updated? If you setup PayPal as a Bank Feed, and also have your bank account where PayPal funds are deposited, do you have duplicate deposits showing up in Quickbooks from PayPal sales?
I would love to see a tutorial about properly 'transferring' funds from PayPal into Bank account. I enter all PayPal transactions as a sales receipt because my invoices are all pre-created in another software, with the option to pay through PayPal. It does the match well, but when I transfer the funds to my bank, it is doubled. Almost seems like when I do the match from the PayPal transaction, it is recording it in the bank account.
I should add we don't spend any money out of PayPal, we only use it to process payments from previously created invoices. So all income is transferred to the bank account.
I just connected with Connect to PayPal and it doesn't look like your video. Instead of having the sales and fee in one line and then being able to click on it and click on "Details" to see the actual sales receipt, it only lets you click on "Split" under the sales line which only brings up a split screen with no way to indicate the tax category/item. This must be new. Do you have any suggestions on what I can use instead (maybe the simple bank download?) to get to the sales receipt during banking review?
Question, becuase there is a descripancy in my head. My Paypalaccount is connected to my bank account (in this case a German one). When paying with paypal, it draws funds from the bank account and NOT from a paypal balance. So, if I connect Paypal with Quickbooks, how does Quickbooks now that the expense which will show as Paypal on my Bank account will not be a duplicate in Quickbooks? Or am I seeing this the completly wrong way?
How can we connect Paypal Sales Tax and Sales Tax Payable in QB? We have Paypal Sales Tax as an item but mapping feature (setting) in Banking does not recongize the service item. Sales tax in paypal has been automatically coded as Paypal Sales in the 2nd line of sales receipt. Is there any way to point sales tax line to a sales tax liability account?
Hi Hector, This is a very useful video, I need one help from you as I am facing an issue while trying to match the PayPal Deposit with Sales Receipt and customer payments. While I click on find match it shows me the Gross amount in that page and thus I can not put PayPal Fees correclty. If I match as same, the PayPal fee records under undeposited Fund, which is not correct and I can not reconcile my account. It will be great help if you can let me know how to resolve this. Thank you.
Am I getting this right.. You download the paypal transactions and youve got to sit there and link you expenses and sales receipt... how is that even convenient. thats doing it manually one by one?.. and youve gone back an entire year plus more.. are you really going to go through each on separately..
i usually use paypal to make invoices for my customers but they often pay me through zelle to avoid the paypal fee, do i need to make all new invoices for my customers on quickbooks and then match it with my zelle transactions?
Thank you! I am a volunteer treasurer for a non-profit agency. I have ZERO training in accounting. I have learned Quickbooks through the school of hard knocks. You, sir, are the BEST teacher I have found when it comes to tutorials about using Quickbooks. I love how you highlight the area of the screen you are referring to. I love how you speak clearly and simply. I love how empowered I feel right now. You have gained a new subscriber!!!!
Thanks! Awesome
Thank you, Bob and Hector. I, too, just started volunteering for a non-profit, and this video is a game changer!!!
Second question, do you have a video showing how you manage/classify PayPal transactions that are funded by a credit card not PayPal funds?
The most comprehensive tutorial I've seen yet on PayPal bank feeds! Bookmarking this one for future reference and for sharing with diy clients
Awesome
as always really good ..... I would like to see a video about matching transfers thru the bank feed.
Very helpful. Thank you for posting Hector.
Great video Hector. However, QBO doesnt let you auto confirm for Paypal accounts now under the rule setting.
Thats right. Paypal rules are different
I had been trying to do this for a week with no luck. Your tutorial worked perfectly! You're amazing! Thank you!!
:)
Hi Hector! Thank you so much for your content, you’re so good at explaining.
What if when you link PayPal, and the client had already deposited money from PayPal into the checking account, which is linked so already added to QBO? How do you not double deposit? I ended up deleting the original link and starting with a new transaction date
i've been using quickbooks online for a few months but still much to learn. you're videos are very helpful, thanks!
Hi Hector and everyone! Wondering if there is a best case approach for the following (seemingly very common) scenario: You send payments using PayPal, pulling the funds from a bank account also linked to QB, as opposed to using your PayPal balance. The transaction will show on both "accounts". I thought it would make sense to be able to match them, so you can reconcile both accounts, however when speaking with a QB support rep, they told me you can "only match transactions under the same bank account", thus making the option impossible, to match your PayPal account transaction, with the Bank transaction, even though they are the same. If you were to categorize both, the transaction would be duplicated, which is obviously a problem. The rep suggested I "exclude" categorizing the transactions from either the bank, or the PayPal account... It just doesn't seem right to me... Thoughts?
Hi @angelopepeskordos did you find a way resolving this? I have the same issue. Please share if you got a way around it.
@@preciousmoyyoNo workaround unfortunately. Strangely some transactions I can match, but general rule of thumb is I exclude one of the two… Doesn’t seem correct but I hope there will be a fix for this soon.
Thank you my friend! 34 seconds in and you solved my problem that Quickbooks help search couldn't answer (I'll come here first next time!)
Great!
At 5:40 I notice your Sales Receipt shows "Deposit To" field directed to "Undeposited Funds". My system is automatically set up this way as well. The problem is all my Paypal Income seems "trapped there" in my reviewed transactions and when I create a Customer Transaction History. While in my regular bank account deposit transactions I can see my funds posted in the appropriate bank. How do I get my Paypal Sales Receipts to end up in "PayPal Bank". We are a small nonprofit and much of our income comes from automatic monthly Paypal Sales that we designate as donations. We appreciate any advice you can provide.
René T did you figure this out- I’m also helping a non profit catch up it’s books and was hoping to use this trick to speed up vs manual data entry
@@leighbrett I gave up. I haven't touched it. I ended up disconnecting my Paypal and was looking for a new accountant too. If you have a solution that would be awesome. The end of the year will be here soon, and I will need to get a whole year's worth of transactions posted to do our year end reports.
René T I’m trying out saasant to do my data catch up will ,et you know how it goes but . Side note if you are manually posting sales receipts to undeposited funds then when you got to bank deposit to select the sales receipt make sure that window has deposit to paypal and not checking account PayPal should be set up as a bank
René T are you reconciling your payable bank account ?
Great explanation! Have been struggling to get up to speed on how this connection works. Thanks!
Very helpful, thank you!!! But how do you record a transfer from the Paypal account into the operating bank account?
would love to know also
Corey Atkinson did you ever find out
Did you find out, please share
Thank you Hector! I have been using your recommended CSV to QBO addon and the entries are different in the journal. I have some testing to do to figure it out. GOOD INFO! You are helpful to many!
:)
First of all, thank you for your wonderful content and for trying to help with Paypal. It's such a nightmare as far as bookkeeping for a client goes....I constantly struggle with this! I do have a question though, hopefully you can answer: So if I accept the payment as a sales receipt, how do I go in and adjust for adding the sales tax and delivery fees? Should I just accept as a deposit and go in and adjust it from there. QBO doesn't give the option to go in and split the transaction if I do that on the normal bank feed screen. I appreciate any and all advise. Trying to finish up a 2021 nightmare! LOL!
I have a question but first I must say you are incredible and explain things so well. Thank You. I use Paypal for my sales but all money is swept into my bank at the end of each day. If I connect Paypal and create a rule for all Paypal transactions to me set as Deposit or Sales Receipt, how do I handle my connected bank account which shows all my Paypal sweeps as deposits? How do I handle the bank reconciliation for deposits if I am already recording the Paypal transactions as Sales. I hope this makes sense. I am getting confused and don't want to make double entries for money received.
Great video and very eye opening. One of the struggles I have with my clients is the mixing of personal with business related expenses in PayPal. It’s difficult to wean them off commingling funds. One of the most frustrating things is that when I copy and paste the PayPal URL from the transaction memo line to view the PayPal details you need to login to PayPal and as far as I know PayPal doesn’t not offer third-party login capability for us accountants to log into a clients PayPal account to be self serving.
Best Quickbooks and PayPal video. Informative, concise, and easy to understand. Please do more.
Thank you sir and I did watch until the end!
Your videos are saving my sanity! I find them so helpful. Do you do any specific to nonprofits?
Patricia Smith I don’t touch non-profits
thanks, Hector! I finally got my brain around this. Question: I am helping out a friend and he has categorized a bunch of transactions into the wrong category in PayPal. (I assume he has reconciled them) I want to move it to a new category as income. Can I do this simply and/or is there a video I can watch? Much appreciated. Gracias!
How do you match the item sold in Paypal to the Products & Services item in QBO so everything is categorized to the correct income account? We have 15-20 products and can't have them all go to one income account "Paypal Sales" or another account that you can edit in the Bank settings. The Square app in QBO allows you to map/match Square items to QBO products for easy recording. The way it looks now, we have to manually edit each sales receipt to add the correct QBO product
Thank you. Very helpful video! Taking on my 1st client using PayPal so this will help streamline things!!
Good luck
Wow, this is an extremely helpful video. I learned a lot. One follow-up question: what is the reasoning behind whether a PP transaction (or any) is categorized as a sales receipt or a deposit? Are there merits to one over the other?
I'd like to know this too. Not quite clear on that yet.
This was very helpful! Do you have to define the expense account for the fees somewhere?
I am learning a lot from your tutorials - thank you! I am a new Quickbooks user trying to get everything set up properly. I use Shopify, with Paypal as my merchant card processor. I cant integrate Shopify at this time because we also take international transactions. If they change that later, would I get duplicate entries from Paypal and Shopify?
This was so good. I've been curious about this. Thank you for creating this video.
:)
Hector, great video. Are you able to do a video on reconciling your PayPal account? I connected my PayPal account to QuickBooks using the same steps but there is a difference between my beginning and ending balance.
Brendan Kutcher reconcile a PayPal account is going to be a unique experience for every account, so that might NOT happen
Ok, thanks Hector. My experience so far is that reconciling PayPal is extremely difficult compared to a bank account or credit card.
Thank you! My PayPal wouldn't match transactions until I changed the sales receipt's Deposit To, to Paypal. So helpful! Love your videos!
Service income received to personal paypal account.Then he deposit the same from PayPal account to business's bank account.how to match this transaction from bank to invoice
Your videos are very helpful, clear and concise.
Thanks.
Thank you for your video. Very well done!
One question: are there advantages to classifying a PayPal sale as a receipt rather than as a transfer ? I ask because all of customer receipts are already handled by my website and I will never send a receipt from QBO.
I have my PayPal account linked to QBO, and on the Banking > Transactions page it shows the payer's name in the description column before I add the transaction. When I expand the transaction, the payer's name also shows in the Bank Detail followed by other data (transaction ID, corresponding PayPal link, etc.). Once I add the transaction, the payer's name doesn't show anywhere, neither the memo nor the description. As QB is receiving data of who the payer is from the bank, how can I set the memo and/or description to match the bank detail?
I love your incredibly clear tutorials! For a nonprofit that accepts donations via PayPal, would you recommend we just create a rule (as you described at about 13:25) that enters the "money in" as a deposit? We are currently hosting livestream music videos, accepting many very small donations via PayPal (intended as tips for the performers), and in some cases we are paying some of the performers via PayPal. Do you have any advice on how best to do this in QB?
I think a rule would be best
@@HectorGarciaCPA Would you create a bill for amounts you want to pay OUT of PayPal? Or will that effectively create the transaction twice: first, my manual entry of bill and payment via my PayPal account, AND second PayPal's bank feed that includes money out?
As usual - very helpful. What about the PAYPAL app that added transactions directly to the books? I have a client who was connected that way, but the sync failed and I can not find how to reconnect. Thanks for any help
Hi Hector, i have watched you a few times, but was confused. I have now subscribed and clicked the bell. I would to say thank you for your videos. I have a problem with Paypal; it does not load any transactions and is so annoying. I have deleted and added PayPal, but still no feeds. Their CSV file is not at all compatible with QB (why?)....i need this info, can you suggest anything. I'm in UK using QB online plus.
So helpful! Thank you Hector for all your videos
Hello Hector, thank you for this video, very helpful. I'm interested in this but when receiving payments from multiple currencies from Paypal. Furthermore, I like how you used the Rules so that all incoming sales are made as a Deposit automatically - time saving. I would like to use this rule, but a good proportion of the incoming are Purchase returns (let's say a fifth). Without using the 'Undo' and then recategorising as a Purchase return, is there a way that you can think of please to handle this scenario?
Thank You Hector! My question is: My business has 3 accounts; Operating, Taxes, Profit. Can I allocate a portion of each sale into multiple accounts under a rule?. Looking forward to hearing back, thanks!
Yes you cam move money to those
Thanks Hector!! I had no idea that we could hook Paypal up as a regular bank feed!! I also didn't realize the difference between the two ADD buttons. Very handy.
Yes, is crazy how things change and evolve.. it wasn’t like that last year.
What about importing invoices from paypal into quickbooks? Do those count as transactions?
Hi Hector, thanks for the great video :) Do you have a video on PayPal bank reconciliation?
Not yet
what is the difference between sales receipt and the other option on the drop down menu like "deposit"
Hector do you know why the download from paypal into QuickBooks for review would have a debit and credit for each transaction? Paypal account is used for sales of product should only be a credit - paypal fees.
Hey Hector, this was an awesome video. I have a question, if I connect my paypal to my quickbooks account, will I be able to match those expenses from my bank transactions? I hope that makes sense thank you.
Great video! Thanks for the information! Looking forward to following this channel!
what is the difference between entering payments from customers as sales receipts vs entering them through and invoice?
Hello! This is so incredibly helpful! Why would one want deposit versus sales receipt or is it personal preference?
Preference
Amazing video, my only question is when the transaction is split, does the PayPal fee categorize the expense to bank fees? or can you choose where that expense goes to? thank you. This video was exactly what I was looking for.
Yes it does
Your videos are fantastic!!! Can you offer best practice suggestions for how to sync paypal invoices so that products/services are also synced in quickbooks? Sales Receipts are only dumped into Paypal Sales.
You need a special app like Synderapp
This was great Hector - so helpful! Thank you for sharing.
Thank you for your clear and concise presentation. Can you show how to import from PayPal a payment and apply it to an invoice?
Not on my list of videos to create, sorry
Is "Connect to PayPal" under Add Account the same as the PayPal app connection?
I'm really enjoying your videos, my husband is self employed and uses paypal for everything and I'm wanting to be a bit more organized for him. If my PayPal transactions include shipping and tax, will QB automatically categorize them like it does with the PayPal fee?
No it doesn’t
Thanks for the video. It's very thorough. When setting up a PayPal account and asked what name to give the account, what if there is already an existing account? We've been manually entering the transactions and I don't see on the video if an existing account can be used. Thank you.
Laura Lozano just pick it from the list; no need to create a new one
@@HectorGarciaCPA Thank you, with your videos it's become easier than I thought.
So helpful! This was exactly the information I was looking for. It does lead to another question which is: my PayPal income comes from sales through a website. In state sales have sales tax but out of state sales do not. Whether or not the customer pays sales tax is determined at the website level. How can I include sales tax in the PayPal records (through QB) so that when I need to remit to the state all the information is captured in one place?
You can’t via this process
@@HectorGarciaCPA ok, that's good to know. Do you have a recommendation of how to address this issue? Thanks!
Wish me luck! I'm going to try to implement what I've learn!
Good luck
When I review the transactions before importing into the Paypal register, it shows the gross amount minus the PayPal fees for the net. The problem is that when I run a report on my customers (in my case donors), it subtracts the fees from their donations so they don't get full credit for their donation. Before, it used to import the Gross and fees on two different lines in the register. How do I get QBO to automatically add both the gross amount of a payment and the fee for the payment on two separate lines in the register instead of combining for just one net amount? Thanks in advance.
my quckbooks online doesn't add the paypal memo with the link to look at it directly in paypal. Also my sales receipts don't show the amount and gross amount minus the paypal fee. Is there a different way this is set up? My paypal fees and sales receipts come in all separately.
great video! Please cover more about Paypal - how to add missing information to a sales receipt that paypal imported into the REVIEW section or into the REGISTER (when customer's name or details of their purchase are missing). Thanks!
Not possible with the built-in app.. you need to look at Sush.io or Webgilty for that level of detail/control
My version of Quickbooks online does not bring in transaction ID and other info from Paypal when I connect QBO with Paypal. Am I missing something. When I click on a deposit transaction, I have no drop down window that asks me if I want to create a Sales Receipt, Deposit, or Transfer. I'm also not getting Bank details link that you can click to take you to Paypal transaction.
How do you fix a different currency Paypal transactions on Quickbook Online? My Paypal is synced on QB and all transactions would appear in USD even though some of those transactions are in Pesos.
Hector, new here and I have Webgility but I’m confused about this PayPal thing. I don’t have them importing my PayPal transactions but they do import my eBay transaction detail as we only use PayPal with my eBay store. I use my regular bank account for my pos sales and website sales. Should I have webgility download my PayPal info as well?
Thanks so much for all the wonderful info you have taught me. What I seem to cannot find is adding ebay fees to the sales receipts as a (-) in order to show total profit for each item I sell on ebay. Can this be done or should I do it on just a monthly basis? Am I trying to complicate each sale by doing this? I inherited a huge amount of inventory and will need to show that on items sold, I am making a profit or on others I am not. Thanks in advance for any advice.
That’s a tricky one. A monthly adjustment is fine
Hector, great video. When using QBO and PayPal I get a lot of "undeposited funds" with a reserve hold description. What is this exactly?
Reserve holds are complicated. Not sure if I can accurately teach that
Have a question. How do you account the paypal reserve hold and reserve release? What account do you use in recording? Thank you so much.
This video made it super easy to understand, but I am a bit perplexed about when they come in as transfers or you are reimbursing an owner.
Is not easy
When you have two or three Paypal transactions (mostly receving PayPal sales), is this a good approach? I see a transaction in Quickbooks, it's sales receipt (they are split deposit transactions -> Gross - Paypal fee = Net amount)....Is it ok to just add new customer manually and click "add", or do I need to create a new invoice and then match/close that invoice with a new Paypal transaction? I tried this way with creating invoices, but expenses are automatically transfered "undeposited funds"
This nethod works just fine
Great help for small business entrepreneurs! Thanks, Hector!
My pleasure!
Would you just be using the transfer option in QuickBooks online to show the money moving from Paypal to the checking account it is deposited to, so you can reconcile each account? What is the best way to show these transfers and deposits between the two accounts?
Yes transfer works
Is there any way to import just the fees & bank transfers to QBO? Our website already pushes the invoices and payments to QBO.
Not possible, but you can match the others
Hi Hector! Thanks for this video. How to change PayPal from sync to bank feeds setting?
Delete the “app”
@@HectorGarciaCPA this meana I have to redo everything?
@@HectorGarciaCPA this means I have to redo all accounts?
@@princesstolentino4015 no.. you remove the Sync app and then connect bank feeds and take over from the last transactions synced
@@HectorGarciaCPA thanks Hector! Will this affect my previous work? Like the balance etc.?
This was very helpful. Thank you!
Great!
Hector is this specific for QBO advanced or can you create sales receipts directly from the bank feeds in PayPal for qbo plus because I do not see this option currently. Could you please advise?
Should be in all versions of QBO
Hector when you set up paypal with the bank feed does the COA need to already have Paypal Fees and Paypal Sales in it?
No, but you can create them
Question: I see the option to choose to make the transaction a sales receipt in my connected PayPal bank, however the option isn't available for my Venmo Bank account. Is there a workaround for this, or does it require that I manually enter a sales receipt for the transaction and then match it with the existing transaction? If that is the case, it may be easier to just enter the data straight from the Venmo account statement.
Paypal has a different connection to QB than Venmo.. no workaround
@@HectorGarciaCPA I almost did not expect a reply, because the post is a few years old, but I was pleasantly surprised! Thank you for the quick response! 😊 I'm disappointed that I have to make a receipt for each transaction but toggling windows isn't so bad. Your videos are excellent btw. I appreciate this resource!
Hi Hector, how do you add the transaction ID to the transaction memo in quickbooks.
Thanks!
If it doesn’t come in the feed, you can’t add it
I found it very helpful,thanks Hector👍
Hector, I have a scenario where there's a fixed price for the widget but the customer can make multiple payments. Now in desktop I had created an invoice for the full amount and then each time a payment came in I would apply the payment against the open invoice. Can this be done in QBO? Additionally, sometimes a customer may qualify for a discount however they have already paid in full. Do you have a demo of the refund that is created in PayPal?
Additionally I concur with James Jones from a couple of days ago that the Add button is definitely no longer there. I did go to the chart of accounts and tried connecting to the bank account that way (as I already had a PayPall Bank account) but it still hasn't come up for me to enter my login credentials.
1) you can create an invoice and do partial payments, yes
2) there is no mechanism to automate early pay discounts like desktop does
3) no demo on paypal refunds
Mr. Garcia, Venmo will follow the same pattern as Paypal in QB?
No. Vengo is different
This was great. I have been watching your Videos so informative . Thanks so much.
Very much helpful... Carry on. Please make a video on how to sort the PayPal balance affecting statements by using the vlookup formula.
How do you account for transactions like the Paypal withdrawals and deposits that have been done with the credit card? Like the instant withdrawals where there is a fee taken for using the card.
Thats a transfer
Very useful, I do need some support with eBay sales in PayPal. I just realized beginning last November sales tax was being charged to the eBay customer and PayPal is taking it out. I'm curious what the best practice is for this. Technically eBay charged the customers on my sales receipt and PayPal takes it out in a separate transaction. I had three sales for November and I added the three sales tax transactions charged me from PayPal but for some reason I'm still not reconciling my monthly statement. Somewhere I've done something wrong. A tutorial on this little issue would be a huge blessing. :)
It’s hard to answer like this.. I would Need to look at your specific use case and make recommendations, sorry.
@@HectorGarciaCPA Well I totally understand. I guess I just needed to watch your video and get my brain out of the high stress I went back in and looked at all three sales receipts and then I looked at all three sales tax transactions. On one of them I changed the payment method and when I changed it back to what the other two transactions had in the payment method - now it is reconciling! Whew, this stuff drives me crazy! Thanks for your videos, they are truly very helpful!
Hi Hector. Thank you for another great video! In your video , is PayPal classified as a VENDOR ?
Are Customers who pay via PayPal automatically added or updated? If you setup PayPal as a Bank Feed, and also have your bank account where PayPal funds are deposited, do you have duplicate deposits showing up in Quickbooks from PayPal sales?
No.. the transfers don’t download
Thank you!
Hector Garcia CPA if the transfers don’t downoald how do you reconcile the PayPal bank account ?
Thank you for your service! Your videos are super helpful
Can I allow my customers to pay with PayPal using their PayPal account through the QB invoices?
I want to know this too...
I would love to see a tutorial about properly 'transferring' funds from PayPal into Bank account. I enter all PayPal transactions as a sales receipt because my invoices are all pre-created in another software, with the option to pay through PayPal. It does the match well, but when I transfer the funds to my bank, it is doubled. Almost seems like when I do the match from the PayPal transaction, it is recording it in the bank account.
I should add we don't spend any money out of PayPal, we only use it to process payments from previously created invoices. So all income is transferred to the bank account.
I just connected with Connect to PayPal and it doesn't look like your video. Instead of having the sales and fee in one line and then being able to click on it and click on "Details" to see the actual sales receipt, it only lets you click on "Split" under the sales line which only brings up a split screen with no way to indicate the tax category/item. This must be new. Do you have any suggestions on what I can use instead (maybe the simple bank download?) to get to the sales receipt during banking review?
Simone Christoph did you figure this out ? I was hoping to use this to quickly add sales receipts direct from PayPal bank
Thank you Hector! This is so helpful!
Question, becuase there is a descripancy in my head. My Paypalaccount is connected to my bank account (in this case a German one). When paying with paypal, it draws funds from the bank account and NOT from a paypal balance. So, if I connect Paypal with Quickbooks, how does Quickbooks now that the expense which will show as Paypal on my Bank account will not be a duplicate in Quickbooks? Or am I seeing this the completly wrong way?
Its a mess
Hello Hector, I have a question. Is PayPal a checking account or a credit card account? Thank you
Bank account
How can we connect Paypal Sales Tax and Sales Tax Payable in QB? We have Paypal Sales Tax as an item but mapping feature (setting) in Banking does not recongize the service item. Sales tax in paypal has been automatically coded as Paypal Sales in the 2nd line of sales receipt. Is there any way to point sales tax line to a sales tax liability account?
There is no built in system to sync PayPal with sales tax... you would need a 3rd party application that specializes in that
Hi Hector, This is a very useful video, I need one help from you as I am facing an issue while trying to match the PayPal Deposit with Sales Receipt and customer payments. While I click on find match it shows me the Gross amount in that page and thus I can not put PayPal Fees correclty. If I match as same, the PayPal fee records under undeposited Fund, which is not correct and I can not reconcile my account.
It will be great help if you can let me know how to resolve this. Thank you.
It’s complicated, I know
Do I have to match my sales receipts with inventory purchases, Sales receipts or deposits?
Sales receipts
Am I getting this right.. You download the paypal transactions and youve got to sit there and link you expenses and sales receipt... how is that even convenient. thats doing it manually one by one?.. and youve gone back an entire year plus more.. are you really going to go through each on separately..
It take a really long time to work with paypal
Can I do this with QuickBooks for desktop (not online) for mac?
No
Thank you so much for this video! Helped so much!!
i usually use paypal to make invoices for my customers but they often pay me through zelle to avoid the paypal fee, do i need to make all new invoices for my customers on quickbooks and then match it with my zelle transactions?
Ideally
Basic question, if invoice or sales receipt is created for full amount and match is done for lessor amount after fee, how is the fee accounted for?
It will bring the fee separately!