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

How do I use a resolving transaction to account for payment processing fees that were taken out of a full payment of an invoice prior to its deposit in my account?

I've tried many times to use this feature, but when the resolving transaction I enter in the amount of the payment processing fees makes the total for the payment match the total on the invoice, I still keep getting an error msg that says, "The selected and downloaded transaction amounts don't match. To continue, resolve the difference." Is there something I need to do first before adding a resolving transaction?
20 Comments 20
Ryan_M
Moderator

How do I use a resolving transaction to account for payment processing fees that were taken out of a full payment of an invoice prior to its deposit in my account?

Hi @HollyJ,

 

Let me help you out with your concern about the Resolve difference feature in QuickBooks Online (QBO).

 

An alternative way I can suggest is to add this processing fee when you create an invoice. This way, you no longer need to resolve the difference later. 

 

You'll need to create an expense account and a service item to record the fees.

 

Create the expense account first:

 

  1. Highlight the Accounting tab.
  2. Select Chart of Accounts.
  3. Press New.
  4. Set the Account Type to Expenses, then set the Detail Type to Bank Charges. (You have the option to set the Detail Type to something else.)
  5. Enter a name for this expense account.
  6. Hit Save and Close.

Then, create the service item second:

 

  1. Highlight the Sales tab.
  2. Select Product and services.
  3. Click New.
  4. Choose Service.
  5. Enter a name for the service.
  6. Change the Income account drop-down menu to the expense account created above.
  7. Hit Save and close.

You can then include this service item in your invoices. 

 

If you want to continue using the Resolve difference feature, I suggest you open your browser's private window. It isolates the cache, which is the common factor of a browser's unusual behavior. 

 

  • Google Chrome: Ctrl + Shift + N
  • Microsoft Edge: Ctrl + Shift + P
  • Firefox: Ctrl + Shift + P
  • Safari: Command + Shift + N

If that works, go back to your regular browser, then clear its cache. Otherwise, open an alternative browser that's available for you.

 

Check out this article: Categorize and match online bank transactions in QuickBooks Online. It has the steps on how you can add, match, and review bank transactions.

 

Let me know if you have other concerns with your online bank transactions in QBO. I'll handle them for you. 

HollyJ
Level 2

How do I use a resolving transaction to account for payment processing fees that were taken out of a full payment of an invoice prior to its deposit in my account?

Ryan, thanks for responding.

 

A couple things—I can't know how a customer is going to pay for an invoice when I create it. Some customers pay by check, some by Paypal & some by credit card. All of those methods mean different processing fees that I can't calculate up front. So it's impossible to determine any applicable payment processing fees when I create the invoice. Consequently, your first suggestion doesn't solve my problem.

 

Second, I cleared my cache & attempted to resolve the transaction again this morning again as you suggested. But (see attached screenshot) it still gave me the same error msg saying that I need to resolve the difference between my invoice total and my payment total even though, with the resolving transaction of the processing fees, they do, in fact, match.

 

Do I need to do something special with the payment processing fees prior to adding them as a resolving transaction? I tried separately adding them as an expense prior to matching the payment to the invoice, but that didn't work either.

 

Otherwise, what is it that I don't understand about how to use QB's resolving transaction feature? Can you speak to how that specific feature works instead of giving me workarounds?

 

We're scaling up and will face this bookkeeping issue more and more often in the future. I want to streamline this process now, not have our work multiply unnecessarily when QB has a feature that should make it easy.

 

Thanks.

ReyJohn_D
Moderator

How do I use a resolving transaction to account for payment processing fees that were taken out of a full payment of an invoice prior to its deposit in my account?

I'll help match your transactions in QuickBooks, @HollyJ.

 

First, thanks for following the suggestions given by my peer above. I've got other solutions you can perform to get around the matching issue you're having.

 

Yes, you can't calculate those processing fees directly since you received those payments from third-party merchant services, like PayPal, etc. There are bank service fees that the credit card company will deduct from the payment. Thus, the payment amount that shows on the bank register won't match the deposit amount in QuickBooks Online.

 

In this case, you can enter the bank service fee amount directly into the register. This way, the register balance matches the bank statement balance. 

 

Here's how:

 

  1. Go to the Accounting menu, and then choose Chart of Accounts.
  2. Select the right account, and then click View register from the Action column.
  3. Add the bank service fee, and then click Save.
    q30.PNG

