Customer - Trial Balance (report)

The Customer - Trial Balance report summarizes customer balances in local currency, grouped by customer posting group.

Specify a range in Date Filter. For each customer, the report shows the following amounts for both the selected period and the fiscal year to date:

  • Beginning balance
  • Total debits and credits
  • Ending balance

The report shows customer and posting-group totals, not individual transactions, remaining amounts, or due dates. The amounts are always in local currency.

Tip

To see individual transactions and due dates, use Customer - Detail Trial Balance (report).

Use cases

Analyze and reconcile customer balances in local currency at the end of a period. Explore opening balances, total debits and credits within the period, and closing balances for customers.

Sales representatives use the report to:

  • Follow up on pending payments by tracking outstanding balances for customers.
  • Verify that customer balances are accurate before making sales decisions or recommendations.
  • Review period debit and credit totals for selected customers.

Sales managers use the report to:

  • Monitor the financial health of key accounts by reviewing their balances and transaction history.
  • Analyze the effect of recent sales transactions on customer accounts and identify trends and areas for improvement.
  • Ensure that customer balances are accurate before making strategic decisions.

Finance analysts use the report to:

  • Reconcile customer balances with the general ledger and ensure accurate financial records.
  • Analyze transaction patterns and identify potential financial risks or opportunities.
  • Serve as a source for financial forecasting and planning.

Accounts receivable specialists use the report to:

  • Review period-end balances by customer posting group.
  • Identify accounts with high outstanding balances and prioritize collection efforts.
  • Provide customers with accurate account information upon request.

Finance managers use the report to:

  • Review selected-period and fiscal-year-to-date movement in receivables.
  • Compare customer posting-group totals with general ledger control accounts.
  • Ensure compliance with accounting standards and regulations by reconciling customer balances with the general ledger and audit trails.

Try the report

Try the report here: Customer - Trial Balance

Tip

If you hold down the Ctrl key while you select the report link, the report opens on a new browser tab. The new tab lets you stay on the current page while you explore the report on the other browser tab.

Sales reports
Ad hoc analysis of sales data
Sales analytics overview

Find free e-learning modules for Business Central here