Monthly Expenditure Ledger

  • Uploaded by: SpreadsheetZONE
  • 0
  • 0
  • May 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Monthly Expenditure Ledger as PDF for free.

More details

  • Words: 4,526
  • Pages: 72
General Ledger - Historic Futures Ltd (Pakistan) Date 20-10-2007

Particulars

Dr. (PKR)

O/B- Funds Transfer

Cr. (PKR)

295,790

Visa Fee

7,875

26-10-2007

Printer HP J5780

8,000

26-10-2007

Phone Set

26-10-2007

White wash/Paint exp

26-10-2007

Electric socket

30-10-2007

ORIX- 1st Invoice Payment

31-10-2007

Stationary

1,951

31-10-2007

c/d Balance

6,869

500 1,350 70 269,175

295,790

295,790

6,869

0

01-11-2007

c/f Balance

02-11-2007

Internet Cable

1,225

03-11-2007

Net Connection+service chg

1,100

13-11-2007

Entertainment- Tourist Bus ticket

=22x127

2,794

14-11-2007

Memory Card -Mobile phone

=30x127

3,810

20-11-2007

Electric socket

20-11-2007

Dhakka Return Ticket

21-11-2007

Mobile Connection

1,500

21-11-2007

Mobile new conn.deposit

1,000

90 33,800

18-23-11-2007 CNG/Fuel exp

1,109

21-11-2007

Bangladesh Visa Fee

150

23-11-2007

Business Card exp

26-11-2007

Taxi Fare

28-11-2007

Simon cash (TK.1000 x 0.98 = PKR 980)

980

28-11-2007

Simon cash (USD100 x 60 = PKR 6000)

6,000

26/11 -1/12

Dinner exps (TK.545 x 0.98 = PKR 534)

534

26/11 - 1/12 Entertainment (TK.65 x 0.98 = PKR 64)

64

1,700 310

26/11 - 1/12 Transport fare (TK.285 x 0.98 = PKR 279) 30-11-2007

c/d Balance

279 35,616

0

49,465

49,465

0

35,616

01-12-2007

c/f Balance

02-12-2007

Hotel room balance (USD2x60 = PKR120)

120

02-12-2007

Taxi Fare

180

02-12-2007

Car Registeration fees

9,000

03-12-2007

Dinner

10-12-2007

Funds Transfer (GBP1000 x PKR128.53)

3/12 - 7/12

Petrol/ Fuel exp

8-12-2007

Internet Charges

12-12-2007

Car accessories (security system etc..)

14-12-2007

Car Tyres

16-12-2007

Seema Medical (Emergency+Medicines)

17-12-2007

Mobile Bill (Nov07)

24-12-2007

Landline Bill (Nov07)

31-12-2007

c/d Balance

1,035 128,531 3,555 600 7,200 14,400 4,833 481 1,070 50,441 128,531

01-01-2008 17-01-2008

31-01-2008 01-02-2008

c/f Balance

50,441

Float amount

16,421

Landline Bill (Dec07)

128,531

960

Mobile Bill (Dec07)

1,500

Mum-Khi Air tickets

26,500

Dhk-Khi Air tickets

29,000

Visa exp (BD+IN)

3,015

Internet Exp Taxi Fare Petrol Exp Computer accessories Seema Medical c/d Balance

29-02-2008

c/f Balance Float amount Landline Bill Jan Mobile Bill Jan Internet Exp Feb Taxi Fare Feb Mobile Sim BD (TK300x0.95=PKR 285) Telephone Card DB (AED20x17.02=PKR340) Telephone Card QR (QR30x17.18=PKR515) Hotel lunch (TK285x0.95=PKR270) Petrol exp Power supply PC Medical consultancy- Seema Medicines - Seema Taxi+Petrol c/d Balance

01-03-2008

c/f Balance

6,261 73,123

600 840 4,583 895 5,230 0 73,123 6,261

70,338

70,338 55,347

1,360 1,320 600 220 285 340 515 270 1,280 400 400 798 942 55,347 70,338

Float Transfer Landline Bill Feb Mobile Bill Feb Internet Exp Taxi Fare Petrol exp Multi Plug holder Bangkok Visa fee Bangkok Hotel Bill (TB16728xPKR1.97) Temple tickets (TB300x1.97=PKR591) Bus Fare Pattaya(TB234x1.97=PKR461) Drinks (TB95x1.97=PKR187) Miscellenous (TB800x1.97=PKR1576) Taxi Fare Medical -Seema Telephone Set (Rs.3300-500=2800) PC -Desktop for office Petrol exp 31-03-2008 01-04-2008

30-04-2008 01-05-2008

67,281 3,270 1,531 600 470 1,083 40 2,000 32,954 591 461 187 1,576 235 1,061 2,800 24,000 482

c/d Balance c/f Balance Float amt adjusted for salary&car Dhaka Return ticket Hotel Bill (Tk.26012x0.9=PKR.23411) Visa Fee BD Rickshaw BD (Tk.220x0.9=PKR.198) Taxi Fare Mobile Bill Internet Charges Printer cartridge (Black) Electric extention wire Courier Charges Petrol exp Seema medicines Landline Bill Bangkok hotel bill adjustment(34812-32954) Car Service Petrol exp USB Extention cable Seema medical c/d Balance c/f Balance Float amount transfer Mobile Bill Landline Bill Petrol Exp Internet exp Car Mobile charger Mobile Security deposit Petrol BD Tesco

122,628 49,287

19,947 69,234

