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

Audit Trail, Reconciliation & Compliance Screens

Catching Problems Before the Auditor Does

The Finance Insights > Audit menu is aimed at accountants and controllers rather than executives — screens that surface exceptions and reconciliation gaps rather than headline KPIs.

Screen	What It's For
Journal Audit Trail	Who posted/edited which journal entries and when — for internal control review.
Anomalous Transactions	Flags entries that don't fit normal patterns (unusual amount, account combination, or timing) for manual review.
Negative Balance Alerts	Accounts sitting in a balance direction they shouldn't (e.g. an asset account with a credit balance) — often a data-entry error.
Bank Reconciliation Status	Which bank accounts/periods are fully reconciled vs still open, across the whole company at a glance.
Tax Reconciliation Audit	Compares tax collected/paid per the ledger against what tax returns actually reported.
Tax & VAT Dashboard	Live view of tax liability building up through the period, ahead of the filing deadline.
Credit Notes Audit	Volume and reasons behind credit notes issued — a spike can indicate a quality or pricing-process problem.
Refund Rate Tracker	Refunds as a share of sales, trended over time.
Payment Method Mix	Split of how customers actually pay (cash/card/transfer/etc.) — useful for reconciling processor fees and cash handling risk.
Top Account Movements	Largest balance changes per account in the period — a fast way to explain "why did this number move so much".
Account Movement Velocity	How frequently/quickly specific accounts are turning over — unusually high velocity on a normally-quiet account is worth investigating.
Year-End Checklist	A structured checklist of the standard year-end closing tasks (see the Accounting course's "Period-End Closing Process" article) so nothing is missed during annual close.

Best Practices

Review the KPI dashboard daily for at least 5 minutes.
Set realistic KPI targets and review quarterly.
Monitor cash flow forecast weekly to avoid liquidity crunches.
Share the dashboard with department heads for visibility.
Run through the Audit screens monthly, not just at year-end — catching an anomalous entry the month it happened is far easier than untangling it during annual close.

Finance Insights Overview

View all

New Content

Audit Trail, Reconciliation & Compliance Screens

Preview

Catching Problems Before the Auditor Does

The Finance Insights > Audit menu is aimed at accountants and controllers rather than executives — screens that surface exceptions and reconciliation gaps rather than headline KPIs.

Screen	What It's For
Journal Audit Trail	Who posted/edited which journal entries and when — for internal control review.
Anomalous Transactions	Flags entries that don't fit normal patterns (unusual amount, account combination, or timing) for manual review.
Negative Balance Alerts	Accounts sitting in a balance direction they shouldn't (e.g. an asset account with a credit balance) — often a data-entry error.
Bank Reconciliation Status	Which bank accounts/periods are fully reconciled vs still open, across the whole company at a glance.
Tax Reconciliation Audit	Compares tax collected/paid per the ledger against what tax returns actually reported.
Tax & VAT Dashboard	Live view of tax liability building up through the period, ahead of the filing deadline.
Credit Notes Audit	Volume and reasons behind credit notes issued — a spike can indicate a quality or pricing-process problem.
Refund Rate Tracker	Refunds as a share of sales, trended over time.
Payment Method Mix	Split of how customers actually pay (cash/card/transfer/etc.) — useful for reconciling processor fees and cash handling risk.
Top Account Movements	Largest balance changes per account in the period — a fast way to explain "why did this number move so much".
Account Movement Velocity	How frequently/quickly specific accounts are turning over — unusually high velocity on a normally-quiet account is worth investigating.
Year-End Checklist	A structured checklist of the standard year-end closing tasks (see the Accounting course's "Period-End Closing Process" article) so nothing is missed during annual close.

Best Practices

Review the KPI dashboard daily for at least 5 minutes.
Set realistic KPI targets and review quarterly.
Monitor cash flow forecast weekly to avoid liquidity crunches.
Share the dashboard with department heads for visibility.
Run through the Audit screens monthly, not just at year-end — catching an anomalous entry the month it happened is far easier than untangling it during annual close.

10:00

0 0

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

Customer & Vendor Risk Screens

Preview

Understanding Who You Sell To and Buy From

Beyond the main dashboard, dedicated screens under Finance Insights > Customers and > Vendors dig into relationship-level financial risk and value.

Customer Screens

Screen	What It's For
Customer Risk Score	Ranks customers by payment reliability/credit risk so collections can prioritise the riskiest accounts first.
Customer Lifetime Value	Total historical (and projected) value of the relationship, not just the last invoice.
Customer Profitability	Revenue from a customer net of the cost to serve them — a big customer isn't always the most profitable one.
Customer Concentration	How much revenue depends on your top few customers — a concentration risk flag.
Customer Churn Risk	Flags customers whose ordering pattern has gone quiet compared to their historical rhythm.
Customer Cohort Analysis	Groups customers by when they first bought, to see how each cohort's spend evolves over time.
Customer Acquisition Velocity	Rate of new customer acquisition over time.
Cross-Sell Opportunity Matrix	Which product combinations customers tend to buy together but aren't yet — an upsell target list.

Vendor Screens

Screen	What It's For
Vendor Concentration	How dependent your supply chain is on a small number of vendors.
Vendor Reliability Score	On-time delivery/quality-linked scoring per vendor, where tracked.
Vendor Spend Analysis	Total spend by vendor and category — the starting point for negotiating volume discounts.
Vendor Payment Schedule	Upcoming bill due dates laid out on a timeline for payment planning.

Receivables & Payables Aging

Aged Receivable, AR & AP Aging, Late Invoice Tracker, Days to Pay Analytics, and Receivables Forecast together give a complete picture of who owes you money, who you owe, and how overdue each side is — the day-to-day working set for a collections/AP team, distinct from the higher-level risk-scoring screens above.

13:00

0 0

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