Running a small business produces a lot of numbers.
Sales.
Expenses.
Invoices.
Bank balances.
Inventory.
Payroll.
Taxes.
The challenge isn't collecting more numbers. It's knowing which ones deserve your attention.
You don't need to become an accountant to develop a better understanding of your business. But having a consistent monthly review can help you see changes earlier, ask better questions and make decisions with more information.
Here are seven numbers worth reviewing every month.
1. Total Revenue
Start with the simplest question:
How much did the business sell this month?
Compare the number with:
- last month
- the same month last year, if available
- your monthly target
- your recent average
One month by itself tells you very little.
The trend is usually more useful.
If sales are changing, the next question is why.
Was it seasonality?
A new customer?
A lost account?
Higher prices?
More transactions?
A spreadsheet makes those comparisons much easier to see over time.
2. Direct Costs
Revenue isn't the same as profit.
If your business sells products, materials or services that have direct costs attached to them, track those costs separately.
Depending on the business, that may include:
- inventory purchased for resale
- materials
- subcontracted labor
- shipping
- direct production costs
Knowing what it costs to produce the revenue gives the sales number much more meaning.
3. Gross Profit
Gross profit is generally the amount remaining after subtracting direct costs from revenue.
For example:
Revenue: $20,000
Direct costs: $8,000
Gross profit: $12,000
Tracking this month after month can help you identify changes in pricing, purchasing costs or margins that might not be obvious from revenue alone.
A company can increase sales while making less money on each sale.
That's why revenue should never be the only number you watch.
4. Operating Expenses
Next, look at what it costs to keep the business running.
Common operating expenses can include:
- rent
- utilities
- advertising
- insurance
- office expenses
- software
- vehicle expenses
- professional services
- payroll and related costs
- equipment
- subscriptions
Compare expenses by category rather than looking only at the total.
If one category begins increasing month after month, you'll be able to investigate it before it simply becomes part of the normal budget.
5. Net Profit or Loss
After accounting for revenue and applicable expenses, what did the business actually earn?
This is one of the most important differences between:
“We had a good sales month.”
and
“We had a profitable month.”
Those statements are not always the same.
A simple monthly profit-and-loss view can make that distinction much easier to see.
6. Accounts Receivable
If you invoice customers, keep an eye on the amount that has been billed but not yet collected.
A useful monthly review includes:
- total outstanding invoices
- invoices currently due
- overdue invoices
- oldest unpaid invoice
- amount collected during the month
A profitable business can still experience cash-flow pressure when too much money remains tied up in unpaid invoices.
Knowing what is outstanding gives you a chance to follow up before old invoices become even older.
7. Cash Flow
Finally, look at the actual movement of cash.
How much came in?
How much went out?
And what changed your cash position during the month?
Profit and cash flow are related, but they are not identical.
A business may have recorded revenue that hasn't been collected yet, purchased inventory that hasn't been sold, paid an annual expense, bought equipment or experienced other timing differences.
That is why reviewing cash flow alongside profit provides a more complete picture.
You Don't Need to Watch Everything Every Day
One of the easiest ways to make financial tracking overwhelming is trying to monitor every possible number constantly.
You don't need to.
For many small businesses, a structured monthly review is a much more realistic starting point.
Choose a consistent date.
Update your records.
Review the seven areas.
Make notes about anything unusual.
Then ask:
What changed?
Why did it change?
Does anything need my attention next month?
That's the real purpose of the numbers.
Not to create more paperwork.
To help you understand what's happening in the business.
Spreadsheets Can Make the Review Easier
You can build this process yourself in Excel, or use individual worksheets designed for the different jobs.
Bay Area Spreadsheets offers accounting and business-management workbooks for journals, ledgers, expenses, profit-and-loss reporting, cash flow, invoicing and other day-to-day financial records.
If you're just beginning, start small.
You don't need an entire accounting system on the first day.
Use the tool that answers the question you have now, then expand your tracking when the business requires it.
Explore the Accounting Spreadsheet Systems
Or, if you want to see the spreadsheet style before purchasing anything:
Try the Free Spreadsheet Introduction Toolkit
The free toolkit currently includes a basic invoice, monthly bill tracker and time-log tracker, giving a new visitor a low-risk way to experience your spreadsheets before considering a larger system.
Spreadsheet tools can help organize financial records, but they do not replace professional accounting, tax, legal or financial advice.