Skip to main content
K
killian-otavo-ie
July 10, 2024
Question

Missing invoice when i try to match bank transactions, help?

  • July 10, 2024
  • 1 reply
  • 0 views
I am matching bank transactions to invoices, and I have 99% of them done, no problem. But one invoice (which is inputted correctly) is not showing when i go to match the bank transaction

1 reply

R
RhoiceW
July 10, 2024

Hi there, Killian. I can provide you with some information on what's the reason why there's no match showing on your invoice in QuickBooks Online (QBO).

 

There are a couple of reasons why some transactions can't find their match from existing records:

 

  • The amounts or dates don't match.
  • The transaction is older than six months.
  • The bank account on the payment isn't the same as the bank where the match is located.
  • The payment has already been reconciled.
  • The transaction matched another transaction. 
  • Multiple currencies are involved, and the exchange rate has shifted significantly, making the amounts very different.

 

Furthermore, matching your invoices in QBO will show a suggested match. However, since it's not showing when matching, you can consider looking for another match invoice.

 

In addition, you can refer to this article to learn how to reconcile an account in QBO: Reconcile an account in QBO.

 

Comment on the post if you still have concerns about matching invoices in QBO. I'm always here to help.

K
killian-otavo-ieAuthor
July 10, 2024
  • The amounts or dates don't match.... They do match less the fees obviously... and the invoice shows in the list on other transactions...
  • The transaction is older than six months... all the transactions I am currently doing are older than 6 months... but all the other transactions from that same time period showed and could be matched
  • The bank account on the payment isn't the same as the bank where the match is located.... They are the same account
  • The payment has already been reconciled.... It has not been
  • The transaction matched another transaction.... It has not been 
  • Multiple currencies are involved, and the exchange rate has shifted significantly, making the amounts very different.... All the one Currency
M
MelroseV
July 10, 2024

Thank you for the prompt response, killian. It's my pleasure to help you match your transaction in QuickBooks Online (QBO).

 

We can resolve the difference after matching your invoice and bank transaction. Ensure to filter the correct date in the Find other matches page. Allow me to guide you on how to do it.

 

  1. Go to Transactions, then click Bank Transactions.
  2. Select the bank transaction you want to match to your invoice.
  3. Click Match.
  4. Tick the invoice you want to match to your bank transaction.
  5. Filter the exact date of your invoice.
  6. Toggle the Resolve Difference.
  7. In the Add resolving transactions, complete the fields and enter the remaining amount.
  8. Select Match.

 

Regarding the accounts you should choose in the Category, I suggest consulting your accountant. They can provide personalized recommendations on this.

 

Additionally, you can reconcile your account to identify and correct any discrepancies or errors, providing a clear and transparent view of your finances: Reconcile an account in QuickBooks Online.

 

Should you have additional questions regarding matching your transaction in QBO, please don't hesitate to click the Reply button. Stay safe!

Terms & ConditionsAccessibility statement