QuickBooks, Excel, Cash Flow, and Technology

QuickBooks Tip – How To Record Payment Processing Fees

Posted by:

QuickBooks Tip – How To Record Payment Processing Fees


A common problem people have when recording payments received from customers in QuickBooks is when fees are taken out prior to the payment funding so that the net amount received is less than what the customer actually owed and paid.

YouTube Preview Image

When this happens you go to record a payment from the customer and if the customer paid (eg) $5,000 you only received $4,855.00 because the payment processor took out 2.9% or $145.00. The problem is if you only record $4,855.00 as the payment received then it will look like your customer still owes you $145.00 when they don’t.

The problems:

  1. The customer paid the full amount.
  2. We only received the amount net of fees.

The trick is that we have to stop taking these forms so literally. The Receive payments screen in QuickBooks in more generic terms is where we give a customer credit for having paid the full amount of their invoice, regardless of what we have received. Now the temptation here is going to be to record a discount in order to account for the fee. This does have to be taken literally. I don’t like doing it that way. It works but it tells the wrong story. We did not give the customer a discount, we were charged for the privilege of getting paid via credit card or some other electronic means. That’s the story we want to tell and the answer is actually really simple.

Here is your answer:

  1. Process the payment as though you received the full amount of the customer’s payment, and make sure it goes into the Undeposited Funds account. Problem 1 solved.
  2. Record the deposit. Initially you will have the whole $5,000. Add a line item for -145.00 (yes a negative number). Under “From Account” book it to “Credit Card Processing Fees” or whatever equivalent account you use. Problem 2 solved.

This tells the right story. The customer paid me in full but before I received the funds my payment processor took their cut.

Please post your comments and questions below! If your question warrants it, I will record a video reply.

24


About the Author:

I started Nerd Enterprises, Inc. in 2003 and continue to work with individuals and companies to cure their financial headaches. Training, writing, blogging, social media and generally building communities around these areas as well as technology has become another passion of mine.

