Excel formulas
Accounting KPI Excel Formulas
Copy Excel formulas for common accounting KPIs and adapt them for your spreadsheet or dashboard.
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 Excel KPI books
Books that help you understand Accounting Excel KPI and related business metrics more deeply.
Explore resources →
Accounting Excel KPI audiobooks
Audiobook searches for learning Accounting Excel 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 Excel KPI into reports, dashboards, and business decisions.
Explore resources →
Accounting formulas for Excel
| KPI | Formula | Excel |
|---|---|---|
| Accounts Receivable Turnover | Net Credit Sales / Average Accounts Receivable | =IFERROR(B2/C2,0) |
| Accounts Payable Turnover | Net Credit Purchases / Average Accounts Payable | =IFERROR(B2/C2,0) |
| Days Sales Outstanding | (Accounts Receivable / Credit Sales) × Days | =IFERROR((B2/C2)*D2,0) |
| Days Payable Outstanding | (Accounts Payable / Cost of Goods Sold) × Days | =IFERROR((B2/C2)*D2,0) |
| Inventory Turnover | Cost of Goods Sold / Average Inventory | =IFERROR(B2/C2,0) |
| Working Capital Ratio | Current Assets / Current Liabilities | =IFERROR(B2/C2,0) |
| Debt Ratio | Total Debt / Total Assets | =IFERROR(B2/C2,0) |
| Asset Turnover | Revenue / Average Total Assets | =IFERROR(B2/C2,0) |
| Operating Cash Flow Ratio | Operating Cash Flow / Current Liabilities | =IFERROR(B2/C2,0) |
| Expense Ratio | Operating Expenses / Revenue | =IFERROR(B2/C2,0) |
| Budget Variance | Actual Amount - Budgeted Amount | =B2-C2 |