Finance & FP&A

How to run monthly flux and variance analysis as Professional Services Founders

Finance & FP&AFor Professional Services Founders3 apps12 steps~24 min to set up

Every month-end, you're pulling QuickBooks exports into a spreadsheet, hunting down the Stripe revenue numbers, cross-referencing Plaid transactions to figure out what actually hit the bank versus what's invoiced, and manually comparing it all against last month. For a 12-person consultancy, the categories that matter — billable staff costs, subcontractor fees, software subscriptions, travel, and client entertainment — don't map cleanly to your chart of accounts. Variance analysis becomes a two-hour exercise in vlookups and tab-switching, usually done by you at 10pm on the 5th of the month, because no one else knows where the numbers live.

Build this on Starch → See the apps used

Finance & FP&AFor Professional Services Founders3 apps12 steps~24 min to set up

Outcome

What you'll set up

A live month-over-month flux dashboard that compares actual spend by category against prior month and budget, updated daily from your bank and accounting data — no export required.

Automated variance flags that surface the accounts where actuals deviated more than 10% from prior month or budget, with the transaction detail behind each flag already pulled in.

A natural-language monthly close summary you can send to your accountant or investors, generated from your Plaid, Stripe, and QuickBooks data in one prompt.

The Starch recipe

Apps, data, and prompts

The combination of Starch apps, the data sources they pull from, and the prompts you use to drive them.

Apps used

Runway Analysis Transaction Insights Budgeting

Data sources & config

Starch syncs your Plaid bank feed data on a schedule (transactions, balances, categorization), syncs your QuickBooks entities — invoices, bills, vendor payments, journal entries — on a schedule, and syncs your Stripe charges and payouts on a schedule. Your quarterly budget targets live in the Budgeting app. HubSpot deal data is queried live from Starch's integration catalog when you want pipeline context alongside actuals. Slack is queried live from Starch's integration catalog to deliver variance alerts to your ops channel.

Prompts to copy

Build me a monthly flux analysis dashboard that compares this month's actual spending by category against last month and against my quarterly budget. Flag any category where the variance is more than 10% or $2,000, whichever is smaller. Pull expenses from Plaid and QuickBooks, and revenue from Stripe.

Every month on the 3rd, generate a variance commentary that lists the top 5 accounts with the biggest month-over-month change, explains what drove each one based on the underlying transactions, and formats it as a plain-English paragraph I can paste into an investor update.

Show me a table of all subcontractor and staffing costs for the month, broken out by vendor, compared to the prior month and to the budget line I set in quarterly budgeting. Alert me on Slack if any single vendor line is more than 20% over the prior month.

Run these in Starch → or paste them into your favorite agent

Walkthrough

Step-by-step

1 Connect Plaid in Starch — Starch syncs your bank account transactions on a schedule, so every expense that clears your operating account is available without manual export.

2 Connect QuickBooks in Starch — Starch syncs your QuickBooks bills, vendor payments, invoices, and journal entries on a schedule. Note: QuickBooks report views (P&L, Transaction List) are temporarily unavailable; entity-level data syncs normally, which is enough to build variance analysis from.

3 Connect Stripe in Starch — Starch syncs your Stripe charges, invoices, and payouts on a schedule so revenue recognition is automated alongside expense data.

4 Open the Runway Analysis app from the App Store and customize it to add your professional services cost categories: billable staff, subcontractors, software, travel, and business development. This gives you the starting expense structure instead of building from scratch.

5 Open the Budgeting app and enter your monthly targets for each category — or tell Starch to generate suggested allocations from your last three months of Plaid and QuickBooks actuals.

6 Describe your flux dashboard to Starch in plain language: what categories to track, what variance threshold triggers a flag, and which prior period to compare against (prior month, same month last year, or budget). Starch builds the table.

7 Add a revenue row pulling from Stripe so gross profit and utilization margin appear alongside cost variances — type 'add a revenue section from Stripe invoices and show gross margin by month for the last six months.'

8 Set up the monthly variance commentary automation — tell Starch: 'On the 3rd of each month, write a plain-English summary of the top variance drivers and post it to my #finance Slack channel.' Starch schedules and runs it automatically.

9 Connect HubSpot from Starch's integration catalog so the dashboard can show open pipeline value alongside actuals — helpful context for whether a revenue miss is a timing issue or a pipeline problem.

10 Review the first automated commentary output and edit the prompt if the framing doesn't match how you talk about the business — Starch refines based on your feedback.

11 Share a read-only view of the flux dashboard with your accountant or CFO so they can see the same numbers you're looking at when you have the monthly close call.

12 Each month-end, instead of building the spreadsheet, open the dashboard, read the flagged variances, and paste the generated commentary into your investor update or board deck.

See this running on Starch

Connect your tools, describe what you want, and the agent builds it. Closed beta is free.

Try it on Starch →

Worked example

March 2026 Monthly Close — 12-Person Strategy Consultancy

Sample numbers from a real run

Subcontractor fees	41,200
Subcontractor fees (Feb)	28,500
Subcontractor variance	12,700
Stripe revenue recognized	187,500
Stripe revenue (Feb)	162,000
Software & tools	8,900
Software & tools (Feb)	7,100
Travel & client entertainment	6,400
Travel & client entertainment (Feb)	2,200
Gross margin (March)	130,400

