Customer Details Report

A transaction-level breakdown of all activity per customer — for when you need to see exactly how customer balances are formed, beyond summary totals. Tracks invoices, payments, adjustments, and other activity at a granular level.

What each entry shows

Payee / Account, Date, Transaction Type (Invoice, Bank Transaction, Journal, etc.), Description, Split Account (the account impacted, e.g., Accounts Receivable), Amount, and Balance (running balance after each transaction).

Transactions are grouped by customer, showing individual transactions, the running balance, and a Total for Customer (the final balance within the selected period). Included types: invoices, payments, bank transactions, journal entries, adjustments.

Reading the report

Positive amounts increase the customer balance (e.g., invoices); negative amounts decrease it (payments, credits, refunds); the Balance column shows the cumulative balance after each transaction.

Configuration

Filter by report period, account, customer (one or multiple), and tags; choose the accounting method (Accrual, Cash, Modified Cash).

How it's generated

Data from customer invoices, payments and receipts, bank transactions, and journal entries is linked to customers, ordered by customer then date, with a running balance calculated per customer. Only customer-linked transactions are included.

Actions

Filter, search for a specific customer, export, and expand/collapse customer sections between transaction detail and summarized views.

FAQs

How is this different from Customer Summary? Summary shows aggregated totals; Details shows the transaction-level breakdown.

Why is a transaction missing? Outside the date range, not linked to a customer, or filtered out.

Useful for reconciliation and collections? Yes — verify balances, transaction accuracy, and payment history.