Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
belowradar
Level 1

undeposited funds and deposits on the bank ledger not showing up on P&L

I 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.

6 Comments 6
ReymondO
Moderator

undeposited funds and deposits on the bank ledger not showing up on P&L

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:

 

  1. Click Reports in the left menu.
  2. Select Company & Financial.
  3. Choose Balance Sheet Standard

 

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.

belowradar
Level 1

undeposited funds and deposits on the bank ledger not showing up on P&L

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?

Catherine_B
QuickBooks Team

undeposited funds and deposits on the bank ledger not showing up on P&L

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!

belowradar
Level 1

undeposited funds and deposits on the bank ledger not showing up on P&L

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.

LieraMarie_A
QuickBooks Team

undeposited funds and deposits on the bank ledger not showing up on P&L

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:

  1. Go to the Reports menu.
  2. Select Company & Financial and choose Profit and Loss by Class.
  3. Modify the reporting period.
  4. You can also filter the classes that you want to show in the report. Click on the Customize Report button.
  5. Select the Filter tab.
  6. Enter and select Class from the list of filters.
  7. Under the Class dropdown, select biz.
  8. Click OK.

 

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.

belowradar
Level 1

undeposited funds and deposits on the bank ledger not showing up on P&L

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.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us