Daily Payment Summary

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

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

Part of: Financial Reports


The report produces an audit of how payments have been received.

Crystal report name Daily Payment Summary 20

This report offers a detailed and summary format.

Detailed Format

Selection Criteria

Run time choices, user selectable.

  • Payment Date Range

Leaving the date set to the default of ‘31/12/9999’ instructs the report to run for today’s date.

The future date removes the need to manually key in today’s date every time the report is run, therefore it's a form of a shortcut to speed up run time selection.

  • Report Type

    • Detail / Detailed with payment Dates & Time) / Summary

  • Include

    • Refunds & Payments / Refunds Only / Payments Only

  • Finance Payments

    • Include / Exclude

  • Restricted Location(s) - Payment Locations

  • Tender Type(s)

  • Tender Group(s)

  • Location Filter

    • Payment Location / Original Sales Location

  • Show VAT / Tax

    • Yes / No

Where a payment links to a sales order with multiple VAT rates, the report shows the VAT composition of the order. See Example below

Print Sequence

As indicated by blue numbered squares in the report example.

1 Location (Payment or Order)

2 Payment Date

3 Tender Group

4 Tender Type

5 Sales Order Number

Report Totals

As indicated by yellow numbered squares in the report example.

1 Tender Group

2 Payment Date

3 Location Summary

4 Report Summary

Printed Fields

Fields printed on the report.

  • Location

  • Payment Date

  • Tender Group

  • Tender Type

  • Sales Order Number

  • Customer’s Full Name

  • Receipt ID

  • Payment Reference

  • Operator

  • Payment Value

  • Number of payments and Value by Tender Group

  • VAT Rate, VAT Value (where selected)

Detailed Format with Dates & Times

Selection Criteria

Run time choices, user selectable.

  • Same as Detailed format

Print Sequence

As indicated by blue numbered squares in the report example.

Same as Detailed format

Report Totals

As indicated by yellow numbered squares in the report example.

Same as Detailed format

Printed Fields

Fields printed on the report.

Same as Detailed format - additional elements are

  • Payment Date & Time

  • Amendment Date & Time (prior to Cash Reconciliation)

  • Reconciliation Date & Time

  • Posted to Accounts Date & Time

  • Payment Location

  • Order Location

Summary Format

Selection Criteria

As per detailed format.

Print Sequence

As indicated by blue numbered squares in the report example.

1 VAT Rates

2 Location

Report Totals

As indicated by yellow numbered squares in the report example.

1 VAT Rates

2 Location

3 Report Total

Printed Fields

Fields printed on the report.

  • VAT Rate and Description

  • Goods Value

  • VAT total

  • VAT Percentage

  • Location

  • Payment Date

  • Tender Group

  • Number of Payments

  • Payment Total

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