Skip to main content
Your CFO wants to see monthly revenue by customer segment. Your ops team needs payroll costs by department. Your board wants a specific format they’ve used for years. None of these are standard reports. Custom reports let you build exactly what you need — pick the data, set the filters, choose the grouping, and save it for next time. If you can imagine it, you can probably build it.

​
Creating a custom report

1

Go to Reports → Custom

Click New Custom Report.
2

Choose a data source

Select what data to report on:
  • Transactions
  • Invoices
  • Bills
  • Customers
  • Vendors
  • Employees
  • Payroll
  • Journal Entries
3

Select columns

Choose which fields to include. Available fields depend on your data source.
4

Apply filters

Narrow down the data:
  • Date range
  • Categories
  • Customers/vendors
  • Amounts
  • Status
5

Set grouping and sorting

Organize the output:
  • Group by (category, customer, month, etc.)
  • Sort by (date, amount, name)
  • Show subtotals
6

Save and run

Name your report and save it. Run immediately or schedule for later.

​
Available data sources

​
Transactions

Financial transactions from all sources:
FieldDescription
DateTransaction date
DescriptionTransaction description
AmountTransaction amount
CategoryAssigned category
AccountBank/credit card account
TypeIncome, Expense, Transfer
PayeeWho paid/received
StatusCleared, Pending, Reconciled

​
Invoices

Customer invoices:
FieldDescription
Invoice #Invoice number
DateInvoice date
Due DatePayment due date
CustomerCustomer name
AmountInvoice total
BalanceAmount still owed
StatusDraft, Sent, Paid, Overdue
Days OutstandingDays since invoiced

​
Bills

Vendor bills:
FieldDescription
Bill #Bill/reference number
DateBill date
Due DatePayment due date
VendorVendor name
AmountBill total
BalanceAmount still owed
StatusOpen, Paid, Overdue
Days OutstandingDays since billed

​
Payroll

Payroll data:
FieldDescription
Pay DateCheck date
EmployeeEmployee name
Gross PayGross wages
Net PayTake-home pay
TaxesTotal taxes withheld
DeductionsTotal deductions
HoursHours worked
Pay TypeRegular, Overtime, Bonus

​
Filtering options

​
Date filters

FilterExample
Exact dateMarch 15, 2025
Date rangeMarch 1 - March 31, 2025
RelativeLast 30 days, This quarter
ComparisonThis month vs. last month

​
Amount filters

FilterExample
Equals= $500
Greater than> $1,000
Less than< $100
Between100−100 - 500

​
Category filters

  • Include specific categories
  • Exclude categories
  • Parent category (includes children)

​
Status filters

  • Active / Inactive
  • Open / Closed / Paid
  • Pending / Cleared / Reconciled

​
Grouping and subtotals

Group your data for analysis:

​
Group by options

Group ByResult
MonthSubtotals by month
QuarterSubtotals by quarter
YearSubtotals by year
CategorySubtotals by category
Customer/VendorSubtotals by contact
EmployeeSubtotals by employee

​
Multiple levels

Nest groupings for deeper analysis:
  • Primary: Category
  • Secondary: Month
Result: Expenses by category, with monthly breakdown within each category.

​
Summary options

OptionShows
CountNumber of records
SumTotal amount
AverageAverage amount
Min/MaxSmallest/largest values

​
Calculated fields

Add calculations to your reports:
CalculationExample
Percentage of totalEach category as % of total expenses
Running totalCumulative sum over time
VarianceActual vs. budget
Growth rateMonth-over-month change

​
Saving and sharing

​
Save for reuse

  1. Click Save Report
  2. Name it descriptively
  3. Access from Reports → My Reports

​
Share with team

  1. Open a saved report
  2. Click Share
  3. Choose team members
  4. They see it in their Reports → Shared

​
Export

FormatUse Case
PDFPrint or share read-only
ExcelFurther analysis, pivot tables
CSVImport to other systems
Google SheetsCollaborative editing

​
Scheduling

Run custom reports automatically:
  1. Open a saved report
  2. Click Schedule
  3. Set frequency (daily, weekly, monthly)
  4. Add recipients
  5. Choose format (PDF, Excel)
Scheduled reports run and email on your defined schedule.

​
Report templates

Start from templates for common custom reports:

​
Expense by vendor

See who you spend the most with:
  • Data: Transactions
  • Filter: Expenses only
  • Group by: Vendor
  • Sort: Amount descending

​
Revenue by customer

See who pays you the most:
  • Data: Invoices (paid)
  • Group by: Customer
  • Sort: Amount descending

​
Monthly trend

See patterns over time:
  • Data: Transactions
  • Group by: Month, then Category
  • Columns: Amount, Count
  • Compare: Year-over-year

​
Overdue invoices

Focus on collections:
  • Data: Invoices
  • Filter: Status = Overdue
  • Sort: Days Outstanding descending

​
Dashboard integration

Pin custom reports to your dashboard:
  1. Save the report
  2. Click Add to Dashboard
  3. Choose widget size (small, medium, large)
  4. Report appears on your dashboard, updated in real-time

​
Common uses

​
Management reporting

  • Weekly revenue summary
  • Monthly expense analysis
  • Department spending

​
Operational tracking

  • Outstanding invoices by customer
  • Vendor payment status
  • Payroll cost by department

​
Compliance

  • Transaction audit trail
  • Category verification
  • Bank reconciliation detail

​
Analysis

  • Profitability by customer
  • Cost trends over time
  • Budget variance

Profit & Loss

View the standard P&L report.