A generic financial dashboard will not serve a cannabis operator. Under IRC Section 280E, the line between cost of goods sold and operating expense is not a presentation choice. For adult-use activity it decides what is deductible at all, so your dashboard has to render that split as a live figure rather than a year-end adjustment.
Since April 2026 there is a second split. State-licensed medical cannabis moved to Schedule III and left 280E behind. Adult-use did not. An operator running both now needs the dashboard to separate them too.
A cannabis financial dashboard exists to show you two things a standard one cannot: your real tax position and your real cash position. Both are distorted in this industry, and both move faster than a monthly close can track.
The tax position is distorted because IRC Section 280E disallows ordinary business deductions for adult-use activity. Only cost of goods sold survives, so how costs are classified drives the federal bill directly. A dashboard that shows gross margin without showing the COGS and operating expense split is hiding the number that matters most.
The cash position is distorted because banking access is limited, excise is remitted on its own schedule, and tax is payable on income that ordinary accounting would not treat as profit. A thirteen-week rolling forecast belongs on the dashboard rather than in a spreadsheet someone updates occasionally.
Last reviewed and updated: September 2026
The Core Problem
Why a Generic Dashboard Fails in Cannabis.
Most business intelligence templates assume a normal tax position. Revenue less cost of sales gives gross profit, operating expenses come off that, and what remains is taxable. In cannabis, two of those three steps break.
Operating expense is not deductible
For adult-use activity, IRC Section 280E disallows ordinary and necessary business deductions. Marketing, rent on retail space, administrative salaries and professional fees all fall outside.
So a dashboard showing net profit after operating expenses is showing a figure with no relationship to what you will owe. Taxable income sits much closer to gross profit.
The COGS line is the tax lever
Because cost of goods sold survives 280E, how a cost is classified changes whether it is deductible. That makes COGS a live financial control rather than an accounting formality.
A dashboard that aggregates all costs into one expense figure removes the single most consequential distinction in the business.
Cash and profit diverge further than usual
Tax is payable on income that ordinary accounting would not call profit. Excise is remitted on its own schedule. Banking constraints slow collection and complicate payment.
An operator can look profitable on paper and still run out of cash, which is why the cash view belongs beside the profit view rather than behind it.
Does your current reporting show the COGS split?If gross margin is one number with no breakdown behind it, the dashboard is hiding your tax position rather than reporting it. Have it reviewed →
The Differentiator
Rendering the 280E Position Live.
This is the section most dashboard guides skip, and it is the reason a cannabis operator needs a purpose-built one. Three figures belong on the front page.
| Metric | Why It Belongs on the Dashboard |
|---|---|
| COGS as a share of total cost | Shows how much of your spend is deductible against adult-use revenue. A falling ratio means a rising effective tax rate, and you want to see that inside the quarter rather than at filing. |
| Effective federal tax rate | Estimated from the actual COGS position rather than the statutory rate. For many adult-use operators the real figure is dramatically higher, and it drives every pricing decision. |
| Medical and adult-use revenue split | Since April 2026 the two sit under different federal regimes. Operators holding both licence types need the split visible, because it determines which costs get allocated where. |
| State position, where it differs | Several states decouple from 280E, so ordinary expenses deductible on the state return are disallowed federally. A single blended tax figure hides that entirely. |
| Tax accrual versus cash set aside | Under 280E the bill is larger than ordinary accounting suggests. Tracking accrual against reserved cash prevents the shortfall that catches operators at filing. |
State treatment varies considerably. New York decoupled at state level and New York City decoupled separately and retroactively, while other states follow the federal rule. See our cannabis tax rates by state guide for where each stands.
Holding both medical and adult-use licences?Two federal regimes, one set of shared costs, and no IRS default allocation method. The dashboard needs to show the split. Read the rescheduling guide →
The Build
What Belongs on the Dashboard.
Beyond the tax layer, five areas earn their place. Anything else is worth questioning, because a dashboard nobody reads is worse than no dashboard.
Sales performance
- Revenue by product category, so you can see which lines actually carry the business
- Revenue by location, which matters as soon as you run more than one site
- Average basket size, tracked as a trend rather than a snapshot
- Medical versus adult-use where both apply, since the tax treatment differs
Profit and loss
- Revenue, then cost of goods sold shown separately from operating expense
- Gross margin by product, because blended margin hides which items lose money
- Operating expense by category, flagged as non-deductible for adult-use activity
- Net position shown twice: book net profit, and taxable income under 280E
Pricing and profitability
- Break-even volume, recalculated when excise rates or costs change
- Margin per product after excise rather than before it
- Discount impact, since promotional pricing in a 280E business costs more than it appears to
Balance sheet
- Cash, inventory and fixed assets
- Liabilities including accrued tax, which is frequently understated in cannabis
- Debt-to-equity, particularly where the debt carries cannabis-sector pricing
The Metric That Prevents Failures
The Thirteen-Week Cash View.
Most cannabis businesses that fail do not fail because they were unprofitable. They fail because cash ran out while the profit and loss still looked acceptable. A thirteen-week rolling forecast is the single most useful thing on a cannabis dashboard.
Thirteen weeks works because it covers a full quarter of obligations, including an excise cycle and a tax payment, while staying short enough to forecast with real confidence rather than assumption.
What it needs to include
- Expected receipts by week, based on observed patterns rather than budget
- Inventory purchases, which in cannabis are usually paid before the product sells
- Excise remittance on its actual due dates rather than spread evenly
- Payroll, rent and fixed obligations
- Estimated tax payments calculated on the 280E position, not the book position
- The resulting low point, which is the number that actually matters
Update it weekly. A forecast refreshed monthly tells you about a problem after the point at which you could have acted on it.
Running a thirteen-week forecast today?If the answer is no, or it lives in a spreadsheet nobody has opened this month, that is the first thing to fix. See outsourced CFO services →
Where the Numbers Come From
Inventory and Seed-to-Sale Reconciliation.
Inventory is not just a working capital question in cannabis. It is the source of your cost of goods sold figure, which means it is the source of your only meaningful federal deduction for adult-use activity. Inventory accuracy and tax accuracy are the same problem.
What to track
- Stock levels by SKU, with reorder points that reflect actual lead times
- Inventory ageing, since slow-moving stock ties up cash that 280E already strains
- Expiry tracking for perishable categories, because written-off stock is lost margin
- Turnover by category, which tells you where the working capital is genuinely working
- Variance between seed-to-sale records and the general ledger, reconciled monthly
That last item is the one operators skip and regulators check. When the tracking system and the books disagree, the problem is almost never the software, and an unexplained variance is difficult to defend in either a regulatory inspection or a tax examination.
Worth the Effort
Customer Metrics in a 280E Business.
Retention metrics matter more in cannabis than in almost any other retail sector, and the reason is tax rather than marketing.
Marketing and advertising spend is an operating expense. For adult-use activity, IRC Section 280E disallows it federally. So every dollar spent acquiring a customer costs a cannabis operator more after tax than the same dollar costs a business in any other industry.
Retention spend is not automatically better treated, but the arithmetic still shifts. When acquisition carries a higher after-tax cost, the return on keeping an existing customer rises relative to winning a new one. That makes customer lifetime value a tax-informed metric rather than a marketing vanity number.
What to put on the dashboard
- Repeat purchase rate, which is the cleanest single measure of retention
- Customer lifetime value, modelled against after-tax contribution rather than revenue
- Customer acquisition cost, with the 280E treatment noted beside it
- Churn, tracked by cohort so you can see whether a change actually worked
- Basket composition, since attachment rates move margin more cheaply than discounting does
Spending on acquisition without tracking retention?In a 280E business that is an expensive way to stand still, because the spend is not deductible for adult-use. Model the difference →
Tools and Setup
Building One That Gets Used.
Accounting platform, point of sale, and seed-to-sale tracking. All three feed the dashboard, and gaps between them are where errors hide.
No visualisation tool can separate COGS from operating expense if the underlying ledger does not. Structure comes before software.
Power BI, Tableau or a well-built spreadsheet all work. The best tool is the one someone on your team will actually keep current.
A dashboard requiring manual updates becomes stale within weeks. Schedule the refresh and check that it ran.
Cash low point, COGS ratio, gross margin by category, effective tax rate, inventory turnover. Add more only once those get used.
Someone reviews it weekly and acts on it, or it becomes decoration. That role usually sits with a CFO rather than a bookkeeper.
GreenGrowth CPAs has built reporting for vertically integrated operators running across multiple dispensary locations, covering sales trends, operational cost visibility, break-even analysis and real-time expense tracking.
Dashboard showing the wrong tax position?
If it reports net profit after operating expenses, it is showing a number your adult-use return will not recognise.
Before You Build
The Readiness Checklist.
Confirm these before choosing a tool
- Chart of accounts separates cost of goods sold from operating expense at entry
- Medical and adult-use activity are distinguishable where both apply
- Point of sale reconciles to seed-to-sale, and both reconcile to the ledger
- Excise is tracked as a liability rather than netted into revenue
- Someone owns the monthly close and it happens on a fixed date
- Tax accrual is calculated on the 280E position rather than book profit
- One person is accountable for reviewing the dashboard and acting on it
Any item you cannot tick is a data problem, and a dashboard built on top of it will report the problem faithfully rather than solve it.
Common Questions
Cannabis Dashboard FAQs.
What makes cannabis different
Why can't I use a standard financial dashboard?
Standard templates assume operating expenses are deductible, and for adult-use cannabis they are not. IRC Section 280E disallows ordinary business deductions, leaving cost of goods sold as the only meaningful federal deduction. A dashboard reporting net profit after operating expenses is therefore showing a figure with no relationship to taxable income. A cannabis dashboard has to separate cost of goods sold from operating expense as a headline metric, and show taxable income under 280E alongside book profit.
Does 280E still apply after the 2026 rescheduling?
It depends on licence type. The April 2026 order moved state-licensed medical cannabis to Schedule III, ending 280E for those operations. Adult-use cannabis remains Schedule I and stays fully subject to it. An operator holding both licence types now runs two federal regimes at once, which means the dashboard needs to show medical and adult-use revenue separately and support allocating shared costs between them. The IRS has published no default allocation method, so the basis you use has to be documented.
What is the single most important metric?
The thirteen-week cash low point, for most operators. Cannabis businesses rarely fail because of a bad profit and loss; they fail because cash ran out while the profit and loss still looked fine. Tax payable on income that ordinary accounting would not call profit makes that gap wider here than in other industries. Second place goes to cost of goods sold as a share of total cost, because that ratio drives the federal tax bill directly and moves without anyone noticing.
Building and maintaining it
What software should I use?
Power BI, Tableau and similar tools all work, and several accounting platforms offer built-in reporting that may be sufficient at smaller scale. Tool choice matters far less than data structure. No visualisation layer can separate cost of goods sold from operating expense if the underlying chart of accounts does not, so fix the ledger first. The second consideration is maintenance: pick something your team will keep current rather than the most capable option nobody updates.
How often should the dashboard refresh?
Daily for sales and inventory, weekly for the cash forecast, monthly for the full profit and loss and balance sheet once the close is done. Real-time sounds attractive but adds little for most operators, since the decisions the dashboard supports are not made hourly. What matters more is that the refresh is automated and that someone checks it ran, because a stale dashboard is worse than none: it produces confident decisions from outdated numbers.
Can a dashboard help with tax compliance?
Indirectly, and usefully. It does not file anything, but tracking the cost of goods sold ratio, accrued tax and the medical versus adult-use split throughout the year means the position at filing is a confirmation rather than a discovery. It also surfaces the problem early enough to act on. An operator who sees the effective tax rate climbing in month four can adjust cost classification or pricing, where one who finds out in month fourteen cannot.
Metrics and interpretation
What margins should a cannabis business expect?
Benchmarks circulate widely but vary enormously by state, licence type and position in the supply chain, so treat any published figure with caution. State excise rates alone create large differences: an operator in a market with a 15 percent excise faces a materially different margin structure from one at 13 percent with no sales tax on top. Rather than benchmarking against a national average, track your own margin by product and by month and manage the trend. That is the number you can actually influence.
Why track customer retention on a financial dashboard?
Because the economics differ here for a tax reason. Marketing and advertising are operating expenses, and for adult-use activity 280E disallows them federally. So acquiring a customer costs a cannabis operator more after tax than it costs a business in any other industry. That shifts the return on retaining an existing customer relative to winning a new one, which makes customer lifetime value and repeat purchase rate financial metrics rather than marketing ones.
Do I need a CFO to run a dashboard?
You need someone who acts on it. Building the dashboard is a data exercise; interpreting a rising cost of goods sold ratio, a narrowing cash low point or a margin shift by category is judgement work. Most operators at this stage cannot justify a full-time finance executive, which is where fractional or outsourced CFO support fits. The distinction worth understanding is that a bookkeeper records what happened and a CFO changes what happens next.
Still have a question this page did not answer?Ask it directly. A cannabis CPA reads every enquiry and you get a straight answer either way. Ask a cannabis CPA →
This guide is general information, not advice for a specific situation. Tax treatment depends on licence type, state and facts we have not seen. Confirm your position with a CPA before relying on any figure in a filing.
Related
More From GreenGrowth CPAs.
Reporting sits within accounting and financial services and outsourced CFO services, alongside tax planning and compliance. For the sector practice, see cannabis CPA services, with state guidance for New York, Minnesota, and Delaware.
Build Reporting That Shows the Real Numbers.
Tell us what you currently report on, which licence types you hold, and where the reporting falls short. We will come back with what to change and what the 280E position actually looks like.
Talk to a Cannabis CPAGet more GreenGrowth CPAs insights in Google Search and AI Mode.
