Skip to main content
R
rlatz
November 10, 2023
Solved

How to expand the limitations of the Matching function

  • November 10, 2023
  • 1 reply
  • 0 views

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?

 

 

Best answer by Mark_AG

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:

 

  1. Go to Transactions and select Bank Transactions.
  2. Choose the bank you're currently using.
  3. Under the For review tab, select the transaction with the $100 amount.
  4. Select Exclude.
  5. Click Go to bank register.
  6. 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.

1 reply

G
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.

 

R
rlatzAuthor
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?

M
Mark_AGAnswer
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:

 

  1. Go to Transactions and select Bank Transactions.
  2. Choose the bank you're currently using.
  3. Under the For review tab, select the transaction with the $100 amount.
  4. Select Exclude.
  5. Click Go to bank register.
  6. 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.

    Terms & ConditionsAccessibility statement