Why you should be using Clearing Accounts for your Shopify bookkeeping
Вставка
- Опубліковано 25 чер 2024
- In this video, I'll share with you why you need to be using clearing accounts for your Shopify bookkeeping.
-------------------------------------
Chapters
0:00 Intro
0:24 What are e-commerce clearing accounts?
0:57 E-commerce timing differences
1:26 Chart of accounts set up
2:06 A2X setup
2:49 Clearing account workflow
3:49 Clearing account example
4:41 The reality of hundreds of transactions
5:10 Categorizing deposits received from payment processors
5:52 QBO bank feeds and deposits from payment processors
7:07 Reconciling clearing accounts
7:59 Download my free Shopify Bookkeeping Blueprint
Our e-commerce accounting videos have moved to a brand new channel. Visit us at the Mavency channel for new content and be sure to hit that subscribe button / @wearemavency
Ready to take on your Shopify financials like a pro while helping your e-commerce business grow? Download your free Shopify Bookkeeping Blueprint where I share the step-by-step processes you need to succeed: bit.ly/SHBKBlueprint
Are you ready to work with a trusted and reliable Shopify bookkeeping pro? Learn more about my bookkeeping, coaching, and integration services and pricing: mavency.com/request-info_ecom... notified about all my latest content, webinars, courses, and more: mavency.ck.page/content
Join my Facebook community of like-minded eCom sellers and bookkeepers and we'll be happy to help: bit.ly/2Am1lLQ
**Special discount: Get 50% off the monthly price of QuickBooks Online for the first 3 months with this link: quickbooks.grsm.io/VeronicaWasek
Save time and effort every month by automating your Shopify and QuickBooks integration with A2X:
www.a2xaccounting.com/signup **Get 20% off your first 6 months with A2X by using this discount code**: VM_20_6MON_2021
Follow us on Instagram @WeAreMavency for e-commerce bookkeeping tips, inspiration, and some behind-the-scenes looks at what we're up to: / wearemavency
Recommended playlist:
e-commerce accounting: bit.ly/36SDaRV
**Affiliate link
Copyright 2022 5MB LLC - Навчання та стиль
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.
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
Great information. I struggle with the cash payments on shopify and the clearing account.
Glad it was helpful!
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.
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.
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.
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