APRA Updates Validation and Derivation Rules in September 2020
APRA updated the lists of the Direct to APRA (D2A) validation and derivation rules for authorized deposit-taking institutions, insurers, and superannuation entities. All reporting entities, including regulated and registered financial entities, submit data to APRA via the D2A.
APRA uses validation rules within D2A to validate the data submitted by reporting entities. There are two types of D2A validation rules—mandatory and confirmation rules. Mandatory rules identify data, within D2A, that contain mathematical errors and discrepancies or factual inconsistencies. To submit data via D2A, entities must correct all data that fail mandatory rules. Confirmation rules identify data, within D2A, that indicate reporting errors or require explanation. Entities are expected to correct any reporting errors identified by these rules. The derivation rules, however, are formulae that automatically calculate (derive) values for attributes, in most cases using the values for other attributes as inputs. As per APRA, the rules are usually updated two weeks before the end of each quarter, in particular March 31, June 30, September 30, and December 31.
Related Links
- Updated Validation Rules (XLSX)
- Updated Derivation Rules (XLSX)
- Overview of Validation and Derivation Rules
Keywords: Asia Pacific, Australia, Banking, Insurance, Pensions, Superannuation, Validation Rules, Derivation Rules, Reporting, Reporting, D2A, Basel, APRA
Featured Experts

María Cañamero
Skilled market researcher; growth strategist; successful go-to-market campaign developer

Nicolas Degruson
Works with financial institutions, regulatory experts, business analysts, product managers, and software engineers to drive regulatory solutions across the globe.

Patrycja Oleksza
Applies proficiency and knowledge to regulatory capital and reporting analysis and coordinates business and product strategies in the banking technology area
Previous Article
ESRB Recommends Framework for Identification of Legal Entities in EURelated Articles
OSFI Discusses Benchmark Rate Transition, Sets Out Work Priorities
The Office of the Superintendent of Financial Institutions (OSFI) published the strategic plan for 2022-2025 and the departmental plan for 2022-23.
EBA Proposes Standards to Support Secondary NPL Markets
The European Banking Authority (EBA) is consulting, until August 31, 2022, on the draft implementing technical standards specifying requirements for the information that sellers of non-performing loans (NPLs) shall provide to prospective buyers.
EU Confirms Agreement on Rules on Cybersecurity and Banking Resolution
The European Council and the Parliament reached an agreement on the revised Directive on security of network and information systems (NIS2 Directive).
EBA Issues Standards for Crowdfunding Service Providers Under ECSPR
The European Banking Authority (EBA) published the final draft regulatory technical standards specifying information that crowdfunding service providers shall provide to investors on the calculation of credit scores and prices of crowdfunding offers.
EU to Amend Credit Risk Adjustment Rules; ESAs Submit Queries on SFDR
The European Council published a draft Commission Delegated Regulation to amend the regulatory technical standards on specification of the calculation of specific and general credit risk adjustments.
EU Confirms Agreement on Rules on Cybersecurity and Banking Resolution
The European Securities and Markets Authority (ESMA) published a paper that examines the systemic risk posed by increasing use of cloud services, along with the potential policy options to mitigate this risk.
MAS Amends Notice 635 and Issues Second Proposal on Green Taxonomy
The Monetary Authority of Singapore (MAS) published amendments to Notice 635, which sets out requirements that a bank in Singapore has to comply with when granting an unsecured non-card credit facility to individuals.
EC Consults on PSD2 and Open Finance; EU Reaches Agreement on DORA
The European Commission (EC) published a public consultation on the review of revised payment services directive (PSD2) and open finance.
EC Mandates ESAs to Propose Amendments to SFDR Technical Standards
The European Commission (EC) has issued two letters mandating the European Supervisory Authorities (ESAs) to jointly propose amendments to the regulatory technical standards under Sustainable Finance Disclosure Regulation or SFDR.
EBA Examines Supervisory Practices, Issues Deposits Reporting Template
The European Banking Authority (EBA) published its annual report on convergence of supervisory practices for 2021. Additionally, following a request from the European Commission (EC),