Originally written by John Hardwick, last updated Jun 14, 2023, on the Swan Retail knowledge base (FRS).
Part of: Financial Reports
This report offers the operator a date selection from which all payments received are reported, whether cash reconciled or not. In addition, all confirmed sales (deliveries and collections) are listed, presenting an audit detailing the impact on the deposit value held for customers.
Crystal report name Customer Deposits Audit 1
Payments in advance of delivery add to the deposit value held, deliveries reduce this (effectively consuming the deposit as a payment).
Any ‘deposit’ values held at the time of commissioning the report will show as ‘opening balances’.
The reference shown in brackets after the tender type is the payment reference allocated by SwanFRS at time of processing.
Red text indicates payments which have not been reconciled and therefore could change before being confirmed.
Selection Criteria
Run time choices, user selectable.
-
Date Range
-
Restricted Company (ies)
Print Sequence
As indicated by blue numbered squares in the report example.
1 Payment Date
2 Time of Transaction
Report Totals
As indicated by yellow numbered squares in the report example.
1 Payment Date
2 Totals
3 Dated Summary
Printed Fields
Fields printed on the report.
-
Transaction Date
-
Transaction Time
-
Customer Number
-
Full Customer’s Name
-
Sales Order Number (blank for unallocated payments)
-
Tender Type and Transaction ID
-
Payment Value
-
Delivered Value
-
Adjustment to the Deposits Held
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article