Generic accounting reports based on mis?

[Martronic-SA]

Is there existing modules or any plan to create a module that would install two basic reports, the Profit & Loss and Bilan based on the default type of account (like the module accout_reports does)? Thanks

[sbidoul]

I not aware of such a plan, although I've had this on the back on my mind for a while.

It should be a relatively simple data module with expressions such as -balp[('user_type_id', '=', ref('...').id)]

[Martronic-SA]

@sbidoul Exactly what I was thinkig. Any idea for the name of the module? (account_mis_reports ?) the reports to create? (P&L, BS, Cash flow?) in which folder to add it (here or in account-financial-reporting?)

[sbidoul]

Any idea for the name of the module?

mis_builder_account_generic_report ?

account-financial-reporting would be a natural place I guess.

Or they could go in https://github.com/OCA/account-financial-reporting/tree/12.0/account_financial_report, although adding mis_builder as a dependency of that module might be controversial.

[sbidoul]

the reports to create? (P&L, BS, Cash flow?)

P&L and BS definitely. Cash flow I don't know myself how generic it can be. A flat trial balance is also easy to add with 5 subkpis (bali[], crd[], deb[], balp[], bale[]) and account detail expansion enabled:

(a grouped trial balance using account groups is not possible with mis builder at the moment).

[pedrobaeza]

But is this something that someone is going to use in practice instead of their localized P&L? If not, better to provide that templates as demo data of the main module.

[Martronic-SA]

We have clients with many sub companies in the world and they are happy to have one common P&L / BS report even if it's not as precise as the localized ones, but at least they are sure to have everything and not an account that is not showing up because of a missing tag or something like that... They ca also use the "generic" report as base for comparisions with localized P&L and BS.

[Martronic-SA]

Here is the first release : https://github.com/OCA/mis-builder/pull/207

[github-actions[bot]]

There hasn't been any activity on this issue in the past 6 months, so it has been marked as stale and it will be closed automatically if no further activity occurs in the next 30 days. If you want this issue to never become stale, please ask a PSC member to apply the "no stale" label.

[MarcoCalcagni]

Is there existing modules or any plan to create a module that would install two basic reports, the Profit & Loss and Bilan based on the default type of account (like the module accout_reports does)? Thanks

Hi, sorry for so late but you can have a look to this module in the Italian localisation. https://github.com/OCA/l10n-italy/tree/14.0/l10n_it_mis_reports_pl_bs

is in the Italian repo because the report is on the Italian chart of accounts .

[norlinhenrik]

I have made generic accounting reports (PL & BS) based on mis_builder, for 14.0 and 17.0.