Use the Transaction Summary Report to see a list of your transactions and their statuses. You can filter it by Payments Received and Uncollected Payments.
The DDCMS-Equivalent View shows the same fixed columns, headers, column order and formatting as the DDCMS report for the preset you have chosen: All transactions, Payments received or Uncollected payments. The downloaded file uses the same layout, so any processes that load it directly continue to work as before.
Switch the DDCMS-Equivalent View toggle off to customise your report from the full list of available columns and filters.
Available filters and columns
To create a Transaction Summary report, you will be able to filter via:
Bank Reference
Additional Reference
Customer Reference
Status
Payment Category
Filter by date
Due Date Range
Manual Payment Method
Include paid direct
Include not presented
Direct Debits only
The following columns will be available to customise your report:
Bank Ref
Customer Ref
Additional Ref
Title
First Name
Surname
Customer Name
Type
Payment Category
Details
Is Direct
Presented Transaction
Status
Comments
Schedule
BACS Date
Represented
Address
Post Code
Home Phone Number
Mobile Phone Number
Work Phone Number
Email
Date of Collection
Amount
Due Date
Indemnity Claim Date
Create Report
To create a Transaction Summary Report:
Click Reports & Analytics tab on the left hand side.
Within the Standards Reports section, select View Reports.
Under the Create A report panel, select Transaction Summary Report and then select Configure Report.
Under the Filters section, click the drop-down arrow to select your filters.
Alternatively, switch on the DDCMS-Equivalent View toggle.
Click Apply Filters.
Under the Column section, click the drop-down arrow to select the columns you need.
Within the Live Preview panel, click the drop-down menu to select the format.
Click Download.
đNote: Under the Filters section, click Clear to start your search again.