Budget vs Actual Report
Use the budget you keep in Google Sheets and the expenses already in your Wave account. See where you went over last month and drill into the transactions behind the biggest gaps.
Built for
- Solo founders reviewing last month’s spending against their budget
- Finance and operations leads preparing a variance review
- Team budget owners explaining their own category
Key insights
- Every category’s budget, actual and variance, largest overspend first
- Material overspends against thresholds you can change
- Mapped and unmatched expenses reconciled to the source report total
- Missing actuals, explicit zeros and unbudgeted lines kept apart
- Transaction detail and supporting bills for material overspends, where available
What is the budget vs actual report?
A budget vs actual report compares planned and actual spending by category. Point Actionbook to your budget in Google Sheets and Profit & Loss in your signed-in Wave account. It matches categories, ranks overspends in dollars and percent, and reads Account Transactions for the flagged expenses you can access. Unmatched expenses stay visible so you can reconcile the figures to the source report.
How to compare budget with actual spending
Start with the monthly budget you kept and the expenses already recorded in your books.
1. Fix the period and the basis
Use one complete calendar month, one entity, one currency and one accounting basis. Set the date range and accounting basis in the expense report to match the budget.
2. Match categories you can defend
Match on a shared account or category code, or confirm a mapping between the budget and the accounts. Compare each uniquely matched expense once and use the report’s subtotal for reconciliation.
3. Work out the variance one way
Use actual minus budget throughout, so a positive number is over budget for an expense category. Show the percentage only where the budget is above zero; there is no percentage against a zero or missing budget.
4. Separate a variance from its cause
Start with the biggest overspends. Review the transactions for those expense accounts and flag any charges, dates or classifications you still need to verify.
Who the budget vs actual report is for
Solo founders
You plan spending in a sheet and track your books in Wave. See what ran over before you set next month’s budget.
- Overspends ranked by size
- The net variance in dollars and percent
- What the figures do not cover
Finance and operations leads
You prepare the monthly variance review and need the figures to tie back to the budget and the books.
- Mapped actuals reconciled to the expense total
- Unmapped rows listed separately
- Missing actuals and explicit zeros shown separately
Team budget owners
You own a category and need to see your own line against plan before you explain it.
- Your category’s budget, actual and variance
- Whether the overspend passes the materiality thresholds
- The evidence to request next
How the budget vs actual report works
Step 1: Use the accounts you already work in
Click Build with Actionbook and point it to your budget tab in Google Sheets and your business in Wave. From your signed-in browser, Actionbook reads Wave’s Profit & Loss for the same month, currency and accounting basis as the budget.
Step 2: Confirm how the categories match
Actionbook matches shared account codes and asks you to confirm a mapping for the other categories. Ambiguous rows are listed separately with their amounts.
Step 3: Drill into the biggest overspends
Actionbook opens Wave’s Account Transactions (General Ledger) for the flagged accounts and checks relevant bills where available. The dashboard shows the entries it found, links back to the available sources, and flags what you still need to confirm.
Budget vs actual report FAQ
Can I use QuickBooks Online instead of Wave?
Yes. Point Actionbook to the QuickBooks Online company and its Profit and Loss report in your signed-in browser. If your account can show Transaction Detail by Account, it can use that report to review the flagged expenses.
When would I need a CSV?
Use a CSV for either source if the sheet or report is unavailable in your browser. Include the category amounts and confirm the entity, period, currency and accounting basis for that file.
How is the variance calculated?
Actual minus budget, the same way on every row, so a positive variance is over budget for an expense category. The percentage is the variance divided by the budget, and it is shown only where the budget is above zero.
What happens when a category is missing from a source?
A category without an expense row reads Missing actual. A source row with an explicit zero counts as zero spend. Actuals with no approved budget line are reported separately, and categories budgeted at zero show their spend with no variance percentage.
How do the mapped expenses reconcile to the source report?
The variance covers mapped categories only. In the example, Wave lists $7,543 in expenses. The dashboard accounts for $7,425 in mapped categories and $118 in unmatched rows. The $1,605 variance compares the mapped actuals with their corresponding budget.
Which overspends count as material?
By default a category must be over by at least 10% and at least $500 to be flagged, so a large percentage on a tiny budget and a small percentage on a large one both stay out. The thresholds are shown on the report and you can set your own.
Can it tell me which transactions caused an overspend?
In the Wave example, three contractor bills dated Oct 2 total $420 and describe work done in September. The dashboard flags the period for you to check. Where only a category total is available, the driver stays unverified.
How is this different from a monthly business review?
A monthly business review compares team metrics and workstreams with their plans. This report focuses on one month of expenses, matching budget categories to actuals and showing what needs a closer look.
Will it change my budget sheet or my bookkeeping records?
The sheet and accounting reports are read-only inputs. The preview uses fictional example data.


