Financial Reports
Overview
The Financial Reports module provides a table-based view of all financial transactions with debit/credit columns, summary statistics, date range filtering, and export options to PDF and Excel.
Navigate to: Sidebar → Reports or Dashboard → Reports
Reports List
Summary Stats
Four summary cards at the top of the reports table:
| Card | Description |
|---|---|
| Total Debits | Sum of all debit transactions (GHS) |
| Total Credits | Sum of all credit transactions (GHS) |
| Net Balance | Total Credits minus Total Debits (GHS) |
| Total Transactions | Total number of transactions |
Date Range Filter
| Element | Description |
|---|---|
| Start date | Beginning of the date range |
| End date | End of the date range |
| Apply button | Filters the report to the selected date range |
Transaction Table Columns
| Column | Description |
|---|---|
| Date | Transaction date |
| Reference | Transaction reference number |
| Description | Transaction description |
| Type | Transaction type badge |
| Debit | Debit amount (GHS) |
| Credit | Credit amount (GHS) |
| Balance | Running balance (GHS) |
| Account | Associated account |
Reference Type Values
| Type | Description |
|---|---|
bill |
Bill-related transaction |
payment |
Payment transaction |
adjustment |
Rate adjustment transaction |
refund |
Refund transaction |
penalty |
Penalty charge |
Export Options
| Action | Description |
|---|---|
| Export to PDF | Downloads the report as a PDF file |
| Export to Excel | Downloads the report as an Excel spreadsheet |
| Opens the browser print dialog for the report |
!!! info "Export Scope" Exports include all currently filtered data — applying a date range before exporting ensures only the relevant transactions are included in the downloaded file.
Calculations
| Formula | Description |
|---|---|
| Net Balance = Total Credits − Total Debits | Positive value indicates net credit position |
| Running Balance | Cumulative balance calculated row by row |
!!! tip "Things to check" - Summary stat values are consistent with the transactions displayed in the table - Net Balance equals Total Credits minus Total Debits - Date range filter correctly narrows transactions to the selected period - PDF export includes all filtered transactions with correct formatting - Excel export includes all columns and data types - Print produces a readable layout matching the on-screen table - Running balance calculations are correct across all rows - Empty date ranges show a "No transactions found" message - Transaction type badges display with consistent colours for each type