103.15

v 12.0 Third Party 192
Live Preview
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Invoicing (account)
Lines of code 12268
Technical Name ks_dynamic_financial_report
LicenseOPL-1
Websitehttps://www.ksolves.com/
Versions 17.0 15.0 16.0 13.0 12.0 14.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Invoicing (account)
Lines of code 12268
Technical Name ks_dynamic_financial_report
LicenseOPL-1
Websitehttps://www.ksolves.com/
Versions 17.0 15.0 16.0 13.0 12.0 14.0
ksolves-logo
Community Odoo.sh

Dynamic Financial Report

With a comprehensive list of financial reports, Dynamic Financial Report has carved out its niche among the elite bookkeeping and accounting solutions, and businesses are in love with its simplicity! It provides a crystal clear visualization of the financial performance of a business by generating precise reports such as Tax Reports, Cash Flow Statements, Balance Sheets, and much more.

Hot Features

  • Robust Overview Of Various Reports
    One can easily view every aspect of a report to detect small shortcomings, understand the financial standing of the business and present them to relevant people.
  • Differentiate Feature
    The differentiate filter helps in comparing or tallying a report with the previous reports of varying periods(month, quarter, etc). It will let you compare the results to visualize where the business is headed for..
  • Dynamic Financial Report-
    It is a feature that helps you to create and customize your own reports with ease. You can create a report in a new format and incorporate it with an existing parent report.
  • Send Email(to user)
    Using this feature, the user can send any report that is required to him/her email address. The pdf of that report is automatically generated and sent.
DEMO AVAILABLE
FREE 90 DAYS SUPPORT

User Guide

Installation

Once you have downloaded the Dynamic Financial Report app from the Odoo app store, you will get a folder name “ks_dynamic_financial_report”.

1. Copy and paste it to your Add-ons folder.

2. Click on Update Apps list from the menu and now Dynamic Financial Report App will appear in App list.

3. Go to Apps menu, search for 'Dynamic Financial Report' and click Install button.

4. You are ready for use Dynamic Financial Report

Various Types Of Reports / Available Filters

You Can find the options for the reports in the "Reporting" menu present in the top middle of the navigation bar
  • Profit and loss Report
  • Balance Sheet Report
  • Executive Summary Report
  • Cash and Flow Report
  • General Ledger Report
  • Consolidate Journal Report
  • Age Receivable Report
  • Age Payable Report
  • Trial Balance Report
  • Tax Report

Available Filters

  • Date Filter: It is possible to filter the report based on various date filter options- Today, End Of Last Month, End Of Last Quarter, End Of Last Financial Year, and Custom date range.
  • Differentiate Filter: The report can also be compared with the previous period or a custom period(defined by the user)
  • Journal Filter: The Journals All button provides the option to filter the report based on Bank, Cash, Cash Basis Taxes, Customer Invoices, Exchange Difference, Miscellaneous Operations, Vendor Bills.
  • Analytic Filter: Analytic accounting helps you to analyse costs and revenues whatever the use case. You can sell or purchase services, track time or analyse the production performance through analytical filters
  • Partner Filter : One can enter the name of the partner in the Partner Search button and the corresponding report will be displayed..
  • Account Type Filter: The Account button allows the user to select from Payable and Receivable



Profit and Loss Report

The Profit And Loss Report displays the Gross Profit, Total Income, Net Profit reports of the company.
  • It is possible to filter the report from the As Of Date button based on various date filter options- Today, End Of Last Month, End Of Last Quarter, End Of Last Financial Year, and Custom date range.
  • The report can also be compared with the previous period or a custom period(defined by the user)
  • The Journals All button provides the option to filter the report based on Bank, Cash, Cash Basis Taxes, Customer Invoices, Exchange Difference, Miscellaneous Operations, Vendor Bills.

Balance Sheet Report

