I'm looking to create a customized cash flow statement that automatically pulls data from the Odoo database.

However, when using Odoo Spreadsheets, I'm facing limitations because I can't fully customize the information I want to display. Ideally, I’d like to include my sales along with their due dates, my expenses and their due dates, etc. But it’s not working, as I can't access the necessary data directly from Odoo's database. The built-in Odoo formulas (e.g., =odoo.balance(...)) don’t allow me to retrieve all the information I need.

Could this be due to a lack of available formulas?

Has anyone encountered this issue before?

Could someone please guide me on the right approach to achieve this?

Andy Benhamou