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

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

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

Introduction to Finance Insights

Preview

Finance Insights Module

Finance Insights provides real-time dashboards and KPIs for executives. It aggregates data from Accounting, Sales, Purchases, and Inventory to give a comprehensive financial view, organised under five menus: Dashboards, Cash, Customers, Vendors, Performance, and Audit.

Core Concepts

Concept	Description
KPI Dashboard	Visual cards showing Revenue, Expenses, Profit, Cash Balance, Receivables, Payables.
Cash Flow	Projected cash inflows and outflows over the next 30/60/90 days.
Revenue Breakdown	Sales by product, customer, salesperson, channel.
Expense Breakdown	Costs by category, department, vendor.
Profitability Analysis	Gross profit and net profit trends with comparison to targets.
Budget vs Actual	Compare actual performance against budgeted figures.

Accessing Finance Insights

Go to Finance Insights from the main dashboard. The overview page (Executive Dashboard) shows:

Top KPI cards (Revenue, Expenses, Net Profit, Cash, AR, AP).
Revenue and expense trend chart (last 12 months).
Top 5 customers by revenue.
Aged receivables summary.
Upcoming payments.

CFO Command Center

The CFO Command Center screen is the single highest-altitude view — it pulls the headline number from most of the other screens in this course onto one page, meant to be the first thing a CFO or owner opens each morning before drilling into any specific area.

08:00

0 0

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