Most Powerful Open Source ERP

How To Customize Accounting Financial Section

How To showing how to customize and use the correct financial sections for accounts in relation to reporting
  • Last Update:2017-10-03
  • Version:003
  • Language:en

Financial section is used by ERP5 to determine the structure of Income statement (Profit and Loss) and Balance sheet reports. This How To will explain how to configure financial section category and accounts to configure these reports

Table of Contents

Financial Sections Explained

Unlike GAP categories which classify the accounts according to legal obligations and Account Type which will imply specific behavior for accounts ( such as "Receivable accounts have a break down by Organisations in the trial balance" ), the Financial Section category is used to represent a company specific vision of the Profit and Loss and Balance Sheet reports.

Profit & Loss and Balance Sheet reports in ERP5 ( reports from accounting module) are simple reports that can be configured without programming, simply by configuring the financial section category and accounts. The idea is that the report just shows the hierarchy of financial sections and the total balance of all accounts members of the respective category.

The configuration consists of two aspects. First, configure your Financial Section hierarchies, which will later be displayed in your customized financial report (balance sheet, profit and loss); Second, assign each of your Account to a certain Financial Section that you just configured. 

Financial reports default structure

The default erp5 instance has already provided you financial reports with default structure.  For example, Income statement (two column mode / single column mode) and Balance sheet.

Example Income Statement structure ( two column mode )

INCOME EXPENSE
  1. Revenue
    • ...............
  2. Non Operating Income
    • ...............
  3. Interest Income
    • ...............
  1. Operating Expenses
    • ...............
    • Cost of Sales
    • Selling, General and Administrative Expenses
    • Other
  2. Non Operating Expense
    • ...............
  3. Interest Expense
    • ...............

Example Income Statement structure ( single column mode )

Alternatively, the income statement can be configured to appear as only one column, with intermediate totals. 

Profit and Loss
  • Operating
    • Revenue Sales
    • Operating Expenses
      • ...............
      • Cost of Sales
      • Selling, General and Administrative Expenses
      • Other
  • Total Operating
  • Non Operating
    • Non Operating Income
      • ...............
    • Non Operating Expense
      • ...............
  • Total Non Operating
  • Financial
    • Interest Expense
      • ...............
    • Interest Income
      • ...............
  • Total Financial

Example Balance sheet structure

ASSET LIABILITY
A- Long Term Assets
  1. ...............
  2. Fixed Assets
    • ...............
    • Deprecation of Fixed Assets
  3. Intangible Assets
    • ...............
    • Deprecation of Intangible Assets
  4. Financials Assets
    • ...............
    • Deprecation of Financials Assets
B- Current Assets
  1. ...............
  2. Inventories
    • ...............
    • Deprecation of inventories
  3. Trade and Other Receivables
    • ...............
    • Deprecation of Trade and Other Receivables
  4. Cash and Cash Equivalents
A- Equity
  1. ...............
  2. Share Capital
  3. Profit or Loss
B- Long Term Liabilities
  1. ...............
  2. Loans
  3. Others Liabilities
C- Current Liabilities
  1. ...............
  2. Accounts Payable
  3. Other Current Liabilities

Configure your own financial sections

You can directly using the default financial report structure as shown above, or you can start configure your own financial sections. You can start by preparing a spreadsheet for financial section structures, you must follow some rules regarding the id of the categories. 

Default Financial Section Category Spreadsheet

Rules to follow when customizing financial section

  • The first level categories cannot be changed. They must be asset, equity and liability for Balance Sheet, and income and expense for Profit and Loss.
  • To have Profit and Loss displayed in single column mode, store all the hierarchy in income and leave expense empty. Because expense accounts have a negative balance, they will naturally be displayed with a negative sign and the summary levels will calculate income - expense.
  • On balance sheet asset tab, the accumulated deprecation is displayed in a separate column showing the corresponding accumulated deprecation next to each asset category. The categories with id amort will appear in the column for deprecation for their parent category. For example we have asset/fixed_assets for Fixed assets and asset/fixed_assets/amort for deprecation of these fixed assets.
  • equity/net_profit has a special behavior that it will not only show the balance of accounts member of this category, but also calculate profit or loss for current period, by summing all accounts of financial section income and expense.
  • Categories are sorted by alphabetical order of their title, or by their Sort Index (int_index) property.
  • Categories can be translated using erp5_content

Note that dynamic configuration such as “This account is asset if it has a debit balance or liability if it has a debit balance” are not supported by this report. One workaround is to use two accounts and make an adjustment accounting transaction at the end of period.

Once these categories are created, you are ready to assign each of your Accounts to a certain financial section.

Assign Accounts a targeted financial section

Each country have its own Chart of Accounts, and each company will specify its own Accounts according to its business. You can create easily customized Accounts in erp5 Account Module, for each Account, you just need to pick out the targeted financial section you want to assign this Account to. 

Tips: enable Financial Section as a column on account module to make sure you did not forget any of them.

After this step is completed, now you are able to produce your customized balance sheet and profit and loss report. 

Related Articles