Free cash flow
dashboard template.

By The Experts AI editorial team · Written with AI assistance · Updated October 14, 2026

Short answer: This free template gives you 24 fictional transactions for a Brooklyn coffee shop (January to June 2026), expected monthly totals, an import test file and the Claude Code prompt we use. A correct dashboard shows $48,250 money in, $32,840 money out and $15,410 net cash flow. No signup is required.

Everything you need to build and check a cash flow dashboard: a sample transactions CSV, the expected totals for every month, a small file for testing imports, and the prompt we use with Claude Code. No signup.

Download the sample CSV ↓ Import test file ↓ Also on GitHub ↗

What is in the CSV

24 fictional transactions for a coffee shop in Brooklyn, NY, from January to June 2026. Four columns: date (YYYY-MM-DD), description, category (Customer receipts, Rent, Supplies, Payroll) and amount in USD. Positive amounts are cash received; negative amounts are payments.

Expected totals to check against

Testing imports

The import test file adds three rows dated June 30, 2026: a $450 catering order, a $120 milk delivery and a $30 card processing fee. After importing it once, receipts rise by $450, payments by $150 and net cash flow by $300 to $15,710. Importing it a second time must not change anything.

The Claude Code prompt

Build a cash flow dashboard for a fictional coffee shop.

The CSV columns are date, description, category, and amount.
Positive amounts are cash received; negative amounts are payments.

Start with three summary cards: money in, money out, and net cash flow.
Add a monthly chart, a transaction table, and a period filter.
Use USD and make the interface readable on a phone.

For the full sample, expected receipts are $48,250,
payments are $32,840, and net cash flow is $15,410.
For June alone, expected net cash flow is $3,000.

Explain your proposed approach before making changes.
Use only the fictional sample. Do not connect external accounts.
Flag ambiguous data instead of guessing.

Adapting your own export

Accounting tools and banks export different columns. To use your own data later, reduce the export to the same four columns, make payments negative, and use one date format. Build and test on the sample first. Read our data safety guide before real data goes near an AI tool.

Next: follow the step-by-step guide or try the finished demo.

Frequently asked questions