Investor Relations

How to build a quarterly lp report as Foundation and Nonprofit Ops Teams

Investor RelationsFor Foundation and Nonprofit Ops Teams2 apps12 steps~24 min to set up

Every quarter your team assembles an LP report the hard way: someone exports QuickBooks data to a spreadsheet, someone else pulls grant disbursement totals from Salesforce by hand, a third person updates the narrative in a Google Doc, and the whole thing gets stitched into a slide deck the night before the board call. If your foundation uses fiscal sponsorships or pass-through grants, reconciling program spend against budget adds another two hours. The purpose-built tools — Fluxx, Blackbaud Grantmaking — assume you have a dedicated grants-management team and a six-figure software budget. You don't. You have four people and a QuickBooks instance.

Build this on Starch → See the apps used

Investor RelationsFor Foundation and Nonprofit Ops Teams2 apps12 steps~24 min to set up

Outcome

What you'll set up

A quarterly LP report that pulls live financials from QuickBooks and compares program spend against your Google Sheets budget — no manual export required

A board-ready narrative draft that summarizes grant activity, highlights program outcomes, and flags variances — generated from your actual data, not a template you fill in by hand

An email workflow that formats the final report and sends it to your LP or board list on the cadence you set, with one review step before anything goes out

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

Investor Reporting Email Agent

Data sources & config

Starch syncs your QuickBooks data on a schedule — invoices, bills, payments, journal entries, and vendor records refresh automatically so the report always starts from current figures. Google Sheets is connected from Starch's integration catalog; the agent queries it live when the report runs to pull your program budget. Salesforce is connected from Starch's integration catalog so the agent can query grant pipeline and disbursement records live. Donor portals or board packet destinations that don't have an API are handled through browser automation — no API needed.

Prompts to copy

Connect my QuickBooks account and pull all grant disbursements, operating expenses, and program spend for Q1 2026. Compare actual spend by program area against the budget in my Google Sheet at [link]. Flag any line item that is more than 10% over or under budget. Format the output as a quarterly LP report with a one-paragraph executive summary, a spend table broken out by program area, and a narrative section I can edit before it goes out.

Draft a donor update email summarizing the Q1 2026 LP report. The tone should be formal but not stiff — we're writing to individual donors and a community foundation funder, not a VC. Pull the key numbers from the report (total disbursed, number of grants closed, largest program area by spend) and write three short paragraphs: what we deployed, what it funded, and what comes next in Q2. Flag anything I should personalize before sending.

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

Walkthrough

Step-by-step

1 Connect QuickBooks: Starch syncs your QuickBooks data on a schedule, pulling invoices, bills, payments, and journal entries. This takes about three minutes and becomes the financial backbone of every report you generate.

2 Connect Google Sheets from Starch's integration catalog. Point Starch at the sheet where your program budgets live — it queries the sheet live each time the report runs, so budget updates you make mid-quarter are reflected automatically.

3 Connect Salesforce from Starch's integration catalog. The agent queries your grant pipeline and closed-grant records live, pulling disbursement dates, grantee names, and program area tags.

4 Open the Investor Reporting app in Starch. It's designed for financial reporting and comes pre-built with a burn/spend structure you'll adapt. Tell Starch your foundation's program areas and the fiscal quarter you're reporting on.

5 Type your first prompt: describe the report structure you want — spend by program area, variance against budget, grant count, and a narrative summary section. Starch drafts the full report from your live data.

6 Review the variance flags. Starch will surface any line item more than 10% over or under budget. For each one, you add a one-sentence explanation — this is the human judgment step that no tool should skip.

7 Edit the narrative section. The draft gives you a starting structure; you adjust the tone to match your foundation's voice and add any context about programmatic outcomes that doesn't live in the financial data.

8 Use the Presentation Agent (currently in beta — request access) or export the report data to your existing board packet format. If you're working in Google Slides or PowerPoint, the structured data Starch outputs pastes cleanly into your existing template.

9 Switch to the Email Agent app. Paste the final report or the key figures, and prompt Starch to draft the donor update or LP email. Specify the audience — individual major donors, a community foundation program officer, or your full board — so the tone is calibrated correctly.

10 Review the email draft. The Email Agent flags anything that looks like it needs personalization — a donor's specific program interest, a grant that had unusual circumstances — so you're not sending a form letter that reads like one.

11 Set the send cadence. For quarterly reports, you configure the Email Agent to send on the date you choose after a final approval step. Nothing goes out without your sign-off.

12 After the first quarter, the setup is largely done. Each subsequent quarter you review the variance flags, edit the narrative, and approve the email. The extraction, reconciliation, and formatting steps are handled by Starch.

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

Q1 2026 LP Report — $50M Community Foundation

Sample numbers from a real run

Education Program Grants Disbursed	412,000
Economic Mobility Program Grants Disbursed	287,500
Capacity Building Grants Disbursed	94,000
Operating Expenses (staff, benefits, office)	118,200
Total Q1 Disbursements + OpEx	911,700
Q1 Budget (per Google Sheet)	875,000
Variance (over budget)	36,700

