Most MSP owners can tell when something is off in their numbers, even if they can’t pinpoint what it is. Maybe your P&L shows a profit, but the bank account doesn’t back it up. Maybe an agreement that should be one of your best performers looks unprofitable on paper. Maybe you’ve seen something that makes no sense at all, like a negative COGS. You know something doesn’t look right. You just don’t know where to start looking. The culprit may be hiding in your PSA. PSA setup problems can create financial reports that don’t accurately reflect how your MSP is performing.
Here’s what we’ve learned after years of working inside MSP financials: the problem usually isn’t your accountant, and it usually isn’t QuickBooks. It’s the setup of your PSA and the way it connects to your accounting system.
Your PSA is the operational engine of your business. It’s where agreements live, where time gets logged, where products get quoted and purchased, and where invoices get generated. When the setup is wrong, every number downstream inherits the problem. Your books can be reconciled, closed, and technically “done,” and your reports can still be misleading, because the data flowing into them was mapped incorrectly from the start.
This matters more right now than it has in years. A significant share of MSPs are switching PSA platforms, whether that’s moving to Autotask, reevaluating ConnectWise, or building around HaloPSA. Every migration is a fresh opportunity to get the setup right, and an equally fresh opportunity to bake in problems that will quietly distort your financials for years.
These are the six setup problems we see most often, what they actually do to your numbers, and why they’re worth fixing.
1. Revenue and COGS Mapped to the Wrong Places
This is the most common problem, and the most consequential. When revenue types and product costs in your PSA don’t map correctly to the right accounts in QuickBooks, your gross margin stops meaning anything. Managed services revenue gets lumped in with hardware sales. Product costs land in the wrong line, or in no line at all. We once sat down with a client whose reports showed a negative COGS, which simply isn’t possible in a healthy set of books. It wasn’t fraud, and it wasn’t a system failure. It was a simple mapping mistake in where revenue was being tracked.
The consequence goes well beyond a messy report. If your COGS is wrong, your gross margin is wrong, and gross margin is the number you use to price services, decide what to sell more of, and evaluate whether a service line is worth keeping. An MSP that believes a service is profitable when it’s actually dragging margin down will keep pricing it, staffing it, and selling it the same way. The report looked fine. The decision it drove was expensive.
2. Procurement and Pass-Through Revenue That Isn’t Classified Correctly
Hardware resale, software licensing, and other procurement revenue behave differently than your service revenue, and they need to be classified that way. When pass-through revenue gets mixed in with core services, your top line looks bigger than your actual business, and your blended margin becomes a number you can’t really make decisions with. A strong quarter of hardware sales can make the whole company look healthier than it is, right up until the low-margin reality shows up in cash.
This is also one of the first things a buyer or lender will dig into. Buyers value recurring service revenue very differently than they value pass-through product revenue, and if your books don’t separate the two cleanly, that ambiguity works against you.
3. Disconnected Quoting and Purchasing Tools That Create Duplicate Work
Your quoting tool, your PSA, and your accounting system each want to be the source of truth, and if they’re connected in the wrong order, none of them is. We see this all the time with quoting tools like Kaseya Quote Manager and QuoteWerks. Connected one way, sales orders, payments, and purchase orders flow through cleanly and your COGS lands on the right revenue line. Connected another way, the systems stop syncing reliably, and now nobody can say for certain whether a purchase order was paid, whether the equipment was delivered, or whether the client was ever billed for it.
And here’s what happens next. When purchase orders don’t sync correctly, technicians stop using the system, because why log things in a tool that doesn’t work? Then the cleanup lands back on the owner or a senior manager, who spends hours manually reconciling POs and matching transactions. You bought software to eliminate manual work, and the setup quietly recreated it. Done right on the front end, you have clarity about what’s been paid and what revenue is coming in. Done wrong, you have duplicate data entry and a growing pile of exceptions.
4. Inconsistent Agreement Setup and Delayed Billing
Agreements are where recurring revenue lives, and when they’re set up inconsistently, billing becomes a monthly project instead of a process. Invoices go out late. Some agreements bill things others don’t. Someone has to manually review and correct invoices before they’re sent, which adds days to the cycle.
Delayed billing sounds like an administrative annoyance, but follow it downstream:
- Cash arrives later than it should.
- Accounts receivable grows.
- Revenue timing gets murky.
- Your forecast becomes a guess.
An MSP that sells well but bills slowly ends up financing its own clients.
5. Labor Costs That Never Make It Into the Numbers
Labor is the largest cost in most MSPs, and it’s often the least visible one in the financials. If technician time isn’t being tracked and allocated to the right agreements and service lines, you can’t see utilization, and you can’t see which clients or services are actually profitable. Every client looks roughly the same on paper, even though one of them consumes three times the engineering hours it pays for. Without accurate labor allocation, “client profitability” is a feeling, not a number, and pricing conversations happen without the one piece of data that should drive them.
6. A PSA-to-QuickBooks Connection Nobody Fully Trusts
Finally, there’s the integration itself. Many MSPs rely on a two-way sync between the PSA and QuickBooks and assume it’s working, right up until the two systems show different revenue for the same month. Once that happens, trust erodes fast. The monthly close slows down because someone has to investigate the differences. Reports get double-checked against exports. And the owner ends up back where this article started: looking at numbers that don’t quite add up, without knowing which system to believe.
The sync isn’t something to set and forget. How revenue flows between systems, how procurement is captured, and how billable expenses are handled are all configuration decisions, and they determine whether your accounting system reflects reality or just approximates it.
Why This Matters More Than It Looks
It’s tempting to file all of this under “systems cleanup,” the kind of project that can wait for a quieter quarter. But look at what actually depends on these numbers:
- Your pricing depends on accurate margins.
- Your hiring plan depends on real utilization.
- Your tool spend depends on knowing what you’re already paying for.
- Your valuation, if you expect to sell in the next several years, depends on clean, defensible financials. Buyers pay for numbers they can trust and discount numbers they can’t.
PSA setup problems don’t announce themselves. They quietly feed distorted data into every decision you make, month after month, until something forces the issue: a cash crunch that shouldn’t have happened, a tax surprise, a due diligence process that stalls, or a report so obviously wrong it can’t be ignored.
What to Do About It
If you’re in the middle of a PSA migration, this is the moment. Getting the mappings, agreement structures, and integration right during setup is much easier than untangling them later, and it’s the difference between a system that supports your growth and one that fights it.
If you’re already noticing the symptoms, the answer isn’t to start over or buy another tool. It’s to find out exactly where the setup is breaking down and what it’s costing you. That’s the work we do every day: looking at how an MSP’s PSA, billing process, and accounting system actually work together, identifying the specific issues affecting reporting and profitability, and prioritizing what to fix first so you’re not trying to solve everything at once.
You don’t have to keep making decisions with numbers you only half trust. If you’re ready to find out what’s going on in your systems and what it would take to get numbers you can rely on, schedule a free consultation today.
