QuickBooks Online: Recording a Deposit minus Merchant fee

[@kevinsmith475]

quickbooks customer service and community was absolutely zero help, You just answered my question and perfectly explained exactly how to do what I need to do in 3 minutes, after 45 minutes of my own research coming up empty. THANK YOU!!!!

[@cfin1985]

Wow, I watched 5-10 KZbin videos on merchant fees before stumbling across this one. None were as clear and concise as yours. Liked video and subscribed to your channel. Thank you so much!

[@HectorGarciaCPA]

Thank you for subscribing and liking the videos, also share! Thanks

[@BD-jy1pn]

Short, clear and to the point... perfect for us busy folks trying to juggle it all. Had to say thank you!

[@HectorGarciaCPA]

:)

[@ThioJoe]

Exactly what I was trying to figure out. Had a wire transfer fee that was taken out of an invoice payment.

[@HectorGarciaCPA]

Yeap

[@HectorGarciaCPA]

If you ever need a new accountant let me know. I specialize in KZbinrs

[@shawnmalone204]

You just saved my day with this video! Not the first time you've solved a problem I've had. Love how clear your instructions are.

[@HectorGarciaCPA]

Happy to hear that!!

[@danielruiz2576]

Thank You! This is by far the best and easiest way this has been explained that I have found.

[@HectorGarciaCPA]

Great!

[@TracyTate-w9c]

this is really helpful for a variety of scenarios. i was trying to use it to resolve the discrepancy on rideshare payments that deduct fees before they deposit money to the driver.

[@machetay]

Thank you so much! I called QB support about this exact issue and they had no idea how to clear out the invoice if the payment did not exactly match. Your video solved my matching/invoice issue!

[@RamosAccounting]

You are the best Hector. Thanks for another great solution. It still working after two years.

[@HectorGarciaCPA]

Yeah, it hasn’t changed

[@christhompsonphotography6783]

Hector, where do I give you a hug? I've been searching for this for a while now. :D Thank you!

[@HectorGarciaCPA]

Awesome

[@MotoMatsalleh]

thanks

[@HectorGarciaCPA]

:)

[@MattHarper]

Great for manual work, but you can't memorize/automate using either of these methods because 1) You can't apply a negative remainder to memorized transaction. QBO just doesn't allow it for whatever reason. And 2) on an invoice, QBO expects the reduced amount and you have to manually "resolve" it and you can't memorize/automate that. This is a big problem for the many, many businesses that have recurring, identical transactions that could be completely automated if QB's allowed for a negative number as the remainder on a memorized transaction.

[@HectorGarciaCPA]

Its a big opportunity

[@LuisPerez-tb1qs]

Question: In the case of an invoice the recording of the income is perfectly fine however resolving the difference implies creating an expense which will directly affect your bank account with an expense. When reconciling wouldn't this create a discrepancy since that money does not appear in the list of expenses for that month, (in reality the money never touched the bank account)?

[@FnRockstar85]

Thank you, Hector!! I appreciate your videos so much!!!

[@beatrizborquez6116]

THANK YOU SO MUCH!!!!! YOU ARE SO HELPFUL

[@HectorGarciaCPA]

:)

[@chloealix8063]

Hmm, but how/where are you actually finding and matching the merchant fee to the split line item. Meaning, if there is a $90 merchant fee from stripe and it's also coming through to the bank feed along with the deposit, how do you match those or reconcile them?

[@Luxxen101]

You are my Quickbooks god!! Thank you!

[@HectorGarciaCPA]

Im fine with “guru” Not “GOD”

[@liezld.6743]

Exactly what I'm looking for! Thank you so much Hector!

[@HectorGarciaCPA]

:)

[@Googlereviewer-s8w]

We need help. I love this video but it does not fix our issue. We have overdue amounts that are actually bank fees. When we transferred from desk top to online the fees did not transfer correctly. now we have many overdue bank fees that show up as the company still owing us money. Any ideas how we can fix this?

[@everydayinsurance7153]

Thank you! This is the answer I've been looking for

[@HectorGarciaCPA]

Great

[@ChrisMcGrory0513]

Very clear instructions. Thank you for making this video!

[@HectorGarciaCPA]

:)

[@nixonleonardo838]

Hi, I have a question. I did purchase GPS traker for my trucks. What GL should I use in QB thank you.

[@widowhoodrealtalkwithtina]

Thank you so much! This solved a big issue I was having!!!

[@HectorGarciaCPA]

Great

[@ReneeGriego-TheBookkeeper]

You are a life saver

[@HectorGarciaCPA]

:)

[@midlife_minimalist]

Thank you! My instinct was right. I was doing them exactly like that. I keep seeing others create a manual deposit and match that to the invoice or sales receipt and add the fee there and then match the manual deposit to the bank feed deposit and I’m like what is the benefit of the bank feed if you are just going to manually enter??

[@HectorGarciaCPA]

Well… these are special transactions.. the benefit is on the other ones

[@debihancock6603]

This was great. 1 question: I did the 1st option/split method. The deposit that went to the bank register isn't the bank deposit total but the split totals. (the customer's full payment is deposited and the fee appears in as a separate payment. This will make reconciliation difficult. Did I do something wrong?

