Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I hope this is the correct discussion topic for my question. On 2/1 we received a merchant deposit from our credit card processor in the amount of $268.37. Payments for the cards were from membership renewals which in reality totaled $460. Because it was the first of the month the card processor deducted their fees so that the $268 was what was deposited. I need to keep track of the membership renewal amounts in QBO, so my question is: how to I add the $460 in membership fees into QBO and show the fee charge correctly? The transfer has taken place from the merchant to our bank and from our bank to Quickbooks.
I'm sure I am not asking the question as clearly as I should, but I hope someone understands what I am trying to say and do!
Thank you in advance for your time and help.
Larry
Solved! Go to Solution.
Thanks for getting back to us, Larry K.
Allow me to step in and help you with matching your deposits with fees in QuickBooks Online.
To answer your follow-up question, yes, you can create a separate invoice for each member to track their renewal in QuickBooks Online and follow the steps provided by my colleague above to match them. See the sample screenshot below.
To help you manage your invoices in QuickBooks, you can refer to this article: Create invoices in QuickBooks Online. This will provide you links on how to record payments manually as well as tips to make your financial reports accurate.
If you need further assistance with matching your deposits with fees or have other follow-up questions in mind regarding QuickBooks Online, please let me know. I'll stick around to help you out.
You've come to the right place! I've got all the steps to make sure everything is accounted for, @Larry K.
If you receive a payment less than the invoice amount due to bank fees, we can use the Resolve Difference feature to account for the bank charge.
You can follow these steps below to create a Bank Charges account:
You can refer to our guide on adding an account to your chart of accounts in QuickBooks Online for your convenience.
Once done, you can match the invoice with the bank transaction and use the Resolve Difference feature to record the bank fee. Let me show you how.
Your transaction is now matched off against the invoice and the bank fees are accounted for.
As another option, you can follow our guide on entering a bank service fee while using a third-party merchant service. Then, match the downloaded transaction and the deposit you created in QuickBooks Online.
Feel free to visit our Banking page for more insights about managing your bank feeds.
If you have any other questions or clarifications, feel free to leave them in the comments below. I'll get back to you as soon as I can.
Thank you @LieraMarie_A for your quick response. This makes sense to me, but I have one follow-up question.
The amount received from the CC merchant is for six separate transactions from members paying their dues. That total equals $460 and then the fees ($191.63) are deducted and the balance is deposited to our account. I want to be able to track each individual members renewal in QBO, so do I create a separate invoice for each member (and what their renewal is) and then match all of them to the transaction when I do the review, and THEN resolve the difference?
Thank you again for your assistance and knowledge!
Thanks for getting back to us, Larry K.
Allow me to step in and help you with matching your deposits with fees in QuickBooks Online.
To answer your follow-up question, yes, you can create a separate invoice for each member to track their renewal in QuickBooks Online and follow the steps provided by my colleague above to match them. See the sample screenshot below.
To help you manage your invoices in QuickBooks, you can refer to this article: Create invoices in QuickBooks Online. This will provide you links on how to record payments manually as well as tips to make your financial reports accurate.
If you need further assistance with matching your deposits with fees or have other follow-up questions in mind regarding QuickBooks Online, please let me know. I'll stick around to help you out.
I have this same exact issue except mine goes a step further. I use wix along with the quickbooks app to automatically track my invoices generated from sales. The issue is that these payments are made to wix and wix charges a 2.9% POS processing fee plus $0.30 to the total before depositing this into my account. For instance a sale of $52.98 on the invoice is deposited by wix as $51.14 after they take their $1.84 out. So I have to go in and link each one manually, calculate the difference, and post as a separate transaction? There has to be a better answer, this should be a pretty common issue with wix and quickbooks but I cant seem to find the right article.
Hello there, @DynamoBicycle.
I'm here to share some pointers to resolve this deposit fee in QuickBooks Merchant.
Yes, fees associated with the invoice should be recorded as a separate transaction. You'll need to tap the link for each invoice to enter the difference manually. This way, you'll be able to avoid discrepancies when you start reconciling your books.
Furthermore, you can refer to the steps provided by @Rose-A above on how to track bank fees or deposit charges.
I'm adding this article for your additional guide to reconciling an account in QuickBooks Online.
You can use various reports and forecasts to get a complete image of your company's current and future finances. You can get some ideas from this article: Track your cash flow in QuickBooks Online.
Feel at ease if you need assistance with how to run an invoice report. I'll be here around to guide you always. God bless you.
Is there not a means of creating a rule for transaction fees or adding a blanket edit rule to synced invoices on Quickbooks to rectify this? This seems like an extremely common issue and something that should be integrated within this software. Kind of takes out the point of "automated accounting" that the quickbooks link too wix is advertised as if I have to go in and manually add the fee to each sale. Moreover, this makes this accounting system essentially useless once I start getting more than 50-100 or so sales per day. I will have to hire someone to exclusively just add these fees to keep my books straight? Thats seems tedious and utterly ridiculous.
Hello @DynamoBicycle.
Handling transaction fees by creating a rule to rectify the data or transactions from another platform to our program can be a big help. I can see how relevant and helpful it is. However, we're unable to do it in the system. We can send your valuable feedback to our Product Development team and share your insights about this.
We can handle these fees ourselves by following the recommendation shared above.
If you would like someone to do it for you, we can consult an accountant or someone who can better guide you in recording the fees in other ways. They'll make sure to keep your accounts and business data accurate. Check this link: Find an accountant.
Here are some articles for more tips and details about handling bank data and reconciling accounts:
Please let me know if you have other concerns about entering charges and handling bank transactions. The Community is always here to help. If you have other suggestions, please feel free to post them.
I have been doing that very thing ALL YEAR matching deposits to invoices and using the RESOLVE to account for prompt pay discounts. All of a sudden, 2 WEEKS AGO is stopped working! I have called Quickbooks every 2 days since and NO ONE KNOWS WHAT THE HECK IS GOING ON!!! Do you? Is anyone else having this issue ALL OF A SUDDEN??!! I have requested a supervisor to call me back twice now and I still have NOT HEARD FROM ANYONE! Quickbooks customer service is terrible!!
WHY is the resolve feature NOW NOT WORKING?????
Why is the resolve feature now not working??!!
Hi, @carsons.
I know how important this feature is for you, especially when you're matching deposits to add them thoroughly to your bank register.
In relevant to your case, may I know if you're getting the "Error: Something not quite right the selected and downloaded amount don't match to continue resolve the difference" when matching downloaded transactions?
I see an investigation topic regarding matching deposits using the Resolve difference feature. As our engineers are diligently working to fix this, I suggest contacting our QuickBooks Online Support team through chat or callback.
On the other hand, our phone and chat supervisors may be unavailable for now due to customer volume that informs this issue. Rest assured, our phone and chat representatives will be attaching your account to the investigation case once you get in touch with one of them. This way, you'll receive an email once they get a fix and release the update soon in QuickBooks Online (QBO). We thank you for your patience.
However, if the error message doesn't appear when matching a deposit using the Resolve difference feature, I suggest using an incognito or private browser to isolate this issue. This mode has no cache, this is why it's suitable to run QBO since the browser's cache affects online website performance.
Run a compatible browser and then follow its keyboard shortcut:
If you're able to run QBO and utilize the Resolve feature when matching deposits, I recommend clearing your regular browser's cache. By doing this, your browser will start with a clean slate. You can also try other supported browsers.
Please let me know how it goes so I can help you more. Stay safe and more power to your business!
Hello, carsons.
Thank you for confirming the error message you've encountered when matching the download transactions.
I'd like to inform you that there are reported similar issues from users about the "Error: Something not quite right the selected and downloaded amount don't match to continue resolve the difference when To be able to match downloaded transactions properly" This is the possible reason why the RESOLVE feature is not working correctly.
Rest assured, our software engineers are working hard to resolve this issue permanently.
To ensure you'll get an update about the resolution status, I suggest contacting our QuickBooks Support Team. This is to ensure that your company is added to the list of affected users and provide this investigation number for easy tracking: INV-77952.
To make sure you'll get prioritized for your concern, please check the availability time of our customer support team. You can contact us every Monday to Friday from 8 AM - 6 PM. Also, phone support may be limited due to volume.
Once the investigation is resolved. You will be able to use the RESOLVE feature again in QBO.
On the other hand, for more details on handling your account, just feel free to use our Community Help articles. Just select a topic that you need help with.
Thank you for your patience while we work on a fix. Please know you can continue to reach me here with any additional questions. I'll be more than happy to assist you again. Take care!
Why are there multiple investigation #'s??? Please tell me what is going on with #78847!
Why is this function ALL OF A SUDDEN not working? It was working fine until 2 weeks ago?
I understand the urgency of this issue, @carsons.
The multiple investigations are determined by the impacted regions. INV-77952 is for QuickBooks Online (QBO) in the United States, while INV-78847 is for QBO in the United Kingdom and the rest of the world. Both cases are still active, and the team is working hard to resolve the issue.
For now, you can attempt using the steps below as a workaround:
You can also refer to this article if you want to match your account with your bank and credit card statements: Reconcile an account in QuickBooks Online.
Please feel free to reply if you have additional questions about the said investigations. Stay safe.
I'm having the same issue. Not sure if this is still an issue for everyone or if I'm doing something wrong.
As a workaround, i've matched the transaction at the lower amount( as the merchant fee is held and only the balance deposited in our bank account). I've then gone into the chart of accounts and editied the amount deposited into our bank account to include the fee. Then I added the merchant fees as an expense to bank fees.
Hopefully this will all look okay in our accounts.
Alot of work for somehting that should be a simple transaction to match, at the moment we have hardly any transactions with fees as most of our customers pay via bank transfer.
Is this going to be resolved in the future?, as we start taking more card payments we will need to look for software that has the feature and leave quickbooks if not.
With the amount of companies that have merchant fees taken straight from the balance before transfer into their bank and then quickbooks. It is really suprising that quickbooks don't have a feature for this.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here