Finance & FP&A

How to analyze vendor and category spend as Chief of Staff and Founder's Office

Finance & FP&AFor Chief of Staff and Founder's Office2 apps11 steps~22 min to set up

You're the one who gets asked 'what are we spending on SaaS this quarter?' twenty minutes before the CFO call. You pull up QuickBooks, realize the categories are a mess, export to a Google Sheet, spend 45 minutes sorting by vendor, and still can't tell whether that $14,000 in 'Miscellaneous' is a problem or noise. Your bookkeeper closes the books once a month. You need answers now. The spend data lives in three places — QuickBooks for accruals, Plaid-connected bank accounts for what actually cleared, and a pile of expense reports nobody has reconciled. No one owns the vendor audit. That means you do.

Build this on Starch → See the apps used

Finance & FP&AFor Chief of Staff and Founder's Office2 apps11 steps~22 min to set up

Outcome

What you'll set up

A live spend dashboard that shows exactly what the company paid each vendor last month, this month, and the trailing six months — pulled directly from your connected bank accounts and refreshed daily, no manual exports required.

Automatic anomaly alerts: any vendor charge that's materially different from its normal range gets flagged before it becomes a line item someone asks you about on a board call.

A categorized vendor breakdown you can slice by department, by recurring vs. one-time, and by new vendors that appeared in the last 60 days — ready to paste into a board deck or exec brief without reformatting.

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

Transaction Insights Runway Analysis

Data sources & config

Connect your business bank accounts through Plaid — Starch syncs your Plaid transaction data on a schedule so the dashboard updates daily without any manual action. If you also want to cross-reference accrual-basis numbers, connect QuickBooks; Starch syncs your QuickBooks invoices, bills, vendor records, and payment entities on a schedule as well. The Transaction Insights starter app gives you the live spend view; the Runway Analysis app layers in burn rate and forward projections. Both are customizable from there — describe any additional cuts or views you need and Starch builds them on top of the same connected data.

Prompts to copy

Build me a vendor spend dashboard that shows every vendor we've paid in the last six months, grouped by category (software, payroll, contractors, office, other), with month-over-month change for each vendor and a flag on anything where this month's charge is more than 20% higher than the prior three-month average.

Add a section that lists every new vendor that first appeared on our bank statements in the last 60 days, with the total paid to date and which account it came from.

Show me a category rollup for Q1 and Q2 so I can compare total software spend, contractor spend, and payroll spend side by side — I need this formatted so I can drop it into a board slide.

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

Walkthrough

Step-by-step

1 Connect your primary operating bank account (and any secondary accounts) through Plaid. Starch syncs transactions on a schedule — you don't re-upload anything; the data just stays current.

2 If your books are in QuickBooks, connect it as well. Starch syncs bills, invoices, vendors, and payments so you can reconcile bank-cleared charges against accrual entries without leaving Starch.

3 Open the Transaction Insights starter app from the Starch App Store. Out of the box it shows category trends, recurring subscriptions, and anomaly flags across your connected accounts.

4 Customize the category structure to match how your company actually talks about spend — tell Starch: 'Recategorize all charges from AWS, Vercel, and Render as Infrastructure; anything from Rippling or Gusto as Payroll Tools.' The agent rewrites the rules and rebuilds the view.

5 Add the new-vendor tracker: tell Starch 'Show me every vendor that appeared for the first time in the last 60 days and hasn't been seen in any prior month.' This catches shadow IT, forgotten trials that converted to paid, and one-off contractors before they become recurring line items.

6 Set the anomaly threshold for your actual business: 'Flag any vendor charge that's more than 25% above its trailing three-month average, and send me a Slack message when one triggers.' Starch connects to Slack directly to deliver the alert.

7 Layer in the Runway Analysis app to see net burn in the same place. Now you can answer 'what are we spending and how does that affect our runway?' without toggling between tools.

8 Build the board-ready export: tell Starch 'Create a category rollup table showing Q1 vs. Q2 total spend across Software, Contractors, Payroll, Office, and Other — format it as a clean summary table.' Copy it directly into your board deck.

9 Schedule a weekly summary: 'Every Monday at 8am, send me a Slack message with last week's total spend by category, any new vendors, and any anomalies flagged.' Now you have situational awareness without opening a dashboard.

10 When the CFO or CEO asks a one-off question — 'what did we spend on legal in Q2?' — just ask Starch directly. The connected data is already there; you're asking a question, not pulling a report.

11 If you need to cross-reference against a vendor contract or purchase order that lives in Notion or Google Drive, tell Starch to pull the relevant Notion page alongside the spend data so you can verify whether actual charges match what was contracted.

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

Q2 2026 Vendor Audit — 10 days before board meeting

Sample numbers from a real run