49,287 122,628 4,678 22,750 23,411 2,200 198 500 1,367 600 850 130 1,480 1,239 250 3,900 1,858 550 783 40 2,450 0 69,234 19,947

80,257 1,409 2,750 2,719 600 250 2,500 290

31-05-2008 01-06-2008

30-06-2008 01-07-2008

BD Visa Fee Taxi Fare BD Petrol IN C&A IN Visa Fee Photographs for visas Seema Medicines Return Ticket Khi-Dac-Khi UPS Batteries Dinner BD TK320 x PK0.98 c/d Balance c/f Balance Float amount transfer -ve balance Internet DSL Landline Bill Voltage Stablizer Petrol Cash (281+272) Taxi Fare (515+410) Mobile Bill Petrol Exp Car tunning+Service Return Ticket Khi-Bom-Khi Air Ticket Cmb-Bom Travelling Pillow Hotel Velan Tirupur -India Pranathi (INR 700x1.7=PKR1190) Miscelleneous Exp (INR 623x1.7=PKR1059)

2,000 645 265 1,030 200 366

80,257 45,286

5,112 1,200 1,880 2,400 553 925

1,190 1,059

c/d Balance c/f Balance Float amount transfer Internet DSL Landline Bill Petrol Cash Stationery Items Seema Medical UK Visa Fee UK Return Ticket UPS Installation Charges UPS Mobile Bill Petrol Credit Tagline Dinner

31-07-2008

c/d Balance

01-08-2008

c/f Balance Float amount transfer Petrol Credit Petrol Cash Seema Medicines

45,286 80,257

46,476 33,347 19,631

33,347 46,476

1,200 790 1,641 270 300 9,750 66,000 600

27,573 80,551

0 80,551 27,573

0 747 320

14-08-2008 17-08-2008 18-08-2008 19-08-2008 21-08-2008 23-08-2008

25-08-2008

Key Board DSL Internet Taxi Khi Airport Bus Heathrow (£4xPKR135) Dinner Priemer Inn(£6.60xPKR135) Mobile Top-Up (£20xPKR135) Tea (£2xPKR135) Meal (£5.8xPKR135) Meal (£5.7xPKR135) Milk BBQ (£3.46xPKR135) Meal (£5.3xPKR135) Lunch 3days (£5.1xPKR135) Meal FS+PN (£10.6xPKR135) Coffee (£3.65xPKR135) Train Kingham-London (£22.2xPKR135) Petrol (£10xPKR135) Tube Ticket (£5.9xPKR135) Chester House Hotel Bill (£510xPKR135) Juice (£1.55xPKR135) Petrol (£10.03xPKR135) River Cruise (£6.5xPKR135) Madame Tassauds Ticket (£25xPKR135) London Eye Ticket (£15xPKR135) Taxi Heathrow airport (£38xPKR135) Taxi Karachi airport Mobile Bill Landline Bill Premier Inn Hotel Bill (£55xPKR135)

31-08-2008

c/d Balance

01-09-2008

c/f Balance Float amount transfer Petrol Credit Petrol Cash Car Service + Oil Car Wheel Allignment Printer Cartridge (Black) A/4 Printer paper rim Car accessories Medical Lab Test X-Ray Medical & Medicines Mobile Bill DSL Internet Bill Landline Bill Medical & Medicines Visa Fee Bangladesh Return Air ticket Khi-Dac-Khi

30-09-2008

c/d Balance

330 800 460 540 270 270 783 770 467 716

493 2,997 797 209 1,755 6,750 2,025 5,130 290 3,810

27,514 42,908

0 42,908 27,514

69,614 360 159 1,150 295 650 2,400

2,000 800 2,070 2,050 500

31,266

01-10-2008

31-10-2008 01-11-2008

30-11-2008 01-12-2008

c/f Balance Float Transfer 01-Car Exp: Petrol Cash Petrol Credit 02-Office Exp: Landline Bill DSL Internet Bill Mobile Bill 03-Travelling Exp: Taxi home to airport 05.10.08 Taxi airport to home 10.10.08 Taxi Lahore airport 10.10.08 Taxi home to airport 11.10.08 Taxi airport to home 24.10.08 Cycle Rickshaw (BDT130x1.175) 04-Medical Exp: Medicines -Farhan Medicines -Seema Consultation -Seema X-Ray -Seema Hydrotherapy- Seema 05-Food/ Hotels Bahawalpur stay (hotel food) Lahore stay (hotel food) Westin Dhaka Hotel bill Dinner 15.10.08 Dhaka Dinner 21.10.08 Dhaka Dinner 22.10.08 Dhaka (BDT268x1.175) 05-Others Mobile Sim+ Card (Simon) BDT220x1.175 Mobile Card (Farhan) BDT200x1.175 c/d Balance c/f Balance 01-Car Exp: Petrol Cash Petrol Credit Car Service 02-Office Exp: Landline Bill DSL Internet Bill Mobile Bill Postage Charges 04-Medical Exp: Seema Medical c/d Balance c/f Balance 01-Car Exp: Petrol Cash

70,414 31,266 12,066

70,414

770

6,500 800

460 300 880 460 260 153 48 347 500 790 2,800 835

432

44,132 28,103

259 235 28,103 44,132

1,003 300 2,840

28,103 15,459

8,501 15,459 28,103

0

31-12-2008 01-01-2009

Petrol Credit 02-Office Exp: Landline Bill DSL Internet Bill Mobile Bill 03-Travelling Exp: Taxi Fare c/d Balance c/f Balance Float Transfer 01-Car Exp: Petrol Cash Petrol Credit Car Service Car Checkup 02-Office Exp: Landline Bill DSL Internet Bill Mobile Bill 03-Travelling Exp:

