Custom Report
The Custom Report form allows creating customized reports from your data.
Select fields, apply filters, and format the output to meet your specific reporting needs.
Name
Enter a descriptive name for this custom report. This name appears in the report list and at the top of the generated report.
Use clear names that describe the report's purpose, like 'Monthly expense analysis' or 'Customer payment history'.
Description
Enter an optional description to explain the purpose and content of this report. This helps other users understand what the report shows.
Include details about filters applied, data sources used, or specific business questions the report answers.
From
Select the starting date for the report period. Only transactions on or after this date will be included in the report.
This date filter applies to transaction dates, not creation or modification dates.
To
Select the ending date for the report period. Only transactions on or before this date will be included in the report.
Set this to today's date for current reports, or use historical dates for period comparisons.
Accounting method
Choose the accounting method for this report:
Accrual basis - Recognizes income when earned and expenses when incurred, regardless of payment timing
Cash basis - Recognizes income when received and expenses when paid, following actual cash flow
This should match your business's accounting method for accurate financial reporting.
Select
Select which fields from general ledger transactions to display as columns in your report.
You can choose transaction fields (date, amount, description) or related object fields (customer name, account name).
The order you select fields determines their column order in the report.
Where
Check this box to enable filtering. Filters allow you to include only transactions that meet specific criteria.
Without filters, the report includes all general ledger transactions within the date range.
Where
Define one or more filter conditions. Only transactions matching ALL conditions will appear in the report.
Common filters include specific accounts, customers, amounts above thresholds, or transaction types.
Each filter consists of a field to check, an operator (equals, contains, greater than), and a comparison value.
Order by
Check this box to enable custom sorting. This controls the order in which transactions appear in your report.
Without sorting, transactions appear in their natural database order.
OrderBy
Specify sort fields and directions. You can sort by multiple fields to create primary and secondary sort orders.
For example, sort first by date (newest first), then by amount (largest first) for transactions on the same date.
Group by
Check this box to enable grouping. This aggregates transactions by common values and shows subtotals.
Grouping transforms detailed transaction lists into summary reports with totals by category.
GroupBy
Select fields to group by. Transactions with the same values in these fields will be combined.
Numeric fields will be totaled, while text fields show the group value. Perfect for summaries by account, customer, or time period.
Multiple grouping levels create hierarchical reports with subtotals at each level.
Groups to collapse
Check this box to initially collapse all groups, showing only group headers and totals.
Users can expand individual groups to see transaction details. This creates cleaner summary reports while preserving detail access.