Matching Transaction without Invoice

It’s nice to see you in the Community, TerryGH.

The Add option is used when the online program didn’t find an existing matching entry. The added payments are recorded to your register.

Once the issue is resolved by your bookkeeper, you can exclude the transactions. This way, they’ll go back to the For Review tab. I’m here to help make sure the process is a breeze for you.

1. Tap the Transactions menu on the left panel to select Banking.
2. This will take you to a page that shows the list of accounts connected to the bank feeds.
3. Click the Blue tile icon and choose the account you’re working on.
4. In the Categorized tab, tick the boxes for the payments and click the Undo link.

For more details, you can browse this article: Unmatch downloaded bank transactions or move them to another account. It outlines the complete steps on how to move a downloaded entry to another account, delete one to name a few.

If you already have the invoice, you can match it to the payments. Here’s an article that covers all the information on how to perform the task: Categorize and match online bank transactions in QuickBooks Online.

To help you in the future, this link will guide you on how to reconcile your accounts. Tap here to view the complete details of the resource. It contains an online tutorial for visual reference.

Keep in touch if you need help with managing your online banking transactions. I’m more than happy to assist further. Enjoy your weekend.

As expected I think I understand your basic answer to my question (once a matching invoice is found/entered undo the add and then the match should appear in the "For Review" tab), my only concern at this point is being able to find all previously added deposits that have not been matched, e.,g if on large invoice is used for two or more customer payments. That should be easily solvable if there is a way to search/run a report that will show all deposits that have not been matched to an invoice -- is that doable?

I can help you run a report where you can see all deposits, TerryGH.

You can open the Deposit Detail report, then customize it to see unmatched deposits. Let me show you how to do it.

1. Click Reports on the left panel.
2. Find and open the Deposit Detail report.
3. Click the Customize button in the upper right-hand corner.
4. Maximize the Rows/Columns section, and then click the Change columns link.
5. Check the Clr box.
6. Maximize the Filter section.
7. Check the Transaction Type box and choose Deposit.
8. Checked the Cleared box and select All.
9. Click Run report.

After filtering the report, look for a deposit that doesn't have a letter C under the CLR column. This means that they are not yet matched to any deposits.

If you also want to see unmatched invoices, you'll have to do it directly from the Banking page. Here's how:

1. Click Banking on the left panel.
2. Look for a payment in the For Review tab.
3. Select the Find Match radio button.
4. Click the Show drop-down, and then select Open invoices.
5. From the list, look for the match and select it.
6. Click Save.

I'm adding these articles to future guides on how manage your bank transactions:

• Categorize and match online bank transactions in QuickBooks Online
• How to Record Bank Deposits in QuickBooks Online.

Stay in touch with me if there's anything else I can do with running a report that shows all deposits that haven't been matched. I'll be right here to help you.

Thanks Mary  -- That is definitely on the right track so I appreciate your quick response, but will have to revisit this tomorrow when I have a good nights sleep. 

One item I did notice is that under the "CLR" column there are only Rs and then blanks, not to mention many items I did not expect.  This should be a snapshop of today right? I focus on this is to find those deposits/payments that have been made and are still not matched to an invoice ... what am I missing?   The "R" seems to indicate reconciled which I would expect since I am only one month behind at present.

Thanks ... TGH

I appreciate your prompt response, @TerryGH.

Let me add some clarifications about locating the unmatched transactions in QuickBooks Online.

The process presented by my peer, MaryLandT above will help you find the unmatched payments that you have. You're in the right track already.

Please know that when pulling up the Deposit Detail report, only the payments will be recognized as cleared and not the invoices. This behavior in QBO is working as designed.

After viewing the unmatched transactions, you can start matching them the to the open invoices. This way, you can have a smooth reconciliation.

For your reference, I'm adding here some links that you can use in fixing reconciliation issues in QuickBooks Online:

• Learn what to review so you can start reconciling
• Fix issues at the end of a reconciliation in QuickBooks Online

You can always get back to me if you need anything else with banking. I'll continue to stick by your side. Have a lovely day!

Hi Betty  .. I do appreciate your jumping in to the conversation but I am either missing something or you folks are since I am not seeing what actually should only be two transactions by the same client that has some invoicing issues, to say the least.

     I tried again to run the report and still am seeing way more transactions than I should since the report is seemingly printing out all deposits and what seems to be offsetting matches and they are all listed with "C"

     By the way, I have no problem is getting the client's account reconciled, but I do need to either match or add all transaction from the For Review section.  I think there are only a few deposits that have not been matched but obviously want to me sure, hence my question here.

If you folks do not have any other thoughts, it seems as though I need to call the QBO tech hotline to have someone share my screen to see when I am missing.  Or any other thoughts?

Thanks again.. TGH

Thanks for getting back to this thread, @TerryGH. 

You could have found and match the transactions to the invoice after following the suggestion by my colleagues above. 

Can I ask for a screenshot of the section where there are some problems when matching your transactions? I appreciate any extra information you can give, and it will help us isolate the issue and provide the best solution. 

Otherwise, you can contact our support team directly. They have the tools to check your account in a safe environment, and they can help find the root cause of your issue and find a fix.

Here's how to reach them:

1. Sign in to your QuickBooks Online company.
2. Select the Help (?) menu.
3. Choose the Assistant tab.
4. Click the Talk to a human option.
   
   
5. Select Get help from a human.
   
   
6. Click either Chat with us or Have us call you button.
   
   

Once everything looks fine, you can start to reconcile your accounts so that they always match your bank and credit card statements.

Let me know if you have further concerns about matching transactions in QuickBooks. I'll be looking forward to your reply. Stay safe and have a good one.