cancel
Showing results for 
Search instead for 
Did you mean: 
topdogsewer
Level 1

P&L & Undeposited Funds

Why are my undeposited funds not showing on my Profit & Loss statement as income? I receive the payment and deposit it into the correct bank account, but instead of the money that was actually taken in showing on the P&L it shows what has been invoiced- whether it has been paid or not. What am I missing here?

Solved
Best answer July 14, 2021

Best Answers
BigRedConsulting
Community Champion

P&L & Undeposited Funds

Payments received from customers don't use income accounts, so they'll never show up on your P&L.

 

A Payment uses your A/R account and either the Undeposited Funds account or can use a bank account directly, if you have that option enabled.

 

None of these accounts are income accounts.

 

Payments should be received against invoices, which do use income accounts - which is where your income is gathered for your P&L.

View solution in original post

10 Comments 10
Tori B
QuickBooks Team

P&L & Undeposited Funds

Hey there, @topdogsewer.

 

Thanks for reaching out to the Community for support and sharing your concerns.

 

It sounds like you may have some data integrity issues causing some of your undeposited funds to not show in your Profit and Loss statement as income. Let's run a quick Verify to ensure that's not the case. 

 

  1. Choose Window then Close All.
  2. Verify Data. Choose File then Utilities. Select Verify Data.

Should the verify discover some data integrity issues, you'll need to run the Rebuild utility to clear the errors. 

 

Here's how: 

 

  • Choose FileUtilities then Rebuild Data.
  • You will receive a warning message to backup your company file, press OK
    1. Select where you want to save your backup, then select OK at the bottom of the QuickBooks Desktop Backup window.
      • If a message asks if you want to replace another backup file, select NO. Enter a new name in the File name field and click Save.
    2. The Rebuild Data utility starts as soon as the backup is finished.
    3. Click OK when you get the message "Rebuild has completed".

Please, let me know how it goes. I want to ensure we get you back to business. I'll be sure to keep an eye out for your reply. 

 

Take care and have a great day ahead! 

topdogsewer
Level 1

P&L & Undeposited Funds

@Tori B Thank you so much for the advise! Unfortunately, I have verified data, rebuilt the data and restarted several times and the monies received from Undeposited Funds are still not showing on the P&L.

Rose-A
Moderator

P&L & Undeposited Funds

Allow me to step in and help you further with showing the monies on your Profit & Loss report, topdogsewer.

 

To get this sorted out, you need to ensure you select the correct date ranges and reporting basis.
 z.PNG

 

If you're still not seeing the funds, let's filter the report to show the information you need. Here's how:

 

  1. On the Profit & Loss screen, click Customize Report.
    x.PNG
  2. Go to the Filters tab, click Account and choose Multiple accounts.
    c.PNG
  3. Select the correct income account and hit OK.
    v.PNG
     

I recommend customizing the report to get the specific details you need. You can also memorize it to save its current customization settings. It serves as your record and helps you quickly access it for future use.

 

Feel free to get back to me if you have any other QuickBooks-related or other reports concerns. I'll keep an eye on your response. Have a great rest of your day!

BigRedConsulting
Community Champion

P&L & Undeposited Funds

Payments received from customers don't use income accounts, so they'll never show up on your P&L.

 

A Payment uses your A/R account and either the Undeposited Funds account or can use a bank account directly, if you have that option enabled.

 

None of these accounts are income accounts.

 

Payments should be received against invoices, which do use income accounts - which is where your income is gathered for your P&L.

Kels
Level 1

P&L & Undeposited Funds

hi - did you ever figure this out? 

Charies_M
Moderator

P&L & Undeposited Funds

Welcome to the Community, Kels.

 

While you can follow the previous recommendations from other users on this thread, I'd like to help you with your specific concern. May I know what are you trying to achieve while working with the Profit and Loss report? I would appreciate any details you can share to help me better understand your concern and provide an accurate solution.

 

For tips and related articles in the future about the "How Do I" steps in QuickBooks Desktop, visit our QuickBooks Community help website for reference.

 

I'm looking forward to hearing your response. It will be my pleasure to assist you. Have a good one.

Kels
Level 1

P&L & Undeposited Funds

hey there, thanks for the reply. after 2 days i finally figured it out! i was trying to show on my p/l cash that received for services (not deposited via a bank) and for the life in me i was not able to figure it out but i did! thanks anyway. 

Weeza
Level 1

P&L & Undeposited Funds

One income account is not showing in the P&L. I am using QBs Desktop Pro Plus 2023. I researched it and all of the invoicing and payments against are correctly done. That one account is just missing???

 

Weeza
Level 1

P&L & Undeposited Funds

I'm just budgeting looking at where we stand as a company. It is a glitch in the system because there is no reason why my income account with activity in it should not show up on the P&L.

 

jenop2
QuickBooks Team

P&L & Undeposited Funds

Hi there, Weeza.

 

Most of the time, transactions and accounts might not show up when running reports due to an incorrect date, accounting method, and data damage. Allow me to give you the steps that can help you sort this out. 

 

First, make sure that you have the right accounting method in the Report Basis section. There are times that an account or transactions would not show up when an incorrect reporting method is selected. Here's an article about this for more details: Differentiate Cash and Accrual Basis.


 

 

 

Second, use the QuickBooks Tool Hub to check if a possible data damage or causing the issue. Here's how:

 

  1. Download the most recent version (1.5.0.0) of the QuickBooks Tool Hub.
  2. Open the file you downloaded (QuickBooksToolHub.exe). You can look it up in your Downloads folder or in the location you selected when you downloaded it.
  3. Follow the on-screen steps to install and agree to the terms and conditions.
  4. Double-click the icon on your Windows desktop to open the tool hub.
  5. Once opened, look for Program Problems, then select Quick Fix my Program.
  6. Start QuickBooks Desktop and open your data file.

 

Please check out these articles for additional details about the steps that I've shared: 

 


After that, go back to your Profit and Loss report to check if the income account is already showing up. 

 

Just in case you need more guidance when running reports, fell free to check out these articles:

 

 

The Community is always here if you need anything else. 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us