The Balance Sheet report displays the assets, liabilities, and equities of the company. The Profit And Loss Report displays the Gross Profit, Total Income, Net Profit reports of the company.
  • It is possible to filter the report from the As Of Date button based on various date filter options- Today, End Of Last Month, End Of Last Quarter, End Of Last Financial Year, and Custom date range.
  • The report can also be compared with the previous period or a custom period(defined by the user)
  • The Journals All button provides the option to filter the report based on Bank, Cash, Cash Basis Taxes, Customer Invoices, Exchange Difference, Miscellaneous Operations, Vendor Bills.

Executive Summary Report

The Executive Summary Report displays an overview of the major points of a larger report. It provides a glimpse of the profitability, position and performance of the business.
  • It is possible to filter the report from the As Of Date button based on various date filter options- Today, End Of Last Month, End Of Last Quarter, End Of Last Financial Year, and Custom date range.
  • The report can also be compared with the previous period or a custom period(defined by the user)

Cash Flow Statement Report

The Cash Flow statement is a financial statement that summarizes the amount of cash and cash equivalents entering and leaving a company.
  • It is possible to filter the report from the As Of Date button based on various date filter options- Today, End Of Last Month, End Of Last Quarter, End Of Last Financial Year, and Custom date range.
  • The Journals All button provides the option to filter the report based on Bank, Cash, Cash Basis Taxes, Customer Invoices, Exchange Difference, Miscellaneous Operations, Vendor Bills.

General Ledger Report

The General Ledger report shows you all the financial activity for your business. These accounts are categories that show you where your money is going or coming
  • It is possible to filter the report from the As Of Date button based on various date filter options- Today, End Of Last Month, End Of Last Quarter, End Of Last Financial Year, and Custom date range.
  • The Journals All button provides the option to filter the report based on Bank, Cash, Cash Basis Taxes, Customer Invoices, Exchange Difference, Miscellaneous Operations, Vendor Bills.

Partner Ledger Report

The Partner Ledger report displays the financial activity of a business with its partners.
  • It is possible to filter the report from the As Of Date button based on various date filter options- Today, End Of Last Month, End Of Last Quarter, End Of Last Financial Year, and Custom date range
  • One can enter the name of the partner in the Partner Search button and the corresponding report will be displayed.
  • The Account button allows the user to select from Payable and Receivable

Age Receivable Report

The Age Receivable report categorizes and displays the amount receivable by a business based on the length of time an invoice is outstanding.
  • It is possible to filter the report from the As Of Date button based on various date filter options- Today, End Of Last Month, End Of Last Quarter, End Of Last Financial Year, and Custom date range.
  • One can enter the name of the partner in the Partner Search button and the corresponding report will be displayed.

Age Payable Report

The Aged Payables report displays the total amount of business that it owes to its suppliers based on the number of days that have transpired since the invoice date
  • It is possible to filter the report from the As Of Date button based on various date filter options- Today, End Of Last Month, End Of Last Quarter, End Of Last Financial Year, and Custom date range.
  • One can enter the name of the partner in the Partner Search button and the corresponding report will be displayed.

Trial Balance Report

The Trial Balance report displays the closing balances of the general ledger accounts. The balance of all ledgers are compiled into debit and credit account column totals that are equal.:
  • It is possible to filter the report from the As Of Date button based on various date filter options- Today, End Of Last Month, End Of Last Quarter, End Of Last Financial Year, and Custom date range.
  • The Journals All button provides the option to filter the report based on Bank, Cash, Cash Basis Taxes, Customer Invoices, Exchange Difference, Miscellaneous Operations, Vendor Bills.

Consolidate Report

The Consolidate Journal report displays the credit and debit amounts for all of the subsidiary journal lines of a business that were consolidated into accounts.
  • It is possible to filter the report from the As Of Date button based on various date filter options- Today, End Of Last Month, End Of Last Quarter, End Of Last Financial Year, and Custom date range.
  • The Journals All button provides the option to filter the report based on Bank, Cash, Cash Basis Taxes, Customer Invoices, Exchange Difference, Miscellaneous Operations, Vendor Bills.