8,350 2,000

15,459 4,669 56,430

440 4,669 15,459

801 300

8,420

04-Medical Exp: Seema+Farhan Medical

2,250

05-Food/ Hotels 05-Others 30-01-2009 01-02-2009

c/d Balance c/f Balance 01-Car Exp: Petrol Credit Car Repair + Service 02-Office Exp: Landline Bill DSL Internet Bill Mobile Bill Wi-Max Device for Internet Printer Service+Cartridge Visiting Cards printing Visiting Card Album 03-Travelling Exp: Thai Visa Fee Thai Return Air ticket 04-Medical Exp: Seema+Farhan 05-Food/ Hotels 05-Others

61,099 49,328

49,328 61,099

850 9,150

1,500 2,800 2,000 600 2,000

2,350

28-02-2009 01-03-2009

31-03-2009 01-04-2009

c/d Balance c/f Balance 01-Car Exp: Petrol Credit Car Service 02-Office Exp: Landline Bill Mobile Bill 03-Travelling Exp: Bangladesh Visa Fee BD Return air ticket Taxi (THB) Toll Tax (THB 70x2.4) Travelling exp (THB 1168x2.4) Taxi for Khi Airport Taxi from Khi Airport 04-Medical Exp: Medical 05-Food/ Hotels Bangkok Hotel Bill (THB) 05-Others Wireless Router for Office Mobile Sim (THB 200x2.4) Soft Drink (THB 120x2.4)

49,328 28,078

210 4,840

200

168 2,803 460 320 1,580

480 280

c/d Balance

30-04-2009

c/f Balance Float Transferred 10.04.09 (Bhanero) Float taken for Salary adjustment 01-Car Exp: Petrol Credit Car Repair Car Service 02-Office Exp: Landline Bill Mobile Bill Internet DSL 03-Travelling Exp: Taxi Airport 04-Medical Exp: Medical 05-Food/ Hotels Hotel Bill (TK) Dinner (FS+SC) Tk 06-Others Sight Seeing (FS+SC) TK 760x1.2=PKR912 Bangla Mobile Card TK100x1.2= PKR 120 c/d Balance

01-05-2009

c/f Balance

28,078 49,328

28,078 17,497 45,555

17,497 28,838

1,619

200 6,900

760 3,020

63,052 49,521

912 120 49,521 63,052

01-Car Exp: Petrol Credit 02-Office Exp: Landline Bill Mobile Bill Internet DSL 03-Travelling Exp: Turkey Visa Fee 04-Medical Exp: Medical 05-Food/ Hotels

6,110

3,550 300

06-Others 31-05-2009 01-06-2009

29/06/09

30-06-2009 01-07-2009

c/d Balance c/f Balance 01-Car Exp: Petrol Credit 02-Office Exp: Landline Bill Mobile Bill 03-Travelling Exp: Bangladesh Visa Taxi Karachi Airport Taxi Ist airport (TL 90x52.9) Taxi 2-weeks (TL 327x52.9) Taxi Khi Airport drop 04-Medical Exp: Medicines 05-Food/ Hotels Refreshment (TL 26x52.9) Breakfast+Dinner for 7 days (TL 455x52.9) Dinner with Veronica (TL19.75x52.9) Refreshment (TL 50x52.9) Lunch (TL15.75x52.9) Hotel Bill (TL 4771.59x52.9) 06-Others Laptop Mouse Passport Renewal fees Turkey Mobile Sim (TL 22x52.9) Phone Call (TL 2x52.9) Museum+Ferry ride (TL 29x52.9) c/d Balance c/f Balance Float Amount Transferred 01-Car Exp: Petrol Credit Petrol Cash 02-Office Exp: Landline Bill

49,521 39,561

39,561 49,521

13,340

200 450 4,761 17,298 460 651 1,375 24,069

2,125

26,808 66,369

106 1,534 0 66,369 26808

86389

398 9,410

Mobile Bill Internet Exp- June Internet Exp- July 03-Travelling Exp: Taxi (Khi Airport to Home) 04-Food/ Hotels Hotel Bill (Dhaka, BD) Dinner (TK225x1.19=PKR267) Dinner (TK200x1.19=PKR238) Refreshment 05-Others 31-07-2009

330

267 238

c/d Balance 86,389

48,938 86,389

RBS Card

Added back in Float

Customer

24000 10608 313 34921

1658 2176 1930 26950 INR 3653 INR 540 INR 24226

32714

11730 1103 2111 2093

5307

1077

1200

PKR 800

891 2700

£2xPKR135

689 1431 2997£22.2xPKR135 1350 797 £5.9xPKR135 68850 1354 877 £13xPKR135 3375 £50xPKR135 2025£15.5xPKR135

2208 7425

99246

2599 300 600

450 220 1295 2000

24980

800

32444

1328

2000 1834

800

IKEA IKEA IKEA IKEA IKEA

6345 183975 1630 264

197376

3293

2000 1550 1958

8801

TESCO TESCO TESCO TESCO

2988

1522

4510

3525

2435

2000 2000

9960

4,488

1,036 1,780

32,045

Patagonia Patagonia

39,349

2,873

1,615

27,560 600

6,932

Patagonia Patagonia Patagonia Patagonia Patagonia

Patagonia

3,075 Patagonia Patagonia

42,655

3,740 1,979

1,500 1,251

28,629 2,350

