Current Month Performance
Selected monthCurrent Month Expense Breakdown
Selected monthTop 5 Expenses
Selected monthTop 5 Expense Deep Dive
Selected monthTop 5 Expense Categories
Selected monthSelected Top Expense Breakdown
Gross Profit vs Nett Profit
Both values shown in randAdvanced OPEX & Nett Profit Analytics
Completed-month averages exclude the current monthGP, OPEX & Nett Profit Trend
All three values shown in rand; margin percentages are shown separately belowMargin Trend
GP%, Nett Profit % and 8% targetPerformance Status
Expenses to Review
Break-even Insight
Largest Month-to-Month Fluctuations
Maximum rand movement by expenseIncreasing vs Decreasing Expenses
Average monthly rand movementGradually Increasing Expenses
Negative trend requiring review| Expense | Monthly Trend % | Avg Monthly Change | Latest Change | Status |
|---|
Decreasing or Stable Expenses
Positive or controlled movement| Expense | Monthly Trend % | Avg Monthly Change | Latest Change | Status |
|---|
Nett Profit Budget & Expense Tracker
Strict approved monthly budgets — 8% nett profit targetTarget Monthly OPEX CeilingR 0.00
Current Month OPEXR 0.00
Required OPEX ReductionR 0.00
Projected Nett Margin0.0%
| Expense | Current Amount | Monthly Budget | Budget Share % | Budget Variance | Exceeded % | Recommended Reduction | Reduction % | Priority |
|---|
Current Month’s Expense Detail and Comparison
Daily snapshots for the selected current monthDaily history is recorded whenever the live dashboard refreshes.
| Expense | From Day | To Day | Daily Movement | % Change |
|---|
Daily Difference Audit
Compare day-to-day OPEX movements against the Daily OPEX Detail sheet
Defaults to the two most recent completed historical dates before the latest snapshot.
Manually replaces today’s Daily OPEX History snapshot with the live current-month expense values.
Select a date range, then run an audit. Every consecutive day-to-day movement inside the range will be checked.
| Expense | Day-to-Day Difference | Column F Total | Unexplained Variance | Coverage % | Status | Detail |
|---|---|---|---|---|---|---|
| Run an audit to compare the selected dates. | ||||||
Daily OPEX Detail & Reconciliation
Drill down into every daily expense addition from the Daily OPEX Detail sheetExpense Detail by Category
Filtered amount and OPEX shareDaily Expense Additions
Filtered detailed additions by dateExpense Summary
Sort by amount, percentage of OPEX, variance or reconciliation| Expense | Detailed Amount | Stated Addition | Variance | % of OPEX | Groups | Reconciliation |
|---|
Individual Expense Breakdown
Exact items entered on the Daily OPEX Detail sheet| Date | Month | Expense | Expense Detail | Expense Amount | Daily Total | Variance | % of OPEX | Reconciled |
|---|
Month-to-Month Comparison
Choose two months below-R 0.00
From Month
To Month
Monthly OPEX Trend
All monthsTop Expense Variances
Selected comparisonTop 5 Expenses — Compare From
Month ATop 5 Expenses — Compare To
Month BMonth to Month Expense Detail Comparison
Uses the month-to-month comparison selections| Expense | Selected Month | Previous Month | Movement | % Change | FY Avg | Variance Compare |
|---|
Monthly Summary
OPEX, GP and Nett Profit reconciliation| Month | Sales | Purchases | GP | GP % | Total OPEX | Nett Profit | Nett Profit % | GP % Movement | Nett % Movement | OPEX Movement |
|---|