Ia Q2 2019-20
Ia Q2 2019-20
Ia Q2 2019-20
CA Ajay.C.Mehta
Chartered Accountant
Arunachala Logistics Private Limited
Internal Audit Report for the Quarter July 2019 to September 2019
Table of Contents
1. Follow-up Report for Q1 of FY 2019-2020
2. Operations
3. Procurement (including Tyres)
4. Driver Performance Incentives
5. Maintenance
6. C & F Operations
7. Pending Insurance Claims & Accidents
8. Statutory Compliances
9. Finance and Accounts
10. Other Areas covered
2
Arunachala Logistics Private Limited
Internal Audit Report for the Quarter July 2019 to September 2019
Summary of area wise observation rating:
5 C & F Operations 3 - 3 -
Pending Insurance
6 2 - 2 -
claims
7 Statutory compliances 23 2 19 2
9 Other areas 4 - 4 -
3
Arunachala Logistics Private Limited
Internal Audit Report for the Quarter July 2019 to September 2019
4
Follow-up Report for Q1 of FY 2019-2020
Amount/Issue Amount/Issue Amount/Issue Not
Area Issue Raised Remarks/ Annexure
Reported Rectified Rectified
Short Recovery (42,510) (11,521) (30,989) Details are given in Succeeding Slide
Operations - Diesel Recovery
Excess Recovery 10,729 - 10,729 Details are given in Succeeding Slide
Short Payment (9,254) (3,767) (5,487) Details are given in Succeeding Slide
Driver Performance
Excess Payment (3,767) 5,379 (9,146) Details are given in Succeeding Slide
5
Follow-up Report for Q1 of FY 2019-2020
Amount/Issue Amount/Issue Amount/Issue Not
Area Issue Raised Remarks/ Annexure
Reported Rectified Rectified
Finance & Accounts Late delivery charges 3,48,000 - 3,48,000 Details are not provided
6
Follow-up Report for Q1 of FY 2019-2020
Amount/Issue Amount/Issue Amount/Issue Not
Area Issue Raised Remarks/ Annexure
Reported Rectified Rectified
GST Short Paid on Other Income (6,145) - (6,145)
GST Excess Paid on Other
48,092 32,797 15,295
Income
7
Follow-up Report for Q1 of FY 2019-2020
Operations
Amount in `
Consolidated Excess/Short Diesel Recovery & Incentive
8
Follow-up Report for Q1 of FY 2019-2020
Operations
Amount in `
Kodad -Excess/Short Diesel Recovery & Incentive
9
Follow-up Report for Q1 of FY 2019-2020
Operations
Amount in `
Peapully Excess/Short Diesel Recovery & Incentive
10
Follow-up Report for Q1 of FY 2019-2020
Operations
Amount in `
Puttur- Excess/Short Diesel Recovery & Incentive
11
Follow-up Report for Q1 of FY 2019-2020
Operations
Amount in `
Hosur Excess/Short Diesel Recovery & Incentive
12
Follow-up Report for Q1 of FY 2019-2020
Operations
Amount in `
Coimbatore Excess/Short Diesel Recovery & Incentive
13
Follow-up Report for Q1 of FY 2019-2020
Operations
Amount in `
Basavakalyan Excess/Short Diesel Recovery & Incentive
14
Follow-up Report for Q1 of FY 2019-2020
Driver Performance Incentives
Amount in `
Consolidated – Driver Performance Incentives
15
Follow-up Report for Q1 of FY 2019-2020
Driver Performance Incentives
Amount in `
Kodad Peapully
16
Follow-up Report for Q1 of FY 2019-2020
Driver Performance Incentives
Amount in `
Puttur Hosur
17
Follow-up Report for Q1 of FY 2019-2020
Driver Performance Incentives
Amount in `
Coimbatore Basavakalyan
18
Follow-up Report for Q1 of FY 2019-2020
Driver Performance Incentives
Amount in `
Hassan– Driver Performance Incentives
19
Arunachala Logistics Private Limited
Internal Audit Report for the Quarter July 2019 to September 2019
2.Operations
20
Policy Procedural Regulatory System Deficiency
Lakhs
150
10 100
Q1 2019-20 Q2 2019-20 Q2 2018-19 Q1 2019-20 Q2 2019-20 Q2 2018-19
Crores
80 1
60 0
Q1 2019-20 Q2 2019-20 Q2 2018-19 Q1 2019-20 Q2 2019-20 Q2 2018-19
Crores
10
30 9
Q1 2019-20 Q2 2019-20 Q2 2018-19 Q1 2019-20 Q2 2019-20 Q2 2018-19
Crores
7
6 6
Q1 2019-20 Q2 2019-20 Q2 2018-19 Q1 2019-20 Q2 2019-20 Q2 2018-19
No of Trips Verified
5%
5% 5% Kodad
2% Peapully
19% Puttur
Hosur
22% 21% Srikakulam
Coimbatore
21% Basavakalyan
Hassan 23
Policy Procedural a Regulatory System Deficiency
Observation rating
The diesel recoveries and incentives are calculated based on the The above actual consumption of diesel is compared with the
target KMPL fixed and the actual Kms travelled as per the trip budgeted consumption and in the event of more consumption of
sheets. These calculations, trip wise has been cross verified with the diesel, the recovery is affected. In the event of better performance in
finance ledgers of Diesel Recovery and Diesel Incentives. terms of diesel consumption, the incentive is paid to the driver.
Based on the actual kms for the trip, the diesel that ought to have
been consumed is determined on the basis of the budgeted KMPL.
24
Policy Procedural a Regulatory System Deficiency
Observation rating
Key Observations
Amount in `
Consolidated Excess/Short Diesel Recovery and Incentive
Diesel Recovery Diesel Incentive
Unit As per audit As per diesel Net Excess / As per audit As per diesel Net (Excess) /
workings recovery ledger (Short) Recovery workings incentive ledger Short Incentive
Unit wise Summaries are given in the succeeding slides along with links to the detailed trip wise diesel recovery/incentive calculations.
25
Policy Procedural a Regulatory System Deficiency
Observation rating
Amount in `
Unit-1 Kodad - Excess/Short Diesel Recovery and Incentive
Diesel Recovery Diesel Incentive
Unit As per audit As per diesel Net Excess / As per audit As per diesel Net (Excess) /
workings recovery ledger (Short) Recovery workings incentive ledger Short Incentive
26
Policy Procedural a Regulatory System Deficiency
Observation rating
Amount in `
Unit-2 Peapully - Excess/Short Diesel Recovery and Incentive
Diesel Recovery Diesel Incentive
Unit As per audit As per diesel Net Excess / As per audit As per diesel Net (Excess) /
workings recovery ledger (Short) Recovery workings incentive ledger Short Incentive
27
Policy Procedural a Regulatory System Deficiency
Observation rating
Amount in `
Unit-3 Puttur - Excess/Short Diesel Recovery and Incentive
Diesel Recovery Diesel Incentive
Unit As per audit As per diesel Net Excess / As per audit As per diesel Net (Excess) /
workings recovery ledger (Short) Recovery workings incentive ledger Short Incentive
28
Policy Procedural a Regulatory System Deficiency
Observation rating
2.1 Excess/short diesel recoveries & incentives HIGH MED LOW
Amount in `
Unit-4 Hosur - Excess/Short Diesel Recovery and Incentive
Diesel Recovery Diesel Incentive
Unit As per audit As per diesel Net Excess / As per audit As per diesel Net (Excess) /
workings recovery ledger (Short) Recovery workings incentive ledger Short Incentive
29
Policy Procedural a Regulatory System Deficiency
Observation rating
2.1 Excess/short diesel recoveries & incentives HIGH MED LOW
Amount in `
Unit-5 Srikakulam - Excess/Short Diesel Recovery and Incentive
Diesel Recovery Diesel Incentive
Unit As per audit As per diesel Net Excess / As per audit As per diesel Net (Excess) /
workings recovery ledger (Short) Recovery workings incentive ledger Short Incentive
30
Policy Procedural a Regulatory System Deficiency
Observation rating
Amount in `
Unit-7 Coimbatore - Excess/Short Diesel Recovery and Incentive
Diesel Recovery Diesel Incentive
Unit As per audit As per diesel Net Excess / As per audit As per diesel Net (Excess) / Short
workings recovery ledger (Short) Recovery workings incentive ledger Incentive
31
Policy Procedural a Regulatory System Deficiency
Observation rating
Amount in `
Unit-8 Basavakalyan - Excess/Short Diesel Recovery and Incentive
Diesel Recovery Diesel Incentive
Unit As per audit As per diesel Net Excess / As per audit As per diesel Net (Excess) /
workings recovery ledger (Short) Recovery workings incentive ledger Short Incentive
32
Policy Procedural a Regulatory System Deficiency
Observation rating
Amount in `
Unit-9 Hassan - Excess/Short Diesel Recovery and Incentive
Diesel Recovery Diesel Incentive
Unit As per audit As per diesel Net Excess / As per audit As per diesel Net (Excess) /
workings recovery ledger (Short) Recovery workings incentive ledger Short Incentive
33
Policy Procedural a Regulatory System Deficiency
Observation rating
Manual
(8) 125 - - - 5,998 (948) 1,699 - - (3,507) 14 - - 3,373
Entries
Portal
- - - 14,592 - - - - - - - - - - 14,592
Error
Total (8) 10,991 (6,989) 23,645 - 5,998 (948) 4,444 - - (3,507) 14 - - 33,640
34
Policy Procedural a Regulatory System Deficiency
Observation rating
Manual Exemptions/Recoveries
• Short/Excess diesel recoveries were made from the drivers as the manual exemptions/recoveries were wrongly calculated. Details of the same
are as given below:
35
Policy Procedural a Regulatory System Deficiency
Observation rating
Manual Exemptions/Recoveries
• Short/Excess diesel recoveries were made from the drivers as the manual exemptions/recoveries were wrongly calculated. Details of the same
are as given below:
Recommendations
Manual exemptions should be properly calculated and approval for the same should be taken.
36
36
Policy Procedural a Regulatory System Deficiency a
Observation rating
Short Recovery - - -
Kodad Excess Recovery - 10,866 10,866
Unit - 1
Total - 10,866 10,866
Short Recovery 10,966 3,978 (6,989)
Peapully Excess Recovery 3,819 12,872 9,053
Unit - 2
Total 14,785 16,850 2,065
Short Recovery - - -
Hosur Excess Recovery - 2,745 2,745
Unit - 4
Total - 2,745 2,745
Recommendations:
KMPL should be updated in portal as and when the KMPL is changed and Effective date should not be backdated.
37
Policy Procedural Regulatory System Deficiency a
Observation rating
Portal Errors
• Excess Diesel recovery was made from the drivers as the diesel recovery entry was wrongly posted. Summary of the same are as given below:
• In unit-2, KMPL for Bulkers is picked based on the tonnage wise slabs fixed in portal. In few instances first slab KMPL’s are picked even though
the tonnage carried falls in other slabs.
Diesel Recovery as Diesel Recovery (Short)/Excess
Unit Particulars Annexure
per Calculation as per ledger paid
Short Recovery - - -
Peapully Excess Recovery 658 14,792 14,133
Unit - 2
Total 658 14,792 14,133
Recommendations:
Necessary rectification entries are to be passed
38
Policy Procedural a Regulatory System Deficiency
Observation rating
39
Policy Procedural a Regulatory System Deficiency
Observation rating
Recommendations
• Necessary rectification entries are to be passed.
40
Policy Procedural Regulatory System Deficiency a
Observation rating
Excess Incentive - - -
Kodad Short Incentive 13,205 2,904 10,301
Unit - 1
Total 13,205 2,904 10,301
Excess Incentive - - -
Hosur Short Incentive 2,486 1,734 752
Unit - 4
Total 2,486 1,734 752
Recommendations
KMPL should be updated in portal & circulars as and when the KMPL is changed and Effective date should not be backdated.
41
Policy Procedural a Regulatory System Deficiency
Observation rating
Manual Reversal's
• Short diesel incentives were given to the drivers as the manually nullified/reversed entries were wrongly calculated. Details of the same are as
given below:
Diesel Incentive as Diesel Incentive as
Unit Particulars Short/(Excess) paid Annexure
per Calculation per ledger
Excess Incentive - 1,351 (1,351)
Peapully Short Incentive - - -
Total - 1,351 (1,351) Unit - 2
Excess Incentive - - -
Coimbatore Short Incentive 113 - 113
Total 113 - 113 Unit - 7
Recommendations
• Manual reversals/nullifications should be properly calculated and approval for the same should be taken.
42
Policy Procedural Regulatory System Deficiency a
Observation rating
Excess Incentive - - -
Kodad Short Incentive 1,293 - 1,293
Unit - 1
Total 1,293 - 1,293
Recommendations
KMPL should be updated in portal & circulars as and when the KMPL is changed. 43
2.1.4 Excess/short diesel recoveries & incentives
Statistical Analysis of Q1(FY 2018-19) & Q2 (FY 2019-20)
• Given below is the comparison showing the percentage of discrepancies in the trip sheets between Q1 (FY 2019-20) & Q2 (FY 2019-20)
pertaining to Unit – 1.
Diesel Recovery Diesel Incentive
Unit-1 Unit-1
Q.E. 30th
Particulars Q.E. 30th June, Particulars Q.E. 30th June, Q.E. 30th
September,
2019 2019 September, 2019
2019
No. of trips Verified 3352 2359 No. of slips Verified 649 508
No. of Trips with Variances 1 10 No. of Slips with Variances 1 7
Percentage of Trips with variances 0.03% 0.42% Percentage of Slips with variances 0.15% 1.38%
Change (Increase)/Decrease (0.39%) Change (Increase)/Decrease (1.22%)
No. of Instances of Short Recovery 1 1 No. of Instances of Excess Incentive 1 -
Short Recovery (502) (8) Excess Incentive (941) -
Average short recovery per trip (502) (8) Average excess incentive per Slip (941) -
Change (Increase)/Decrease 98.41% Change (Increase)/Decrease 100.00%
Excess Recovery - 10,991 Short Incentive - 11,594
Net (Short)/Excess Recovery (502) 10,983 Net Short/(Excess) Incentive (941) 11,594
44
Policy Procedural Regulatory System Deficiency
Observation rating
1.60% 1 0.94
Thousands
1.38% 1
1.40%
1
1.20%
1
1.00%
1
0.80% 0.50
1
0.60% 0
0.42%
0.40% 0
0.20% 0.15% 0
0.03%
0.00% 0
0.01 -
Discrepancies in Discrepancies in 0
Recoveries incentives Short Recoveries Excess Incentives
Q1 0.03% 0.15% Q1 502 941
Q2 0.42% 1.38% Q2 8 0
45
2.1.4 Excess/short diesel recoveries & incentives
Statistical Analysis of Q1(FY 2019-20) & Q2 (FY 2019-20)
• Given below is the comparison showing the percentage of discrepancies in the trip sheets between Q1 (FY 2019-20) & Q2 (FY 2019-20)
pertaining to Unit – 2.
Diesel Recovery Diesel Incentive
Unit-2 Unit-2
Q.E. 30th
Particulars Q.E. 30th June, Particulars Q.E. 30th June, Q.E. 30th
September,
2019 2019 September, 2019
2019
No. of trips Verified 1963 2530 No. of slips Verified 446 490
No. of Trips with Variances 15 26 No. of Slips with Variances 13 3
Percentage of Trips with variances 0.76% 1.03% Percentage of Slips with variances 2.91% 0.61%
Change (Increase)/Decrease (0.26%) Change (Increase)/Decrease 2.30%
No. of Instances of Short Recovery 9 4 No. of Instances of Excess Incentive 2 3
Short Recovery (23,037) (6,989) Excess Incentive (765) (2,329)
Average short recovery per trip (2,560) (1,747) Average excess incentive per Slip (383) (776)
Change (Increase)/Decrease 31.74% Change (Increase)/Decrease (102.96%)
Excess Recovery 3,149 23,646 Short Incentive 6,165 -
Net (Short)/Excess Recovery (19,888) 16,657 Net Short/(Excess) Incentive 5,400 (2,329)
46
Policy Procedural Regulatory System Deficiency
Observation rating
Thousands
2.91%
3.00%
20
2.50%
2.00% 15
1.50%
1.03% 10
1.00% 0.76% 6.99
0.61%
0.50% 5
2.33
0.77
0.00%
Discrepancies in -
Discrepancies in incentives Short Recoveries Excess Incentives
Recoveries
Q1 23,037 765
Q1 0.76% 2.91%
Q2 6,989 2,329
Q2 1.03% 0.61%
47
2.1.4 Excess/short diesel recoveries & incentives
Statistical Analysis of Q1(FY 2019-20) & Q2 (FY 2019-20)
• Given below is the comparison showing the percentage of discrepancies in the trip sheets between Q1 (FY 2019-20) & Q2 (FY 2019-20)
pertaining to Unit – 3.
Diesel Recovery Diesel Incentive
Unit-3 Unit-3
Q.E. 30th
Particulars Q.E. 30th June, Particulars Q.E. 30th June, Q.E. 30th
September,
2019 2019 September, 2019
2019
No. of trips Verified 2611 2558 No. of slips Verified 441 582
No. of Trips with Variances 3 8 No. of Slips with Variances 1 0
Percentage of Trips with variances 0.11% 0.31% Percentage of Slips with variances 0.23% 0.00%
Change (Increase)/Decrease (0.20%) Change (Increase)/Decrease 0.23%
No. of Instances of Short Recovery 1 - No. of Instances of Excess Incentive - -
Short Recovery (710) - Excess Incentive - -
Average short recovery per trip (710) - Average excess incentive per Slip - -
Change (Increase)/Decrease 100.00% Change (Increase)/Decrease 0.00%
Excess Recovery 1,273 5,998 Short Incentive 7 -
Net (Short)/Excess Recovery 563 5,998 Net Short/(Excess) Incentive 7 -
48
Policy Procedural Regulatory System Deficiency
Observation rating
Hundreds
7.10
0.30% 7
0.25% 0.23% 6
0.20% 5
4
0.15%
0.11%
3
0.10%
2
0.05%
0.00% 1
0.00% - - -
Discrepancies in 0
Discrepancies in incentives Short Recoveries Excess Incentives
Recoveries
Q1 0.11% 0.23% Q1 710 -
Q2 0.31% 0.00% Q2 - -
49
2.1.4 Excess/short diesel recoveries & incentives
Statistical Analysis of Q1(FY 2019-20) & Q2 (FY 2019-20)
• Given below is the comparison showing the percentage of discrepancies in the trip sheets between Q1 (FY 2019-20) & Q2 (FY 2019-20)
pertaining to Unit – 4.
Diesel Recovery Diesel Incentive
Unit-4 Unit-4
Q.E. 30th
Particulars Q.E. 30th June, Particulars Q.E. 30th June, 2019 Q.E. 30th
September,
2019 September, 2019
2019
No. of trips Verified 2876 2692 No. of slips Verified 539 500
No. of Trips with Variances 19 33 No. of Slips with Variances 11 1
Percentage of Trips with variances 0.66% 1.23% Percentage of Slips with variances 2.04% 0.20%
Change (Increase)/Decrease (0.57%) Change (Increase)/Decrease 1.84%
No. of Instances of Short Recovery 16 4 No. of Instances of Excess Incentive 7 -
Short Recovery (15,879) (948) Excess Incentive (4,419) -
Average short recovery per trip (992) (237) Average excess incentive per Slip (631) -
Change (Increase)/Decrease 76.12% Change (Increase)/Decrease 100.00%
Excess Recovery 5,422 4,444 Short Incentive 18,512 752
Net (Short)/Excess Recovery (10,457) 3,496 Net Short/(Excess) Incentive 14,093 752
50
Policy Procedural Regulatory System Deficiency
Observation rating
Hundreds
158.79
2.04% 160
2.00%
140
1.50% 120
1.23%
100
1.00% 80
0.66%
60 44.19
0.50%
0.20% 40
20 9.48
0.00% -
Discrepancies in Discrepancies in 0
Recoveries incentives Short Recoveries Excess Incentives
Q1 0.66% 2.04% Q1 15879 4419
Q2 1.23% 0.20% Q2 948 0
51
2.1.4 Excess/short diesel recoveries & incentives
Statistical Analysis of Q1(FY 2019-20) & Q2 (FY 2019-20)
• Given below is the comparison showing the percentage of discrepancies in the trip sheets between Q1 (FY 2019-20) & Q2 (FY 2019-20)
pertaining to Unit – 7.
Diesel Recovery Diesel Incentive
Unit-7 Unit-7
Q.E. 30th
Particulars Q.E. 30th June, Particulars Q.E. 30th June, Q.E. 30th
September,
2019 2019 September, 2019
2019
No. of trips Verified 622 569 No. of slips Verified 179 150
No. of Trips with Variances 2 0 No. of Slips with Variances 1 1
Percentage of Trips with variances 0.32% 0.00% Percentage of Slips with variances 0.56% 0.67%
Change (Increase)/Decrease 0.32% Change (Increase)/Decrease (0.11%)
No. of Instances of Short Recovery 1 - No. of Instances of Excess Incentive - -
Short Recovery (2,382) - Excess Incentive - -
Average short recovery per trip (2,382) - Average excess incentive per Slip - -
Change (Increase)/Decrease 100.00% Change (Increase)/Decrease 0.00%
Excess Recovery 750 - Short Incentive 2,181 113
Net (Short)/Excess Recovery (1,632) - Net Short/(Excess) Incentive 2,181 113
52
Policy Procedural Regulatory System Deficiency
Observation rating
0.80% 30
Hundreds
0.70% 0.67%
25 23.82
0.60% 0.56%
0.50% 20
0.40%
0.32% 15
0.30%
0.20% 10
0.10% 5
0.00%
0.00% - - -
Discrepancies in 0
Discrepancies in incentives
Recoveries Short Recoveries Excess Incentives
Q1 0.32% 0.56% Q1 2382 0
Q2 0.00% 0.67% Q2 0 0
53
2.1.4 Excess/short diesel recoveries & incentives
Statistical Analysis of Q1(FY 2019-20) & Q2 (FY 2019-20)
• Given below is the comparison showing the percentage of discrepancies in the trip sheets between Q1 (FY 2019-20) & Q2 (FY 2019-20)
pertaining to Unit – 8.
Diesel Recovery Diesel Incentive
Unit-8 Unit-8
th Q.E. 30th
Particulars Q.E. 30 June, Particulars Q.E. 30th June, Q.E. 30th
September,
2019 2019 September, 2019
2019
No. of trips Verified 941 545 No. of slips Verified 193 152
No. of Trips with Variances 4 2 No. of Slips with Variances - -
Percentage of Trips with variances 0.43% 0.37% Percentage of Slips with variances 0.00% 0.00%
Change (Increase)/Decrease 0.06% Change (Increase)/Decrease 0.00%
No. of Instances of Short Recovery 1 1 No. of Instances of Excess Incentive - -
Short Recovery (3) (3,507) Excess Incentive - -
Average short recovery per trip (3) (3,507) Average excess incentive per Slip - -
Change (Increase)/Decrease (1,16,803.67%) Change (Increase)/Decrease 0.00%
Excess Recovery 130 14 Short Incentive - -
Net (Short)/Excess Recovery 127 (3,493) Net Short/(Excess) Incentive - -
54
Policy Procedural Regulatory System Deficiency
Observation rating
0.50% 40
Hundreds
0.43% 35.07
0.45% 35
0.40% 0.37%
30
0.35%
0.30% 25
0.25% 20
0.20%
15
0.15%
0.10% 10
0.05% 5
0.00% 0.00%
0.00% 0.03 - -
Discrepancies in 0
Discrepancies in incentives Short Recoveries Excess Incentives
Recoveries
Q1 Q1 3 0
0.43% 0.00%
Q2 Q2 3507 0
0.37% 0.00%
55
2.1.4 Excess/short diesel recoveries & incentives
Statistical Analysis of Q1(FY 2019-20) & Q2 (FY 2019-20)
• Given below is the comparison showing the percentage of discrepancies in the trip sheets between Q1 (FY 2019-20) & Q2 (FY 2019-20)
pertaining to Unit – 9.
Diesel Recovery Diesel Incentive
Unit-9 Unit-9
th
Particulars Q.E. 30 June, Q.E. 30th Particulars Q.E. 30th
Q.E. 30th June, 2019
2019 September, 2019 September, 2019
No. of trips Verified 774 637 No. of slips Verified 174 169
Percentage of Trips with variances 0.00% 0.00% Percentage of Slips with variances 0.00% 0.00%
Change (Increase)/Decrease 0.00% Change (Increase)/Decrease 0.00%
No. of Instances of Short Recovery - - No. of Instances of Excess Incentive - -
Short Recovery - - Excess Incentive - -
Average short recovery per trip - - Average excess incentive per Slip - -
Change (Increase)/Decrease 0.00% Change (Increase)/Decrease -
Excess Recovery - - Short Incentive - -
Net (Short)/Excess Recovery - - Net Short/(Excess) Incentive - -
56
Policy Procedural Regulatory System Deficiency
Observation rating
100.00% 0
Hundreds
90.00% 0
80.00% 0
70.00% 0
60.00% 0
50.00% 0
40.00% 0
30.00% 0
20.00%
0
10.00%
0.00% 0.00% 0.00% 0.00% 0
0.00% - - - -
Discrepancies in Discrepancies in 0
Recoveries incentives Short Recoveries Excess Incentives
Q1 Q1 0 0
0.00% 0.00%
Q2 Q2 0 0
0.00% 0.00%
57
Operations – Expenditure
Snapshot of the Trip sheets closed during the Quarter July 2019 to September 2019
Expenditure
No. of Trips
Unit
Percentage of
No of Trips Closed Vouched Not Vouched
Verification
Kodad 2359 239 2120 10.13
Peapully 2530 307 2223 12.13
Puttur 2558 257 2301 10.05
Hosur 2692 268 2424 9.96
Srikakulam 235 20 215 8.51
Coimbatore 569 54 515 9.49
Basavakayan 545 62 483 11.38
Hassan 637 72 565 11.30
Total 12125 1279 10846 10.55
5% 5% 5%
No of Trips Closed Kodad
19% Peapully
2% Puttur
Hosur
22% Srikakulam
21% Coimbatore
Basavakalyan
21% Hassan 58
Policy Procedural a Regulatory System Deficiency
Observation rating
2.2 Trip route Expenditures- Budget vs Actual HIGH MED LOW
Key Observations
Amount in `
Consolidated - Trip Expenditure - Budget V/S Actuals
Break Up
Consolidated
Excess of actuals over budgets (3,669)
Unit wise trip wise actual v/s budgets are given in the succeeding slides.
59
59
Policy Procedural a Regulatory System Deficiency
Observation rating
Total
Expense Head Short (Excess) Short (Excess) Short (Excess) Short (Excess) Short (Excess) Short (Excess) Short (Excess) Short (Excess)
Loading Charges - - - - - - - - - - - - - - - - -
Toll Gates (120) 5,518 (3,230) 72,290 - 48,260 - 275 - 12,218 - 355 - 4,725 - 121 1,40,412
Kanta - - - - - - - - - - - - - - - - -
Village Tax - - - - - - - - - - - - - - - - -
Total (120) 5,577 (3,230) 72,890 - 52,210 - 275 - 12,218 - 595 (319) 15,905 - 125 1,56,127
60
Policy Procedural a Regulatory System Deficiency
Observation rating
2.2 Trip route Expenditures- Budget vs Actual HIGH MED LOW
Amount in ` Summary
Unit-1-Kodad - Trip Expenditure - Budget V/S Actuals Excess of Actuals Excess of Budgets
Expenditure Budget Actual Variance
over Budgets over Actual
Budgeted Actual
Unit Variance
Expenditure Expenditure Loading Charges - - - -
-
1,41,591 1,36,133 5,458 Unloading Charges - - - - -
Break Up
Kodad Return Load Load Ch 54,140 54,140 -
-
-
Excess of actuals over budgets (120)
Ret Load Un-Load ch 14,835 14,776 - 59 59
Excess of budgets over actuals 5,518 Toll Gates 56,626 51,228 (120) 5,518 5,398
Kanta - - - - -
• The Summary in a form a chart is given in the succeeding
slide. Village Tax 11,590 11,590 - - -
6161
Trip route Expenditures- Budget vs Actual – Kodad
60
55 56
50
40
30
10
- - - - - - - 1 - - - - - - - -
-
(1) (1)
(10)
1 2 3 4 5 6 7 8 9 10
Excess of Actuals over Budgets - - - - (120) - - - - (120)
Excess of Budgets over Actuals - - - 59 5,518 - - - - 5,577
Policy Procedural a Regulatory System Deficiency
Observation rating
2.2 Trip route Expenditures- Budget vs Actual HIGH MED LOW
Amount in `
Summary
Unit-2-Peapully - Trip Expenditure - Budget V/S Actuals
Excess of Actuals Excess of Budgets
Budgeted Actual Expenditure Budget Actual Variance
Unit Variance over Budgets over Actual
Expenditure Expenditure
Loading Charges - - - - -
3,36,900 2,67,240 69,660
Unloading Charges - - - - -
Break Up Return Load Load Ch 18,100 18,100 - - -
Peapully
Excess of actuals over budgets (3,230) Ret Load Un-Load ch - - - - -
Kanta - - - - -
• The Summary in a form a chart is given in the succeeding
Village Tax 450 450 - - -
slide
Other Trip Expenses - - - - -
63
Trip route Expenditures- Budget vs Actual - Peapully
80
Thousands
72 73
70
60
50
40
20
10
- - - - - - - - 1 - - - - - - -
-
(3) (3)
(10)
1 2 3 4 5 6 7 8 9 10
Excess of Budgets over Actual - - - - 72,290 600 - - - 72,890
Excess of Actuals over Budgets - - - - (3,230) - - - - (3,230)
Policy Procedural a Regulatory System al
Deficiency
Observation rating
2.2 Trip route Expenditures- Budget vs Actual HIGH MED LOW
Amount in ` Summary
Unit-3-Puttur - Trip Expenditure - Budget V/S Actuals
Excess of Actuals Excess of Budgets
Expenditure Budget Actual Variance
Budgeted Actual over Budgets over Actual
Unit Variance
Expenditure Expenditure
Loading Charges - - - - -
Excess of budgets over actuals 52,210 Toll Gates 1,38,840 90,580 - 48,260 48,260
Kanta - - - - -
Hundreds
522
500 483
400
300
Excess of Budgets over Actual
Excess of Actuals over Budgets
200
100
39
- - - - 1 - - - - - - - - - - - -
-
Loading Unloading Return Load Ret Load Fixed Food Other Trip
Toll Gates Kanta Village Tax
Charges Charges Load Ch Un-Load ch Expenses Expenses
Excess of Budgets over Actual - - 100 - 48,260 3,850 - - - 52,210
Excess of Actuals over Budgets - - - - - - - - - -
Policy Procedural a Regulatory System Deficiency
Observation rating
2.2 Trip route Expenditures- Budget vs Actual HIGH MED LOW
Amount in `
Summary
Unit-4-Hosur - Trip Expenditure - Budget V/S Actuals
Budgeted Actual Excess of Actuals Excess of Budgets
Unit Variance Expenditure Budget Actual Variance
Expenditure Expenditure over Budgets over Actual
Excess of budgets over actuals 275 Ret Load Un-Load ch 250 250 - - -
Kanta - - - - -
• The Summary in a form a chart is given in the succeeding Total 1,94,661 1,94,386 - 275 275
slide
67
67
Trip route Expenditures- Budget vs Actual - Hosur
3
Hundreds
3 3
2
Excess of Actuals over Budgets
Excess of Budgets over Actual
- - - - - - - - - - - - - - - - - -
-
Loading Unloading Return Load Ret Load Un- Fixed Food Other Trip
Toll Gates Kanta Village Tax
Charges Charges Load Ch Load ch Expenses Expenses
Excess of Actuals over Budgets - - - - - - - - - -
Excess of Budgets over Actual - - - - 275 - - - - 275
Policy Procedural a Regulatory System Deficiency
Observation rating
2.2 Trip route Expenditures- Budget vs Actual HIGH MED LOW
Amount in ` Summary
Unit-5-Srikakulam - Trip Expenditure - Budget V/S Actuals
Excess of Actuals Excess of Budgets
Budgeted Actual Expenditure Budget Actual Variance
Unit Variance over Budgets over Actual
Expenditure Expenditure
Unloading Charges - - - - -
Break Up
Srikakulam Return Load Load Ch 6,110 6,110 - - -
Excess of actuals over budgets -
Ret Load Un-Load ch 2,000 2,000 - - -
Excess of budgets over actuals 12,218
Toll Gates 21,840 9,622 - 12,218 12,218
Kanta - - - - -
69
69
Trip route Expenditures- Budget vs Actual - Coimbatore
14
Thousands
12 12
12
10
- - - - - - - - - - - - - - - - - -
-
Loading Unloading Return Load Ret Load Un- Fixed Food Other Trip
Toll Gates Kanta Village Tax
Charges Charges Load Ch Load ch Expenses Expenses
Excess of Actuals over Budgets - - - - - - - - - -
Excess of Budgets over Actual - - - - 12,218 - - - - 12,218
Policy Procedural a Regulatory System Deficiency
Observation rating
2.2 Trip route Expenditures- Budget vs Actual HIGH MED LOW
Amount in ` Summary
Unit-7-Coimbatore - Trip Expenditure - Budget V/S Actuals
Excess of Actuals Excess of Budgets
Budgeted Actual Expenditure Budget Actual Variance
Unit Variance over Budgets over Actual
Expenditure Expenditure
Kanta - - - -
Village Tax - - - - -
71
71
Trip route Expenditures- Budget vs Actual - Coimbatore
7
Hundreds
6
6
4
4
- - - - - - - - - - - - - - - - -
-
Loading Unloading Return Load Ret Load Un- Fixed Food Other Trip
Toll Gates Kanta Village Tax
Charges Charges Load Ch Load ch Expenses Expenses
Excess of Actuals over Budgets - - - - - - - - - -
Excess of Budgets over Actual - - 240 - 355 - - - - 595
Policy Procedural a Regulatory System Deficiency
Observation rating
2.2 Trip route Expenditures- Budget vs Actual HIGH MED LOW
Summary
Amount in `
Unit-8-Basavakalyan - Trip Expenditure - Budget V/S Actuals
Excess of Actuals Excess of Budgets
Expenditure Budget Actual Variance
Budgeted Actual over Budgets over Actual
Unit Variance
Expenditure Expenditure
Loading Charges - - - - -
2,77,732 2,62,145 15,587
Unloading Charges 2,08,463 1,97,951 (319) 10,830 10,512
Break Up
Basavakalyan Return Load Load Ch - - - - -
Excess of actuals over budgets (319)
Ret Load Un-Load ch - - - - -
Excess of budgets over actuals 15,905
Toll Gates 8,520 3,795 - 4,725 4,725
Village Tax - - - - -
Hundreds
159
160
140
120
108
100
80
Excess of Actuals over Budgets
40
20
4
- - - - - - - - - - - - - -
-
(3) (3)
(20)
Loading Unloading Return Load Ret Load Fixed Food Other Trip
Toll Gates Kanta Village Tax
Charges Charges Load Ch Un-Load ch Expenses Expenses
Excess of Actuals over Budgets - (319) - - - - - - - (319)
Excess of Budgets over Actual - 10,830 - - 4,725 350 - - - 15,905
Policy Procedural a Regulatory System Deficiency
Observation rating
3.2 Trip route Expenditures- Budget vs Actual HIGH MED LOW
Amount in ` Summary
Unit-9-Hassan- Trip Expenditure - Budget V/S Actuals
Excess of Actuals Excess of Budgets
Expenditure Budget Actual Variance
Budgeted Actual over Budgets over Actual
Unit Variance
Expenditure Expenditure
Loading Charges - - - - -
68,530 68,405 125
Unloading Charges - - - - -
Break Up Return Load Load Ch 30,680 30,680 - - -
Hassan
Excess of actuals over budgets -
Ret Load Un-Load ch - - - - -
Excess of budgets over actuals 125 Toll Gates 450 329 - 121 121
Kanta - - - - -
Village Tax - - - - -
• The Summary in a form a chart is given in the succeeding Total 68,530 68,405 - 125 125
slide
75
75
Trip route Expenditures- Budget vs Actual - Hassan
1
Hundreds
1
1
1
0
- - - - - - - - - - - - - - - - -
-
Loading Unloading Return Load Ret Load Un- Fixed Food Other Trip
Toll Gates Kanta Village Tax
Charges Charges Load Ch Load ch Expenses Expenses
Excess of Actuals over Budgets - - - - - - - - - -
Excess of Budgets over Actual - - - - 121 4 - - - 125
Policy Procedural a Regulatory System Deficiency
Observation rating
Observations
• Cement unloading charges were Short/(Excess) paid, details of the same are as given in the below annexures:
2.2.2 Excess/short Return load Loading / Un Loading charges HIGH MED LOW
Observations
• Return load loading charges were Short/(Excess) paid, details of the same are as given in the below annexures
• Return load Unloading charges were Short/(Excess) paid, details of the same are as given in the below annexures
78
Policy Procedural a Regulatory System Deficiency
Observation rating
Observations
• Toll Charges
Unit Budget Actual Variance Annexure
Kodad 18,866 13,468 5,398
Unit 1
Observations
Trip Wise Toll Charge Deductions (FASTag) – We have mapped Toll Charge based on the transaction date against the Trip period. We have
verified 10% of the trips closed during the Quarter. We have observed that there are toll deductions which are not as per the budgets prepared
for FASTag Toll Charges. Details are given in the annexure below:
Q2
Unit -1 Unit - 3 Unit - 4 Unit - 5 Unit - 7 Unit - 8 Unit - 9
80
Arunachala Logistics Private Limited
Internal Audit Report for the Quarter July 2019 to September 2019
81
Procurement(Including Tyres)-Process Workflow
82
a
3.1 Issues relating to PO, GRN and Policy Procedural Regulatory System Deficiency
Observation rating
Recommendations
• To ensure that there are no delays in raising GRN’s.
• To ensure that the inward movement of materials is properly
recorded and stamped at security gate before it reaches the stores.
84
Policy Procedural a Regulatory System Deficiency
Observation rating
3.2 PO’s are raised only for internal regularization HIGH MED LOW
No of days by
which Invoice No. of instances
Recommendations
precedes the PO
0-5 111 • To ensure that PO’s are issued to the suppliers and on the strength of which
6 – 10 21
PO raised after
the supplies are to be affected.
11 – 30 23 Invoice
>30 4
Total 159 Management’s Response
85
Policy Procedural a Regulatory System Deficiency
Observation rating
• During the course of audit, it is observed that in 45 instances, copy of the • To ensure that all the invoices are available on record.
invoice was attached to the GRN instead of the original Invoice(without • To ensure that the original invoices are kept on record,
insurance stamp). Such instances are annexed below: in the event they are submitted for insurance claims,
appropriate stamp on copy of the bill is to be affixed.
Missing GRNs
87
Policy Procedural a Regulatory a System Deficiency
Observation rating
3.5
2.6 Excess/(Short) GRN amounts
Other Observations HIGH MED LOW
Key Observation
• It is observed that in 13 instances amounts on the purchase voucher are not matching with the invoice amounts, Such instance are annexed
below:
Potential Impact
• Differences in balance as per vendor books of account and ALPL books of accounts.
Recommendation
• Periodic ledger statements from vendors should be obtained and reconciliation should be done and documented.
88
3.6 Issues relating to PO, GRN and
Security Inward dates
Statistical Analysis of Q1 (FY 2019-20) & Q2 (FY 2019-20)
Number of Instances in %
40.00%
35.00% 33.59%
29.98%
30.00%
25.00%
20.00%
15.00%
10.21%
10.00% 7.96%
5.77% 5.55%
5.00%
0.00%
P.O after Invoice Date Delay in raising GRN Security Inward prior to P.O
Q1 10.21% 33.59% 5.77%
Q2 7.96% 29.98% 5.55%
90
Policy Procedural Regulatory System Deficiency
3.6 Issues relating to PO, GRN and Observation rating
Number of Instances in %
20.00% 18.19%
18.00%
16.00%
14.00%
12.00% 10.40%
10.00%
8.00%
6.00%
4.00% 2.16%
2.00% 0.26% 0.15% 0.34%
0.00%
Invoice not found GRN raised prior to Security Inward Absence of security stamp
Q1 2.16% 0.15% 10.40%
Q2 0.26% 0.34% 18.19%
91
Arunachala Logistics Private Limited
Internal Audit Report for the Quarter July 2019 to September 2019.
92
92
Policy Procedural a Regulatory System Deficiency
Observation rating
4.1 Calculations of DP Incentives HIGH MED LOW
Key Observations
• Driver Performance incentive slip consists of various kind of incentives to the driver such as Kilometer incentive, Senior Active Driver
Incentive, Super Active driver Incentive, Good Driver Incentive and Return load commission.
• We have verified 100% of the driver performance incentive slips generated during the quarter.
• Based on the various reports generated from the Portal/SAP and on the basis of various incentive schemes and incentive budgets in force we
have re-calculated the incentives payable. With regards to verification of incentive payments/calculations, reliance is placed on data generated
and given to us by the developers of the Web Portal. The differences in the calculation are given in succeeding slides.
93
Policy Procedural a Regulatory System Deficiency
Observation rating
4.1 Driver Performance Incentives HIGH MED LOW
Key Observations
Amount in `
Consolidated – Driver Performance Incentives
94
94
Policy Procedural a Regulatory System Deficiency
Observation rating
4.1 Driver Performance Incentives HIGH MED LOW
Amount in ` Expenditure
As per Our
As per Ledger
Unfavourable Favourable
Variance
Calculation Variance Variance
Unit-1-Kodad – Driver Performance Incentives
Driver
20,88,381 20,88,447 (67) - (67)
As per Performance
Unit As per Ledger Variance
calculation KMS Incentives 1,23,48,761 1,23,48,761 - - -
1,55,62,093 1,55,20,656 41,437 R\L Commission 3,89,277 3,49,750 (2,438) 41,966 39,528
9595
Driver Performance Incentives - Kodad
500
Hundreds
439.66
419.66
400
300
200
Excess Payment to
Driver
100
Short Payment to
Driver
20.00
- - - - - - - - -
-
(0.67) (0.24)
(24.38) (25.29)
(100)
Driver R\L Punctual Senior Active Good Driver Other
KMS Incentives Total
Performance Commission Incentive Incentive Incentive Incentives
Excess Payment to Driver (67) - (2,438) - - - (24) (2,529)
Short Payment to Driver - - 41,966 - 2,000 - - 43,966
Policy Procedural a Regulatory System Deficiency
Observation rating
4.1 Driver Performance Incentives HIGH MED LOW
Amount in ` Expenditure
As per Our
As per Ledger
Unfavourable Favourable
Variance
Calculation Variance Variance
Unit-2-Peapully – Driver Performance Incentives
Driver Performance 25,76,498 25,76,498 - - -
As per
Unit As per Ledger Variance KMS Incentives 2,03,38,961 2,03,34,163 - 4,799 4,799
Calculation
9797
Driver Performance Incentives - Peapully
80
Hundreds
72.99
70
60
50 47.99
40
30
25.00
Excess Payment to
20 Driver
Short Payment to
10 Driver
- - - - - - - - - - -
-
(10)
(12.15) (12.15)
(20)
Driver R\L Punctual Senior Active Good Driver Other
KMS Incentives Total
Performance Commission Incentive Incentive Incentive Incentives
Excess Payment to Driver - - (1,215) - - - - (1,215)
Short Payment to Driver - 4,799 - - 2,500 - - 7,299
Policy Procedural a Regulatory System Deficiency
Observation rating
4.1 Driver Performance Incentives HIGH MED LOW
Amount in `
As per Our Unfavourable Favourable
Unit3-Puttur – Driver Performance Incentives Expenditure As per Ledger Variance
Calculation Variance Variance
Driver
21,53,916 21,53,916 - - -
As per Performance
Unit As per Ledger Variance
Calculation
KMS Incentives 1,23,74,295 1,23,74,187 - 108 108
9999
Driver Performance Incentives - Puttur
60
Hundreds
53.23
50
40
30 28.69
22.50
Excess Payment to
20
Driver
Short Payment to
Driver
10
1.08 0.96
- - - - - - - - -
-
(0.16) (0.16)
(10)
Driver R\L Punctual Senior Active Good Driver Other
KMS Incentives Total
Performance Commission Incentives Incentive Incentive Incentives
Excess Payment to Driver - - - - - - (16) (16)
Short Payment to Driver - 108 2,869 - 2,250 - 96 5,323
Policy Procedural Regulatory System Deficiency a
Observation rating
Amount in ` Expenditure
As per Our
As per Ledger
Unfavourable Favourable
Variance
Calculation Variance Variance
Unit-4-Hosur – Driver Performance Incentives
Driver
24,45,113 24,45,113 - - -
Performance
As per
Unit As per Ledger Variance
Calculation KMS Incentives 1,37,17,326 1,37,17,326 - - -
Other Incentives - - - - -
101
10
1
Driver Performance Incentives - Hosur
45
Hundreds
40 39.29
35
30
26.25
25
20 Excess Payment to
Driver
15 Short Payment to
13.04 Driver
10
- - - - - - - - - - - - -
-
Driver R\L Punctual Senior Active Good Driver Other
KMS Incentives Total
Performance Commission Incentive Incentive Incentive Incentives
Excess Payment to Driver - - - - - - - -
Short Payment to Driver - - 1,304 - 2,625 - - 3,929
Policy Procedural Regulatory System Deficiency a
Observation rating
4.1 Driver Performance Incentives HIGH MED LOW
10
103
3
Driver Performance Incentives - Srikakulam
0
Hundreds
0
Excess Payment to
0 Driver
Short Payment to
0 Driver
- - - - - - - - - - - - - - - -
-
Driver R\L Punctual Senior Active Good Driver Other
KMS Incentives Total
Performance Commission Incentive Incentive Incentive Incentives
Excess Payment to Driver - - - - - - - -
Short Payment to Driver - - - - - - - -
Policy Procedural Regulatory System Deficiency a
Observation rating
4.1 Driver Performance Incentives HIGH MED LOW
Amount in ` Expenditure
As per Our
As per Ledger
Unfavourable Favourable
Variance
Calculation Variance Variance
Unit-7-Coimbatore – Driver Performance Incentives
Driver
7,72,822 7,72,822 - - -
Performance
As per
Unit As per Ledger Variance
Calculation KMS Incentives 51,04,262 51,04,262 - - -
10
105
5
Driver Performance Incentives - Coimbatore
160
Hundreds
146.34 146.34
140
120
100
80
60
Excess Payment to
Driver
40 Short Payment to
Driver
20
- - - - - - - - - - - -
-
(5.42) (5.42)
(20)
Driver R\L Punctual Senior Active Good Driver Other
KMS Incentives Total
Performance Commission Incentive Incentive Incentive Incentives
Excess Payment to Driver - - (542) - - - - (542)
Short Payment to Driver - - 14,634 - - - - 14,634
Policy Procedural Regulatory System Deficiency a
Observation rating
4.1 Driver Performance Incentives HIGH MED LOW
Amount in ` Expenditure
As per Our
As per Ledger
Unfavourable Favourable
Variance
Unit 8 -Basavakalyan – Driver Performance Incentives Calculation Variance Variance
Driver Performance 7,03,553 7,03,553 - - -
As per
Unit As per Ledger Variance
Calculation KMS Incentives 36,01,485 36,01,485 - - -
10
` 7
107
Driver Performance Incentives - Basavakalyan
60
Hundreds
55.06
50
40.06
40
30
20 Excess Payment to
Driver
15.00
Short Payment to
Driver
10
- - - - - - - - - - -
-
(1.25) (1.25)
(10)
Driver R\L Punctual Senior Active Good Driver Other
KMS Incentives Total
Performance Commission Incentive Incentive Incentive Incentives
Excess Payment to Driver - - - - (125) - - (125)
Short Payment to Driver - - - - 1,500 - 4,006 5,506
Policy Procedural Regulatory System Deficiency a
Observation rating
4.1 Driver Performance Incentives HIGH MED LOW
Amount in ` Expenditure
As per Our
As per Ledger
Unfavourable Favourable
Variance
Calculation Variance Variance
Unit-9 Hassan – Driver Performance Incentives
Driver
8,59,304 8,59,304 - - -
Performance
As per
Unit As per Ledger Variance
Calculation KMS Incentives 60,88,447 60,88,447 - - -
10
c 109
9
Driver Performance Incentives - Hassan
450
Hundreds
395.00 395.00
400
350
300
250
Short Payment to
150 Driver
100
50
- - - - - - - - - - - - - -
-
Driver R\L Punctual Senior Active Good Driver Other
KMS Incentives Total
Performance Commission Incentive Incentive Incentive Incentives
Excess Payment to Driver - - - - - - - -
Short Payment to Driver - - - - 39,500 - - 39,500
Policy Procedural a Regulatory System Deficiency
Observation rating
Total (2,529) 43,966 (1,215) 7,299 (16) 5,323 - 3,929 (542) 14,634 (125) 5,506 - 39,500 1,15,730
111
Policy Procedural a Regulatory System Deficiency a
Observation rating
4.2.1 Wrongofcalculation
3.2 Analysis of RL Commission
Driver Performance HIGH MED LOW
Excess Payment - - -
Recommendations Puttur Short Payment 8,614 5,742 2,869
Total 8,614 5,742 2,869 Unit - 3
• RL Commission payable to the driver is to be
updated in the RL OA on the web portal. Excess Payment - - -
• In cases where the system is not picking the Hosur Short Payment 1,304 - 1,304
correct commission the same needs to be Total 1,304 - 1,304 Unit - 4
rectified. Excess Payment - 542 (542)
Coimbatore Short Payment 14,634 - 14,634
Total 14,634 542 14,091 Unit - 7
112
Policy Procedural a Regulatory System Deficiency a
Observation rating
4.2.2 No. ofof
3.2 Analysis Duties
Driverof driver
Performance HIGH MED LOW
113
Policy Procedural a Regulatory System Deficiency a
Observation rating
4.2.3 Other of
3.2 Analysis Incentives
Driver Performance HIGH MED LOW
114
Policy Procedural a Regulatory System Deficiency a
Observation rating
4.2.4 Portal of
3.2 Analysis Errors
Driver Performance HIGH MED LOW
Excess Payment - - -
Peapully Short Payment 5,000 2,500 2,500
Recommendations Unit - 2
Total 5,000 2,500 2,500
Excess Payment - - -
Puttur Short Payment 4,500 2,250 2,250
Unit - 3
Total 4,500 2,250 2,250
Excess Payment - - -
Hosur Short Payment 5,250 2,625 2,625
Unit - 4
Total 5,250 2,625 2,625
115
Policy Procedural a Regulatory System Deficiency a
Observation rating
4.2.5 Portal of
3.2 Analysis Errors
Driver Performance HIGH MED LOW
Excess Payment - - -
116
Policy Procedural a Regulatory System Deficiency
Observation rating
4.2.6 Non Updation
3.2 Analysis of Target KM’s
of Driver Performance HIGH MED LOW
Summary
Short/(Excess)
KMS Incentive KMS Incentive
Unit Particulars paid Annexure
paid payable
Excess Payment - - -
117
Policy Procedural a Regulatory System Deficiency
Observation rating
4.2.7 Other of
3.2 Analysis differences
Driver Performance HIGH MED LOW
Key Observations
• Other Short/Excess payments were made to the driver, details of the same is as given below:
Incentive
Unit Particulars Incentive Paid Short/(Excess) paid Annexure
payable
118
4.3 Analysis of Driver Performance
Statistical Analysis of Q1 (FY 2019-20) & Q2 (FY 2019-20)
Percentage of Differences 2.93% 9.25% 4.93% 1.02% 4.54% 2.81% 0.93% 0.60%
Short Payment to the Driver 12,149 43,966 14,621 7,299 5,379 5,323 5,125 3,929
Excess Payment to the Driver (283) (2,529) (8,738) (1,215) (13,307) (16) (740) -
(Increase)/Decrease in Excess
(794.85%) 86.10% 99.88% 100.00%
payment
119
4.3 Analysis of Driver Performance
Statistical Analysis of Q1 (FY 2019-20) & Q2 (FY 2019-20)
Percentage of Differences 4.47% 10.00% 16.58% 12.50% 14.37% 13.61% 5.00% 5.02%
Short Payment to the Driver 6,581 14,634 8,481 5,506 40,906 39,500 93,242 1,20,157
120
4.3 Analysis of Driver Performance
Statistical Analysis of Q1 (FY 2019-20) & Q2 (FY 2019-20)
• The below mentioned chart depicts the Number of slips with differences for the two periods viz. Q1 (FY 2019-20) and Q2 (FY 2019-20).
18% 16.58%
16% 14.37%
13.61%
14% 12.50%
12%
10.00%
10% 9.25%
8%
6% 4.93% 4.54% 4.47% 5.00% 5.02%
4% 2.93% 2.81%
2% 1.02% 0.93% 0.60%
0%
Unit 1 Unit 2 Unit 3 Unit 4 Unit 7 Unit 8 Unit 9 Total
Q1 2.93% 4.93% 4.54% 0.93% 4.47% 16.58% 14.37% 5.00%
Q2 9.25% 1.02% 2.81% 0.60% 10.00% 12.50% 13.61% 5.02%
121
4.3 Analysis of Driver Performance
Statistical Analysis of Q1 (FY 2019-20) & Q2 (FY 2019-20)
• The below mentioned chart depicts the excess payment to the drivers for the two periods viz. Q1 (FY 2019-20) and Q2 (FY 2019-20).
(35)
Thousands
(29.97)
(30)
(25)
(20)
(15) (13.31)
(10) (8.74)
(6.90)
(4)
(5) (3)
(0.28) (1) (0.74) (1)
(0) - - (0) - -
-
Unit-1 Unit-2 Unit-3 Unit-4 Unit-7 Unit-8 Unit-9 Total
Q1 (283) (8,738) (13,307) (740) - (6,899) - (29,967)
Q2 (2,529) (1,215) (16) - (542) (125) - (4,427)
122
Arunachala Logistics Private Limited
Internal Audit Report for the Quarter July 2019 to September 2019
5.Maintenance
12
123
3
A trip is closed only after A hard copy of job card is
The job card is raised by the Stores in charge raises MIR and
completion of maintenance of taken and thereafter manual
supervisor for every vehicle. It also raises MIN for issuing the
the vehicle returning from the indents are raised for
includes the details of PPM required materials to the
trip. requirements of spares, Lubs
Schedules to be performed maintenance department.
etc.
124
Policy Procedural a Regulatory System Deficiency
Observation rating
5.1 PPM Schedules HIGH MED LOW
Unit 1 Unit 2 Unit 3 Unit 4 • To ensure that PPM Schedules are performed on
timely basis.
• To ensure that Maintenance Schedule is properly
Unit 2 Unit 3
monitored so as to minimize backlogs.
Unit 1 Unit 4
Management’s Response
• The following annexure consists of repeated schedule carried out within short period.
125
Policy Procedural a Regulatory System Deficiency
Observation rating
5.2 Vehicle Break Down Analysis HIGH MED LOW
Key Observations
• The summary of vehicle break down enroute and reasons thereof, vehicle-wise and driver-wise is given in the table below:
Unit 1
Unit 1 Unit 1
Unit 2
Unit 2 Unit 2
Unit 3
Unit 3 Unit 3
Unit 4
Unit 4 Unit 4
Unit 7
Unit 7 Unit 7
126
Policy Procedural a Regulatory System Deficiency
Observation rating
5.3 Local Repairs Expenditure HIGH MED LOW
Key Observations
• Local Repairs are incurred at the unit level. The maintenance of vehicle carried is either In-house or outside on contract basis.
• The below is the annexure for vehicle wise local repairs details on account of repeat failure in short duration:
LR with MGT
Remarks
Recommendations
Management’s Response
127
Arunachala Logistics Private Limited
Internal Audit Report for the Quarter July 2019 to September 2019
128
12
Policy Procedural a Regulatory System Deficiency
Observation rating
Key Observations
• We have verified the weekly labour payments and its subsequent billing to RCL for the period 26th June 2019 to 25th September
2019 for all the godowns. The top 5 godowns with differences noted in the amounts paid to the labour contractor against its
billing to RCL are as given below :
• Godown wise summary of the differences noted is given in the below annexure:
Differences
Summary
129
Policy Procedural a Regulatory System Deficiency
Observation rating
Key Observations
• The summary of differences noted in the amounts paid to the labour contractor against its billing to RCL is as given below:
• The day wise details of differences are given in the below annexure:
Differences
130
Policy Procedural a Regulatory System Deficiency
Observation rating
Recommendations
• To reconcile the quantities for which labour payments are made with monthly claims and a working sheet for the same is to be maintained.
Management’s Response
131
Arunachala Logistics Private Limited
Internal Audit Report for the Quarter July 2019 to September 2019.
13
132
2
Policy Procedural a Regulatory System Deficiency
Observation rating
7.1 Pending Insurance Claims HIGH MED LOW
133
Policy Procedural a Regulatory System Deficiency
Observation rating
7.1 Pending Insurance Claims HIGH MED LOW
Key Observations
• A statistical analysis of accidents occurred, model-wise and unit-wise, during October, 2018 to September, 2019 is given in the annexure
below:
Accidents
Comparison
• We have made an analysis on the Cost for the accidents occurred from July’19 to September'19. A summary is given below and the vehicle-
wise details are attached in the annexure below:
Particulars Amount Amount
Actual Repair Cost 36,80,543
• The calculations are made on certain assumptions. The assumptions are attached here:
Assumptions
134
Arunachala Logistics Private Limited
Internal Audit Report for the Quarter July 2019 to September 2019
8.Statutory Compliances
13
135
5
Statutory Compliances- Acts Covered
We have broadly reviewed compliance with the following:
• Employees Provident Fund Act 1952
• Employee State Insurance Act
• Professional Tax
• Goods and Services Tax
• Income Tax Act 1961
• Companies Act, 2013
136
Policy Procedural Regulatory a System Deficiency
Observation rating
8.1 Remittance of Provident Fund HIGH MED LOW
Key Observations
• As per PF and Misc. Provisions Act, the employer shall pay the PF contributions within 15 days from the last day of the calendar month in
which the contributions fall due.
• Details of Provident Fund contribution payable as per books and paid as per challan are as given below:
137
Policy Procedural Regulatory a System Deficiency
Observation rating
8.1 Remittance of Provident Fund HIGH MED LOW
Key Observations
• Details of difference in number of employees as per pay-sheet & challan are as given below:
No. of employees in No of employees in
Month Difference
pay sheet Challan
July-19 1,285 1,285 -
Aug-19 1,290 1,290 -
Sept-19 1,291 1,291 -
• Details of PF contribution payable as per our calculation and as per books are as given below:
Employees Employees Employer’s
Excess Employer's Excess
Contribution as Contribution Contribution
Month /(Short) Annexure Contribution as per /(Short) Annexure
per our payable as per payable as per
deduction our calculation deduction
calculation books books
138
Policy Procedural Regulatory a System Deficiency
Observation rating
8.1 Remittance of Provident Fund HIGH MED LOW
Key Observations
• It is observed that employee contribution is excess paid by Rs 15,579/- and employer contribution is excess paid by Rs 16,848/-.Details of PF
contribution payable as per our calculation and Paid as per challan are as given below:
139
Policy Procedural Regulatory a System Deficiency
Observation rating
8.2 Remittance of ESI HIGH MED LOW
Key Observations
• As per Employees State Insurance Act, 1948 the employer shall pay the ESI contributions within 15 days from the last day of the calendar
month in which the contributions fall due.
• It is observed that ESI amounting to Rs.690/- is excess paid as per books. Details of ESI contribution payable as per books and paid as per
challan are as given below:
Employee Employer
Employee Employer
contribution Excess Contribution Excess Due Date of Date of
Month Contribution Annexure Contribution
paid as per /(Short) Paid paid as per /(Short) Paid Payment Payment
as per books as per books
challan challan
Total (690) -
140
Policy Procedural Regulatory a System Deficiency
Observation rating
8.2 Remittance of ESI HIGH MED LOW
Key Observations
• It is observed that employee contribution is excess deducted by Rs.1,698/- and employer contribution is excess deducted by Rs.4,376/-Details
of ESI contribution payable as per our calculation and as per books are as given below:
Employee
Employee Employer Employer
Contribution as Excess/(Short) Excess/(Short)
Month contribution as Annexure Contribution as per Contribution as per
per our deduction deduction
per books our calculation books
calculation
141
Policy Procedural Regulatory a System Deficiency
Observation rating
8.2 Remittance of ESI HIGH MED LOW
Key Observations
• Details of ESI employee contribution payable as per our calculation and paid as per challan are as given below:
July'19 Aug’19 Sept’19
Particulars
Amount Amount Amount Amount Amount Amount
1 ESI payable as per our calculation 5,47,913 5,48,305 5,53,103
Reconciliation:
Add: Difference in calculation as per portal(Round off Diff) 562 568 560
Annexure
July Aug Sept
142
Policy Procedural Regulatory a System Deficiency
Observation rating
8.3.1 Remittance of Professional Tax HIGH MED LOW
Key Observations
Professional Tax
• Summary of month wise remittances of Professional Tax as per books is annexed below:
143
Policy Procedural Regulatory a System Deficiency
Observation rating
8.3.1 Remittance of Professional Tax HIGH MED LOW
Key Observations
Professional Tax
• Summary of month wise Professional Tax as per books and as per our calculations is annexed below:
Total (350)
144
Policy Procedural Regulatory a System Deficiency
Observation rating
8.3.1 Remittance of Professional Tax HIGH MED LOW
Key Observations
Professional Tax
• Summary of month wise professional tax as per our calculations and paid as per challan is annexed below:
Total 750
145
Policy Procedural Regulatory a System Deficiency
Observation rating
8.3.2 Remittance of Professional Tax HIGH MED LOW
Key Observations
• Professional Tax for Tamilnadu for the period 1st April’19 to 30th September’19 as per Books and as per challan is given below:
• Professional tax for Tamilnadu for the period of 1st April’19 to 30th September’19 as per our calculations and paid is given below:
Amount Payable
Amount Paid Excess/(Short)
Period as per our Annexure
as per Challan Paid
calculations
1st Apr'19 to 30th
1,99,636 1,73,983 (25,653)
Sept'19
Cal V/s Paid
• Professional tax for Tamilnadu for the period of 1st April’19 to 30th September’19 as per our calculations and books is given below:
Amount
Amount Payable Excess/(Short)
Period Payable as per Annexure
as our calculation deduction
books
1st Apr'19 to 30th
1,99,363 1,79,688 (19,948)
Sept'19 Payable V/s Cal
146
Policy Procedural Regulatory a System Deficiency
Observation rating
8.4.1 Goods and Services Tax HIGH MED LOW
Key Observations
• The various recoveries made from the drivers are supply of services and GST is payable on such recoveries. As per clause (e) of paragraph 5
schedule II of the CGST Act 2017, “agreeing to the obligation to refrain from an act, or to tolerate an act or a situation, or to do and act” is
considered as Supply of service under Section 7(d) of the Act and the recoveries made, fall under this category. It is observed that GST is not
being charged on such recoveries. The summary of differences is given below :
GST Payable
GST Paid as per Excess/(Short)
Month as per our
GSTR-3B paid
calculation
Total 869
147
Policy Procedural Regulatory a System Deficiency
Observation rating
8.4.1 Goods and Services Tax HIGH MED LOW
Key Observations
Summary of differences – July
GST Payable
GST Paid as
State GST head as per our Excess/(Short) paid
per GSTR-3B
calculation
CGST 40,001 40,001 -
SGST 40,001 40,001 -
Andhra Pradesh
IGST 67,802 68,291 488
Total 1,47,804 1,48,292 488
CGST 11,670 11,670 -
SGST 11,670 11,670 - July
Karnataka
IGST 10,523 10,523 -
Total 33,862 33,862 -
CGST 36,078 36,078 -
SGST 36,078 36,078 -
Tamil Nadu
IGST 19,730 19,730 -
Total 91,887 91,887 -
CGST 14,218 14,218 -
SGST 14,218 14,218 -
Telangana
IGST 22,196 22,196 -
Total 50,632 50,632 -
148
Policy Procedural Regulatory a System Deficiency
Observation rating
8.4.1 Goods and Services Tax HIGH MED LOW
Key Observations
Summary of differences – August
GST Payable as
GST Paid as
State GST head per our Excess/(Short) paid
per GSTR-3B
calculation
CGST 34,536 34,536 -
SGST 34,536 34,536 -
Andhra Pradesh
IGST 57,604 57,604 -
Total 1,26,676 1,26,676 -
CGST 9,050 9,050 -
SGST 9,050 9,050 - Aug
Karnataka
IGST 8,443 8,443 -
Total 26,542 26,542 -
CGST 70,630 70,630 -
SGST 70,630 70,630 -
Tamil Nadu
IGST 26,647 26,648 -
Total 1,67,908 1,67,908 -
CGST 16,824 16,824 -
SGST 16,824 16,824 -
Telangana
IGST 18,620 18,620 -
Total 52,268 52,268 -
149
Policy Procedural Regulatory a System Deficiency
Observation rating
8.4.1 Goods and Services Tax HIGH MED LOW
Key Observations
Summary of differences – September
GST Payable as
GST Paid as
State GST head per our Excess/(Short) paid
per GSTR-3B
calculation
CGST 48,118 48,118 -
SGST 48,118 48,118 -
Andhra Pradesh
IGST 72,400 72,400 -
Sept
Total 1,68,636 1,68,636 -
CGST 12,044 12,044 -
SGST 12,044 12,044 -
Karnataka
IGST 13,001 13,001 -
Total 37,089 37,089 -
CGST 11,369 11,369 -
SGST 11,369 11,369 -
Tamil Nadu
IGST 7,776 7,776 -
Total 30,515 30,515 -
CGST 29,798 29,798 -
SGST 29,798 29,798 -
Telangana
IGST 18,576 18,957 381
Total 78,172 78,553 381
150
Policy Procedural Regulatory a System Deficiency
Observation rating
8.4.2 Goods and Services Tax HIGH MED LOW
Key Observations
• It is observed that GSTIN of ALPL is not found on invoices/ wrongly mentioned on Invoice and GST input is claimed. Details of the same are as
given below:
Number of
CGST SGST IGST Total GST
invoices
GSTIN Missing on
4 600 600 - 1,200 Invoices
• It is observed that GST input is short/excess claimed on the purchases made. Details of the same are as given below:
151
Policy Procedural Regulatory a System Deficiency
Observation rating
8.4.2 Goods and Services Tax HIGH MED LOW
Key Observations
• It is Observed that GST pertaining to some of the purchases of goods and services has not been claimed as input during the Quarter. Details of
the same are given in the below annexure:
No of
Input-CGST Input-SGST Input-IGST Total GST
Purchases
GST Input not
7 1,299 1,299 7,179 9,777
claimed
• It is Observed that in few instances GST input is accounted on freight charges even though the vendor did not charge GST on invoice.
Details of the same are given below.
152
Policy Procedural Regulatory a System Deficiency
Observation rating
8.4.2 Goods and Services Tax HIGH MED LOW
Key Observations
• It is observed that GST input is accounted under incorrect ledger account head i.e. input under IGST is accounted as CGST/SGST
and vice versa amounting to ₹ 30,582/-. Details of the same are as given below :
AP July - 1,854
TN July - 28,728
• It is observed that GST input is accounted under incorrect location amounting to ₹ 45,271/-. Details of the same are as given below :
153
Policy Procedural Regulatory a System Deficiency
Observation rating
8.4.2 Goods and Services Tax HIGH MED LOW
Key Observations
• It is observed that in purchase invoices GSTIN of ALPL state is different from the state in which actual supply of goods has taken place, as a
result the inputs claimed in such instances will be ineligible. Details of the same are as given below:
• GSTR 1 filing details: State Return Period Due date of filing Date of filing Delay in days
July'19 11-08-2019 10-08-2019 -
Andhra Pradesh August'19 11-09-2019 11-09-2019 -
September'19 11-10-2019 11-10-2019 -
July'19 11-08-2019 10-08-2019 -
Telangana August'19 11-09-2019 11-09-2019 -
September'19 11-10-2019 11-10-2019 -
July'19 11-08-2019 10-08-2019 -
Karnataka August'19 11-09-2019 11-09-2019 -
September'19 11-10-2019 11-10-2019 -
July'19 11-08-2019 10-08-2019 -
Tamil Nadu August'19 11-09-2019 11-09-2019 -
September'19 11-10-2019 11-10-2019 -
July'19 11-08-2019 10-08-2019 -
Kerala August'19 11-09-2019 11-09-2019 -
September'19 11-10-2019 11-10-2019 -
July'19 11-08-2019 10-08-2019 -
Orissa August'19 11-09-2019 11-09-2019 -
September'19 11-10-2019 11-10-2019 -
July'19 11-08-2019 10-08-2019 -
Maharashtra August'19 11-09-2019 11-09-2019 -
September'19 11-10-2019 11-10-2019 -
July'19 11-08-2019 10-08-2019 -
Goa August'19 11-09-2019 11-09-2019 -
September'19 11-10-2019 11-10-2019 -
July'19 11-08-2019 10-08-2019 -
Pondicherry August'19 11-09-2019 11-09-2019 - 155
September'19 11-10-2019 11-10-2019 -
Policy Procedural Regulatory a System Deficiency
Observation rating
8.4.3 Goods and Services Tax HIGH MED LOW
Key Observations
• The company is generally regular in depositing the TDS amounts with the Government. A brief Section wise monthly summary is annexed
below:
TDS
• Details of Quarterly E-TDS return in Form no. 26Q and 24Q for the quarter ending 30th September’2019 are as given below:
Tax Deposited as Tax Deposited Excess/(Short) Tax Deducted Tax Deducted Excess/(Short) Acknowledgement
Form Due Date
per Return as per Books Reported as per Return as per Books Reported Date
157
Policy Procedural Regulatory a System Deficiency
Observation rating
8.5 Remittance of TDS HIGH MED LOW
Key Observations
• An amount of ` 2,27,358/- from July'19 to September'19 is paid to RCL towards Corpus Fund. It is explained that the same is collected by RCL
based on the Tonnage carried by transporters towards development of roads. The same is considered as an expenditure by ALPL. Prima facie,
it appears to be in the nature of voluntary contribution not arising out of contractual agreements. The deduction of the same as an
expenditure under Income Tax Act needs to be reviewed. Further, applicability of provisions of TDS also needs to be reviewed. In the event a
view is taken that TDS is required to be done, non deduction of the same will negate the claim of expenditure to the extent of 30%. Details of
the amount paid are given below.
158
Policy Procedural Regulatory a System Deficiency
Observation rating
8.6 Cash transactions exceeding ` 10,000 HIGH MED LOW
Key Observations
• Section 40A(3)(a) of the Income-tax Act, 1961 provides that any expenditure incurred in respect of which payment is made in a sum
exceeding Rs 10,000/- in a single day otherwise than by an account payee cheque drawn on a bank or by an account payee bank draft or use
of electronic clearing system through a bank account, shall not be allowed as a deduction.
• Details of cash payments exceeding Rs 10,000/- in a single day are given below :
No of Transactions 1
Kodad
Total Amount ` 12,750 Kodad
No of Transactions 7
Peapully
Total Amount ` 1,48,000 Peapully
No of Transactions 1
Srikakulam
Total Amount ` 10,862 Srikakulam
No of Transactions 2
Basavakalyan
Total Amount ` 43,000 Basavakalyan
159
Arunachala Logistics Private Limited
Internal Audit Report for the Quarter July 2019 to September 2019
16
160
0
Policy Procedural a Regulatory System Deficiency
Observation rating
9.1 Finance and Accounts HIGH MED LOW
Key Observations
During the course of our audit we have observed the following :
Bank Reconciliation Statement:
• It is observed that there are certain entries in the reconciliation statement which have not been cleared for more than 90 days as on
25th November 2019. These represent stale cheques which needs to be reversed or entries for which clearing date is not entered in the
BRS. Details are given in the annexure below:
Uncleared
Cheques
161
Arunachala Logistics Private Limited
Internal Audit Report for the Quarter July 2019 to September 2019
10.Unit Visit
16
162
2
Policy Procedural a Regulatory System Deficiency
10.1 Unit Visit – Puttur Observation rating
Key Observations HIGH MED LOW
• We have made a surprise visit to Unit-3 Puttur on 14-December-2019. Following are our observations:
• We have physically verified the cash on hand, the differences noted are as below:
Balance as per Difference
Date and Time Physical Cash Balance Remarks Snapshots
Books [(Short)/Excess]
14th Dec 2019
₹ 2,37,614 ₹ 2,37,609 (5/-)
U3 Cash
• We have also carried physical verification of stock held at stores. We have verified 104 items and 4 differences were found, the details
are given below:
• We have also carried out physical verification of tyres and found 110 tyres short. However, the reason for the difference is reconciled
and is annexed herewith.
Tyres Reco
• On verifying the diesel stock at the unit, we had noted an short stock of 741.89 Ltrs. Details are given in the annexure below.
Particulars (Qty in Ltrs)
Physical stock as on 14/12/2019 18,069.10
Stock of Diesel as per SAP (18,810.99)
(Short)/Excess Stock (741.89)
163
Policy Procedural a Regulatory System Deficiency
10.2 Unit Visit – Hosur Observation rating
Key Observations HIGH MED LOW
• We have made a surprise visit to Unit-4 Hosur on 11-December-2019. Following are our observations:
• We have physically verified the cash on hand, the differences noted are as below:
Balance as per Physical Cash Difference
Date and Time Remarks Snapshots
Books Balance [(Short)/Excess]
11th December,
2019 09:00AM ₹ 51,560 ₹ 51,558 (2/-)
U4 Cash
• We have also carried physical verification of stock held at stores. We have verified 127 items and 14 differences were found, the details
are given below:
• We have also carried out physical verification of tyres and found 406 tyres short. However, the reason for difference is explained and
3 tyres are found to be excess after reconciliation. Details are given below
Tyres reco
• On verifying the diesel stock at the unit, we had noted an Excess stock of 2,531.75 Ltrs. Details are given in the annexure below.
Diesel Reco
164
Policy Procedural a Regulatory System Deficiency
10.3 Unit Visit – Coimbatore Observation rating
Key Observations HIGH MED LOW
• We have made a surprise visit to Unit-7 Coimbatore on 13-December-2019. Following are our observations:
• We have physically verified the cash on hand, the differences noted are as below:
Balance as per Difference
Date and Time Physical Cash Balance Remarks Snapshots
Books [(Short)/Excess]
13th December
2019 09:30 AM ₹ 37,253 ₹ 37,253 -
U7 Cash
• We have also carried physical verification of stock held at stores. We have verified 64 items and 8 differences were found, the details
are given below:
• We have also carried out physical verification of tyres and 114 tyres were found short . However, the reason for difference is explained
Details are given below.
Tyres Reco
• On verifying the diesel stock at the unit, we had noted an short stock of 1,438.87 Ltrs. Details are given in the annexure below.
Diesel Reco
165
10.4 Unit Visit – U 7 Tyre Retreading Plant Policy Procedural a Regulatory System Deficiency
Observation rating
Key Observations HIGH MED LOW
• We have made a surprise visit to Unit-7 Tyre retreading plant of Coimbatore on 13-December-2019. We have identified 31 differences in stock
as per books and physical stock out of 81 items, the details are given in the annexure below
Stock Differences
• We have also carried out physical verification of tyres and 70 tyres were found Short . However, the reason for difference is explained and
1 tyre are found to be Short after reconciliation. Details are given below
Tyres Reco
166
Policy Procedural a Regulatory System Deficiency
10.5 Unit Visit – Hassan Observation rating
Key Observations HIGH MED LOW
• We have made a surprise visit to Unit-9 Hassan on 12th December2019. Following are our observations:
• We have physically verified the cash on hand, the differences noted are as below:
16
7
Arunachala Logistics Private Limited
Internal Audit Report for the Quarter July 2019 to September 2019
16
168
8
Policy Procedural a Regulatory System Deficiency
Observation rating
11.1 Punctual Incentives HIGH MED LOW
Key Observations
During the course of our audit we have covered the following other areas:
• Incentive Payments:
• Punctual Incentives: Punctual Incentives are paid to certain eligible employees in the maintenance & Tyres department. Based on the
incentive circular and the data obtained from SAP we have verified whether Punctual Incentive payments. Summary of Discrepancies
observed Unit wise for the months of July to September 2019 is as follows.
Eligible but not
Unit Not eligible but paid Eligible and excess paid
paid
UNIT-1, KODAD 1,500 (500) -
UNIT-2, PEAPULLY 2,000 (1,000) -
UNIT-3, PUTTUR 2,000 (3,000) -
750 (3,000) - Annexure
UNIT-4, HOSUR
HEAD OFFICE 7,000 (2,000) -
BALANAGAR 750 - (500)
BASAVAKALYAN 10,250 - -
Hasan 11,250 - -
RMC-TELLAPUR 3,000 - -
Total 38,500 (9,500) (500)
169
Policy Procedural a Regulatory System Deficiency
Observation rating
11.2 Diesel Reconciliation HIGH MED LOW
Key Observations
• Diesel Reconciliation of Stock ledgers : Upon the verification of the own bunks diesel closing stock balances as per books and as per the
certified copies received from the units few discrepancies were found. Details of the same are as given below:
Opening Stock As on Closing Stock as on
Purchases for the Q2 Consumption For Q2
01.07.2019 30.09.2019
Own -
As Per As Per As Per As Per Difference Remarks
bunks
As per SAP Certified As per SAP Certified As per SAP Certified As per SAP Certified
Copies Copies Copies Copies
Key Observations
• Monthly Diesel Reconciliation of Stock ledgers : Upon the verification of the own bunks diesel closing stock balances as per books and as
per the certified copies received from the units few discrepancies were found. Details of the same are as given below:
Key Observations
During the course of our audit we have covered the following other areas
• Vigilance Incentives : We have verified the vigilance incentives paid for vigilance officers and no discrepancies were noted.
• RCL Reconciliation: We have verified the RCL reconciliation for the month of September 2019, and no discrepancies were noted.
172