Ir al contenido
Menú
Se marcó esta pregunta

Every customer need Cashflow to track their In-Out bank operations.

By default Odoo Enterprise provides the report. But is it work correct?

I see it is not. Let me explain the main issues:

1. Cash Flow is hard coded without any reasons. 

  • a user can't add any new lines
  • a user can't drill-down to accounting move lines or other details
  • a user can't check report's settings if he need to find the unexplained differences
  • a user must understand how the report works with Tags/Account Types.

2. Out-of-the-box CF provides with the wrong results.

3. Cash Flow works as Cash flows from unclassified activities just a sum of account move lines without any Tags. This is a shame. Why do I can see Expenses/Incomes accounts in the Cash Flow? Does Odoo Master of Accounting know the difference CF and PL?

4. Accrual report not Cash Based.

With Odoo you have to reconcile all bank operations if you need Cash Flow. And this is a problem also. Invoices and Bills are not created at day of transaction.

Cash Based method is more clear for customers: you have just upload the bank statement and set accounts. Then Cash flow is ready.

Avatar
Descartar

Hey Alexander, did you ever get this figured out? We're trying to implement Odoo for accounting and just came across the cash flow statement issue.

Autor Mejor respuesta

We create our own report for Cash Flow movement.

The basic idea is to calculate direct incomes and outcomes to/from bank account (type 'Bank and Cash'). Additionally we use analytic accounts for grouping operations into 3 groups: Operational Activities, Financial Activities, Investments. 

The reason we did so is that native Odoo report works with non-direct method and calculates changes in accounts with type 'Account Receivables' and 'Account Payables'. This is OK for large corporations. But for SMB it gives nothing.

Additionally we added 'USD' as additional currency for CashFlow Statement instead of 'main currency PLN'.

Avatar
Descartar

Hi Alexander, we have implemented Odoo Accounting starting January. The January CF report still looked +/- accurate, but now for February, there are the strangest figures showing up (i.e. inexistant flows on Share Capital).
Could you elaborate how you created your own report ? Do you export all movements to the spreadsheats and then sort them with the analytical distribution ?
Thanks,
Johann

Mejor respuesta

Did anyone figure this out? Do you have to rebuild this from scratch as a custom report or is it possible to get their default report to work?

This is one of the 3 fundamental financial statements and form what I can see it's completly broken. 

Cash flow from operations has to start with net income, then add or subtract changes in working capital. 

I can't make anything match because the net income from my P&L doesn't match the CFS. We're running inventory with everything as consumable, so we're not recording any changes in working capital or inventory, and it's still wrong. 

Avatar
Descartar
Mejor respuesta

To know about What is Cash Flow to Creditors? Formula, Calculation and Interpretation Browse through Ledger Labs' blogs :- https://www.theledgerlabs.com/cash-flow-to-creditors/

Avatar
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
4
jul 23
5245
0
may 23
1282
2
feb 25
504
0
jun 24
616
1
mar 25
2362