How to Track Revenue from Two Customer Groups in QuickBooks |

I have a dilemma and I need your help to know how to handle it. In Our P&L we want to review and keep track of our revenues from 2 customer groups: Annuity Clients & Backfile Projects. We do scanning work for Annuity Clients weekly/monthly or as they need. Backfile Project clients are one time deals. My questions is what is the best way to track these 2 categories in QuickBooks? Do I need to divide the customers into 2 groups – if so how? I really would appreciate your advice on this issue.

You've got several options. The easiest is to just have two separate revenue accounts, one for each client, and create service items that are linked to each account.

You could also use customer types. This is a better option if there are also expenses associated with your customer types because you can filter many reports by customer type, including your P&L. Exporting your customer list is the easiest way to add them. However, this creates a separate, filtered P&L for each customer type.

You could also use classes and the P&L by Class report. The drawback to that is you’ll have to open every transaction and add a class to it. Very tedious.

Visit our webstore for huge savings on QuickBooks!

This article is provided for informational purposes and is not intended to be construed as legal, accounting, or other professional advice. For further information, please consult appropriate professional advice from your attorney and certified public accountant.

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

Ruth is the president of The QB Specialists, an Intuit Premier Reseller that offers huge savings and expert advice on QuickBooks POS and QuickBooks Enterprise. She is an Advanced Certified QuickBooks ProAdvisor and a member of Intuit’s Trainer/Writer Network. She is also certified in QuickBooks POS and QuickBooks Enterprise and has provided expert QuickBooks help to thousands of businesses all over the world since 1996.

Web Store | Price List | Free Trials | Newsletter