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
Update from Other Ledgers - Nominal
Viewed 2073 times since Wed, Jun 27, 2012
Reconcile Bank Account - Cashbook
Viewed 2191 times since Wed, Jun 27, 2012
PERIODS – Comparative Input for Periods - Nominal
Viewed 1119 times since Wed, Jun 27, 2012
Warn if Sales/Purchase Account On-Stop
Viewed 1690 times since Tue, Jun 12, 2012
Transaction Control Numbers - Nominal
Viewed 1887 times since Wed, Jun 27, 2012
Record Journal Number on Sales / Purchase Transactions
Viewed 2129 times since Tue, Jun 12, 2012
PREV-YR-TOT – Previous Year Budget Totals - Nominal
Viewed 1085 times since Wed, Jun 27, 2012
Enter New Transactions during Bank Reconciliation
Viewed 1985 times since Wed, Jun 13, 2012
End of Year Procedure - Nominal
Viewed 2323 times since Wed, Jun 27, 2012
Hyperlinks on Full Mode Financial Summaries
Viewed 2677 times since Tue, Jun 12, 2012