Recording MSP Recurring Revenue and Hardware in QuickBooks

An MSP records recurring managed-services fees as income in the month the service is delivered, and records resold hardware as cost of goods sold matched to the invoice that bills the client for it. When a client prepays a year, that cash is deferred revenue (a liability) recognized one month at a time, not income on the day it lands. Get those two ideas right and the rest of a managed-services book falls into place. The trouble is that PSA batches, distributor drafts, and license rebills all hit the same checking account and blur together unless you set up the accounts to keep them apart.

Monthly recurring revenue and the processor fee

Most MSPs bill a fixed monthly fee per seat or per endpoint through a PSA tied to a payment processor. Cards and ACH run in a batch, and the deposit that reaches your bank is net of the processor fee. If you book the deposit as revenue, you have quietly understated both your sales and your expenses by the same amount, and your effective margin looks better than it is.

Split every batch instead. Record the gross amount your clients paid as managed-services income, then record the processor fee as its own merchant-fee expense line. A $4,000 batch that arrives as $3,884 is $4,000 of income and $116 of fees, not a $3,884 sale. Doing this month after month keeps your top line honest and gives you a real number for what card processing actually costs.

Keep recurring, project, and pass-through income separate

One income account for everything hides the story you most want to see. Build at least three so margin is visible by type of work:

• Managed Services Income: the recurring agreement fee, your predictable base.
• Project Income: one-time migrations, installs, and cabling. Higher labor, lumpier, and worth watching on its own.
• Hardware and License Resale: product you buy and rebill, which carries a very different margin than labor.

With income sorted this way, a profit and loss report shows whether your recurring base is growing or whether a good month was really one big project that will not repeat. Blend them and you cannot tell the difference.

Prepaid blocks and deferred revenue

When a client pays for twelve months up front, or buys a block of hours, you have not earned that money yet. Under accrual accounting the cash is unearned, so it sits as deferred revenue, a liability, and moves into income as you deliver the service. Some very small MSPs report on a cash basis and book it all as income on receipt. Which path is right for your books is a decision for your CPA, and it usually turns on your size, your entity type, and whether anyone outside the company reads your statements.

Here is the accrual version as a balanced example. A client prepays $12,000 for a year of coverage:

Each side totals $12,000 over the year, so the entry balances. After six months, $6,000 has moved to income and $6,000 still sits in the liability as coverage you owe. That liability is a real obligation: if the client cancels, part of it may be refundable.

Hardware resale: COGS, not overhead

This is where MSP books most often go sideways. You buy hardware from a distributor such as Ingram Micro, TD SYNNEX, Pax8, or Dell, and you resell it to the client. The distributor pulls an ACH draft from your checking account. If you code that draft to a general operating expense, you have double-counted, because the cost belongs against the resale, not in overhead.

Two clean patterns cover almost everything:

1. Drop-shipped for a specific job: gear that ships straight to one client for one order is cost of goods sold, matched to the invoice that bills them for it. Cost and revenue land in the same period and the margin is obvious.
2. Stocked on the shelf: hardware you buy ahead and hold is inventory, an asset, until you actually sell it. At the point of sale it converts to COGS. Until then it is not an expense at all.

A short balanced example. You buy five laptops for $6,000 and invoice the client $7,500:

The $6,000 distributor draft is COGS (or inventory first, then COGS), never a second operating expense on top. Code it once, against the sale.

Agent versus principal on recurring licenses

Recurring licenses like Microsoft 365, Azure, EDR, and backup raise a different question: do you show the full license fee as your revenue, or only your cut? Under current revenue guidance the test is control. If you control the license before it reaches the client and carry the risk, you are a principal and report gross, the full amount as revenue with the vendor cost as COGS. If you merely arrange the sale and pass it through, you look more like an agent and report net, only the margin.

In practice, a license passed through at cost is close to a wash: you record the vendor charge and a matching rebill, and there is little or no margin either way. A license you mark up produces real gross profit, and that is the piece your books should surface. Talk the gross-versus-net call over with your CPA, because it changes how big your reported revenue looks even when the cash in your pocket is identical.

Draw the line at your own-use subscriptions

Your PSA, your RMM, and the tenant your own staff work in are tools you use to run the company. Those seats are an operating expense, plain overhead. The licenses you buy to resell to clients are COGS against resale income. They can come from the same vendor on the same card, so the split is easy to miss, yet it matters: mixing your own-use spend into resale COGS distorts the margin on product you sell. Many of these platforms also let you monitor client servers and endpoints for uptime, and the seats that power that internal tooling still count as your overhead, not the client's cost.

Reconciling it all from the bank statement

Every one of these transactions eventually shows up on a bank or credit-card statement: PSA deposits, distributor drafts, vendor subscriptions, and merchant fees. Matching them is far quicker when your statement is a file QuickBooks can read rather than a PDF you retype. Convert the statement with a PDF to QBO converter and it becomes a Web Connect file you can import straight into QuickBooks Online. For a workflow built around managed-services books specifically, see our guide to turning a bank statement into QuickBooks for MSPs. Once the transactions are in, you code each one to the right account: income, deferred revenue, COGS, or overhead.

Frequently asked questions

Should an MSP record prepaid annual contracts as income right away?

On accrual accounting, no. The prepayment is deferred revenue, a liability, and you move one twelfth into income each month as you deliver coverage. Small MSPs on a cash basis may book it on receipt. Which basis applies to your company is a call for your CPA, since it depends on size and who reads the statements.

Where does resold hardware go in QuickBooks?

Hardware drop-shipped for a specific client job is cost of goods sold, matched to the resale invoice. Hardware you stock is inventory, an asset, until it sells and then converts to COGS. The distributor's ACH draft is that cost, not a separate operating expense, so code it once against the sale to avoid double-counting.

Do I report the full Microsoft 365 license fee as revenue?

It depends on whether you act as principal or agent. If you control the license and carry the risk, report gross with the vendor cost as COGS. If you only pass it through, report net, your margin. A pass-through at cost is roughly a wash; a marked-up license shows real gross profit. Confirm the treatment with your CPA.

Why split the payment processor fee out of the deposit?

Because the net deposit hides both revenue and expense. Booking the net figure understates your true sales and your true processing cost by the same amount, so your margin looks inflated. Record gross income and the fee as its own expense line, and both numbers stay accurate month after month.

Managed-services books reward a little structure up front: separate income accounts, a deferred revenue liability for prepaid work, and hardware and licenses booked as COGS instead of overhead. Set that up once and every batch, draft, and rebill lands where it belongs. Start by getting clean transactions into QuickBooks with a converted statement, then let the account structure do the sorting.