Skip to content
Back to Fiplan

Cash, financial year by financial year and month by month

⏱ 5 min readUpdated on

A profitable business can run short of money in a given month. Fiplan's monthly cash flow shows what the bank account will hold at the end of each month, and warns you if the balance falls below zero.

What it is for

The Cash Flow Statement tab has two views. The Annual view splits each financial year's flows between operations, investments and financing — each including VAT —, then VAT settled with the State, advance tax payments (versements anticipés / voorafbetalingen) and the balance of the tax. The Detailed monthly view shows, for one financial year, each month: receipts, disbursements, net flow and cumulative balance.

At the top, the screen shows “Positive cash throughout the period”, or the number of negative months and the lowest point.

Steps

  1. Open Results, Cash Flow Statement tab.
  2. Read the alert: positive cash, or negative months and lowest point.
  3. In the Annual view, compare the three families of flows.
  4. Switch to the Detailed monthly view and choose the Year: the detailed table shows, month by month, customer receipts, then disbursements (supplies, general expenses, remuneration), investments, financing, VAT settled with the State and the tax.
The monthly view for 2027: the “Monthly flow” and “Cumulative balance” chart, and the detailed table.
The monthly view for 2027: the “Monthly flow” and “Cumulative balance” chart, and the detailed table.

Worked example · Boulangerie Dupont SRL

Annual view202720282029
Operating cash flow118,703.36115,588.85115,938.20
Investing cash flow-38,720.000.000.00
Financing cash flow53,322.82-7,604.69-7,954.04
VAT administration110.40-8,812.80-8,812.80
Corporate income tax — balance0.00-21,025.38-20,094.01
Net cash flow133,416.5878,145.9879,077.35
Cumulative cash133,416.58211,562.56290,639.91

In 2027, financing includes the contribution (apport / inbreng) of €20,000.00 and the loan of €40,000.00, minus the capital repaid. The previous year's tax is paid in 2028 and 2029, on its own line: Corporate income tax — balance. The VAT on a sale or purchase paid in cash stays on the line of that operation; “VAT administration” only carries the returns paid to the State and the credits refunded.

The first three months of 2027:

MonthNet flowCumulative balance
January71,121.3471,121.34
February9,958.3681,079.70
March-28,761.6452,318.06

March carries the van, VAT included: it is the lowest point of the plan, €52,318.06. No month is negative.

Pitfalls

An investment goes out VAT included. The van costs €38,720.00 in March; its VAT comes back later, through the VAT return.
Tax goes out the following year. The corporate income tax (ISOC / VenB) for 2027 is paid in 2028: the 2027 cash flow ignores it, the balance sheet carries it as a debt.
The tab's balance is the balance sheet's. The cumulative cash at each year-end is the balance of account 550000: a check verifies it.

What it changes · 2027

① Income statementNo effect€0.00Cash is read here; the result is read in the income statement.
② CashCash at 31 December 2027€133,416.58Lowest point in March: €52,318.06.
③ Balance sheetCash at bank and in hand€133,416.58The same amount, on the assets side of the balance sheet.

Source

Fiplan convention: flows are classified according to the journal entries that touch cash (account 550000) — operations, investment, financing (each including VAT), VAT settled with the State, advance tax payments, balance of the tax; a flow is classified first by the module of its line, then by its account; the cumulative balance of each month is the sum of the flows since the start of the plan.