Budgets/revised budgets can be used for comparison purposes on a wide variety of GL reports. 

Budget Review & Maintenance

Budget Review and Maintenance lets you view and manage your budgets as follows:

• Enter Budget and Revised Budget data manually.
• Review and compare General Ledger Accounts by one or more Categories, Sub-Categories, or Dimension Tags.
• Compare Actual, Budget and Revised Budget values for consecutive or non-consecutive financial years, past or future.

This is useful if you are using Departmental (Dimension Tag) Analysis budgets, Project, or Job Accounting rather than, or in addition to, traditional Departmental Accounting. Each time you set up a new Project or Job, you can enter Budgets directly. 

Budgets can also be uploaded using a template. See Download & Upload Budget Template.

Viewing Budgets in GL Listing Grid

Go to GL > General Ledger Accounts.

If the Period Budget and To Date Budget columns are not present, click Add/Remove Columns and add them. 

Prerequisites

Before you start setting up your Budgets, reduce your workload by reviewing the pre-supplied set of General Ledger Codes and deleting any unwanted ones. See Create & Manage Entity GL Accounts for further details.

See:

Download & Upload Budget Template 

Create & Manage Entity GL Accounts 

GL Account Queries (11.5) - AIQ Academy

Managing Budgets (11.6) - AIQ Academy

Updating Budgets

Data goes back two years. Only budgets in open periods can be updated.

1. In the blue banner, go to GL > Budget Review & Maintenance.
2. In Budget, select a GL account. If needed, select one or more Category and Sub-Category.
3. Enter the Years to compare. The current and previous years appear by default.
4. Click View. If needed, click Clear Filter to restore the program to its initial state.
5. Optionally tick Display signs as reversed.
6. Update budget figures individually as follows:
   • If the General Ledger Code has no Dimension Tag associated with it, enter the Budgets directly in this screen. Click Update.
   • If the General Ledger Code has any Dimension Tags associated with it, select them from the Dimension Tag dropdown. Then enter Budgets for each period and click Update.

The Budget Review & Maintenance screen also lets you:

• Export to: Export the Datasets to several formats.
• Budget Upload: Link to Upload Budget Template screen.

Update Budgets in Bulk

Note, is a year has any closed periods, the bulk update amounts will be calculated using a 12 period financial year but only applied to the open periods.

In the Actions dropdown, select one of the following:

• Adjust: This allows you to adjust one budget in relation to another by a percentage.
• Spread: Enter an amount and this will be spread evenly across all periods in the selected dataset.
• Fill: This allows you to fill every period in the chosen budget with a value.
  
• Copy: This allows you to copy from one budget to another.
  

Click Apply to bulk complete the budget, then click Update.