Skip to Content

Creating and maintaining budgets

Use Budget & Forecast → Budgets to prepare a profit-and-loss or balance-sheet plan. Start with a new budget, an uploaded spreadsheet, or an available accounting-software budget.

Set up a new budget

  1. Click New Budget.
  2. Enter Budget Name.
  3. Choose Budget type: Profit and loss or Balance sheet.
  4. Select Period.
  5. Choose the available Budget format or Default view options.
  6. Select Pre-fill data if you want a starting point.
  7. Click Next.

Profit-and-loss budgets offer Consolidated and Subdivided formats. For a subdivided plan, select the available grouping and values. Balance-sheet budgets offer Monthly, Quarterly, or Yearly as the default view.

Enter and copy values

Find accounts by name or number and edit their period cells. Use the row controls to copy a value across periods or split a total across months. Inspect the resulting monthly allocations before saving.

Use Compare reference data to show a reference alongside the budget. Select rows and choose Batch actions → Copy reference data to populate those rows. Clear data removes values from the selection after confirmation; check the selected rows before proceeding.

Click Save to create the budget. After the first save, Table settings → Autosave budget controls automatic saving. Check Last saved at or use Save before leaving when you need confirmation that the changes were retained.

Customize and export the worksheet

Table settings includes Hide empty rows and Compact display density. Click Apply to apply the display options. Use Export/Print → Export to Excel or Print/Save as PDF for the worksheet output.

Import a spreadsheet

  1. Return to Budgets and click Import Budget.
  2. Complete the budget name, type, period, and available setup options.
  3. Click Download budget template.
  4. Fill the generated workbook using its chart-of-accounts rows.
  5. Choose the completed XLSX file, up to 10 MB.
  6. Click Upload budget and review the result.

Use the generated template so the workbook matches the selected client’s accounts.

Import and manage saved budgets

Import from QuickBooks or Import from Xero imports available budgets from the connected provider. Check the resulting list before repeating the import.

A budget’s menu includes View/Edit, Duplicate, Archive, Restore, and Delete. Hide archived budgets controls whether archived plans appear. Select multiple budgets for Batch actions → Delete.

Run reports in Spreadsheet Sync downloads a spreadsheet export. For a QuickBooks client, Push to QuickBooks or Re-sync to QuickBooks sends the budget to QuickBooks. Those push actions are hidden for Xero clients.

Last updated on