financial-report-configuration-in-odoo.jpg
Blogger_636864898679251912.png
By: Akshay Babu

Financial Report Configuration in Odoo

Financial Report is a statement that discloses an organization's financial state to the management, investors, and the government. Odoo ERP is self-reliant in generating financial reports in the real-time. The basic accounting reports to advanced management reports are also provided in Odoo.

In Odoo community edition, pdf format is used for viewing various reports, but under the enterprise version, it supports both pdf & xls reports. The enterprise version also supports the drill down in reports. 

Some of the reports provided by Odoo are :
1. Journal Audit
2. Partner Ledger
3. General Ledger
4. Trial Balance
5. Balance Sheet
6. Profit & Loss
7. Cash Flow Statement
8. Executive Summary
9. Aged Partner Balance
10. Tax Report
Under Odoo  Enterprise  Edition, one can configure the balance sheet, profit and loss report, cash flow statement & executive summary. But under the community edition, one can only configure, the balance sheet and profit and loss reports. However, new reports can be made in both edition.

Balance Sheet Report
A balance sheet shows the asset, liability & equity of a business organization.

Profit and loss report
The profit and loss report is a report that shows the income and expense of a company during a particular period of time.

Cash Flow Statement
It is a budget summary that demonstrates how the adjustments in monetary record and salary influence the money and money counterparts. It likewise breaks the examination to operating, investing and budgetary exercises.

Executive Summary
Executive summary summarizes the profit & loss, cash flow & balance sheet reports.

Report Configuration in Odoo 11 Community Edition
Under Community Edition,  one can configure the balance sheet and profit & loss report. The stock balance sheet and profit and loss report only show the basic details. However, If necessary a new report can also be generated.

Need for Configuration  
To understand the need for configuration,  let us see a balance sheet report before configuring it.

financial report configuration in odoo

Here, we can see that the balance sheet report shows only the asset, liability and some accounts under liability. There is no information regarding how one have calculated the assets or the liability. As mentioned before a financial report is used to disclose an organization's financial state to the management, investors and the government.

But the above balance sheet report does not show the necessary details. So to make the report more understandable, one needs to configure the report. 

To add each line to a report, one can use the account reports. 

Let’s see more about account reports.

Account Reports
In order to add each line to a report, firstly one should create a new account report. To view, account report go to
Invoicing -> Configuration -> Financial Report -> Account Reports

financial report configuration in odoo

To create a new account report, click on the create button 

financial report configuration in odoo

Report Name:  Name of the report.
Parent: In which report do we wish to see the report that’s been created.
Sequence: Where on parent report we wish to see the new report.
Financial Report Styles: Reports format style can be set up here.

Sign on Reports
I. Preserve Balance Sign
For accounts that are typically more credited than debited and for accounts that we would like to print as positive amount in the report, we shall use this option.
Eg. Income Account. 

II. Reverse Balance sign
For accounts that are typically more debited than credited and for accounts that we would like to print as negative in the report, we shall use this option.
Eg. Expense Account. 

Types
Types are classified into four.

I. View 
The report would be shown in the parent report.
II. Accounts
Accounts selected can be linked to the parent report.
III. Account Types
Account types selected can be added to parent report.
IV. Report value
To get the net value of a report.  

Balance sheet report configuration
By configuring balance sheet report, we are going to add more details to the balance sheet report. In a balance sheet report,  the main details that we need are assets, liability & equity.

Assets
The screenshot  shows only the total asset value in the balance sheet. As you see they do not mention anything about current assets, fixed assets or non-current assets.

financial report configuration in odoo

The current assets also include prepayment, receivables and bank & cash account. 

So one need to add all these details to their report.

One has to add all these report lines for the assets. This is how the asset part has to look like.

Assets
   Current assets
Bank & Cash account
Receivables
Prepayment
Current Asset
   Plus Fixed Assets
   Plus Non Current Assets
 
Account Report for Assets
Report Name: Asset
Parent: Balance Sheet 
Sequence: 1
View: Account Types

