cancel
Showing results for 
Search instead for 
Did you mean: 
mforest
Level 4

Deposit in checking not showing up in bank reconciliation screen

I have an invoice that was paid to me by the customer.  However this amount is not showing up in the bank reconciliation screen under deposits.  It is in the checking account.  I noticed that while other customer payments in the deposit line have the account “undeposited funds” next to them this particular deposit only has the word “split” in the deposit line.  How do I get this deposit to appear in my bank reconciliation screen?

14 Comments 14
MarsStephanieL
QuickBooks Team

Deposit in checking not showing up in bank reconciliation screen

Hi there, mforest.

 

I'm here to help you deposit your invoice transaction correctly to your actual bank. The deposit is still there, the split transaction in the invoice it means that there's a deduction, like the delivery fees or any categories that can cause to lessen the amount of your deposit.

 

The Undeposited funds act as temporary storage before depositing it into the actual bank. Let me show you how to transfer the amount from Undeposited funds to your actual bank.

 

  1. In your QuickBooks company, select the Banking menu.
  2. Click Transfer Funds.
  3. Enter the correct details. 
    Note: Make sure that the amount you have received will be posted in this transaction so that it will match during the reconciliation process of your actual bank.
  4. Verify the information then hit Save & Close.

 

For future reference, you can check out: Reconcile an account in QuickBooks Desktop.

 

Let me know if you need further assistance. I'm ready to back you up. Take care and always take vitamins.

mforest
Level 4

Deposit in checking not showing up in bank reconciliation screen

Thanks for your reply. One of the transactions among the regular deposits is a refund from a utility. I credited the utility expense account. Do you think that is the problem?. Thanks again.

mforest
Level 4

Deposit in checking not showing up in bank reconciliation screen

Thank you for your answer.  One of the transactions I posted was a credit to the utility expense account when i revived a refund.  The other transactions are regular deposits from customers, Is that the problem?  Thanks again.

RCV
QuickBooks Team
QuickBooks Team

Deposit in checking not showing up in bank reconciliation screen

Thanks for coming back, mforest.

 

May I know how did you record the credits towards the utility expense account? This helps us isolate the issue better on why the deposits not showing in the bank reconciliation check.

 

Then, let's review the deposit transaction you've created if it was posted to the correct bank account.

 

To learn more about recording deposits and Undeposited Funds account, you can check out these articles:

 

Once done, let's go back to the Reconciliation page and choose the bank account or the correct date. Then, let's ensure the Hide transactions after the statement's end date is unchecked. 

 

Here's how:

 

  1. Click Banking on the top menu.
  2. Tap Reconcile.
  3. Select the correct bank in the Account fields.
  4. Choose the correct period for the Date fields.
  5. Tick Continue.
  6. Uncheck the Hide transactions after the statement's end date option.

I have a link here where you can find articles about reconciling your accounts: Reconcile your bank account with QuickBooks.

 

Keep me posted if you need a hand with running a reconciliation report or any QuickBooks related. I'll be here to ensure your success. Take care always. 

mforest
Level 4

Deposit in checking not showing up in bank reconciliation screen

I am sorry  I meant to say that I posted it as a debit to utilities expense.  It was a refund from utility company,so that makes it a a debit to the expense account.

CharleneMaeF
QuickBooks Team

Deposit in checking not showing up in bank reconciliation screen

Allow me to chime in, @mforest.

 

You’ll need to make sure you record the transactions to the correct bank account. Let me guide you on how.

 

  1. From the Homepage, select Record Deposits.
  2. In the Payments to Deposit screen, select the payments you want to combine. Then select OK.
  3. In the Make Deposits window, select the correct account you want to deposit in the Deposit to drop-down menu.
  4. Make sure to check the deposit total.
  5. Enter the date you deposited at your bank.
  6. Click Save and Close.

Once done, you'll need make to sure that the transaction is not yet in reconciled status.

 

Here’s how:

 

  1. Go to Banking menu.
  2. Select the Use Register tab.
  3. From the drop down menu, choose the correct account.
  4. Click OK.
  5. The check mark between PAYMENT and DEPOSIT shows the transaction is already reconciled.

