How to Run a Monthly Financial Health Check for a Services Firm With QuickBooks

Services firms run on a specific financial rhythm that traditional business dashboards were not built for. Revenue is lumpy because invoices land when clients pay them, not when work is delivered. Cash flow depends on which clients are current, which are 45 days overdue, and which have quietly stopped billing altogether. The month-end P&L, when it eventually arrives, describes what happened but doesn’t answer what the founder actually needs to know: whether to hire, whether to chase collections, and whether a specific client is silently churning.

This walkthrough covers the manual method for building a monthly financial health check from your QuickBooks data. Four moves that matter for a services firm and how to make each one. It also covers the point at which the manual method stops paying off, and the free Claude skill available at the Databox Skills Marketplace, that runs the same four moves on demand.

TL;DR

• Services firms need four moves in every monthly financial review: a three-window P&L comparison (this month, prior month, same month last year), a four-week cash flow projection anchored in DSO and DPO, AR/AP aging with concentration checks, and a silent-invoice check for clients who stopped billing after three consecutive months.
• The manual method uses QuickBooks reports directly. Total time for a single firm is 60-90 minutes if you know what you’re doing. The silent-invoice check is the tedious move that catches revenue collapse three months before it shows up on the P&L.
• Each move earns its place. Revenue lumpiness makes single-window P&L comparisons misleading. Cash flow projections without stated assumptions are guesses in a spreadsheet. AR aging without the silent-invoice check misses pre-churn signal that becomes declining revenue in the next quarter.
• The manual method holds for one firm reviewed monthly. It breaks when an agency runs it for multiple client entities, when the review needs to happen weekly during a cash-tight or high-stakes period, or when client count pushes the silent-invoice cross-reference past what a person can hold in a spreadsheet.
• The Quick Financial Health Check Claude skill, built by Wagman Digital and shipped to the Databox Skills Marketplace, automates the same four moves against your live QuickBooks data pulled through Databox MCP. Output is a self-contained HTML dashboard with explicit data-gap disclosures when a number isn’t available.

The manual method: four moves that make a services-firm monthly review actually useful

The manual monthly financial review for a services firm is a defined workflow. It works. The four moves below are what the review has to include to be worth doing at all. Skipping any one of them produces a report that describes revenue without describing the health of the firm.

Move 1: The three-window P&L comparison

Open QuickBooks Online. Go to Reports → Profit and Loss. Set the date range to the current month. Note revenue, gross profit (if you track COGS), operating expenses by major category, and net income.

Change the range to the prior month. Note the same figures. Then change the range to the same month last year. Note them again. That’s three windows.

What you’re looking for isn’t the absolute values. It’s the shape of the trend across all three windows read together. A firm where revenue is strong month-over-month but weak year-over-year is a firm in a seasonal recovery, not a firm in genuine growth. A firm where revenue is up year-over-year but down month-over-month is a firm heading into a rough quarter. A firm where all three windows show consistent growth is a firm that can budget confidently and hire against it.

Single-window comparisons miss all three patterns. A month-over-month check tells you what’s changing right now. A year-over-year check tells you whether the trend is durable. You need both, on the same page, to make a decision that isn’t just a reaction to the most recent number.

Move 2: The four-week cash flow projection

The four-week projection is where most manual monthly reviews get skipped, because it requires two calculations most owners don’t do routinely.

First, compute DSO (Days Sales Outstanding). Pull your total accounts receivable from the Aged Receivables report. Divide by the last 90 days of revenue. Multiply by 90. That’s your average days-to-collect. A services firm with DSO under 30 is running tight collections. A firm with DSO over 60 has structural collection issues that will strangle cash flow independent of whether new revenue is coming in.

Second, compute DPO (Days Payable Outstanding). Same math but for accounts payable: total AP divided by the last 90 days of operating expenses, multiplied by 90. DPO tells you how long you take to pay your own vendors. It matters because your DPO minus your DSO is roughly your cash conversion gap — the number of days your money is tied up in the business.

