Customer Balance & Open Invoices Reports Guide

How to use customer balance, open invoice, customer history, and receivable journal reports to review balances, open documents, and customer activity in QBM.

Sales & Customers Receivables End-User Guide

Overview

This report family helps answer slightly different customer-balance questions. Some reports show customer totals, some show open invoices only, and some show the full history behind the balance.

Balance ReportsShow what customers owe at a selected date.
Open Invoice ReportShows unpaid or partly paid invoices and related credits.
History ReportsShow movement and transaction activity over time.

Reports Covered

Report Menu Path Main Use
Customer Balance Summary Reports > Customers > Customer Balance Summary High-level balance view by customer.
Customer Balance Detail Reports > Customers > Customer Balance Detail Supporting detail behind the customer balance.
Open Invoices Reports > Customers > Open Invoices Open customer invoices and, where selected, open credit memos.
Customer Transaction History Reports > Customers > Customer Transaction History Chronological customer-side movement over a selected range.
Accounts Receivable Journal Reports > Customers > Accounts Receivable Journal Receivable transaction activity for review and follow-up.

Common Filters

Field Or Option What It Means
Customer Review one customer or all customers.
Date / Date Range Choose the balance date or the period to analyze.
Show Zero Balance Include customers with no outstanding balance when you want a full list.
Display Type Choose list or graph where the summary report supports visual output.
Currency: Base / Transactions In detail reports, choose whether to review balances in base currency or in the original transaction currency.
Use Date Range In Open Invoices, limits the report by the selected date range when needed.
Show Credit Memo Includes open customer credit memos together with open invoices.
Include Zero Amount In transaction history, includes lines with zero amount when full movement review is required.

When To Use Each Report

Customer Balance Summary

Use this when you want a quick view of who owes you and by how much. It is a strong daily control report for collections teams and account managers.

Customer Balance Detail

Use this when the summary total needs explanation. It is useful for customer dispute review, statement checking, and support follow-up.

Open Invoices

Use this when you want a clean list of unpaid or partly paid invoices. Turn on Show Credit Memo when you also want open credits visible in the same review.

Customer Transaction History

Use this for a chronological history of activity over a selected period. This is useful when the question is not only what is open, but what happened.

Accounts Receivable Journal

Use this when finance wants a receivable transaction report for a selected period, especially for review, export, or reconciliation support.

Suggested Workflow

  1. Start with Customer Balance Summary to identify the customers that need attention.
  2. Move to Open Invoices when you need the unpaid document list for follow-up.
  3. Use Customer Balance Detail if you need supporting balance detail.
  4. Use Customer Transaction History when you need the full customer story over time.
  5. Use the Accounts Receivable Journal for broader receivable transaction review during finance checks.

Best Practice

  • Use summary reports for decision-making and detailed reports for explanation.
  • Show credit memos when you want the net open position, not only invoice lines.
  • Use transaction-currency detail when customer accounts are actively managed in foreign currency.
  • Do not confuse transaction history with open invoices. One shows movement, the other shows remaining unpaid documents.
Important: If balances look incorrect, review receipts, allocations, customer credits, and any recent adjustments before escalating the issue.