Monthly revenue and expenses: a worked example
12 synthetic records. One reporting currency. Free to download.
- Total revenue
- 157,000
- Total expense
- 103,000
- Revenue minus expense
- 54,000
Monthly revenue and expenses
Synthetic sample (2026): values reconcile to the CSV
View all 12 source rows
| Date | Department | Revenue | Expense |
|---|---|---|---|
| 2026-01-01 | Sales | 12,000 | 8,000 |
| 2026-01-01 | Operations | 8,000 | 7,000 |
| 2026-02-01 | Sales | 13,000 | 8,500 |
| 2026-02-01 | Operations | 9,000 | 7,000 |
| 2026-03-01 | Sales | 14,000 | 9,000 |
| 2026-03-01 | Operations | 10,000 | 7,500 |
| 2026-04-01 | Sales | 16,000 | 9,500 |
| 2026-04-01 | Operations | 11,000 | 8,000 |
| 2026-05-01 | Sales | 18,000 | 10,000 |
| 2026-05-01 | Operations | 12,000 | 8,500 |
| 2026-06-01 | Sales | 20,000 | 11,000 |
| 2026-06-01 | Operations | 14,000 | 9,000 |
To turn a monthly revenue and cost breakdown into visuals, use one row per month and department, numeric Revenue and Expense columns, and a consistent Date column. Compare income and costs on a trend chart, then review their difference separately. A total alone cannot show whether costs are rising faster than revenue.
Start with the free monthly revenue and expense CSV. It contains 12 rows: two departments across January to June 2026. Open it in Excel, or use the CSV directly. See the revenue and expense dashboard for field requirements and a broader interactive example.
1. Prepare the monthly spreadsheet
Keep the header row as Date, Department, Revenue, Expense. Use dates such as 2026-01-01 rather than ambiguous labels such as 01/02. Keep currency symbols out of numeric cells and use a single reporting currency. Revenue and expense values in this sample are positive; Expense is subtracted once when calculating the net result.
Do not mix transaction rows with monthly totals, or leave a grand-total row at the bottom: summing both double-counts the same activity. If your source already contains one total per month, leave Department out rather than inventing a breakdown. If it contains signed transaction amounts instead, establish a transaction-type mapping before comparing it with this separate-column example.
2. Choose graphs that answer different questions
- Monthly revenue versus expenses: two lines or grouped columns, using the same month axis and currency scale.
- Monthly net result: Revenue minus Expense for each month. Retain negative values rather than truncating the axis.
- Department costs: a bar chart of summed expenses per department. Do not compare this six-month total with a single month's budget.
For a snapshot report, upload the CSV or an .xlsx copy to the Excel dashboard creator. Check the detected headers and numeric fields, then follow the report purchase or subscription flow. Review the generated metrics against the file before sharing. The upload is a snapshot; changing the original spreadsheet does not establish a live sync.
3. Reconcile the sample results
| Measure | Expected result | Calculation |
|---|---|---|
| Revenue | 157,000 | Sum of the Revenue column |
| Expenses | 103,000 | Sum of the Expense column |
| Net result | 54,000 | Revenue minus expenses |
| January revenue | 20,000 | 12,000 Sales plus 8,000 Operations |
| June revenue | 34,000 | 20,000 Sales plus 14,000 Operations |
June revenue is 70% above January: (34,000 - 20,000) / 20,000. Expenses increase from 15,000 to 20,000, or about 33.33%. This shows a widening difference in this sample; it does not explain the cause. Use department records and business context to investigate what changed.
4. Avoid turning a simple net result into accounting profit
The 54,000 difference is only revenue less the expenses supplied. It is not automatically net income, cash flow, or tax-adjusted profit. For an accounting view, include and define the required COGS and operating-cost fields in a profit and loss dashboard. For spending control, follow the budget versus actual tutorial.
5. Share a report that someone else can verify
State the reporting period, currency, exclusions, and whether figures are actuals or estimates. Keep the source sample with the report. A spreadsheet visualization tool can speed up the first visual draft, but the final check is whether another reader can reproduce its totals. Use Excel-to-PowerPoint reporting when your plan includes presentation exports.
Example scope: The downloadable data is synthetic, not a customer case study. It demonstrates calculations, not a guarantee that every uploaded file produces the same charts. Review the privacy policy before uploading business records. Sample files and public examples are free; generating your own report requires a $2 one-time unlock or an eligible subscription. PDF and PowerPoint exports require a plan that includes them.