With DSO and DPO in hand, the four-week projection is a defined calculation. Start with current cash balance. Add expected collections (aged AR filtered to invoices you expect to collect within 4 weeks, adjusted by your DSO track record). Subtract expected outflows (aged AP filtered to payables due within 4 weeks, plus recurring fixed costs like payroll and rent). What comes out the other end is a 4-week net cash forecast, stated with your DSO/DPO assumptions attached.

Never present a cash projection without those assumptions attached. A projection that shows “$47,000 net positive over 4 weeks” without disclosing that it assumes a 42-day collection cycle is a projection nobody should make decisions from. If your DSO drifts up by two weeks, that same $47,000 projection is closer to $18,000 in actual cash arriving. The assumption is what makes the projection honest.

Move 3: AR and AP aging with concentration checks

Open the Aged Receivables Detail report. Note the totals for each bucket: current, 1-30 days, 31-60 days, 61-90 days, over 90 days. Do the same for Aged Payables Detail.

Two patterns to flag. First, growing balances in the 61-90 or 90+ buckets on the AR side. Receivables that have moved past reasonable collection windows are receivables where a phone call, a formal collections process, or a write-off decision is overdue. The longer they sit, the less likely they are to be collected in full.

Second, concentration. If one or two vendors make up most of your AP balance, a squeeze on any one of those relationships affects your operations. Same for AR: if one client makes up 40% of your outstanding receivables, that client’s collection timing is your firm’s cash flow. Concentration is the risk you don’t see until it’s the reason you can’t make payroll.

Move 4: The silent-invoice check

This is the tedious move. Open your invoice history in QuickBooks. Filter to invoices sent in the last three months. Group by client.

Any client who received an invoice in each of the last three months is on your “consistently invoiced” list. Now filter to invoices sent in the current month. Cross-reference against the consistently-invoiced list. Any client on the consistent list who did not receive an invoice this month is a silent-invoice flag.

Silent-invoice clients are pre-churn. The engagement stopped or slowed. The invoice never went out. The client hasn’t formally said goodbye, and might not for another month or two. In three months, they’ll appear on your churn analysis. Right now, they’re a phone call away from either being re-engaged with a scoped project or having the churn confirmed early enough that you can redeploy the capacity.

This check is where the manual method gets genuinely painful at scale. For a firm with 30 active clients, the cross-reference takes 20-30 minutes and requires attention that a reviewer running through end-of-month tasks under time pressure rarely brings. Miss the check for two consecutive months and you’ll discover the silent-invoice pattern in the same review where you also discover you lost the client.

The judgment layer: what the four moves surface

Not every pattern the review surfaces deserves action. Three tests, applied in order.

Test 1: Does the pattern have a hypothesis? A P&L window showing revenue down 15% year-over-year with an obvious explanation (“we lost the two large retainers in Q1 and haven’t replaced them”) is a report worth writing up. Without a hypothesis, you have data, not a diagnosis. Never bring a P&L flag to an ownership meeting without at least one testable explanation.

Test 2: Does the cash flow projection change a decision? A four-week forecast of $47,000 net positive is context. A four-week forecast that’s negative given current commitments is a decision point: whether to delay a hire, chase specific collections, defer a vendor payment, or draw on a credit line. Cash flow projections that don’t tie to a pending decision are review theater. The projection matters when a specific action rides on it.

Test 3: Do the silent invoices matter for capacity planning? A silent-invoice flag on a $5,000/month project client is different from a silent-invoice flag on a $40,000/month retainer. Contextualize by revenue impact before deciding which flags demand outreach this week. The check surfaces all silent invoices; judgment decides which get called.

A completed monthly financial review, after judgment is applied, lands on three or four specific decisions: which cash actions to take, which AR balances to chase, which silent-invoice clients to call, and whether the hiring or investment plan holds. That’s the review worth walking into an ownership or leadership meeting with. Anything less is a monthly report that describes the past without changing the future.

Two things the manual method does poorly

