[go: up one dir, main page]

0% found this document useful (0 votes)
82 views22 pages

VAT Bills 074

The document contains detailed financial records of transactions related to various suppliers and services, including VAT calculations and total expenses. It includes information on trekking activities, wages paid to staff, and sales figures for different trips. Overall, the total sales amount to 1,682,800.00 with various breakdowns of taxable and non-taxable sales.

Uploaded by

Lal Dhwoj
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
82 views22 pages

VAT Bills 074

The document contains detailed financial records of transactions related to various suppliers and services, including VAT calculations and total expenses. It includes information on trekking activities, wages paid to staff, and sales figures for different trips. Overall, the total sales amount to 1,682,800.00 with various breakdowns of taxable and non-taxable sales.

Uploaded by

Lal Dhwoj
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 22

S.

N Date Nepali Date Name of Suppliers PAN No Bill No Vatable VAT Grand Total
1 3-Aug-17 International Guest House 500020191 15 2,552.00 331.76 2,883.76
2 4-Oct-17 International Guest House 500020191 110 6,927.00 900.51 7,827.51
3 4-Oct-17 International Guest House 500020191 112 7,656.00 995.28 8,651.28
4 12-Oct-17 International Guest House 500020191 170 7,656.00 995.28 8,651.28
5 13-Oct-17 International Guest House 500020191 178 11,119.90 1,445.59 12,565.49
6 19-Oct-17 International Guest House 500020191 225 3,828.00 497.64 4,325.64
7 28-Oct-17 International Guest House 500020191 309 6,927.80 900.61 7,828.41
8 28-Oct-17 International Guest House 500020191 310 31,358.80 4,076.64 35,435.44
9 8-Nov-17 International Guest House 500020191 410 6,927.80 900.61 7,828.41
10 16-Nov-17 International Guest House 500020191 467 13,855.90 1,801.27 15,657.17
11 19-Nov-17 International Guest House 500020191 489 193,604.40 25,168.57 218,772.97
12 19-Nov-17 International Guest House 500020191 490 420,076.80 54,609.98 474,686.78
13 19-Nov-17 International Guest House 500020191 491 91,872.00 11,943.36 103,815.36
14 17-Dec-17 International Guest House 500020191 607 2,643.30 343.63 2,986.93
15 10 0ct 17 Hotel Raniban Arcade 300697436 445 23,008.81 2,991.15 25,999.96
830,014.51 107,901.89 937,916.40
S.N. Date Date Purchase From Bill no TPIN Vatable VAT Total
1 11-Mar-18 Centrel park resort 109 600873189 308,505.34 40,105.69 348,611.03
2 4-Mar-18 Da Yatra Courtyard (P) ltd 1165 600747925 150,889.65 19,615.65 170,505.30
3 11/22/2074 Helenas café &bar 2473 604277037 12,523.50 1,628.06 14,151.56
4 3-Mar-18 Bhaktapur Branch 1536 304370339 10,808.60 1,405.12 12,213.72
5 10-Mar-18 Bhojan Griha Pvt 3202 300056121 36,669.60 4,767.05 41,436.65
6 26-Feb-18 Boudha stupa resturent & café pvt 4484 304370339 5,821.20 756.76 6,577.96
7 26-Feb-18 Boudha stupa resturent & café pvt 4485 304370339 6,041.20 785.36 6,826.56
8 8-Mar-18 Dhulikhel Mountain Resort B-O1755 300048298 34,815.00 4,525.95 39,340.95

Details for Expenses 566,074.09 73,589.63 639,663.72


S.N. Head No of Pax
1 Bhaktapur Entrance 31500
2 Changunarayan 6780
3 Boudhanath 8000
4 Pashupatinath 20000
5 Swayambhu 4000
6 Sarangkot 1000
7 Devi'ss fall 600
8
9
10

Details for Wages payment


