XML Reporting for FCA Product Sales Data: A Simpler Way to Prepare RegData Submissions

Reporting FCA Product Sales Data is increasingly challenging for heavily regulated companies, especially as consumer credit Product Sales Data requirements grow.

The issue is not only understanding what needs to be reported.

Firms also require a reliable method to convert their internal data—encompassing products, customers, agreements, and performance—into the right XML format for FCA RegData submission, including RegData XML submission.

For many firms, this creates an uncomfortable gap between compliance and technology. The compliance team understands the reporting obligation, but the data sits across systems, spreadsheets, databases, or operational processes. The final submission, however, needs to be prepared as a correctly structured Product Sales Data XML file.

XML Authority helps close that gap. As FCA XML reporting software, it streamlines the path from data to a compliant file.

It enables firms to generate schema-based Excel templates or SQL tables, populate the required data, validate against the relevant XSD using an XSD validation software approach, and produce XML files for FCA RegData XML upload.

What is FCA Product Sales Data reporting?

Product Sales Data, often shortened to PSD, is information submitted by firms to the FCA about the products they sell and, in some cases, how those products perform. The FCA requires some firms to submit PSD through RegData, its online system for collecting, validating, and storing regulatory data. This is often referred to as FCA Product Sales Data XML reporting when the data is prepared in a machine-readable XML format.

PSD reporting includes investment products, home financing, short-term loans, specific protection products, and data on mortgage performance.

Recently, the FCA introduced three new Product Sales Data returns for consumer credit reporting under PS24/3, highlighting this as a relevant issue for firms involved.

The regulatory requirement is clear: firms need to submit the required data. The operational question is: how do you get that data into the correct XML format?

This is where XML Authority is designed to help.

How do you report FCA Product Sales Data using XML Authority?

XML Authority provides a schema-driven process for generating XML reports. It supports FCA PSD reporting end to end.

Instead of asking users to manually read the XML schema or write XML code, XML Authority turns the schema into a usable reporting structure. The process can be summarised in five steps.

1. Select the relevant XML schema

XML Authority contains all FCA returns that are submitted through RegData, including Product Sales Data RegData returns.

2. Generate an Excel template or SQL table structure

XML Authority can generate an Excel template or SQL tables based on that schema.

This gives firms flexibility.

Compliance or reporting teams can work with Excel templates in a familiar format. IT or data teams can use generated SQL tables as part of a database or data warehouse process.

The result is a practical bridge between the regulatory reporting requirement and the technical XML format.

3. Populate the Product Sales Data

The generated template or SQL structure can then be populated with the required reporting data.

XML Authority does not need to replace the firm’s source systems. Instead, it provides the reporting structure that those systems, spreadsheets, or internal processes can feed into.

Data entry can be done manually, connected from other spreadsheets, filled in using formulas, or loaded into created database tables. The method depends on the firm’s operational model.

4. Validate against the XSD

Before creating the final XML file, XML Authority performs XSD validation software checks against the relevant schema.

This ensures that the XML is structured properly, that all required fields specified by the schema are filled in, and that values match the necessary data types.

This is an important control before attempting to upload the file through RegData.

XML Authority does not replace every possible FCA business rule or internal data quality review. Its role is to help firms create and validate the XML structure against the schema, reducing the risk of technical XML errors.

5. Generate the XML file for RegData

Once the data has been populated and validated, XML Authority generates the Product Sales Data XML file.

That file can then be uploaded through FCA RegData using the FCA’s XML upload process.

Supported returns and capabilities

XML Authority’s schema library contains all Product Sales Data XML Schemas:

• PSD001 – Product Sales Data – Mortgage
• PSD002 – Product Sales Data – Retail Investments
• PSD003 – Product Sales Data – Pure Protection
• PSD004 – Product Sales Data – Home Reversion Plans
• PSD005 – Product Sales Data – Home Purchase Plans
• PSD006 – Product Sales Data – Short Term Loans
• PSD007 – Product Sales Data – Mortgage Performance Data
• PSD008 – Product Sales Data – Credit Agreement Sales
• PSD008a – Product Sales Data – Credit Agreement Back-book
• PSD009 – Product Sales Data – Credit Agreement Performance

XML Authority for FCA Product Sales Data reporting

FCA Product Sales Data reporting sets a clear operational need: firms must provide structured data via RegData in the right XML format.

XML Authority helps firms manage that XML reporting layer.

For firms preparing FCA Product Sales Data reports, XML Authority provides a practical alternative to manual XML work, spreadsheet-only processes, or bespoke internal scripts.

If your firm needs to prepare Product Sales Data XML submissions for FCA RegData, Authority Software can help you establish a clear, repeatable reporting process using XML Authority.