Question

Matching transactions resolve error

Forum|Forum|4 years ago
March 27, 2022
3 replies
2 views

I am matching payment transactions to a bank deposit. I have done this many times before, but currently I can not get the resolve button to work correctly to resolve the difference. It creates the transaction and adds it appropriately in its calculation but does not fill it in on the added transaction. Is anyone else having this issue? How can I fix this.

QuickBooks Online

MJoy_D

QuickBooks Team

Let's resolve the error you're having when matching your transaction, @Ginger2744.

Let’s isolate this issue by clearing your browser’s cache. Try using a private browser when paying your bills online. If it works, proceed and clear the cache in the one that you're currently using.

Here’s how to go incognito or use a private browser:

For Chrome, press Ctrl + Shift + N.
For Internet Explorer or Firefox, press Ctrl + Shift + P.
For Safari, hold down Command + Shift + N.
Microsoft Edge: CTRL + Shift + P

If it works, here's how to clear cache and cookies to fix issues when using QuickBooks Online. Restart your browser right after. You can also proceed by using other supported browsers (Firefox, Google Chrome, Safari, Microsoft Edge) if the steps above don’t work.

Here's more information that can help you find a match while you’re reviewing downloaded bank and credit card transactions: Fix mismatched or miscategorized bank transactions.

Here's a guide to help you review your opening balance, start your reconciliation, compare the transactions on your statement with what's in QuickBooks: Reconcile an account in QuickBooks Online.

You can always get back to us by leaving a reply on this thread. We're already ready to help with any QuickBooks and banking concerns you have. Have a great rest of the day!

C

Can I Reindex data

My totals on my Profit and Loss by tag group and profit and loss for the company do not match. Can I reindex the data or where can I find the difference? I would like to use the tag group reports, but they are way off the profit and loss - and I don't know which is correct. I tried clearing the cache, cookies and using the private browser. They are still all the same totals

G

Ginger2744Author

so it appears that it is not working because it is a negative value. It used to let me do this so this is disappointing that it no longer does. I work with Square and that negative amount was the fee amount and how I tracked that. Now I'm not sure how to match my sales to my bank deposit.

RenjolynC

Level 9

Thanks for keeping us posted, Ginger2744.

I'll give steps on how you can reach out to our support team regarding the Resolve Difference function. Meanwhile, let me share a way on how you can match your sales to the bank deposit.

Some banks add service charges and processing fees. If you haven't recorded a bank deposit in QuickBooks for the sales transaction, let's do that and add the fee as a negative amount. Before doing so, please make sure to change the Deposit to account in your sales transaction to Undeposited Funds. This way, the transaction will show up in the Bank Deposit window.

To deposit, here's how:

Go to + New > Bank deposit.
Under the Select the payments included in this deposit section, put a check mark on the sales transaction.
Scroll down to the Add funds to this deposit section.
Enter the fee as a line item.
Select who the fee was from (for example, the bank charging you).
From the Account drop-down, choose Bank Charges.
Enter the amount fee as a negative number. For example, if the fee was US $.50, enter –.50.
Review the deposit total with the bank fee.
Hit Save and close or Save and new.

Once done, you can now match this deposit to the one downloaded in the Banking page.

For more information about the steps I've shared, please feel free to read these articles:

As for contacting our Customer Care Team, you can follow the steps and get our direct phone number in this link: QuickBooks Online Support.

You're always welcome to post a reply on this thread if there's anything else you need. Me and my colleagues are here to help.

V

VTXtools

Hello there, @VTXtools.

Please know that this isn't the experience we want you to have. All transactions downloaded into QuickBooks are from the bank. It depends on the bank if it includes information such as fees and charges per transaction.

You're right. The only workaround to make up for the processing fees is to create an expense for each transaction.

For detaile information about Include bank or processing fees, you may visit this article: Record and make bank deposits in QuickBooks Online.

You may visit this article as your reference when you reconcile an account to ensure your accounts in QBO are balanced: Reconcile an account in QuickBooks Online.

If you have any further concerns about your transactions, don't hesitate to post them here. Have a great day!

Yes, an expense must be created. But the software bug which has been logged and recognized by the development team has rendered the resolve difference/add resolving transaction inoperable. So the extra step/workaround of manually creating an expense before matching the downloaded transaction needs to be done for each transaction rather than from within the match transaction modal. Its not a major issue to workaround but it is still a bug that needs to be resolved as it is more time consuming.

V

VTXtools

Looks like the bug has been resolved. I'm not able to enter a negative number in the resolve transaction and get it to post.