ValteraTools CFO services
  1. Valtera
  2. Tools
  3. Excel templates
  4. 13-week cash flow forecast
Excel template · Cash flow

13-week cash flow forecast

Enter expected receipts and payments for the next 13 weeks. The template calculates each week's balance and marks in red the week when cash will fall below your minimum.

Updated:
Valtera_13_week_cash_flow_EN.xlsx · 11 KB · Sheets: Guide, 13 weeks
Format: .xlsx · Excel, Google Sheets, LibreOffice · No sign-up required
Other languages: Azerbaijani · Russian
Valtera_13_week_cash_flow_EN.xlsx — 13 weeks · Preview with sample data
Start of week 1 (Monday)19.10.2026
Opening balance (bank + cash)45,000
Minimum balance15,000
Line itemWeek 1Week 2Week 3Week 4Week 5Week 6Week 7
19.10.202626.10.202602.11.202609.11.202616.11.202623.11.202630.11.2026
RECEIPTS
Customer payments (receivables)18,00012,0009,00022,00015,00011,0008,000
From new sales3,0004,0004,0005,0005,0005,0006,000
Other receipts (loans, equity)-------
Total receipts21,00016,00013,00027,00020,00016,00014,000
PAYMENTS
Suppliers14,0009,00016,00012,00013,00018,00010,000
Payroll (net)---16,500---
Taxes and social contributions-6,8004,200---6,800
Rent and utilities3,100---3,100--
Loan repayments--2,800---2,800
Other payments1,2001,2001,2001,2001,2001,2001,200

What the template includes

  • Settings for the start date, opening balance and minimum balance.
  • Week dates are built automatically.
  • Receipts: customer payments, new sales, other.
  • Payments: suppliers, salaries, taxes and insurance contributions, rent, loan, other.
  • Net cash flow, opening and closing balance, warnings for weeks below the minimum.

How to use it

  1. Enter receivables by customer in the week you expect payment. Use the customer's actual payment habits, not the contract terms.
  2. Enter salaries, taxes and loan payments in their exact week. Insurance contributions are due by the 15th of the month, income tax and VAT by the 20th: tax calendar 2026.
  3. Plan actions for the red weeks: collecting debts, splitting payments, postponing purchases.
  4. Every Monday, enter the actual figures and roll the forecast forward one week.

Full explanation: how to build a cash flow forecast. To find the cause of a gap: cash gap calculator.

Let us run the numbers

Valtera keeps the books and tax records of small and mid-sized companies and, as an outsourced CFO, takes responsibility for revenue growth and cash flow.