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

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.

• 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

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!

Thats the point when I do points 1 - 7... the invoice does not appear. All the dates, Bank accounts etc are correct on the invoice and transaction... but the invoice does not appear... ironically when i was doing other transactions the invoice did appear... it just does not appear for the one transaction it should appear for

The efforts you've made are greatly appreciated, @Killian. I see the importance and urgency of this matter and I'm here to help you successfully match your invoice to your bank transaction.

When matching transactions in your bank feeds, it’s essential that the amounts entered should be identical. Keep in mind that any associated fees can affect this process.

At the same time, QuickBooks Online (QBO) won't match transactions if your invoice amount is greater than the amount shown in your bank feeds. Only the same or lower amounts will appear in the Find other matches section.

With that, you'll need to manually receive payment for the invoice and deposit it in your bank including the processing fees. I'm here to help you out in accomplishing this process.

Firstly, find the invoice you want to match from the transaction in your bank feeds and go to the Received Payment page. To do so, here's how:

1. Head to the + New, then select Receive payment.
2. From the Customer dropdown, choose the name of the customer.
3. In the Payment method dropdown, pick the payment method.
4. Select the Payments to deposit or Undeposited Funds, from the Deposit to dropdown.
5. Tick the checkbox for the invoice you're recording the payment on in the Outstanding Transactions section.
6. Click Save and close.

See this article for reference: Record invoice payments in QuickBooks Online

Once done, let's go ahead and deposit the money at your respective bank. I'll gladly walk you through the process of completing this.

1. Go to + New, then Bank deposit.
2. In the Account dropdown, choose the account where the funds are to be deposited.
3. Tick the checkbox the checkbox for the transaction.
4. In the Add funds to this deposit section, add an expense account in the Account column.
5. From the Amount column, add the exact amount of the processing fees and make sure it is negative.
6. Once done, Save and new or Save and close.

For reference, you can scan this article: Record and make bank deposits in QuickBooks Online.

Afterward, return to your bank feeds page and match the corresponding invoices to its bank transactions.

For more detailed guidance on ensuring your bank statements in QBO match your actual bank records, you can refer to this article: Reconcile an account in QuickBooks Online.

Don't hesitate to reply to this post if you need further help in matching your transactions in QBO. I'll make sure to help you out anytime.