Calculating Sales Growth: Essential Guide
You check your bank account after a strong month and feel relieved. Then the next month lands flat, a client delays payment, and suddenly it looks like the business is slipping.
That cycle is common for freelancers, consultants, small agencies, and micro-businesses. The problem isn't only uneven income. It's that individuals in these roles often try to judge growth from scattered invoices, a spreadsheet they update late, and whatever the bank balance happens to show that day. That doesn't tell you whether demand is improving, whether your pricing is working, or whether you're seeing a normal dip between projects.
Calculating sales growth helps, but only if you use the right comparison. For businesses with project-based income, a basic month-to-month view can create more confusion than clarity. A simpler system, with cleaner historical records than Excel usually provides, gives you a much more honest read on progress.
Table of Contents
- Why 'More Money This Month' Isn't a Growth Strategy
- Foundational Sales Growth Calculations
- Beyond Monthly Numbers with Period-Over-Period Growth
- The Freelancer's Secret Weapon The Rolling Average
- How to Turn Growth Data Into Actionable Insights
- Automate Your Sales Tracking with MicroCRM
Why 'More Money This Month' Isn't a Growth Strategy
A freelance photographer might bill heavily during holiday season, then hit a quiet January. A consultant might close two large projects in one month and spend the next month delivering the work instead of selling. A designer can look “up” one month and “down” the next while the underlying business is perfectly healthy.
That's why “more money this month” isn't a strategy. It's a snapshot. Snapshots are emotional. Growth tracking needs context.
The most misleading habit is checking one recent number and treating it like a verdict. If a payment lands early, the month looks great. If an invoice gets paid a few days late, the month looks weak. Nothing about your client quality, pricing, or demand has necessarily changed.
Practical rule: Don't confuse cash timing with business momentum.
For freelancers and micro-businesses, this matters even more because revenue often arrives in lumps. One big project can distort a whole month. One slow patch can make you question pricing, outreach, or your niche when the underlying problem is timing.
A better approach starts with two questions:
- What period am I comparing so the numbers are fair?
- What type of revenue am I counting so the result reflects real sales performance?
When those two points are unclear, spreadsheets become traps. You can still do the math, but the answer won't guide a useful decision.
Foundational Sales Growth Calculations
The standard formula is simple. Sales growth = ((Current Period Sales − Previous Period Sales) ÷ Previous Period Sales) × 100. Salesforce uses that exact formula and shows that if net sales rise from $500,000 to $600,000, the result is 20% sales growth in its guide to calculating sales growth rate.
What counts as sales
Use net sales, not gross sales. That means the number should exclude returns, allowances, and discounts. If you mix gross figures in one period and net figures in another, the formula still produces a percentage, but it won't describe reality.
That sounds obvious, but many small businesses encounter difficulties here. One spreadsheet tab includes issued invoices. Another includes paid invoices. A third subtracts refunds manually. By the time you compare periods, you're no longer comparing like with like.
A clean sales record should answer these questions:
- Which dates count: invoice date, payment date, or service delivery date
- Which deductions apply: discounts, refunds, credit notes
- Which sales belong in the period: only completed sales, not tentative pipeline value
How to run the formula correctly
Here's the practical flow:
- Pick one fixed period. Month, quarter, or year all work.
- Pull net sales for the current period.
- Pull net sales for the matching previous period.
- Apply the formula once, without mixing definitions.
If your business generated less than the prior period, the result is negative. If it generated more, the result is positive. That's the basic signal.
A historical example often cited in sales writing compares prior period sales of 9.75 billion with current period sales of 10.1 billion, which comes out to exactly 3.5% growth using the same formula, as shown in Salesforce's article above.
The formula is easy. The discipline is in using the same revenue definition every time.
If you want a cleaner workflow than a patchwork workbook, it helps to keep contacts, deals, and invoices tied together from the start. That's also why many small operators eventually move away from manual sheets and into simpler systems. If you want more ideas on organizing the underlying records before you calculate growth, Micro CRM's small business blog archive is a useful place to browse.
Beyond Monthly Numbers with Period-Over-Period Growth
Month-over-month growth looks precise, but for a freelancer it can be wildly misleading. One month reflects closing work. The next reflects delivering it. The cash pattern jumps around even when demand is steady.
Why MoM can distort reality
The biggest issue with MoM is that it overreacts to timing. A photographer can have a strong wedding season, then a softer period immediately after. A consultant can invoice at project kickoff rather than evenly across the work. In both cases, the business may be stable, but MoM swings make it look erratic.
That's why standard advice often fails smaller operators. monday.com notes that for freelancers with irregular revenue, standard month-over-month comparisons are often misleading, and that rolling 12-month averages or same-period year-over-year comparisons give a better measure of business health in its article on how to calculate sales growth.
Which comparison works better
A more useful way to compare periods depends on what you're trying to learn.
| Comparison | Best use | Main problem |
|---|---|---|
| MoM | Spot short-term shifts | Too sensitive to timing |
| QoQ | Review broader momentum | Still affected by seasonality |
| YoY | Compare similar business conditions | Slower to show recent changes |
If your work is seasonal or project-based, YoY is usually the fairest test because it compares like with like. January this year versus January last year is a real comparison. December versus January often isn't.
A simple record system matters here. If your client history, invoices, and deal notes are stored in one place, same-period comparisons become much easier. That's where a lightweight tool like MicroCRM can help. It keeps the history intact so you're not rebuilding the past from old email threads and scattered spreadsheets.
The Freelancer's Secret Weapon The Rolling Average
The most useful number for many freelancers isn't last month's revenue. It's the trend line underneath it.
How a rolling average reduces noise
A rolling average smooths out the sharp peaks and dips that come with project-based work. Instead of treating one unusually good month as proof of growth, or one weak month as failure, you average a set of recent periods and watch the direction.
That makes it easier to answer practical questions:
- Is demand improving across the last stretch of work?
- Are larger projects becoming more common
- Is revenue quality getting better, even if month-to-month cash flow is messy?
For irregular businesses, this is often the first metric that feels calm enough to trust.
A rolling average won't remove volatility from the business. It removes volatility from your interpretation.
monday.com makes the same point in its sales growth guidance. For creative freelancers with uneven income, rolling 12-month averages or same-period year-over-year comparisons are more effective than standard MoM checks for understanding business health, as noted in its article linked earlier.
A simple way to calculate it
You don't need advanced forecasting software to start. Use a 3-month, 6-month, or 12-month rolling view.
A practical method looks like this:
- List revenue by month in date order.
- Add the most recent set of months you want to average.
- Divide by the number of months in that set.
- Move forward one month and repeat.
A shorter rolling average reacts faster. A longer one gives a steadier picture. If your business is very seasonal, the longer view is usually more honest.
This walkthrough is helpful if you want to see the concept in action:
If you work with only a modest number of clients, keeping these records inside a simple CRM beats maintaining multiple spreadsheet tabs. You can still export data when needed, but your base numbers stay cleaner.
How to Turn Growth Data Into Actionable Insights
A freelancer has a strong March, a quiet April, then lands one large project in May. On paper, growth looks erratic. In practice, the question is simpler: which part of the business is producing steady demand, and which part is creating noise?
That is the point where growth data becomes useful. Revenue percentages matter, but only when they lead to a decision on pricing, retention, capacity, or follow-up.
What flat growth is telling you
Flat growth rarely has one cause, especially in a project-based business. A full month can hide weak pricing. A good close rate can hide a shrinking average project value. Steady inbound interest can still produce uneven cash flow if proposals sit too long before follow-up.
Use growth numbers as a prompt to inspect the operating pattern behind them:
- Healthy pipeline, flat revenue: pricing may be overdue for review
- Projects closing, but revenue stalls: smaller jobs may be replacing higher-value work
- Good demand, uneven results: follow-up speed or proposal consistency may be the issue
- Strong sales months, no real lift over time: delivery capacity may be limiting what the business can take on
For freelancers and micro-businesses, this matters more than it does in larger firms with predictable deal flow. One delayed client decision or one oversized invoice can distort a month. Looking at revenue alone can push you toward the wrong fix.
Track two views at once: what closed, and what is likely to close.
Use pipeline data with past revenue
Historical growth shows the result. Pipeline data shows the next likely pressure point.
Together, they support better decisions:
- Raise rates when demand stays steady and your active pipeline remains full
- Focus on retention when repeat clients are carrying the most stable revenue
- Change outreach when new opportunities are too thin at the top of the funnel
- Review delivery limits when closed work is strong but lead times or workload are stretching out
- Check your data handling when client records, invoices, and sales notes sit in one system. Review your data processing practices before small admin shortcuts become a risk
The practical goal is not perfect forecasting. It is fewer bad decisions based on noisy months.
If revenue is up but your pipeline is getting thinner, that is not momentum. It may be a temporary spike. If revenue is flat while your pipeline quality improves, that can be a stronger sign than the monthly total suggests. This is why I prefer simple tracking that combines closed revenue, open deals, average project value, and follow-up status in one place. Small businesses do not need more dashboards. They need a cleaner read on what to do next.
Want to better organize your clients and business opportunities?
👉 Try MicroCRM for free
Automate Your Sales Tracking with MicroCRM
Spreadsheets work for a while. Then they become a second job.
Why spreadsheets break down
The issue isn't that Excel is bad. It's that manual systems depend on memory and discipline. You have to enter invoices, update deal stages, clean duplicates, and remember which tab holds the “real” number. One missed step and your growth calculation starts from the wrong baseline.
MicroCRM is better suited to small businesses that want clarity without enterprise overhead. It keeps contacts, deals, invoices, follow-ups, and appointments in one interface, with a visual Kanban pipeline and integrated invoicing. That means less time rebuilding reports and more time understanding what the business is doing.
For freelancers and micro-businesses, the main benefit is simplicity:
- Easy setup: you can start using it without a long implementation cycle
- Centralized records: client history and invoice data stay connected
- Built-in follow-up tools: automated emails reduce dropped opportunities
- No unnecessary features: the product stays focused on the basics most small operators use
Where CAGR fits
When you want a longer view, CAGR is more useful than a stack of annual percentages. Metrics Watch defines it as [(Ending Value ÷ Beginning Value)^(1 ÷ Number of Years)] − 1 and gives an example of revenue rising from $10 million in 2013 to $70 million in 2023, which produces a CAGR of approximately 70% in its article on the sales growth rate formula.
For a freelancer or small business, the takeaway is simple. Use basic period growth for near-term visibility, and use CAGR when you want to understand the long arc of the business. A tool like MicroCRM makes both easier because the data is already structured.
Manage clients, deals, and invoices in one platform.
Start for free. No credit card required.