SaaS / Software	47,200
Contractors (non-payroll)	93,500
Payroll Tools (Rippling, Gusto)	18,700
Infrastructure (AWS, Vercel)	22,100
Office & Facilities	11,400
Miscellaneous / Uncategorized	6,300

Ten days out from the Q3 board meeting, the CEO asks you to pull together a clean picture of Q2 operating spend by category. In the old world this is a two-day project: export from QuickBooks, untangle the miscellaneous bucket, chase down the finance lead for the contractor invoices, and format everything into a slide that doesn't look like a spreadsheet. With Starch, you ask: 'Show me Q2 total spend by category from our Plaid accounts, and flag any vendor where spend increased more than 30% versus Q1.' Within seconds you can see that contractor spend jumped from $71,000 in Q1 to $93,500 in Q2 — and drilling in, two new design agencies appeared in May that account for the entire delta. Software spend held flat at $47,200. Infrastructure climbed $6,800 quarter-over-quarter, and Starch flags a single AWS charge in June for $4,100 that was $800 the prior three months — turns out an engineer spun up a new environment and forgot to shut it down. You bring both findings to the board deck with actual vendor names and amounts, not a vague 'contractor costs were up.' Total time from question to board-ready table: under 20 minutes.

Measurement

How you'll know it's working

Total operating spend by category, month-over-month and quarter-over-quarter

Number of active vendors (any vendor paid in the last 30 days) and new vendors added in the last 60 days

Recurring vs. one-time spend ratio — what percentage of monthly spend is locked into subscriptions or retainers

Anomalous charges as a percentage of total spend — tracking whether the flag rate is going up or down

Days since last manual reconciliation — the goal is zero, because Starch keeps it current

Comparison

What this replaces

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

QuickBooks reports alone

QuickBooks gives you accrual-basis reporting but requires your bookkeeper to close the books first — you're always looking at last month, and the report views can't be customized without an accountant or a BI tool bolted on.

Google Sheets + manual bank export

You control the format, but it's a point-in-time snapshot the moment you export it — next week someone will ask a follow-up question and you'll pull the numbers again from scratch.

Ramp or Brex spend dashboards

Excellent for corporate card spend, but only sees what goes through that card — misses ACH payments, wire transfers, and anything paid from accounts outside their ecosystem.

Looker or Metabase connected to QuickBooks

More powerful for long-horizon analytics, but requires a data engineer to set up and maintain the pipeline, and you're back to asking someone else every time you want a new cut of the data.

On Starch RECOMMENDED

One platform — 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

Does Starch see all our bank accounts, or just one?

You connect as many accounts as you want through Plaid — operating account, payroll account, secondary business accounts. Starch syncs transactions from all of them and lets you view spend across all accounts combined or filtered by account. Most chiefs of staff connect two to four accounts and view them as a single consolidated feed.

Our QuickBooks categories are a disaster. Will that make the spend dashboard useless?

No. Starch pulls the raw transaction data from Plaid (what actually cleared your bank) and lets you define your own categorization rules in plain language — 'anything from Stripe is revenue-related, anything from Rippling is payroll tools, any charge with AWS in the name goes to Infrastructure.' Your QuickBooks chart of accounts is separate; Starch doesn't depend on it being clean. That said, if you want to reconcile bank transactions against QuickBooks entries, Starch can do that too once both are connected.

Is this real-time or does it have a lag?

Plaid transactions sync on a schedule — typically refreshed daily. You're not waiting for your bookkeeper or a month-end close, but you're also not seeing intraday real-time data. For the vendor audit and board-prep use cases most chiefs of staff describe, daily refresh is more than sufficient.

What about the QuickBooks P&L report — can I pull that directly?

Honest answer: QuickBooks report views (P&L, Transaction List, Vendor Expenses) are temporarily unavailable in Starch pending an upstream fix. Entity-level data — bills, invoices, vendors, payments, journal entries — syncs normally today. For a full P&L view right now, Plaid transaction data plus the Runway Analysis app gets you 90% of the way there; formal QuickBooks report sync is coming back soon.

Can I use this to prepare the vendor section of an investor update?

Yes — that's one of the most common use cases. Once your data is connected, tell Starch: 'Write a two-paragraph summary of Q2 operating spend for our investor update, highlighting the categories that grew most and any anomalies we investigated.' It drafts from the live data. You edit, approve, and paste. The investor update isn't a separate project anymore; it's a five-minute ask against data that's already current.

We use Xero instead of QuickBooks. Does that work?

Yes. Connect Xero from Starch's integration catalog; the agent queries it live when your app or dashboard needs accounting data. It's not a scheduled sync the way QuickBooks is, but the data is reachable for custom apps and dashboards you build on top.

Is Starch SOC 2 certified? We have a security review process.

Not yet — Starch is not SOC 2 Type II certified today. That's worth knowing upfront if your company has a formal security review gate for any tool that connects to financial accounts. It's on the roadmap; if this is a blocker, the team can speak to current controls directly.