Track Financial Ratios for a Small Business

Why ratios are calculated once and then forgotten

Owners of small and mid-sized businesses hear about financial ratios from their accountant or their bank, usually once a year when the accounts are finished or a loan is renewed. The ratios arrive months after the period they describe, calculated in someone else's spreadsheet, and there is no easy way to see them again until next year.

That is a pity, because a handful of ratios answer the questions owners actually ask. Can we pay our bills next month? Are we keeping more of each sale than last year? How long are customers taking to pay us? How many months could we run on the cash in the bank? Each answer is a simple division of two numbers that are already in the ledger.

The trick is to calculate the ratios automatically from the books, for any period, and to show them with last year's figure next to them. Then the trend is visible every month, and a falling margin or a lengthening collection period is spotted while there is still time to act.

Why this happens

Ratios are only calculated for the year-end accounts or a loan application.
The numbers behind them are exported and retyped into a spreadsheet.
There is no comparison with the same period last year.
Ratio names are used without explaining what a good result looks like.
Receivables, payables and cash are taken from different reports on different dates.

Biznsbook addresses this through current and quick ratios, gross, operating and net margin, days sales and payables outstanding, cash runway in the Accounting module, built on the same ledger that every posted sale, bill, payroll run and voucher updates.

Financial reporting rarely fails because the arithmetic is hard. It fails because the numbers are rebuilt by hand every month and nobody trusts the copy. Reading the ledger directly removes that step.

Step-by-step: Track Financial Ratios for a Small Business

Written for owners, bookkeepers and finance managers in small and mid-sized businesses using Biznsbook Accounting, where sales, purchases, inventory and payroll post to the same ledger the reports read.

Map the key accounts. Under Accounting → Account mapping, check that receivables, payables, inventory and cash are mapped to the right accounts, and that every bank account is linked to its ledger account. The ratios use these roles, not account names.
Classify income and expense accounts. In Transaction accounts, give cost of goods sold accounts the Cost of goods sold sub type, and other income or expense accounts their own sub types, so gross and operating margins are measured correctly.
Open Financial Health. Go to Accounting → Financial reporting → Financial health and choose a period, such as year to date or the last twelve months.
Read liquidity first. Current ratio, quick ratio, cash ratio and working capital show whether short-term assets cover short-term debts, with and without inventory.
Then profitability. Gross, operating and net margin show how much of each sale is kept at each level; return on equity shows profit against the owners' stake.
Then the cash cycle. Days sales outstanding, days payables outstanding and days inventory show how long cash is tied up in customers, suppliers and stock; debt to equity and cash runway show resilience.
Compare and drill in. Each card shows the same period last year. When a ratio moves the wrong way, open the income statement or balance sheet for the same dates and click into the accounts behind it.

Review results after the first full monthly cycle. Adjust roles, mappings, or approvals where the same exception repeats.

Inside Biznsbook, every financial report has a short "How this is built" note at the bottom and the Accounting guide (Accounting → Accounting guide) walks through each screen. This article focuses on the finance process behind those screens.

Common mistakes to avoid

Mistake 1: Ratios are only calculated for the year-end accounts or a loan application. Repeating this each month usually shows up first in a management pack nobody trusts.
Mistake 2: The numbers behind them are exported and retyped into a spreadsheet. Repeating this each month usually shows up first in a management pack nobody trusts.
Mistake 3: There is no comparison with the same period last year. Repeating this each month usually shows up first in a management pack nobody trusts.
Mistake 4: Ratio names are used without explaining what a good result looks like. Repeating this each month usually shows up first in a management pack nobody trusts.
Mistake 5: Receivables, payables and cash are taken from different reports on different dates. Repeating this each month usually shows up first in a management pack nobody trusts.

Each of these turns a monthly review into an argument about whose spreadsheet is right. Report from the ledger instead.

Best practices that hold up as you scale

Map the key accounts — Under Accounting → Account mapping, check that receivables, payables, inventory and cash are mapped to the right accounts, and that every bank account is linked to its ledger account.
Classify income and expense accounts — In Transaction accounts, give cost of goods sold accounts the Cost of goods sold sub type, and other income or expense accounts their own sub types, so gross and operating margins are measured correctly.
Open Financial Health — Go to Accounting → Financial reporting → Financial health and choose a period, such as year to date or the last twelve months.
Read liquidity first — Current ratio, quick ratio, cash ratio and working capital show whether short-term assets cover short-term debts, with and without inventory.
Then profitability — Gross, operating and net margin show how much of each sale is kept at each level; return on equity shows profit against the owners' stake.

