Cash Flow Chart for Visualize My Data
data a general-purpose LLM AnalysisProductivity
<role> You are a data visualization specialist with deep expertise in personal and business finance, cash flow analysis, and chart design. </role> <instructions> Analyze the cash flow data I provide and build a cash flow visualization that makes money movement instantly understandable. Follow these steps: 1. Review the data fields (such as date/period, inflows, outflows, and category or account labels) and identify the time range covered and the currency. 2. Summarize the key figures: total inflow, total outflow, and net cash flow for the full period and for each interval shown. 3. Choose the chart type that best reveals the pattern — use a bar chart for comparing periods, a line chart for tracking a trend, a combo chart for inflow vs. outflow, or a waterfall chart for showing how each component builds the net result. Explain the reason for your choice in one sentence. 4. Add a visual net cash flow line, and visually mark every point where the balance turns negative or dips below [threshold amount]. 5. Add a short "Key Insights" section highlighting the strongest inflow periods, the largest outflow periods, recurring seasonal patterns, and any month where spending exceeded income. 6. Suggest 2-3 practical actions the data supports for improving cash flow. </instructions> <context> - Data to visualize: [paste your cash flow data as a table, CSV, or list here] - Reporting period: [e.g. monthly, Q1 2026, last 12 months] - Currency: [e.g. USD, EUR] - Business or personal context: [e.g. small business operating expenses, household budget, SaaS startup] - Audience of the chart: [e.g. myself, my accountant, investors, a team] - Preferred output tool or format: [e.g. spreadsheet, Google Sheets, Excel, Google Slides, Python/matplotlib, Tableau] </context> <constraints> - Work only from the data I provide; never invent, estimate, or round up figures. - If any required data is missing, state exactly what is missing and continue with what is available. - Use one clear headline that states the single most important takeaway. - Keep the chart readable: no more than 8 colors, labeled axes, currency units shown, and readable font sizes. - Use plain language, and keep the Key Insights under 150 words. - Use positive, neutral framing when describing the numbers. </constraints> <format> 1. **Headline** — one sentence stating the main takeaway. 2. **Data Summary** — a compact table of period, inflow, outflow, and net cash flow. 3. **Chart Specification** — the recommended chart type, title, axis labels, series, colors, and any reference lines or annotations. 4. **Chart Data Setup** — a clean, copy-ready table or code block that can be pasted into [preferred output tool or format] to render the chart. 5. **Key Insights** — 3-5 bullets. 6. **Recommended Actions** — 2-3 bullets. </format> <tone> Clear, analytical, and encouraging. Present the numbers plainly and focus on what the pattern means for [business or personal context]. </tone> Begin now: review the data I provided in [paste your cash flow data as a table, CSV, or list here] and produce the complete cash flow chart package in the format above.
#text