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

Deposits not showing to reconcile

I'm working on a client's bank rec and they have a sales invoice with 4 deposits of £500 on it. Usually, I'm able to fill out the deposit amount and reconcile off pretty easily. But, when I enter £2000 for this invoice, I can't find it to reconcile off against each amount of £500. If I change the deposit amount to £500 on its own then it works and I can reconcile it off.

 

Feels like this is probably a glitch but can't find anyone who has had this problem before.

Solved
Best answer July 29, 2025

Accepted Solutions
MirriamM
Moderator

Deposits not showing to reconcile

Thank you for your prompt response, Zach. The additional information and the screenshot you provided were helpful.

 

You’re right that entering £500 works because QuickBooks Online (QBO) matches payments to the exact amounts shown in your bank feed.

 

When you enter a lump sum of £2000, QuickBooks searches for a single £2000 deposit to match. However, since your bank feed shows four separate deposits of £500 each, it cannot identify a matching lump sum. Because the invoice was paid in four partial payments of £500, QuickBooks requires each payment to be matched individually.

 

Thus, you'll need to enter £500 on the invoice to match the first deposit, and then use the Receive payment feature to record the remaining three £500 payments separately. This way, you’ll be able to reconcile all four deposits totaling £2000 accurately.

 

If you have any follow-up questions, please feel free to ask in the comments. We'll get back to you.

View solution in original post

5 REPLIES 5
IrishA
QuickBooks Team

Deposits not showing to reconcile

This behavior occur depending on how deposits are recorded and matched within the QuickBooks, Zach.

 

With this in mind, may I know how you recorded the £2000? Was this recorded as a deposit? If possible, sharing further details or screenshots would help us provide a more accurate resolution.
 

The reconciliation of accounts in QuickBooks Online (QBO) relies on your bank statement. When deposits are listed as separate amounts of £500, they need to be matched to the corresponding entries in QuickBooks.

 

Recording the deposits as £500 each allows the system to identify and match them more easily, as the amounts align directly.
 

The four separate deposits of £500 we can record them individually in the Debtors account (Account Receivable). This will apply to your invoice of  £2000.
 

To do this:
 

  1. Navigate to the +New icon and select Bank Deposit.
  2. Scroll down to the Add funds to this deposit section.
  3. In the Received From column, enter the name of your customer.
  4. In the Account field, select Debtors (Accounts Receivable).
  5. Input the £500 amount. Repeat this process for the remaining three deposits.

 

Once the deposits are entered separately, you'll be able to match and reconcile them against the bank transactions in QuickBooks Online. This process ensures the invoice for £2000 is marked as fully paid, while also allowing you to reconcile the individual deposits of £500 accurately.

 

If you have any additional details, questions, or need further assistance, please don’t hesitate to leave your comment below.

zachlonsdale
Level 2

Deposits not showing to reconcile

I have attached the bottom of the invoice showing the breakdown including the deposit. When the £2,000 deposit is changed to £500, I can match bank transactions also worth £500 to this. Is there a way I can leave this as £2,000 and then match the 4 transactions of £500 separately given that these deposits have been imported from bank statements into QuickBooks? 

MirriamM
Moderator

Deposits not showing to reconcile

Thank you for your prompt response, Zach. The additional information and the screenshot you provided were helpful.

 

You’re right that entering £500 works because QuickBooks Online (QBO) matches payments to the exact amounts shown in your bank feed.

 

When you enter a lump sum of £2000, QuickBooks searches for a single £2000 deposit to match. However, since your bank feed shows four separate deposits of £500 each, it cannot identify a matching lump sum. Because the invoice was paid in four partial payments of £500, QuickBooks requires each payment to be matched individually.

 

Thus, you'll need to enter £500 on the invoice to match the first deposit, and then use the Receive payment feature to record the remaining three £500 payments separately. This way, you’ll be able to reconcile all four deposits totaling £2000 accurately.

 

If you have any follow-up questions, please feel free to ask in the comments. We'll get back to you.

zachlonsdale
Level 2

Deposits not showing to reconcile

I appreciate the advice here. That was my original idea but was hoping there would be some neat work around. Would there be any other way of doing this so that the whole £2000 deposit is recorded as such or will that just be taking up more time than it's worth at that point?

JamesDuanT
Moderator

Deposits not showing to reconcile

The steps outlined by my colleagues above are the most effective methods for recording invoice payments to align with the deposits shown on your bank statement and in Banking, Zach.


You can also consult your accountant to explore alternative ways to ensure your bank statement matches the records in QuickBooks Online.


Feel free to reach out if you need any additional assistance.

Need to get in touch?

Contact us