Finance Insights

This course covers Finance Insights in Quickenerp: 57 executive dashboards and reports across cash, customers, vendors, performance, and audit. Learn how to read the KPI dashboard, monitor cash flow in real time, track customer/vendor risk, use the audit screens, and generate executive reports for decision-making.

Start this Course

Responsible	System
Last Update	07/21/2026
Completion Time	2 days 19 hours
Members	1

Course
Reviews

Accounting & Finance

Finance Insights Overview

View all

New Content

Budget vs Actual & Profitability

Preview

Budget vs Actual Analysis

Comparing Performance

Go to Finance Insights > Performance > Budget vs Actual.

Select a budget period.
See revenue and expense accounts compared side by side.
Variance Amount – Actual − Budget.
Variance % – (Variance / Budget) × 100.
Green = favorable (revenue higher or expense lower than budget).
Red = unfavorable.

Budget Heatmap shows the same variance data as a colour-coded grid across accounts and months, making it fast to spot which line item is driving an overall miss.

Profitability by Segment

Drill down profitability by:

Product / Product Category – Product Profitability screen shows which items drive profit.
Customer – see the Customer Profitability screen (previous article).
Salesperson – Margin by Salesperson.
Analytic Account / Cost Center – Analytic / Cost Center P&L.
Sales Channel – Online vs retail vs wholesale.

Other Performance Screens

Screen	What It's For
Sales Analytics / Daily Sales Snapshot	Day-to-day sales performance tracking, separate from the longer-range trend charts on the main dashboard.
Average Order Value Trend	Whether typical order size is growing or shrinking over time.
Top Discount Recipients	Who is receiving the most discounting, to check it aligns with actual customer value/volume.
Pricing Power Index	How much of a price increase the market/customers have actually absorbed historically.
Gross Margin Stability	How consistent margins are period to period — volatility itself is a risk signal, even if the average looks fine.
Recurring Revenue Tracker	MRR/ARR-style tracking for subscription or contract revenue.
P&L Forecast	Projects the income statement forward based on recent trends.

Exporting Reports

All dashboard views can be exported:

Click the Download button on any chart or KPI.
Format options: PDF, XLSX, CSV, PNG (for charts).
Schedule recurring exports via Actions > Schedule Report.

12:00

0 0

New Content

Cash Flow & Forecasting

Preview

Cash Flow Management

Cash Flow View

Go to Finance Insights > Cash > Cash Flow Forecast. Shows:

Opening Balance – Cash at start of period.
Expected Inflows – Open invoices due, expected payments.
Expected Outflows – Vendor bills due, payroll, recurring expenses.
Net Cash Flow – Inflows – Outflows.
Closing Balance – Projected end balance.

Forecast Periods

7-day forecast – Immediate liquidity check.
30-day forecast – Short-term planning.
90-day forecast – Medium-term strategy.
Custom date range.

Other Cash Screens

Screen	What It's For
Cash Position 360	Total cash across every bank/cash account right now, in one consolidated view.
Cash Conversion Efficiency	How efficiently operating activity converts into actual cash (vs just booked profit).
Free Cash Flow	Cash generated after operating costs and capital spending — what's actually available to reinvest or distribute.
Burn Rate & Runway	For cash-negative periods: monthly burn and how many months of cash remain at the current rate.
Working Capital Cycle	How long cash is tied up between paying suppliers and collecting from customers.
Liquidity Stress Test	Models how the cash position holds up under a revenue-drop or delayed-collections scenario.
Currency Exposure	How much cash/receivables/payables sit in each foreign currency, and the resulting FX risk.

Cash Flow Alerts

Configure alerts in Settings:

Low Cash Threshold – Alert when projected cash drops below a set amount.
Large Payment Alert – Notify when a single outflow exceeds a set amount.
Overdue Receivable Alert – Daily summary of overdue invoices.

12:00

0 0

New Content

Dashboards & KPIs

Preview

KPI Dashboards

Key Performance Indicators

KPI	Formula	What It Tells You
Revenue	Sum of invoiced sales (current period)	Top-line growth.
Gross Profit	Revenue – Cost of Goods Sold	Product profitability.
Net Profit	Revenue – All Expenses	Overall business profitability.
Gross Margin %	(Gross Profit / Revenue) × 100	Pricing and cost efficiency.
Operating Expenses Ratio	(OpEx / Revenue) × 100	Cost control effectiveness.
Current Ratio	Current Assets / Current Liabilities	Short-term liquidity.
Days Sales Outstanding	(AR / Revenue) × 365	Average collection time.
Days Payable Outstanding	(AP / COGS) × 365	Average payment time.
Inventory Turnover	COGS / Avg Inventory Value	How fast inventory sells.

Customizing the Dashboard

Click the Edit button (pencil icon) on any KPI card.
Change the Period: Today, This Week, This Month, This Quarter, This Year, Custom Range.
Change Comparison: Show vs previous period, vs budget.
Target: Set a target value. KPI turns green/red based on attainment.
Drill Down: Click any KPI to see the underlying transactions.

Chart Types

Charts on the dashboard can be:

Line Chart – Trends over time.
Bar Chart – Compare categories.
Pie Chart – Revenue/expense distribution.
Gauge – Single KPI vs target.
Table – Detailed list view.

Financial Ratios & Multi-Year Comparison

The Financial Ratios screen calculates the standard set (liquidity, leverage, efficiency, profitability ratios) in one place instead of building them manually in a spreadsheet. Multi-Year Comparison and Three-Statement View lay out several years of Balance Sheet/P&L/Cash Flow side by side for trend spotting.

12:00

0 0

This documentation is updated continuously. Some features described here may be renamed, deprecated, or still being finalized.