Can I copy my monthly budget value across the year?
Description

When you use Advanced Budgeting you can use the Copy values option to copy budget values across the 12 months of the year and if required, increase or decrease the values. Let's take a look.

Cause
Resolution

Copy budget values

  1. On the navigation bar click Nominal codes, click Budgets then browse to and select the relevant nominal code. Read more >
  2. Under Monthly Breakdown, click the budget or forecast month you want to start the value from.
  3. Enter the value you want to copy, then click Copy value.
  4. Select the copy type you want to apply, then if required enter an adjustment value, then click  OK.
Incremental adjustment example

This is a cumulative adjustment. A month is calculated based on the previous month's value plus the adjustment.

If you enter a value of £/€10 in January and you choose a £/€5 adjustment, the result is:

JanFebMarAprMayJun
10.0015.0020.0025.0030.0035.00
JulAugSepOctNovDec
40.0045.0050.0055.0060.0065.00

If you enter a value of £/€10 in January and you choose a 5% adjustment, the result is:

JanFebMarAprMayJun
10.0010.5011.0311.5812.1612.76
JulAugSepOctNovDec
13.4014.0714.7715.5116.2917.10

NOTE: To enter a percentage adjustment you must enter the % sign in the Percentage or Value adjustment box. For example, to increment by 5%, enter 5% in this box.

Uniform adjustment example

The adjustment is calculated using the starting month's value plus the adjustment.

If you enter a value of £/€10 in January and you choose a £/€5 adjustment, the result is:

JanFebMarAprMayJun
10.0015.0015.0015.0015.0015.00
JulAugSepOctNovDec
15.0015.0015.0015.0015.0015.00

If you enter a value of £/€10 in January and you choose a 5% adjustment, the result is:

JanFebMarAprMayJun
10.0010.5010.5010.5010.5010.50
JulAugSepOctNovDec
10.5010.5010.5010.5010.5010.50

NOTE: To enter a percentage adjustment you must enter the % sign in the Percentage or Value adjustment box. For example, to adjust by 5%, enter 5% in this box.

[BCB:120:Limitless - 50 Accounts - Nominal / Chart of Accounts:ECB]


Steps to duplicate
Related Solutions