cancel
Showing results for 
Search instead for 
Did you mean: 
userdeanswindowclean
Level 2

Can invoices from a merchant be reconciled with bank deposits that have credit card fees deducted?

We use Jobber for our client interface which allows them to pay with a credit card. Quickbooks is pulling invoices from Jobber while also recording the corresponding bank deposits. Those deposits have merchant fees deducted so the amounts are different from what the invoice shows. That means we have duplicate transactions which misrepresents our income and throws off our reporting. Do I have to manually edit the amount of each invoice to match the corresponding deposit? If so, will that reconcile them and remove the duplicate transactions?
1 Comment 1
Mark_R
Moderator

Can invoices from a merchant be reconciled with bank deposits that have credit card fees deducted?

I've got you covered, @userdeanswindowclean.

 

When matching deposits with credit card fees to the invoice, you don't have to edit each invoice to match it. You have two options to handle credit card fees to allow you to match your invoices to the deposit.

 

First, you can utilize the Resolve Difference option. This helps match your transaction through its difference until it will be equal to zero. Here's how:

 

  1. Click Banking from the left menu.
  2. Select the bank account, then go to the For Review tab.
  3. Select the Find other records or Find match button to open the Match transactions window.
  4. By default, the Match transactions window lists All transactions within the date range, but you can narrow the results.
  5. Use options on the Show drop-down menu to specify the type of transaction you're looking for.
  6. If the amounts are different, you can locate additional matched transactions, or select Resolve Difference to open the Add resolving transaction fields to add the Category and Amount (and, optionally, Payee) of a resolving transaction until the difference equals zero.
  7. If necessary, you can use the Add new transaction button to add multiple resolving transactions.
  8. Hit Save.

 

Also, you'll want to create a bank deposit for the credit card fee less than the amount of the invoice. This way, you can match this transaction to the bank deposit.

 

I'm also adding this article to learn more about reconciling accounts in QuickBooks: Reconcile an account.

 

Please keep in touch if there's anything else I can do to help you succeed with QuickBooks. I've got your back. Have a great day!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us