cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
Megan88
Level 2

Bank Reconciliation

I have a direct debit payment which i have matched against multiple invoices on one supplier account, but when i go to reconcile the bank i can see one payment for the full amount of DD and then all of the individual invoices i have matched it to, so if i check them all off, there is a difference because it's as if the payment has been duplicated. Does QB always show bulk payments split like this when reconciling? It seem silly to not have the transactions listed exactly as bank statement when reconciling. How can i get the bank to reconcile?
7 REPLIES 7
EmmaM
QuickBooks Team

Bank Reconciliation

Hello Megan88

 

The bulk payment should show on the reconcile as you have matched it to multiple invoices and it should have a green box icon to show it was a banking match.The invoices you h ave matched too which also show do they have the green box and are they showing under type receive payment?

 

Can you click into one of the transactions that is not the bulk payment then check in more> audit history ,that it shows as a matched transaction in the banking.If you can then go back to the invoice itself and check against the payment on the invoice that it shows in the top left as online banking in blue writing and click on it and check the amount is the bulk amount.If it is can you reply back with a screen shot of this and also the reconcile page so we can look at this further

 

Thanks

Emma

Megan88
Level 2

Bank Reconciliation

Hi EmmaM Thank you for your quick reply. I matched the DD from the bank feed using ‘find match’. The screenshot below shows the bank reconciling without any difference, but the individual transactions have not been ticked.
JaneD
Moderator

Bank Reconciliation

Thanks for the screenshot, Megan88.

 

I can see that you've created an expense transaction that caused a duplicate in your reconciliation.

 

To fix this, you need to delete the expense and match the direct debit to your bill payment transactions. 

 

Here are the steps to delete the expense:

  1. Go to Accounting from the left menu.
  2. Then, select the Chart of Accounts tab.
  3. Locate the bank account and click on the Account history link.
  4. From the Filter icon, set all the fields to find the expense transaction and click on Apply.
  5. Once done, click on the expense and choose Delete.

I've attached some screenshots for reference.1.PNG

 

2.PNG

 

3.PNG

 

Then, let's manually match the direct debit transaction to your bill payments on the Banking page:

 

  1. Just go to Banking from the left menu.
  2. Locate and click on the direct debit transaction.
  3. Click on the Find match radio button and make sure to select Bill Payments from the Show drop down.
  4. Set the date field.
  5. Select all bill payments to match.
  6. Once you're done, just click on Save.

For further guidance, you can check out these articles:

After following these steps, you'll be able to complete your bank reconciliation process.

 

I'm also linking an article that will help you in the future: Reconcile a bank account and common troubleshooting tips [Video].

 

That'll do it. Let me know if you have any follow-ups or other questions. I'm here to help. Have a great day.

Megan88
Level 2

Bank Reconciliation

Hi JaneD Thanks so much for your reply. I have just gone to the 'Reviewed' transactions in the bank feed, clicked undo and then matched it against the invoices again and it appears to have fixed the duplicate issue. Why would it have posted as an expense? Every check I did seemed to show that the invoices were paid with 'Online banking match' so i can't really understand why it would have done this? Could it be that i added the DD to supplier account and then later allocated to the invoices instead of using the 'Find Match' option? Thank you
GeorgiaC
QuickBooks Team

Bank Reconciliation

Hey Megan88,

 

 

This would have been initially added directly from the banking For-Review tab by clicking 'Add' in the action column, rather than clicking into the transaction and selecting 'Find Match' and allocating against the separate bills . As it has been matched against multiple transactions it would not have automatically shown 'Match' on the action column which is why it may have been added error :)

Megan88
Level 2

Bank Reconciliation

Hi GeorgiaC That is exactly what I thought, thank you for confirming. :)
GeorgiaC
QuickBooks Team

Bank Reconciliation

Anytime Megan88 - please you have that sorted! :)

Need to get in touch?

Contact us