Customer Balance

Reports-> Customer -> Customer Balance

This report is designed to indicate the monies owed to the shop by customers. It lists all customer tickets with a balance based upon the store location and transaction cutoff date entered.

A report column for Paid In (Deposits) exist for shops on Ticket Zero accounting (set in System Settings) to total the current partial payments held on customer tickets. These partial payments (paid in) is the total deposit for the store and tracked as a liability until the customer ticket is fully paid by most shops.

This report is a good tool to compare to your GL systems account to insure everywhereRetail and accounting system is properly matched If not, then it recommended to adjust the GL to match everywhereretail's number.

The sales & balance columns include sales tax. The balance column is the result of net sales + sales tax - paid.

Filters

Store ... Limit sales made at a specific store or selected multiple stores.

Last Transaction Date: Only transactions that were created on or before the entered cut-off date will be considered for the ticket net sales, payments and balance totals.

Run Report button ... Display report.

Export to Excel button ... This is a specially designed export to Microsoft compatible Excel spreadsheet format that is easily manipulated for analysis.