All-you-need-to-know-about-nominal-budget-in-Sage-200

All You Need to Know About Nominal Budgets in Sage 200

In All Sage Blog Posts, Sage 200 by Kate Jones

Spread the love

Comparing your actual spend against your budgeted spend is one of the most useful things you can track as a business. It is for this reason that inputting your budgets into Sage is such a worthwhile task. Here, we will go through all you need to know about budgets and why you should be using them.

Different Types of Budgets

There are different types of budgets you can use within Sage 200

No Budget

If you had previously set budgets on an account and then at a later date, choose no budget as your budget type, you are prompted to delete the budgets.

Monthly Budget

Enter the required values for each budget period in the budget this year column.

Annual Budget

Using an annual budget, you can enter the total value, which the ledger apportions equal values to each period. A year to date budget figure is shown which is the accumulated budgets of the periods to date.

Group Budget

This is only applicable for posting type nominal accounts. Selecting this option indicates that you do not intend to enter any budget figures for this account since they will be included in the budget figures for a group account.

Profiled Budget

Select the required budget from the budget profile list. The total annual budget figure will be divided according to the percentages defined in the selected budget profile. There are 3 templates for profiled budgets which have to be set up before you input your budgeted amount. These type of budgets are good for seasonal businesses e.g. ice cream sales.

maintain-nominal-budget-input

Future Years Budgets

Within Sage 200 (versions 2015 and above) you can budget up to 5 years ahead of the current financial year. These can also be imported on newer versions (we will cover imports later on)

future-nominal-budget-input

NB: In previous versions, you could still enter budgets but only for the one future year.

 

Manually inputting your budget

If you would like to manually input/amend your budgets for a specific nominal account

Nominal Ledger-Nominal List-Amend Account

Within this screen, you can go to Budget This Year or Budget Future Year. On these tabs, you can see your budgets and whether they are set out as Monthly or Annually. You can then simply type your budget into the relevant boxes and save.

monthly-nominal-budget-input

Importing budgets

There is a function within Sage 200 where you can import your budgets from excel format into the system. If you have a lot of accounts, the thought of manually entering budgets may sound daunting. Don’t worry, you have the option to import your budget using the standard Sage CSV Imports. The import file allows you to input multiple monthly budgets for multiple accounts in one go. This is a much faster process and is great if you already use Excel to manage your budgets.

You need to ensure when completing the CSV template file for budgets that all headers are not amended/edited or deleted. The following fields within the CSV template file are mandatory –

  1. Account Cost Centre – This is the nominal code which you will be creating, is 3 text characters long and does not already exist within Sage 200.
  2. Account Department – This is the nominal account department, 3 text characters and must already exist in Sage 200.
  3. Budget Year (this will not be available for versions 2013 or below) – Mandatory if you are importing budgets for multiple years. Year relative to the current year must be one of 0 for the current year, 1 for current year +1, 2 for current year +2, 3 for current year +3, 4 for current year +4, 5 for current year +5.
  4. Account Number – This is the nominal account number, up to 8 text characters and already exist in Sage 200.
  5. Annual Budget (this will not be available for versions 2013 or below) – The annual budget, you must enter a value even if you are only importing monthly budgets.

To upload the CSV file into Sage 200 –

Nominal Ledger-Utilities-Import-Import Ledger File

Make sure to change Data to import to Budget Values.

validate-nominal-budget-input

Default budget reports

There are a number of default budget reports you can run through Sage 200.

To run a report

Nominal Ledger-Reports-Budget Comparisons

From here you can run

Detailed Budgets

Summary Budgets

Individual Budgets

Detailed Budgets (previous years)

Each report has set criteria allowing you to select the range of records from that module to include on the report. Each report can be printed, emailed and exported to an Excel spreadsheet.

You can also create your own custom reports, why not contact us for more information.

I hope this blog has given you some helpful tips on budgets within Sage, if you require any assistance, information or would just like to let us know of any other useful blogs you would like please let us know.

Sage200-training-cta

Other Blogs:


Spread the love