Settings Dialog

In this article

Dialog is accesible:

  • By going to the Extensions menu→Cash Flow Statements and financial RatiosFinancial Reports.
  • By going to the Extensions menu→Cash Flow Statements and financial RatiosSettings.

Set up the groups

The first and most important step is to enter the groups or accounts number you are using in your account table.
Once you enter the groups the report and calculations are all done automatically, except for some specific transactions for the Cash Flow Statement.

  • Groups must be entered manually
  • Groups must be separated by a semi-colon ';'
  • Both groups and accounts can be entered
  • It is important to make sure that you include elements that exist in your chart of accounts, if are entered groups or accounts that do not exist in your chart of accounts, a message will be displayed on the row of the grouping concerned, returning those elements for which a match was not found in the chart of accounts. Once corrected, you only need to run the dialogue again and the message will disappear.
  • By default, the groups within the dialogue refer to the Swiss SME chart of accounts, and it is possible to return to the base scenario by clicking the Restore Defaults button. Beware, however, that in this way the customisations made will be lost, and will be replaced with the default values. 

banana setting dialog group of accounts

All the necessary elements must be inserted within the different groupings defined in the dialogue (Liquidity, Fixed Asset,Owned base capital,...).

Assets

They show the total employment of a company, so the investments to which the company has allocated
the means found in carrying out its activity.

  •  Liquidity: Must include groups or accounts that define liquidity in the company, such as cash or bank
  • Credits: Must include groups or accounts within which are recorded all the operations
    concerning money due to buyers who didn’t paid yet for their purchases
  •  Stocks: Must include groups or accounts with all goods for resale in the ordinary course of business.
  • Fixed assets: Must include groups or accounts containing fixed assets elements, as:
    •  Buildings
    • Computer equipment
    • Computer software
    • Furniture and fixtures
    • Intangible assets
    • Land
    • Leasehold improvements
    • Machinery
    • Vehicles

Liabilities and Equity

Shows where company's resources come from. In general, the funds at the company's disposal are
classified in a way to distinguish between own funds (which flow into equity) and those from third parties.

  • Short-term debt capital: Must include groups or accounts representing the company commitments that must be fulfilled, without any particular cancellation, in the current year.
  • Long term debt capital: Must include groups or accounts containing that kind of capital that the company can have at its disposal for several years, on a fixed basis, and that can usually only be withdrawn within a set time limit.
  • Own Base capital: Must include groups or accounts those group referring to the company's own capital.
  • Reserves and Profits: Must include groups or accounts within which are recorded the amounts to be paid to reserves or designated as profits.

Revenues

Indicates what is produced by the company during a financial year. Whether it is an increase in the value of products or semi-finished products in the course of production or services in progress, revenue from the sale of products or services or the increase in the value of fixed assets thanks to own resources, all these heterogeneous factors add up.

  • Sales turnover: Must include groups or accounts within which is recorded what is produced by the company during a financial year. Whether it is an increase in the value of products or semi-finished products in the course of production or services in progress.

Costs

  • Costs of Merchandise and services: Must include those groups or accounts in which all costs relating to goods and services consumed during the annual financial year are recorded.
  • Personnel Costs: Must include all those accounts referring to a cost due to personnel, such as:
    • Salaries
    • Social charges
    • Severance Pay
    • Pension and similar treatment
    • Other costs
  • Different Costs: Must include all other groups or accounts relating to costs during the operating period.
  • Interests: Must include groups or accounts containing the costs of financing sources, such as bank interest payable or interest on loans.
  • Depreciation and Adjustments: Must include groups or accounts where are registered possible revaluations and write-downs of equity investments, as well as of financial fixed assets and securities included in current assets that are not equity investments.
  • Final Result: The group containing the difference between the costs and the revenues at the end of the year.

Average Number of employees

This information is useful for calculating efficiency ratios, enter the average number of employees in the company and find out information such as the average company revenue per employee.

Printing Preferences

To make the Analysis as close as possible to your needs you can set some preferences, and choose about the details of printing and analysis

banana setting dialog preferences

Printing Details

  • Page header: Include the header in the report, the header is composed with the information retrieved from the properties of the file.
  • Logo: Choose whether to include your company logo in the report. for information on how to set up a logo visit this Logo set up page.
  • Background color of headers: Choose the colors for the table headings
  • Text color of headers: Choose the color for the texts in the table headings
  • Report Without colors: Check the box for no colours in the report.

Analysis Details

  • Number of previous years: Set the number of previous accounts (years) to be included in the analysis, which will be added to the current year and the Budget (if present and included).If you don't know how to set the previous year to a file, go to “File→File and Accounting Properties→Options Tab.
  • Number of decimals: Choose how many numbers after the decimal point you want for the digits in the report, if you don't want to have decimals you only need to insert a zero 0.
  • Include Budget: If you are using the Budget table for your financial planning, you have the possibility to include it in the analysis.
  • Include Budget to date column: Include the columns showing the values of the budget up to that day, compare the values with those of the year-to-date.
  • Include Current year projection column: You can include the projection for the current year. The programme uses the values in the budget table to return what could be the values at the end of the year.
  • Current Date: Insert the current date. If no date is entered, the date of the day is taken automatically
  • Include DuPont Analysis: Choose whether to include the Dupont Analysis
  • Include Control Sums: Choose whether to include the table with the control sums, useful to inform in case of errors on the totals (assets/liabilities, operating result).
  • Show the formulas column: Choose whether to show the column with the calculation formulas.
  • Show the acronym column: Decide whether or not to show the acronym column, which is useful for identifying the elements used for formulas.

The columns of acronyms and formulas are complementary, that's beacuse the acronym column is useful to uderstand how the formulas are composed. if you dont need these columns, just uncheck the checkbox.

Set the benchmarks

Benchmarking is a method of assessing an organisation's competences based on comparison with the "best
in class", whatever sector it belongs to. So the Benchmark is a key performance indicator on the basis of
which a company assesses its performance with regarding to products, services and business processes.

You can customise these values depending on your company:

  • Sector  
  • Size
  • Targets

These values are only representative, which means that the figures you enter are not used in the analysis but are shown as they are. In the report, they are displayed in the Benchmark column, in the indexes tables, so that you can quickly assess the situation.

banana setting dialog benchmarks

It's also possible to call the dialog from the opened report and change the parameters. The values of the
analysis will be updated automatically. 

help_id
financialStatementAnalysis

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