The Q1 close took about 45 minutes of actual staff time instead of the usual two days. Starch pulled all QuickBooks disbursements and operating expenses, compared them against the program budgets in the Google Sheet, and flagged a $36,700 overage — mostly in the Education Program line, where two grants that were expected to close in Q2 were executed early at the grantees' request. Starch surfaced that variance automatically; the ops director added a one-sentence explanation in the narrative section. The Salesforce query confirmed 23 grants closed in Q1 across 19 grantees. The draft LP email went to three individual major donors and a community foundation co-funder. The Email Agent drafted separate versions for each audience — the major donors got a more personal note referencing their specific program interests, the co-funder got a more formal program-outcome summary. Total review and edit time: about 30 minutes. The report was out two days before the board call instead of the night before.

Measurement

How you'll know it's working

Grants disbursed vs. planned disbursements for the quarter (count and dollar amount)

Program spend as a percentage of total expenditures (program efficiency ratio)

Budget variance by program area (actual vs. planned, flagged at >10%)

Time from quarter close to LP report sent (target: under 5 business days)

Board packet completion date relative to board meeting (target: 48+ hours prior)

Comparison

What this replaces

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

Fluxx or Foundant Grantmaking

Purpose-built for grants management but costs $60K–$150K/year, assumes a dedicated grants team, and still doesn't automate the LP report or board narrative — you're managing the grants database in one tool and writing the report separately anyway.

Blackbaud Financial Edge + Raiser's Edge

Deep nonprofit accounting and donor management, but implementation takes months, licensing is expensive for a four-person shop, and it produces data you still have to manually format into an LP report.

Manual QuickBooks export + Google Sheets + Google Docs

Free and familiar, but the reconciliation and formatting work falls entirely on your team every quarter — typically 6–10 hours of staff time that could be spent on program work.

Airtable + a consultant-built reporting template

Flexible and cheaper than Fluxx, but every quarter you're still exporting data manually, and the template breaks whenever your program structure changes — plus you're dependent on whoever built it to fix it.

On Starch RECOMMENDED

One platform — investor reporting, email agent 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

We use Salesforce for grants management, but it was set up by a consultant and the schema is messy. Can Starch still query it reliably?

Starch connects to Salesforce from its integration catalog and queries it live. The agent works with whatever fields and objects exist in your instance — it doesn't require a clean or standard schema. If your grants are tracked in a custom object instead of the standard Opportunity, you describe that to Starch when you set up the query and it adapts. What Starch can't do is fix the underlying data quality in Salesforce — if disbursement dates are missing from half your records, the report will reflect that gap. That's worth knowing upfront.

Our QuickBooks has 20+ expense categories and a fairly complex chart of accounts. Will the report still make sense?

Yes. Starch syncs your QuickBooks data on a schedule — including all your entities and journal entries — and when you set up the report, you tell Starch which account groups map to which program areas. It's a one-time configuration step. After that, every quarterly report uses the same mapping unless you change it. One current limit: QuickBooks' built-in report views (like the P&L summary view) are temporarily unavailable in Starch due to an upstream fix in progress. Entity-level data — bills, invoices, payments, journal entries — syncs normally and is sufficient for building a program spend breakdown.

We're not reporting to venture capital LPs — our 'LPs' are major donors and a co-funding community foundation. Is the Investor Reporting app going to feel like the wrong tool?

The Investor Reporting app is the closest pre-built starting point for structured financial reporting, but you're not locked into its framing. When you set it up, you describe your audience — major donors and a co-funder, not investors — and Starch adjusts the narrative tone and structure accordingly. The financial pull and variance analysis work the same way regardless of what you call the recipients. You can also build a custom reporting app from scratch by describing exactly what you want: 'Build me a quarterly donor report that pulls QuickBooks program spend, compares it against our Google Sheet budget, and formats the output as a two-page narrative summary suitable for major individual donors.'

Does Starch store our financial data? We have grant agreements that require data security commitments.

Starch stores data synced from scheduled-sync providers like QuickBooks in its database, and live-queried data from tools like Salesforce and Google Sheets is not persistently stored. Starch is not currently SOC 2 Type II certified — that's worth knowing if your grant agreements or co-funder relationships require it. There's no on-premises or self-hosted option today. If SOC 2 Type II certification is a hard requirement for your foundation, that's an honest constraint to weigh.

Can Starch help with the 990 compliance questions we get from donors every year?

Not directly — Starch doesn't prepare 990s or interface with the IRS e-filing system. What it can do is help you build a Q&A surface that pulls relevant data from your QuickBooks and Salesforce records to answer common compliance questions faster. For example: 'Build me a view that shows total grants disbursed by program area and grantee for the calendar year, formatted for 990 Schedule I review.' The filing itself stays with your accountant or a dedicated 990 preparation tool.