39,449

5,276

2,410 1,621 TESCO

9,307

1,799

2,138 IKEA TESCO TESCO TESCO IKEA

TESCO TESCO 1,044 2,645 833 252,417

TESCO TESCO TESCO

501 1,164

260,876

4,359

TESCO TESCO

1,005 1,304 1,111 IKEA TK21402

TK180

7,779

IKEA IKEA IKEA IKEA

General Ledger - Historic Futures Ltd (Pakistan) Date 20-10-2007

Particulars O/B- Funds Transfer

Dr. (PKR)

Cr. (PKR)

295,790

Visa Fee

7,875

26-10-2007

Printer HP J5780

8,000

26-10-2007

Phone Set

26-10-2007

White wash/Paint exp

26-10-2007

Electric socket

30-10-2007

ORIX- 1st Invoice Payment

31-10-2007

Stationary

1,951

31-10-2007

c/d Balance

6,869

500 1,350 70 269,175

295,790

Funds Transfer 20/10/07 chq# 373151

295790

295,790

Ref. Chq # 373151 N.A HP J5780.jpg Phone Set.jpg Paint+Socket.jpg Paint+Socket.jpg Orix.bmp Stationary.jpg

Note: Pls.refer my attached Bank Statement for the transaction of Rs.295790

General Ledger - Historic Futures Ltd (Pakistan) Date

Particulars

Dr. (PKR)

Cr. (PKR)

01-11-2007

c/f Balance

6,869

0

02-11-2007

Internet Cable

1,225

03-11-2007

Net Connection+service chg

1,100

13-11-2007

Entertainment- Tourist Bus ticket

=22x127

2,794

14-11-2007

Memory Card -Mobile phone

=30x127

3,810

20-11-2007

Electric socket

20-11-2007

Dhakka Return Ticket

21-11-2007

Mobile Connection

1,500

21-11-2007

Mobile new conn.deposit

1,000

90 33,800

18-23-11-2007 CNG/Fuel exp

1,109

21-11-2007

Bangladesh Visa Fee

150

23-11-2007

Business Card exp

26-11-2007

Taxi Fare

28-11-2007

Simon cash (TK.1000 x 0.98 = PKR 980)

980

28-11-2007

Simon cash (USD100 x 60 = PKR 6000)

6,000

26/11 -1/12

Dinner exps (TK.545 x 0.98 = PKR 534)

534

26/11 - 1/12 Entertainment (TK.65 x 0.98 = PKR 64)

64

1,700 310

26/11 - 1/12 Transport fare (TK.285 x 0.98 = PKR 279) 30-11-2007

c/d Balance

279 35,616

0

49,465

49,465

Ref.

Office Exp\Internet Cable.pdf Internet Exp\Net Connection.pdf Entertainment\Tour Ticket Big Bus London.pdf Office Exp\Memory Card.pdf Office Exp\Electric Socket.pdf Travelling Expenses\Dhakka Return Ticket.pdf Mobile Exp\Mobile connection.pdf Mobile Exp\Mobile Deposit.jpg Car Exp\Petrol\Nov 07.pdf Visa Exp\Bangladesh Visa Fee.jpg Office Exp\Business Cards.pdf Travelling Expenses\Taxi Fare.pdf

Meal Exp\Dinner exps.pdf Entertainment\Tour Tickets.pdf Travelling Expenses\Rikshaw Fare.pdf

General Ledger - Historic Futures Ltd (Pakistan) Date

Particulars

Dr. (PKR)

Cr. (PKR)

01-12-2007

c/f Balance

0

02-12-2007

Hotel room balance (USD2x60 = PKR120)

120

02-12-2007

Taxi Fare

180

02-12-2007

Car Registeration fees

9,000

03-12-2007

Dinner

1,035

10-12-2007

Funds Transfer (GBP1000 x PKR128.53)

3/12 - 7/12

Petrol/ Fuel exp

8-12-2007

Internet Charges

12-12-2007

Car accessories (security system etc..)

14-12-2007

Car Tyres

16-12-2007

Seema Medical (Emergency+Medicines)

17-12-2007

Mobile Bill (Nov07)

24-12-2007

Landline Bill (Nov07)

31-12-2007

c/d Balance

128,531 3,555 600 7,200 14,400 4,833 481 1,070 50,441 128,531

Funds Transfer on 10/12/07 chq# 375732

206916

less: Oct Salary

22500

less: Nov Salary

45000

less: Car Installment

10885

Float amount

35,616

128531

128,531

Ref.

Accomodation\Hotel Room.pdf Travelling Expenses\Taxi.pdf Meal Exp\Meal.pdf Car Exp\Petrol\Dec 07.pdf Internet Exp\Dec 07.pdf Car Exp\Maintenance\Car accessories.pdf Car Exp\Maintenance\Tyres.pdf Medical Exp\Seema Medical Dec07.pdf Mobile exp\Nov07.pdf Telephone Bills\Nov07.pdf

136142 45000 10885

Note: Pls.refer my attached Bank Statement for the transaction of Rs.206916

General Ledger - Historic Futures Ltd (Pakistan) Date 01-01-2008 17-01-2008

Particulars

Dr. (PKR)

c/f Balance

50,441

Float amount

74,990

Landline Bill (Dec07) Mobile Bill (Dec07)

960 1,500

Wrong Float amount

Mum-Khi Air tickets

26,500

Dhk-Khi Air tickets

29,000

Visa exp (BD+IN)

3,015

Internet Exp

600

Taxi Fare

840

