Customer Balance

Originally written by John Hardwick, last updated Jun 14, 2023, on the Swan Retail knowledge base (FRS).

Part of: Financial Reports

The customer balance report produces a statement for a user definable list of customers, grouped optionally by location and / or salesperson.  The details show balances across sales orders, payments, and finances with an aged banding per transaction.

Detailed

see image above.

In detailed mode, if quotes are included, a Q is displayed before the order number to identify quotations.

Summary

Selection Criteria

Run time choices, user selectable.

• Customer Surname

• Group By Location

  • Yes / No

• Group By Salesperson

  • Yes / No

• Include customers with balances over X

• Format

  • Detail / Summary

• Restricted Customer / Selling Location(s)

• Include Quotations

  • Yes / No

Print Sequence

As indicated by blue numbered squares in the report example.

1 Selling Location (if selected)

2 Salesperson (if selected)

3 Customer

4 Sales Order (in detailed mode)

Report Totals

As indicated by yellow numbered squares in the report example.

1 Sales Order (in detailed mode)

2 Report

Printed Fields

Fields printed on the report.

• Selling location (if selected)

• Salesperson (if selected)

• Customer Title, Initials, Surname

• Customer ID

• Order(s) Total

• Payments Received

• Approved Finance

• Unapproved Finance

• Unfulfilled Value (Pending Delivery)

• Delivered Value

• Customer To Pay

• Aged of Debt

  • Less than 30 days

  • 30 to 60 days

  • 60 to 120 days

  • Over 120 days

• Last Payment Date

• Total Payments

• Allocated Payments

• Unallocated Funds

Detailed Format

• Quotation Indicator

• Sales Order Number

• Pad Reference

• Sales Order Date

Attachments (2)

image-20230331-123407.png
31.3 KB

image-20230331-123601.png
27.6 KB