Skip to main content
June 9, 2021
Question

I'm in the process of matching the bank entries and quickbook entries. I have some with identical amounts, however when I do a search to match the correct Quickbooks entries don't show up

  • June 9, 2021
  • 1 reply
  • 0 views

I have some unmatched quick book entries that I need to match with the bank entries, however, when I select review for matches, the correct entries don't show up.

1 reply

June 9, 2021

Let me help you match the downloaded bank transactions in Bank Feeds page, mbw1.

 

Sometimes QuickBooks may not match a transaction in an electronic statement with the transaction in QuickBooks. If this happens, we can manually match it to open or posted transactions. Then, press Resolve to split entries to balance the remaining amount if the amount doesn’t match. Just go to unrecognized tab to manually match your transactions to what’s in your books. Here's how: 

  1. From the transaction, select the dropdown in the Action column.
  2. Select Match to existing transactions.
  3. Choose the matching transaction, then hit Save and add to register.
  4. If the amount doesn’t match, press Resolve to split entries to balance the remaining amount. You can also add resolving split entries in an existing posted transaction for deposits and payments.
  5. If you’re matching a money-out transaction to existing bills, edit the amounts under the To Pay column to indicate full or partial payments against bills.
  6. Once you’ve added details, press Save and add to register to add the transaction to your books.

 

You can also create rules to categorize transactions for things you frequently spend money on, like supplies or business expenses. Here's how: 

  1. Go to the Banking menu.
  2. Select Bank Feeds and then Bank Feeds Center.
  3. Tap Rules, then select Add Rule.
  4. Add a Rule Name, then select  if it’s Money In or Money Out or Both.
  5. Add Conditions and if the rule is for Any or All of the conditions for descriptionmemo, and amount.
  6. If your class tracking is enabled, add values for PayeeAccount, and Class.
  7. For Money Out rules, you can also assign a Customer:Job
  8. Add the conditions for the rule, then when you’re done press Save.

 

From the rules page you can also search rules based on the name, rule condition, description, payee, class and account. You can also create a rule from a transaction, here’s how.

  1. Select a transaction, then from the Action column.
  2. Select the dropdown then Add More Details.
  3. Choose Create rule from this transaction.
  4. From the Add Rule screen, add the details for the rule.
  5. When you’re done, press Save.

 

To learn more about this one, see the Add and match Bank Feed transactions in QuickBooks Desktop article. Feel free to visit our Banking page for more insights about managing your bank feeds and reconciling accounts.

 

I'd like to know how you get on after trying the steps as I want to ensure this is resolved for you. Just reply to this post and I'll get back to you. Take care always.