Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowWe purchased a small company and pay the previous owner based on PAID invoices for his customers, but we also need to calculate actual profit on any goods sold. I've tried manipulating reports to get this information, but I'm coming up empty. At this point, I have to go through each of his customers and record everything on a spreadsheet, including the inventory items that were sold and the cost of those items. Is there an easier way to do this? Again, he doesn't get paid until the customer pays us, which makes the equation even more complicated. I can't just use the P&L by class report because I also need to consider whether a payment has been made for each invoice produced.
Solved! Go to Solution.
Thanks for posting a question here in the Community, @judi-qb.
Allow me to share with you some insights on how you can run a report for your invoice payments transactions in QuickBooks Desktop.
First off, you'll have to make sure to record the payments when the invoices were paid and the items were taken by the customers. Check out this article to learn more on how to record invoice payments in QuickBooks Desktop: How do I enter invoice payments in QuickBooks Desktop.
Also, you'll have to ensure to use Cash as the report basis when running your Profit and Loss such as detail, standard, by class, etc. I'll guide you how:
Please see screenshots below for visual reference:
I'm also thinking of adding this article about customizing your reports which might come in handy to you so you can personalize your reports: How do I customize my reports in QB Desktop?
You're also able to memorize these customize reports. This way, you don't have to make another customization for the same report you wish to have: How do I memorize a report in QuickBooks Desktop.
Fill me in if you have more questions. I'll be here to help. Take care and have a great day!
Thanks for posting a question here in the Community, @judi-qb.
Allow me to share with you some insights on how you can run a report for your invoice payments transactions in QuickBooks Desktop.
First off, you'll have to make sure to record the payments when the invoices were paid and the items were taken by the customers. Check out this article to learn more on how to record invoice payments in QuickBooks Desktop: How do I enter invoice payments in QuickBooks Desktop.
Also, you'll have to ensure to use Cash as the report basis when running your Profit and Loss such as detail, standard, by class, etc. I'll guide you how:
Please see screenshots below for visual reference:
I'm also thinking of adding this article about customizing your reports which might come in handy to you so you can personalize your reports: How do I customize my reports in QB Desktop?
You're also able to memorize these customize reports. This way, you don't have to make another customization for the same report you wish to have: How do I memorize a report in QuickBooks Desktop.
Fill me in if you have more questions. I'll be here to help. Take care and have a great day!
Thank you so very much! The element I was missing is running the report as a Cash Basis!!!!! Thank you, thank you, thank you!!!!!!!!
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.