Weekly cash position dashboard

Who it's for

Small finance teams and founders who want one number every Monday: how much cash do we have, and is it enough?

What's in it

• Cash on hand and weeks of expenses it covers
• AR and AP due in the next 30 days
• Payroll and available credit
• Ending cash by week against a cash floor

The prompt

Works in Claude, ChatGPT, Gemini and Copilot. Fill in the [brackets], then paste your data under it.

Build a weekly cash position dashboard from the data below.
- Left: a big "cash on hand today" number, how many weeks of operating expenses it covers, then lines for AR due next 30 days, AP due next 30 days, payroll (next 2 cycles) and line of credit available.
- Right: ending cash by week for 13 weeks as a line chart, actual weeks solid and forecast weeks lighter, with a dashed line at our cash floor of [$ AMOUNT].
- Title "Weekly cash position" and a subtitle with the date and who prepared it.

My data:
[paste balances and weekly cash numbers]

Build it as ONE self-contained HTML file:
- Put all the data inside the file. No API calls, no fetch, no external data.
- Use plain HTML, CSS and JavaScript (inline SVG for charts is fine). If you need a chart library, load it from cdn.jsdelivr.net.
- Add a "data as of" date under the title.
- Make it readable on a laptop and print cleanly to one page if possible.

Data you need

• Bank balances
• AR due in 30 days
• AP due in 30 days
• Upcoming payroll
• Credit line available
• Weekly ending cash (actual and forecast)

Make it and share it

1. 1Gather the numbersExport or copy: Bank balances; AR due in 30 days; AP due in 30 days; Upcoming payroll; Credit line available; Weekly ending cash (actual and forecast).
2. 2Paste the promptCopy the prompt into Claude, ChatGPT, Gemini or Copilot, fill in the brackets and paste your data under it.
3. 3Check itTie the totals back to your source reports before anyone else sees it.
4. 4Put it on the fridgeUpload the HTML file to Dashfridge, or connect your AI and say "put this on the fridge". Publish it and invite your team.

Keep it current

How often: Weekly. Most teams refresh it Monday morning before the leadership meeting. Update the same dashboard each time instead of sending a new file, so your team keeps one link and every past version is kept. Your AI can do the refresh for you: see dashboards that update every week.