İçereği Atla
Bu soru işaretlendi
accrualsenterprisecashflowreportsAccounting
6 Cevaplar
10972 Görünümler
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
Vazgeç
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
Üretici En İyi Yanıt

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
Vazgeç
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
Rani Tathod
En İyi Yanıt

It sounds like you're encountering some common challenges with Odoo's Cash Flow Statement.



  Odoo's Cash Flow Statement relies heavily on proper configuration of account types and tags to classify transactions correctly.

  Ensure that your chart of accounts is set up with the correct account types (e.g., Cash, Bank, Accounts Receivable, etc.) and that relevant transactions are tagged appropriately for operating, investing, or financing activities.

  Review your reconciliation process to ensure that all bank transactions are accurately matched with invoices, bills, or other relevant accounting entries. Unreconciled transactions can skew the Cash Flow Statement.

  Consider using Odoo's reporting tools to customize the Cash Flow Statement to better suit your specific needs. While the default report has limitations, you can create custom reports using Odoo's reporting engine to include additional details and drill-down capabilities.

  If you require a cash-based Cash Flow Statement, explore using custom filters and date ranges in your reports to focus on actual cash inflows and outflows during a specific period.

  Remember that Odoo's Cash Flow Statement is designed to comply with standard accounting principles, which typically involve accrual-based accounting.


For personalized assistance:
https://www.pragtech.co.in/contact-us-mql.html

Avatar
Vazgeç
Avatar
john
En İyi Yanıt

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
Vazgeç
Avatar
Robbie
En İyi Yanıt

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
Vazgeç
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
En İyi Yanıt

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
Vazgeç
Avatar
Cybrosys Techno Solutions Pvt.Ltd
En İyi Yanıt

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
Vazgeç
İlgili Gönderiler Cevaplar Görünümler Aktivite
Is is possible to configure/customize the cash flow statement?
cashflow Accounting
Avatar
Avatar
Avatar
Avatar
4
Tem 23
6494
How to understand this help field value in accounting reports for carryover?
reports Accounting
Avatar
0
May 23
2257
I can not open "Payments" in "Clients" menu , from "Accounting" module Çözüldü
enterprise Accounting odoo 17
Avatar
Avatar
Avatar
2
Haz 25
1516
In Odoo Online - Customize Reports
reports Accounting odoo17
Avatar
0
Haz 24
1546
How can I view accounting reports in a currency different from the main currency of my database? Çözüldü
currency reports Accounting Quickstart
Avatar
2
Eyl 25
520