Customer Deposits Audit

Created by Migration Bot, Modified on Fri, 23 Oct at 11:25 AM by Migration Bot

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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article