Add all the necessary account types to calculate the asset.
 
financial report configuration in odoo

Now under assets, one need current assets, fixed assets & non-current assets. So while creating account reports for current assets, fixed assets & non-current assets, one needs to give parent value as an asset.

Account Report for Current Asset 
Report Name: Current Asset
Parent: Asset 
Sequence: 1
View: Account Types

Add all the necessary account types to calculate the current asset. The sequence is given 1 to list the current asset as first under the asset.

financial report configuration in odoo

Account Report for Fixed Asset 
Report Name: Plus Fixed Asset
Parent: Asset 
Sequence: 2
View: Account Types
Add all the necessary account types to calculate the fixed asset.

financial report configuration in odoo

Account Reports For Non-Current Asset
Report Name: Plus Non-Current Asset
Parent: Asset 
Sequence: 3
View: Account Types

Add all the necessary account types to calculate the non-current asset.

financial report configuration in odoo

Under current assets, one needs to create the account reports for the current asset, bank, and cash, prepayment & receivable.

So while creating the account reports,  keep the parent value as current assets for the current asset, bank, and cash, prepayment & receivable.  
Account Reports For Bank & Cash Account
Report Name: Bank & Cash Account
Parent: Current Asset 
Sequence: 1
View: Account Types
 
Add all the necessary account types for bank & cash account.

financial report configuration in odoo

Account Reports For Recievables
Report Name: Receivables
Parent: Current Asset 
Sequence: 2
View: Account Types
 
Add all the necessary account types for receivables.

financial report configuration in odoo

Account Reports For Prepayment
Report Name:  Prepayment
Parent: Current Asset 
Sequence: 3
View: Account Types
 
Add all the necessary account types for prepayment.

financial report configuration in odoo

Account Report for Current asset 
Report Name: Current asset
Parent: Current Asset 
Sequence: 4
View: Account Types

Add all the necessary account types for current assets.

financial report configuration in odoo

Liabilities 
In the liability part of the balance sheet report, one can only see some accounts. Liability part of the balance sheet should have current liabilities and noncurrent Liabilities. A current liability is calculated by adding current liability & payables account. So they should also be mentioned in the liability part of the balance sheet.  

financial report configuration in odoo
This is how the liability part should look like.

Liabilities
    Current Liabilities
Current liabilities
Payables 
    Non-Current Liabilities

Account Report for Liabilities
Report Name: Liabilities
Parent: Balance Sheet 
Sequence: 2
View: Account Types

Add all the necessary account types for liabilities.

financial report configuration in odoo

Create account reports for current liabilities and non-current liability. As we need those reports to be under liabilities, the parent field should be set as liabilities.

Account Report for Current Liabilities 
Report Name: Current Liabilities
Parent: Liabilities 
Sequence: 1
View: Account Types

Add all the necessary account types for current liabilities.

financial report configuration in odoo

Account Report for Non Current Liabilities 
Report Name: Non Current Liabilities
Parent: Liabilities 
Sequence: 2
View: Account Types

Add all the necessary account types for non-current liabilities.

financial report configuration in odoo

Account Report for Current liability
Report Name: Current liability
Parent: Current Liabilities 
Sequence: 1
View: Account Types

Add all the necessary account types for current liability.

financial report configuration in odoo

Account Report for Payables
Report Name: Payables
Parent: Current Liabilities 
Sequence: 2
View: Account Types

Add all the necessary account types for payables.

financial report configuration in odoo

Equity
If we check the above balance sheet screenshot, one can see that there is no reporting line for equity. So to create a report line let's make an account report for equity.

Account Report For Equity
Report Name: Equity
Parent: Balance Sheet 
Sequence: 3
View: Account Types

Add all the necessary account types for equity.

financial report configuration in odoo

After creating all the account reports necessary for the balance sheet, now go to

Invoicing -> Reporting -> PDF report -> Balance sheet

financial report configuration in odoo

On clicking the print button, the balance sheet would be printed.

financial report configuration in odoo