Petrol Exp

4,583

Computer accessories

895

Seema Medical 31-01-2008

Cr. (PKR)

5,230

c/d Balance

52,308 125,431

Funds actually transferred 04/01/08 chq# 2182402

72306

less: Dec Salary

45000

less: Car installment

10885

Float amount

16421 Correct Float amount

125,431

Ref.

Your 19/12/07 email showed funds transferred 76875 pls also see followup email in which you mentioned that you mistakenly wrote 10,000 instead of 10,885 for the car but the amount transferred is OK Note: Pls.refer my attached Bank Statement for the transaction of Rs.72306

General Ledger - Historic Futures Ltd (Pakistan) Date 01-01-2008 17-01-2008

Particulars

Dr. (PKR)

c/f Balance

50,441

Float amount

16,421

Landline Bill (Dec07)

960

Mobile Bill (Dec07)

1,500

Mum-Khi Air tickets

26,500

Dhk-Khi Air tickets

29,000

Visa exp (BD+IN)

3,015

Internet Exp

600

Taxi Fare

840

Petrol Exp

4,583

Computer accessories

895

Seema Medical 31-01-2008

Cr. (PKR)

c/d Balance

5,230 6,261

0

73,123

73,123

Funds actually transferred 04/01/08 chq# 2182402

72306

less: Dec Salary

45000

less: Car installment

10885

Float amount

16421

Ref.

Your 19/12/07 email showed funds transferred 76875 pls also see followup email in which you mentioned that you mistakenly wrote 10,000 instead of 10,885 for the car but the amount transferred is OK Note: Pls.refer my attached Bank Statement for the transaction of Rs.72306

General Ledger - Historic Futures Ltd (Pakistan) Date 01-02-2008

Particulars

Dr. (PKR)

c/f Balance Float amount

6,261 70,338

Landline Bill Jan

1,360

Mobile Bill Jan

1,320

Internet Exp Feb

600

Taxi Fare Feb

220

Mobile Sim BD (TK300x0.95=PKR 285)

285

Telephone Card DB (AED20x17.02=PKR340)

340

Telephone Card QR (QR30x17.18=PKR515)

515

Hotel lunch (TK285x0.95=PKR270)

270

Petrol exp

29-02-2008

Cr. (PKR)

1,280

Power supply PC

400

Medical consultancy- Seema

400

Medicines - Seema

798

Taxi+Petrol

942

c/d Balance

55,347 70,338

Funds transferred on 26/01/08 chq# 2214197

126223

less: Jan Salary

45000

less: Car Installment

10885

Float amount

70338

70,338

Ref.

Yours 11/01/08 email shows funds transferred 130875 Note: Pls.refer my attached Bank Statement for the transaction of Rs.126223

General Ledger - Historic Futures Ltd (Pakistan) Date 01-03-2008

Particulars

Dr. (PKR)

c/f Balance

55,347

Float Transfer

67,281

Landline Bill Feb

3,270

Mobile Bill Feb

1,531

Internet Exp

600

Taxi Fare

470

Petrol exp

1,083

Multi Plug holder

40

Bangkok Visa fee

2,000

Bangkok Hotel Bill (TB16728xPKR1.97)

32,954

Temple tickets (TB300x1.97=PKR591)

591

Bus Fare Pattaya(TB234x1.97=PKR461)

461

Drinks (TB95x1.97=PKR187)

187

Miscellenous (TB800x1.97=PKR1576)

1,576

Taxi Fare

235

Medical -Seema

1,061

Telephone Set (Rs.3300-500=2800)

2,800

PC -Desktop for office

24,000

Petrol exp 31-03-2008

Cr. (PKR)

482

c/d Balance

49,287 122,628

Funds transferred on 04/03/08 IFR NCP 3121

123166

less: Feb Salary

45000

less: Car Installment

10885

Float amount

67281

122,628

Ref.

Supported Invoice attached Supported Invoice attached Supported Invoice attached

Note: Pls.refer my attached Bank Statement for the transaction of Rs.123166

General Ledger - Historic Futures Ltd (Pakistan) Date 01-04-2008

Particulars c/f Balance

Dr. (PKR) 49,287

Float amt adjusted for salary&car

4,678

Dhaka Return ticket

22,750

Hotel Bill (Tk.26012x0.9=PKR.23411)

23,411

Visa Fee BD

2,200

Rickshaw BD (Tk.220x0.9=PKR.198)

198

Taxi Fare

500

Mobile Bill

1,367

Internet Charges

600

Printer cartridge (Black)

850

Electric extention wire

130

Courier Charges

1,480

Petrol exp

1,239

Seema medicines

250

Landline Bill

3,900

Bangkok hotel bill adjustment(34812-32954)

1,858

Car Service

550

Petrol exp

783

USB Extention cable

40

Seema medical 30-04-2008

Cr. (PKR)

c/d Balance

2,450 19,947

0

69,234

69,234

Funds transferred on 01/04/08 chq# 2311942

51207

less: March Salary

45000

less: Car Installment

10885

Float amount

-4678

Ref. pdf file

Already sent Already sent Already sent Already sent Already sent Already sent Already sent Already sent Already sent Already sent Already sent Already sent Already sent Already sent Page-1 Page-1 Page-2 Page-3,4

General Ledger - Historic Futures Ltd (Pakistan) Date 01-05-2008

Particulars

Dr. (PKR)

c/f Balance Float amount transfer

Cr. (PKR) 19,947

80,257

Mobile Bill

1,409

Landline Bill

2,750

Petrol Exp

