You can set up budget figures for each period of the year for some or all accounts. These are maintained using the options on this sub-menu.
There are a number of ways to create and update the budget figures on accounts:
Base this year’s figures on last year’s actual results, or on last year’s budgets
Enter the total budget value you want for the year, and ask the computer to divide these across the periods, either equally or based on a pre-defined model
Enter all the periods for the year one by one for each account
Import them from an external source such as a spreadsheet
Note
Many people use a spreadsheet to develop their budgets, and then output the details to an ASCII file for input into their nominal ledger.The following options would then be used to revise the budgets input so far, rather than create them from scratch.See also the Introductionchapter for more information.
When you select the BUDGETS option a further menu of options is given.
Budget Factor Tables
In most companies both income and expenditure follows a seasonal trend of some nature during the year.You can define up to five budget factor tables in the nominal ledger System Profiles to provide period by period trend figures. You might define one for sales accounts, another for gross margin accounts, perhaps a third for wages and salary costs, and a fourth for marketing expenditure.
A budget factor table defines the percentages to apply to the annual budget figure for 12 or 13 periods (depending on the number of periods in your financial year). The percentages must sum to 100%. If you enter a budget figure for the year, and ask to allocate it according to a budget factor table, then the individual period budgets are calculated from the total budget times the budget factor for that period.
In the example below, a budget of £800,000 has been allocated across the 12 periods according to the budget factor table overleaf
Article ID: 999
Created On: Wed, Jun 27, 2012 at 11:51 AM
Last Updated On: Mon, Jun 19, 2023 at 7:28 PM
Online URL: https://kb.datafile.co.uk/article/budgets-â€-budgets-proposed-nominal-999.html