Exchange formats for the audit data collection standard: XML and JSON
Introduction: Accounting and enterprise resource planning (ERP) software packages are widely used in businesses and by various government organizations to manage and track business processes, post transactions and produce financial reports. Because of the nature of the information contained within the ERP systems, the data are also leveraged by internal and external auditors to assess the business controls, processes and financial reporting. There are numerous ERP packages that are used by businesses and government organizations, which can vary greatly in design (e.g. interfaces, data content, data formats, operational reports, management reports, financial reports). These and other design differences present challenges in the collection of data for auditing supervision management purposes. This document concerns the specification of technical exchange formats as output file formats for the functional content defined in ISO 21378. © ISO 2023 – All rights reserved
Scope: ISO 21378, the audit data collection standard (ADCS), defines the functional requirements for exchanging audit data in flat file format. This document concerns the specification of technical exchange formats in extensible markup language (XML), JavaScript object notation (JSON) and comma-separated values (CSV) as output file formats for the functional content defined in ISO 21378. This document also contains the following schemas and sample files for tables in ISO 21378. — XML schema; — XML sample file; — JSON schema; — JSON sample file. To keep the three exchange formats (XML, JSON and CSV) consistent, this document also specifies how to use the technical solution in the CSV format.