This is a long post with several questions - sorry.
We have a Cash Box in our home.
When we started with QBO several weeks ago, I thought the Undeposited Funds could simply be equivalent to our Cash Box, so I entered the amount in the box as the opening balance (equity) of Undeposited Funds.
I have gotten 20 contributions which I've added to Undeposited Funds in QBO and to our Cash Box. Now there are a total of 21 line items in Undeposited Funds - the 20 contributions and the opening balance.
Then I deposited money in our bank.
The amount of the deposit was greater than the 20 contributions by about $500 U.S. but less than the total in the Cash Box.
Now I can't figure out how to enter the Bank Deposit in QBO because:
a) There seems to be no way to split the Opening Balance in the checklist to make up the difference.
b) If I try to bypass the Opening Balance and enter part of it in the table beneath for additional deposits, the system won't let me because the Undeposited Funds is not a bank!!!
c) I can't change the Undeposited Funds account to be a bank.
----------------------------------------
I can think of four workarounds and want your opinion:
Do I make a journal entry to split the equity? How? (This feels the cleanest if I can be shown how to do it.)
Do I create a separate account for cash on hand and transfer the $ from the Undeposited Funds to the Cash on Hand as necessary?
Do I create a separate account for cash on hand, edit the transactions so that they are in the cash on hand account, and use it in the future, bypassing the undeposited funds altogether?
A related question to all of this: I experimented and if I deposit two checklisted items, they are not combined in the deposit. Instead, the Bank register is split. There's no way around that, is there? Each of them eventually needs to be resolved.... Given that, maybe the best is to have a separate Cash-on-Hand account?
Oh, well.
Thanks for your patience in reading my little tome.
Any help would be greatly appreciated!
Solved! Go to Solution.
Undeposited Funds and Bank Accounts refer to different concepts. I'm here to provide the distinction between the two to guide you through the process, LCUUF.
The Undeposited Funds is a temporary account used to hold payments you receive but have not yet deposited into your bank account. This serves as a holding area for cash or checks that you plan to deposit.
While bank accounts like checking, savings, and petty cash accounts represent actual bank accounts that your business owns and the real money available to the business.
When you receive a payment in QuickBooks, it is automatically recorded in your Undeposited Funds account. When you're ready, you can consolidate all payments into a single deposit transaction to your bank account.
You'll also have the option to select the Cash Box account. under the Deposit To field at the time of receiving the payment. This allows you to allocate the amount directly to the Cash Box account instead of placing it in Undeposited Funds. I've added a screenshot for your visual guide:
Next, move the amount from the Cash Box account to your actual bank account.
To give you an overview of how Undeposited Funds works, check this article for more details: Deposit Payments into the Undeposited Funds in QuickBooks Online.
Additionally, learn how to categorize downloaded transactions once you connect your bank. Go through this article for reference: Categorize Online Bank Transactions in QuickBooks Online.
Post your reply below if you have any other follow-up questions about Undeposited Funds and bank deposits. I'll be one post away if you need further assistance.
Create a bank account in QBO called Cash Box. Then, make a transfer (New > Transfer) from Undeposited Funds (UF) to Cash Box for the amount of your opening balance equity (OBE) that you are leaving in the Cash Box. You should now have the 20 contributions and the amount of OBE that you're depositing sitting in UF. Go to New > Bank deposit and select the 20 contributions plus the Transfer and you should be all set.
EDIT: "Go to New > Bank deposit and select the 20 contributions plus the Transfer and you should be all set. "
The amount that makes up the amount of OBE being deposited will show up on your Bank Deposit screen as a couple of different line items depending on how the original OBE amount was entered into UF.
This was extremely helpful. We have just begun to set up QBO and will simply delete the file and do it correctly.
This was a great answer. We just began to set up QBO, so we have wiped the file and will start correctly. However, another question has arisen.
We are in Mexico and our home currency will be $MX. However, many of our donors pledge in $U.S.
My understanding is that one cannot invoice for a given donor in more than one currency. How do we handle a situation where a donor pledges in $U.S. this year but in $MX next year?
Thanks for your patience.!
We are glad to hear that our colleague's advice helped you resolve your concerns, LCUUF. Regarding your follow-up question, you can set up and use the multi-currency feature to record the pledge using other currencies. Let me provide the steps on this below.
Here's how to enable it:
Once done, follow step five in the Learn about section of this resource to record transactions in Mexican currency: How to use Multicurrency in QBO.
In addition, I will attach these helpful articles for you to reference in future tasks:
As always, you can freely visit our Community Forum for additional questions or concerns about setting up and adding multiple currencies. Kindly save this thread or click the Reply button below, and I will quickly respond and offer further assistance. Take care!
Disclaimer: I've updated my response to offer more clarity regarding the follow-up question.
Thank you Jevee -
I have two follow-up questions.
---------------------------------
I have completely reset QBO and now have a Cash Box account (which is mirrored by an actual cash box) that has the starting balance = the current contents of our physical cash box.
Thus, I now have two accounts for cash funds in my Chart of Accounts -
Undeposited Funds (which is currently empty)
Cash Box (Bank/Cash on Hand) which reflects the petty cash balance in the physical box.
Our process is as follows: Our Sunday collection has two components - general cash donations; and cash Pledge payments in envelopes.
The Pledge payments are individually posted in QBO under "Receive Payments". The total cash donation for the service is posted in QBO under Sales Receipt. Then all the cash goes in our cash box. When the amount in the cash box reaches a certain threshold, we deposit the money in the bank.
Both the "Receive Payment" form and the "Sales Receipt" form have a "Deposit To" box that must be completed.
There are two possible account choices in the Deposit To drop-down menu:
Undeposited Funds or Cash Box.
My understanding is that initially I want to put the funds in the Undeposited Funds account. This keeps the QuickBooks accounts 'clean' and keeps information where QuickBooks needs it for accurate reporting.
1) Is the above in bold correct?
2) Next and final (I hope) question about this topic:
Do I want to make bank deposits from Undeposited Funds, or do I want to transfer from Undeposited Funds to the Cash Box account (which would reflect our physical reality) and execute Bank Deposits from there????? In other words, going forward, where in QuickBooks should our physical cash box contents be reflected?
Sorry for my confusion.
Ted
Undeposited Funds and Bank Accounts refer to different concepts. I'm here to provide the distinction between the two to guide you through the process, LCUUF.
The Undeposited Funds is a temporary account used to hold payments you receive but have not yet deposited into your bank account. This serves as a holding area for cash or checks that you plan to deposit.
While bank accounts like checking, savings, and petty cash accounts represent actual bank accounts that your business owns and the real money available to the business.
When you receive a payment in QuickBooks, it is automatically recorded in your Undeposited Funds account. When you're ready, you can consolidate all payments into a single deposit transaction to your bank account.
You'll also have the option to select the Cash Box account. under the Deposit To field at the time of receiving the payment. This allows you to allocate the amount directly to the Cash Box account instead of placing it in Undeposited Funds. I've added a screenshot for your visual guide:
Next, move the amount from the Cash Box account to your actual bank account.
To give you an overview of how Undeposited Funds works, check this article for more details: Deposit Payments into the Undeposited Funds in QuickBooks Online.
Additionally, learn how to categorize downloaded transactions once you connect your bank. Go through this article for reference: Categorize Online Bank Transactions in QuickBooks Online.
Post your reply below if you have any other follow-up questions about Undeposited Funds and bank deposits. I'll be one post away if you need further assistance.
Exactly what I needed. ¡Muchas gracias, Maria!
You are very much welcome, LCUUF.
I'm glad that my colleague, @MariaSoledadG, was able to assist you with your concern about Undeposited Funds . This topic is particularly important for maintaining accurate financial records.
The Community team is always here if you have any further questions or need additional guidance as you work through these steps, feel free to click on the Reply button. Your proactive approach is commendable. Take care!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here