Accounting Budgets

Overview

The Budget module can be used to record Accounting Budgets for a financial year. Versions can be created to maintain the original Budget while working on an updated Budget. The List View can be filtered by the Start Date (Default = Fin Year) and by the Budget Status.

Budgets can be exported in Excel format: Menu (button) > Email Excel.

Navigation Example

Main Menu > Accounting > Budgets

Settings

User Settings

Navigation Example

Main Menu > Setup > Settings > Users (tab)

Note

The defaults are the values for new databases, new users and new Transaction Types. Your database may have different values.

Setting Description Default
Accounting > Budgets - Access AllowedOptions are None, View-only and Full Access.
  • Full Access is required to edit or create Budgets.
None

Statuses Explained

Info

Only budgets with a Pending Status can be edited or deleted.

Status Description
PendingNew budgets start as Pending. The budget and its note can be edited, and the budget can be deleted.
ActiveThe budget is read-only. Active and Pending budgets appear on the list by default.
CompleteThe budget is read-only.
CancelledThe budget is read-only.

List View

The List View displays a list of Budgets on the left and the selected Budget on the right.

Header Buttons Explained

Button Description
⬆⬇Navigate between the available budgets.
EditEdit a budget that has a Pending Status.
NewCreates a New Budget.
SaveSaves any changes (greyed-out when there are no changes).
CopyCopy an existing budget to a new budget.
Menu
  • Views:
    • Budgets: View the budget in spreadsheet format.
    • Chart: Displays a graphic presentation of a specific account.
  • Actions
    • Refresh: Resets all the data filters.
    • Delete Budget: Permanently delete a budget that has a Pending Status.
    • Email Excel: Opens the default Email Template with the budget attached as a .xlsx file.
  • Layout & Grids
    • Save
    • Save (All Users)
    • Restore Default (All Users)

Budget Selection Column

Data Filters Explained

Filter Description
Active (checkbox)Only shows budgets with Active or Pending Statuses.

Budget Selection Fields Explained

Field Description
Field Chooser (*)Add or remove columns.
IDThe system-generated number allocated to each budget.
StatusThe Status of the budget.
DescriptionThe user-provided Description of the budget.
Ver No.The Version Number of the budget.
  • When a budget is copied, the copy is given the next version number.

Budget Editing Section

Header Fields Explained

Field Description
Status barChange the Status of the budget to:
  • Pending: Changes can still be made.
  • Active: Changes are no longer allowed.
  • Complete: The budget is no longer used (that year has passed).
  • Cancelled: The budget was cancelled.
NoteSpace for you to enter a note about the budget if it has a Pending Status.
TypeDropdown list with available budget types. Options are:
  • Sales (Rep)
  • Sales (Customer)
  • Sales (Customer Categories)
  • Sales (Item Categories)
  • Purchases (Supplier)
  • Purchases (Item Categories)
  • Accounting
StartingSelect the first month of the year.
DescriptionThe name of the budget entered by the user.
NoteEnter an additional note.

Buttons Explained

Button Description
UpdateGenerate the updates as entered in the preceding three fields.
DeleteDelete the selected lines.
AddAdds a single line.
Arrow next to Add (button)Adds a group of accounts or refreshes the list based on changes to the chart of the account. The options are:
  • Add / Update All Accounts.
  • Add / Update Profit or Loss Accounts.
  • Add / Update Financial Position Accounts.
  • The Update dropdown list lets you select several rows and adjust the data as follows:
    • Set to Average for: Select the number of years.
    • Set to Highest for: Select the number of years.
    • Set to Lowest for: Select the number of years.
    • Set Amount: Enter the amount (integers only).
    • Adjust by: Enter a percentage.
      • For the first three options, the number of years selected should be limited to the number of years there is data for in QuickEasy BOS Enterprise.
  • Input Field:
    • Input the data required from the Update dropdown list. The field changes based on which option was selected.
  • Round to:
    • This optional feature rounds the calculation results (from the Update changes) to the nearest:
      • 1
      • 10
      • 100
      • 1000

Columns Explained

Field Description
Field Chooser (*)Add or remove columns.
IDThe system-generated number allocated to each line item on the budget.
AccountingName of the account.
CategoryThe account's category (e.g. Sales, Expenses).
Date FieldsColumns with dates for a year starting with the date entered as the Start Date.
  • The total at the bottom of each column simply adds every number in that column. (It is a total, not a potential profit or loss.)
TotalA total of all the months.
...A submenu to:
  • View Detailed Ledger (view the related Ledger account).
  • Delete (the row).

Chart

Buttons Explained

Button Description
ViewGenerates a chart based on the selected filters.
Menu > Reset Data FiltersResets all the filters.

Data Filters Explained

Filter Description
BudgetDropdown list from which a budget can be selected.
ItemDropdown list from which an account can be selected.

Fields Explained

Field Description
Dark Blue BarsThe bar depicts the Budgeted Amounts for the period displayed below the bar.
Orange BarsThe bar depicts the Actual Amounts for the period displayed below the bar.
Dark Blue LineThe line depicts the Cumulative Budgeted Amount for the displayed periods.
Orange LineThe line depicts the Cumulative Actual Amount for the displayed periods.

Report an issue with this page

For more useful feedback, select the text on the page you're reporting about, then click Feedback again — or continue without selecting anything.