Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello,
I am using QuickBooks Desktop. When I create a P&L report for year ending it does not show me all my transactions from customers. Under customer transactions report it does show all the transactions. I have checked the Item List to make sure all the information is correct but I didn't see any errors.
Solved! Go to Solution.
Only customer invoice transactions that have items linked to income accounts will show on your P&L. When you say "I have checked the Item List to make sure all the information is correct but I didn't see any errors.", are you saying that all items on the invoices in question are mapped to income accounts and are still not showing under income on your P&L? Invoices with items mapped to non-income accounts will do exactly as you describe - they will show under customer transaction reports but not on your P&L. If the invoices in question contain items linked to income accounts and are not showing on your P&L it can only be a few things:
1) You may need to rebuild your data. (File > Utilities > Rebuild data)
2) Make sure the invoice date is within the P&L dates (basic, I know).
3) Make sure the invoice is paid if you're running the report on cash basis (also basic).
Thanks for getting back to this thread, @drm4610. I get how challenging it can be when things don't go as planned—especially when creating a P&L report that doesn't generate all customer transactions for the year. Let's perform some troubleshooting steps to get your financial records back on track.
Since you already followed the solution provided by my colleague above, and the transactions are still not fully reflected in the P&L report, I'd recommend verifying and rebuilding your data. This process is designed to identify and resolve errors within the software, ensuring your records are accurate and complete.
If you continue to experience problems with your company file, you'll have to rebuild it.
Here's how:
1. Go to the File menu, then click Utilities.
2. Once the rebuild is finished, select OK.
Additionally, I'll drop this article you can browse to learn how to prevent finance charges from being assessed on an invoice, which can be handy for you moving forward: Assess finance charges.
Your concerns are important to me, so please don't hesitate to let me know in the comments below if there's anything else you need further assistance with. I'm eager to provide the support you need to streamline your transactions and ensure everything runs smoothly, @drm4610.
Hello there, @drm4610.
When pulling up a Profit and Loss report, only will show are those posting transactions affecting income and expense accounts. Since, you've mentioned that transactions from a customer aren't showing up, it's important to double-check the filters applied in the Profit and Loss Detail report.
Here's how:
Additionally, you may want to learn and understand reports in QuickBooks Desktop.
Furthermore, you can also access additional resources for managing your customer and vendor transactions through this links:
Feel free to comment below whenever you're having trouble regarding your Profit and Loss report. I'm here to help you!
Hey,
Thank You for the suggestion. I tired the steps recommended but it is still missing transactions in the report. Just to clarify the transactions which are missing from Customers are invoices sent and invoices paid by customers. It shows some transactions(invoices) for customers but missing others. It looks like QuickBooks is not mapping all the transactions.
Only customer invoice transactions that have items linked to income accounts will show on your P&L. When you say "I have checked the Item List to make sure all the information is correct but I didn't see any errors.", are you saying that all items on the invoices in question are mapped to income accounts and are still not showing under income on your P&L? Invoices with items mapped to non-income accounts will do exactly as you describe - they will show under customer transaction reports but not on your P&L. If the invoices in question contain items linked to income accounts and are not showing on your P&L it can only be a few things:
1) You may need to rebuild your data. (File > Utilities > Rebuild data)
2) Make sure the invoice date is within the P&L dates (basic, I know).
3) Make sure the invoice is paid if you're running the report on cash basis (also basic).
Thanks for getting back to this thread, @drm4610. I get how challenging it can be when things don't go as planned—especially when creating a P&L report that doesn't generate all customer transactions for the year. Let's perform some troubleshooting steps to get your financial records back on track.
Since you already followed the solution provided by my colleague above, and the transactions are still not fully reflected in the P&L report, I'd recommend verifying and rebuilding your data. This process is designed to identify and resolve errors within the software, ensuring your records are accurate and complete.
If you continue to experience problems with your company file, you'll have to rebuild it.
Here's how:
1. Go to the File menu, then click Utilities.
2. Once the rebuild is finished, select OK.
Additionally, I'll drop this article you can browse to learn how to prevent finance charges from being assessed on an invoice, which can be handy for you moving forward: Assess finance charges.
Your concerns are important to me, so please don't hesitate to let me know in the comments below if there's anything else you need further assistance with. I'm eager to provide the support you need to streamline your transactions and ensure everything runs smoothly, @drm4610.
Thank You everyone for the help.
You're most welcome, @drm4610.
I'm glad to hear that my colleagues have been of help in resolving your concern about the P&L report not showing all the customer transactions.
If you have any other questions or need further assistance, please do not hesitate to reach out. We are always here to help. Have a great day ahead!
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