After that, you can now enter the fee as a negative amount on the Bank Deposits screen when depositing a payment.

 

To do that:

 

  1. Click + New, and then select Receive Payments.
  2.  Enter all the payment information, and then choose the checkbox next to the invoice you would like the payment to be applied to.
  3. Select the Undeposited funds account from the Deposit to drop-down.
  4. Click Save and close.
    q31.PNG

Then, it's time to create a bank deposit:

 

  1. Click + New again, and then select Bank deposit.
  2. Select all the payments you want to deposit.
  3. Go to the Add other funds to this deposit section, and then enter the amount of the bank service fee charged to you by the credit card company as a negative amount.
  4. From the Account section, select the Expense account you usually use in tracking bank fees.
  5. Check and fill out other necessary information.
  6. Click Save and close.
    q32.PNG

For more details, please refer to this handy article: Enter a bank service fee while using a third-party merchant service.

 

Next, you can do the usual matching process.

 

Also, QuickBooks will create an adjustment or journal entry when you use the Resolve difference feature. You usually do this when you're matching the same transactions, but their amounts don't quite add up.

 

When you're all set, you can begin your usual reconciliation. This way, you can ensure your books are accurate.

I'm still around to help if you need more banking insights. I'd be glad to extend a helping hand. Have a great day!

HollyJ
Level 2

How do I use a resolving transaction to account for payment processing fees that were taken out of a full payment of an invoice prior to its deposit in my account?

Thanks ReyJohn_D. I appreciate your help.

 

But I already understand how to make sure that the processing fees and the deposit are both showing up in my account via the method that you suggested.

 

What I'm trying to understand is how to use QB's Resolving Transactions feature when matching an invoice, instead of having to do this in the roundabout ways that you and your colleagues have suggested. None of the answers I've received have specifically explained how to use the Resolving Transactions feature that I'm having trouble with when I try to match an invoice to a payment and add an accounting of the payment processing fees via QB's Resolving Transactions feature.

 

As our transactions multiply, using QB's Resolving Transactions feature would be the cleanest way to solve my problem. So I'd really appreciate it if someone could reply to me specifically explaining to me what I'm doing wrong in using your Resolving Transactions feature instead of explaining workarounds that don't involve QB's Resolving Transactions feature.

ReyJohn_D
Moderator

How do I use a resolving transaction to account for payment processing fees that were taken out of a full payment of an invoice prior to its deposit in my account?

You're most welcome, @HollyJ!

 

I've got some insights about the Resolve difference feature in QuickBooks Online (QBO).

 

There may be times when a bank item amount (payments/bank fees) doesn't quite match the transaction you entered (invoice). When you go to the Banking page, they don't add up even though they're the same entries.

 

In this case, you can use the Resolve difference feature to match them and fix the payment differences until it equals to zero. 

 

Let me guide you on how to perform this task:

 

  1. Go to the Banking menu, and then choose the For Review tab.
  2. Find the said transactions, and then select the Find match button to open the Match transactions window.
  3. Look for and select the invoice payments to match. You can also use the filters to narrow down your search.
  4. Scroll to the bottom of the table, and then click the Resolve Difference button.
  5. Enter the processing fee details. Make sure the total is zero.
  6. Click Save when you're ready.


In case you run into some problems when reconciling your accounts, you can refer to this handy article to resolve them: Fix reconciliation issues in QuickBooks Online.

 

You can get back to me anytime if you have questions about handling your transactions. I'm still around to help you.

HollyJ
Level 2

How do I use a resolving transaction to account for payment processing fees that were taken out of a full payment of an invoice prior to its deposit in my account?

Perfect. Except as I've mentioned, that's exactly what I'm doing.

 

But when I do, even though the difference is $0, QB keeps giving me an error msg that says I still need to resolve the difference. (see attached screenshot)

 

Is this a glitch? And if so, how do I get it fixed?

Mark_R
QuickBooks Team

How do I use a resolving transaction to account for payment processing fees that were taken out of a full payment of an invoice prior to its deposit in my account?

Thank you for posting back and sharing a screenshot, @HollyJ.

 

I appreciate all the steps you've performed to resolve the payment differences, and I want to make sure this is taken care of.

 

