Finance & FP&A

How to run monthly flux and variance analysis as CPG Founders

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

Every month you're pulling QuickBooks exports into a spreadsheet, manually tagging COGS lines by SKU, and trying to figure out why gross margin dropped 4 points from February to March. Was it the co-packer surcharge? The Amazon FBA fee increase? The promotional pricing you ran on Whole Foods EDI? You don't know until you've spent three hours reconciling. Most CPG brands at your stage are running this in Excel or Google Sheets, with a bookkeeper who closes the books 2-3 weeks late. By the time you know what happened, you're already 6 weeks into the next month making the same mistake.

Build this on Starch → See the apps used

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

Outcome

What you'll set up

A live monthly P&L variance view that compares actuals from QuickBooks and Plaid against your budget by category — COGS, trade spend, co-packer fees, and Amazon/DTC separately

Automatic flagging when any account line moves more than 10% month-over-month, with a plain-English explanation of what drove the change

A narrative summary you can paste directly into your board deck or send to your CFO without reformatting anything

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

Budgeting Transaction Insights Runway Analysis

Data sources & config

Starch syncs your QuickBooks data on a schedule (invoices, bills, payments, vendors, journal entries) and syncs your Plaid bank feed on a schedule (categorized transactions, balances). The Budgeting app wires your quarterly budget targets; Transaction Insights layers on vendor-level spend trends; Runway Analysis pulls the same Plaid and Stripe connections to give you forward burn context alongside the monthly variance view.

Prompts to copy

Build me a monthly flux and variance report that pulls actuals from QuickBooks and my Plaid bank accounts, compares them against my budget by category — break out COGS, co-packer fees, trade spend, Amazon fees, and DTC fulfillment separately — and flags any line that moved more than 10% month-over-month with a reason

Show me a spend trend for the last 6 months broken down by vendor, and highlight any vendor whose charges jumped more than 15% versus the prior month

Generate a one-paragraph narrative summary of this month's variances that I can paste into my investor update — include the top 3 drivers of margin movement and whether we're on track against the annual budget

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

Walkthrough

Step-by-step

1 Connect QuickBooks from Starch's scheduled-sync integration — Starch pulls invoices, bills, vendors, payments, and journal entries automatically. This is the source of truth for your P&L actuals.

2 Connect your Plaid bank accounts so Starch syncs categorized transactions and balances on a schedule. This catches anything that hits your bank but hasn't been booked in QuickBooks yet — co-packer ACH pulls, Amazon disbursement deposits, distributor chargebacks.

3 Open the Budgeting app and enter or import your quarterly budget by category. If you've never formalized a budget, the app suggests allocations based on your historical QuickBooks and Plaid spending patterns so you're not starting from a blank page.

4 Tell Starch how you want your P&L structured for CPG: describe your category breakdown — 'separate COGS into raw materials and co-packer fees; separate revenue into DTC, Amazon, and wholesale; break out trade spend as its own line.' Starch maps your QuickBooks chart of accounts to that structure.

5 Starch builds a variance table comparing actuals to budget for the current month and the prior month, with the dollar and percentage delta for each line. Any line beyond your threshold (you set it — 10% is a common starting point) gets flagged automatically.

6 Use the Transaction Insights app to drill into flagged lines. If co-packer fees spiked, you'll see which vendor, which dates, and whether it's a one-time charge or a new recurring pattern — without opening QuickBooks.

7 Cross-reference your Runway Analysis dashboard to understand how this month's variances affect forward cash position. A 4-point gross margin drop looks different if you have 18 months of runway versus 7.

8 Ask Starch to generate the month-over-month narrative: 'Write a 3-sentence summary of March's P&L variance — what were the top drivers, how did gross margin move, and are we on track against the annual budget?' This is what goes into your board update.

9 Set up a monthly automation: on the 5th of each month (or whenever your books close), Starch runs the variance analysis against the prior month, compiles the flagged items, and Slacks you a digest with the summary and a link to the full dashboard.

10 If you run trade promotions through distributors, describe the promo deduction tracking you need: 'Flag any month where trade spend exceeds 12% of wholesale revenue and show me which distributor it came from.' Starch builds that as a standing alert on top of the same data.

11 Review the variance report before your monthly ops meeting. Because Starch has already done the reconciliation, the meeting becomes about decisions — whether to renegotiate the co-packer contract, whether to pull back on a SKU — not about figuring out what the numbers mean.

12 Share or export the variance summary for your accountant or CFO. The same data that powers your internal dashboard can generate the formatted output they need, without you manually rebuilding it in a spreadsheet.

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 — Snack Brand, ~$2.1M ARR

Sample numbers from a real run

Net Revenue — DTC (Shopify)	68,400
Net Revenue — Amazon FBA	54,200
Net Revenue — Wholesale (UNFI)	41,800
COGS — Raw Materials	47,300
COGS — Co-packer Fees	28,600
Amazon FBA Fees	9,100
Trade Spend (distributor promos)	14,200
Fulfillment — DTC	6,800
Gross Profit	58,400