Discussion

  1. INEZ  May 1, 2013

    Thank you so much! This tutorial was simple to understand and made perfect sense.

    Here’s my follow up question: Moving forward, this is a no brainer to implement and would be a tremendous asset to our company. Is there anything that can be done for invoices/payments of months and even years past? Are those invoices doomed to stay open with minimal amounts on them forever?

    Thanks again!

    -Inez

    (reply)
    • NERD  May 1, 2013

      Write them off with an entry in the current year. Book it to some expense / loss account.

      (reply)
      • INEZ  May 1, 2013

        How would you suggest going about this? It would have to be entered as a received payment to match the open invoice, right? Would I then go to deposit the money and reflect it as wire losses are you showed in this tutorial?

        Here’s a good example of what’s been happening:

        We get money wired in. The company pays the full amount and the third party bank takes a fee. It is usually 20-25 dollars per wire. The bookkeeper before me would enter the net amount and this has left invoices open with balances of 20-25 dollars. There are multiple companies in this situation and one company with about 15 open invoices this way. The company currently knows they are because of the fees and kind of just overlooks it. But it bugs me and is not a true representation of what has been paid. I would love to correct this, but fear it might affect years worth of taxes or financial statements.

        I don’t know if I should leave what has been done in the past as is and then implement this new method from this point forward.

        You have been such a tremendous help.

        Thank you again!

        (reply)
        • NERD  May 5, 2013

          Going forward you handle it the same as the CC processing fee only it goes to Bank Service charges instead of CC processing fees. Cleaning up the past might be tricky. If your returns have already been filed and you file on a cash basis then your income was understated (by the amount of all the fees which were left as unpaid amounts on the invoices. At the same time your CC processing fees (expenses) were understated so it’s a bit of a wash. Best thing to do is probably record an entry on Jan 1 of the current year writing off the balances (because it’s really a wash between income and expenses in the end). Instead of using “Bad Debt Expense” as the account to write it off to (Debit) use Bank Service Charges. The journal entry will post in the current year which will cause the cash basis income from those invoices (the previously unpaid portion) to show up as income in the current year and then that will be offset by the Bank Service charges which will also show up as on 1/1/13.

          (reply)
          • INEZ  May 7, 2013

            Thank you again! You have been super helpful. Do you have an email address where I could ask a more specific question?

            Thanks again!

          • NERD  May 7, 2013

            Umm. You’re on my website. Just have a look way over top right and use the contact us form? Or scroll all the way down to the bottom and all of our contact info is listed there.
            Or you see that old fashioned looking phone on the right? Give that a click and give us a call!

  2. LEIMAN  June 27, 2013

    Hey Seth,

    If I just wanted to post a whole month’s worth of fees would i just do a journal entry? I basically do not want to record the fees one transaction at a time. Any suggestions? Thanks!

    Leiman

    (reply)
    • NERD  June 28, 2013

      The only problem with that is that it is not how your bank is charging you so your reconciliations will be come more challenging. If you are off in reconciling you will have no way of knowing if you mis-keyed the amount of a fee in adding up the whole month without going back and re-keying that. So I think it’s better to follow the banking when you post your fees, but outside of that sure you can post a monthly entry. The expenses will be correct by the end of the month.

      The other thing to consider is your bank balance. If the bank takes the fees out of every transaction and you are posting the gross amounts of your transactions then your bank balance will be overstated until you post the fees at the end of the month.

      (reply)
  3. GANDALF  July 30, 2013

    “This tells the right story.” Thank you for pointing this out. I try to explain to clients all the time that we can’t combine transactions, or skip steps, or just summarize. We have to show every part of what happened.

    I only recently started taking electronic payments. Say what you want about Intuit (I sure have!), but Intuit Payment Network is the best electronic option that I have found. I started out using Dwolla, but my first Dwolla payment took 10 calendar days to find its way to my account! Thanks, “Nerd”, for your helpful illustration.

    (reply)
    • NERD  July 30, 2013

      Thanks! I still love PayPal. It’s easy and contrary to what many people think because they’ve been “duped” by the other payment processors, it really is about the least expensive processing option out there.

      (reply)
  4. ANDREA  October 17, 2013

    How would this work for GST?
    The payment processor takes out transactions fees and also a commission, both of these have a GST component. Although I’m not registered for GST, it won’t be long before I will and I need to track the GST paid.

    (reply)
    • NERD  October 19, 2013

      GST is like sales tax. If they deducted it from you then you should show that deduction as a reduction from the gross payment (just like a processing fee) and then it should go to some balance sheet account so that when you go to pay your GST you can deduct that amount as having already been paid.

      (reply)
  5. DWIGHT  February 4, 2014

    Thanks for the process to enter credit card fees. My CC processor charges a percentage plus a transaction fee. The formula in Excel is (Invoice Total *.029)+.15. Is there some way to have Quickbooks calculate this fee from the invoice total?

    (reply)
    • NERD  February 9, 2014

      Unfortunately there is no way to get QuickBooks to produce a calculated field like this! You can do the math right in QuickBooks as you are entering the transaction though.
      Check this video here: How to Do the Math in QuickBooks

      (reply)
  6. SHANA  February 20, 2014

    I have a situation that still confuses me after reading your post…

    - we are a newspaper company
    - We accept credit cards- not through quickbooks but a different merchant.
    - We have customers that pay on their invoices, buys subscriptions, buys print jobs, ect with credit card.
    - I understand about how to apply the payment to the invoice and applying a negative number for the fee in the deposit window….
    - what about those that come to the window and buys a print job? How do i initially get that in QB? Do i have to create an invoice for each person that does this? Some days we have 5-10 other days 0.

    - I’m also having trouble matching up the customer credit card payments with what has actually been deposited in our account bank account (due to fees taken) whats your suggestion to make this process easier?

    (reply)
    • NERD  April 8, 2014

      Hi! Normally you would create a sales receipt in QB for each buy.
      When the CC company takes out the fees before funding (ie they fund net) it creates an accounting nightmare. The first thing I would do is call your processor and tell them you need the payments funded gross and the fees taken separately. Tell them you’ll find another processor if they aren’t willing to do it. It’s THAT important.
      Meanwhile what I have done in these cases is (1) get online access to the processor and then (2) make their customer service rep stay on the phone with me and help me tie out every single deposit from Gross to net. This way you don’t have to struggle and they can share in the “burden” in terms of the cost of the time you need to spend figuring out their mess!

      (reply)
  7. BRIT  March 13, 2014

    When entering multiple invoices under a payment it keeps jumping back to the top opposed to just letting me click each one. If i look each one up then it doesn’t jump back to the top. This is very frustrating and consumes a lot of time. I used to be able to just keep going down consecutively entering my discounts. Please help!

    (reply)
    • NERD  April 8, 2014

      I would really have to see what you’re describing to be able to help. I’m not sure I’m clear on what is going on. When you are in the receive payments screen you should be able to enter the amount, and then if necessary click “unapply payment” (if QB hasnt applied it correctly). Then you should be able to check off the invoices and scroll down as needed until you’ve applied the whole payment.

      (reply)
  8. ADISACK  April 7, 2014

    How does this work for QuickBooks online? Also, when there’s no invoice for the client, how do I handle this? For example, my customers went on a website and paid for my product. If I sell the product for $500 but only got a payment of $475 because my CC payment system has already taken out their fees of $25, how do I record this transaction.

    Thanks.

    (reply)
    • NERD  April 8, 2014

      It works the same in QBO. The screens look a little different but it basically looks the same.
      If you have web sales there are a few ways people handle this. Often times a single customer is created called “Web Sales” and you book sales receipts for that customer for each sale. Otherwise you book 1 invoice for the entire day and the book individual payments on that invoice for Visa/MC, Amex, and any other payment method that will ultimately fund together.

      If you REALLY want it simple and using your example.. Book a deposit with 2 line items. Sales (Income) for the gross sale of $500.00 and then a second line item for -$25.00 booked to CC Processing Fees. This way your deposit will net out to the right amount that actually went into your account and your sales will be accurate as will be your CC Processing Fee Expense.

      (reply)
  9. MATT  April 8, 2014

    Hello Nerd,

    I don’t mean any disrespect, but this method of recording payment processing fees (or in my case wire transfer fees) separately in the Make Deposits screen, is Nonsense. Don’t get me wrong, it works. But it is needless extra work. And, it is not a true reflection of what occurred (more in the case of wire fees).
    QuickBooks is set up to record these fees seamlessly in Receive Payments. In my case, the wire payment comes in as a net amount with the fee already deducted. In QB, you can receive the payment as the net amount. Select to Receive payment, enter the net amount. In the receive payment screen, select Discounts and Credits, and choose your Wire Fee expense account and enter the amount of the fee. Save and Close. This records the payment correctly to match your bank statement and records the expense correctly offsetting the total amount of the invoice. More importantly, there are no extra screens to go to as in your method. Also, I record the payment when it occurs. A few days later, I do a make deposit for all credit cards that cleared that day for that type of card, as it does on the bank statement. Easy peasy.
    As for payment processing fees, I record these separately as an expense for the total amount, also as it occurs on the bank statement. To be honest, we don’t care about offsetting the customers payment. I look at it as this is our service that we pay for. And I’d rather make it less complicated than more. I have more important things to do. But that is our choice.

    Regards, Matt
    QuickBooks ‘Master’ (7 yrs as QB TechSupport)

    (reply)
    • NERD  April 8, 2014

      No offense taken. First and to be clear. The method I am showing only applies when the fees are taken out prior to funding into the bank account. If the fees are paid separately then of course they should be recorded separately as you point out in your comment.

      When the fees are funded net, however - the main reason I disagree with you on this, probably comes from having been an auditor – using a discount tells the wrong story. It suggests I gave my customer a discount instead of what really happened, which is I incurred an expense for the privilege of processing payments via credit card or wire.

      If you ever want to sell your company, or get financing from a bank and they dig deep enough into your books it can raise questions (and even doubts) which can be avoided by booking it the way I’m suggesting.

      In reality, it’s not a whole lot of extra work. You’re already booking a payment on the invoice. Then you still have to record the deposit. All you’re doing here is adding a line item in the deposit to show the “right” story – that you didn’t get that full customer payment because a fee was deducted.

      (reply)
  10. ELISE PEREZ  April 14, 2014

    Hi Seth! Thanks for the awesome tutorial! My question is are we allowed to charge the customer the credit card processing fees, and if so, what kind of item would be created for this ‘other income’ that we receive or would we just list it as part of the sales income? Example, sale is $1500, and we are charged 2.75%, so the total we will be charged by the credit card processor is $41.25, our we allowed to tell the customer that the sale price is $1541.25? Or is this against any laws? I was signed up for Intuit’s Go Payment credit card processor but had to cancel my monthly subscription because it wasn’t in our best interest, as most of our customers pay via cash or check. I guess my concern is for large amount sales transactions, do you have to just foot the bill for these credit card costs?

    Thanks!
    Elise

    (reply)
    • NERD  April 20, 2014

      Hi Elise. You can’t really tell the customer you are charging $1,541.25. Keep in mind also that the CC processor is now going to charge you 2.75% of THAT number which will be a little more than the $41.25. Of course you can charge a “convenience fee” for people who want to pay with a CC. That would be an item linked to an income account for (eg) Convenience Fees.

      (reply)

Add a Comment