An Excel template to track your cash forecast by hand for the next three months: enter every receipt and every payment, and get ahead of cash shortfalls. The template is in Spanish.
We'll email it to you right away · No commitment
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 9 | Concepto | Sem. 1 | Sem. 2 | Sem. 3 | Sem. 4 |
| 13 | Clientes | 18.400 | 21.000 | 16.900 | 24.300 |
| 20 | Nóminas | 9.800 | 0 | 0 | 9.800 |
| 21 | Proveedores | 6.200 | 7.100 | 5.400 | 6.900 |
| 24 | Impuestos | 14.500 | 0 | 0 | 0 |
| 31 | Saldo final | −2.100 | 11.800 | 23.300 | 30.900 |
| 32 | Alerta | Negativo |
You enter by hand your sales and customer receipts, pending invoices, direct debits, payroll and social security, suppliers, rent, taxes, and loan, leasing and renting instalments.
The «Alerta» (alert) row flags in red the weeks with negative cash and in orange those that fall below your minimum cash buffer.
Closing balance in week 13, the lowest balance and the week it hits, and how many weeks you'll be negative or below your buffer.
In the yellow cells: your company name, the Monday of week 1, your opening cash balance across all your banks and the minimum cash buffer you want to keep.
Replace the sample amounts (in blue) with your expected receipts and payments for each week, in euros and as positive numbers.
If you need another line, rename the ones labelled «Otros cobros» or «Otros pagos», without touching the cells with formulas.
Look at the closing balance and the «Alerta» row to see which weeks to watch and act early: move a payment, bring forward a receipt or arrange financing.
Free template · Excel (in Spanish)
Leave your email and we will send it to you right away.
With Orama, this forecast fills itself in from your banks and updates up to 4 times a day. Try it free for 7 days or book a 30-minute demo.