Budget table columns

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. Normally you would use your own account numbers.

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.2015 the next date will be 29.2.2016.
        • "5YE" every three years, but at the end of the month.
          If the date is 28.2.2015 the next date will be 29.2.2020.
    • 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.
    • 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
      A description referring to the quantity, for example: m2, ton, pcs.
      • In the income and expense accounting, enter a negative value to have the amount entered in the output column.
    • Formula (in base currency)
      Allows you to enter calculation formulas, in Javascript, plus the programming functions of the Banana Apps.
      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.
    • 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 in the Income and Expense column.

    • Revenue 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

    • Revenue and Expense Columns 
      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
      It is the exchange rate that is applied to convert the amount into the account currency into the base currency.
    • Total currency amount of the account
      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 will remain empty.

This documentation is outdated

The most complete and up-to-date documentation is the one of Banana Accounting Plus: Try it now

Share this article: Twitter | Facebook | LinkedIn | Email