Skip to main content
M
Megan88
August 7, 2019
Question

Bank Reconciliation

  • August 7, 2019
  • 1 reply
  • 0 views
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?

1 reply

E
EmmaM
August 7, 2019

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

M
Megan88Author
August 7, 2019
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
JaneD
August 7, 2019

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.

 

 

 

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.

Terms & ConditionsAccessibility statement