At this time, I suggest reaching out to our QuickBooks Support Team so they can investigate why you're still receiving the error even though the difference is already $0 and provide additional troubleshooting steps to get this fix. They can also create an investigation ticket if other users are experiencing the same.

 

To reach them, click the ? Help button at the top right corner of your QuickBooks Online and select Contact Us to talk or chat with a live agent.

 

Just in case you want to learn more about matching transactions, feel free to check out this article for more guidance: Categorize and match online bank transactions in QuickBooks Online.

 

Please touch base with me here for all of your QuickBooks needs, I'm always happy to help.

HollyJ
Level 2

How do I use a resolving transaction to account for payment processing fees that were taken out of a full payment of an invoice prior to its deposit in my account?

Mark_R, thanks very much for your response. 

 

Unfortunately, we've already tried resolving this issue via QB's support chat, and it was one of the most frustrating customer service experiences we've ever had. My partner was on a 2-hr chat with one of your reps the other day who could not help her because he wasn't familiar with QB's Resolving Transactions feature and apparently neither was his supervisor. I've uploaded the transcript of that chat so you can see why we're very hesitant to go thru that process again because it was so time consuming and, ultimately, completely unhelpful.

 

Can get me in touch with someone at QB who's familiar enough with this feature to actually help us?

MaryLurleenM
Moderator

How do I use a resolving transaction to account for payment processing fees that were taken out of a full payment of an invoice prior to its deposit in my account?

This is not the kind of service we want you to have, HollyJ.

 

As much as I want to assist you with this, our QuickBooks Online support has better access. They can work with you remotely, and also report this error to our product engineers. The resolve transaction/resolve difference should work when trying to match the transactions. 

 

I recommend reaching out to them again.

 

Here's an article with a video tutorial for your reference: Categorize and match online bank transactions in QuickBooks Online. See more video tutorials about QuickBooks here.

 

If there's anything else that I can help you with, let me know in the comments.

HollyJ
Level 2

How do I use a resolving transaction to account for payment processing fees that were taken out of a full payment of an invoice prior to its deposit in my account?

Thanks very much, Mary. 

 

We'll reach out to them again. Can you suggest any terminology we could use that might expedite us getting assistance with it from them instead of wasting more time with someone who isn't familiar with the feature?

 

JoesemM
Moderator

How do I use a resolving transaction to account for payment processing fees that were taken out of a full payment of an invoice prior to its deposit in my account?

Thanks for getting back to us, @HollyJ.

 

You can use the Resolve Payment Difference as terminology when you contacted our support team. This way, they'll have an idea about your concern and look into this further.

 

Also, you'll have an option to request a callback and speak with a live representative. Just follow the steps below and they'll call you within 5 minutes after you've confirmed it.

 

  1. Go to the Help menu at the upper right.
  2. Select Contact Us.
  3. In What can we help you with?  box enter Resolve Payment Difference.
  4. Click Let’s talk, then  Get a callback
  5. Type in your contact info.
  6. Select Confirm my call.

 

To reach us on time, our Live Help is available from 6:00 AM to 6:00 PM on weekdays and 6:00 AM until 3:00 PM on Saturdays.

 

I'm also adding this article to further guide you in managing the growth of your business using QuickBooks: Help Articles. It includes topics about account management, banking, and expenses, to name a few. You can click the + More topics button to view other selections.

 

Please know that you're always welcome to comment below if you have other inquiries about managing a QuickBooks account. I'm just around to help. Take care always.

Dereeko
Level 1

How do I use a resolving transaction to account for payment processing fees that were taken out of a full payment of an invoice prior to its deposit in my account?

Hi @HollyJ 

Did you fix the problem? I have exactly in the same situation and getting the same error message. How did you fix the problem?

Regards

Derko.

indigo-digitaal
Level 2

How do I use a resolving transaction to account for payment processing fees that were taken out of a full payment of an invoice prior to its deposit in my account?

Hi Holly,

We are also having exactly the same issue. It's as if QuickBooks has never heard of businesses being charged credit card fees before! I have been trying for 3 hours to reconcile one transaction. We are new to QuickBooks (came from Xero) and nobody knows what I'm talking about. I have called and was told they can't teach us how to use the product. When I asked where I should learn...do they have a help center, video tutorials, anything? I was told that most of their customers have been using QuickBooks for years. In Xero, you just apply the deposit to all the invoices it paid for, then click the "adjustment" button when they don't equal the right amount, and you apply the balance to the "bank services" account. It is SO simple! How is this possible that we have baffled QuickBooks to the point that they are trying to find time-consuming work-arounds for us? And THANK YOU for posting this thread. I will be eternally grateful if someone can tell us how to do this in a normal way!

