
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.
Free Download: Get the MSP Chart of Accounts Template built for managed service providers who want clearer financial reporting by revenue type, COGS, payroll, vendors, and line of business.
👉 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:
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.
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.
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.
Moving Into Your New Chart of Accounts
Designing a new chart of accounts is the easy part.
Moving into it is where the real work begins.
If you have been operating under a different structure, you cannot just flip a switch. You have routing, habits, and systems built around the old structure. Those need to change.
Here is what that typically involves.
1. Rerouting Billing from Your PSA
Billing from your PSA, whether ConnectWise, Autotask, or another system, is normally routed into QuickBooks using your existing revenue accounts. If you adopt a new MSP chart of accounts, that routing needs to be updated so revenue flows into the correct categories.
If this step is not handled carefully, you end up with a hybrid structure. That defeats the purpose of doing the work in the first place.
2. Allocating Tech Labor Properly
Most MSPs post all technician labor into a single account.
With a more intentional chart of accounts, labor should be allocated across lines of business such as:
- Managed Services
- Projects
- Time and Materials
- Telecom, Security, or other specialized services
For a deeper breakdown of how to do this correctly, see our guide on allocating tech labor correctly.
This is one of the most meaningful upgrades you can make. It directly impacts gross margin clarity and your ability to understand which parts of the business are truly profitable.
3. Rerouting Credit Card Costs
Vendor and tool costs often flow through a credit card and get coded to broad expense buckets.
Under a refined structure, those charges need to be categorized into the correct cost buckets so they align with your revenue structure. Otherwise, your gross profit reporting will be distorted.
4. Aligning Procurement and Payables
If your PSA routes purchase orders, receipts, inventory, or payables into QuickBooks, those integrations must also be aligned to the new accounts.
When PSA and QuickBooks are aligned properly, you can report on granular detail while still maintaining a clean accounting framework.
In short, every automated pathway that touches QuickBooks should be reviewed.
There is usually an initial lift. But once it is set up correctly, the clarity is worth it.
Taking Care of Your New Chart of Accounts
Creating a better structure is not the finish line.
It is the starting line.
Use It or Lose It
If you restructure your chart of accounts but never look at reporting based on it, the system will slowly decay.
- People will make coding mistakes.
- Transactions will drift back into old habits.
- Someone will eventually ask why all this effort was necessary.
If you want the structure to stick, you have to use it.
That means reviewing financial statements monthly with intention. When mistakes are caught and corrected, everyone understands that the structure matters.
Protect the Integrity of the Numbers
Numbers that are not used lose integrity.
You rarely get everything right the first month. That is normal. What matters is discipline.
Each month, review:
- Is billing routing correctly into the right revenue categories?
- Are costs landing in the proper buckets?
- Do labor allocations reflect operational reality?
When you review consistently, your numbers gain integrity.
And when numbers have integrity, they get trusted.
That is when you move from managing your business purely on instinct to managing it with instinct supported by reliable data.
That is a very different place to operate from.
Frequently Asked Questions
Can I restructure my chart of accounts mid year?
Yes. The more important question is whether you want to restate earlier months to match the new structure. That may require accountant time and additional cost. However, if you are considering selling your business, having comparable financial statements across years can be extremely valuable. Buyers often request multiple years of financials. Inconsistent structures can weaken your story.
Do I need an accountant or bookkeeper after I restructure?
Restructuring requires discipline and oversight. Even if you plan to manage much of it internally long term, it is wise to have an accountant or experienced bookkeeper help set up the structure and review the first few months. The goal is not just to create new accounts. It is to build a process that maintains integrity.
Does restructuring my chart of accounts increase the value of my business?
If the new structure provides real insight and you consistently maintain it, the answer is yes.
Buyers evaluate risk.
If you can clearly explain your margins, your labor allocation, and your cost structure, and support it with clean and consistent financials, you reduce uncertainty. Less risk creates more confidence. More confidence often leads to stronger valuations.
There is a big difference between saying, “I will have to get back to you,” and saying, “Yes, I review that monthly. Here is how it works.”
What if I want more detail than what is in my chart of accounts?
Your chart of accounts is your official accounting ledger. It must be structured well enough to produce reliable financial statements.
The detailed operational data lives in your PSA and in QuickBooks at the transaction level.
When PSA and QuickBooks are aligned properly, you can report on granular detail while still maintaining a clean accounting framework.
The chart of accounts provides structure.
Your integrated systems provide depth.
Why does my PSA gross profit not match my QuickBooks gross profit?
PSA gross profit is typically based on estimated labor rates.
QuickBooks contains actual payroll data and actual vendor costs.
Because the PSA does not contain your true payroll burden or full accounting structure, the two numbers will rarely match exactly. The difference becomes even more apparent when analyzing profitability by technician.
That mismatch is one of the primary reasons MSPs decide to rethink their chart of accounts structure.
Need Help Implementing This?
Designing a better chart of accounts is one thing. Implementing it correctly across your PSA, QuickBooks, labor allocation, and cost routing is another.
If this approach makes sense to you and you would prefer help putting it in place the right way, contact us and we will walk through your current setup together.
📌 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
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

Why Revenue Is Easy to Measure and Profit Is Hard for MSPs
How much revenue does your MSP generate each year? That is a question almost every
Christine
March 10, 2026

Your PSA Isn’t Showing You Real Gross Profit. Here’s Why. (Free Download and Video Walk-Through)
Don’t trust your QuickBooks profitability, or don’t really understand it? There is a solution. You
Christine
January 26, 2026

Why Most MSPs Never Really Know Their Gross Profit
Most MSPs we talk to use QuickBooks the same way. They open it to make
Christine
December 22, 2025