Budget table

The Budget table is where planning is entered. It's setup is identical to the Transactions table. Specific columns are depending on whether you are working with Income/Expense or Double-Entry accounting.

Enter Financial budgeting Movements

Financial planning movements are entered in the Budget table. This is like entering accounting transactions, but about future movements.
For each budgeted event indicate:

  • The date when the event is expected to occur.
  • The repetition code for recurring movements (frequence for the repetition of the movement)
  • A possible description
  • The accounts that are involved in the movement. 
  • The amount of the movement.

Transactions may be of two types:

  • Single, occurring on one specific date.
  • They are repeated with a fixed frequency.
    In this case they are entered only at their first occurrence, with indication of a repetition code.
    For an automatic forecast over several years, enter repetition code "Y" for all operations that will be repeated on an annual basis.

Repetition

To designate a repetitive movement, the following columns are to be used:

  • Repeat.
    Indicating "M" = Monthly for example, will be like entering the registration for all the following months.
    If no repeat code is assigned, the transaction will take place once only.
  • End (Date).
    Use in combination with Repeat and indication of the last date on which the operation is to be repeated.
  • Total.
    The total amount entered for the current year.

Repetitive movements can be indicated. They are entered once only, the program will then take charge of following occurrences.
Repetition is the central function for planning with Banana and is useful for four reasons:

  1. Planning is made very fast, because recurring movements such as rent, bank fees, salaries and so on are entered on a single registration row.
    Once the user has indicated the transaction a first time, the program will then repeat it automatically.
  2. The program is capable of creating financial projections for several years:
    • Not only repetitive operations are indicated each month or quarter, but also those repeated annually. The "Y" repetition code designates all operations that will be repeated every year, for example
      • Depreciation and other year-end closing operations.
      • Other amounts occurring on an annual basis.
  3. Repetition can be linked to a formula in order to create a progression.
  4. When you modify your planning, altering the relevant row in question will instantly update all other data.

    Forecasting with quantities and prices

    Quantities and unit prices can be inserted. This way the program will automatically calculate the amount of the transaction. 
    For a restaurant, for instance, you will be able to indicate the number of meals served and their average cost.
    This will provide you with a more precise idea of the elements that make up for your planning. By adjusting unit prices you might evaluate the impact of a price change.

    Calculation formulas

    Formulas in Javascript can be inserted in the Formula column.
    You can enter calculations, assign and use variables, and recall functions.

    There are functions that allow you to use the planning data up to that point.
    Examples of use:

    • Calculation of depreciation.
      If the value of the investment is altered, depreciation will be adjusted.
    • Calculation of interest.
      Interest is calculated on actual basis (365/365 days).
    • Calculation of commissions.
      Apply a percentage to be paid to sellers, based on revenues for a determined period.

    With  formulas you can automate the correlated transactions. Higher revenues will lead to higher commissions and lower interest.
    Lower investments will automatically lead to lower depreciation and interest.

     

    help_id
    accounting::budget

    Help us improve the documentation

    We welcome feedback on how to improve this page.

    Tell us what theme needs a better explanation or how to clarify a topic.

    Share this article: Twitter | Facebook | Email