Reporting Period
- Requirement
- Required
- Example
- 2026-06
- Purpose
- Groups values by month or period
Upload a structured profit and loss statement to visualize revenue, cost of goods sold, gross profit, operating expenses, operating profit, and net results.
VizMint converts account-level or monthly P&L data into management-ready KPIs and charts while keeping calculation requirements and limitations visible.
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.
Profit and Loss Dashboard
Interactive preview from the sample P&L dataset
Switch preview
Total Records
72
rows in sample
Total Signed Amount
791,742
sum of Signed Amount
Total Amount
4,127,456
sum of Amount
Bin width 20,000 · 72 observations
Full dashboard with all KPI details and 6 charts is on the demo page.
Open full demoThe sample uses account-level P&L rows with reporting period, account category, subcategory, amount, department, and business unit fields. Charts and KPI cards are generated from the same JSON dataset.
Sample totals from 72 records: $2,459,599 revenue, $748,790 COGS, 69.6% gross margin, $919,067 operating expenses, and $791,742 operating profit.
Turn an income statement into a management view of revenue, COGS, gross margin, operating expenses, and net result.
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 monthly P&L sample produces $2,459,599 revenue, $748,790 COGS, 69.6% gross margin, $919,067 operating expenses, and $791,742 operating profit.
The workflow is designed around clear field requirements, visible formulas, reproducible sample data, and results that reconcile to the spreadsheet.
A profit and loss statement is essential for understanding business performance, but a long account table can hide the movements that matter most. A visual P&L dashboard makes it easier to compare revenue, direct costs, overhead, and profit across periods.
Use the dashboard to review margins, identify fast-growing expenses, compare departments, and prepare monthly management or board reporting.
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.
| Reporting Period | Account Subcategory | Account Code | Department | Signed Amount |
|---|---|---|---|---|
| 2025-07-01 | Product Sales | 4100 | Sales | 94,772 |
| 2025-07-01 | Subscription Revenue | 4101 | Product | 68,628 |
| 2025-07-01 | Cost of Goods Sold | 5100 | Operations | -50,654 |
| 2025-07-01 | Payroll | 6100 | Operations | -35,948 |
| 2025-07-01 | Marketing | 6200 | Marketing | -16,340 |
The finished example is generated from the sample dataset rather than an unrelated mockup or stock image.
Bin width 20,000 · 72 observations
VizMint works best when every column has one clear heading and each row represents one consistent record.
| Column | Requirement | Example | Purpose |
|---|---|---|---|
| Reporting Period | Required | 2026-06 | Groups values by month or period |
| Account Category | Required | Revenue | Maps values to the P&L structure |
| Account Subcategory | Recommended | Product Sales | Creates more detailed analysis |
| Amount | Required | 45000 | Stores the financial value |
| Department | Optional | Operations | Enables departmental P&L views |
| Business Unit | Optional | SaaS | Enables business-unit comparison |
| Currency | Recommended | USD | Identifies currency |
| Actual/Budget Type | Optional | Actual | Enables comparison when both datasets exist |
Total operating revenue in the selected period.
Direct costs associated with delivered products or services.
Revenue remaining after COGS.
Gross profit as a percentage of revenue.
Indirect expenses required to run the business.
Gross profit after operating expenses.
Result after other income and expenses.
Net profit as a percentage of revenue.
| Chart or Output | Required Fields | Business Question |
|---|---|---|
| Monthly Revenue Trend | Period, revenue | Is top-line performance growing? |
| Gross-Profit Trend | Period, revenue, COGS | Are direct costs affecting profit? |
| Expense Composition | Expense subcategory, amount | Which expenses make up the largest share? |
| P&L Waterfall | Revenue, COGS, operating expenses, other items | How does revenue become net profit? |
| Margin Trend | Period, gross margin, net margin | Are margins improving? |
| Department P&L | Department, account category, amount | Which departments contribute most to profit or cost? |
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 |
|---|---|---|---|
| Gross Profit | Revenue − cost of goods sold | Revenue and COGS | Cannot be calculated when COGS is unavailable. |
| Gross Margin | Gross profit ÷ revenue × 100 | Revenue and COGS | Do not calculate when revenue is zero. |
| Operating Profit | Gross profit − operating expenses | Revenue, COGS, operating expenses | Other income and expenses remain outside operating profit. |
| Net Profit | Operating profit + other income − other expenses | Complete P&L categories | Tax and interest must be classified correctly. |
| Net-Profit Margin | Net profit ÷ revenue × 100 | Revenue and net profit | Do not calculate when revenue is zero. |
| Problem | Recommended Fix |
|---|---|
| Inconsistent account names | Normalize variations such as Payroll, Salaries, and Wages. |
| Revenue and expenses mixed in one category | Map every account to a clear P&L category. |
| Negative values used inconsistently | Apply one sign convention for income and expenses. |
| Blank reporting periods | Add a valid month, quarter, or date. |
| Totals included with detail rows | Remove totals to prevent double counting. |
| Different currencies combined | Convert values first or keep them separated. |
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.