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?
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.
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.
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.
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.
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.
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.
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.
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.
Once done, you'll need make to sure that the transaction is not yet in reconciled status.
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!
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.
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:
Now we can recreate the Deposit so you can reconcile your books. I've provided the steps below:
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.
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.
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.
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.