cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
RTBrew
Level 1

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

 
Solved
Best answer March 15, 2021

Best Answers
Alex M
QuickBooks Team

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

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.

View solution in original post

6 Comments 6
LeithG
Level 7

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

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 M
QuickBooks Team

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

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
Level 7

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

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!

Alex M
QuickBooks Team

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

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
Level 7

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

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.

Alex M
QuickBooks Team

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

Hi there LeithG,

 

It's good to hear back from you. I can provide some clarifications on the article in order to help you get to matching those transactions with a difference.

 

When going to the Banking tab to do this match, Match won't be written in the rightmost column since the amounts are not the same. Click on the Description of the transaction you want, then it will open up an expanded menu underneath the row. There will be an option to Find Match which you can select, which will bring you to a page to help you match. Make sure that the transaction located in QuickBooks is within those dates, if not you can adjust the timeline. 

 

Once you've found the transaction you're looking for, click in the checkbox to select it and there will be a difference locate at the bottom right of your screen. You can select the Resolve option, which will open up a menu at the bottom where you can enter the amount as well as the account in which you want to send the difference. Since you're wanting to deduct this amount from the transaction as a service charge, make the amount negative. After entering the amount, the difference should now be zero, and it should let you save.

 

I hope these tips will help you be able to use the resolve feature to make matching easier for you. Let me know if you're in need of an more info. I've got your back.

Need to get in touch?

Contact us