How to Create a Budget in QuickBooks Online (Plus and Advanced)
The bank wants a budget with the loan renewal, or the partners want a plan for the year. QuickBooks Online can hold it right next to your real numbers, as long as you're on Plus or Advanced. It takes about as long as the typing does.
Current layout: go to Reports, then Financial planning, then Budgets, and create a new budget.
Reports › Financial planning › Budgets › Create budgetOlder layout: the same tool sits under the gear menu.
Gear icon › BudgetingCan't find either? Budgeting is included in QuickBooks Online Plus and Advanced only. Simple Start and Essentials need an upgrade first.
Profit and loss budget or balance sheet budget?
QuickBooks asks this first. Most small businesses want the left one.
Income and spending by month
- Targets for sales, cost of goods and each expense account.
- Can be one budget for the whole company, or subdivided by class, location or customer.
- The only type you can import from a spreadsheet.
- What lenders and partners usually mean by "a budget".
Ending balances you aim for
- Targets for things like cash on hand, loan balances and receivables.
- Set yearly, quarterly or monthly.
- A status bar helps you keep the targets in balance as you type.
- Useful when a lender sets covenants on cash or debt.
Start with profit and loss. Add a balance sheet budget later if someone holds you to a cash or debt target.
Building the budget
Written for the current Reports layout. Labels in the older gear-menu version are close.
- 1
Confirm the fiscal year start
Gear icon › Account and settings › AdvancedThe budget's months follow the first month of your fiscal year. Fix it here before you start, not after you've typed twelve columns.
- 2
Make sure the accounts exist
A budget can only use accounts already in your chart of accounts. If you're planning a new kind of spending, add the account first.
- 3
Create the budget and choose its shape
Reports › Financial planning › Budgets › Create budgetPick profit and loss or balance sheet, choose the fiscal year, then consolidated (one budget for everything) or subdivided. Subdivided asks which split you want, such as Class or Location, so you can set separate numbers for each class or site.
- 4
Start from last year if you have it
Turn on Compare reference data to see last year's actuals beside each row. Tick the accounts you want to reuse, then choose Batch actions > Copy reference data to drop those numbers in as your starting point.
Watch for: one-off costs from last year (a move, a lawsuit, a big repair) copying straight into this year's plan. Adjust those rows by hand.
- 5
Type the amounts, then save
Enter a figure for each account and month, or a yearly total spread across the months. Switch between monthly, quarterly and yearly views to check the totals, then Save and close. You can come back and edit as often as you like.
Reading one line of Budget vs. Actuals
Run it from the budget list: open the dropdown in the Actions column and choose Run Budgets vs. Actuals report. It shows one budget at a time.
| Budgeted for March (The number you typed in the grid.) | $4,000 |
|---|---|
| Actually spent in March (Every bill, expense and check posted to Advertising.) | $5,150 |
| Over budget (The report shows this as the difference and as 129% of budget.) | $1,150 |
The report only knows what's been posted. If March's ad invoices aren't entered yet, the line looks fine until they are, which is why a mid-month read can mislead.
Questions people ask
How do I edit a budget in QuickBooks?
Open the budget list (Reports, Financial planning, Budgets), select the budget or its Edit pencil, change any amounts and save. There's no need to rebuild it. To try a what-if version without touching the original, use Duplicate from the Actions dropdown and edit the copy.
How do I delete a budget in QuickBooks?
Tick the box next to it in the budget list, open the dropdown in the Actions column and choose Delete. A deleted budget can't be brought back, so archive it instead if you might want it later. Deleting a budget never touches your actual transactions.
Can I print or export my QuickBooks budget?
Yes. Run Budget Overview or Budgets vs. Actuals from the budget list, then use the export icon for Excel or PDF, or the print icon. Save the customized report and you can also have QuickBooks email it to you on a schedule from Reports > Custom reports.
Can I import a budget into QuickBooks Online instead of typing it in?
Yes, for profit and loss budgets. Choose Import budget from the budget list, pick the year and consolidated or subdivided, download the template, fill it in and upload it. Don't add rows or columns for accounts that aren't in QuickBooks, and keep the file under 10MB.
Why is there no budgeting option in my QuickBooks Online?
Either your plan is Simple Start or Essentials, which don't include budgets, or your user role doesn't have access. An admin or a standard user with all access can create them. Upgrading to Plus is the usual fix.
Can QuickBooks warn me when a category goes over budget?
Not line by line. It will email a saved report on a schedule, but someone still has to read it and spot the row that's off. n-frames builds a weekly check against the QuickBooks API that compares each budget line with actuals so far and messages the person responsible for that spending, with the transactions that pushed it over.