Finance CFO with Cash Cycle
The Finance CFO with Cash Cycle dashboard for Sage X3 adds AP and AR balances and the cash conversion cycle to the standard Finance CFO view. It helps finance leaders see net income, revenue, and gross margin trends alongside how long cash stays tied up before it's collected.
How to use the finance CFO with cash cycle dashboard
- Follow net income, revenue, and gross margin by fiscal period to see how profitability is trending.
- Weigh AP and AR balances against the cash conversion cycle to see how quickly cash comes back.
- Read liquidity and leverage ratios to see how well the business covers obligations and is funded.
- Sort expense categories by department to see where spending concentrates.
Filters
Use the filtering panel at the top of the Finance CFO with Cash Cycle dashboard to control which data is shown. The filters apply to all views and ensure the dashboard reflects the selections you choose.
Fiscal Year: multiple values
Company: multiple values
Ledger: multiple values
Ledger Type: multiple values
Key performance indicators (KPIs)
The key performance indicators (KPIs) are displayed at the top of the dashboard. They show performance, cash cycle, and liquidity measures, and update based on the filters you apply.
Performance KPIs
| KPI | What it measures |
|---|---|
| Net Income | Profit or loss after deducting all expenses, taxes, and costs from total revenue. A positive value indicates profitability, while a negative value indicates a loss. |
| Revenues | Total earnings from goods and services sold before expenses. Indicates overall sales performance. |
| Gross Margin | Percentage of revenue remaining after subtracting cost of goods sold (COGS). Higher values indicate stronger profitability from core operations. |
Cash Cycle KPIs
| KPI | What it measures |
|---|---|
| Days Inventory Outstanding | Average number of days inventory remains in stock before being sold. Lower values indicate faster inventory turnover. |
| Days Payable Outstanding | Average number of days taken to pay suppliers. Higher values can improve cash flow but may affect supplier terms. |
| Days Sales Outstanding | Average number of days customers take to pay invoices. Lower values indicate faster collections. |
| Cash to Cash Cycle | Number of days required to convert inventory and other inputs into cash from sales. Lower values indicate faster cash conversion. |
Liquidity KPIs
| KPI | What it measures |
|---|---|
| Working Capital | Difference between current assets and current liabilities. A positive value indicates stronger liquidity, while a negative value may indicate liquidity pressure. |
| Working Capital Ratio | Liquidity ratio calculated as current assets / current liabilities. A ratio below 1 can indicate difficulty meeting short-term obligations. |
| Return on Assets | Profitability ratio calculated as Net Income / Total Assets. Higher values indicate more efficient asset use. |
| Return on Equity | Profitability relative to shareholders' equity. Higher values indicate stronger returns for investors. |
Visual components
| View name | Type of view | What it shows |
|---|---|---|
| Gross Margin Progression | Combination | Plots revenue, COGS, gross margin, and gross margin % by fiscal period. |
| AP AR Balances | Pie | Shows the accounts receivable and accounts payable balances. |
| Cash to Cash Cycle | Combination | Plots days sales outstanding, days payable outstanding, and days inventory outstanding by fiscal period, with the monthly cash to cash cycle as a reference line. |
| Net Income Progression | Combination | Plots net income, expenses, and net income margin % by fiscal period. |
| Expenses Distribution | Radar Line | Shows expense posting by department and account category. |
| Leverage Ratio Progression | Combination | Plots total assets, total liabilities, debt ratio, and debt to equity ratio by fiscal period. |