Dashboard template

Cash in, cash out, and the next 13 weeks.

A cash flow dashboard template is a ready-made page showing cash in bank today, money in and out by week, receivables and payables falling due, and a 13-week forecast with the lowest point marked. Connect your accounting system and bank balances, add known commitments from a sheet, and let Klayara AI explain why cash moved.

Cash flow template preview13-week lowWeek 9

Cash flow

Cash in bank, weekly flows and the 13-week forecast.

Profit and cash are different questions, and most businesses that run short of money were profitable on paper at the time. This template answers the cash question only: how much is in the bank across every account and entity, what came in and went out this week, what is due in and out over the next month, and where the balance is heading for the next 13 weeks. It is the page an owner or finance lead opens every Monday, separate from the wider finance snapshot.

It reads from your accounting system — Xero, QuickBooks, Tally, Zoho Books or your ERP — for bank balances, open invoices and bills. Receipts are forecast from the receivables ageing and each customer's usual payment delay; payments from bills due plus a sheet of known commitments such as payroll, rent and tax. Our guide to the cash-flow dashboard explains the six numbers behind it.

Week to week, the finance lead updates the commitments sheet and the page does the rest. Klayara AI, on Growth and Enterprise, explains a movement in plain words when someone clicks Why did this change? — for example which customers paid late — and an alert described in a sentence, such as "WhatsApp me if the 13-week low falls below two months of payroll", becomes a draft automation to review. The Monday cash summary can arrive by email, WhatsApp, Slack or Telegram.

  • Owners and finance leads who want a Monday answer to "do we have enough cash for the next quarter?".
  • Growing companies with several bank accounts or entities whose balances live in different places.
  • Finance teams preparing for a lender or board conversation about runway and working capital.
The metrics

What a cash flow dashboard should show.

Each figure below is on the template from the first minute — rename, redefine or remove any of them.

Cash in bank

Total balance across every bank account and entity today, with each account a click away.

Net cash flow this week

Receipts minus payments for the current week, against the same week last month.

Cash in

Customer receipts and other income received this week and month to date.

Cash out

Supplier payments, payroll, rent, tax and loan repayments made this week and month to date.

13-week low point

The lowest forecast balance in the next 13 weeks and the week it falls in — the one number that decides whether to act now.

Receivables due in 30 days

Invoices falling due in the next 30 days, with the share already overdue shown separately.

Payables due in 30 days

Bills and known commitments due in the next 30 days, so the timing of payments can be planned.

The panels

The charts on the page, and the decision each one supports.

Cash position, back and forward

Thirteen weeks of actual balance followed by thirteen weeks of forecast, with the low point and any minimum balance line marked.

Weekly cash in and out

Paired bars per week for receipts and payments, with net flow as a line. Shows whether a bad week was a slow receipt or a big payment.

Receivables due by week

Expected receipts by week and customer, with overdue invoices at the front so the chase list is obvious.

Payables and commitments

Bills and fixed commitments by due week, grouped by type — suppliers, payroll, tax, rent, loans.

Biggest movements

A table of the largest receipts and payments this week, so the reason for a swing is visible without opening the ledger.

Where the numbers come from

Connect the systems you already run.

The template expects data like this. Connect it live or import it, relate the tables once, and every panel fills in.

See all 150+ connectors
XeXeroQuQuickBooksZoZoho BooksTaTallyMiMicrosoft DynamicsGoGoogle SheetsMiMicrosoft Excel
FAQ

Cash flow template questions.

Something else on your mind? Ask us directly — a person answers.

What is a cash flow dashboard?

A cash flow dashboard is a single page showing cash in bank, money coming in and going out by week, receivables and payables falling due, and a short-term forecast of the balance — usually 13 weeks — so a business sees a shortfall before it happens.

How is a cash flow dashboard different from a profit and loss report?

A profit and loss report shows what was earned and spent when invoices were raised. A cash flow dashboard shows when money actually moves in and out of the bank, which is what decides whether payroll and suppliers can be paid on time.

How is the 13-week forecast built?

Receipts come from open invoices adjusted by each customer's usual payment delay; payments come from bills due plus a sheet of known commitments such as payroll, rent and tax. The forecast updates as invoices are paid and new bills arrive.

Can the cash summary arrive every Monday on WhatsApp?

Yes. Schedule the page as a PDF or image to email, WhatsApp, Slack or Telegram at any day and hour, and add an alert for when the forecast low falls below a level you set.

Can Klayara AI explain why our cash fell this week?

Yes. Click "Why did this change?" and Klayara AI explains the movement in plain words — for example a large supplier payment or customers paying later than usual — using only the figures you may see. Klayara AI is on the Growth plan (150 AI credits a month for the workspace) and Enterprise, and runs only when someone clicks.

Your cash flow dashboard, this week.

Bring your data and we'll set this template up on it live — then shape it around the questions you actually ask.

Talk to sales

Prefer to see plans first? See pricing

Contact usWhatsApp