QuickBooks Grant Budget Tracking and Budget vs Actual Reporting

QuickBooks grant budget tracking usually starts as a budget vs actual report. Nonprofit finance teams compare approved grant budgets with actual spending, explain variances, and send funders a report that still matches the numbers in QuickBooks Online.

The sections below show how to prepare budget vs actual reports in QuickBooks Online, where the process gets harder, and what to change to produce clearer grant reports with fewer spreadsheets.

QuickBooks grant budget tracking workflow

For most nonprofits, the process works as follows:

1. Set up the grant structure in QuickBooks Online, so that each award has a clear Class, Customer, or Project.
2. Compare spending with the approved grant budget every month, not only when a report is due.
3. Reconcile budget categories, restricted fund balances, and shared-cost allocations before you send updates.
4. Turn the monthly budget vs actual view into a funder report with columns for the period, the cumulative total, and the remaining budget.

If you are still setting up QuickBooks Online itself, start with the QuickBooks nonprofit setup guide and the restricted funds guide before you build a report template.

Why budget vs actual reports help

For funders

Funders review budget variances to see:

• Whether you are on track to spend the grant
• Whether any category is far over or under budget
• Whether you need a budget change

For your organization

Budget tracking helps you find problems early, avoid overspending restricted funds, and forecast allowable program needs before the grant ends.

For grant and compliance reviewers

Grant reviews, compliance reviews, and single audit procedures may check:

• Whether spending followed the restrictions
• Whether budget changes were properly approved
• Whether variances and possibly unallowable costs were checked against the award, the cost principles that apply, and required approvals

Limits of QuickBooks Online budgets

QuickBooks Online budgets can help, but they are available only on Plus and Advanced, and the features can change.

What QuickBooks Online budgets can do

• Create a profit and loss budget for a fiscal year, by account
• Subdivide the budget by Class or Location
• Compare actual amounts with the budget
• Enter and view budget amounts by month, quarter, or year

What QuickBooks Online budgets can't do

• Cover one continuous award period that crosses fiscal years, or several years at once. You need a separate schedule to connect fiscal-year budgets across the award period.
• Use your funder's categories. Budgets follow your chart of accounts.
• Follow a grant period that doesn't match your fiscal year, for example April to March, without reconciling across fiscal-year views.

Why grant budgets don't fit

Most grant budgets:

• Don't follow your fiscal year, for example September to August or April to March
• Use the funder's categories, not your accounts
• Cover more than one year
• Need to be tracked apart from your organizational budget

When QuickBooks Online alone isn't enough

QuickBooks Online budget reports usually work for a few simple grants. They get harder to use when your team needs to:

• Track one grant across several reporting periods
• Explain variances by the funder's categories instead of your chart of accounts
• Review restricted fund balances and budget status together
• Combine allocation decisions, indirect costs, and narrative reporting without rebuilding everything in Excel

At that point, budget tracking involves grant managers and program staff as well as finance, and it needs a shared process.

Setting up Class budgets in QuickBooks Online

You can still create useful grant budgets in QuickBooks Online.

Step 1: Create the budget

1. Go to Reports > Financial planning > Budgets.
2. Select Create new or Create budget.
3. Choose a profit and loss budget, and choose the fiscal year.
4. Name the budget, for example "[Grant Name] FY2026."
5. Choose Subdivided budget and select Class.
6. Select Next.

Step 2: Enter budget amounts

1. Filter to your grant's Class.
2. Enter amounts by account and month.
3. Enter the approved monthly plan. If you only have an annual amount, label the budget clearly as annual instead of putting the full total in the first month.
4. Select Save.

Menu names and budget features can change, so confirm the path and the subdivision options in your company.

Step 3: Run the Budgets vs. Actuals report

1. Go to Reports.
2. Search for "Budgets vs. Actuals."
3. Choose the date range that matches the grant period.
4. Filter to your grant's Class.
5. Customize the columns as needed.

Using a spreadsheet instead

For grants that don't fit QuickBooks Online budgets, a spreadsheet is a common alternative.

Grant budget template

Create a spreadsheet like this one.

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%

Filling it from QuickBooks Online

1. Run Profit and Loss by Class for the grant period.
2. Map each account to a budget category.
3. Enter the totals in the spreadsheet.
4. Calculate the variances.

A spreadsheet can match any grant period, use the funder's categories, track totals across years, and hold notes on variances.

Preparing funder reports

Most funders want a specific format.

Standard format