2,719

Internet exp

600

Car Mobile charger

250

Mobile Security deposit

2,500

Petrol BD Tesco

290

BD Visa Fee

2,000

Taxi Fare BD

645

Petrol IN C&A

265

IN Visa Fee

1,030

Photographs for visas

200

Seema Medicines

366

Return Ticket Khi-Dac-Khi UPS Batteries Dinner BD TK320 x PK0.98 31-05-2008

c/d Balance

45,286 80,257

Funds transferred on 29/04/08 chq#2350439

136142

less: April Salary

45000

less: Car Installment

10885

Float amount

80257

80,257

Ref. pdf file

RBS Card

24000 10608 313 34921

General Ledger - Historic Futures Ltd (Pakistan) Date 01-06-2008

Particulars c/f Balance

Dr. (PKR)

Cr. (PKR)

45,286

Float amount transfer -ve balance

5,112

Internet DSL

1,200

Landline Bill

1,880

Voltage Stablizer

2,400

Petrol Cash (281+272)

553

Taxi Fare (515+410)

925

Mobile Bill Petrol Exp Car tunning+Service Return Ticket Khi-Bom-Khi Air Ticket Cmb-Bom Travelling Pillow Hotel Velan Tirupur -India Pranathi (INR 700x1.7=PKR1190)

1,190

Miscelleneous Exp (INR 623x1.7=PKR1059) 30-06-2008

1,059

c/d Balance

33,347 46,476

Funds transferred on 27/05/08 chq#239179

106658

less:May Salary

45000

less:June Salary

45000

less: Car Installment May

10885

less: Car Installment June

10885

Float amount

-5112

46,476

Ref. pdf file

RBS Card

1658 2176 1930 26950 INR 3653 INR 540 INR 24226

32714

General Ledger - Historic Futures Ltd (Pakistan) Date 01-07-2008

Particulars

Dr. (PKR)

c/f Balance

33,347

Float amount transfer

19,631

Cr. (PKR)

Internet DSL

1,200

Landline Bill

790

Petrol Cash

1,641

Stationery Items

270

Seema Medical

300

UK Visa Fee

9,750

UK Return Ticket

66,000

UPS Installation Charges

600

UPS Mobile Bill Petrol Credit Tagline Dinner 31-07-2008

c/d Balance

Funds transferred on 25/07/08 chq#2479273

27,573

0

80,551

80,551

187286

less:July Salary

45000

less:August Salary

45000

less:September Salary

45000

less: Car Installment July

10885

less: Car Installment August

10885

less: Car Installment September

10885

Float amount

19631

Ref. pdf file

RBS Card

11730 1103 2111 2093

5307

General Ledger - Historic Futures Ltd (Pakistan) Date 01-08-2008

Particulars

Dr. (PKR)

Cr. (PKR)

c/f Balance Float amount transfer

RBS Card

27,573 0

Petrol Credit

1077

Petrol Cash

747

Seema Medicines

320

Key Board

330

DSL Internet

800

1200

Taxi Khi Airport

460

Bus Heathrow (£4xPKR135)

540

Dinner Priemer Inn(£6.60xPKR135)

270

891

Mobile Top-Up (£20xPKR135)

2700

Tea (£2xPKR135)

270

14-08-2008

Meal (£5.8xPKR135)

783

17-08-2008

Meal (£5.7xPKR135)

770

Milk BBQ (£3.46xPKR135)

467

Meal (£5.3xPKR135)

716

18-08-2008

Lunch 3days (£5.1xPKR135)

689

19-08-2008

Meal FS+PN (£10.6xPKR135)

1431

21-08-2008

Coffee (£3.65xPKR135) Train Kingham-London (£22.2xPKR135)

23-08-2008

493 2,997

2997

Petrol (£10xPKR135) Tube Ticket (£5.9xPKR135)

1350 797

797

Chester House Hotel Bill (£510xPKR135)

68850

Juice (£1.55xPKR135) 25-08-2008

209

Petrol (£10.03xPKR135)

1354

River Cruise (£6.5xPKR135)

1,755

877

Madame Tassauds Ticket (£25xPKR135)

6,750

3375

London Eye Ticket (£15xPKR135)

2,025

2025

Taxi Heathrow airport (£38xPKR135) Taxi Karachi airport

5,130 290

Mobile Bill Landline Bill Premier Inn Hotel Bill (£55xPKR135)

2208 3,810 7425

31-08-2008

c/d Balance

Total Amount Added back in Float for the expenses of Seema in UK

27,514

0

42,908

42,908

PKR 15,394

99246

Float Added

PKR 800

£2xPKR135

£22.2xPKR135 £5.9xPKR135

£13xPKR135 £50xPKR135 £15.5xPKR135

General Ledger - Historic Futures Ltd (Pakistan) Date 01-09-2008

Particulars

Dr. (PKR)

Cr. (PKR)

c/f Balance Float amount transfer

RBS Card

27,514 69,614

Petrol Credit

2599

Petrol Cash

360

Car Service + Oil

159

Car Wheel Allignment

600

Printer Cartridge (Black)

1,150

A/4 Printer paper rim

295

Car accessories

650

Medical

2,400

Lab Test

450

X-Ray

220

Medical & Medicines

2,000

Mobile Bill DSL Internet Bill

1295 800

2000

Landline Bill

2,070

Medical & Medicines

2,050

Visa Fee Bangladesh

500

Return Air ticket Khi-Dac-Khi 30-09-2008

300

24980

c/d Balance

31,266 70,414

