Section 8: Reports > Accounting Reports

Miscellaneous Customer Account Balances

This report is a summary of current receivable or payable balances for each miscellaneous customer (i.e. customer account 0000000), including a breakdown of the sales invoices portion, repair invoices portion, and credit notes portion (see Customers, and Invoicing).

Report totals include the total sales invoices balance, repair invoices balance, credit notes balance, and a grand total. The report may be sorted by customer name, or any one of the individual balances. And it may be filtered by business location.

Report Option Fields

Field

Description

Bus. Location

Enter or select the business location for which to generate the report or leave blank for all business locations. This report option is not available in the Repair Lite and Repair Micro editions.

Sort by

Select the desired sort order.

In the Repair Micro, Retail SQL, and Retail editions, select to sort either by customer name (the system default), by repair invoices balance, by credit notes balance, or by total balance.

In all other editions select to sort either by customer name (the system default), by sales invoices balance, by repair invoices balance, by credit notes balance, or by total balance.

 

Sales invoices are included on the report when the amount paid is different from the grand total. Repair invoices are included on the report when they are set to a repair invoice status (see Repair Invoice     Statuses) and the amount paid is different from the grand total. And credit notes are included on the report when the amount applied is different from the grand total. Overpayments on some invoices may balance out receivable amounts on other invoices. Only customers with a non-zero balance of sales invoices, repair orders, and/or credit notes are included in the report.

The Sales column is not available in the Repair Micro, Retail SQL, and Retail editions.

More:

Payment Ledger Listing