Don't Tell Claude “Make me a dashboard” “Make it look premium” “Add...
Hamidullah Khan, PhD@IamKhanPhD
7 views
Oct 27, 2026
~8 min read
Advertisement
1
Don't Tell Claude
“Make me a dashboard”
“Make it look premium”
“Add some features”
You're leaving out the details that turn a basic interface into a functional dashboard.
Here are 15 Claude prompts to copy and paste👇👇
(Save now Build Professional Dashboard later)
“Make me a dashboard”
“Make it look premium”
“Add some features”
You're leaving out the details that turn a basic interface into a functional dashboard.
Here are 15 Claude prompts to copy and paste👇👇
(Save now Build Professional Dashboard later)
2
1. Build the dashboard foundation
“Build a working dashboard for [business name] in one HTML file with CSS and JavaScript. Use [currency: USD], a light background, dark text, and [accent color]. Include Overview, Reports, and Data tabs. Support CSV upload with columns: record_id, date, department, account, category, amount, currency. Categories: net_revenue, cogs, opex, other_income, other_expense, interest_expense, income_tax. Normal amounts are positive; reversals are negative. Net revenue already excludes discounts, returns, and sales tax. Validate dates, duplicate IDs, missing amounts, and categories. Reject mixed currencies. Include labeled sample data, a CSV template, and simple opening instructions.”
“Build a working dashboard for [business name] in one HTML file with CSS and JavaScript. Use [currency: USD], a light background, dark text, and [accent color]. Include Overview, Reports, and Data tabs. Support CSV upload with columns: record_id, date, department, account, category, amount, currency. Categories: net_revenue, cogs, opex, other_income, other_expense, interest_expense, income_tax. Normal amounts are positive; reversals are negative. Net revenue already excludes discounts, returns, and sales tax. Validate dates, duplicate IDs, missing amounts, and categories. Reject mixed currencies. Include labeled sample data, a CSV template, and simple opening instructions.”
3
2. Create executive KPI cards
“Add cards for net revenue, gross profit, operating profit, and operating margin for [reporting period]. Calculate gross profit = net revenue − COGS; operating profit = gross profit − operating expenses; operating margin = operating profit ÷ net revenue × 100. Calculate margins from summed amounts, never by averaging row percentages. Show N/A when revenue is zero or negative. Place a monthly revenue chart beneath the cards. Clicking a card must reveal its contributing records. Check: revenue 100,000, COGS 60,000, and operating expenses 25,000 produce gross profit 40,000, operating profit 15,000, and operating margin 15%.”
“Add cards for net revenue, gross profit, operating profit, and operating margin for [reporting period]. Calculate gross profit = net revenue − COGS; operating profit = gross profit − operating expenses; operating margin = operating profit ÷ net revenue × 100. Calculate margins from summed amounts, never by averaging row percentages. Show N/A when revenue is zero or negative. Place a monthly revenue chart beneath the cards. Clicking a card must reveal its contributing records. Check: revenue 100,000, COGS 60,000, and operating expenses 25,000 produce gross profit 40,000, operating profit 15,000, and operating margin 15%.”
4
3. Show revenue growth correctly
“Add a revenue trends page for [business]. Show monthly net revenue, month-over-month growth, and year-over-year growth. Growth = (current revenue − comparison revenue) ÷ comparison revenue × 100. Display N/A when comparison revenue is zero or negative, alongside the absolute change. Default comparisons to completed calendar months. Label incomplete months and exclude them from these growth calculations. Represent missing data as gaps unless confirmed as zero. Add department filters, exact-value tooltips, and a table beneath the chart. Check: revenue rising from 80,000 to 100,000 means 25% growth.”
“Add a revenue trends page for [business]. Show monthly net revenue, month-over-month growth, and year-over-year growth. Growth = (current revenue − comparison revenue) ÷ comparison revenue × 100. Display N/A when comparison revenue is zero or negative, alongside the absolute change. Default comparisons to completed calendar months. Label incomplete months and exclude them from these growth calculations. Represent missing data as gaps unless confirmed as zero. Add department filters, exact-value tooltips, and a table beneath the chart. Check: revenue rising from 80,000 to 100,000 means 25% growth.”
5
4. Build an operating cost explorer
“Create a cost analysis page for [period]. Define operating costs here as COGS + operating expenses, using the dashboard’s accounting records. Show total costs, the five largest accounts, and a department-by-account table. Calculate account share = account cost ÷ total operating costs × 100; show N/A when total costs are zero. Use horizontal bars ranked by amount and a visible zero baseline for negative adjustments. Clicking an account must show its transactions. Label these as accounting costs. Include transaction dates, active filters, and a download of the filtered records.”
“Create a cost analysis page for [period]. Define operating costs here as COGS + operating expenses, using the dashboard’s accounting records. Show total costs, the five largest accounts, and a department-by-account table. Calculate account share = account cost ÷ total operating costs × 100; show N/A when total costs are zero. Use horizontal bars ranked by amount and a visible zero baseline for negative adjustments. Clicking an account must show its transactions. Label these as accounting costs. Include transaction dates, active filters, and a download of the filtered records.”
6
5. Compare budget against actuals
“Add a budget page using a separate CSV: month, department, category, budget_amount, currency. Compare net revenue, COGS, and operating expenses for [completed period], matching the same departments and categories. Variance = actual − budget. Variance % = variance ÷ absolute budget × 100. Show N/A for a zero budget and distinguish missing budgets from explicit zeros. Higher revenue is favorable; higher costs are unfavorable. Use both text labels and colors. Check: actual expenses 12,000 against budget 10,000 show +2,000, +20%, and ‘Unfavorable.’ Display Actual, Budget, Variance, and Status columns.”
“Add a budget page using a separate CSV: month, department, category, budget_amount, currency. Compare net revenue, COGS, and operating expenses for [completed period], matching the same departments and categories. Variance = actual − budget. Variance % = variance ÷ absolute budget × 100. Show N/A for a zero budget and distinguish missing budgets from explicit zeros. Higher revenue is favorable; higher costs are unfavorable. Use both text labels and colors. Check: actual expenses 12,000 against budget 10,000 show +2,000, +20%, and ‘Unfavorable.’ Display Actual, Budget, Variance, and Status columns.”
7
6. Create a monthly profit and loss report
“Build an expandable monthly P&L for [business], with account details beneath each category. Show net revenue; subtract COGS for gross profit; subtract operating expenses for operating profit; add other income; subtract other expenses, interest expense, and supplied income tax expense for net profit. Depreciation and amortization already included in COGS or operating expenses must stay there without another deduction. Add monthly and year-to-date views. Every subtotal must reconcile to its accounts. Calculate total-period margins from total-period amounts. Include a print layout with the business name, dates, currency, and accounting basis.”
“Build an expandable monthly P&L for [business], with account details beneath each category. Show net revenue; subtract COGS for gross profit; subtract operating expenses for operating profit; add other income; subtract other expenses, interest expense, and supplied income tax expense for net profit. Depreciation and amortization already included in COGS or operating expenses must stay there without another deduction. Add monthly and year-to-date views. Every subtotal must reconcile to its accounts. Calculate total-period margins from total-period amounts. Include a print layout with the business name, dates, currency, and accounting basis.”
8
7. Reconcile cash movement
“Add a cash page using a separate cash ledger: transaction_id, date, bank_account, signed_amount, activity, transfer_id. Receipts are positive and payments negative; activities are operating, investing, financing, or internal transfer. Closing cash = opening cash + signed cash movements. For consolidated cash flow, exclude matched transfers between included accounts; retain transfers in individual-account views. Show a waterfall and compare calculated closing cash with the supplied closing balance at the same cutoff. Display any difference explicitly. Check: opening cash 10,000 + receipts 8,000 − payments 6,000 = closing cash 12,000.”
“Add a cash page using a separate cash ledger: transaction_id, date, bank_account, signed_amount, activity, transfer_id. Receipts are positive and payments negative; activities are operating, investing, financing, or internal transfer. Closing cash = opening cash + signed cash movements. For consolidated cash flow, exclude matched transfers between included accounts; retain transfers in individual-account views. Show a waterfall and compare calculated closing cash with the supplied closing balance at the same cutoff. Display any difference explicitly. Check: opening cash 10,000 + receipts 8,000 − payments 6,000 = closing cash 12,000.”
9
8. Build a 13-week cash forecast
“Create a 13-week cash forecast starting [date], with opening cash [amount] and minimum cash threshold [amount]. Use dated expected cash receipts and payments with unique event IDs, signed amounts, source references, and inclusion switches. Calculate daily closing balances, then summarize weekly; carry each closing balance into the next period. Show the lowest projected daily balance and first threshold breach. Keep actual and forecast transactions distinguishable. Flag past-due forecast events for rescheduling. Prevent the same invoice or payment schedule from being included twice. Add editable timing and amount assumptions, with a reset button.”
“Create a 13-week cash forecast starting [date], with opening cash [amount] and minimum cash threshold [amount]. Use dated expected cash receipts and payments with unique event IDs, signed amounts, source references, and inclusion switches. Calculate daily closing balances, then summarize weekly; carry each closing balance into the next period. Show the lowest projected daily balance and first threshold breach. Keep actual and forecast transactions distinguishable. Flag past-due forecast events for rescheduling. Prevent the same invoice or payment schedule from being included twice. Add editable timing and amount assumptions, with a reset button.”
10
9. Track overdue customer invoices
“Build an accounts receivable page as of [date]. Use invoices with IDs, customers, issue dates, due dates, and totals, plus dated payments and credit notes. Outstanding balance = invoice total − payments − credits recorded on or before the cutoff. Exclude invoices issued after the cutoff. Show positive balances in non-overlapping buckets: Current, 1–30, 31–60, 61–90, and 91+ days past due. Due today counts as Current. Use calendar-day differences. Show overpayments separately as customer credits. Include customer search, an aging bar chart, invoice drilldown, and a check that bucket totals equal positive outstanding balances.”
“Build an accounts receivable page as of [date]. Use invoices with IDs, customers, issue dates, due dates, and totals, plus dated payments and credit notes. Outstanding balance = invoice total − payments − credits recorded on or before the cutoff. Exclude invoices issued after the cutoff. Show positive balances in non-overlapping buckets: Current, 1–30, 31–60, 61–90, and 91+ days past due. Due today counts as Current. Use calendar-day differences. Show overpayments separately as customer credits. Include customer search, an aging bar chart, invoice drilldown, and a check that bucket totals equal positive outstanding balances.”
11
10. Plan supplier payments
“Add a supplier payment planner for [date range]. Calculate outstanding supplier invoices as of [cutoff date], after dated payments and credits. Show overdue invoices first, followed by upcoming due dates. Include supplier, invoice ID, due date, outstanding balance, planned payment date, and planned payment amount. Allow partial payments, but prevent combined planned payments from exceeding an invoice’s outstanding balance. Show scheduled totals by week and send selected payments into the cash forecast once using unique payment IDs. Label them ‘Planned’ until actual payment records exist. Add supplier filters and CSV export.”
“Add a supplier payment planner for [date range]. Calculate outstanding supplier invoices as of [cutoff date], after dated payments and credits. Show overdue invoices first, followed by upcoming due dates. Include supplier, invoice ID, due date, outstanding balance, planned payment date, and planned payment amount. Allow partial payments, but prevent combined planned payments from exceeding an invoice’s outstanding balance. Show scheduled totals by week and send selected payments into the cash forecast once using unique payment IDs. Label them ‘Planned’ until actual payment records exist. Add supplier filters and CSV export.”
12
11. Measure product contribution
“Build a product profitability page using [monthly] data: product, net revenue, COGS, variable fulfillment costs, payment fees, and variable advertising costs. These cost fields must be mutually exclusive. Gross profit = net revenue − COGS. Contribution = gross profit − the other listed variable costs. Contribution margin = contribution ÷ net revenue × 100; show N/A for non-positive revenue. Keep shared fixed overhead separate. Rank products by contribution amount and flag negative contributions. Calculate overall margin from totals. Check: 10,000 revenue − 4,000 COGS − 1,000 fulfillment − 500 fees − 500 advertising = 4,000 contribution and 40% margin.”
“Build a product profitability page using [monthly] data: product, net revenue, COGS, variable fulfillment costs, payment fees, and variable advertising costs. These cost fields must be mutually exclusive. Gross profit = net revenue − COGS. Contribution = gross profit − the other listed variable costs. Contribution margin = contribution ÷ net revenue × 100; show N/A for non-positive revenue. Keep shared fixed overhead separate. Rank products by contribution amount and flag negative contributions. Calculate overall margin from totals. Check: 10,000 revenue − 4,000 COGS − 1,000 fulfillment − 500 fees − 500 advertising = 4,000 contribution and 40% margin.”
13
12. Add a break-even calculator
“Create a break-even calculator for one [product/service] using fixed costs [20,000 per month], selling price [100 per unit], and variable cost [60 per unit]. Contribution per unit = price − variable cost. Break-even units = fixed costs ÷ contribution per unit; round up only when showing required whole units. Break-even revenue = fixed costs ÷ (contribution per unit ÷ price). With positive fixed costs and non-positive contribution, show ‘No break-even at this price.’ Keep all inputs on the same time basis. Add sliders and a revenue-versus-cost chart. The example must return 500 units and 50,000 revenue.”
“Create a break-even calculator for one [product/service] using fixed costs [20,000 per month], selling price [100 per unit], and variable cost [60 per unit]. Contribution per unit = price − variable cost. Break-even units = fixed costs ÷ contribution per unit; round up only when showing required whole units. Break-even revenue = fixed costs ÷ (contribution per unit ÷ price). With positive fixed costs and non-positive contribution, show ‘No break-even at this price.’ Keep all inputs on the same time basis. Add sliders and a revenue-versus-cost chart. The example must return 500 units and 50,000 revenue.”
14
13. Estimate operating cash runway
“Add an operating-burn runway panel as of [date], using unrestricted cash [amount] and the preceding [3] complete months of operating cash transactions. Monthly net operating burn = operating cash payments − operating cash receipts. Average the monthly net burn amounts. Estimated runway in months = unrestricted cash ÷ average monthly net operating burn. For positive cash and zero or negative burn, display ‘No runway estimate: operations are not consuming cash on average.’ Flag cash at or below zero as exhausted. State that this estimate assumes unchanged burn and excludes investing and financing flows. Check: 90,000 cash ÷ 15,000 monthly burn = 6 months.”
“Add an operating-burn runway panel as of [date], using unrestricted cash [amount] and the preceding [3] complete months of operating cash transactions. Monthly net operating burn = operating cash payments − operating cash receipts. Average the monthly net burn amounts. Estimated runway in months = unrestricted cash ÷ average monthly net operating burn. For positive cash and zero or negative burn, display ‘No runway estimate: operations are not consuming cash on average.’ Flag cash at or below zero as exhausted. State that this estimate assumes unchanged burn and excludes investing and financing flows. Check: 90,000 cash ÷ 15,000 monthly burn = 6 months.”
15
14. Track subscription MRR and ARR
“Add a subscription dashboard for [business] using dated subscription changes. Define MRR as monthly-normalized recurring charges after recurring discounts, counting active and past-due subscriptions under this stated policy. Exclude trials, free plans, taxes, setup fees, and usage-based charges. Divide annual recurring charges by 12. Show MRR, ARR = MRR × 12, and a bridge reconciling starting MRR + new + reactivation + expansion − contraction − churn = ending MRR. Treat plan changes as expansion or contraction. Include customer drilldown and the reporting date. Label ARR as a run rate. Check: a 1,200 annual subscription contributes 100 MRR.”
“Add a subscription dashboard for [business] using dated subscription changes. Define MRR as monthly-normalized recurring charges after recurring discounts, counting active and past-due subscriptions under this stated policy. Exclude trials, free plans, taxes, setup fees, and usage-based charges. Divide annual recurring charges by 12. Show MRR, ARR = MRR × 12, and a bridge reconciling starting MRR + new + reactivation + expansion − contraction − churn = ending MRR. Treat plan changes as expansion or contraction. Include customer drilldown and the reporting date. Label ARR as a run rate. Check: a 1,200 annual subscription contributes 100 MRR.”
16
15. Audit the calculations before sharing
“Audit this dashboard’s actual code and repair calculation errors. Centralize shared formulas so cards, charts, tables, and exports use identical logic. Check weighted margins: 50% margin on 100 revenue plus 10% on 900 revenue must produce 14% overall. Check that margin rising from 20% to 25% displays +5 percentage points. Test zero denominators, missing amounts, reversals, duplicate IDs, partial payments, cutoff dates, and internal transfers. Verify that filters update every related view and exports match displayed totals. Run the checks and report expected versus actual results. Clearly identify any checks you could not execute.”
“Audit this dashboard’s actual code and repair calculation errors. Centralize shared formulas so cards, charts, tables, and exports use identical logic. Check weighted margins: 50% margin on 100 revenue plus 10% on 900 revenue must produce 14% overall. Check that margin rising from 20% to 25% displays +5 percentage points. Test zero denominators, missing amounts, reversals, duplicate IDs, partial payments, cutoff dates, and internal transfers. Verify that filters update every related view and exports match displayed totals. Run the checks and report expected versus actual results. Clearly identify any checks you could not execute.”
