I am creating a Dashboard with financial KPIs in Odoo 16, and to do the KPIs calculations (financial ratios) I will need to link the information from the Balance Sheet to the spreadsheet I am using in Odoo, this way I will be able to calculate the ratios.
I am not able to link the Balance Sheet from the Accounting module to the spreadsheet I am using, I hope there is a simple way to just feed the historial accounting information to perform the financial ratio analysis.