Skip to main content
March 15, 2021
Solved

How do most companies deal with payments via credit card not matching up up with the original amount invoiced?

  • March 15, 2021
  • 3 replies
  • 0 views
Original commenter did not share additional details
Best answer by Alex M

Hi there RTBrew,

 

I'm happy to hear you're using the connection to your bank in QuickBooks Online. It's a feature that saves you time and makes it easier to categorize your transactions. It's vital that the processing fees on your credit card payments be accounted for in order for your bank balance to be correct. I can provide some insight into this.

 

As explained by lashedlifter, you can add the fees when you create the deposit of your payment. This article about How to account for Bank Fees when matching transactions in Bank Feed goes into detail on how to add those fees when matching.

 

If you don't currently have an expense account to keep track of the credit card fees, you can add it by navigating to the Accounting option in the left column, then selecting Chart of Accounts. Click the New button in the top right, then choose Expense as the Account type, and Bank Charges as Detail Type. Pick a name for the account and Save.

 

I hope this helps you in matching your sales to your invoices already in QuickBooks Online. If you have any questions or need more information, please reach out here.

3 replies

LeithG
March 15, 2021

Hi RTBrew

 

The only difference should be the credit card commission fees - often between 1-3% depending on the card.  If the discrepancy is larger than that, it may be due to exchange charges from the credit card company as well.

 

As with deposits from wires where you get wire fees, you would record the deposit against AR in full, and then add adjusting (split) negative values for the fees which get recorded to your card fee or exchange loss/gain account as necessary.

Alex MAnswer
March 15, 2021

Hi there RTBrew,

 

I'm happy to hear you're using the connection to your bank in QuickBooks Online. It's a feature that saves you time and makes it easier to categorize your transactions. It's vital that the processing fees on your credit card payments be accounted for in order for your bank balance to be correct. I can provide some insight into this.

 

As explained by lashedlifter, you can add the fees when you create the deposit of your payment. This article about How to account for Bank Fees when matching transactions in Bank Feed goes into detail on how to add those fees when matching.

 

If you don't currently have an expense account to keep track of the credit card fees, you can add it by navigating to the Accounting option in the left column, then selecting Chart of Accounts. Click the New button in the top right, then choose Expense as the Account type, and Bank Charges as Detail Type. Pick a name for the account and Save.

 

I hope this helps you in matching your sales to your invoices already in QuickBooks Online. If you have any questions or need more information, please reach out here.

LeithG
March 15, 2021

Hey Alex M

 

That's a cool feature on the matching I didn't know existed!  I've always just entered the transaction and used the Split function, and append a negative amount for the bank fees.  This is definitely simpler, I'll have to try this next month!

March 15, 2021

Hello lashedlifter,

 

I'm happy to hear that the article helped you as well. If you have any questions about the steps, feel free to let me know.

LeithG
March 19, 2021

Hi Alex

 

I went back to try this on one of my transactions, but it doesn't seem to be working; there's no option to match on the bank transaction.