S.N. Name Rate Days Total
1 Prem Tamang 2500 7 17,500.00
2 Bil Bahadur Tamang 2500 7 17,500.00
3 Bhoj kumar tamang 2000 5 10,000.00
4 Jitbahadur tamang 2000 5 10,000.00
5 Danu tamang 2000 5 10,000.00
6 Tirtha tamang 2500 5 12,500.00
7 Rajkumar tamang 2000 5 10,000.00
8 Raju tamang 2000 5 10,000.00
9 Dan Bahadur tamang 2000 5 10,000.00
10 Laldhwoj tamang 2000 5 10,000.00
11 Nir tamang 2500 7 17,500.00
12 fursang tamang 2000 5 10,000.00
13 Chhoisang tamang 2000 5 10,000.00
14 Lanam Tamang 2000 5 10,000.00
Total Salary and Wages for this Trip 165,000.00
Tilicho lake annapurna trekking
Trekking Area Mardi Himal trekking Olivia foong sheng qi (singapore)
Pax 6.00 Cash rececived 100,000.00
Duaration :- 3 oct 17-13 oct 17 File :-006 Pax 2.00
CHANG XUANGYI SHERRRI (Singap 104 ACAP 4,000.00
Cash received 343,200.00 3,300.00 TIMS 2,000.00
ACAP 12,000.00 Guide porter 37,400.00
TIMS 6,000.00 non vatable 43,400.00
Guide porter 80,600.00 Vatable sales 56,600.00
Non vayable 98,600.00 948.08 Vatable sales 50,088.50
Vatable sales 244,600.00 2,351.92 VAT 6,511.50
Vatable sales 216,460.18 2,081.35 total sales 100,000.00
VAT 28,139.82 270.58
Total sales 343,200.00

Jullie green

EBC Trekking 5 Oct 17-18 oct 17


Jullie green (USA) Paul (Austrilia0 100,000.00
ABC Trekking Pax 1.00
14 oct 17-26 oct 17 TIMS 1,000.00
Cash received 286,000.00 57200 550 Flight 47,190.00
Pax 5.00 File :-011 Guide porter 42,500.00
ACAP 10,000.00 non vatable 90,690.00
TIMS 5,000.00 Vatable sales 9,310.00
Flight 57,750.00 Vatable sales 8,238.94
Guide porter 57,600.00 VAT 1,071.06
Non vatable 130,350.00 1,253.37 Total sales 100,000.00
vatable 155,650.00 1,496.63
Vatable sales 137,743.36 1,324.46
VAT 17,906.64 172.18 Pung Quing yoong(Ma260,000.00
Total sales 286,000.00 2,750.00 Pax 5.00
ACAP 10,000.00
EBC trekking LYTLE VICTORIA IRENE (USA) TIMS 5,000.00
Joe 220,000.00 Guide porter 62,400.00
Cash received 14 Oct-17 to 27 Oct17 total non vatable 77,400.00
pax 4.00 File:-010 Vatable sales 182,600.00
TIMS 4,000.00 Vatable sales 161,592.92
Flight 151,160.00 VAT 21,007.08
Guide porter 59,000.00 Total sales 260,000.00
Non taxable 214,160.00 2,059.23
Taxable 5,840.00 56.15 Rhian 249,600.00
Vatable 5,168.14 49.69 Pax 4.00
Vat 671.86 6.46 TIMS 4,000.00
Total sales 220,000.00 2,115.38 ACAP 8,000.00
Guide porter 62,400.00
Eileen prentice (Br 124,000.00 12 oct-25 oct 17 Non vatable 74,400.00
Pax 2.00 File:-9 Vatable 175,200.00
TIMS 2,000.00 Vatable sales 155,044.25
ACAP 4,000.00 Vat 20,155.75
Guide porter 44,200.00 Total sales 249,600.00
Non Vatable 50,200.00 482.69
Vatable sales 73,800.00 709.62
Vatable sales 65,309.73 627.98
Vat 8,490.27 81.64
Total sales 124,000.00 1,192.31

Total sales 1,682,800.00


16,180.77
9 oct 17-20 oct 17

File :-008 Non Vatable sales 779,200.00


Vatable Sales 799,646.02
VAT Received 103,953.98 103,953.98
Total Sales
417.31
544.23 Vatable Purchase 830,014.51
481.62 VAT Paid 107,901.89
62.61 VAT Payable (3,947.90)
961.54

Oct 17-18 oct 17

File no :007

872.02
89.52
79.22
10.30
961.54

1 Oct 17-12 Oct 17


File no :005

744.23
1,755.77
1,553.78
201.99
2,500.00

British File No :-012


2 nov 17-16 nov 17
715.38
1,684.62
1,490.81
193.81
2,400.00
Peace Nepal Treks (P) ltd
Sales details for the month of
Mangsir 2074
File no :005 1 Oct 17-12 Oct 17 File no :007
Pung Quing yoong(Malaysia) 260,000.00 2500 EBC Trekking 5 Oct 17-18 oct 17
Pax ( 5) Amount Rs Amount (USD) Paul (Austrilia) Amount (Rs)
ACAP 10,000.00 96.15 Cash recceived 100,000.00
TIMS 5,000.00 48.08 TIMS 1,000.00
Guide porter 62,400.00 600.00 Flight 47,190.00
total non vatable 77,400.00 744.23 Guide porter 42,500.00
Vatable sales 182,600.00 1,755.77 non vatable 90,690.00
Vatable sales 161,592.92 1,553.78 Vatable sales 9,310.00
VAT 21,007.08 201.99 Vatable sales 8,238.94
Total sales 260,000.00 2,500.00 VAT 1,071.06
Total sales 100,000.00
File :-006
Trekking Area Mardi Himal trekking File :-008 Tilicho
Pax (6) Duaration :- 3 oct 17-13 oct 17 Olivia foong sheng qi (singapore)
CHANG XUANGYI SHERRRI (Singapore) Details Amount (Rs)
Details Amount (Rs) Amount (USD) Cash rececived 100,000.00
Cash received 343,200.00 3,300.00 ACAP 4,000.00
ACAP 12,000.00 115.38 TIMS 2,000.00
TIMS 6,000.00 57.69 Guide porter 37,400.00
Guide porter 80,600.00 775.00 non vatable 43,400.00
Non vayable 98,600.00 948.08 Vatable sales 56,600.00
Vatable sales 244,600.00 2,351.92 Vatable sales 50,088.50
Vatable sales 216,460.18 2,081.35 VAT 6,511.50
VAT 28,139.82 270.58 total sales 100,000.00
Total sales 343,200.00 3,300.00

File:-9 12 oct-25 oct 17 File:-010


Eileen prentice (British) 124,000.00 1,192.31 Joe Pax (4)
Pax (2) Amount (Rs) Amount (USD) Details Amount (Rs)
TIMS 2,000.00 19.23 Cash received 220,000.00
ACAP 4,000.00 38.46 TIMS 4,000.00
Guide porter 44,200.00 425.00 Flight 151,160.00
Non Vatable 50,200.00 482.69 Guide porter 59,000.00
Vatable sales 73,800.00 709.62 Non taxable 214,160.00
Vatable sales 65,309.73 627.98 Taxable 5,840.00
Vat 8,490.27 81.64 Vatable 5,168.14
Total sales 124,000.00 1,192.31 Vat 671.86
Total sales 220,000.00
Jullie green (USA) File :-011
ABC Trekking 14 oct 17-26 oct 17 File No :-012 Rhian (4)
Pax 5 Details Amount (Rs)
Details Amount (RS) Amount (USD) Cash Received 249,600.00
Cash received 286,000.00 2,750.00 TIMS 4,000.00
ACAP 10,000.00 96.15 ACAP 8,000.00
TIMS 5,000.00 48.08 Guide porter 62,400.00
Flight 57,750.00 555.29 Non vatable 74,400.00
Guide porter 57,600.00 553.85 Vatable 175,200.00
Non vatable 130,350.00 1,253.37 Vatable sales 155,044.25
vatable 155,650.00 1,496.63 Vat 20,155.75
Vatable sales 137,743.36 1,324.46 Total sales 249,600.00
VAT 17,906.64 172.18
Total sales 286,000.00 2,750.00

Total Vatable sales 799,646.02


Total Vat collect 103,953.98
Total Non Vatable 779,200.00
Pax (1)

Amount (USD)
961.54
9.62
453.75
408.65
872.02
89.52
79.22
10.30
961.54

9 oct 17-20 oct 17


Pax (2)
Amount (USD)
961.54
38.46
19.23
359.62
417.31
544.23
481.62
62.61
961.54

EBC trekking
14 Oct-17 to 27 Oct17
Amount (USD)
2,115.38
38.46
1,453.46
567.31
2,059.23
56.15
49.69
6.46
2,115.38
2 nov 17-16 nov 17
Amont (USD)
2,400.00
38.46
76.92
600.00
715.38
1,684.62
1,490.81
193.81
2,400.00
Peace Nepal Treks (P) Ltd
Sales Details For the month of
Aswin 2074

File No :- 001 104 File No :- 002 Annapurna trekking Eileen (2 pax)


10/5/2017 10/10/2017 Starting 10/12/2017
Trekking Area Everest Pax (1) Ending 10/20/2017

Details Amount (USD) Amount (Rs) Details Amount (USD) Amount (Rs)
Cash received 871.00 90,584.00 Cash received 500.00 52,000.00
TIMS 9.62 1,000.00 TIMS 19.23 2,000.00
Flight Ticket 460.10 47,850.00 ACAP/MCAP 38.46 4,000.00
Guide Salary 126.92 13,200.00 Guide Salary 155.77 16,200.00
Poter salary 92.31 9,600.00 Poter salary 92.31 9,600.00
Non Vatable sales 688.94 71,650.00 Other 46.15 4,800.00
Vatable sales 182.06 18,934.00 Total Non Vatable sales 351.92 36,600.00
Vatable sales 161.11 16,755.75 Vatable sales 148.08 15,400.00
VAT 20.94 2,178.25 Vatable sales 131.04 13,628.32
Total Sales 871.00 90,584.00 VAT 17.04 1,771.68
Total sales 500.00 52,000.00
File No :-003 10/14/2017 10/20/2017
Jullie Green (5
Annapurna Gorepani Pax) File No :-004 Everest Three pases Joe (4 pax )

Details Amount (USD) Amount (Rs) 12-Oct-17 31-Oct-17


Cash Received 1,100.00 114,400.00 Details Amount (USD) Amount (Rs)
TIMS 48.08 5,000.00 Cash received 2,600.00 270,400.00
ACAP/MCAP 96.15 10,000.00 TIMS 38.46 4,000.00
Flight Ticket 550.00 57,200.00 Flight Ticket 1,453.46 151,160.00
Guide Salary 121.15 12,600.00 Guide Salary 423.08 44,000.00
Poter salary 161.54 16,800.00 Poter salary 615.38 64,000.00
Other 34.62 3,600.00 Total Non Vatable sales 2,530.38 263,160.00
Total Non Vatable sales 1,011.54 105,200.00 Vatable sales 69.62 7,240.00
Vatable sales 88.46 9,200.00 Vatable saels 61.61 6,407.08
Vatable sales 78.28 8,141.59 VAT 8.01 832.92
VAT 10.18 1,058.41 Total sales 2,600.00 270,400.00
Total sales 1,100.00 114,400.00

Toal Vatable Sales 44,932.74


Total Vat Collect 5,841.26
Total Non Vatable 476,610.00
File No :- 001
Starting Date 10/5/2017
Ending Date 10/10/2017

Trekking Area Everest


No of Pax :- 1
Cash received 871.00 90,584.00 104
Expenses
TIMS 1,000.00
ACAP/MCAP -
Flight Ticket 47,850.00
Guide Salary 13,200.00
Poter salary 9,600.00
Other -
Non Vatable sales 688.94 71,650.00
Vatable sales 18,934.00
Vatable sales 161.11 16,755.75
VAT 20.94 2,178.25
Total Sales 90,584.00

File No :-003
Name of Trip Annapurna Gorepani
Name of Group Jullie Green (5 Pax)
Starting 43,022.00
Ending 43,028.00
Cash Received 1,100.00 114,400.00 104.00
Expenses
TIMS 5,000.00
ACAP/MCAP 10,000.00
Flight Ticket 57,200.00
Guide Salary 12,600.00
Poter salary 16,800.00
Other 3,600.00
Total Non Vatable s 1,011.54 105,200.00
Vatable sales 9,200.00
Vatable sales 78.28 8,141.59
VAT 10.18 1,058.41
Total sales 114,400.00

Total non vatabel sales 476,610.00


Total Vatable sales 44,932.74
Total VAT Collection 5,841.26

Toal sales 527,384.00


5,071.00

File no 001
Langtang trekking
Total pax :-4 Carol (USA)
Cash received 170,000.00 1,634.62
TIMS 4,000.00
Guide wages 36,000.00
Porter wages 97,200.00
Total Nonvatable sales 137,200.00 1,319.23
Vatable sales 32,800.00 315.38
Total vatable sales 29,026.55 279.10
VAT 3,773.45 36.28
Total sales 170,000.00

File no :-002
EBC trekking
ASHLEING (2pax)
Toal cash received 145,000.00 1,394.23
Tims 2,000.00
Flight ticket 80,440.00
Guide salary 34,000.00
Porter wages 22,500.00
Total non vatable sales 138,940.00 1,335.96
Vatable sales 6,060.00 58.27
Total vatable sales 5,362.83 51.57
VAT 697.17 6.70
Total sales 145,000.00

Lisa Suke *22


Cash Received 114,500.00 1,100.96
Entrance fee 44,469.00
Guide wages 37,500.00
wages for Porter 22,500.00
Total Non Vatable sales 104,469.00 1,004.51
Vatable Sales 10,031.00 96.45
Total Vatable Sales 8,876.99 85.36
Vat 1,154.01 11.10
Total Sales 114,500.00

NATALIA LESMANA (Indonesian)


Cash Received 97,885.00 941.20
ACAP 6,000.00
TIMS 3,000.00
Wages for Guide 35,000.00
Wages for Porter 52,000.00
Total Non vatable sales 96,000.00 923.08
Vatable sales 1,885.00 18.13
Total Vatable Sales 1,668.14 16.04
VAT 216.86 2.09
File No :- 002
Name of Trip Annapurna trekking
Name of Group Eileen prentice (2 pax)
Trekking Area ABC
Starting 10/12/2017
Ending 10/20/2017
Cash received 500.00 52,000.00 104
Expenses
TIMS 2,000.00
ACAP/MCAP 4,000.00
Flight Ticket -
Guide Salary 16,200.00
Poter salary 9,600.00
Other 4,800.00
Total Non Vatable sal 351.92 36,600.00
Vatable sales 15,400.00
Vatable sales 131.04 13,628.32
VAT 17.04 1,771.68
Total sales 52,000.00
File No :-004
Name of Trip Everest Three pases
Name of Group Joe (4 pax )
Trekking Area Everest Three pases
Starting 12-Oct-17
Ending 31-Oct-17
Cash received 2600 270,400.00 104.00
Expenses 650
TIMS 4,000.00
ACAP/MCAP -
Flight Ticket 151,160.00
Guide Salary 44,000.00
Poter salary 64,000.00
Other
Total Non Vatable sal 2530.3846153846 263,160.00
Vatable sales 7,240.00
Vatable saels 61.6065350579 6,407.08
VAT 8.0088495575 832.92
Total sales 270,400.00

Vatable sales 44,932.74


44,934.51
(1.77)
Non Vatable 476,610.00
Non Vatable 476,609.00
1.00
Statement for defined date- 16 JUL 2017 to 14 JAN 2018
Customer ID. : 105102 Account No. : 01901051020015
Account Name: PEACE NEPAL TREKS(P)LTD Currency :USD
BALANCE AT PERIOD START 1,556.89
VALUEDATE DESCRIPTION REFERENCE POSTDATE AMOUNT
17-Jul-17 Credit Card Payment 01901051020015-20170717\A 17-Jul-17 (15.44)
CC-4404680000007164
24-Jul-17 Transfer FT1720500242\A03 24-Jul-17 5,927.33
GIME-82869
24-Jul-17 Transfer FT1720500245\A03 24-Jul-17 (0.29)
GIME-82869
16-Aug-17 Credit Card Payment 01901051020015-20170816\A 16-Aug-17 (0.49)
CC-4404680000007164
22-Aug-17 Transfer FT1723404043\A40 22-Aug-17 7,008.53
THE ROTARY CLUB
23-Aug-17 Transfer FT1723503399\A40 23-Aug-17 175.00
PUNG QING YOONG
6-Sep-17 Transfer FT1724906579\A40 6-Sep-17 570.00
COOPER JONATHAN
15-Sep-17 Transfer FT1725804484\A40 15-Sep-17 446.46
17-Sep-17 Credit Card Payment 01901051020015-20170917\A 17-Sep-17 (59.38)
CC-4404680000007164
20-Sep-17 Transfer FT1726309429\A40 20-Sep-17 1,760.00
VICTORIA I LYTLE
20-Sep-17 Transfer FT1726309475\A40 20-Sep-17 1,760.00
JOSEPH M
22-Sep-17 Transfer FT1726509181\A40 22-Sep-17 469.00
ASHLEIGH SHONE
6-Oct-17 Transfer FT1727912149\A40 6-Oct-17 1,140.00
SUSAN BENNETT
9-Oct-17 Transfer FT1728200792 9-Oct-17 (2.40)
REQ LOST CHGS.
11-Oct-17 Inward cheque payme TT1728451037 11-Oct-17 (19,308.75)
24495121
11-Oct-17 Transfer FT1728400436\A03 11-Oct-17 142.58
GIMB83029
11-Oct-17 Transfer FT1728400444\A03 11-Oct-17 (0.29)
GIMB83029
16-Oct-17 Transfer FT1728900541\A03 16-Oct-17 18,276.13
GIMB83032
16-Oct-17 Transfer FT1728900543\A03 16-Oct-17 (0.29)
GIMB83032
18-Oct-17 Cash Withdrawal TT1729160692 18-Oct-17 (8,683.06)
NIR BAHADUR
24495122
18-Oct-17 Credit Card Payment 01901051020015-20171018\A 18-Oct-17 (86.38)
CC-4404680000007164
23-Oct-17 Transfer FT1729600042\A40 23-Oct-17 1,475.00
SUSAN BENNETT
25-Oct-17 Cash Withdrawal TT1729866864 25-Oct-17 (8,662.17)
NIR
24495123
25-Oct-17 Transfer FT1729800272\A03 25-Oct-17 377.67
NIBL-3006043687
25-Oct-17 Transfer FT1729800276\A03 25-Oct-17 (0.29)
NIBL-3006043687
16-Nov-17 Credit Card Payment 01901051020015-20171116\A 16-Nov-17 (85.07)
CC-4404680000007164
16-Nov-17 Transfer FT1732004312\A40 16-Nov-17 1,140.00
JOHN FARHALL
17-Nov-17 Cash Withdrawal TT1732192665 17-Nov-17 (3,870.34)
NIR BAHADUR
24495124
17-Dec-17 Credit Card Payment 01901051020015-20171217\A 17-Dec-17 (20.00)
CC-4404680000007164
19-Dec-17 Transfer FT1735300184\A03 19-Dec-17 521.82
GIMB83117
19-Dec-17 Transfer FT1735300187\A03 19-Dec-17 (0.29)
GIMB83117
27-Dec-17 Transfer FT1736105270\A40 27-Dec-17 600.00
NG JIE QI
BALANCE AT PERIOD END 2,551.48
Total Deposit 41,789.52
Opening Balance 1,556.89
Total withdraw (40,524.32)
Credit Card Payment (270.61)
Closing balance 2,551.48

You might also like