Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
July 29, 2025
Solved

Deposits not showing to reconcile

  • July 29, 2025
  • 1 reply
  • 6 views

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.

Best answer by MirriamM

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.

1 reply

QuickBooks Team
July 29, 2025

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.

July 29, 2025

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? 

MirriamMQuickBooks TeamAnswer
QuickBooks Team
July 29, 2025

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.