ExcelCraft
Open editor

EXCELCRAFT PRO TEMPLATE

13-week cash flow
forecast for Excel.

See the tight week coming while there is still time to act. List what you expect to receive and pay, and the forecast shows your bank balance for the next 13 weeks, the lowest point and any week below your buffer.

See what is inside

Planned pricing: $8 a month or $60 a year. No payment is taken today.

Original ExcelCraft workbook · Pro · Finance & accounting

ExcelCraft / Cash Flow Forecast (13 weeks)Fictional sample
Cash Flow Forecast (13 weeks) with fictional sample data, shown in the ExcelCraft spreadsheet editor
Pro workbook preview · fictional data

INSIDE THE WORKBOOK

Every sheet
has one job.

Mint cells are where you type. White cells calculate. Instructions inside the file explain each field.

Dashboard
Cash today, lowest balance and when, weeks below buffer and cash in 13 weeks; closing cash by week and cash in vs out.
Forecast
The full weekly grid: opening cash, receipts and payments by category, net flow, closing cash and a below-buffer flag.
Inflows
Expected receipts with date, category and certainty (Confirmed, Expected or Possible).
Outflows
Expected payments with the date they leave the bank: payroll, rent, suppliers, tax and loans.
Settings · Checks · Instructions
Start Monday, opening cash, minimum buffer, categories and whether to count possible receipts.

WHY IT HELPS

Built around
the real task.

A rolling 13-week cash forecast by category with a minimum-balance warning.

  1. Weekly, because cash is weekly

    Payroll, rent and supplier runs land on specific days. A weekly forecast shows the dip a monthly one averages away.

  2. Prudent by default

    Receipts marked Possible stay out of the forecast unless you choose to include them, and the upside is shown separately.

  3. Rolls forward in a minute

    Each Monday move the start date, update opening cash from the bank and add new items. Past weeks drop off automatically.

GETTING STARTED

Three steps
to your own version.

The sample shows a working example; the blank version keeps every formula ready for your records.

  1. Set the starting point

    On Settings, pick the Monday to start from, today's bank balance and the lowest balance you are comfortable with.

  2. List money in and out

    Add expected receipts and payments with the date they will hit the bank.

  3. Act on the low point

    Check the lowest balance and any red week. Chase receipts, move payments or arrange funding before it arrives.

QUESTIONS

Before you begin.

Short answers about how the workbook behaves.

Why 13 weeks?

About one quarter: long enough to see payroll, rent and tax cycles, short enough to forecast with real invoices and bills.

How is this different from a P&L?

A P&L shows profit when it is earned. A cash forecast shows when money actually arrives and leaves, which is what pays the bills.

How do I enter recurring payments?

Add a row for each occurrence within the 13 weeks, for example each payroll date. Copy and change the date.

Can it connect to my bank?

No. Update opening cash from your bank each week. Nothing is uploaded.

How do I keep my changes?

Use Download XLSX or PDF in the editor before closing the tab. Nothing is saved to a server automatically, and your workbook never leaves your device while you edit.

Will it work in Excel and Google Sheets?

The files use standard XLSX formulas without macros, pivot tables or external links. They are checked with the ExcelCraft engine; compatibility with every Excel or Google Sheets version is not guaranteed. Review formulas, charts and formatting in your app before relying on important figures.

Can I change the currency?

Amounts use a $ number format. Change the cell format to your currency; the formulas do not convert between currencies.

EXCELCRAFT PRO · EARLY ACCESS

Part of
ExcelCraft Pro.

Pro workbooks cover whole workflows: purchasing to receiving, journal to balance sheet, tasks to portfolio health. Pro is planned to include AI credits for editing through chat. Pro downloads and the AI assistant are not available yet.

  • Every Pro workbook as it is released, with dashboards, checks and instructions
  • Planned: monthly AI credits for editing spreadsheets through chat
  • Planned launch pricing; final terms are not set

$8/ month

or $60 / year · planned launch price

No payment today. We email you once when Pro opens.

How Pro works

RELATED

Works well with.

Separate workbooks for neighbouring jobs. Records do not sync between files.

Your workbook stays in this browser while you edit. Use Download in the editor to keep your work, and review important figures in the saved copy. How local files are handled.

Original ExcelCraft workbook design, formulas and fictional sample data · CC0. Management tool only; not tax, legal or accounting advice.