The Cashflow-prognose (Cash flow forecast) shows per week what you expect to receive and pay, and how your balance develops over the next 26 weeks. You find the page in the menu Projectfinanciën → Cashflow-prognose (Project finance → Cash flow forecast). You do not need an add-on for the forecast: it is included in every package. By default only the admin role sees it. You can also give the right to view it and the right to change the starting balance and fixed costs to a role of your own.
What counts
Beamcore only reads what is already in the system and changes nothing there. All amounts include VAT.
- Sales invoices that have been sent or partly paid: the outstanding amount on the due date. A credit note counts as negative.
- Instalment invoices that have not been invoiced yet: on the expected date of the trigger plus the customer's payment term.
- Accepted quotes without an invoice and without instalments: on the delivery date of the project plus the payment term. Without a delivery date Beamcore uses a fixed number of days after acceptance. That is marked as an estimate in the list.
- Purchase invoices that have not been paid or rejected: what is still outstanding on the due date.
- Purchase orders without a purchase invoice: the open quantity times the price, plus 21% VAT. An order line without a price does not count and is mentioned.
- Fixed costs: wages and other costs per month, on the payment day.
An item dated before this week counts in week 1 as overdue. Instalments that you invoice manually or that are not in the planning yet are listed separately under Zonder verwachte datum (Without expected date) and do not count in the balance.
Entering the starting balance and fixed costs
- Click Startsaldo en vaste lasten (Starting balance and fixed costs) at the top.
- Fill in the Startsaldo (Starting balance): what is in the bank at the start of this week. It may be negative. There is no bank link, so you enter this amount yourself.
- Fill in Lonen per maand (Wages per month) and Overige vaste kosten per maand (Other fixed costs per month), including VAT, and choose the Betaaldag (Payment day, 1 to 28, default 25).
- Check the assumptions: Betaaltermijn leveranciers (Supplier payment term, default 30 days) and Offerte zonder opleverdatum (Quote without delivery date, default 60 days after acceptance).
- Save.
VAT payments and payroll tax are not listed separately. Include them in the fixed costs.
Reading the overview
At the top are the tiles Startsaldo (Starting balance), Verwacht inkomend (Expected incoming), Verwacht uitgaand (Expected outgoing), Saldo aan het eind (Balance at the end) and Laagste saldo (Lowest balance). The chart Verwacht saldo (Expected balance) shows the balance at the end of each week; the dotted line is €0. In the table Per week you click a week to see which items fall in it. If the balance drops below zero in a week, you see the warning Let op: het saldo komt onder nul. (Note: the balance drops below zero.) at the top, with the week and the lowest point. Under Totaal per soort (Total per type) you see what comes in and goes out per source, and what is still expected after this period.
It remains a forecast based on what is in Beamcore now. The more completely you keep track of invoices, instalments and purchasing, the more accurate the picture.