Financial Reports & Dashboard

NexusRMS provides a comprehensive suite of financial reports and dashboards to give you real-time visibility into your company's revenue, receivables, and cash flow. From high-level KPI cards to detailed aged receivables breakdowns, every metric is designed to help you make informed business decisions.

Payment Dashboard

The Payment Dashboard (PaymentDashboard.vue) is the primary financial overview page, accessible from Financial > Dashboard. It displays four KPI cards at the top followed by interactive charts and lists.

KPI cards

• Total Outstanding — The combined amount_due across all unpaid invoices, displayed with a sparkline showing the trend over recent weeks
• Overdue Amount — The total value of invoices past their due_date, highlighted in red when above zero
• Paid This Month — Total payments received in the current calendar month, with a percentage change indicator compared to the previous month
• Collection Rate — The percentage of invoiced amounts that have been collected, shown as a circular progress indicator. The circle is colour-coded: green above 80%, amber between 50% and 80%, and red below 50%.

Charts

• Payment Methods — A pie chart (Chart.js) breaking down payments received by method (e.g., bank transfer, credit card, Stripe Connect, cheque)
• Aged Receivables — A bar chart showing outstanding amounts in four ageing buckets: 0–30 days, 31–60 days, 61–90 days, and 90+ days
• Payment Trends — A line chart comparing invoiced amounts versus paid amounts over time, with a period selector to toggle between monthly, quarterly, and yearly views

Lists

• Overdue Invoices — The top 5 overdue invoices sorted by amount_due descending, showing invoice_number, client name, amount, and days overdue
• Recent Payments — The last 7 days of payments received, showing payment_number, client name, amount, payment_method, and date

Financial Reports page

The Financial Reports page (FinancialReports.vue) provides ten structured report types that can be configured, previewed, exported, and scheduled for automatic delivery.

Report types

1. Income Statement (P&L) — Revenue minus expenses for the selected period, broken down by category
2. Balance Sheet — A snapshot of assets, liabilities, and equity at a point in time
3. Cash Flow — Inflows and outflows of cash, grouped by operating, investing, and financing activities
4. Aged Receivables — Detailed breakdown of amounts owed by clients, grouped into ageing buckets
5. Aged Payables — Amounts owed to suppliers, grouped by ageing period
6. Sales by Client — Revenue totals grouped by client, with drill-down to individual invoices
7. Sales by Project — Revenue totals grouped by project, showing quoted versus invoiced versus collected amounts
8. Equipment Profitability — Revenue generated per equipment item versus maintenance and depreciation costs
9. Payment Analysis — Breakdown of payment volumes, methods, average collection time, and failure rates
10. Tax Summary — Total tax collected and owed for the period, grouped by tax type and rate

Configuration options

Each report supports the following configuration before generation:

• Date Range — Choose from quick presets (This Month, Last Month, This Quarter, This Year, Last Year, Custom) or use the custom date picker to define a specific start and end date
• Comparison Mode — Overlay a second data set for context. Options: None, Previous Period, Year over Year, Budget
• Conditional filters — Narrow results by Client, Project, or Category depending on the report type

Export formats

All reports can be exported in three formats:

• PDF — Formatted document suitable for printing or attaching to emails
• Excel — Spreadsheet with full data for further analysis and pivoting
• CSV — Plain comma-separated values for importing into other systems

Scheduled reports

Reports can be scheduled for automatic generation and email delivery. Click Schedule Report to open the scheduling dialog with the following fields:

• reportType — Select which of the ten report types to generate
• frequency — How often the report runs: daily, weekly, or monthly
• dayOfWeek — For weekly reports, which day of the week (Monday through Sunday)
• dayOfMonth — For monthly reports, which day of the month (1–28)
• format — Output format: PDF, Excel, or CSV
• recipients — One or more email addresses to receive the report

Controller endpoints

The backend provides several dedicated endpoints for financial reporting:

• FinancialReportsController — Generates aged receivables data, revenue reports, and profit/loss statements
• InvoiceController > statistics() — Returns overall invoice statistics including counts by status, total invoiced, and total outstanding
• InvoiceController > agedReceivables() — Returns the ageing breakdown across the four standard buckets
• InvoiceController > overdue() — Lists all overdue invoices with client and amount details
• QuoteStatusController > statistics() — Returns overall quote statistics including conversion rates and average values
• QuoteStatusController > expiringSoon() — Lists quotes approaching their valid_until date

Tips

• Check the dashboard weekly — The Payment Dashboard gives you a quick pulse on cash flow. Pay particular attention to the Aged Receivables chart — amounts in the 90+ day bucket often require escalation.
• Use comparison mode for context — Selecting Year over Year on the Income Statement reveals seasonal trends and growth patterns that single-period reports cannot show.
• Schedule monthly P&L reports — Set up a monthly Income Statement to be emailed to your finance team on the first of each month for consistent oversight.
• Export to Excel for board reports — The Excel export includes full data tables that can be reformatted for presentations or imported into accounting software.
• Monitor the collection rate — A declining collection rate may indicate the need for stricter payment terms or more proactive payment reminders.