Home » Categories » Solutions by Business Process » Finance » Nominal and Cashbook

CALC - Recalculate Current Year Budgets - Nominal

Datafile Software

CALC – Recalculate Current Year Budgets - Nominal

You would use this option at the start of a new year to calculate automatically the new year’s budgets based on either the actual results from the previous year or the previous year’s budgeted values. It is a batch operation — that is to say, it processes a range of accounts in the one run.You can ask to increase the previous year’s values by a fixed percentage in the process.

Recalculate Using Which Value?

If you want to recalculate the current year budgets using the actual month-by-month results from last year, then reply 1 <Enter>. If you want to base the current year’s budgets on the previous year’s budgets, then reply 2 <Enter>.

Account range from: to:

You can choose a consecutive range of nominal account codes here, which includes the ‘From’ and ‘To’ accounts entered. If you leave the ‘From’ account blank, then the range starts from the beginning of the file. If you leave the ‘To’ account blank, then the range finishes at the end of the file.

Adjust Budgets by Percentage Value %

You can increase last year’s values by entering a percentage here. If you enter ‘10.00’ here (you don’t have to enter the decimal places if zero) then last year’s values are increased by 10%. If you leave it zero, then last year’s values are copied without change. If you enter a negative value here, then last year’s values are reduced by this percentage.

Automatically Set Period Budgets?

Whilst this menu option is used to set the annual budget figure, in many cases you will want to reset the period budget figures at the same time. If you reply 'No' here then no period budget figures are touched by this option.

If you reply ‘Y’ here then:

If an account has a budget factor table number defined for it, that table is used to calculate the period budgets based on the new annual figure, as described above

If no budget table factor is defined for an account, then the period budgets are calculated by dividing the annual budget by the number of periods in the year

Note

Rounding may leave a few pence ‘unallocated’ when determining the period budgets. The few odd pence not yet allocated to a period are added to the final period for equal budgets, or to the largest period value for factored budgets.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Account Audit Trail, Account Audit Trail (Currency) - Nominal
Viewed 1268 times since Wed, Jun 27, 2012
VIEW – View an Account - Nominal
Viewed 824 times since Wed, Jun 27, 2012
Default Bank Account for Receipts and Payments
Viewed 2265 times since Wed, Jun 13, 2012
Automatic Postings - Cashbook
Viewed 1248 times since Wed, Jun 27, 2012
Defining User Journals - Nominal
Viewed 1276 times since Wed, Jun 27, 2012
Bank Reconciliation – Default Date for New Transactions
Viewed 1027 times since Wed, Jun 13, 2012
Nominal Ledger Configuration
Viewed 1245 times since Wed, Jun 27, 2012
Set Auto Expand Data Files - Cashbook
Viewed 1209 times since Thu, Jun 28, 2012
System Profiles Screen 1 - Nominal
Viewed 1469 times since Wed, Jun 27, 2012
PERIODS – Comparative Input for Periods - Nominal
Viewed 876 times since Wed, Jun 27, 2012