Chart of Accounts

You’re Gonna Need a Bigger Chart of Accounts

Here’s a common situation: an MSP or IT service provider is using a PSA—let’s say ConnectWise (CW)—along with QuickBooks Online (QBO). They’re getting some decent reports out of CW, and their bookkeeper prepares financial statements in QBO every month.

But there’s a problem: the two systems don’t really talk to each other in a meaningful way.

They can see tech utilization and customer profitability reports in CW. They can see the bottom line in their QBO reports. But what they can’t see is how those two connect.

That’s a fixable problem, and the first step? A better chart of accounts.

👉 Click here to grab our free CSV of a recommended MSP Chart of Accounts (COA).

Revenue: Categorizing the Right Way

Let’s say our MSP is fairly typical. They primarily engage customers through a Managed Services contract with monthly billing based on users or endpoints. But they also have some break/fix work, plus projects, cloud services, and hardware resale.

To get a clearer financial picture, we need to create separate revenue accounts for each of these four categories. That way, we can track how much each is growing.

But revenue is only half the picture.

What About Profitability?

Knowing how much revenue each category brings in is great, but what we really want to see is how profitable each category is.

To do that, we need to track Cost of Sales (also called Cost of Services). This allows us to calculate Gross Profit by line of business—and once you see that, there’s no going back.

Of course, this only works if your PSA is set up to track these costs properly. If it’s not, we’ll have to fix that—but with a clear purpose in mind.

Designing the Rest of Your Chart of Accounts

A solid COA isn’t just about revenue and costs—it should be designed with three key principles in mind:

  1. Balance Between Simplicity and Detail

You want to break things down enough to get useful insights but not so much that you spend all your time categorizing transactions.

  1. Make Life Easier for Your Tax Provider

A well-designed COA means fewer headaches (for you and your tax accountant). Unlike their other clients who bring them a shoebox full of receipts, you’ll be handing over clean, categorized financials.

  1. Built-in Flexibility

Your business will evolve, and so should your COA. Leave room for adjustments as your company grows and your financial tracking gets more sophisticated.

📌 Reminder: You can download a free CSV of our recommended MSP Chart of Accounts here.

In our next blog, we’ll cover how to categorize tech costs properly—because knowing what to put where is just as important as having the right accounts in the first place.

Stay tuned!

Download a Free CSV of Our Recommended MSP Chart of Accounts

Share this post

Recent Posts

About

John Risko brings over 30 years of expertise in accounting and financial strategy, guiding businesses across industries such as advanced manufacturing, communications, energy, and IT services.

Blog

Subscribe to receive a notification of our monthly blog

Read More