ABCDEFVWXYZ
1
SetUP
2
3
For integrity purpose worksheets are protected, but no password is required
4
5
6
i
Instructions:
to register the organization in the below yellow cells
7
8
1)
Enter Organization name
9
2)
Enter Organization Registration number or Tax ID
10
3)
Enter Organization Address
11
12
4)
Enter Country of operation
13
5)
Enter reporting Year
14
6)
Enter reporting currency
(National currency of the country)
15
16
7)
Enter Organization Manager Position
17
8)
Enter Manager Name
18
19
9)
Enter Auditor Position
20
10)Enter Auditor Name
21
11)
Enter Audit firm name:
22
23
24
25
Organization Name:
26
Organization ID:
27
Organization Address:
28
29
Country
30
31
Reporting Financial Year
32
33
Reporting Currency
34
35
Organization Manager:
36
Manager Name:
37
38
Auditor Position:
39
Auditor Name:
40
Audit Company Name:
41
42
43
i
Instructions:
to register the chart of accounts in the below yellow cells
44
45
1)
Copy the Organization Account codes and Accounts descriptions
46
2)
Paste the chart of accounts in the cells D59 (marked as light pink cell)
47
3)
In the category column, select related value. Use standard values from the dropdown list
48
49
Please refer to example below:
50
1Bank accounts are part of "Current Assets"
51
2
Office furniture belongs to "Fixed Asset" category
52
3Staff salary is part of "Personnel cost"
53
54
55
56
Chart of Accounts
57
58
NoAccountsAccounts DescriptionCategory
59
1
60
2
61
3
62
4
63
5
64
6
65
7
66
8
67
9
68
10
69
11
70
12
71
13
72
14
73
15
74
16
75
17
76
18
77
19
78
20
79
21
80
22
81
23
82
24
83
25
84
26
85
27
86
28
87
29
88
30
89
31
90
32
91
33
92
34
93
35
94
36
95
37
96
38
97
39
98
40
99
41
100
42