How to expand the limitations of the Matching function

rlatz · ‎November 10, 2023

Scenario:

One Banking transaction imported for a $100 deposit from Customer
One Customer has multiple transactions related to the $100 deposit. Each transaction is separately entered in JE's in QB as follows:
- Revenue item A for $25
- Revenue item B for $150
- Return item C for ($75)

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.

item B does not show up because the $150 is larger than the bank total of $100
item C does not show up because it is negative

Resolution:

How can the Matching function be expanded to show the items B and C?

MarkAngeloG · ‎November 10, 2023

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:

Go to Transactions and select Bank Transactions.
Choose the bank you're currently using.
Under the For review tab, select the transaction with the $100 amount.
Select Exclude.
Click Go to bank register.
Under the ✔ section, manually click the blank field to change it to C.

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.

View solution in original post

LeizylM · ‎November 10, 2023

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!

View solution in original post

GenmarieM · ‎November 10, 2023

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.

rlatz · ‎November 10, 2023

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?

MarkAngeloG · ‎November 10, 2023

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:

Go to Transactions and select Bank Transactions.
Choose the bank you're currently using.
Under the For review tab, select the transaction with the $100 amount.
Select Exclude.
Click Go to bank register.
Under the ✔ section, manually click the blank field to change it to C.

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.

rlatz · ‎November 10, 2023

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?

LeizylM · ‎November 10, 2023

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!

Topics

Training

Community

Resources

How to expand the limitations of the Matching function