Budget category	Approved	Period expenses	Cumulative	Remaining
(Funder's categories)	(Original budget)	(This period)	(Total to date)	(Budget minus cumulative)

Tips for clear reports

1. Use the funder's categories, not your chart of accounts.
2. Show both the current period and the cumulative total.
3. Add a percentage column so readers can see progress.
4. Explain variances under the award's rules. Use the funder's approval threshold or your own approved review threshold, because there is no universal 10% rule.

Variance explanations

Common variance explanations include:

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

How to manage multiple grants in QuickBooks Online

For each grant, choose one QuickBooks Online dimension, such as a Class, Customer, or Project, based on how your organization already records and reports activity. Keep a separate approved budget for each award, and review every grant each month for the same period and the same set of transactions.

A monthly review of several grants should show:

1. The approved budget and reporting period for each grant
2. Expenses coded or allocated to the grant
3. Shared costs that are waiting for review
4. The remaining budget by the funder's categories
5. Variances, deadlines, and approved budget changes

Don't use one tag for several grants if you need a separate budget vs actual report for each. When a shared expense benefits several awards, keep the original QuickBooks Online transaction, and document the allocation method and each grant's share.

QuickBooks grant expense tracking by program and grant

QuickBooks Online can report by Class, Customer, Project, or Location, but the right structure depends on your plan and your accounting design. If leadership needs budgets by program while funders need reports by grant, don't force both meanings into one dimension. Use two dimensions on purpose, and keep a reviewed mapping from QuickBooks accounts to funder budget categories.

For every expense, your records should show three things: which program benefited, which grant paid its share, and which funder budget category the cost belongs to. Keeping the three separate makes grant expenses easier to reconcile, and it stops changes to program reporting from changing the grant report without anyone noticing.

Using grant management software

For organizations with several grants, grant management software can reduce manual work.

What grant management software can provide

• Budget categories that match funder requirements
• Budgets for any grant period, not only your fiscal year
• Tracking across several years
• Budget vs actual figures from synced transactions
• Funder reports

How GrantLink handles budget reporting

GrantLink syncs with QuickBooks Online and:

• Allocates eligible expense lines that match the grant's Expenses links automatically
• Lets you review which budget line each allocation belongs to
• Tracks spending against each grant's budget from the latest synced data, on the grant's Budget page and on Grants > Budget vs actual
• Uses the grant's own start and end dates, not your fiscal year
• Creates funder reports from Chats > New chat or from Draft report with Assistant on the grant's Reporting > Reports page, and keeps finished reports there

A simpler process for funder reports

If your team uses QuickBooks Online and doesn't want to change accounting systems, a common approach works as follows:

1. Keep QuickBooks Online as your accounting record.
2. Use GrantLink to set up budgets, allocations, and reporting periods for each grant.
3. Turn the synced data into grant reports with GrantLink's QuickBooks grant management software and AI-assisted funder reporting.

Best practices

Track monthly

Don't wait until a report is due. Monthly tracking helps you catch overspending early, see which categories need attention, and plan spending changes.

Document budget changes

When a budget changes, keep a copy of the funder's approval, update your budget tracking right away, and note the date and reason for the change.

Reconcile to QuickBooks Online

Make sure your budget tracking ties to QuickBooks Online. Run Profit and Loss by Class to check the totals, investigate any differences, and document the reconciliation.

Plan spending near the end of the grant

Track the remaining budget by category so you can find underspent categories. Forecast documented, allowable program needs and any approved indirect cost recovery. Don't spend money only to use up an award. Submit a budget change request if you need one.

Common mistakes

Using the wrong period

A team uses its fiscal year to report on a grant that runs July to June. Track by the grant period instead.

Using the wrong categories

A team reports by its chart of accounts instead of the funder's categories. Map your accounts to the funder's budget categories instead.

Leaving out indirect costs

A team leaves indirect costs out of budget tracking. Calculate and track indirect costs every period.

Tracking too late

A team looks at the budget only when a report is due. Review it monthly to find problems early.

How GrantLink supports this today

To use a funder's exact form, open the grant's Reporting > Templates page and select Add template. You can add Excel workbooks (.xlsx or .xlsm) and fillable PDF forms up to 3 MB. When you create a report, the Assistant fills a new copy from the grant's data, and it never changes your uploaded file.

Adding a template doesn't create a report by itself. To create one, select Draft report with Assistant on the grant's Reporting > Reports page, or open Chats > New chat. Finished reports appear on the grant's Reports page. Before you submit, review allocations, category coding, accounting treatment, and the final output against QuickBooks Online and the award.

Sources

• Intuit: Create budgets in QuickBooks Online: the menu path, fiscal-year budgets, subdivisions, intervals, and budget reports.
• Intuit: QuickBooks Online plans: the current plan comparison. Check it before you buy, because plan features change.