Shopping Cart

No products in the cart.

BS ISO 21378:2019

$215.11

Audit data collection

Published By Publication Date Number of Pages
BSI 2019 218
Guaranteed Safe Checkout
Categories: ,

If you have any questions, feel free to reach out to our online customer service team by clicking on the bottom right corner. We’re here to assist you 24/7.
Email:[email protected]

This document establishes common definitions of accounting data elements and provides the information necessary to extract relevant audit data.

NOTE

For the purpose of this document, “audit” refers to an examination of an entity’s financial and financial related records in order to check that they are fairly presented.

This document is applicable to the bridging of understanding among auditors, auditees, software developers and IT professionals, and creating a mechanism for expressing the information, common to accounting, in a manner independent of accounting and ERP systems. This document serves as a foundation for local data extraction efforts in the areas of general ledger, accounts receivable, sales, accounts payable, purchase, inventory, and property, plant and equipment.

PDF Catalog

PDF Pages PDF Title
2 undefined
8 Foreword
9 Introduction
11 1 Scope
2 Normative references
3 Terms and definitions
13 4 Modules, tables and fields
4.1 General
14 4.2 Naming conventions
16 4.3 Representation and datatype of data elements
18 4.4 Base module
4.4.1 General
4.4.2 BAS_Business_Segment
4.4.3 BAS_Business_Segment_Hierarchy
19 4.4.4 BAS_Employee
20 4.4.5 BAS_User
21 4.4.6 BAS_Customer_Type
22 4.4.7 BAS_Customer
25 4.4.8 BAS_Supplier_Type
26 4.4.9 BAS_Supplier
28 4.4.10 BAS_Chart_Of_Accounts
30 4.4.11 BAS_Accounting_Period
4.4.12 BAS_Journal_Entry_Type
31 4.4.13 BAS_Bill_Type
32 4.4.14 BAS_Settlement_Method
4.4.15 BAS_Currency
33 4.4.16 BAS_Measurement_Unit
34 4.4.17 BAS_Payment_Term
4.4.18 BAS_Project
35 4.4.19 BAS_Bank_Account
36 4.4.20 BAS_Tax_Regulatory
37 4.4.21 BAS_Tax_Type
38 4.4.22 BAS_Customized_ACC_Segment
39 4.4.23 BAS_Customized_ACC_Value
40 4.4.24 BAS_Profile
42 4.4.25 Base standard data questionnaire
43 4.5 General Ledger module
4.5.1 General
44 4.5.2 GL_Trial_Balance
47 4.5.3 GL_Details
52 4.5.4 GL_Source
53 4.5.5 GL_Account_Segment
55 4.5.6 GL_Accounts_Period_Balance
58 4.5.7 GL standard data profiling report
59 4.5.8 GL standard data questionnaire
60 4.6 Accounts Receivable module
4.6.1 General
61 4.6.2 AR_Open_Accounts_Receivable
65 4.6.3 AR_Cash_Received
69 4.6.4 AR_Cash_Application
72 4.6.5 AR_Adjustments
78 4.6.6 AR_Adjustments_Details
82 4.6.7 AR standard data profiling report
83 4.6.8 AR standard data questionnaire
4.7 Sales module
4.7.1 General
84 4.7.2 SAL_Contracts
86 4.7.3 SAL_Contracts_Details
89 4.7.4 SAL_Orders
91 4.7.5 SAL_Orders_Details
94 4.7.6 SAL_Invoices_Generated
99 4.7.7 SAL_Invoices_Generated_Details
102 4.7.8 SAL_Shipments_Made
105 4.7.9 SAL_Shipments_Made_Details
107 4.7.10 SAL standard data profiling report
108 4.7.11 SAL standard data questionnaire
109 4.8 Accounts Payable module
4.8.1 General
4.8.2 AP_Open_Accounts_Payable
113 4.8.3 AP_Payments_Made
117 4.8.4 AP_Cash_Application
121 4.8.5 AP_Adjustments
127 4.8.6 AP_Adjustments_Details
131 4.8.7 AP standard data profiling report
132 4.8.8 AP standard data questionnaire
4.9 Purchase module
4.9.1 General
133 4.9.2 PUR_Requisitions
134 4.9.3 PUR_Requisitions_Details
136 4.9.4 PUR_Contracts
138 4.9.5 PUR_Contracts_Details
141 4.9.6 PUR_Orders
144 4.9.7 PUR_Orders_Details
148 4.9.8 PUR_Invoices_Received
152 4.9.9 PUR_Invoices_Received_Details
156 4.9.10 PUR_Materials_Received
159 4.9.11 PUR_Materials_Received_Details
161 4.9.12 PUR standard data profiling report
163 4.9.13 PUR standard data questionnaire
4.10 Inventory module
4.10.1 General
164 4.10.2 INV_Location
165 4.10.3 INV_Product_Type
166 4.10.4 INV_Product
169 4.10.5 INV_On_Hand
172 4.10.6 INV_Transaction
177 4.10.7 INV_Physical_Inventory
180 4.10.8 INV_Period_Balance
182 4.10.9 INV standard data profiling report
183 4.10.10 INV standard data questionnaire
4.11 Property, Plant and Equipment module
4.11.1 General
184 4.11.2 PPE_Type
185 4.11.3 PPE_Master
188 4.11.4 PPE_Addition
191 4.11.5 PPE_Removal
194 4.11.6 PPE_Change
197 4.11.7 PPE_Department_Allocation
4.11.8 PPE_Depreciation_Method
198 4.11.9 PPE_Depreciation
201 4.11.10 PPE standard data profiling report
202 4.11.11 PPE standard data questionnaire
203 5 Syntax/technical format
5.1 General
5.2 Characteristics of flat files
5.3 Extension
5.4 Conventions of folder naming and file naming
204 5.5 Data file format convention in flat files
205 6 Transport/handling and versioning
6.1 Character encoding conventions
206 6.2 Versioning
6.3 Multi-platform and multi-system data transfer
6.4 File compression
208 Annex A (informative) Guidance on how to use the business segment table structure to customize the extraction standard for client-specific needs
213 Annex B (informative) Guidance on how to use Account Segment
217 Bibliography
BS ISO 21378:2019
$215.11