mgzimmermann
Level 1

How do I use a resolving transaction to account for payment processing fees that were taken out of a full payment of an invoice prior to its deposit in my account?

Hi @HollyJ,

 

faced the same issue and finally found a solution. The key is to have the Difference field in CERO. The validation is on that field. I had an invoice for $400 with a payment of $300 and the were $100 of bank fees and commissions.

 

1- In the Match Transaction page I selected the invoice I wanted to match the payment to. The app completes the PAYMENT column with the payment, $300. Change it manually to $400, as you want to pay the full invoice.

2- Clicked on Resolve Difference, selected the Category as Bank Fees and complete the amount column to $ -100.

3- The app calculates the Difference as $0. If you press SAVE you are good to go.

 

What is confusing is that when you click the invoice, it autocompletes with the PAYED AMOUNT, so you can never get a difference of $0.

 

All the best,

Martin

klangefeld
Level 1

How do I use a resolving transaction to account for payment processing fees that were taken out of a full payment of an invoice prior to its deposit in my account?

Did you ever find an answer to this?  I'm also having the same problem!

 

ShiellaGraceA
QuickBooks Team

How do I use a resolving transaction to account for payment processing fees that were taken out of a full payment of an invoice prior to its deposit in my account?

Thanks for joining us here today, @klangefeld.

 

I have some information about the Resolve Difference feature. While this option will help resolved your transaction fees, you'll want to contact our Customer Care Support. This way, we can add your account to the list of affected users. You will be notified via email on the updates of the resolution status.

 

Here's how to reach out:

  1. Go to Help at the top.
  2. Tap the Search tab, and then select Contact Us.
  3. In What can we help you with?  box enter Resolve Payment Difference.
  4. Click Continue.
  5. Choose either Chat with us or Callback.

Meanwhile, you can add the fees to the transactions manually as a workaround. Just edit the transaction and enter the fees as a line item. See attached screenshot below.

 

 

 

Also, you can add the fee during reconciliation. See this guide for details: Reconcile in QuickBooks Online.

 

 

 

 

Feel free to browse this link in case you need help with bank-related tasks. It has our general banking topics with articles: Find help with bank feeds and reconciling accounts.

 

Reach out to me again if you still have questions or concerns with invoices or fees. I'll be right here for you. Take care and have a nice day ahead.

Rita8of15
Level 1

How do I use a resolving transaction to account for payment processing fees that were taken out of a full payment of an invoice prior to its deposit in my account?

Thank you sooo much!  I was having this issue also and couldn't get any help from QBO support.   Seems like a simple fix, but certainly not logical.   I've use QB desktop for years and am having a horrible time converting to Online.   Thanks for your help on this one!

RDAccount
Level 1

How do I use a resolving transaction to account for payment processing fees that were taken out of a full payment of an invoice prior to its deposit in my account?

Why can't the resolve transaction feature make it part of the deposit rather than creating another expense.  This is causing lots of issues when trying to reconcile the account at the end of the month.

RDAccount
Level 1

How do I use a resolving transaction to account for payment processing fees that were taken out of a full payment of an invoice prior to its deposit in my account?

Can you change the "Resolve difference" feature to add a transaction to the deposit instead of creating a whole new journal entry?  Its causing issues when I go to reconcile the account because I have transactions that don't match up with the bank statements.

Adrian_A
Moderator

How do I use a resolving transaction to account for payment processing fees that were taken out of a full payment of an invoice prior to its deposit in my account?

Hello RDAccount,

 

Being able to add a column on the invoice form would be a great feature. 

 

While this option is unavailable, I suggest sharing this idea with our developer's team. Here's how:

 

  1. Click the Gear icon.
  2. Under PROFILE, select Feedback.
  3. Type in a few words to describe your feature suggestion.
  4. Click Next.

 

Moreover, you can check this artile as your guide about managing bank entries: Banking.

 

I'm always around whenever you have banking concerns.

Need to get in touch?

Contact us