Date
- Requirement
- Required
- Example
- 2026-06-01
- Purpose
- Creates monthly and period-based trends
Upload your financial spreadsheet and turn monthly revenue, operating costs, expense categories, departments, and net results into a clear visual dashboard.
VizMint helps you understand where money is coming from, where it is being spent, and how performance changes over time—without manually rebuilding formulas, pivot tables, or charts.
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.
Revenue and Expense Dashboard
Interactive preview from the sample finance dataset
Switch preview
Total Records
48
rows in sample
Total Revenue
1,144,000
sum of Revenue
Total Expense
767,000
sum of Expense
Bin width 10,000 · 48 observations
Full dashboard with all KPI details and 6 charts is on the demo page.
Open full demoThe preview engine infers metrics, categories, and time fields from the data itself—so any structured JSON or CSV with numeric and categorical columns can produce KPI cards and charts without hardcoded field names.
Sample totals from 48 records: Total Revenue 1,144,000, Total Expense 767,000, Revenue − Expense 377,000 (Expense / Revenue 67.0%).
See whether costs are growing faster than income and identify the categories or teams causing the change.
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 shown on this page covers 48 transaction records. Auto-generated totals include 1,144,000 revenue, 767,000 expense, and a 377,000 net difference, all traceable to the live preview dataset.
The workflow is designed around clear field requirements, visible formulas, reproducible sample data, and results that reconcile to the spreadsheet.
Financial spreadsheets often contain everything a business needs to review monthly performance, but long tables make important changes difficult to see. A revenue and expense dashboard converts transaction or summary data into a clear visual report.
Use it to compare income and costs, identify expensive categories, review departmental performance, and understand whether the gap between revenue and expenses is improving or narrowing.
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.
| Month Start | Category | Description | Cost Center | Net Impact |
|---|---|---|---|---|
| 2025-07-01 | Subscription Revenue | Subscription Revenue from mid-market customers | REV-001 | 47,120 |
| 2025-07-01 | Services Revenue | Services Revenue from enterprise customers | REV-002 | 28,880 |
| 2025-07-01 | Payroll | Payroll operating cost | OPS-100 | -31,320 |
| 2025-07-01 | Marketing | Marketing operating cost | MKT-200 | -22,680 |
| 2025-08-01 | Subscription Revenue | Subscription Revenue from mid-market customers | REV-001 | 47,400 |
The finished example is generated from the sample dataset rather than an unrelated mockup or stock image.
Bin width 10,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 monthly and period-based trends |
| Revenue | Required for separate-column format | 18500 | Calculates total revenue |
| Expense | Required for separate-column format | 11200 | Calculates total expenses |
| Amount | Required for transaction format | 11200 | Stores the transaction value |
| Transaction Type | Required with Amount | Expense | Separates revenue and expense transactions |
| Category | Recommended | Marketing | Creates expense-category breakdowns |
| Department | Optional | Sales | Compares results by department |
| Region | Optional | North | Creates regional comparisons |
| Business Unit | Optional | Retail | Compares business units |
| Description | Optional | Monthly software fees | Adds transaction context |
| Currency | Recommended for multi-currency files | USD | Identifies transaction currency |
Total value of records classified as revenue.
Total value of records classified as expenses.
Difference between total revenue and total expenses.
Percentage of revenue consumed by expenses.
Month with the largest revenue total.
Month with the largest expense total.
Category responsible for the highest cost.
Percentage change from the previous month.
Percentage change from the previous month.
| Chart or Output | Required Fields | Business Question |
|---|---|---|
| Monthly Revenue and Expense Trend | Date, revenue, expense | Are income and costs moving in the right direction? |
| Revenue vs Expense Comparison | Period, revenue, expense | Which periods have the healthiest gap? |
| Net-Result Trend | Date, net result | Is financial performance strengthening or weakening? |
| Expense Category Breakdown | Category, expense | Which categories drive the most spending? |
| Department Comparison | Department, revenue, expense | Which departments contribute most to results? |
| Regional Comparison | Region, revenue, expense | How does performance vary by location? |
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 Result | Total revenue − total expenses | Revenue and expense fields | Do not label as formal net profit unless all accounting items are present. |
| Expense-to-Revenue Ratio | Total expenses ÷ total revenue × 100 | Revenue and expense fields | Do not calculate when revenue is zero. |
| Monthly Revenue Change | Current-month revenue − previous-month revenue | Date and revenue | Requires at least two valid periods. |
| Revenue Growth Percentage | Monthly revenue change ÷ previous-month revenue × 100 | Date and revenue | Do not calculate when previous-month revenue is zero. |
| Category Share | Category expenses ÷ total expenses × 100 | Category and expense | Uncategorized rows remain in totals but reduce category completeness. |
| Problem | Recommended Fix |
|---|---|
| Revenue and expenses stored in one unclassified column | Add a transaction-type column identifying revenue and expense rows. |
| Numbers stored as text | Remove currency symbols and spaces that prevent numeric analysis. |
| Repeated total rows | Remove subtotals and grand totals to prevent double counting. |
| Mixed date formats | Use one consistent date format. |
| Duplicate transactions | Review transaction IDs, dates, descriptions, and amounts. |
| Missing categories | Totals can still be produced, but category analysis will be incomplete. |
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.