Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI use the "undeposited funds" feature in quickbooks desktop. After understanding this feature I have a new problem.
Once I go through the invoice procedure and use undeposited funds this transaction is listed on my bank ledger but I have no way of showing this deposit on the P&L? For instance...If i had a client have 1k each week for undeposited funds deposit for a total of 52k where is this number on my balance sheet, p&l reports? I need this income number generated...
I did read someone used a "dummy" account for undeposited funds and then classified their deposits with their own income codes.
Hi there, @belowradar.
Let me share some insights on how QuickBooks enter your data in reports.
The Profit and Loss report shows your income, expenses, and net income (profit or loss). This summarizes your company's revenues, costs, and expenses during a specific period of time.
Since Undeposited Funds is an asset to your business, this won't be reported in the P&L report.
You can run the Balance Sheet report instead. This reports the assets, liabilities, and shareholder equity at a specific point in time.
Here's how:
Moreover, you can customize the data, add or delete columns, and even personalize the font and style of the report. These filters will narrow the scope of the information in a report.
Just tag my name in the comment section if you have any other concerns or questions. I'll get back to you as soon as I can. Stay safe.
Allow me to pose this question a different way.
Month one: I created an invoice for $1,000 and went thru "receive payments" and "make deposit" process thru quickbooks. It is now a transaction on my bank ledger as a DEPOSIT and is coded as coming from "undeposited funds" I also have made a class for it "biz".
Month two: I created an invoice for $1,200 and went thru "receive payments" and "make deposit" process thru quickbooks. It is now a transaction on my bank ledger as a DEPOSIT and is coded as coming from "undeposited funds" I also have made a class for it "biz".
Month three: I created an invoice for $1,777 and went thru "receive payments" and "make deposit" process thru quickbooks. It is now a transaction on my bank ledger as a DEPOSIT and is coded as coming from "undeposited funds" I also have made a class for it "biz".
For the sake of typing the rest of my twelve month of revenue:
Month four: $2,700
Month five: $3,555
Month six: $3,384
Month seven: $1,221
Month eight: $2,999
Month nine: $1,000
Month ten: $1,800
Month eleven: $1,450
Month twelve: $1,200
And we can all agree I will have 12 deposits that are listed on my bank ledger coded as "biz" from account: "undeposited funds". (In the past I had not used quickbooks invoicing and simply coded my deposits as "BelowRadarRevenue" and this is simply generated on reports from quickbooks but these are now coded as "undeposited funds" and when I try to change "from account" I get this pop up:
you cannot edit payment information in a deposit transaction. 1) delete the payment from the deposit 2) go to the original payment transaction to edit it 3) redeposit the payment
Regardless,
Getting back to my question @ReymondO :
Due to me owning a calculator we can agree that my 12 month revenue total = $23,286
How can I get quickbooks to generate this number on P&L or balance sheet or relevant report etc?
Hello there, belowradar.
If you're using QuickBooks Payments, once you have processed your payments, QuickBooks puts the money in your bank account. It uses the bank account you picked when you signed up for the merchant services. You can check the account you selected to verify if deposits are posted to the correct bank account and not on Undeposited Funds.
Undeposited Funds account clear out any payments waiting to be deposited. This way, you can combine payments on the Deposit window. It's possible that there are deposits that didn't get linked on the invoices that's why the amounts don't match the actual deposit posted in your financial reports. Ensure that the affected accounts are the posting or bank accounts instead of Undeposited Funds.
Feel free to use these links that will help you manage customer transactions:
Need more assistance? Let me know by posting again here. Take care always!
Great reply. I appreciate the attention. Now...
Due to me owning a calculator we can agree that my 12 month revenue total = $23,286
How can I get quickbooks to generate $23,286 on P&L or balance sheet or relevant report etc?
Am I not phrasing this correctly? This seems like a reasonable request.
*Note if the answer is: "you are not able to" then say so.
Allow me to chime in and clear up your confusion, @belowradar.
Did you assign the class on the invoices? If you classified them to biz, you can run the Profit and Loss by Class report to get your 12-month revenue of $23,286.
Here's how:
If you're not seeing the total amount of $23,286 income, make sure you've assigned all your invoices to biz. To verify it, double-click the income amount. From there, you'll see the list of invoices included.
Additionally, if you need to deposit the money into your bank account, refer to this article: Record and make bank deposits.
I'm always here if you need more help with getting your desired report. I'm determined to ensure your success.
Thank you. I appreciate this response.
If anyone cares this was eye opening in the sense that I needed to make sure all my invoice item lists were coded as the correct "revenue" and yes they were all classified as "biz"
This was a teaching moment on "invoice item lists" and how they spit out data and I happen to be looking at the "deposit screen" (and bank ledger transactions) end of things which confused me. Appreciate the perspective.
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