--- title: "Weekly cash position dashboard template — make it with AI | Dashfridge" description: "A one-screen weekly cash dashboard: cash today, AR and AP due, payroll, line of credit and ending cash by week. Copy the prompt into any AI tool." url: https://dashfridge.com/templates/weekly-cash-dashboard site: Dashfridge (https://dashfridge.com) --- [Templates](https://dashfridge.com/templates) · [Finance](https://dashfridge.com/templates#finance) # Weekly cash position dashboard A one-screen weekly cash dashboard: cash today, AR and AP due, payroll, line of credit and ending cash by week. Below: the live dashboard, the prompt to make yours, and how to keep it current. The Dashfridge team · Updated November 10, 2026 Live sample with made-up numbers · runs locked down, like every dashboard on Dashfridge ## 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. Copy this prompt 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. **Gather the numbers** Export 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. **Paste the prompt** Copy the prompt into Claude, ChatGPT, Gemini or Copilot, fill in the brackets and paste your data under it. 3. **Check it** Tie the totals back to your source reports before anyone else sees it. 4. **Put it on the fridge** Upload 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](https://dashfridge.com/guides/scheduled-refresh). ## Common questions **What should a weekly cash dashboard include?** Cash on hand, how many weeks of expenses it covers, what's coming in (AR due) and going out (AP and payroll) in the next 30 days, available credit, and ending cash by week against a minimum. **Who should see the weekly cash dashboard?** Usually the leadership team and anyone who approves spend. Keep it somewhere they sign in to rather than in email, so everyone sees the same, current version. ## Get new finance templates A couple of emails a month for people who build dashboards with AI. No spam. ## Make it with any AI. Keep it here. Your team signs in with their company email and always sees the current, certified version. Free for your first 3 dashboards. [ Start free with your work email](https://dashfridge.com/sign-up) ## More templates [13-week cash flow forecast A direct-method 13-week cash flow dashboard you can make with Claude, ChatGPT, Gemini or Copilot from your bank balance, AR, AP and payroll. Copy the prompt.](https://dashfridge.com/templates/13-week-cash-flow) [AR aging and collections dashboard An AR aging dashboard with current, 1–30, 31–60, 61–90 and 90+ buckets, DSO and the largest past-due accounts. Make it with any AI tool from your aging report.](https://dashfridge.com/templates/ar-aging-dashboard) [Budget vs. actual dashboard A monthly budget vs. actual (BvA) dashboard by department with variance, % and the owner's explanation. Copy the prompt into Claude, ChatGPT, Gemini or Copilot.](https://dashfridge.com/templates/budget-vs-actual)