Use the same report, the same dates and the same order every month. Consistency is what turns numbers into a trend people trust.

How Biznsbook supports this workflow

current and quick ratios is part of Biznsbook Accounting and reads the posted ledger directly, so the numbers match the trial balance and change the moment a document is posted. Every amount on the report can be opened in the general ledger to see the entries behind it.

gross, operating and net margin is part of Biznsbook Accounting and reads the posted ledger directly, so the numbers match the trial balance and change the moment a document is posted. Every amount on the report can be opened in the general ledger to see the entries behind it.

days sales and payables outstanding is part of Biznsbook Accounting and reads the posted ledger directly, so the numbers match the trial balance and change the moment a document is posted. Every amount on the report can be opened in the general ledger to see the entries behind it.

cash runway is part of Biznsbook Accounting and reads the posted ledger directly, so the numbers match the trial balance and change the moment a document is posted. Every amount on the report can be opened in the general ledger to see the entries behind it.

Access is permission-based: viewing reports needs View financial reports, and creating, approving or archiving budgets needs Manage budgets. Company admins see everything.

Suggested implementation timeline

Week 1: Check account sub types and account mapping so cost of sales, other income and expenses, cash, receivables and payables are classified correctly.
Week 2: Set up current and quick ratios and run the report for last month alongside your current spreadsheet.
Week 3: Agree with the owner or finance manager which lines and ratios go into the monthly pack.
Month 2: Run the monthly review from Biznsbook only and retire the spreadsheet copy.
Ongoing: Monthly review using a five-ratio monthly check.

Metrics to track monthly

Net profit and margin against budget, year to date
Number of cost lines over budget this quarter
Gross margin month by month
Days sales outstanding and cash runway

Start with three metrics; trend direction matters more than a single point-in-time snapshot.

Spreadsheets vs Biznsbook Accounting

Compare a typical export-and-spreadsheet process with Biznsbook current and quick ratios and the related Accounting reports.

Capability	Manual / Spreadsheet	Biznsbook
How often	❌ Once a year with the accounts	✅ Any period, whenever you open the page
Source numbers	❌ Exported and retyped	✅ Computed from the posted ledger
Comparison	❌ Last year's figure looked up by hand	✅ Same period last year on every card
Meaning	❌ Ratio names without context	✅ Plain-language explanation per ratio
Consistency	❌ Balances taken from different reports	✅ Balances and income for the same dates
Follow-up	❌ Separate investigation	✅ Income statement and balance sheet drill-down

A five-ratio monthly check

If you only look at five numbers each month, make them current ratio, gross margin, net margin, days sales outstanding and cash runway. Note them in your management pack with last year's figure. A ratio that moves the same way three months in a row deserves a conversation: a slipping gross margin points to pricing or purchase costs, a rising collection period to credit control, and a shrinking runway to spending or financing decisions.

Put the routine in your month-end checklist so it happens after every close, not only when a question comes up.

Frequently asked questions

Which ratios does Biznsbook show?

Current ratio, quick ratio, cash ratio, working capital, gross margin, operating margin, net margin, return on equity, days sales outstanding, days payables outstanding, days inventory, debt to equity and cash runway in months.

What do the green, amber and red colours mean?

They are general rules of thumb for small businesses, written on each card, such as a current ratio above 1.5 being comfortable. They are not benchmarks for your industry, so compare with your own history first.

How is cash runway calculated?

Cash and bank balances at the end date divided by the period's average monthly spend on cost of sales and operating expenses. It answers how many months the current cash would last at the current rate of spending.

Why does a ratio show n/a?

When the bottom of the division is zero, for example no revenue in the period or no current liabilities, the ratio cannot be calculated and is shown as n/a rather than a misleading number.

Where do receivables and payables come from?

From the accounts mapped as receivable and payable under Account mapping, at the end date of the period. Cash is every account mapped as cash, undeposited funds or card clearing, plus every bank account.

Can I see the ratios for last year?

Yes. Choose last year's dates in the filter, or read the 'same period last year' line on each card while looking at the current period.

How this differs by industry

Retail

Retailers watch days inventory and gross margin side by side: if stock days climb while margin falls, they are carrying slow lines and discounting to move them.

Wholesale & distribution

Distributors live on days sales outstanding and days payables. A widening gap between the two means customers are paying slower than suppliers want to be paid.

Manufacturing

Manufacturers check the quick ratio, not only the current ratio, because raw material and work in progress can make the current ratio look healthier than the cash position is.