Great video! It is really important to make sure that Shopify sellers don't just record all transactions but know how to record them correctly. Keeping financial records detailed and accurate leads to a stress-free tax season!
@@5MinuteBookkeeping I'm quite mixed up. In the banking window, QBO shows like 5 times the balance as what our actual bank account shows. Also, when a sale is created in Shopify (for website order) that individual sale filters into QBO and I wonder if at that time it's recorded as income. ? Another thing is, what account do you give shopify 'transfers' in the banking review window. I was putting them to 'Sales from Product Income', but I thought that was why showing such a high QBO 'bank balance', but when I created a Shopify Clearing account (bank?) and allocated to that and just recorded that transfer as a 'transfer', that didn't work either to balance. I'm sure I need to do the step where I clear out the Shopify Clearing, but not sure where to do that. I'm more of a creative, so this all doesn't come naturally to me at all.
Found your post interesting to watch. I can't wait to see your new videos soon. Good Luck with the upcoming update. This UA-cam channel is really very informative and effective.
Thanks so much! I sell on Etsy, Amazon, eBay, and Shopify and Shopify is by far the most confusing. I really want to figure it out especially because I want to pivot my business next year to provide bookkeeping for other online small businesses. I need to check out your courses. Sounds like we would be a good fit. Thanks again!
Reconciling clearing accounts is a more complex process. I do not have videos on how to reconcile on my UA-cam channel. But, I do teach the full Shopify bookkeeping process, including reconciling clearing accounts in my online course, Shopify Bookkeeping Method here courses.5mbacademy.com/courses/shopify-bookkeeping-method
The Shopify manual gateway is typically used in Shopify when a sale is entered in Shopify but payment is received outside of Shopify. Many B2C sellers user the Manual Gateway - they enter sales in Shopify but the customer pays them outside of Shopify.
Greetings, how would it be if I entered the income directly from the bank statement? That is, during the month, payments from Shopify come in that I reconcile with income from sales from Shopify. But at the end of the month in the summary there is a difference, since those payments come in the other month. How would I do it? Thank you.
When looking at deposits in my bank account - and the corresponding payouts in Shopify - how do I record the fees? Do I categorize the entire net amount to the clearing account, and then record fees later?
Hi. I’m confused on how to match PayPal income. Because on Shopify Payments is so easy to match, as I match their payments to my bank account. However on PayPal “bank” I get deposita from customers individually and I set them as Deposit to PayPal Clearing. What else would be the next step so the clearing gets closer to Zero.
We have stopped using the PayPal bank feed in QBO because it's too cumbersome and it doesn't always pull all the transactions from Shopify. We enter one summarized entry per month in QBO using the PayPal monthly statement. We still use the clearing account but keep in mind that the clearing account balance will likely never be 0 because of timing differences.
Hi Carmen. I do not work with QuickBooks Desktop. You may want to search for videos by Hector Garcia CPA. He specializes in QuickBooks Desktop version.
That's a great question, Diosdado. You have to get the bill from Shopify and categorize the expenses based on whether the fees are for the Shopify platform, apps, shipping, or other expenses. For the Shopify platform fees and app fees, I categorize them to Software Expense.
You’re a life savior!
Thank you.
Great video! It is really important to make sure that Shopify sellers don't just record all transactions but know how to record them correctly. Keeping financial records detailed and accurate leads to a stress-free tax season!
Exactly! Thanks for watching.
@@5MinuteBookkeeping I'm quite mixed up. In the banking window, QBO shows like 5 times the balance as what our actual bank account shows. Also, when a sale is created in Shopify (for website order) that individual sale filters into QBO and I wonder if at that time it's recorded as income. ? Another thing is, what account do you give shopify 'transfers' in the banking review window. I was putting them to 'Sales from Product Income', but I thought that was why showing such a high QBO 'bank balance', but when I created a Shopify Clearing account (bank?) and allocated to that and just recorded that transfer as a 'transfer', that didn't work either to balance. I'm sure I need to do the step where I clear out the Shopify Clearing, but not sure where to do that. I'm more of a creative, so this all doesn't come naturally to me at all.
Found your post interesting to watch. I can't wait to see your new videos soon. Good Luck with the upcoming update. This UA-cam channel is really very informative and effective.
Thank you.
Great information. I struggle with the cash payments on shopify and the clearing account.
Glad it was helpful!
Thanks so much! I sell on Etsy, Amazon, eBay, and Shopify and Shopify is by far the most confusing. I really want to figure it out especially because I want to pivot my business next year to provide bookkeeping for other online small businesses. I need to check out your courses. Sounds like we would be a good fit. Thanks again!
You're welcome!
Nice Information, thank you so much ♥
You're most welcome
This is great! Do you have any videos on how to reconcile your clearing accounts?
Reconciling clearing accounts is a more complex process. I do not have videos on how to reconcile on my UA-cam channel. But, I do teach the full Shopify bookkeeping process, including reconciling clearing accounts in my online course, Shopify Bookkeeping Method here courses.5mbacademy.com/courses/shopify-bookkeeping-method
What type of account is the Shopify Manual Gateway? And are there supposed to be deposits in the bank feed with the memo "Shopify manual?" Thanks!!
The Shopify manual gateway is typically used in Shopify when a sale is entered in Shopify but payment is received outside of Shopify. Many B2C sellers user the Manual Gateway - they enter sales in Shopify but the customer pays them outside of Shopify.
Greetings, how would it be if I entered the income directly from the bank statement? That is, during the month, payments from Shopify come in that I reconcile with income from sales from Shopify. But at the end of the month in the summary there is a difference, since those payments come in the other month. How would I do it? Thank you.
Take a look at these 2 video for the process:
ua-cam.com/video/v8vS1DOibvU/v-deo.html
ua-cam.com/video/yLTDTFiWhzM/v-deo.html
When looking at deposits in my bank account - and the corresponding payouts in Shopify - how do I record the fees? Do I categorize the entire net amount to the clearing account, and then record fees later?
Hi. Take a look at this video where I explain how to record the fees ua-cam.com/video/Lj-in8ORCRQ/v-deo.html&pp=gAQBiAQB
Hi.
I’m confused on how to match PayPal income. Because on Shopify Payments is so easy to match, as I match their payments to my bank account.
However on PayPal “bank” I get deposita from customers individually and I set them as Deposit to PayPal Clearing. What else would be the next step so the clearing gets closer to Zero.
We have stopped using the PayPal bank feed in QBO because it's too cumbersome and it doesn't always pull all the transactions from Shopify. We enter one summarized entry per month in QBO using the PayPal monthly statement. We still use the clearing account but keep in mind that the clearing account balance will likely never be 0 because of timing differences.
Can you please tell me how posting on desktop version a chrismas club for employee
Hi Carmen. I do not work with QuickBooks Desktop. You may want to search for videos by Hector Garcia CPA. He specializes in QuickBooks Desktop version.
@@5MinuteBookkeeping thanks
Hi, how do you record shopify bill?
That's a great question, Diosdado. You have to get the bill from Shopify and categorize the expenses based on whether the fees are for the Shopify platform, apps, shipping, or other expenses. For the Shopify platform fees and app fees, I categorize them to Software Expense.