Monthly grant budget vs. actual (Make)

Pull actuals by class from QuickBooks into each grant's budget sheet.

MakeNonprofit grants & donorsAdvancedHuman check: High

Tools
Make: QuickBooks Online, Google Sheets

Time saved
~3-5 hrs/month (estimate)

Difficulty
Advanced

Steps

Schedule: the 5th of each month.
QuickBooks Online 'Make an API Call' to /reports/ProfitAndLoss?summarize_column_by=Classes for the grant period.
Iterator over the report rows, then Google Sheets 'Update a Row' in that grant's BvA tab.
Gmail: alert the program manager about any line over 90% spent.

Keep a human check here: High risk

Before you report spending to a funder, confirm which costs are allowable and how they're coded.

Node and module names match Make's docs as of Oct 2026. Apps rename triggers and actions sometimes, so check yours in the editor. Try it with test data or a sandbox company first.

Build it

[AFFILIATE LINK PLACEHOLDER: not live]
Try Make. We may earn a commission if you sign up, at no cost to you. Disclosure

Related recipes

Record online donations in QuickBooks (Zapier)

Create a QuickBooks sales receipt for each Stripe donation.

ZapierNonprofit grants & donorsIntermediateHuman check: Medium

Saves ~2-4 hrs/month

Draft donor acknowledgment letters (Make)

Generate a thank-you letter from a template for each new gift and save it as a Gmail draft.

MakeNonprofit grants & donorsIntermediateHuman check: Medium

Saves ~3-6 hrs/month

Get grant report deadline reminders (n8n)

Send reminders 30, 14, and 3 days before each grant report or drawdown date.

n8nNonprofit grants & donorsBeginnerHuman check: Low

Saves ~1-2 hrs/month