Skip to Content
This question has been flagged
accrualsenterprisecashflowreportsAccounting
5 Replies
12436 Views
Avatar
Alexander Koltsov

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
Discard
Robbie

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.

Avatar
Alexander Koltsov
Author Best Answer

We create our own report for Cash Flow Statement Report Direct.

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.

How the CashFlow Statement Works now:

  • The new Cash Flow (Direct Method) report works alongside the standard one.
  • You can define your own list of Cash Flow Items and group them as Operating, Financial, Investing, or Other.
  • Each bank transaction can be labeled with a specific Cash Flow Item — for example, “Receipts from Customers” and “Refunds from Vendors” are both incoming payments but represent completely different flows and must be tracked separately.
  • Unlabeled transactions appear in the “Undefined” section, helping you identify gaps in classification.
  • A “Check Result” line compares opening/closing balances with the totals per group to ensure the report is balanced.
  • Reconciliation models are supported to automate transaction labeling.

See more.

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 alternative and additional currency for CashFlow Statement instead of 'main currency PLN'.

Avatar
Discard
Hoepfner Johann

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

Avatar
john
Best Answer

The Cash Flow Statement in most Enterprise systems automatically categorizes transactions into three sections — Operating, Investing, and Financing activities. It pulls data directly from your accounting records, showing how cash moves in and out of the business. This helps you understand liquidity, assess financial health, and track how operational profits convert into actual cash.

Avatar
Discard
Avatar
Robbie
Best Answer

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
Discard
Kiko Cruz

I was able to make the default CFS report work (v18.4e of Odoo Online). I made my answer to a similar post: https://www.odoo.com/forum/help-1/seting-up-cashflow-statement-in-odoo-using-tags-in-accounts-209172

Avatar
Grace Tuner
Best Answer

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
Discard
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,

Please go through these blogs, hopes it helps to understand the functionality of cashflow statements in odoo 16.

https://www.cybrosys.com/blog/what-is-cash-flow-statement-in-odoo-16-accounting#:~:text=Thus%20in%20the%20cash%20flow,cash%20equivalents%2C%20closing%20balance'.

https://www.cybrosys.com/blog/what-is-advanced-cash-flow-statements-in-odoo-16

Hope it helps

Avatar
Discard
Related Posts Replies Views Activity
Is is possible to configure/customize the cash flow statement?
cashflow Accounting
Avatar
Avatar
Avatar
Avatar
4
जुल॰ 23
7080
How to understand this help field value in accounting reports for carryover?
reports Accounting
Avatar
0
मई 23
2679
I can not open "Payments" in "Clients" menu , from "Accounting" module Solved
enterprise Accounting odoo 17
Avatar
Avatar
Avatar
2
जून 25
1860
In Odoo Online - Customize Reports
reports Accounting odoo17
Avatar
0
जून 24
1970
How can I view accounting reports in a currency different from the main currency of my database? Solved
currency reports Accounting Quickstart
Avatar
1
नव॰ 25
1217