Budget Set up
How can i put monthly budget for accounts
Jimmy Michael replied
here are brief explanations how to define budget:
Defining a Budget
Financials --> Budget --> Define Budget
Use the Define Budget window to choose the required G/L accounts.
The table displays G/L accounts defined as 'Relevant to Budget' in the Chart of
Scenario u2013 from the drop down menu, choose the scenario for which you would like to
define a budget (more details on scenarios will be provided later).
The Budget Scenarios window displays G/L accounts defined as 'Relevant to Budget'
in the Chart of Accounts, and for which an amount was entered in the budget.
Fields in the window:
u2022 Fiscal Year u2013 the fiscal year linked to the selected budget scenario.
u2022 Display Accounts with no Budget u2013 check this box to also display G/L
accounts for which no budget amount has been entered.
u2022 Acc. No. u2013 the G/L account code as defined in the Chart of Accounts.
Acc. Name u2013 the G/L account name.
u2022 Parent Acc. u2013 you can determine the budget amount of a certain G/L
account according to a certain percentage calculated from an existing
budget amount of another G/L account. Click the Tab key to display a
list of G/L accounts with budget amounts, select the required G/L
account and set a required percentage in the field '%' to the right. See
the above example: for G/L account 612100000-01-001-01, a budget of
5 millions was entered. 10% of this G/L account's budget is allocated to
G/L account 612400000-01-001-01.
Note! The option of linking budget amounts to parent accounts is used for
calculations only. Due to this reason, the budget amount entered in the field Parent
Acc. and divided among its child G/L accounts, is not actually deducted from the
budget of the parent account. In the example above, G/L account 612100000-01-
001-01 has a budget of 5 millions, and its child G/L account 612400000-01-001-01
has a budget of 500,000. However, the budget amounts are managed separately
for each G/L account.
u2022 % - in case you have selected a parent account for a certain G/L
account, type the proportionate budget percentage you would like to
allocate to the child G/L account e.g. if the parent account's budget is
$1000 and you define 10%, the child account's budget will be $100.
u2022 Method u2013 the default budget distribution method between the months.
You can define a different method for each G/L account. Click the field
to open a drop down menu displaying all the distribution methods
defined in your company.
u2022 Local Debit / Credit u2013 in these fields, enter the amount in local currency
for each G/L account. The budget is checked against the debit side.
Therefore, you must enter an amount in the Debit field. An amount can
also be entered on the credit side.
u2022 System Debit, Credit - in these fields, you can manually change the
system currency budget amounts, which were calculated according to
the amount in local currency multiplied by the relevant exchange rate.
u2022 Actual u2013 the G/L account's balance to date based on its journal entries
in SAP Business One in local currency.
u2022 Actual (SC) - the G/L account's balance to date based on its journal
entries in SAP Business One in system currency.
u2022 Actual u2013 Future Local, System u2013 displays the future balance of the G/L
account. This future balance displays the amounts of open Purchase
Orders and Goods Receipt POs.
You can choose to display or hide columns in this window by clicking the Settings icon
and selecting relevant fields.
I have the file for more detail. let me know if you need it.