Skip to the page content

Reading Financial Ratios

Financial Ratios turns Profit & Loss and Balance Sheet figures into margins, stock turnover, days to collect and pay, and the current and quick ratio.

On this page

Financial Ratios answers "is the business healthy?" with a few short figures. Open Reports → Financial Ratios, then press a period button such as This month or choose From and Until yourself. The report is only open to holders of the Sensitive Reports role, like Profit & Loss and the Balance Sheet, and it switches on together with the Balance Sheet feature. If the menu is missing, ask the Vende team to switch it on.

Every ratio is written with its name, its formula and one line on how to read it, so you need not memorise formulas. On a phone each ratio is one card.

Compare with another period

Choose Compare with. Previous period puts the period before beside yours, for example This month beside last month. Last year puts the same days a year before. The Change column writes the rise or fall: margins in points, turnover in times and durations in days. Vende does not judge whether a rise is good or bad, because that depends on the business.

Profit

  • Gross profit margin = gross profit : net sales. Of every Rp 100 of sales, this much is left after the cost of the goods.
  • Net profit margin = net profit : net sales. Of every Rp 100 of sales, this much is profit after all costs. Negative means a loss.

Turnover

  • Inventory turnover = cost of goods sold from inventory : average inventory. Inventory includes goods sent by Surat Jalan but not yet billed, as in the cost calculation of Profit & Loss. Cost of goods sold from inventory is cost of goods sold without the consigned goods sold, because consigned goods never enter your stock. How many times the stock sold out and was refilled in the period. A longer period gives a bigger number, so compare periods of the same length.
  • Days of stock = average inventory : cost of goods sold from inventory x days in the period. How many days the stock on hand would last.
  • Days to collect receivables = average sales receivables : net sales x days in the period. Sales receivables are Trade Receivable, Property Receivable and KPR Retention. On average how many days a sale waits to be paid. Receivables include VAT on taxed notes while sales do not, so the figure reads slightly higher than it is.
  • Days to pay debts = average Trade Payable and Consignment Payable : cost of goods sold x days in the period. On average how many days you take to pay suppliers and consignors. Compare it with the days to collect receivables: if you pay faster than you collect, your cash carries the gap.

An average is half of the balance at the start of the period plus the balance at its end.

Ability to pay

  • Current ratio = current assets : current liabilities. Above 1 means the assets that turn into cash quickly cover the debts.
  • Quick ratio = (current assets - inventory) : current liabilities. Like the current ratio without stock, since stock may not sell fast.

Current assets are every asset except fixed assets and their depreciation. The Vende Balance Sheet does not split short-term and long-term debts, so every debt counts as a current liability. A long loan therefore makes the current and quick ratio lower than they really are.

Figures used and the dash

Below the ratios is a Figures used table. Net sales, cost of goods sold, gross profit and net profit are those of Profit & Loss. Cost of goods sold from inventory is cost of goods sold less the consigned part that the sales notes booked. Current assets, inventory and current liabilities are those of the Balance Sheet on the last day of the period, for the same branches. So you can check every ratio yourself.

A ratio that cannot be worked out is written as - with the reason, for example "No sales in this period", "No cost of goods sold in this period" (a service shop has no stock turnover), "No stock in the books", "Stock in the books is below zero" (goods sold before they were bought; see Negative Stock History) or "No debts". Vende does not guess a figure.

Download

Press Download PDF to print or send it. Export to Excel appears when the Excel export feature is on. Both carry the ratios and the figures used.

Example

Toko Berkah, September: net sales Rp 500.000, cost of goods sold Rp 200.000, net profit Rp 240.000. Gross margin 60%, net margin 48%. Average stock Rp 290.000, so turnover 0,7 times and the stock lasts 44 days. Current assets of Rp 1.450.000 against debts of Rp 620.000 give a current ratio of 2,34 times.

Still not answered?

Ask us directly. We help until it is clear.

Ask on WhatsApp