Blog

Creating a Job Profitability Summary Report in QuickBooks

quickbooks-audit-trail

QuickBooks offers a lot of great reporting functionality. The job profitability summary provides gross margin dollars and gross margin percentages on jobs and projects on a regular basis. This report is good for contractors, service providers and others whose work is based on projects.

The report gives you a snapshot of your jobs so that you can see which ones are profitable in terms of job costs related to the invoices, but there is a bonus to using this report. It allows you to perform the following three quality checks:

1. Improved Recording Accuracy. Many companies have complex distribution, such as when a company places an order from one location but the product is distributed to a different location. This type of purchase creates a one-sided entry for both accounts in QuickBooks. The Job Profitability Report helps you find these errors and correct the posting so that you have an accurate picture of the profit and loss margin for this sale.

2. Catch Duplicate Billings from Vendors. Occasionally, you will find that a vendor has double billed for a product. In reviewing the Job Profitability Report, you will see if you have been accidentally double billed for a product from the vendor.

3. Apply Bulk Purchases to Clients. Many companies purchase items in bulk for better pricing. When this happens, all of the expense for the items goes against the company and not to the actual customer purchasing the product. If the company is not using an inventory tracking system, they have no way of allocating the cost to an individual sale for cost comparison.

By reviewing the Job Profitability Summary report, you can find such transactions and breakdown the bulk purchase to record these costs correctly. You will be looking for any transactions that have actual revenue without an actual cost offset. Once you find the sales receipt transaction, you can add the customer purchasing information to the Invoice, providing you with accurate numbers once again.

If you need help reconciling your general ledger using the Profitability Summary Report, contact us!

author-avatar

About Marjorie Adams

Our head QuickBooks trainer and guru, Marjorie Adams, is Founder and CEO of Fourlane, Inc., an award-winning consulting firm and Intuit’s #1 QuickBooks Reseller Partner. Fourlane’s team of experts offers several QuickBooks oriented services including consulting, training, programming, integration, and more. Over the years, Fourlane has helped over 10,000 customers across many different industries with their QuickBooks accounting software. Marjorie Adams is considered one of the top QuickBooks trainers in the country. She was listed on CPA Practice Advisor’s 40 Under 40 in 2014 & 2015, and has been recognized as Intuitive Accountant’s 2015 QuickBooks Desktop ProAdvisor of the Year. Marjorie sits on Intuit’s VIP Program, is a frequent contributor to Inuit Accountants News Central, and has developed Intuit’s QuickBooks Enterprise Certification training. She has also been published in The Wall Street Journal, Forbes, BusinessWeek, American Express Open, the Huffington Post, and Inc. Magazine.

One thought on “Creating a Job Profitability Summary Report in QuickBooks

  1. Lynn Leader says:

    Is there anyway to run a report by customer by gross margin without running the sales by summary for each customer? I want one report that shows items sold by customer with costs and gross margin. I have researched and was not able to find anything within quickbooks 18.0

Leave a Reply

Your email address will not be published. Required fields are marked *