Skip to main content
Pending validationOdoo 20.0Community and Enterprise, with differences

How to get the statement of cash flows

What is it for?​

The statement of cash flows shows where the money came from and where it went in the fiscal year, in three blocks: operating, investing and financing activities. It ends with cash and cash equivalents at the end of the period. It is one of the SNC financial statements and part of the set submitted with the IES.

When to use it?​

  • At the end of the fiscal year, to prepare the financial statements.
  • To explain to Management why the bank balance went up or down.
  • Do not use it to find out what is left to collect or pay: for that there is the aged balance.

Where to find it?​

Accounting › Review › Financial statements › Cash flows.

Before you start​

  • Your profile is Accountant. With it you can do every step of this article (tested with the Accountant profile).
  • The fiscal year's journal entries are posted.
  • The example is Empresa Demonstração, Lda, in fiscal year 2026, on 03/11/2026.

How to use it​

  1. Open Accounting › Review › Financial statements › Cash flows. The Demonstração dos Fluxos de Caixa (SNC) opens on the current fiscal year (01/01/2026 – 31/12/2026), with the Line, Notes and Value columns. To change the period, compare with the previous year or save the options, see How to filter, compare periods and export a report.
  2. Read the operating activities. In the example: Recebimentos de clientes (receipts from customers) €32,674.40, Pagamentos a fornecedores (payments to suppliers) -€31,936.10 and Pagamentos ao pessoal (payments to staff) -€36,972.06, which gives Caixa gerada pelas operações (cash generated by operations) of -€36,233.76. With Outros recebimentos/pagamentos (other receipts/payments, -€2,675.61), the Fluxos de caixa das atividades operacionais (cash flows from operating activities) are -€38,909.37.
  3. Read investing and financing. In the example, investing is -€9,000.00 (Ativos fixos tangíveis -€4,200.00 and Ativos intangíveis -€4,800.00). Financing is €80,206.21: €120,000.00 received and -€39,793.79 paid in Financiamentos obtidos (borrowings).
  4. Check the end of the statement. Variação de caixa e seus equivalentes (1+2+3) (change in cash and cash equivalents) is the sum of the three blocks: -38,909.37 - 9,000.00 + 80,206.21 = €32,296.84. Added to Caixa e seus equivalentes no início do período (€0.00), it gives Caixa e seus equivalentes no fim do período: €32,296.84.
  5. Check closing cash against the balance sheet for the same fiscal year: the Caixa e depósitos bancários (cash and bank deposits) line must give the same amount. In the example, €32,296.84 in both.
  6. To hand the statement over for signature, click Export and choose Export PDF ready to sign (how to do it).

Expected result​

  • The three blocks add up to the Variação de caixa e seus equivalentes and this, added to opening cash, gives closing cash.
  • Closing cash equals the Caixa e depósitos bancários line in the balance sheet.
  • No journal entry is created: the statement only reads.

Important notes​

  • Cash is calculated journal by journal. The cash of each bank journal is the bank account plus its transit accounts (pending payments and receipts). If a journal ends up owing (credit balance), that amount does not reduce cash: it counts as financing, and in the balance sheet it goes to Financiamentos obtidos. There is no netting between journals.
  • Why opening cash is €0.00 if the bank opens negative. Account 121 opens 2026 at -€78,700.00: it is a credit balance, so it is in Financiamentos obtidos in the 2025 balance sheet, not in cash. At the end of 2026 that amount is €38,906.21. The difference of €39,793.79 is the payment that appears under financing.
  • How to check against the ledger. Closing cash minus the borrowings in the balance sheet equals the sum of the cash, deposit and transit accounts in the ledger: 32,296.84 - 38,906.21 = -€6,609.37, the sum of 111001 (€578.46), 111002 (€20.14), 120001 (-€367.50), 120002 (€0.00), 120003 (-€36,972.06) and 121 (€30,131.59).
  • The warning about payments to reconcile is for information. In the example, the screen says: “There are payments to reconcile: the transit and pending payment accounts of the bank journals have a balance. The cash shown already nets them against the bank account of each journal.” Reconcile before submitting the statement (unreconciled items).
  • Pending validation by a certified accountant: whether the transit accounts belong in “cash and cash equivalents” and whether the bank's credit balance is presented as financing in the submitted statement.

Common problems​

“The lines of this statement have not been generated yet, so it shows zero…”​

  • Cause: the screen shows this warning on the statement of cash flows even when the amounts are there. In the example it appears with all the amounts in this article, and closing cash matches the balance sheet.
  • What to do: if the amounts appear and step 5 matches, you can read them. Do not run what the warning asks: in Accounting › Configure › Plan and legal rules › Generate statement lines (that is the menu name), the product refuses this statement (“Line "Fluxos de caixa das atividades operacionais" points to annex 5 line 1, which has no taxonomy in the mapping table for this statement model…”). The amounts do not change and the warning stays. If everything is zero, see the next case.

All lines are zero​

  • Cause: the company has no journal entries in the period. In a company with none at all, the statement comes out all at €0.00, with the same warning, and the balance sheet may refuse to open: “The accounting referential of "…" is not defined, so this statement cannot be shown…”
  • What to do: check the company and the period in the top bar. Without journal entries, the zeros are right. For the balance sheet, set the company's accounting framework.

Closing cash does not match the bank balance​

  • Cause: closing cash adds up the journals with a debit balance, with each one's transit accounts. It is not the balance of account 121.
  • What to do: check against the balance sheet (step 5). For the bank in particular, see the unreconciled items.
Versions: Odoo 20.0Community and Enterprise, with differencesfiscaldoo 20.0 (master 8f78854ec)ID DOC-0145
Was this page helpful?