Understanding your business finances should not require an accounting degree.
These free small business financial tools are designed to help you understand profit, cash flow, margins, collections, costs, and financial warning signs in plain language.
They accompany the book Know Your Numbers by Mark Williams, but you can begin using them even if you have not read the book yet.
Choose the complete companion workbook for the full system, or start with the Smart Monthly Business Dashboard for a simpler monthly review.
The complete set of financial examples, worksheets, and decision tools from Know Your Numbers.
Use it to trace profit to cash, understand your financial statements, evaluate business decisions, and apply the lessons from the book to your own numbers.
A simpler tool for tracking the numbers that matter each month.
Enter a small set of financial figures and the dashboard automatically calculates margins, collection days, cost ratios, cash performance, and warning signals.
Know Your Numbers - Companion Workbook
The Know Your Numbers Companion Workbook is the complete practical resource for the book.
It includes examples from Burn Rate Candle Co., the fictional business followed throughout the manuscript, along with blank tools you can use for your own company.
A guided introduction and workbook map
Burn Rate Candle Co.’s financial examples
A profit-to-cash bridge
Simplified financial statement inputs
A monthly business dashboard
Contribution analysis for products, clients, and sales channels
A keep, drop, or reprice decision tool
A growth return and timing calculator
Plain-English financial definitions
One of the most important lessons in Know Your Numbers is that profit and cash are not the same thing.
The completed Burn Rate Candle Co. example shows how:
$42,000 of reported profit
Became negative $9,000 of operating cash flow
After inventory, receivables, payables, and depreciation
And ultimately became $12,000 of ending cash after investing and financing activity
You can change the example numbers, follow the formulas, and then use the blank version to trace the cash in your own business.
The workbook can help you explore questions such as:
Why does my profit not match my bank balance?
Where is my cash currently tied up?
Which financial numbers deserve my attention?
Is a product, client, or sales channel worth keeping?
What costs would actually disappear if I stopped offering something?
Will a new machine, hire, or expansion pay for itself?
Can the business survive the timing of that investment?
What warning signs are appearing in my numbers?
The workbook does not make the decision for you. It organizes the information so you can see the decision more clearly.
Know Your Numbers - Monthly Dashboard
The Smart Monthly Business Dashboard turns your financial reports into a simple monthly operating habit.
Instead of manually calculating every ratio, enter a small set of finalized monthly figures and let the dashboard calculate the rest.
Revenue
Direct costs or cost of goods sold
Net profit
Ending cash
Accounts receivable
Inventory or direct labor
Two major controllable costs
Cash generated by operations
Gross margin
Net margin
Accounts receivable days
Inventory pressure for product businesses
Direct labor percentage for service businesses
Major costs as a percentage of revenue
Operating cash margin
Profit-to-cash conversion
Monthly warning points
A plain-English financial insight
Select whether your company is primarily a product or service business.
For a product business, the dashboard focuses on inventory relative to recent sales.
For a service business, it focuses on direct labor as a percentage of revenue.
You can also adjust the warning thresholds to better fit your company.
The dashboard looks for both individual thresholds and developing trends.
It can help flag issues such as:
Cash falling below your chosen reserve
Operations consuming cash
Customers taking longer to pay
Gross margin declining over several months
Inventory or labor pressure increasing
Major costs growing too large relative to sales
Net margin falling below your minimum
A warning is not an automatic verdict. It is a prompt to investigate the number, understand what changed, and decide whether action is needed.
This dashboard is an educational decision-support tool and is not a substitute for professional accounting, tax, legal, audit, or lending advice.
Set aside time once a month to update your dashboard and ask:
Are customers taking longer to pay?
Is inventory or labor growing faster than sales?
Are margins moving in the wrong direction?
Are major costs rising faster than revenue?
Did the business generate cash, or only report profit?
What is the one action that matters most this month?
You do not need to analyze every line of every report.
You need a consistent place to track the few numbers that matter and enough history to recognize when something begins moving in the wrong direction.
Future Usefully Competent resources may include:
A standalone profit-to-cash worksheet
A monthly financial review agenda
A receivables and collections tracker
An inventory health worksheet
A growth decision calculator
Financial questions to ask your bookkeeper
Plain-English financial reference guides
[EXPLORE THE BOOKS]
[LEARN MORE ABOUT USEFULLY COMPETENT]
These spreadsheets and resources are educational decision-support tools.
They are not substitutes for professional accounting, tax, legal, audit, valuation, investment, or lending advice. Their usefulness depends on the accuracy and consistency of the information entered.
Always reconcile your figures to your accounting records and consult a qualified professional when making significant financial, legal, or tax decisions.