In March, gross margin came in at 35.6% versus the budgeted 39.1% — a 3.5-point miss that would have taken three hours to diagnose in a spreadsheet. Starch flagged two drivers immediately. First, co-packer fees hit $28,600 versus $22,100 in February — a $6,500 jump traced to a minimum run charge on a short production order your ops team placed in late February to cover a surprise Whole Foods reorder. Second, trade spend reached $14,200 (8.5% of wholesale revenue), up from $9,800 in February, driven by a February invoice from UNFI for the Q1 promotional program that posted to March in QuickBooks. Amazon FBA fees were in line with forecast at $9,100. The narrative Starch generated for the board update read: 'March gross margin of 35.6% was 3.5 points below budget, driven by a one-time co-packer minimum run charge ($6.5K) and a timing difference on UNFI promo invoicing ($4.4K). Excluding these two items, margin was 39.0%, essentially on plan. No structural margin deterioration; the co-packer minimum is being addressed in the next production schedule.' That paragraph took 10 seconds to generate and went straight into the investor update.

Measurement

How you'll know it's working

Gross margin by channel (DTC vs. Amazon FBA vs. wholesale) — month-over-month and vs. budget

COGS as % of net revenue, broken out by raw materials vs. co-packer fees

Trade spend as % of wholesale revenue — flagged when it exceeds 12%

Month-over-month variance by account line, with threshold alerts for moves >10%

Days to close: how many days after month-end the variance report is ready for review

Comparison

What this replaces

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

QuickBooks + Google Sheets (manual export)

Free and familiar, but you're rebuilding the variance table manually every month — typically 2-4 hours of work, 2-3 weeks after close, with no automated flagging or narrative generation.

Mosaic or Planful

Purpose-built FP&A tools with robust variance reporting, but they start at $1,000–$2,000/month and assume a finance team that can manage the implementation — not practical for a 3-person CPG brand.

Fathom or Spotlight Reporting

Good QuickBooks-connected reporting at a reasonable price (~$50-150/month), but they produce fixed report templates — you can't describe a CPG-specific breakdown (co-packer vs. raw materials COGS, channel-level trade spend) and have it built on the fly.

Bookkeeper or fractional CFO doing monthly reporting

You get a human who understands your business, but the report lands 2-3 weeks after close, costs $500-2,000/month for the time, and you still can't query it interactively when a number looks off.

On Starch RECOMMENDED

One platform — quarterly budgeting, transaction insights, runway analysis 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

My books don't close until the 15th of the following month. Can Starch run the variance report before the books are fully closed?

Yes. Starch syncs your Plaid bank transactions on a schedule in near-real time, so you can see actuals hitting your bank even before your bookkeeper posts them in QuickBooks. You can run a 'soft close' variance view against bank data and then rerun it once QuickBooks is reconciled. Just be clear in your prompt which data source you want for each line — 'use QuickBooks for COGS and Plaid for operating expenses' is a valid instruction.

My chart of accounts in QuickBooks doesn't map neatly to how I think about CPG financials. Can Starch regroup accounts without me restructuring QuickBooks?

Yes. Describe the grouping you want: 'Roll up accounts 5010, 5020, and 5030 into a single COGS line; treat 6100 through 6199 as trade spend.' Starch applies that mapping in the app layer without touching your QuickBooks setup. Your bookkeeper's structure stays intact; your management reporting reflects how you actually run the business.

Does Starch store all my historical QuickBooks data so I can look at 12 or 24 months of variance history?

Starch syncs QuickBooks entity-level data (invoices, bills, vendors, payments, journal entries) on a schedule with up to 50,000 records per entity. For most CPG brands at your revenue stage, that covers a meaningful history. Starch is not a long-horizon data warehouse, so if you need 5-year archived analytics with complex historical queries, a dedicated BI tool would serve you better. For monthly flux analysis and 12-month trend views, the sync depth is sufficient.

I use Xero instead of QuickBooks. Does this work?

Yes. Connect Xero from Starch's integration catalog — the agent queries it live when your variance app runs. You won't get the scheduled-sync depth that QuickBooks gets (where data is pre-stored in Starch), but the live query is sufficient for building a monthly variance report. Combine it with Plaid for bank-level transaction data.

Can I track variance against a rolling forecast instead of a static annual budget?

Yes. Describe what you want: 'Compare this month's actuals against a 3-month rolling average of prior actuals, not a fixed budget.' Starch builds the comparison logic you describe. You can also maintain a manually updated forecast target in the Budgeting app and compare actuals against that.

QuickBooks report views — like P&L reports — are disabled. Does that affect this workflow?

Worth naming honestly: QuickBooks P&L report views (the pre-formatted report endpoints) are temporarily disabled pending a connector fix. Starch works around this by pulling entity-level data — bills, invoices, journal entries, payments, vendors — and building the P&L structure itself. For the vast majority of CPG variance analysis, the entity-level data is actually more useful because you can slice it by vendor, SKU, or account in ways a canned QuickBooks report won't let you.

Will this work if my revenue comes from multiple channels — Shopify, Amazon Seller Central, and UNFI wholesale?

Yes, and this is where Starch earns its keep for CPG brands. Connect Shopify from Starch's integration catalog for DTC order and revenue data. Amazon Seller Central is web-accessible — Starch automates it through your browser, no API needed, and there's a pre-built Amazon Seller Dashboard in the App Store. UNFI invoices and payments flow through QuickBooks. Describe the channel breakdown you want and Starch pulls from each source to build a unified revenue view alongside your cost variance analysis.