Skip ke Konten
Pertanyaan ini telah diberikan tanda
accrualsenterprisecashflowreportsAccounting
5 Replies
12049 Tampilan
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
Buang
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
Penulis Jawaban Terbai

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
Buang
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
Jawaban Terbai

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
Buang
Avatar
Robbie
Jawaban Terbai

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
Buang
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
Jawaban Terbai

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
Buang
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Jawaban Terbai

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
Buang
Post Terkait Replies Tampilan Aktivitas
Is is possible to configure/customize the cash flow statement?
cashflow Accounting
Avatar
Avatar
Avatar
Avatar
4
Jul 23
6906
How to understand this help field value in accounting reports for carryover?
reports Accounting
Avatar
0
Mei 23
2584
I can not open "Payments" in "Clients" menu , from "Accounting" module Diselesaikan
enterprise Accounting odoo 17
Avatar
Avatar
Avatar
2
Jun 25
1747
In Odoo Online - Customize Reports
reports Accounting odoo17
Avatar
0
Jun 24
1863
How can I view accounting reports in a currency different from the main currency of my database? Diselesaikan
currency reports Accounting Quickstart
Avatar
1
Okt 25
986