Handling Merchant Fee in QB Online
Vložit
- čas přidán 5. 07. 2024
- Are you accepting payments through a merchant provider (ie. Stripe, PayPal, Square, or your local bank)? I've been receiving questions about what's the proper way to handle these in QuickBooks to make sure the customer's account and your bank account are both reflecting the payments properly.
Don't forget to review how this type of expense is impacting the Profit and Loss.
Looking for the Desktop Version of this video: • How to handle Merchant...
Ready to learn more areas of QuickBooks? Join us on our next workshop to learn how to design QuickBooks for your specific business... ➡️ CandusKampfer.com/workshop
Receive our QB tips straight to your inbox each week visit: ➡️ CandusKampfer.com/tips
Timestamps:
0:00 - How to enter in Merchant Fees in QuickBooks Online
0:42 - Entering Customer Payments in Receive Payments
2:26 - Customer Payment Deposit in QuickBooks Online
5:50 - QuickBooks Tips & Tricks
5:57 - 3 secrets to Customizing with QuickBooks Workshop
I’d love to connect with you 🤗
Instagram: / candus.kampfer
Facebook: / canduskampfer
CandusKampfer.com: canduskampfer.com/
TikTok: / canduskampfer
Pinterest: / canduskampfer
#CandusKampfer
Are you more comfortable not with entering your merchant fees?
Yes, thank you!
I just watched your same video for QuickBooks Desktop. In the comments I saw someone asking about QBO, and you had already provided a link (which brought me here). This video was a lifesaver for me. Thank you .
Hi @Lorgayle1,
Glad it helped you.
Have an amazing day!
~ Team Candus
P.S. We’d love to connect with you! Find us on ↓
Instagram: instagram.com/candus.kampfer
Facebook: facebook.com/CandusKampfer
TikTok: www.tiktok.com/@canduskampfer
I usually match with the bank deposit then use the "resolve" button to make the adjustment.
Thank you for this! Such a helpful video and I love your personality to boot! It’s nice to have someone explain it in terms that make sense.
Hi!
Thanks for reaching out.
I'm so glad you found our video helpful 🤗
If you’d like to learn more about how to optimize QuickBooks for your business, I recommend checking out our Confidence with QuickBooks program. You can learn more here: ConfidencewithQuickBooks.com
Have a great day,
Samantha, Team Candus
Thank you so much for clearing that up!! It helped tremendously!!
Yay! Glad it helped you, Andrea. 😊
If you haven't already joined our weekly QB Tips & Tricks, click here to join and we'll send you our tips straight to your inbox: canduskampfer.com/weeklytips
Have an amazing day!
Elaine ~ Team Candus
P.S. We’d love to connect with you! Find us on ↓
Instagram: instagram.com/candus.kampfer
Facebook: facebook.com/CandusKampfer
TikTok: www.tiktok.com/@canduskampfer
Pinterest: pinterest.com/canduskampfer/
Really helpful, thank you!
Hi Daniel,
Thanks for reaching out.
I'm so happy you found this video helpful 😊
If you’d like to learn more about how to optimize QuickBooks for your business, I recommend
checking out our Confidence with QuickBooks program. To learn more you can attend our Customizing QuickBooks workshop. Save your seat here:
CandusKampfer.com/workshop
Have a great day,
Samantha, Team Candus
Super helpful for what I needed help with!
Hi,
I'm so glad you found our video helpful!
If you’d like to learn more about how to optimize QuickBooks for your business, I recommend checking out our Confidence with QuickBooks program. To learn more you can attend our Customizing QuickBooks workshop. Save your seat here: CandusKampfer.com/workshop
Have a great day,
Samantha, Team Candus
Do you have a video that shows how to enter payment when the merchant fee is added to the customer invoice but it was higher than the square fee taken out?
Hello,
Sorry, we don't currently have a video on this. I will add your question to the list Candus uses to create new QuickBooks tips each month.
The best possible way for you to receive support from Candus is to register for and attend her workshop.
Here is the link to register to attend: canduskampfer.com/workshop
Have a great day!
Kindra ~ Team Candus
P.S. We’d love to connect with you! Find us on ↓
Instagram: instagram.com/candus.kampfer
Facebook: facebook.com/CandusKampfer
TikTok: www.tiktok.com/@canduskampfer
THANK YOU!
Hi Casey,
I'm so glad you found this video helpful 🥳
Have a great day,
Samantha, Team Candus
Hi Candies. I accept deposits through Venmo and they charge a fee. I have been accepting the payments through the bank download. It already takes out for the fees. I think I have to input each one with the negative number for the merchant fee. does this mean that my revenue will increase, because what is downloading is not true amount that I am charging?
This video was super helpful!!
But, now I'm having trouble getting the manual deposit we to match with the square deposit. I originally didn't have the Square processing fees on the customer invoice but it wouldn't match. So I tried adding the Square processing fee to the customer invoice then doing the process you showed in the video and it seems to have worked. However, im concerned about having the Square processing fees on the customer invoice and having the Square merchant fees on the bank deposit. Is it an issue to have the fees in both places?
Thank you for watching our videos 😊
The best possible way for you to receive support from Candus is to register for and attend her workshop.
Here is the link to register to attend: canduskampfer.com/workshop
Have a great day!
Ednalyn ~ Team Candus
P.S. We’d love to connect with you! Find us on ↓
Instagram: instagram.com/candus.kampfer
Facebook: facebook.com/CandusKampfer
TikTok: www.tiktok.com/@canduskampfer
I found your video super helpful! I now know what I was missing when doing my books for my merchants that have fees. I do have a quick question. When I am creating my bank deposit and splitting between the merchant fees and undeposited funds. Would I also split out the sales tax that the customer paid with the purchase?
Actually now that I am thinking about it, the Sales Receipt already has Sales Tax Payable. Clearing it would be when I pay the Sales taxes to the State right?
Hi Jennie, Yes, that's perfect!
If you'd like to learn more about how to customize QuickBooks to your business, you learn more here: ConfidencewithQuickBooks.com
Have a great day,
Sam, Team Candus
Hello @CandusKampfer, My first month without my bookkeeper. I followed the very detailed video; thank you! However, QB automatically marked the invoice as paid in full and does not appear in the receive payment section. How can I capture the Bank Fee Expense?
Hi Amanda,
Thanks for reaching out.
Woo hoo! I'm so glad you found this video helpful 🤗
If the fee comes out of the daily deposits vs a monthly fee, you do it in the deposit.
If you’d like to learn more about how to optimize QuickBooks for your business, I recommend
checking out our Confidence with QuickBooks program. To learn more you can attend our Customizing QuickBooks workshop. Save your seat here:
CandusKampfer.com/workshop
Have a great day,
Samantha, Team Candus
omg! your awesome.
Hi @JBoice4617,
Oh my gosh, thank you so much! We love hearing this. 🙏🏻
If you haven't already joined our weekly QB Tips & Tricks, click here to join, and we'll send you our tips straight to your inbox: canduskampfer.com/weeklytips
Have an amazing day!
~ Team Candus
P.S. We’d love to connect with you! Find us on ↓
Instagram: instagram.com/candus.kampfer
Facebook: facebook.com/CandusKampfer
TikTok: www.tiktok.com/@canduskampfer
I'm an independent hairdresser and on a cash basis accounting system. I enter all my daily transactions into a memorized journal entry daily. This was set up by a CPA years ago when I had a bigger salon. I now work from home, so I've been trying to handle all the accounting by myself and not doing as good of a job as I'd like. One of my struggles is with the merchant information and reconciling the merchant account. I've looked back at how the CPA was closing the account out every month, but not understanding it all. I know how to reconcile my bank statement and credit card statements, but I struggle with how to handle the statement from my merchant account. Is there a video on this anywhere on youtube or on your website?
Hi Melinda,
The problem may be that the merchant deposits do not match the actual bank deposits? This can happen if you're not "depositing" the same amounts in QB as what the merchant is. If you are using sales receipts/invoices to accept payments, you can deposit them into Undeposited Funds and then checkmark all of the payments in the deposit screen minus the merchant fee into the bank account at the same time to match what was actually deposited. Then reconciling should be a breeze. Here is a video on Undeposited Funds that may help: czcams.com/video/cKm2ZaDLC8M/video.html
Have a great day!
Kindra ~ Team Candus
P.S. We’d love to connect with you! Find us on ↓
Instagram: instagram.com/candus.kampfer
Facebook: facebook.com/CandusKampfer
TikTok: www.tiktok.com/@canduskampfer
Is there any way to do this from a deposit versus an invoice? I don't use the invoice feature in Quickbooks. Thanks!
Thank you for watching our videos 😊
I will add your question to the list Candus uses to create new QuickBooks tips each month. If you haven't already joined our weekly QB Tips & Tricks, click here to join and we'll send you our tips straight to your inbox: canduskampfer.com/weeklytips
Have a great day!
Ednalyn ~ Team Candus
P.S. We’d love to connect with you! Find us on ↓
Instagram: instagram.com/candus.kampfer
Facebook: facebook.com/CandusKampfer
TikTok: www.tiktok.com/@canduskampfer
Pinterest: pinterest.com/canduskampfer/
I would LOVE this information as well! Is this addressed any where yet?
Hello Candus,
I have been looking for a solution for a different problem i am facing
In my store i accept utility payments for customers like power bill, phone bill and water bill. I use a website to process the payments and on my QuickBooks i cannot record it properly as it shows as 100% profit. Is there a way to make an item that isn't inventory nor service but based on percentage?
Thank you
Hi,
Thank you for watching our video.
If you're interested in more in-depth training on how to handle this, I recommend checking out our Confidence with QuickBooks program. To learn more you can attend our Customizing QuickBooks workshop. Save your seat here: CandusKampfer.com/workshop
Have a great day,
Samantha, Team Candus
Hi @Candus Kampfer Can yio please help me to record a Merchant Fee Income (Charge to Customer) correctly?
Hi @user-hd1pt8oc9t,
Thank you for watching our videos 😊
The best possible way for you to receive support from Candus is to register for and attend her workshop.
Here is the link to register to attend: canduskampfer.com/workshop
Have a great day!
~ Team Candus
P.S. We’d love to connect with you! Find us on ↓
Instagram: instagram.com/candus.kampfer
Facebook: facebook.com/CandusKampfer
TikTok: www.tiktok.com/@canduskampfer
What would you do if the merchant fee appears in bank statements as its own separate transaction? Every time I try to categorize it, it categorizes it as a cheque.
Hi,
Thanks for reaching out.
Enter it in manually through an expense or in the bank feed. It will go against merchant fees (or whatever you want to use).
If you’d like to learn more about how to optimize QuickBooks for your business, I recommend checking out our Confidence with QuickBooks program. To learn more you can attend our Customizing QuickBooks workshop. Save your seat here:
CandusKampfer.com/workshop
Have a great day,
Samantha, Team Candus
What if my fees are taken out of my bank account in a separate transaction?
Hi Tammy,
Thank you for reaching out.
You would need to do them individually.
If you'd like additional support, you can check out our Customizing QuickBooks workshop here: CandusKampfer.com/workshop
Have a great day,
Samantha
Team Candus
What if I charged my customer the fees? How do I record that?
Hi Joann,
Thank you for watching our video.
If you're interested in more in-depth training on how to record your fees when you charge your customer, I recommend checking out our Confidence with QuickBooks program. To learn more you can attend our Customizing QuickBooks workshop. Save your seat here: CandusKampfer.com/workshop
Have a great day,
Samantha, Team Candus