KPI category
Accounting KPI Formulas
Accounting KPI formulas for receivables, payables, working capital, liquidity, financial control, and month-end reporting.
Affiliate resources
Ideas for You
Useful learning resources related to this page. As an Amazon Associate, this site may earn from qualifying purchases at no extra cost to you.
Accounting KPI books
Books that help you understand Accounting KPI and related business metrics more deeply.
Explore resources →
Accounting KPI audiobooks
Audiobook searches for learning Accounting KPI while commuting, walking, or working.
Explore resources →
Accounting Excel resources
Excel-focused resources for building KPI trackers and dashboard workflows.
Explore resources →
Financial statement analysis
Practical resources for turning Accounting KPI into reports, dashboards, and business decisions.
Explore resources →
Popular formulas
Common Accounting KPIs
Accounts Receivable TurnoverNet Credit Sales / Average Accounts ReceivableAccounts Payable TurnoverNet Credit Purchases / Average Accounts PayableDays Sales Outstanding(Accounts Receivable / Credit Sales) × DaysDays Payable Outstanding(Accounts Payable / Cost of Goods Sold) × DaysInventory TurnoverCost of Goods Sold / Average InventoryWorking Capital RatioCurrent Assets / Current LiabilitiesDebt RatioTotal Debt / Total AssetsAsset TurnoverRevenue / Average Total AssetsOperating Cash Flow RatioOperating Cash Flow / Current LiabilitiesExpense RatioOperating Expenses / RevenueBudget VarianceActual Amount - Budgeted Amount
All Accounting KPI formulas
| KPI | Formula | Excel | Tool |
|---|---|---|---|
| Accounts Receivable Turnover | Net Credit Sales / Average Accounts Receivable | =IFERROR(B2/C2,0) | Calculator |
| Accounts Payable Turnover | Net Credit Purchases / Average Accounts Payable | =IFERROR(B2/C2,0) | Calculator |
| Days Sales Outstanding | (Accounts Receivable / Credit Sales) × Days | =IFERROR((B2/C2)*D2,0) | Calculator |
| Days Payable Outstanding | (Accounts Payable / Cost of Goods Sold) × Days | =IFERROR((B2/C2)*D2,0) | Calculator |
| Inventory Turnover | Cost of Goods Sold / Average Inventory | =IFERROR(B2/C2,0) | Calculator |
| Working Capital Ratio | Current Assets / Current Liabilities | =IFERROR(B2/C2,0) | Calculator |
| Debt Ratio | Total Debt / Total Assets | =IFERROR(B2/C2,0) | Calculator |
| Asset Turnover | Revenue / Average Total Assets | =IFERROR(B2/C2,0) | Calculator |
| Operating Cash Flow Ratio | Operating Cash Flow / Current Liabilities | =IFERROR(B2/C2,0) | Calculator |
| Expense Ratio | Operating Expenses / Revenue | =IFERROR(B2/C2,0) | Calculator |
| Budget Variance | Actual Amount - Budgeted Amount | =B2-C2 | Calculator |
How to use these KPIs
Start with a small set of metrics that connect to decisions. Define each KPI once, document the formula, and reuse the same calculation in Excel, dashboards, and business reports.
Build dashboards faster
Each KPI page includes a plain formula, Excel formula, Power BI DAX measure, calculator, related KPIs, and common mistakes to avoid.