cancel
Showing results for 
Search instead for 
Did you mean: 
nulsenc
Level 2

How to match bank transaction to already paid invoice

I have invoices that show as paid but the transaction is still listed in the bank feed.  Someone applied a payment to the invoice but they did not do it from bank feed.  If I remove the payment from the invoice it will put a credit on the customers account.  This is not good since the money that I am going to put on the invoice from the bank feed is the only payment that has been received.

Is there a way to attach the bank feed to the already paid invoice without doubling the payment or income, so that my bank feed is up to date?

Solved
Best answer October 15, 2018

Best Answers
lyndaartesani
Level 6

How to match bank transaction to already paid invoice

What is the date of the payment and the date of your qb transaction?  That can prevent a match.  Also if the transaction is reconciled will prevent the match.  You would have to click the R to temporarily unreconcile the latter transaction, click the bank feed to match it and then re-reconcile it by clicking the spot on the register to re-reconcile it to an R in that spot.

View solution in original post

3 Comments 3
lyndaartesani
Level 6

How to match bank transaction to already paid invoice

What is the date of the payment and the date of your qb transaction?  That can prevent a match.  Also if the transaction is reconciled will prevent the match.  You would have to click the R to temporarily unreconcile the latter transaction, click the bank feed to match it and then re-reconcile it by clicking the spot on the register to re-reconcile it to an R in that spot.

HeatherS7
Level 1

How to match bank transaction to already paid invoice

Hi

It hasn't been reconcilled

The date of the transaction is Jan 31, the date of the cheque is Feb 28 and the date it came through the bank is march 14 

Angelyn_T
Moderator

How to match bank transaction to already paid invoice

Hi there, @HeatherS7.

 

Thank you for taking the time to reach out to us here in the Community. Allow me to join the thread and help share information about finding match transactions in QuickBooks Online (QBO).

 

To search for other transaction to match if QBO is unable to find or match to the correct one.

 

  1. Click on Banking from the left pane.
  2. On the Banking page, select the For Review tab.
  3. Select the transaction to open it.
  4. Select the Find other records or Find match button to open the Match transactions window. The Match transactions default the search result 10 days ahead of the transaction date (To) and 10 weeks before the To date for From. You can narrow the result by editing the date range From and To.
  5. Use options on the Show drop-down to narrow the transaction you're looking for. You can also use the Search field by entering a specific text such as Name, part of the name, or an amount.
  6. Select all the checkboxes of the matching transactions, then verify if the total amount is the same as they downloaded transaction.
  7. (Optional) If the amounts are different, you can locate additional matched transactions, or toggle Resolve | Difference. This will open the Add resolving transactions field to add the Category, Amount, and Payee(Optional) of a resolving transaction until the difference is zero. You can also use Add new transaction to add multiple resolving transactions if necessary.
  8. Select Save.

If you can't still find the transaction, make sure that the transactions hasn't been reconciled, was entered using the same bank account and wasn't matched to another downloaded transaction.

 

For additional reference, you can check this article: Add and match downloaded banking transactions.

 

Please let me know how things go by adding a comment below and if you have any other banking concerns. It's my pleasure to help you!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us