Here, one can see that all the report lines in the report are the account reports that one has created.
> All the report lines are under the respective parent field given in the account reports.
The report lines are ordered according to the sequence number given in the account report.
> To add a new line to this report, all we have to do is to create a new account report with the parent as a balance sheet.

We can configure the profit and loss report also in this way.

This is how we configure reports in Odoo Community Edition. Now let's see the account configuration in Odoo Enterprise Edition.

Report Configuration in Odoo Enterprise Edition
Under Odoo Enterprise Edition, one can configure the following reports.
1) Balance sheet
2) Profit & Loss
3) Cash Flow Statement
4) Executive Summary

If one wish to add a new line to any report, or if one wants to create a new report, follow the following steps. 

Step 1: Activate Developer Mode
Go to Settings -> activate developer mode

financial report configuration in odoo

Step 2: Open Financial Reports
Go to Accounting -> Configuration -> Financial Report

financial report configuration in odoo

> To create a new report, click on the create button.
> If we want to configure an existing report, click on the report that we want to configure (Let's take the balance sheet for example)

Here we are going to configure the balance sheet, so click on the balance sheet.

Step 3: Open Balance Sheet

financial report configuration in odoo

We can configure the balance sheet from the window shown above.

financial report configuration in odoo

Based on Date Range: specify if the report uses the single date or range of dates.
Tax Reports: When checked, automatically filters out journal items that have boolean field ‘tax_eligible’ set to false.

financial report configuration in odoo
Allow comparison: Display comparison filter.
Allow filtering by journals: Display journal filter in the report.
Allow Cash Basis mode: Display options to switch to cash basis mode.
Show unfold all filter: Unfolds all filters in the report.
Enable the hierarchy option: Displays hierarchy options in the report.

To add a line to the existing balance sheet report, one has Report Lines. Report Lines are similar to account reports in Community Edition.

financial report configuration in odoo

To add a new report line click on ‘add a line’.

Step 4: Click on Add a Line

financial report configuration in odoo

Now let's add a line, ‘Liability + equity’ in the report. To add, one needs to fill details in creating lines. 

financial report configuration in odoo

Section Name: Name on report line (Liability +Equity)
Code: Report Line code(LE)
Sequence: Where on the report would this line be displayed(4)
Parent: Does this report line belongs to some other report.

financial report configuration in odoo

Formula:  Formula for computing the report line. (Balance =CL balance +EQ Balance)
Domain:  Domain of report line.
Group By:  How the report line should be grouped.
Special date changer: One can specify the date for the report line.
financial report configuration in odoo

The cosmetic part is used for styling that reports line. We have various options for styling the report line.

financial report configuration in odoo

If one needs to add a child for the report line, that can also be done here. Make sure to add the correct parent field for the child line.  

financial report configuration in odoo

Now after saving the window go to Accounting -> Reporting -> Balance sheet

financial report configuration in odoo

> In the above report,  One can see that Liability +Equity line has been added.
> Similarly one can configure profit & loss, cash flow statement & executive summary in the same way. 

This is how we configure financial reports in Odoo.

Cybrosys is an exponent in Odoo customization and has crafted several accounting modules like PDC Management, Payment Receipt, Manual Bank Reconciliation, Account Journal Reports, PDC Payment Report, Tax invoice Report and more.

You can check our Odoo apps via clicking the link: Financial reports in Odoo




Comments

0


Leave a comment

 
Calicut

Cybrosys Technologies Pvt. Ltd.
Neospace, Kinfra Techno Park
Kakkancherry
Kerala, India - 673635

London

Cybrosys Limited
Alpha House, 100 Borough High Street,
London, Greater London,
SE1 1LB, United Kingdom

Kochi

Cybrosys Technologies Pvt. Ltd.
1st Floor, Thapasya Building,
Infopark, Kakkanad,
Kochi, India - 682030.

Bangalore

Cybrosys Techno Solutions
The Estate, 8th Floor,
Dickenson Road,
Bangalore, India - 560042

Send Us A Message