Scenario:
Thus, the 3 items total the $100.
Problem:
When doing the Match function in QB, the only transaction that shows up in the choices is item A for $25.
Resolution:
How can the Matching function be expanded to show the items B and C?
Solved! Go to Solution.
Hi there, @rlatz.
I can see that you want to match multiple journal entries to a single bank transaction. However, item B and item C aren't showing. Let me guide you on how to handle this. We'll have to exclude the transaction from your bank feeds and manually categorize the journal entries in the bank register. This will help avoid duplicate transactions and help you reconcile your bank account.
Here's how:
After categorizing everything from your bank transactions, you can now reconcile your bank to match your QuickBooks Online transactions.
If you have any other concerns about bank matching, feel free to reply to this post. The Community is always here to provide the best solution.
On behalf of my colleague, you're welcome, rlatz. I'm glad you found the suggested workaround helpful in simplifying the process and saving time. I'd like to provide additional details about matching transactions in QuickBooks Online (QBO).
Regarding your question, the match function primarily serves the purpose of marking the journal entry (JE) in the bank registry by adding a "C" next to it. It doesn't create any additional entries or modify the existing ones.
The function is designed to provide a straightforward and effective way to track and reconcile the JE without any unintended consequences. It focuses on enhancing efficiency and accuracy without generating any additional data.
I've added some articles below to learn more about categorizing transactions and the reconciliation workflow in QBO:
I'm always here whenever you need help with your bank transactions and any concerns related to QuickBooks. Take care and have a good one!
Welcome to the Community, @rlatz.
I have some insights to share with you about matching online transactions.
When matching transactions, you need to make sure that the date on your journal entry is accurate or the amount is closer to the online banking transaction for QuickBooks to find a match automatically. Please also note that QuickBooks will match the closest amount to your online transaction.
Furthermore, I'm adding this helpful article as your detailed guide to categorizing and matching your online bank transactions: Categorize and match online bank transactions in QuickBooks Online.
If you need help in matching your transactions, don't hesitate to drop a comment below. Have a good one.
Thanks for responding. I wish there were a way to expand the scope of the match. Another words, in my example, if the bank amount is $100, I wish it could find transactions (in the match) around this date and time that were $200 more or less. Another words, show me matches with amounts that are ($100) to $300. That would capture the ($25) and $150 line items. Is there a setting to do this?
Hi there, @rlatz.
I can see that you want to match multiple journal entries to a single bank transaction. However, item B and item C aren't showing. Let me guide you on how to handle this. We'll have to exclude the transaction from your bank feeds and manually categorize the journal entries in the bank register. This will help avoid duplicate transactions and help you reconcile your bank account.
Here's how:
After categorizing everything from your bank transactions, you can now reconcile your bank to match your QuickBooks Online transactions.
If you have any other concerns about bank matching, feel free to reply to this post. The Community is always here to provide the best solution.
Thanks VERY much Mark, It is a simple and effective way to do this, and saves lots of time!!
So all the match function is doing is essentially putting a C next to the JE in the bank registry? The match function does not create anything else that would be missing by doing this "workaround" that you suggest?
On behalf of my colleague, you're welcome, rlatz. I'm glad you found the suggested workaround helpful in simplifying the process and saving time. I'd like to provide additional details about matching transactions in QuickBooks Online (QBO).
Regarding your question, the match function primarily serves the purpose of marking the journal entry (JE) in the bank registry by adding a "C" next to it. It doesn't create any additional entries or modify the existing ones.
The function is designed to provide a straightforward and effective way to track and reconcile the JE without any unintended consequences. It focuses on enhancing efficiency and accuracy without generating any additional data.
I've added some articles below to learn more about categorizing transactions and the reconciliation workflow in QBO:
I'm always here whenever you need help with your bank transactions and any concerns related to QuickBooks. Take care and have a good one!
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