Tax Report

The Tax Report shows tax incurred on various sales and purchases of the business by categorizing them based on various tax slabs/brackets. The report provides a great brief to anyone who is looking for a quick overview.
  • It is possible to filter the report based on various date filter options- Today, End Of Last Month, End Of Last Quarter, End Of Last Financial Year, and Custom date range.
  • The report can also be compared with the previous period or a custom period(defined by the user)

Functionalities

The computed reports can be exported, printed, and emailed based on the user’s preference. On the top left corner, there are buttons for Print(Pdf), Export(XLSX), and Send Email.
  • Print(Pdf):- To print pdf of existing report.
  • Export(XLSX):- To Print Excel report of existing report
  • Send Email:- To send the pdf attached mail to the user for current report

Dynamically Creating Financial Reports

With the help of this functionality, you can create reports on your own. To do so, follow these steps:
  • Go to the configuration menu present in the navigation bar. Click on the Dynamic Financial Reports. On clicking, a form is opened.
  • Fill in the fields that are required:
    • Report Name- Provide a name to the report
    • Report Menu- Choose the menu of the report where you wish to see the Report Menu For example If you choose Accounting->Reporting->Generic Statements then the name of the report will be shown in the Reporting Section of the Navigation Bar.
    • Parent- If you want to keep the report in the existing reports menu, then you can accordingly choose the Type. There are 5 types to create the reports
      • Total- if we choose Total as a type then our report will be shown or created as a sum of the records
      • Subtraction- If you choose subtraction as a type, then the report will be created which displays the difference of the records.
      • Accounts- If you choose Accounts as a type, then the report will be created according to the selected accounts
      • Account Type- If you choose Account type as a type then, the report will created according to the selected accounts type.
      • Report Value- If you choose Report Value as a type then the report will be made on the basis of values like operating income , assets etc.

Our Releases

12th March, 2024

Latest Release 12.0.1.2.1

Enhancement - Working of Excel report in Other languages.

Improvement - Sign issue in profit and loss pdf and xlsx report.

28th September, 2022

Release 12.0.1.2.0

Feature - Add new move line to get sales margin in executive summary report.

16th September, 2022

Release 12.0.1.1.3

Improvement - Closing bank balance data in executive summary report.

Improvement - Partner ledger data rendering.

17th August, 2022

Release 12.0.1.1.2

Improvement - Receivable and payable data in executive summary report.

Improvement - Genaral ledger data rendering.

1st July, 2022

Release 12.0.1.1.1

Improvement - Date when we apply comparison.

Improvement - Addition of equity and liabilities in comparison case.

Improvement - Remove currency from pdf in executive summary report.

24th June, 2022

Release 12.0.1.1.0

Improvement - Executive summary report with comparison period data.

17th June, 2022

Release 12.0.1.0.9

Improvement - Export button functionality.

Imrovement - Working of sign in balance sheet.

Enhancement - Working of journal item in balance sheet report.

Enhancement - Deduct cost of revenue from expense in excecutive summary report.

Enhancement - Average debtors days and Average creditor days in balance sheet report.

Enahncement - Working of closing bank balance data.

18th May, 2022

Release 12.0.1.0.8

Fix - Balance sheet and Profit and Loss Report data issue with the previous period comparison.

28th April, 2022

Release 12.0.1.0.7

Enhancement - Multi Company Feature.

21st April, 2022

Release 12.0.1.0.6

Enhancement - Added sum of EQUITY and LIABILITIES in the balance sheet report.

8th April, 2022

Release 12.0.1.0.5

Minor code changes related to the balance sheet report.

Minor UI changes related to the trial balance report.

25rd March, 2022

Release 12.0.1.0.4

Improvement - Added a configuration to manage the negative sign on the Balance sheet.

