CEF Core provides three standard financial reports -- Trial Balance, Profit & Loss, and Balance Sheet -- plus a visual report builder for custom queries. All reports can be exported to CSV, Excel, PDF, or JSON.
Access standard reports from Accounting → Reports in the sidebar. Each report pulls data directly from the GL journal entries and presents it in the standard accounting format.
Lists every GL account with its debit or credit balance as of a specific date. The total debits must equal total credits. Use this report to verify the GL is in balance before closing a period.
asOfDate (defaults to today)Shows revenue versus expenses for a date range, calculating net income. This is the primary report for understanding the fund's operating performance over a period.
startDate, endDatePoint-in-time snapshot showing all assets, liabilities, and equity. The fundamental accounting equation must hold: Assets = Liabilities + Equity.
asOfDate (defaults to today)Pro Tip: Run the trial balance at the end of each business day to catch posting errors early. If debits do not equal credits, investigate recent journal entries for unbalanced postings.
For reports beyond the standard three, CEF Core provides a visual query builder through the Reports service. Create custom reports by selecting data sources, columns, filters, and groupings without writing SQL.
The report builder uses templates as starting points. CEF Core ships with built-in templates for common reports such as active loans, maturing notes, aged receivables, and interest income by borrower. You can also create your own templates.
The visual query builder allows you to construct reports by selecting fields from available data sources (GL, Loans, Notes, Cash, CRM). Drag columns into the report layout, apply filters, set sort order, and add grouping with subtotals. The builder generates the underlying query and stores it as a template for re-use.
Note: The visual query builder requires ADMIN or TREASURY role. STAFF users can run existing templates but cannot create new ones.
All reports -- both standard and custom -- can be exported in four formats.
Comma-separated values for import into spreadsheets or data tools. Best for data analysis and bulk processing.
Formatted Excel workbook with column headers, number formatting, and sheet tabs. Best for sharing with stakeholders who use Microsoft Office.
Print-ready PDF with the fund's header, report title, date, and page numbers. Generated using jsPDF. Best for board presentations and regulatory submissions.
Machine-readable JSON array of report rows. Best for API integrations and programmatic consumption by external systems.
To export, click the Export button on any report and select the desired format. The file downloads immediately to your browser.
Custom reports can be saved and shared with other users in your organization.
After running a report with custom parameters, click Save to name it and store the configuration. Saved reports appear in your Reports → My Reports list and can be re-run at any time with the latest data.
To share a saved report, open it from My Reports, click Share, select the users or roles to share with, and choose the permission level (View or Edit).
Financial reports are available through two API services. All requests require JWT authentication.
| Method | Endpoint | Description |
|---|---|---|
GET | /api/v1/gl/trial-balance | Trial balance (?asOfDate=YYYY-MM-DD) |
GET | /api/v1/gl/profit-loss | Profit & Loss (?startDate, endDate) |
GET | /api/v1/gl/balance-sheet | Balance sheet (?asOfDate=YYYY-MM-DD) |
GET | /api/v1/gl/income-statement | Alias for profit-loss |
| Method | Endpoint | Description |
|---|---|---|
GET | /api/v1/reports/templates | List all report templates |
POST | /api/v1/reports/templates/:id/execute | Run a template with parameters |
POST | /api/v1/reports/templates/:id/export | Export to CSV, Excel, PDF, or JSON |
After reviewing your financial reports, learn how to execute the month-end close process to finalize the accounting period.
Month-End Close Guide