Funds transferred on 24/09/08 chq#1739845

69614

70,414

32444

Float Added

800

General Ledger - Historic Futures Ltd (Pakistan) Date 01-10-2008

Particulars

Dr. (PKR)

Cr. (PKR)

c/f Balance

31,266

Float Transfer

12,066

RBS Card

01-Car Exp: Petrol Cash

770

Petrol Credit

1328

02-Office Exp: Landline Bill DSL Internet Bill

6,500 800

2000

Mobile Bill

1834

03-Travelling Exp: Taxi home to airport 05.10.08

460

Taxi airport to home 10.10.08

300

Taxi Lahore airport 10.10.08

880

Taxi home to airport 11.10.08

460

Taxi airport to home 24.10.08

260

Cycle Rickshaw (BDT130x1.175)

153

04-Medical Exp: Medicines -Farhan

48

Medicines -Seema

347

Consultation -Seema

500

X-Ray -Seema

790

Hydrotherapy- Seema

2,800

05-Food/ Hotels Bahawalpur stay (hotel food)

835

Lahore stay (hotel food)

6345

Westin Dhaka Hotel bill

183975

Dinner 15.10.08 Dhaka

1630

Dinner 21.10.08 Dhaka

264

Dinner 22.10.08 Dhaka (BDT268x1.175)

432

05-Others

31-10-2008

Mobile Sim+ Card (Simon) BDT220x1.175

259

Mobile Card (Farhan) BDT200x1.175

235

c/d Balance

28,103 44,132

44,132

197376

Funds transferred on 27/10/08 chq#2607068

269721

less:October Salary

75000

less:November Salary

75000

less:December Salary

75000

less: Car Installment Oct

10885

less: Car Installment Nov

10885

less: Car Installment Dec

10885

Float amount

12066

Float Added

Customer

800

IKEA IKEA IKEA IKEA IKEA

TESCO TESCO TESCO TESCO

General Ledger - Historic Futures Ltd (Pakistan) Date 01-11-2008

Particulars c/f Balance

Dr. (PKR)

Cr. (PKR)

RBS Card

28,103

01-Car Exp: Petrol Cash

1,003

Petrol Credit

3293

Car Service

300

02-Office Exp: Landline Bill

2,840

DSL Internet Bill

2000

Mobile Bill

1550

Postage Charges

1958

03-Travelling Exp:

04-Medical Exp: Seema Medical

8,501

05-Food/ Hotels

05-Others

30-11-2008

c/d Balance

15,459 28,103

28,103

8801

Added in Float Customer

General Ledger - Historic Futures Ltd (Pakistan) Date 01-12-2008

Particulars c/f Balance

Dr. (PKR)

Cr. (PKR)

RBS Card

15,459

01-Car Exp: Petrol Cash

0

Petrol Credit

2988

02-Office Exp: Landline Bill

8,350

DSL Internet Bill

2,000

Mobile Bill

1522

03-Travelling Exp: Taxi Fare 31-12-2008

440

c/d Balance

4,669 15,459

15,459

4510

Added in Float Customer

General Ledger - Historic Futures Ltd (Pakistan) Date 01-01-2009

Particulars c/f Balance Float Transfer

Dr. (PKR)

Cr. (PKR)

4,669 56,430

01-Car Exp: Petrol Cash

801

Petrol Credit Car Service

300

Car Checkup 02-Office Exp: Landline Bill

8,420

DSL Internet Bill Mobile Bill 03-Travelling Exp: 04-Medical Exp: Seema+Farhan Medical

2,250

05-Food/ Hotels 05-Others 30-01-2009

c/d Balance

49,328 61,099

Funds transferred on 19/01/09 less:January Salary less:February Salary less:March Salary less: Car Installment Jan less: Car Installment Feb less: Car Installment Mar Float amount

314685 75000 75000 75000 11085 11085 11085 56430

61,099

RBS Card

3525 2435

2000 2000

9960

Added Back in Float

Customer

General Ledger - Historic Futures Ltd (Pakistan) Date 01-02-2009

Particulars c/f Balance

Dr. (PKR)

Cr. (PKR)

49,328

01-Car Exp: Petrol Credit Car Repair + Service

850

02-Office Exp: Landline Bill

9,150

DSL Internet Bill Mobile Bill Wi-Max Device for Internet

1,500

Printer Service+Cartridge

2,800

Visiting Cards printing

2,000

Visiting Card Album

600

03-Travelling Exp: Thai Visa Fee

2,000

Thai Return Air ticket 04-Medical Exp: Seema+Farhan

2,350

05-Food/ Hotels 05-Others 28-02-2009

c/d Balance

28,078 49,328

49,328

RBS Card

Added Back in Float

Customer

4,488

1,036 1,780

Patagonia 32,045

39,349

Patagonia

General Ledger - Historic Futures Ltd (Pakistan) Date 01-03-2009

Particulars c/f Balance

Dr. (PKR)

Cr. (PKR)

28,078

01-Car Exp: Petrol Credit Car Service

210

02-Office Exp: Landline Bill

4,840

Mobile Bill 03-Travelling Exp: Bangladesh Visa Fee

200

BD Return air ticket Taxi (THB) Toll Tax (THB 70x2.4)

168

Travelling exp (THB 1168x2.4)

2,803

Taxi for Khi Airport

460

Taxi from Khi Airport

320

04-Medical Exp: Medical

1,580

05-Food/ Hotels Bangkok Hotel Bill (THB) 05-Others Wireless Router for Office

31-03-2009

