Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
My P&L report shows bills and invoices in sales portion which distorts sales . I can't see anything wrong in filters just as standard P&L report no customization...
Solved! Go to Solution.
I assume you're not entering an income account - your "Sales" account - on your bills directly, or you'd know why they're showing up on the P&L using the account.
Bills will use income accounts in cases where you use items / are purchasing items that have only one account, an income account.
To avoid this, edit the items you're purchasing on your bills and enable the purchase option. It'll have a different title depending on the type of item, and your QB version, but it'll always appear in the location seen here:
When you check the box, then you'll see options for values to use when you purchase the item:
When you add the Expense account and then save the item, you'll get a prompt like this:
Answer Yes, and then all of your purchases that you don't want to use your sales account will be updated to use the new purchase/expense account.
I appreciate the screenshot you've provided. Let me share some information on why invoices and bills are showing up on your Profit & Loss report in QuickBooks Desktop, ACE15.
I can see that you're looking at the Profit & Loss Detail report. You'll see the invoices and bills there because this statement provides a line item for every variable that affects profit, rather than combining income and expense items.
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.
This should keep you moving today, ACE15. Don't hesitate to let me know if I can be of additional assistance while working in QuickBooks or need more help with your profit & loss report. I'm always here to keep helping. Have a good one!
No that didn't work either sales still contains bills
Thanks for coming back, @ACE15.
I have some information about the bills in our Profit and Loss report. These are transactions associated with your customers (For example an expense billable to a customer).
You can check the bills if they are billable or not by clicking the bill transaction itself. If these bills are not billable, you can delete the customer's name in the Customer:Job column.
Additionally, you can re-sort your master name list. Re-sorting will help you fix odd behavior in the program and makes your list go back to their default order. Please check out this guide for the detailed steps: Re-sort lists in QuickBooks Desktop.
In case you need help with other tasks in QBDT, browse this link here to go to our general topic with articles.
Keep me posted if you still have questions or concerns with reports. I'll be around to help. Take care and have a great day ahead.
I assume you're not entering an income account - your "Sales" account - on your bills directly, or you'd know why they're showing up on the P&L using the account.
Bills will use income accounts in cases where you use items / are purchasing items that have only one account, an income account.
To avoid this, edit the items you're purchasing on your bills and enable the purchase option. It'll have a different title depending on the type of item, and your QB version, but it'll always appear in the location seen here:
When you check the box, then you'll see options for values to use when you purchase the item:
When you add the Expense account and then save the item, you'll get a prompt like this:
Answer Yes, and then all of your purchases that you don't want to use your sales account will be updated to use the new purchase/expense account.
All of your corrective instruction did not correct the problem of P&L including bills. I tried both accrual and cash repots and the bills are still showing up. We do not use Customer:Job or Item tracking; any suggestions?
This is not the impression we want you to experience when running the Profit and Loss report, WYO2021.
I appreciate you for performing the solutions provided by my colleagues. To better isolate this one, let's try opening another company file to check if you're having a problem with only one file and not the program itself. Let me show you how:
Then, try running the report again to see if sales are showing both bills and invoices. If it works, it's possible there may be a damaged data on the company file you've been working with. We can run the Rebuild Data tool is built-in to fix any company file data issues. Just follow the steps and detail in the Fix data damage on your QuickBooks Desktop company file article. We can also repair your QuickBooks Desktop to fix any damaged components in the software.
If the problem persists, I'd suggest contacting our Technical Support Team. They'll pull up your account in a secure environment and investigate what's causing this issue. You may send a message via chat, call us at a time convenient to you, or we’ll get in touch with you instead. To ensure we address your concern, our representatives are available from 6:00 AM to 6:00 PM on weekdays and 6:00 AM - 3:00 PM on Saturdays, PST. See our support hours and types for more details about this one.
Visit our Reports page for more insights about managing your reports in QuickBooks.
Feel free to update us after contacting our support or performing the solutions, as I want to ensure this is resolved for you. Please reply to this post and I'll get back to you. Have a great weekend.
It looks like this is a duplicate post, @Manizha1983.
My colleague GlinetteC already shared her answer about your concern regarding running the Profit and Loss report. You can check her response through this link: https://quickbooks.intuit.com/learn-support/en-us/other-questions/p-l-shows-both-invoices-and-bills/...
You might also want to learn how to memorize reports in QuickBooks Desktop. This allows you to save it with its current customization settings.
The QuickBooks Community team is always here to help if you have any other concerns or follow-up questions. Have a good one, @Manizha1983.
Thank you Mark, yes Glinette responded to my comment. I run the P&L exactly the same was but when I click on the sales account I see invoice and bills where I should only be seeing invoices.
thanks
Welcome to the Community, Manizha1983.
There may be transactions associated with your customers as an expense billable to a customer. This shows the bills in the Profit and Loss report. Just check the bills if they are billable or not by clicking the bill transaction itself. If these bills are not billable, we can delete the customer's name in the Customer:Job column.
Also, bills will use income accounts when using items that are purchasing items that have only one account (an income account). To resolve this one, follow the steps provided by BigRedConsulting on this thread. Then, try running the report again to see if sales are showing both bills and invoices.
If the same thing happens, there may be damaged data on the company file you've been working with. We can run the Rebuild Data tool is built-in to fix any company file data issues. Just follow the steps and detail in this article: Fix data damage on your QuickBooks Desktop company file article. We can also repair your QuickBooks Desktop to fix any damaged components in the software.
Feel free to visit our Reports page for more insights about managing your reports in QuickBooks.
Please let us know after performing the steps provided, as I want to ensure this is resolved for you. Just reply to this post and I'll get back to you. You have a good one.
This is great info, however, in your example you used a "Non-Inventory Part". We only have Inventory Parts, and the "purchasing option" you highlighted is not showing in those Item set-ups. How can I get those Bills out of my P&L Sales? Please advise.
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