complete_bank_branch_audit_tool.xlsx

	A	B	C	D	E	F
1	Area	Checklist Item	Risk Level (H/M/L)	Status (Yes/No)	Remarks	Working Paper Ref
2	Planning	Obtain appointment / engagement letter	L
3	Planning	Review previous year branch audit report	M
4	Planning	Review previous year LFAR	M
5	Planning	Review previous year MOC	M
6	Planning	Review RBI inspection observations	H
7	Planning	Review concurrent audit reports	H
8	Planning	Obtain branch profile and business mix	M
9	Planning	Obtain trial balance and financial statements	H
10	Planning	Identify large advances accounts	H
11	Planning	Identify stressed / NPA accounts	H
12	Cash	Physically verify cash balance	H
13	Cash	Verify cash retention limit compliance	H
14	Cash	Check insurance cover for cash	M
15	Cash	Verify ATM cash balance	M
16	Cash	Check surprise verification records	M
17	Deposits	Verify account opening forms	M
18	Deposits	Verify KYC documentation	H
19	Deposits	Check interest calculation on term deposits	H
20	Deposits	Verify TDS deduction on deposits	M
21	Deposits	Review inoperative accounts	M
22	Deposits	Check large deposit movements	H
23	Deposits	Verify bulk deposits approval	H
24	Advances	Verify sanction authority	H
25	Advances	Check loan documentation completeness	H
26	Advances	Verify security creation	H
27	Advances	Verify drawing power calculation	H
28	Advances	Verify stock statements	H
29	Advances	Verify end use of funds	M
30	Advances	Review renewal / review of limits	H
31	Advances	Check insurance of securities	M
32	NPA	Verify SMA classification	H
33	NPA	Check 90 day overdue calculation	H
34	NPA	Verify NPA tagging in CBS	H
35	NPA	Check interest reversal	H
36	NPA	Verify provisioning percentages	H
37	NPA	Check security valuation reports	M
38	Income	Verify interest income on advances	H
39	Income	Check reversal of interest in NPA accounts	H
40	Income	Verify commission income	M
41	Income	Verify locker rent income	L
42	Contingent Liability	Verify bank guarantees issued	H
43	Contingent Liability	Verify letters of credit	H
44	Contingent Liability	Verify bills for collection	M
45	Contingent Liability	Check margin requirements	M
46	Fraud	Review fraud register	H
47	Fraud	Review suspicious transaction reports	H
48	Fraud	Check early warning signals	H
49	Fraud	Review internal audit observations	M
50	Closing	Identify audit adjustments	H
51	Closing	Prepare Memorandum of Changes	H
52	Closing	Discuss observations with branch manager	M
53	Closing	Prepare LFAR observations	H
54	Closing	Finalize branch audit report	H
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100