SRI FABRICATORS WORK AND OBSERVATION SHEET-2007-2008 1. 2. 3. 4.
Stock entry in raw material and consumables remove the suspense a/c particular payments and receipts entry vouching purchase bill and sales bill Bank voucher entry dec-2007 to Mar-08 SALES BILLS
S I.N O.
DATE
INV.NO. CUSTOMER NAME
BILL AMOUNT
REMARKS
1
13.4.07
1587
Rs.20470
2
27.7.07
1695
3
29.9.07
1914
4
17.10.07
1958
5
29.10.07
19910
6
30.10.07
2001
7
2.11.07
2017
8
2.11.07
2018
9
5.11.07
2024
10
9.11.07
2044
11
13.11.07
2061
12
28.12.07
2223
13
25.01.07
2336
14
19.12.07
2185
Lincoln helios Rs.491 (India) pvt ltd
15
28.12.07
2223
Lincoln helios Rs.48770 (India) pvt ltd
This bill is double entry(one bill delete ) Bill not entry(entry to the tally) Bill cancelled original bill not attached Bill cancelled original bill not attached Bill cancelled original bill not attached Bill cancelled original bill not attached Bill cancelled original bill not attached Bill cancelled original bill not attached Bill cancelled original bill not attached Bill cancelled original bill not attached Bill cancelled original bill not attached Bill cancelled original bill not attached entry in tally Lincoln helios (India) pvt ltd (changing to carrier air condition ltd) entry in tally carrier air condition ltd(changing to Lincoln helios pvt ltd) In this bill not entry (bill entry in tally)
Lincoln hellios India pvt ltd Fouress engineering (India) ltd Lincoln hellios India pvt ltd Lincoln hellios India pvt ltd Lincoln hellios India pvt ltd Lincoln hellios India pvt ltd Lincoln hellios India pvt ltd Lincoln hellios India pvt ltd Lincoln hellios India pvt ltd Lincoln hellios India pvt ltd Lincoln hellios India pvt ltd Lincoln hellios India pvt ltd Carrier air condition ltd
Rs.33600 Rs.747 Rs.2162 Rs.4717 Rs.1206 Rs.6998 Rs.1166 Rs.4036 Rs.1090 Rs.7076 Rs.48774 Rs.49140
16
31.12.07
2239
Lincoln helios Rs.6552 (India) pvt ltd
Entry in tally carrier air condition ltd(change to Lincoln helios pvt ltd) Rs.100780,1 In this bill not entry(bill 13884,1292 entry to the tally) 82,129282 Rs.18217 in this bill not entrypayment Rec Rs.132242 chq no.385784/30.4.08
17
4,10,16/ 01/2008
027,031, 033,034
Lincoln helios (India) pvt ltd
18
14.3.08
2513
Carrier air conditioning
PURCAHSE BILL SI.NO. DATE
INV.NO
1 2
7.5.07 20.2.07
3 4
SUPPLIER NAME
REMARKS
97 4986
BILL AMOUNT Favourite steel traders 390 Shankara pipes India pvt ltd 8160
30.6.07
2283
Shree vinayaka hardware’s
7577
20.11.07
10948
Madras auto service
81000
Tall bill entry date.30.7.07 This bill entry in sri fabricator (bill
Bill not filling
5
9.1.08
13513
Madras auto service
67500
6
12.4.08
697
Madras auto service
42975
SI.NO. DATE
INV.NO.
VAT OBSERVATION PARTICULAR
1
27.4.07
10077
Singhal steels
BILL AMOUNT 28800
2
2.6.07
5122
Sri balaji enterprises
630
3
7.6.07
8915
Power tech
430
4
30.6.07
3445
Sri balaji enterprises
13000
5
10.5.07
7124
Power tech
2313
6
11.5.07
55490
Sri balaji enterprises
7
2.2.08
5824
KHK patch miyan shib brother
4680
is sri Krishna fab tech) This bill entry sri Krishna and sri fabricators(this bill sri fabricator) This bill not entry
REMARKS Input 4% vat not entry in tally(changing to input vat) This bill labour charges entry in vat (changing to labour charges) This bill labour charges entry in vat (changing to labour charges) Assemble value amount Rs.12500 tally not entry This bill labour charges entry in vat(changing to labour charges) This bill entry in vat tracking 12.5% vat this bill 4 %( changing to vat4%) Bill entry 4% vat actual billing 12.5% vat(changing to vat12.5%)
Sales bills Excise duty observation monthly wise APRIL-07 Date INV NO. 17.04.0 7 27.04.0 7 27.04.0 7 Total
1 336 1 368 1 369
Assessable 16%Excise 2%cess 1%cess Remarks Value duty on ED on HED 168000 26880 538 269 bill cancelled in tally 2230
357
7
4
bill cancelled in tally
1500
240
5
2
bill cancelled in tally
171730
27477
550
275
Particula r
12.5%Vat Sales
Tally
813037.93 36502 7 984767 36502 7
R.G.-1
CST Sales
Total 16%Excise 2%cess Assessable duty on ED Value 1178064 188492.38 3774.1 3 1349794 215967 4319
1%cess on HED 1882.8 3 2160
Total Excise duty 194149.34 222446
Total Assessable value R.G.-1 books amount -1349794 (-)Total Cancelled bills Assessable Value amt- 171730 tally system assessable value 1178064 Total 16.48% excise duty in R.G.-1 books amt-222446 (-)Total Cancelled bills 16.48% excise duty - 28302 tally system 16.48% excise duty 194144 MAY-07 Date INV NO. 10.5.07 22.5.07 total Particula r
1 403 1 453
Assessable 16%Excise 2%cess 1%cess Remarks Value duty on ED on HED 1500 240 5 3 Bill cancelled in tally 1650
264
5
2
3150
504
10
5
12.5%Vat Sales
CST Sales
Total Assessable Value
Bill cancelled in tally
16%Excise 2%cess 1%cess Total duty on ED on Excise HED duty
Tally R.G.-1
978685.27 31320 0 1608182 31320 0
1291885.2 7 1294982
206700.06 207197
4127.3 7 4143.9 4
2064.5 5 2071.9 7
212891.98 213412.91
Total Assessable value R.G.-1 books amount - 1294985 (-)Total Cancelled bills Assessable Value amt3150 Balance tally system assessable value 1291835 Total 16.48% excise duty in R.G.-1 books amt-207197 (-)Total Cancelled bills 16.48% excise duty - 519 Balance tally system 16.48% excise duty 206678
JUNE-07 Date
INV NO.
Assessable Value 450 490 420 7500 825 490 600 10775
2.6.07 7.6.07 7.6.07 8.6.07 11.6.07 18.6.07 29.6.07 TOTAL
1506 1519 1521 1524 1526 1577 1606
Particula r
12.5%Vat Sales
Tally
1186891.40 38170 0 1197666.4 38170 0
R.G.-1
CST Sales
16%Excise duty 72 78.40 67.80 1200 304 78 90 1890.2
2%cess on ED 1.44 1.56 1.34 24 6.08 1 2 37.42
Total 16%Excise 2%cess Assessable duty on ED Value 1568591.4 251006.63 5019.4 1 1579366.4 252698.62 5053.9 7
Total Assessable value R.G.-1 books amount – 1579366.4 (-)Total Cancelled bills Assessable Value amt10775 Balance tally system assessable value 1568591.4 Total 16.48% excise duty in R.G.-1 books amt-260279.57 (-)Total Cancelled bills 16.48% excise duty - 1946.83 Balance tally system 16.48% excise duty 258332.74 JULY-07
1%cess on HED .72 .78 .67 12 3.04 1 1 19.21
Remarks bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally 1%cess on HED 2509.9 9 2526.9 8
Total Excise duty 258536.03 260279.57
Date
INV NO.
26.7.07 Total
1694 1694
Assessable Value 1520 1520
Particula r
12.5%Vat Sales
CST Sales
Tally
633290.49 16619 4 634810 16619 4
R.G.-1
16%Excise duty 243 243
2%cess on ED 5 5
1%cess on HED 2 2
Total 16%Excise 2%cess Assessable duty on ED Value 799484.49 127917.48 2557.6 2 801004 128160.64 2563
Remarks bill cancelled in tally
1%cess on HED 1279.9 9 1282
Total Excise duty 131755.09 132005.64
Total Assessable value R.G.-1 books amount – 801004 (-)Total Cancelled bills Assessable Value amt1520 Balance tally system assessable value 799484 Total 16.48% excise duty in R.G.-1 books amt-132005.64 (-)Total Cancelled bills 16.48% excise duty 250 Balance tally system 16.48% excise duty 131755.64 AUGUST-07 Date INV NO.
Assessable Value 1610 760 2850 190 5410
6.8.07 8.8.07 13.8.07 24.8.07 Total
1725 1735 1758 1801
Particula r
12.5%Vat Sales
Tally
825656.15 39698 2 831066.15 39698 2
R.G.-1
CST Sales
16%Excise duty 258 122 456 30 866
Total Assessable Value 1222638.1 5 1228048.1 5
2%cess on ED 5 2 9 1 17
1%cess on HED 3 1 5 0 9
Remarks bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally
16%Excise 2%cess 1%cess duty on ED on HED 195622.08 3912.1 1955.9 8 8 196488 3930 1965
Total Assessable value R.G.-1 books amount – 1228048.15 (-)Total Cancelled bills Assessable Value amt5410 Balance tally system assessable value 1222638.15 Total 16.48% excise duty in R.G.-1 books amt-202383 (-)Total Cancelled bills 16.48% excise duty 892
Total Excise duty 201490.24 202383
Balance tally system 16.48% excise duty
SEPT-07 Date
INV NO.
Assessable Value 11550 9630 95 11550 570 33395
3.9.07 19.9.07 24.9.07 24.9.07 29.9.07 total
1823 1886 1893 1898 1914
Particula r
12.5%Vat Sales
Tally
1156033.10 48216 0 1189428.1 48216 0
R.G.-1
CST Sales
201491
16%Excise duty 1848 1541 15 1848 91 5343
2%cess on ED 37 31 0 37 2 107
1%cess on HED 18 15 0 18 1 52
Total 16%Excise 2%cess Assessable duty on ED Value 1638193.1 262110.88 5242.0 6 1671588.1 267454 5349
Remarks bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally
1%cess on HED 2620.9 4 2675
Total Excise duty 269973.88 275478
Total Assessable value R.G.-1 books amount – 1671588.1 (-)Total Cancelled bills Assessable Value amt33395 Balance tally system assessable value 1638193.1 Total 16.48% excise duty in R.G.-1 books amt-275478 (-)Total Cancelled bills 16.48% excise duty - 5502 Balance tally system 16.48% excise duty 269976
OCT-07 Date
INV NO.
17.10.07 29.10.07 30.10.07 total
1958 1991 2001
Particula r
12.5%Vat Sales
Assessable Value 1650 3600 920 6170
CST Sales
16%Excise duty 264 576 147 987
2%cess on ED 5 12 3 20
1%cess on HED 3 6 1 10
Remarks bill cancelled in tally bill cancelled in tally bill cancelled in tally
Total 16%Excise 2%cess 1%cess Total Assessable duty on ED on Excise
Tally R.G.-1
480741.40 67515 0 486911 67515 0
Value 1155891.4
184942.63
1162061
185930
3698.7 3 3718
HED 1849.3
duty 190490.66
1860
191508
Total Assessable value R.G.-1 books amount – 486911 (-)Total Cancelled bills Assessable Value amt6170 Balance tally system assessable value 480741 Total 16.48% excise duty in R.G.-1 books amt-191508 (-)Total Cancelled bills 16.48% excise duty - 1017 Balance tally system 16.48% excise duty 190491 NOV-07 Date
INV NO.
2.11.07 2.11.07 5.11.07 9.11.07 13.11.07 TOTAL
2017 2018 2024 2044 2061
Particula r
12.5%Vat Sales
Tally R.G.-1
Assessable Value 5340 890 3080 832 5400 15542
16%Excise duty 854 142 493 133 864 2486
2%cess on ED 17 3 10 3 17 50
1%cess on HED 9 1 5 1 9 25
CST Total 16%Excise 2%cess Sales Assessable duty on ED Value 654794.30 654794.30 104766.28 2095.2 6 670336.3 670336.3 107254 2145
Remarks bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally
1%cess on HED 1046.7 7 1073
Total Excise duty 107908.31 110472
Total Assessable value R.G.-1 books amount – 670336.3 (-)Total Cancelled bills Assessable Value amt- 15542 Balance tally system assessable value 654794.3 Total 16.48% excise duty in R.G.-1 books amt-110472 (-)Total Cancelled bills 16.48% excise duty - 2561 Balance tally system 16.48% excise duty 107911 DEC-07 Date
INV NO.
Assessable 16%Excise 2%cess Value duty on ED
1%cess on HED
Remarks
20.12.07
2188
11160
Particula r
12.5%Vat Sales
CST Sales
Tally
996377.30 68220 0 996377.30 68220 0
R.G.-1
JAN-08 Date
INV NO.
31.1.08
1786
36
18
Total 16%Excise 2%cess Assessable duty on ED Value 1678577.3 268572.37 5371.3 4 1678577.3 268572.37 5371.3 4
Bill cancelled in RG-1 1%cess on HED 2685.7 6 2685.7 6
2360
Assessable 16%Excise 2%cess Value duty on ED 11250 1800 36
1%cess on HED 18
31.1.08
2361
700
18
36
18
31.1.08
2362
4175
668
13
6
16125
2486
85
42
Total Particula r
12.5%Vat Sales
Tally
923924.60 19100 0 940049.60 19100 0
R.G.-1
FEB-08
CST Sales
Total 16%Excise 2%cess Assessable duty on ED Value 1114924.6 178386.41 3567.0 6 1131049.6 180967 3619
Total Excise duty 276629.47 276629.47
Remarks 31.1.08tally not entry, entry in tally 4.02.08 31.1.08tally not entry, entry in tally 4.02.08 31.1.08tally not entry, entry in tally 4.02.08
1%cess on HED 1783.7 4 1809
Total Excise duty 183737.21 186395
Date
INV NO. 2410 2419
Assessable Value 13000 5280
16%Excise duty 2080 844
2%cess on ED 42 16
1%cess on HED 21 8
22.2.08 22.2.08 19.2.08
2394
775
124
2
1
Particula r
12.5%Vat Sales
CST Sales
Tally
649484.
R.G.-1
663664
68225 0 68225 0
MAR-08 Date
INV NO.
14.3.08 31.3.08
2513 2568
Particula r
12.5%Vat Sales
CST Sales
Tally
1419656.8 0 1442956.8 0
65015 0 65015 0
R.G.-1
Total 16%Excise 2%cess Assessable duty on ED Value 1331734 213082.04 4261.1 0 1345914 215346 4306
Assessable Value 15900 7400
16%Excise duty 2226 1036
2%cess on ED 44 21
Tally not entry RG-1 book and tally entry not tally(4875+803.4) bill cancelled in tally
1%cess on HED 2130.7 2 2153
1%cess on HED 22 10
Total 14%Excise 2%cess Assessable duty on ED Value 2118326.80 289772.03 5794.3 6 2093106 293028 5857
Remarks
Total Excise Duty 219473.86 221805
Remarks Tally not entry bill cancelled in tally
1%cess on HED 2897.5 6 2930
Total Excise Duty 298463.95 301815
2007-08 Sales bills Excise duty OBSEVATION SHEET Date INV Assessable 16%Excise 2%cess 1%cess NO. Value duty on ED on HED 17.04.07 1336 168000 26880 538 269 27.04.07
1368
2230
357
7
4
27.04.07
1369
1500
240
5
2
10.5.07
1403
1500
240
5
3
22.5.07
1453
1650
264
5
2
2.6.07
1506
450
72
1.44
.72
7.6.07
1519
490
78.40
1.56
.78
7.6.07
1521
420
67.80
1.34
.67
8.6.07
1524
7500
1200
24
12
11.6.07
1526
825
304
6.08
3.04
18.6.07
1577
490
78
1
1
29.6.07
1606
600
90
2
1
26.7.07
1694
1520
243
5
2
6.8.07
1725
1610
258
5
3
8.8.07
1735
760
122
2
1
13.8.07
1758
2850
456
9
5
24.8.07
1801
190
30
1
0
3.9.07
1823
11550
1848
37
18
19.9.07
1886
9630
1541
31
15
24.9.07
1893
95
15
0
0
24.9.07
1898
11550
1848
37
18
Remarks bill cancelled in tally bill cancelled in tally bill cancelled in tally Bill cancelled in tally Bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally
29.9.07
1914
570
91
2
1
17.10.07
1958
1650
264
5
3
29.10.07
1991
3600
576
12
6
30.10.07
2001
920
147
3
1
2.11.07
2017
5340
854
17
9
2.11.07
2018
890
142
3
1
5.11.07
2024
3080
493
10
5
9.11.07
2044
832
133
3
1
13.11.07
2061
5400
864
17
9
20.12.07
2188
11160
1786
36
18
31.1.08
2360
11250
1800
36
18
31.1.08
2361
700
18
36
18
31.1.08
2362
4175
668
13
6
22.2.08 22.2.08
2410 2419
13000 5280
2080 844
42 16
21 8
19.2.08
2394
775
124
2
1
14.3.08 31.3.08
2513 2568
15900 7400
2226 1036
44 21
22 10
bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally bill cancelled in tally Bill cancelled in RG-1 31.1.08tally not entry, entry in tally 4.02.08 31.1.08tally not entry, entry in tally 4.02.08 31.1.08tally not entry, entry in tally 4.02.08 Tally not entry RG-1 book and tally entry not tally(4875+803.4) bill cancelled in tally Tally not entry bill cancelled in tally