When the March flux analysis ran on April 3rd, Starch flagged three accounts. Subcontractor fees came in at $41,200 versus $28,500 in February — a $12,700 variance, 44.6% over prior month. Drilling into the transactions, it was two new project engagements that onboarded in mid-March and a Statement of Work extension that wasn't yet in the QuickBooks budget. Starch surfaced the vendor names and invoice dates automatically, so there was no digging through bills. Travel and client entertainment jumped from $2,200 to $6,400 — Starch traced it to four separate charges from a client kickoff trip that weren't present in February at all, which explained the full variance. Software and tools ticked up $1,800, which Starch flagged as a new Figma team seat added mid-month. Revenue came in at $187,500 versus $162,000 in February, a $25,500 increase that tracked against two retainer expansions visible in HubSpot. Gross margin held at 69.5%. The variance commentary Starch posted to Slack read: 'March actuals were ahead of February across all lines. The subcontractor overage reflects two new engagements — not a cost control issue. Travel spike is one-time kickoff travel. Recommend updating April subcontractor budget line to $38K to reflect current run rate.' That paragraph took zero minutes to write.

Measurement

How you'll know it's working

Gross margin by month (revenue minus billable staff and subcontractor costs as a percentage of revenue)

Subcontractor cost as a percentage of revenue — for a 12-person firm, this is the lever that moves margin most

Month-over-month variance by cost category, flagged against a 10% or $2,000 threshold

Days to close the month — how many days after month-end before the flux analysis is done and distributed

Budget attainment by category — actual versus the quarterly budget target set in the Budgeting app

Comparison

What this replaces

The other ways teams handle this today, and how the Starch version compares.

QuickBooks P&L report + Excel

QuickBooks report views give you the output but not the variance logic or automation; you still build the prior-month comparison, the percentage changes, and the commentary manually in Excel every month.

Fathom or Spotlight Reporting

Good variance reporting on top of QuickBooks, but you're paying for another point tool, it doesn't pull Stripe or Plaid into the same view, and you can't describe a custom automation and have it built against your data.

Mosaic or Pigment

Purpose-built FP&A tools with strong variance analysis, but they're priced and scoped for teams with a dedicated finance hire — implementation takes weeks and the per-seat cost doesn't make sense at 12 people.

Google Sheets with a manual import routine

Zero cost and fully flexible, but the variance logic breaks the moment someone changes a category name, and there's no automation — someone still runs it every month.

On Starch RECOMMENDED

One platform — runway analysis, transaction insights, quarterly budgeting all running on connected data. Setup in plain English; numbers stay current via scheduled syncs and live agent queries.

Try it on Starch →

FAQ

Frequently asked questions

QuickBooks is my source of truth for expenses. Can Starch actually see all my cost categories?

Starch syncs your QuickBooks bills, vendor payments, invoices, journal entries, and chart of accounts entities on a schedule — so your cost categories come through as they're coded in QBO. One honest caveat: QuickBooks report views (the pre-built P&L and Transaction List reports) are temporarily unavailable due to an upstream connector fix in progress. Entity-level data — which is what powers variance analysis — syncs normally. If you need the formatted QBO P&L report specifically, you'd need to pull that separately for now.

I use Harvest for time tracking and billing. Can Starch pull utilization data alongside the financials?

Harvest is reachable from Starch's integration catalog, which connects to 3,000+ apps — the agent queries it live when your dashboard needs the data. You can ask Starch to build a utilization row alongside your cost variances: 'pull this month's billable hours from Harvest by person and show utilization rate next to the subcontractor cost line.' If you run into any issues with the live query, Harvest is also web-based, so Starch can automate it through your browser with no API needed.

Will this work if my Stripe invoices don't always match the month the work was done?

This is a real professional services problem — revenue recognition on a cash basis doesn't always match delivery. You can tell Starch how you want to handle it: 'treat Stripe invoice date as recognition date' or 'only count payments that cleared the bank this month per Plaid.' The flux analysis will follow whatever rule you describe. If you need accrual-basis revenue, the QuickBooks sync includes your invoiced-but-not-collected entries, and you can combine both in the same dashboard.

Is Starch SOC 2 certified? My clients ask about data security.

Not yet — Starch is not SOC 2 Type II certified as of now. If a client or enterprise contract requires a SOC 2 report, that's an honest constraint to know. For most sub-50-person professional services firms doing internal FP&A work, this hasn't been a blocker, but it's worth flagging if your client agreements have specific compliance requirements.

I want to send the monthly variance summary to my investors automatically. How does that work?

Describe the automation to Starch: 'On the 4th of every month, generate a variance summary from last month's Plaid, Stripe, and QuickBooks data and send it to my investor update email list via Gmail.' Starch schedules the automation, runs the analysis against your live synced data, writes the commentary, and sends the email. You can review a draft version the first time before letting it run hands-off. Starch syncs Gmail on a schedule and can send from your connected account.

What if I want to track project-level margins, not just company-wide categories?

Tell Starch what you want: 'Build a project margin view that shows revenue billed per client from Stripe, subcontractor costs per project from QuickBooks vendor bills tagged with project codes, and staff cost allocated by hours from Harvest — then show margin by project for the current and prior month.' Starch builds that view against your connected data. If your QuickBooks bills aren't tagged with project codes today, the most practical starting point is the company-wide flux analysis; you can layer project tracking in once the underlying data is structured for it.