1. Plan the dashboard “Act as a senior FP&A analyst. I run a [business type] earning revenue through [revenue sources]. My main goals are [improve cash flow / reduce costs / increase profit]. Review my uploaded financial data and design a dashboard plan containing: 8 essential KPIs, required calculations, recommended charts, filters, and dashboard sections. Prioritize decisions I should make weekly and monthly. Do not build it yet—first show me the proposed structure and identify missing data.”

2. Clean the financial data “Inspect my uploaded file for missing values, duplicate transactions, inconsistent dates, incorrect number formats, blank categories, and unusual entries. Create a cleaned version without silently deleting anything. Add a ‘Data Issues’ table showing the row, issue, suggested correction, and confidence level. Standardize dates as [DD/MM/YYYY], currency as [USD], and categories using [my preferred categories].”

3. Build the executive overview “Using my cleaned data, create an executive finance dashboard for the period [date range]. Include KPI cards for revenue, expenses, gross profit, net profit, profit margin, cash balance, accounts receivable, and monthly burn rate. Compare each KPI with [previous month / previous year / budget]. Use green, amber, and red indicators, and explain the rule behind each status.”

4. Create the profit-and-loss view “Build an interactive profit-and-loss section from my data. Show revenue, cost of goods sold, gross profit, operating expenses, EBITDA, taxes, and net profit by month. Add actual-versus-budget comparisons, percentage variance, and year-over-year change. Include a waterfall chart explaining how revenue becomes net profit and highlight the three largest negative variances.”

5. Build a cash-flow command center “Create a cash-flow dashboard using my uploaded transactions. Separate operating, investing, and financing cash flows. Show opening cash, cash received, cash paid, closing cash, net cash movement, monthly burn rate, and estimated runway. Add a 13-week cash-flow forecast using clearly stated assumptions and flag any week when cash may fall below [minimum cash threshold].”

6. Analyze expenses and overspending “Analyze expenses by category, vendor, department, and month. Show total spend, average monthly spend, budget variance, and each category’s percentage of revenue. Identify recurring charges, sudden increases, possible duplicates, and expenses that grew faster than revenue. Rank the five biggest cost-saving opportunities and estimate their potential annual impact.”

7. Track invoices and receivables “Build an accounts-receivable dashboard from my invoice data. Calculate total outstanding, overdue amount, average collection time, and aging buckets of 0–30, 31–60, 61–90, and 90+ days. List the ten highest-priority unpaid invoices using amount, days overdue, and customer payment history. Add a projected collections chart for the next [30/60/90] days.”