Budget table columns

Documentation •
In this article

The Budget table columns are very similar to the Transactions table columns. To facilitate understanding, letters have been used for account designation in the following example. If you have accounts with numeric accounts, you will obviously use your own account numbers.

Budget table columns

Below you will find explanations for each budget column:

  • Data
    The future date when you expect the operation to take place:
    If an exact date is not available, for example a monthly sales budget, enter the end of the month date.
  • Repeat
    A repetition code is entered. for further information on use, also see Dates and Repetitions.
    When the forecast is calculated, the program internally creates copies of the rows with the date set successively and based on the indicated repetition code.
    • Blank, no repetition takes place.
    • The initial row keeps the date indicated.
    • The date of the copy lines is progressively increased as defined by the repeat code.
    • If the repetition is monthly or yearly in the created lines:
      • It is generally used on the same day as the column being used.
      • If the day is greater than the number of cycles in the month, the last day of the month is used.
      • If the end of month indication "ME" or "YE" is indicated, the last day of the month will be used.
    • Basic codes for repetition:
      • "D" for a daily repetition (Day)
      • "W" for a weekly repetition (Week)
      • "M" for a monthly repetition (Month)
      • "Y" for a yearly repetition (Year)
    • Multiples
      If the code is preceded by a number, the repetition occurs with the multiplied frequency.
      • "2M" for bimonthly
      • "3M" for quarterly
      • "6M" for six months
    • Repetition with a later date at the end of the period.
      The "M" and Y "codes with the" E "at the end move the repetition date to the end of the month.
      • "ME" monthly repetition, but with a date at the end of the month.
        If you enter the date 1.1.2022 the next date will be 28.2.2022 and the one after 31.3.2022
        If the date is 28.2.2022, the next date will be 31.3.2022.
      • "3ME" for quarterly end of month
        If you start on 30.6.2022, the next date will be 31.12.2022.
      • "6ME" for half-yearly end of the month
      • "YE" each year, but at the end of the month.
        If the date is 28.2.2022 the next date will be 28.2.2023.
      • "5YE" every five years, but at the end of the month.
        If the date is 28.2.2022 the next date will be 28.2.2027.
  • End (End date)
    • Generally to be left blank.
    • Enter the date after which there must be no repetition.
      For a lease, the date on which the lease ends will be indicated as the final date.
  • Variant
    To indicate a possible variant relating to the budget, in combination with the extensions.
  • Management of a New Year 
    Indicate how the transfer should take place when a new year is created.
    • No value - the date is incremented by one year.
    • "1" The date remains the same.
    • "2" The transaction is not transferred to the new year.
  • Description
    A descriptive text for the operation that appears in the account tab.
    You can use calculation formulas by entering the value between ${} (see Javascript template literals). 
    When the account card is prepared the formula is resolved and the result is replaced.
    For example the text "Amount ${10+20} year" will be "Amount 30 year".
    You can use all the formulas, but to avoid confusion, it is recommended to avoid entering value assignments in the Description column.
  • Debit and Credit Account, CC1, CC2, CC3
    As in the Transactions table, the accounts in which the transactions are to be registered are indicated.
    Segments and cost centers can also be used. This way, a budget may also be prepared for segments or cost centers.
  • Quantity
    The quantity which, multiplied by the unit price, returns the total amount  (see Quantity and Price columns)
  • Unit
    A description referring to the quantity, for example: m2, ton, pcs.
  • Price/Unit
    The unit price which, multiplied by the quantity, returns the total amount
    • In the income and expense accounting, enter a negative value to have the amount entered in the Expenses column.
  •  Formula (in base currency)
    Allows you to enter calculation formulas, in Javascript, plus the programming functions of the Banana Accounting  Extensions.
    If there is a formula (or any text), the value in the Amount column is set based on the result of the formula.
    See the next points for how to use it:
    • In double-entry accounting, the result of the formula must always be a positive number.
    • In the income and expense accounting, if the result is positive, it will be considered as an revenue, if negative as a cost.
  • FormulaBegin
    The text that you insert in this column is inserted before the text used in the Formula and then used for calculation.
    The main use of the FormulaBegin to insert a  variable setting like "A=", in the Formula you then only insert the value, so that it easier to modify.
  • Amount (in base currency)
    The amount that is used for the forecast.
    In the event in the row includes a repetition, the amount of the first transaction is indicated. The amounts of subsequent repetitions are visible in the account card.
    The amount is automatically calculated in the following cases:
    • If you entered a value in the Quantity or Unit price columns, the amount is calculated based on the contents of these two columns.
      • In double-entry accounting, the result is converted into a positive value.
      • In the income and expense accounting, if the result is positive, it will be considered as an revenue, if negative as a cost.
    • If a formula has been entered, the amount will be the result of the formula.
      The formula also has priority over quantity and price.
  • Total
    This is the total of the repeated row amounts that fall within the Accounting and Forecasting Period set in the file properties.
    If there is no date or if the start or end date are outside of the accounting period, this column will remain empty.

Columns in income and expense accounting

For the Cash Manager and the Income and Expense Accounting, the amounts are indicated are follows:

  • Income and Expense Columns 
    The budget amounts are entered in the income and expense columns.
  • Use of Quantity, Price and Formula columns
    When the program automatically calculates the amount based on the Quantity, Price or Formula columns, the result will be entered in the Revenue column if it is positive, and in the Expense column if it is negative.
    In the Quantity and Price columns you can indicate a positive or negative value.

Columns in multi-currency accounting

  • Amount in account currency 
    Is the amount in the currency of the transaction account (see multi-currency transactions).
    This amount is used to calculate the basic currency value at the indicated exchange rate.
    If there is a formula, the value is the result of the formula calculation .
    If the row includes a repetition, the amount of the first transaction is indicated.
  • Account currency amount formula
    calculation formula can be entered.
    If the line includes a repetition, the amount of the first transaction is indicated. The amounts of subsequent repetitions are visible in the account card.
  • Exchange rate
    It is the exchange rate that is applied to convert the amount into the account currency into the base currency.
  • Total amount in the account currency
    Is the total of the amounts of the repeated lines in the currency of the account, whose date falls within the accounting period defined in the file properties
    If there is no date or if the start or end date is outside the accounting period, this column remains empty.

See also: Tutorial File Budget Formulas For Multi-Currency Financial Planning

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 | LinkedIn | Email