Add features for reporting

The features in a feature set determine the order of the reporting overview. A feature in a feature set represents a single line in the reporting overview. You can add the features to the feature set.

A new feature set automatically gets three features:

  • A1, Assets
  • P1, Liabilities
  • V1, Result

If you delete or add the features with check codes 2, 3 and 4, Profit displays a message. Profit uses these check codes in the default balance sheet (assets and liabilities side) and in the profit and loss account. These check codes can only occur once in a feature set; you cannot add or delete them. If you add new features, then the features that were automatically set will check them. These are the parent features.

Note:

If you only want to use balance sheet (assets and liabilities) and profit and loss account in the reporting, you do not have to indicate any extra check for the other features. This is done automatically.

The Assets group and Liabilities group features always work in combination with a second feature.

Example:

If you specify the 'Assets' type for a feature, the amount is always shown on the assets side of your report. If you also specify a second feature of the 'Liabilities' type, a debit amount is on the assets side of your report and a credit amount on the liabilities side.

Example:

You can place the VAT accounts in the 'Short-term debts' feature to which you link the feature type Liabilities group. In the Feature 2 field, select a feature that is linked to the Assets group feature type, for example, ‘Receivables and accrued assets'. In this way, Profit first totals up all amounts from the VAT accounts and then determines whether the total amount is debit or credit. If the total amount is a credit amount, then it will be on the liabilities side on the 'Short-term debts' feature. If the total amount is a debit amount, then it will be on the assets side on the 'Claims and accrued income' feature.

To add features for reporting:

  1. Go to: Financial / Reporting / Configuration / Feature set
  2. Open the properties of the feature set.
  3. Go to the tab: Features.
  4. Click on: New.
  5. Select Kind of feature:
    • Activa: Specified for each ledger account. If the ledger account amount is a credit amount, then it will be on the assets side as a negative amount.
    • Passiva: Specified for each ledger account. If the ledger account amount is a debit amount, then it will be on the liabilities side as a negative amount.
    • Opbrengsten: The total amount of the ledger accounts is recorded as revenue in the Profit & Loss account. If the total amount of the feature is debit, then this feature has a negative amount.
    • Kosten: The total amount of the ledger accounts is recorded as costs in the Profit & Loss account. If the total amount of the feature is credit, then this feature has a negative amount.
    • Activa groep: In an asset group, the amounts of the ledger accounts are totalled up, then the system determines whether the total amount is debit or credit. A debit amount is shown on the assets side and a credit amount is shown on the liabilities side (on the feature selected in the Feature 2 field).
    • Passiva groep: In a liability group, the amounts of the ledger accounts are totalled up, then the system determines whether the total amount is debit or credit. A credit amount is shown on the liabilities side and a debit amount is shown on the assets side (on the feature selected in the Feature 2 field).
  6. Select Feature 2.
  7. Select Check type.

    Profit can check whether you have configured the features correctly:

    • Geen controle
    • Controle activazijde balans: when linking ledger accounts to this feature, the system checks whether the linked ledger accounts are of the Assets type (Account type = 1 Assets).
    • Controle passivazijde balans: when linking ledger accounts to this feature, the system checks whether the linked ledger accounts are of the Liabilities type (Account type = 2 Liabilities).
    • Controle resultatenrekening: when linking ledger accounts to this feature, the system checks whether the linked ledger accounts are of the Costs or Revenue types (Account type = 3 Revenue or Account type = 4 Costs).
    • Controle compleetheid: Profit checks that all ledger accounts in the ledger set are linked to a feature.
    • Controle overlapping: Profit checks that there are no ledger accounts present which are linked to multiple features.
    • Controle compleetheid + overlapping: if you select this option, the system checks that all ledger accounts in the ledger set are linked to a feature and that there are no ledger accounts present which are linked to multiple features.
  8. In Code percentage, enter a code if you want to express the feature as a percentage of another feature. Configure this as follows:
    • For features you want to set to 100%, enter code 10, 20, 30, 40, 50, 60, 70, 80 or 90.
    • For features you want to express as a percentage of another feature, enter code 01, 02, 03, 04, 05, 06, 07, 08 or 09.
    • Features with code 01 have a percentage of the feature with code 10, and so on.

    Example:

    You have added the following features:

  • A100 Fixed assets
  • A110 Intangible fixed assets
  • A120 Tangible fixed assets
  • A130 Financial fixed assets

    If you want to express three features ('A110 Intangible fixed assets', 'A120 Tangible fixed assets' and 'A130 Financial fixed assets') as a percentage of feature 'A100 Fixed Assets', you enter the percentage code 10 for the 'A100 Fixed Assets' feature. Enter 01 for the other three features.

  1. In Deviating order, enter a sequence.

    You can enter a deviating order for a feature. The encoding for the deviating order is numeric: the order is 0, 1, 2, etc.

  2. Select Split features.

    You can split the features for the reporting. You enter the specifications and amounts for the feature split when generating the reporting. You can choose from:

    • Do not split feature: You cannot split the feature.
    • Feature can be split: You can split the feature.
    • Feature must be split: You must split the feature.
  3. Select the Custom overviews check box.

    You can generate your own custom overviews in the reporting overview. A custom overview is made up of one or more features for which this check box is selected. You can specify the structure of the custom features in the feature structure.

    If you use the balance sheet (assets and liabilities) and profit and loss account reporting, but also use custom overviews, select this check box. You can now use check codes 5, 6 and 7 in the custom overviews.

  4. Click on: Finish.

Directly to

  1. Feature set
  2. Add a feature set
  3. Add features
  4. Copy features