For a breakdown of the Ad Valorum charges, you have the option to create a custom report template:
In Access PaySuite DDCMS navigate to REPORTS.
Click CUSTOM.
Click CREATE NEW TEMPLATE.
Input a Report Name.
In Report Area select Payments.
This populates Available Fields in the REPORTS COLUMNS.
Drag and drop the following fields into the Selected Fields:
Payments.DirectDebitRef
Payments.Status
Payments.Amount
Payments.SubmittedBankDate
Payments.DateOfCollection
Click CONFIRM COLUMN SELECTION.
Column Naming and Filtering
Each field included in your template has an edit (pencil) button. Pressing it enables you to optionally rename the column and filter the data it retrieves, based on the field type. When you finalise editing the field properties, click the corresponding row's Update (tick) button. You can also tick the box against Has Header at the top to specify if you want a header included. Column renaming is only available if you have this ticked.
Add in a filter to the Payments.DirectDebitRef to ‘Not Contains’ their Disbursement bank reference
Add in a filter to the Payments.SubmittedBankDate to ‘Between’ applicable date range i.e 01/05/2025 – 31/05/2025
Add in a filter to the Payments.Status to ‘Is’ ‘Paid’
Preview and Save
You can preview the partial output of a defined Report Template by pressing the PREVIEW button. The top three database results matching your template structure and columns criteria are displayed.
Press BACK TO EDIT to return to previous page, then SAVE if you’re content with your template definition. It is displayed in your Custom Reports Templates Library, where you can further manage and RUN it. The output of a manually run report isn't saved in Report History, but it can be exported by pressing EXPORT CSV or EXPORT EXCEL.
Download the report and add a column with the following:
SUM: =IF(B2*0.0075>3.85,3.85,B2*0.0075)
The sum gives the cost line by line of each successful transaction.