The manual method works for one services firm reviewed monthly by an owner or bookkeeper who knows the business. It works well. Two patterns break it.

Higher review frequency. A services firm in a cash-tight period, or one about to make a significant commitment like a new hire or a lease, needs the four moves to run weekly, not monthly. Sixty to ninety minutes of manual review per week is four to six hours a month, and the silent-invoice check specifically gets harder as the base period rolls forward. Weekly checks require the reviewer to hold the invoice pattern of the last three months in their head with each run, and the pattern subtly changes each week. The check either gets rushed and misses the flags, or it gets deferred and defeats the purpose of the weekly cadence.

Multiple client entities. An agency doing white-label finance work for services clients, or a firm operating multiple entities (say, a holding company with three subsidiaries), has to run the full four-move review for each one separately. Time scales linearly with entity count. The move most vulnerable to reviewer fatigue is the silent-invoice check, which is where the review actually earns its keep — and it’s the one most likely to get skipped by the fourth or fifth entity on the list.

Both patterns land in the same place. The review either stops running or gets shortened to fit the available time. And the moves that get cut are always the ones that require the most attention: the year-over-year P&L window, the cash flow projection with assumptions attached, and the silent-invoice cross-reference. What survives the compression is a glance at revenue against last month, which is the read the article opened by warning against.

The Claude skill that closes the gap

The Quick Financial Health Check Claude skill, built by Wagman Digital, a 50-person digital marketing agency, and shipped to the Databox Skills Marketplace. It automates the same four moves against your live QuickBooks data, pulled through Databox MCP, and delivers a self-contained HTML dashboard. On demand. In minutes per run.

The output covers what a services firm’s monthly financial review actually needs:

• Data Source Disclosure Box. Every metric pulled from QuickBooks, listed with a success or failure status and a sync freshness stamp. You know exactly what the report is built on before you read a single number.
• Executive summary. Led by whatever you named as your single biggest financial concern during onboarding. If you told the skill you’re worried about cash runway, the summary leads with cash runway. If you’re worried about client concentration, it leads there.
• Target scorecard. Optional. If you set targets during onboarding (revenue floor, profit target, cash minimum), the scorecard runs your actual figures against them.
• P&L comparison. The current month against the matched prior period and against the same period last year. Move 1 of the manual method, computed and rendered as a three-window read.
• Four-week cash flow projection. With DSO and DPO calculated from your live data and stated as assumptions inside the projection. Move 2, done without you having to run the math yourself.
• AR/AP aging. The standard buckets, with concentration callouts when one client or vendor makes up an outsized share.
• Missing-invoice alerts. Clients invoiced consistently for three months who went silent this month. Move 4, automated against your invoicing history.
• Alerts and next steps. A prioritized list of what to do this month, tied to the specific patterns the report surfaced.

What sets the skill apart from a generic monthly financial report is what it refuses to do. If QuickBooks doesn’t return a specific number — because a category isn’t tracked in your setup, because a sync failed, or because the data is missing entirely — the report renders a visible DATA GAPS block. It never fills a missing number with an estimate. A confident-looking wrong number is more dangerous than an honest blank, and the skill treats that principle as non-negotiable.

The output is print-friendly HTML. Because it contains real client names and financial figures, it carries a confidentiality note. Share it deliberately.

Data source is QuickBooks Online, connected through Databox. That’s the entire data surface. The skill doesn’t cross-reference against your CRM, your project management system, or your marketing analytics. Financial review for services firms is what the report does. The tight scope is what keeps it accurate and repeatable.

Run the manual review at least once before you install the skill. The four moves are what teach you which patterns to trust and which to challenge on your specific book of business. The DSO number that feels normal for your firm is different from the industry benchmark. The silent-invoice pattern that matters for you is calibrated to the average size of your client engagements. Concentration risk means one thing at a three-client agency and another thing at a thirty-client one. The skill carries those calibrations forward once you know what “right” looks like for your operation. It can’t tell you that on the first run.