Hi everyone,

I’m trying to build a pivot view that shows my cashflow per account, with the months (based on the payment date) on the X-axis and the accounts on the Y-axis. Basically, I’d like to see how much cash goes in and out per account each month, similar to th cashflow statement, but on account basis.

The problem is that all pivot views I’ve found so far use the accounting date instead of the payment date. Since our bank is connected and all transactions are reconciled either to bills/invoices or directly to accounts, I was hoping to use the payment date from the reconciliation instead.

I’m using Odoo 18 Enterprise on Odoo.sh.

Has anyone managed to build something similar?

Or is there maybe a field or model that exposes the payment date I can use for this?

Thanks a lot for your help!