[@HectorGarciaCPA]

It will net out

[@hollythecrossstitchaddict83]

Hi, I'm having a blonde monment. I use sage, but I can't find anything to help me. If my client paid the invoice in full $700 which is what the invoice was, but I only receive $696.60 because VENMO took $13.40 in fees, how do I do a general journal to account that my cient paid in full but the fees were taken so only $696.60 was received, I know this but I'm drawing a blank! Do I just receipt the invoice in full and the dr bank charges a/c and cr the bank account for the difference?

[@HectorGarciaCPA]

You can adjust A/R against CREDIT that invoice for the difference, and use “merchant fees” as the debit

[@nathanaeljean-julien517]

Hi Hector, thank you for all this info. What should i do if the merchant fee is a percentage ? And can i do this with multiple entries ? Im using quickbooks desktop

[@YourDigitalSpaceman]

Yes, same question - I don't see a way how to resolve the difference and assign different fees to different clients when the deposit consist of multiple different client payments on the same day.

[@shahramtoopal3332]

Thank you so much ❤

[@HectorGarciaCPA]

You're welcome 😊

[@edemtogbey4861]

Thank you for sharing this info

[@JaniceAbado]

Do you have a video for the same problem but with foreign currency?

[@HectorGarciaCPA]

I dont do any videos on foreign currency sorry

[@marygraceayon2441]

Hi Hector! Thank you for all the info. Does this workflow also applies to foreign bank accounts? Thanks for answering.

[@HectorGarciaCPA]

Dont know

[@marticastlewarr5723]

What if it's a merchant fee that was paid by the customer and the Client is discounting his invoiced amount by the amount of the merchant fee?

[@HectorGarciaCPA]

Make an adjustment to the invoice to match

[@SkibidiMomm]

What if I already added the deposit in sales? I need to make a journal entry to fix it.

[@HectorGarciaCPA]

Or adjust the deposit

[@Cmtinker]

I use a CRM that processes payments through Square. Syncing with Square just duplicates the deposits my bank feed is already showing. This is the only way I’ve found to account for merchant fees. Wish there was an automation or an easier way? @hector, I really appreciate all of your quality content!

[@HectorGarciaCPA]

I wouldn’t recommend syncing square, its not designed to work with bank feeds combined

[@mr.dovahkiin5335]

This is really helpful! In my case I am receiving a partial payment with fees taken out. How do I apply that to the open invoice?

[@HectorGarciaCPA]

Receive the full Payment for the invoice into undeposited funds, and then use the technique from the video to reduce the fee

[@JP-ht5vgh]

Hello Mr. Garcia, Why did you not use the same split method in the 2nd example? They both had been short paid and both needed an extra negative line, what is the difference?

[@HectorGarciaCPA]

I dont think adding a negative line in an invoice is advisable

[@JP-ht5vgh]

@@HectorGarciaCPA So, the 1st example was not an invoice? was it a payment and i missed it?

[@maude6497]

Hi Hector. learning a lot from you! does this process to match with merchant fee also applies for paypal payment for shopify orders? thanks for answering

[@HectorGarciaCPA]

No… there is a clearing account process that you need to follow it’s probably easier for larger volume .. HOWEVER, if the volume is low, then is ok to use this process

[@maude6497]

@@HectorGarciaCPA thank you! will take it from you. :)

[@davidbernhardt551]

Hi! If I'm only selling online, through a merchant account, wich merges all the payments I receive and the merchant fees as well daily, how do i account for the merchant fees? I can do the split, but what about the method with the invoice and the resolving? I mean, there is normally no actual invoice being made because of the transaction from my merchant account, it is only a transfer, or not? Should i just create an invoice as my merchant account as a customer regardless?

[@HectorGarciaCPA]

Would need to look at your file to see what issue you are having. This video still works today, is 100% relevant, so if you missed a step somewhere..

[@davidbernhardt551]

@@HectorGarciaCPA Thank you for your answer! I think i figured out what was the problem. Great video btw!

[@MaeA.-dj7ul]

how about if payment is received from stripe in foreign currency. invoice in cad $ while home currency is usd (us) less mercahnt fee?

[@HectorGarciaCPA]

Its a tricky one for sure :)

[@MaeA.-dj7ul]

@HectorGarciaCPA yes it was...the invoice was in cad $, and they paid it in usd account. I have amended the exchange rate in bank deposit to match with the payment received in the bank feeds less srtipe fees, but if I click find match, it was not in the foreign currency tab. How to fix this

[@Nicole-xb9ke]

bless you!!!!

[@HectorGarciaCPA]

:)

[@jasonliu6956]

How do I record bank fee for vendor payment

[@HectorGarciaCPA]

As “Bank Service Charges” or “Bank Fee Expense”

[@jasonliu6956]

@@HectorGarciaCPA How would I apply the same method but to paying vendors? Lets say bill is $1000, $45 is bank fee. So vendor will only receive $955.

[@Jmerlo21]

System-recorded fee for QuickBooks Payments. Fee-name: DiscountRateFee, fee-type: Daily. Is there anything i can do about these fees?

[@HectorGarciaCPA]

Delete them if they seem duplicates