Fix - Date filter issue for the single date range, showing the data based on the last date of the selected filter in the single date range filter option.

23rd March, 2022

Release 12.0.1.0.3

Fix - Options filter drop-down issue.

1st March, 2022

Release 12.0.1.0.2

Improvement- Provide the configuration to manage the initial balance for income/expense account in the trial balance report.
Improvement - Provide the configuration to manage the initial balance in the partner/general ledger report.

30th November, 2021

Release 12.0.1.0.1

Fix - Minor code changes in Analytic Tag Filter

Frequently Asked Question

For extra customizations, you can contact us and communicate the exact modifications that you need. We will certainly help you with that.

Yes, we will provide 90 days of free support for any app-related queries. issues and glitches. It starts from the date of purchase.

Dynamic Financial Report is a feature that helps you to create and customize your own reports with ease. You can create a report in a new format and incorporate it with an existing parent report

The app can significantly reduce the burden of businesses of any scale by automatically generating various reports on a click. Whether you are a small business, MSME or a large enterprise, investing in the app will be fruitful.

The differentiate filter will help you to compare or tally a report with the previous ones(different time segments). It will let you compare the results and understand the financial standing of the new report.

Generally, a report only sums up the overall transaction details of various products in a combined fashion. What if you need to get the transaction history(credit/debit details) of a specific product? This is where an analytical account comes in. Using an analytical account, you can check the credit/debit history of a specific product without affecting the details of the original report.

FREE 90 DAYS SUPPORT

Ksolves will provide FREE 90 days support for any doubt, queries, and bug fixing (excluding data recovery) or any type of issues related to this module. This is applicable from the date of purchase.

Note:

Extensively Tested on Odoo Vanilla with Ubuntu OS

Ksolves Odoo Services

ksolves
support
Odoo Implementation
apps
Odoo Community Apps
support2
Odoo Support & Maintenance
custom
Odoo Customization
integrated
Odoo Integration Services
develop
Odoo Developer Outsourcing
sales@ksolves.com
+91 120-4299799‬
Odoo Proprietary License v1.0

This software and associated files (the "Software") may only be used (executed,
modified, executed after modifications) if you have purchased a valid license
from the authors, typically via Odoo Apps, or if you have received a written
agreement from the authors of the Software (see the COPYRIGHT file).

You may develop Odoo modules that use the Software as a library (typically
by depending on it, importing it and using its resources), but without copying
any source code or material from the Software. You may distribute those
modules under the license of your choice, provided that this license is
compatible with the terms of the Odoo Proprietary License (For example:
LGPL, MIT, or proprietary licenses similar to this one).

It is forbidden to publish, distribute, sublicense, or sell copies of the Software
or modified copies of the Software.

The above copyright notice and this permission notice must be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM,
DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
DEALINGS IN THE SOFTWARE.

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.
There are no ratings yet!
Is it compatible with Odoo 11?
by
Soufiane Taouil
on 1/17/24, 10:22 AM


Re: Is it compatible with Odoo 11?
by
Ksolves
on 1/24/24, 11:22 AM Author

Hello Soufiane,

Thanks for reaching out to us,

Currently, the Dynamic Financial Report is only available from Odoo version 12.

If case you will be required for Odoo version 11, please feel free to reach out to us at odoo.helpdesk@ksolves.in

Thanks


Great app to build visual dahsboard
by
camille.arsenault@arseno.qc.ca
on 3/29/23, 11:35 AM

Great app to build visual and dynamic dashboards and is easy to learn and use. Customer service is very responsive and quick if you need any help or have questions. They even offre free dashboard templates when you buy the V15 version. 

Highly recommend!

Re: Great app to build visual dahsboard
by
Ksolves
on 3/29/23, 12:54 PM Author

Hello Camille,

Thanks for sharing the encouraging feedback. 

We also look forward to a long-term association & serve you with future assignments up to the mark. 

Regards, 

Team Ksolves!