Accounting Budgets Tutorial
Overview
An Accounting Budget is a financial plan that shows expected income, costs and cash flow over a certain time, usually a year. Budgets act as a guide for a business’s financial activities, helping managers set goals, allocate funds and plan for cash needs. Key types of budgets include:
- The operating budget (for everyday costs and income)
- The capital budget (for long-term investments)
- The cash flow budget (showing money coming in and going out to ensure cash availability)
- Budgets are important for checking performance, as they allow businesses to compare actual results with forecasts and identify areas for improvement. They also help in decision-making, allowing companies to plan for growth, control spending and maintain financial stability.
- Reviewing and adjusting budgets regularly is important to keep on track with business goals.
💡These tutorials explain how to create, edit and display budgets.
How to View a Budget
- Navigate to Main Menu > Accounting > Budgets.
- Select the Year to view all the available budgets for that year or select No Date to display all the budgets.
- Click View (button).
- Double-click the budget you want to open.
How to Create a New Budget from Scratch
- Navigate to Main Menu > Accounting > Budgets.
- Select the Year you want to create the budget for.
- Click New (button).
- Add any Notes in the block provided.
- Click the arrow next to the Add button and select:
- Add/Update all Accounts, or
- Add/Update Accounts (Profit or Loss), or
- Add/Update Accounts (Financial Position).
- Edit the fields.
- Set the Status to Active.
- Click Save (button).
- Note: The totals at the bottom do not show a profit or loss; they show a total of all the numbers filled in.
How to Create a Budget by Copying a Previous Budget
- Display a list of budgets.
- Double-click the budget you want to view.
- Click Copy (button) > Copy to new Budget to create a budget for a new year.
- Change the Date to the new year.
- Edit the fields.
- Set the Status to Active.
- Click Save (button).
How to Delete a Budget
- Display a list of budgets.
- Double-click the budget you want to view.
- If the budget is blank, click Delete (button).
- Note: If you get an error message that the budget cannot be deleted, first delete all the rows.
How to Delete Rows in a Budget
- Display a list of budgets.
- Click View (button).
- Select the rows you want to delete by clicking them.
- Use Ctrl + click to select random rows.
- Use Shift + click to select a group of adjacent rows.
- Click Delete (button) between Update and Add (buttons).
How to Add Accounts to a Budget
- Display a list of budgets.
- Click View (button).
- Click Add (button) to add a single account. A row is added at the bottom of the budget. Select an Account in the Account column and fill in the other information.
- Click the arrow next to the Add button to add multiple Accounts and choose:
- Add/Update all Accounts, or
- Add/Update Accounts (Profit or Loss), or
- Add/Update Accounts (Financial Position).
How to Create Several Budgets for the Same Year
- Display a list of budgets.
- Double-click the budget you want to copy to open it.
- Click Copy (button).
- Select Copy to Version to create another budget for the same year.
- Edit the fields.
- Click Save (button).
How to Edit a Budget
- Display a list of budgets.
- Double-click the budget you want to edit.
- Edit individual records by overwriting the numbers in the grid.
- Note: Use Tab to move between the fields.
- Edit multiple records by selecting the rows to edit and then selecting an Update option next to the Update box:
- Adjust by:
- Select a % to update by:
- Note: This feature adds the adjustment to the existing value (to add 10%, you adjust by 10%, not 110%).
- Select a Round to option (1, 10, 100, 1,000).
- Click Update (button).
- Select a % to update by:
- Set Amount:
- Update = Enter a value in the block.
- Click Update (button).
- Set to Average for:
- Enter the number of years.
- Note: You must have data for the chosen number of years for this calculation to work.
- Click Update (button).
- Enter the number of years.
- Set to Highest for:
- Enter the number of years.
- Note: You must have data for the chosen number of years for this calculation to work.
- Click Update (button).
- Enter the number of years.
- Set to Lowest for:
- Enter the number of years.
- Note: You must have data for the chosen number of years for this calculation to work.
- Click Update (button).
- Enter the number of years.
- Adjust by:
- The Total column updates automatically.
- Click Save (button).
How to Email a Budget
- Display a list of budgets.
- Double-click the applicable budget to open it.
- Click Menu (button) > Email Excel to email the budget in Excel format.
How to See a Budget Comparison
- Navigate to Main Menu > Accounting > Statement of Profit or Loss.
- Click Set > Fin Year (Months).
- A new Budget option appears in the same row. Click the dropdown list next to Budget and select the budget you want to display.
- Note: If no budget exists yet, there are no names to select.
- Click View (button).
- Note: The Statement of Profit or Loss appears on the left and a graph appears on the right.
- Note: The budget comparison does not appear on the graph.
How to See the Percentage Change between the Budgeted and Actual Amounts
- Navigate to Main Menu > Accounting > Statement of Profit or Loss.
- Click Set > Fin Year (Months).
- A new Budget option appears in the same row. Click the dropdown list next to Budget and select the budget you want to display.
- Click the dropdown list next to % and select Budget.
- Click View (button).
- Note: The Statement of Profit or Loss appears on the left and a graph appears on the right.
- Note: The budget comparison does not appear on the graph.