Budgets and 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 General Listing Grid

Go to General Ledger > 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 

Managing Budgets (11.6) - AIQ Academy

Only budgets in open periods can be updated.

1. In the blue banner, go to General Ledger > Budget Review & Maintenance.
2. In Budget for, 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. This reverses the sign convention so that income appears as positive values rather than negatives.
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. See Download & Upload Budget Template for more details.

Note, if 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 selected budget by a percentage relation to another selected budget.
• Spread: Enter an amount and this will be spread evenly across all periods in the selected dataset.
• Fill: This allows you to fill each period in the selected budget with the amount entered.
  
• Copy: This allows you to copy from one budget to another.
  

After completing any bulk action, click Apply to preview the result, then click Update to save.