Date
- Requirement
- Required
- Example
- 2026-06-01
- Purpose
- Creates time-based cash trends
Upload cash transaction data to visualize receipts, payments, net movement, account balances, and monthly cash trends.
The workflow helps owners and finance teams understand how cash is entering and leaving the business without manually rebuilding reports from bank or transaction exports.
Supports structured .csv and .xlsx files. Public examples use synthetic data. Review VizMint’s current privacy and retention policy before uploading sensitive information.
Use the fixed preview below to switch between the source spreadsheet and a dashboard sample. Open the full demo in a new tab for every KPI and chart.
Cash Flow Dashboard
Interactive preview from the sample cash transaction dataset
Switch preview
Total Records
48
rows in sample
Total Cash Inflow
1,604,886
sum of Cash Inflow
Total Cash Outflow
1,059,000
sum of Cash Outflow
Bin width 50,000 · 48 observations
Full dashboard with all KPI details and 6 charts is on the demo page.
Open full demoThe sample contains 48 cash transactions across multiple categories and accounts. Charts and KPI cards are generated from the same JSON dataset.
Sample totals: $85,000 opening balance, $1,604,886 operational receipts, $1,059,000 payments, and $630,886 ending balance — with 0 internal transfers excluded from operational movement.
Understand cash in, cash out, net movement, and ending balance without confusing revenue with cash.
Financial reporting is useful only when every total can be traced to a defined period, category, and source row. A reliable analysis explains what a number includes, what it excludes, and which decision it supports.
The sample starts with $85,000, records $1,604,886 in operational receipts and $1,059,000 in payments, and ends at $630,886 after excluding labelled internal transfers.
The workflow is designed around clear field requirements, visible formulas, reproducible sample data, and results that reconcile to the spreadsheet.
Revenue and expenses do not always show when money actually enters or leaves an account. A cash flow dashboard focuses on receipts, payments, net movement, and balances by period, category, or account.
Use it to identify cash pressure, compare payment categories, and prepare a clear cash position review for management.
Follow the same dataset from source rows to the generated dashboard preview. The spreadsheet table, KPI cards, and charts all come from one JSON sample, so every visible result can be checked against the source.
The source preview highlights the exact columns and representative rows used in the analysis.
| Date | Quarter | Category | Department | Consolidated Running Balance |
|---|---|---|---|---|
| 2025-07-04 | Q3 2025 | Customer Receipts | Sales | 183,000 |
| 2025-07-10 | Q3 2025 | Supplier Payment | Operations | 159,540 |
| 2025-07-16 | Q3 2025 | Payroll | People | 130,560 |
| 2025-07-22 | Q3 2025 | Tax & Other | Finance | 114,000 |
| 2025-08-04 | Q3 2025 | Customer Receipts | Sales | 222,017 |
The finished example is generated from the sample dataset rather than an unrelated mockup or stock image.
Bin width 50,000 · 48 observations
VizMint works best when every column has one clear heading and each row represents one consistent record.
| Column | Requirement | Example | Purpose |
|---|---|---|---|
| Date | Required | 2026-06-01 | Creates time-based cash trends |
| Amount | Required for transaction format | 4500 | Stores transaction value |
| Cash Flow Type | Required with Amount | Outflow | Separates receipts and payments |
| Cash Inflow | Required for separate-column format | 9000 | Stores receipts |
| Cash Outflow | Required for separate-column format | 4500 | Stores payments |
| Category | Recommended | Supplier Payment | Creates category views |
| Account | Recommended | Operating Account | Enables account comparison |
| Opening Balance | Conditionally required | 25000 | Calculates ending balance |
| Department | Optional | Operations | Enables departmental analysis |
| Currency | Recommended | USD | Identifies currency |
Cash available at the start of the selected period.
Sum of cash inflows.
Sum of cash outflows.
Inflows minus outflows.
Opening balance plus net movement.
Category with the highest payments.
Category with the highest receipts.
Lowest calculated balance during the period.
| Chart or Output | Required Fields | Business Question |
|---|---|---|
| Cash Inflow vs Outflow Trend | Date, inflow, outflow | Are receipts keeping pace with payments? |
| Ending Balance Trend | Date, opening balance, movement | How is available cash changing? |
| Cash Movement Waterfall | Opening balance, receipts, payments, ending balance | How does cash move from opening to closing position? |
| Payment Category Breakdown | Category, outflow | Which categories consume the most cash? |
| Receipt Category Breakdown | Category, inflow | Where does cash come from? |
| Account Comparison | Account, inflow, outflow, balance | How do accounts differ? |
Use clear headers, one record per row, consistent dates, and numeric values stored as numbers.
Select the CSV or Excel file using the page’s upload control.
For multi-sheet workbooks, choose the sheet containing the relevant data table.
Review the detected fields and map any column VizMint could not identify confidently.
Check dates, numbers, categories, missing values, and record counts before generation.
Create the supported dashboard, report, presentation, chart, or answer.
Review calculations and limitations, then save, share, or export using the options available in the active plan.
| Metric | Formula or Method | Required Fields | Important Rule |
|---|---|---|---|
| Net Cash Movement | Cash inflows − cash outflows | Inflow and outflow fields | Non-cash transactions should be excluded. |
| Ending Balance | Opening balance + net cash movement | Opening balance, inflow, outflow | The next period opening should reconcile with the previous ending balance. |
| Payment Category Share | Category outflows ÷ total outflows × 100 | Category and outflow | Uncategorized payments remain in totals. |
| Receipt Growth | Current-period receipts − previous-period receipts | Date and inflow | Requires at least two periods. |
| Problem | Recommended Fix |
|---|---|
| Bank transfers counted as income and expense | Identify internal transfers and exclude them from operational movement. |
| Opening balance missing | Show movement KPIs but do not calculate ending balance. |
| Negative numbers used inconsistently | Normalize signs and cash-flow type. |
| Duplicate bank rows | Use transaction IDs, dates, and amounts to check duplicates. |
| Cash and accrual data mixed | Use actual receipt and payment dates for cash analysis. |
| Multiple accounts combined without labels | Add an account field. |
Available options depend on the live VizMint plan. The final page should list only verified capabilities, such as saving the analysis, downloading chart images, exporting PDF or PowerPoint files, creating a shareable link, refreshing with updated data, or removing branding on eligible plans.
Do not publish a plan comparison until product and billing owners confirm every feature.
VizMint analyzes exports; it does not replace the accounting, CRM, help-desk, HR, warehouse, advertising, or project-management system that produced them.
Upload a structured CSV or Excel file, review the detected fields, and generate the workflow-specific output described on this page.