You can check this article to learn on how  to view, print, export a reconciliation report.

 

Keep us updated by dropping a comment below if you have further questions. Have a nice day!

mforest
Level 4

Deposit in checking not showing up in bank reconciliation screen

I am sorry  I meant to say that I posted it as a credit to utilities and a debit to cash .  It was a refund from utility company.

mforest
Level 4

Deposit in checking not showing up in bank reconciliation screen

Yes that is the first hing i checked.  The deposit shows up in my checking account and it is not marked as reconciled.

mforest
Level 4

Deposit in checking not showing up in bank reconciliation screen

Maybe i am not explaining myself properly.  I have been doing this bank reconciliation for my checking account and all other deposits and expenses are visible. I am off the amount of the deposit in the checking account, but not appearing in the bank rec.  The entry is not marked as  cleared.   The only thing different about this entry is that the word “split” appears in the line next to deposits.  All my oter deposits went to “undeposited funds”   I have included a screenshot. Note the  $4470.08 is the one not showing up in the bnk rec.  It has the Split word.  The $800 deposit has the undeposited funds term.  The $800 did show up in the bank rec.

mforest
Level 4

Deposit in checking not showing up in bank reconciliation screen

Here is a breakdown of the problem deposit

Ashley H
QuickBooks Team

Deposit in checking not showing up in bank reconciliation screen

Thanks for the response and the screenshots, @mforest.

 

After looking into the screenshots, I noticed there isn't a Deposit account showing up on the register, but the breakdown is showing an account listed. This makes me think the Deposit is broken. No worries, all we have to do is delete this transaction and recreate it. I suggest speaking with your accountant before taking action in what I recommend below to ensure this is best for your books.

 

Before deleting this transaction, I recommend writing down all of the information. Here's how to delete the Deposit:

  1. Go to Lists at the top menu bar, then Chart of Accounts.
  2. Double-click the account, then double-click the Deposit.
  3. If you want to delete a specific payment, select it from the list.
  4. Now click the Edit tab at the top menu bar.
  5. Hit Delete Deposit if you want to delete the entire deposit.

Now we can recreate the Deposit so you can reconcile your books. I've provided the steps below:

  1. On the Homepage, go to Record Deposits / Make Deposits.
  2. In the Payments to Deposit window, select the payments you want to combine, then select OK.
  3. In the Make Deposits window, choose the account you want to put the deposit into from the Deposit to drop-down. In the Make Deposits window, select the account you want to put the deposit into from the Deposit to drop-down.
  4. Check the deposit total. Make sure the account and selected payments match the deposit slip from your bank. Use your deposit slip as a reference.
  5. Enter the date you deposited at your bank.
  6. Add a memo as needed.
  7. When you're done, hit Save & Close.

This should put you back on track with your reconciliation. 

 

If you hit any bumps along the way, don't hesitate and reach back out! I'm always here to help.

mforest
Level 4

Deposit in checking not showing up in bank reconciliation screen

Yes that is what I am doing. How do I account for the refund from the utility company?  I’ll just do that in a separate entry.

mforest
Level 4

Deposit in checking not showing up in bank reconciliation screen

I deleted all the prior payments and reentered them under Customer/receive payments.  The same thing happened.  The total is in my checking account, but it still wont show up in the reconciliation.  Once again the "split"  designation appears instead of the undeposited funds.

JoesemM
Moderator

Deposit in checking not showing up in bank reconciliation screen

Thanks for getting back to us, @mforest.

 

Since none of the steps provided above worked for you, I'd suggest reaching out to our Customer Support Team. They have tools to pull up your account securely and further investigate why your transaction won't show up in your reconciliation page.

 

Here's how: 

  1. Open QuickBooks.
  2. Click the Help tab then select  QuickBooks Desktop Help.
  3. Select Contact Us.
  4. Enter your concern, then select Continue.
  5. Tap Start messaging to chat with our support expert.

You can also browse useful topics in our help article to get answers to your product-related questions.

 

If you have any other questions in mind, please let me know. I'll be here to lend a hand. Take care always.

Need to get in touch?

Contact us