Grant Budget vs Actual Reporting in QuickBooks Online

Budget vs actual reporting is essential for grant management. Funders want to see how you're spending their money compared to your approved budget.

This guide shows you how to set up and run budget vs actual reports for grants in QuickBooks Online.

Why Budget vs Actual Matters

For Funders

Funders review budget variance to assess:

• Are you on track to spend the grant?
• Are any categories significantly over or under?
• Do you need a budget modification?

For Your Organization

Budget tracking helps you:

• Catch problems early
• Avoid overspending restricted funds
• Plan spending to use funds before grant end

For Auditors

Auditors examine:

• Whether spending aligns with restrictions
• If budget modifications were properly approved
• That no categories exceeded allowable amounts

QuickBooks Budget Limitations

QuickBooks Online has significant budget limitations for grants:

What QBO Budgets Can Do

• Create annual budgets by account
• Subdivide by Class (if using class tracking)
• Compare actual expenses to budget
• Show variance by month or year

What QBO Budgets Can't Do

• Multi-year grants — Only annual budgets
• Custom categories — Must use Chart of Accounts
• Period flexibility — Can't match grant periods (e.g., April-March)
• Multiple budgets per class — Only one budget per fiscal year

The Fundamental Problem

Most grants have budgets that:

• Don't align with fiscal year (Sept-Aug, April-Mar)
• Use funder's categories, not your accounts
• Span multiple years
• Need separate tracking from your organizational budget

Setting Up Class Budgets in QBO

Despite limitations, you can create useful grant budgets in QBO:

Step 1: Create the Budget

1. Go to Settings → Budgeting
2. Click Add Budget
3. Name it: "[Grant Name] FY2026"
4. Choose Fiscal Year
5. Under "Subdivide by," select Class
6. Click Next

Step 2: Enter Budget Amounts

1. Filter to your grant's Class
2. Enter amounts by account and month
3. For simple tracking, enter total in first month
4. Click Save

Step 3: Run Budget vs Actual Report

1. Go to Reports
2. Search "Budget vs Actual"
3. Choose date range matching grant period
4. Filter by Class = your grant
5. Customize columns as needed

Alternative: Spreadsheet-Based Tracking

For grants that don't fit QBO's budget model:

Grant Budget Template

Create a spreadsheet with:

Category	Approved Budget	Spent to Date	Remaining	% Used
Personnel	$50,000	$35,000	$15,000	70%
Fringe Benefits	$12,500	$8,750	$3,750	70%
Travel	$5,000	$2,100	$2,900	42%
Supplies	$8,000	$6,200	$1,800	78%
Contractual	$15,000	$10,000	$5,000	67%
Other	$2,500	$800	$1,700	32%
Direct Total	$93,000	$62,850	$30,150	68%
Indirect (10%)	$9,300	$6,285	$3,015	68%
Grand Total	$102,300	$69,135	$33,165	68%

Populating from QBO

1. Run P&L by Class for grant period
2. Map accounts to budget categories
3. Enter totals in spreadsheet
4. Calculate variances

Advantages of Spreadsheets

• Match any grant period
• Use funder's categories
• Track multi-year totals
• Include notes for variances

Creating Funder-Ready Reports

Most funders want specific formats:

Standard Format

Budget Category	Approved	Period Expenses	Cumulative	Remaining
(Funder's categories)	(Original budget)	(This period)	(Total to date)	(Budget - Cumulative)

Tips for Clean Reports

1. Match funder categories — Not your chart of accounts
2. Include period and cumulative — Show both current and total
3. Add percentage column — Quick visual of progress
4. Note significant variances — Explain anything over 10%

Variance Explanations

Common variance explanations:

• "Timing difference — expenses expected next quarter"
• "Cost savings from vendor negotiation"
• "Position filled later than planned"
• "Reallocation approved on [date]"

Using Dedicated Tools

For organizations with multiple grants, specialized tools improve efficiency:

What Grant Management Software Provides

• Budget categories that match funder requirements
• Any grant period (not just fiscal year)
• Multi-year grant tracking
• Automatic budget vs actual from synced transactions
• Professional funder reports

How GrantLink Handles Budget Reporting

GrantLink syncs with QuickBooks and:

• Maps transactions to grant budget categories
• Tracks spending against budgets in real-time
• Generates funder-ready reports
• Handles any grant period

Best Practices

1. Track Monthly

Don't wait for reports to be due. Track monthly to:

• Catch overspending early
• Identify categories that need attention
• Plan spending adjustments

2. Document Modifications

When budgets change:

• Keep copy of funder approval
• Update budget tracking immediately
• Note change date and reason

3. Reconcile to QBO

Ensure your budget tracking ties to QBO:

• Run P&L by Class for verification
• Investigate any differences
• Document reconciliation

4. Plan End-of-Grant Spending

Track remaining budget by category:

• Identify underspent categories
• Plan allowable expenses
• Submit modification requests if needed

Common Mistakes

Mistake 1: Wrong Period

Using fiscal year for a July-June grant.

Fix: Track by grant period, not your fiscal year.

Mistake 2: Wrong Categories

Using your chart of accounts instead of funder categories.

Fix: Map accounts to funder's budget categories.

Mistake 3: Ignoring Indirect

Not including indirect costs in budget tracking.

Fix: Calculate and track indirect costs each period.

Mistake 4: Late Tracking

Only looking at budget when report is due.

Fix: Monitor monthly; catch problems early.

---

GrantLink automatically tracks budget vs actual for all your grants, syncing with QuickBooks and generating funder-ready reports. See how it works.