ERPNext Financial Ratios Report Explained
The Financial Ratios report in ERPNext calculates 11 liquidity, solvency and turnover ratios for each fiscal year you select, straight from the general ledger. Read it as a trend across years. Before you rely on it, check the account setup behind it: a missing account type or a zero denominator shows as 0, not as an error.
This guide explains how the report behaves in standard ERPNext versions 15 and 16. A customised report can calculate differently, so confirm the formulas on your own site and reconcile the source balances before making a decision. The guide is written by Akwad Programming, which sets up ERPNext accounting for companies in Qatar, and was checked on 15 November 2026.
How do you run the Financial Ratios report?
Open the report from the search bar, then choose the company and the range of fiscal years to compare. It takes three steps:
- Open the report. Type “Financial Ratios” in the search bar. In version 16 it is also listed under Financial Statements in the Accounting workspace.
- Choose the company. Pick it in the Company filter.
- Choose the years. Set Start Year and End Year to the fiscal years you want to compare.
The standard report works by fiscal year only. Its periodicity is fixed to yearly, so you cannot switch it to months or quarters.
How is the report laid out?
The first column names the ratio. Each further column is one fiscal year, so choosing 2023 to 2025 gives three columns side by side. Ratios are grouped under three headings: Liquidity, Solvency and Turnover.
- Asset and liability figures are balances at the end of each fiscal year.
- Income and expense figures are that year’s movement, as in the Profit and Loss Statement, ignoring period closing entries.
- Everything comes from general ledger entries. If the books are wrong, the ratios are wrong, so check that adjustments use the right Journal Entry types.
- When a denominator is zero, ERPNext shows 0 instead of an error. Treat an unexpected 0 as a setup question.
Which accounts does the report read?
The ratios depend on how your chart of accounts is tagged: the report finds current assets, current liabilities, direct income and direct expenses by their Account Type, so a missing tag changes the result.
- Current assets, current liabilities, direct income and direct expenses: the report looks for group accounts with that Account Type (Current Asset, Current Liability, Direct Income, Direct Expense).
- In version 15, if those groups are not tagged, the related ratios show 0.
- In version 16, if no group is tagged, the report falls back to each account’s Account Category, or to ledger account types such as Bank, Cash, Receivable, Stock, Payable and Tax.
- Cost of goods sold comes from accounts with the Account Type Cost of Goods Sold.
- Quick assets are ledger accounts of type Bank, Cash and Receivable.
What do the liquidity ratios show?
Liquidity ratios show whether current assets can pay current liabilities: the current ratio uses all current assets, and the quick ratio leaves out stock.
Current ratio
Formula: current assets ÷ current liabilities.
It shows whether short-term assets cover short-term obligations. A value below 1 is a reason to review working capital and payment timing. On its own, it does not prove a cash-flow problem.
Quick ratio
Formula: (cash + bank + receivables) ÷ current liabilities.
It leaves out stock, so it matters most for a company with high inventory and little cash.
What do the solvency ratios show?
Solvency ratios show how far the company relies on debt rather than owners’ money. ERPNext groups the debt equity ratio and four profitability ratios (gross profit, net profit, return on assets and return on equity) under the Solvency heading.
Debt equity ratio
Formula: total liabilities ÷ shareholders’ funds, where shareholders’ funds = total assets − total liabilities.
It shows how far the company relies on debt rather than owners’ money. If it rises over time, look at borrowing, equity changes and the reason for the financing before drawing conclusions about risk.
Gross profit ratio
Formula: (net sales − cost of goods sold) ÷ net sales, where net sales = direct income.
A fall usually points to pricing or rising costs.
Net profit ratio
Formula: (total income − total expense) ÷ net sales.
ERPNext calls the numerator profit after tax, but it is simply income minus expenses. Tax is included only if it is booked as an expense.
Return on assets
Formula: net profit ÷ total assets at year end.
A low value can mean assets are under-used.
Return on equity
Formula: net profit ÷ shareholders’ funds.
It can look high when equity is small, so read it with the debt equity ratio.
What do the turnover ratios show?
The debtor, creditor and inventory ratios use average balances: (opening balance + closing balance) ÷ 2. The opening balance is taken on the day before the fiscal year starts. The averages use accounts of type Receivable, Payable and Stock.
Fixed asset turnover
Formula: net sales ÷ fixed assets in version 16. Version 15 divides by total assets, despite the name.
A low value means assets are not generating enough sales. Know which version you run before comparing figures.
Debtor turnover
Formula: net sales ÷ average receivables.
A low ratio means customers pay slowly, which strains cash flow.
Creditor turnover
Formula: direct expenses ÷ average payables.
It shows how quickly the company pays suppliers. A low or falling ratio means slower payment, which can point to tight cash; a very high ratio means you pay faster than your credit terms require.
Inventory turnover
Formula: cost of goods sold ÷ average stock.
A low ratio points to slow-moving or excess stock.
What does the ERPNext Financial Ratios report leave out?
The standard report does not include net working capital or sales growth. Calculate them separately or add them through a custom report.
How do you check the report before you rely on it?
Check the basics, the account setup and the source figures, then look into every zero or odd movement before you rely on a ratio.
- Check the basics. Confirm the company, fiscal years, currency and opening balances.
- Check the account setup. Review the Account Type on your current asset, current liability, direct income and direct expense groups. In version 16, also check the Account Category and your fixed asset accounts.
- Reconcile the figures. Match the source figures to the Balance Sheet and the Profit and Loss Statement.
- Investigate the odd ones. Look into every zero and every unusual year-on-year movement before relying on a ratio.
For the wider reporting workflow, see the official ERPNext accounting reports documentation.
Akwad Programming sets up ERPNext accounting for companies in Qatar as part of ERPNext implementation. We import your chart of accounts and opening balances, check them with your team and build the reports your management needs. Contact our Doha team.