News & Special Offers

QuickBooks Sale!

Dell All-in-One w/touchscreen

Dell Inspiron One All-In-One Computer / AMD Athlon II X2 Processor

How to Use Items to Track Profitability in QuickBooks

We have setup Items to track the expenses related to purchasing/maintaining/operating equipment and we want to also track revenue associated with equipment rental. For example, we purchase a tractor for $5000 & spend $1000 in fuel/oil & $100 in repairs/maintenance. We have separate expense accounts for all these items (we are a nonprofit and have to record these as we are funded for them). We have decided to rent the equipment to generate revenue. How can we (using a single item called tractor) link the various expenses as well as potential revenue, so that we can evaluate our profit loss on that item?
If you want to use items to track profitability, you should set it up as non-inventory item, if you think you might sell the tractors at some point. If not, set it up as a service item. Check the box next to “This item is used in an assembly…” and you’ll be able to enter both the revenue and expense accounts. You should probably use a cost of goods sold account for your expense account. Make sure to use the Items tab instead of the Expenses tab on all your purchase transactions (i.e., Enter Bills or Write Checks). Then use an Item Profitability report (Reports > Jobs, Time & Mileage) to evaluate the profitability.

However, you might find it easier to setup a class called tractors. This will also allow you to use more than one revenue and expense account. If you don’t have classes activated yet, go to Edit > Preferences > Accounting > Company Preferences and check the box next to Use class Tracking (you may need to be logged in as Admin to do this).  Make sure to enter the class on all your revenue and expense transactions related to your tractors.  Then you can use the Profit & Loss by Class report (Reports > Company & Financial) to evaluate profitability.


If we helped solve your problem, please consider posting a review for us!

Ruth Perryman - QuickBooks Specialist Written by +Ruth Perryman, CMA, CFE, CFM, MBA

Ruth is the president of The QB Specialists, Inc. and has provided QuickBooks help to thousands of businesses around the world since 1996. She is an Intuit Solutions Provider, an Advanced Certified QuickBooks ProAdvisor, and a member of the Intuit Trainer/Writer Network. She is also certified in QuickBooks Point of Sale and QuickBooks Enterprise Solutions.

Buying QuickBooks for a client? Call us at 800-707-0940 to discuss what we can do to help!

QuickBooks price list | QuickBooks for sale | Free trial QuickBooks POS | Free trial QuickBooks Enterprise

Leave a Reply

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

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>