QuickBooks HelpQuickBooksHelpIntuit

Create budgets

by Intuit614 Updated about 2 hours ago

Many businesses use budgets to help plan their finances. Look back at your assets and liabilities, then create a budget for the coming year, month, or quarter. 

With all your financial data in your company, you can create both profit and loss or balance sheet budgets you need. This gives you an overview to help compare your actual income and expenses with your budget.

Note: You can create a budget at any time, but it’s best to start at the beginning of the fiscal year.

For a better experience, open this article in QuickBooks Online. Launch side-by-side view Open this link in a new window

The QuickBooks design has been updated! If this video doesn't match what you see in QuickBooks, use the in-app Search bar to navigate to the page you need.

Get the tools you need to streamline your business and the insights to drive it forward. All in QuickBooks Online Advanced.

Prerequisites

  • Sign in with an account that can access budgets, such as an admin or standard all access user. 
  • Make sure each account you want to include in your budget is listed in the chart of accounts.
  • Make sure the beginning of your fiscal year is correct in the Advanced section of your Account and settings (Take me there).

If you track your budget outside QuickBooks Online and want to import it, prepare the budget in a properly formatted Excel spreadsheet of 10MB or less.

Follow this link to complete the steps in product Open this link in a new window

  1. Select Import budget.
  2. Select a period, format, and pre-fill data for your template.
  3. Download the P&L budget_template.xlsx file.
  4. Open the budget template in Excel or Google Sheets.
  5. Enter your budget for each account for all months listed.
    Important: Don't add columns or rows for any additional accounts. 
  6. Save the file with a new name.

You can either create a new budget or import one you track outside QuickBooks.

Step 1: Create or import a new budget

You can either create a new budget or import one you track outside QuickBooks.

Create a new budget

Follow this link to complete the steps in product Open this link in a new window

  1. Select Create new or Create budget.
  2. Select either Profit and loss, or Balance sheet.
  3. Select the fiscal year you're creating the budget for.
  4. For a Profit and loss budget, select either Consolidated budget or Subdivided budget. For a Balance sheet budget, select Yearly, Quarterly, or Monthly.
  5. For a subdivided budget, select what you want to subdivide by, like Location or Class.
  6. Select Next.

Import a budget

If you track your project budget outside QuickBooks, you can use our AI-powered import to track it inside your QuickBooks company. That way, any mismatches or duplicates can be addressed when mapping the spreadsheet to QuickBooks.

Note: You can only import a profit and loss budget.

  1. Select Import budget.
  2. Select the fiscal year you're creating the budget for.
  3. For a Profit and loss budget, select either Consolidated budget or Subdivided budget
  4. For a subdivided budget, select what you want to subdivide by, like Location or Class.
  5. Select Next.
  6. Upload the properly formatted Excel file and select Next.
  7. When the budget is finished importing, select View budget.

Step 2: Review the created budget

Once the budget is created, review it and make any necessary changes.

  1. Select Edit ✎ and name your budget.
  2. If you want to add either past actual or past budget data as a reference, turn on Compare reference data. Then select the reference data you want to compare.
  3. To pre-fill your budget with reference data, check the box next to each account you want to include. Then from the Batch actions dropdown, select Copy reference data.
    Tip: To remove the reference data, select Clear reference data instead.
  4. Enter your budget for each account. Switch between YearlyQuarterly, or Monthly views as needed.
  5. Select Save or Save and close.

Note: You can also import a budget from an Excel spreadsheet using Spreadsheet Sync.

Next steps

Once you’ve created a budget, you can copy it, run a report with it, edit it, or delete it.

Follow this link to complete the steps in product Open this link in a new window

  1. Find the budget you want to copy. 
  2. In the Actions column, select the dropdown ▼, then select Duplicate.

Select the period you want to duplicate the budget for, then select Duplicate.

  1. Find the budget you want to use for a report.
  2. In the Options column, select the ▼ dropdown, then select Run Budget Overview report or Run Budgets vs. Actuals report.

Note: If you want to export a budget as a PDF or Excel file, run a report and export it.

You can edit existing budgets to suit your business needs.

  1. Select the budget you want to edit.
  2. Make any changes and select Save or Save and close.

If you decide to delete a budget, be careful. You can't recover deleted budgets.

  1. Check the box next to the budget you want to delete.
  2. In the Actions column, select the dropdown ▼, then select Delete.

Related links

QuickBooks LedgerQuickBooks Online AdvancedQuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple StartQuickBooks Solopreneur

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.