Mobile Sim (THB 200x2.4)

480

Soft Drink (THB 120x2.4)

280

c/d Balance

17,497 28,078

28,838

RBS Card

Added Back in Float

Customer

2,873

1,615

27,560 600

Patagonia Patagonia Patagonia Patagonia Patagonia

6,932

Patagonia

3,075 Patagonia Patagonia

42,655

General Ledger - Historic Futures Ltd (Pakistan) Date 01-04-2009

Particulars

Dr. (PKR)

c/f Balance

17,497

Float Transferred 10.04.09 (Bhanero)

45,555

Float taken for Salary adjustment

Cr. (PKR)

1,619

01-Car Exp: Petrol Credit Car Repair Car Service

200

02-Office Exp: Landline Bill

6,900

Mobile Bill Internet DSL 03-Travelling Exp: Taxi Airport

760

04-Medical Exp: Medical

3,020

05-Food/ Hotels Hotel Bill (TK) Dinner (FS+SC) Tk 06-Others

30-04-2009

Sight Seeing (FS+SC) TK 760x1.2=PKR912

912

Bangla Mobile Card TK100x1.2= PKR 120

120

c/d Balance

49,521 63,052

Funds transferred on 18/04/09 less:April Salary less:May Salary less:June Salary less: Car Installment April less: Car Installment May less: Car Installment June Float amount taken

256636 75000 75000 75000 11085 11085 11085 -1619

63,052

RBS Card

3,740 1,979

1,500 1,251

28,629 2,350

39,449

Added Back in Float

Customer

General Ledger - Historic Futures Ltd (Pakistan) Date 01-05-2009

Particulars c/f Balance

Dr. (PKR)

Cr. (PKR)

49,521

01-Car Exp: Petrol Credit 02-Office Exp: Landline Bill

6,110

Mobile Bill Internet DSL 03-Travelling Exp: Turkey Visa Fee

3,550

04-Medical Exp: Medical

300

05-Food/ Hotels 06-Others 31-05-2009

c/d Balance

39,561 49,521

49,521

RBS Card

Added Back in Float

Customer

5,276

2,410 1,621 TESCO

9,307

General Ledger - Historic Futures Ltd (Pakistan) Date 01-06-2009

Particulars c/f Balance

Dr. (PKR)

Cr. (PKR)

39,561

01-Car Exp: Petrol Credit 02-Office Exp: Landline Bill

13,340

Mobile Bill 03-Travelling Exp:

29/06/09

Bangladesh Visa

200

Taxi Karachi Airport

450

Taxi Ist airport (TL 90x52.9)

4,761

Taxi 2-weeks (TL 327x52.9)

17,298

Taxi Khi Airport drop

460

04-Medical Exp: Medicines

651

05-Food/ Hotels Refreshment (TL 26x52.9)

1,375

Breakfast+Dinner for 7 days (TL 455x52.9)

24,069

Dinner with Veronica (TL19.75x52.9) Refreshment (TL 50x52.9) Lunch (TL 15.75x52.9) Hotel Bill (TL 4771.59x52.9) 06-Others Laptop Mouse Passport Renewal fees

2,125

Turkey Mobile Sim (TL 22x52.9) Phone Call (TL 2x52.9)

106

Museum+Ferry ride (TL 29x52.9) 30-06-2009

c/d Balance

Currency Conversion: 1 TL = 52.9 PKR

1,534 26,808

0

66,369

66,369

RBS Card

Added Back in Float

Customer

1,998

2,138 IKEA TESCO TESCO TESCO IKEA

TESCO TESCO 1,044 2,645

TESCO

833

TESCO

252,417

TESCO

501 1,164

TESCO TESCO

261,075

General Ledger - Historic Futures Ltd (Pakistan) Date 01-07-2009

Particulars

Dr. (PKR)

c/f Balance Float Amount Transferred

Cr. (PKR) 26808

86389

01-Car Exp: Petrol Credit Petrol Cash

398

02-Office Exp: Landline Bill

9,410

Mobile Bill Internet Exp- June Internet Exp- July 03-Travelling Exp: Taxi (Khi Airport to Home)

330

04-Food/ Hotels Hotel Bill (Dhaka, BD) Dinner (TK225x1.19=PKR267)

267

Dinner (TK200x1.19=PKR238)

238

Refreshment 05-Others 31-07-2009

c/d Balance

48,938 86,389

Funds Transferred on 09/07/09

353644

less: July Salary less: August Salary less: September Salary less: Car Installment July less: Car Installment August less: Car Installment September less: 3 months Medical payment Float Amount Transferred

75000 75000 75000 11085 11085 11085 9000 86389

86,389

RBS Card

Added Back in Float

Customer

4,359

1,005 1,304 1,111 IKEA TK21402

IKEA IKEA IKEA

TK180

7,779

IKEA

General Ledger - Historic Futures Ltd (Pakistan) Date 01-08-2009

Particulars c/f Balance

Dr. (PKR)

Cr. (PKR)

48,938

01-Car Exp: Petrol Credit Petrol Cash 02-Office Exp: Landline Bill Mobile Bill Internet Exp- Aug 03-Travelling Exp: 04-Food/ Hotels 05-Others 30-08-2009

c/d Balance

48,938 48,938

48,938

Added Back in Float

RBS Card

0

Customer

Related Documents

Expenditure Voucher
April 2020 12
Expo Expenditure
July 2020 13
Citywide Ledger
May 2020 6
General Ledger
November 2019 11
Expenditure Review
October 2019 12

More Documents from ""