Use the Customer Open Balance Letter to periodically inform your customers of open balances or for your own internal auditing purposes. This letter contains an introductory paragraph, individual transaction information, and the outstanding balance due for a customer site as of a specific date.
You can include transactions for all currencies in which a customer does business or for only one currency. If you include multiple currencies, the report lists the total balance in each currency separately.
When calculating a customer's open balance, Receivables includes invoices, debit memos, credit memos, bank charges, payments, discounts, on-account credits, and unapplied receipts. Receivables uses the following formula to calculate the balance due:
Sum of Open Invoices - On-Account Credits - On-Account Receipts - Unapplied Receipts = Open Balance
Enter parameters to define the content of the report.
As of Date: The date for which you want to review the customer's open balance. For example, if you enter 30-SEP-99, the report displays the customer's open balance as of September 30, 1999.
Currency: The currency of transactions to include in the report. Leave this field blank to report on transactions in the currencies in which they were entered.
Minimum Invoice Balance: The minimum open amount for a transaction to appear in the report.
Minimum Open Balance: The minimum open balance for a customer to appear in the report.
Include On Account Credits: Choose whether to display on-account credits in the report.
Include On Account Receipts: Choose whether to display on-account receipts in the report.
Include Unapplied Receipts: Choose whether to display receipts that have not been fully applied in the report.
Include Uncleared Receipts: Choose whether to display receipts for which the cash has not yet been recognized in Receivables.
Reference Number: A reference number to uniquely identify this report.
Customer Name From/To: To limit the report to one customer, enter the same customer name in both fields. Leave these parameters blank to include open balances for all customers.
Reference Number: The number you entered to uniquely identify the report.
Customer Tax Reference Number: The tax reference number for this customer. You enter a customer tax registration number in the Customers window.
On Account Credits and Receipts: The sum of any on-account credits and receipts for this customer.