Error: QB and OLB not matched

DaniMogollon · ‎August 22, 2022

Hi Community,

I am trying to book for the first time an expense which I load by "Bank Feed". even if a tried to book a unique transaction or confirm a rule, I always get the Message.

any one of you know why this happen and how to solve this?

Jovychris_A · ‎August 22, 2022

Hi, @DaniMogollon.

I can share a few insights about why the bank feed expense transaction didn't match a record in QuickBooks Online (QBO). These are due to the following:

Transactions have been matched previously to another downloaded transaction.
Transactions recorded in QuickBooks is not using the same bank account.
The transaction is entered manually in QuickBooks and could have a different amount, date, or payee from the downloaded expenses.
Transactions are already reconciled.

Thus, there are times that if the entries aren’t the same as the downloaded, QuickBooks won’t find it. The only way to see this is to manually locate and match them, where you can use the Find Match option. Then, search for a possible match for that expense. You can also use the Search field to locate transactions by amount, reference number, or memo.

Here's how:

Go to the Transaction menu and select Banking.
Select the tile for the account you want to review.
Select the For Review tab to start your review.
Select the expense to expand the view.
Choose Find match.
You can use filters/search to locate transactions. Remember to use a dollar sign or decimal point when searching for dollar amounts.

If you're still unable to find the match, you can utilize the Exclude option instead of matching them. This will simply move the transactions out of the For review tab, and won't impact your books since you've already recorded the expense.

Here's how:

Go to Transactions menu and then select Banking.
In the For review tab, check the expense transaction box.
Hit Exclude.

I'm adding these articles for your reference in matching bank feeds with QuickBooks transactions:

Please get back to me if you have other concerns about banking transactions. Anytime I can help. Take care always.

DaniMogollon · ‎August 26, 2022

Team, thank you very much for your useful comments.

Unfortunately, the problem persist.

I think the issue is related to my laptop setup. Please see the attached file, in which a have a USD 375 transaction, but system show that in QB the amount is 375.000. I think somehow system is adding thousands.

what do you think, any idea?

JamaicaA · ‎August 26, 2022

I appreciate you providing these additional details as these are helpful, @DaniMogollon. I’d be glad to redirect you to the best support to help you with your expense transactions concern.

QuickBooks is dependent on the information that is transmitted from your bank institution. Thus, you’re unable to find a match since you’re having different expense amounts from the QuickBooks’ system and the bank feed downloaded transactions.

You’ll need to make sure that the information is correct especially the dates and amounts. Once these are in order, the system will take over from there and automatically provide matches.

To make sure this issue will be addressed properly, I suggest contacting our Customer Support Team. They can investigate further to check on your transactions securely and help verify what's causing the issue.

Here’s how:

Go to the Help icon.
Select the Search tab, then Contact us.
Choose between Start a chat or Get a callback to connect with us.

For information on this, please see the following article: How To Add And Match Downloaded Banking Transactions.

For more in-depth information about finding a match in QuickBooks, refer to these articles:

We appreciate your patience on this concern. Feel free to click the Reply button if you have other questions about matching your expense transactions in QuickBooks Online. I'm always here to lend a hand.

suds1

I'm getting this problem in QB Desktop Pro Plus 2024. The transactions "to be reviewed" are 1) being added to the register 2) NOT removed from the list of transactions to be reviewed; however, because I am getting the error message (pop-up box), i don't notice that the transactions are being added to the register, so I adjust the transaction in some minimal way, like changing a class or something, try again, and get the same message, and the transaction gets added to the register despite the error message AND still appearing in the list of transactions to be reviewed.

Silly error, but the only workaround I have is that, when i get the message, check to see whether the transaction has been added to the register; if so, then delete the transactions from the list of transactions to be reviewed.

Aldren18

I appreciate your resourcefulness in identifying a workaround, Suds1. Let’s collaborate to tackle the issue with the "to be reviewed" transactions and ensure everything runs smoothly moving forward.

Before we dive into troubleshooting, could you share the name of your bank and the exact error message you received? This information will be invaluable in identifying any relevant ongoing investigations.

To get started, I recommend turning off online banking for all inactive accounts to isolate the bank feeds issue. After doing so, refresh the bank connection on the affected account to ensure all current transactions sync correctly.

Here's how to proceed:

First, check for inactive bank accounts:

Navigate to the Company menu.
Choose Chart of Accounts.
Select the Include Inactive box. Look for an inactive account with a lightning bolt sign.

Then, turn off the online banking for inactive accounts:

Right-click the inactive account and select Edit Account.
Go to Bank Feed Settings.
Tick the Deactivate All Online Services, then OK.
Select Save & Close.
Close and reopen your company file.

I've included a screenshot for your reference:

Please ensure that during setup, you hold the Ctrl key each time you select a button, except when entering info. This refreshes the connection with your bank.

Additionally, If you have multiple online banking accounts, check if the issue is with a specific account. Problems with one account can sometimes impact others.

Here’s how:

Go to Chart of Accounts, then select the Include Inactive checkbox.
Turn off the Bank Feeds.
Then, set up online banking for each of the accounts.

For more detailed instructions, check out this article: Fix OL and OLSU bank feed errors in QuickBooks Desktop (QBDT).

Should the issue remain after these steps, I suggest updating your QBDT and running the QuickBooks Tool Hub. This tool helps resolve common issues in QBDT, including performance problems and errors that cause delays during operations like transaction review errors.

Furthermore, I’ll share these insightful articles designed to help you handle your transactions effectively and streamline your entry processes in QuickBooks Desktop:

Please note: While some help articles provided aren't specific to QuickBooks International, the steps and guides are still applicable and can resolve the issue.

I encourage you to bookmark this thread for future questions or concerns about your entries and banking in your QBDT. My team and I are always available to support you.