Customer Balance Report - Smarter Sales & Inventory Management | Zayls

by Zayls
1 year ago
0 Views
Knowledge Base Reports | Customer Balance Report

Customer Balance Report

Customer Balance Report is a summary report of a customer’s outstanding balance to the company. This report shows an overview of the current Invoice Balance, Sales Returns Balance, Payment Entry Balance, and the total Final Balance.

Customer Balance Report Overview

Report Filters

  • Customer Group – This filter will show the customers that belong to the group/s selected.
  • Customer – This filter will show the customers selected.

Customer Balance Report Columns

  • Customer Group – This column shows the customer group of the customer.
  • Customer – This column shows all the customers selected.
  • Invoice Balance – This column shows the current invoice balance of the customer.
  • Billing Statement Balance – This column shows the current billing statement balance of the customer.
  • Sales Returns Balance – This column shows the balance of items that the customer will return to the company.
  • Payment Entry Balance – This column shows the balance of customer deposit/s.
  • Final Balance – This column shows the final balance of the customer given the following balances.

Final Balance = Invoice Balance – Sales Returns Balance – Payment Entry Balance

A parenthesis around the final balance amount indicates a negative balance — the company owes money to the customer.

Export Customer Balance Report to PDF or Excel

  1. In the Customer Balance Report, click Export.
  2. There are two Export options: Export to PDF and Export to Excel. Click your desired format.
  3. Upon clicking your desired formatthe file will be automatically downloaded to your computer.
  4. You may also view the Export History by clicking View Export History.