Excel Files > Bank Reconciliation 2
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 Excel Files > Bank Reconciliation 2 as PDF for free.
More details
- Words: 998
- Pages: 4
Bank Reconciliation PICIC Commercial Bank Ltd., Pak Rupee A/C No. 9962-0300 as on 31-07-2007
Page No. 1
Rupees
483,656.86
Balance as per Cash Book (Dr.) as on 31st July, 2007 Add: Cheques issued but not presented to bank for payment Shikarpur (1) Cheque No. 15149156 Dated: 1-11-06 for teacher honorarium Miss Sanam for October, 06 (2) Cheque No. 15149920 Dated: 1-12-06 for teacher honorarium Miss Asia for November, 06 (3) Cheque No. 15151295 Dated: 2-03-07 for teacher honorarium Miss Asia for Dec., 06 to Feb., 07 (4) Cheque No. 18769350 Dated: 2-06-07 for teacher honorarium Miss Asia for March, 07 to May, 07 Sukkur (1) Cheque No. 15149167 Dated: 1-11-06 for teacher honorarium Miss Zubaida for October, 06 (2) Cheque No. 15149938 Dated: 1-12-06 for teacher honorarium Miss Zubaida for November, 06 (3) Cheque No. 15151280 Dated: 2-03-07 for teacher honorarium Miss Zamiran for Dec., 06 to Feb., 07 (4) Cheque No. 15151282 Dated: 2-03-07 for teacher honorarium Miss Shabana for Dec., 06 to Feb., 07 (5) Cheque No. 15151286 Dated: 2-03-07 for teacher honorarium Miss Zubaida for Dec., 06 to Feb., 07 (6) Cheque No. 18769356 Dated: 2-06-07 for teacher honorarium Miss Zamiran for March, 07 to May, 07 (7) Cheque No. 18769362 Dated: 2-06-07 for teacher honorarium Miss Zubaida for March, 07 to May, 07
1,000 1,000 3,000 3,000 8,000 1,000 1,000 3,000 3,000 3,000 3,000 3,000 17,000
T. M. Khan (1) Cheque No. 18769335 Dated: 2-06-07 for teacher honorarium Miss Hawa for March, 07 to May, 07
3,000
Cheque No. 18769333 Dated: 1-06-07 for teacher honorarium De. Ayesha Irfan for May, 07
3,000
Cheque No. 18770513 Dated: 05-07-07 for CitiBank A/C opening
100,000 106,000
Cheque No. 18770551 Dated: 27-07-07 Dr. Afshan Jaffery Salary June, 07 Cheque No. 18770552 Dated: 27-07-07 Dr. Shehla Ahmed Salary June, 07 Cheque No. 18770553 Dated: 27-07-07 Dr. Tariqa Chishty Salary June, 07 Cheque No. 18770554 Dated: 27-07-07 Dr. Yasmin Azhar Salary June, 07
4,000 7,000 4,000 7,000
Cheque No. 18770555 Dated: 27-07-07 Dr. Shagufta Ahmed Salary June, 07 Cheque No. 18770556 Dated: 27-07-07 Dr. Uzman Shah Salary June, 07 Cheque No. 18770557 Dated: 27-07-07 Dr. Ayesha Irfan Salary June, 07
7,000 4,000 2,000
Page No. 2
35,000 Cheque No. 18770558 Dated: 28-07-07 Mr. Waseem Khan VTC Contractor Cheque No. 18770561 Dated: 28-07-07 M/s. Izhar Construction (Pvt. ) Ltd. For VTC Cheque No. 18770562 Dated: 30-07-07 M/s. Farooq Sons
28,125 37,500 4500 70,125
Less: Cheques deposited but not yet cleared by the bank
Balance as per Bank Statement Dated: 31-07-2007
236,125 719,781.86 -
719,781.86
Bank Reconciliation PICIC Commercial Bank Ltd., Pak Rupee A/C No. 9962-0300 as on 31-08-2007
Page No. 1
Rupees
293,552.36
Balance as per Cash Book (Cr.) as on 31st August, 2007 Add: Cheques issued but not presented to bank for payment Shikarpur (1) Cheque No. 15151295 Dated: 2-03-07 for teacher honorarium Miss Asia for Dec., 06 to Feb., 07 (2) Cheque No. 18769350 Dated: 2-06-07 for teacher honorarium Miss Asia for March, 07 to May, 07
3,000 3,000
Sukkur (1) Cheque No. 15151280 Dated: 2-03-07 for teacher honorarium Miss Zamiran for Dec., 06 to Feb., 07 (2) Cheque No. 15151282 Dated: 2-03-07 for teacher honorarium Miss Shabana for Dec., 06 to Feb., 07 (3) Cheque No. 15151286 Dated: 2-03-07 for teacher honorarium Miss Zubaida for Dec., 06 to Feb., 07 (4) Cheque No. 18769362 Dated: 2-06-07 for teacher honorarium Miss Zubaida for March, 07 to May, 07
3,000 3,000 3,000 3,000
T. M. Khan (1) Cheque No. 18769335 Dated: 2-06-07 for teacher honorarium Miss Hawa for March, 07 to May, 07
3,000
Doctors (1) Cheque No. 18769333 Dated: 1-06-07 for Dr. Ayesha Irfan for May, 07 (2) Cheque No. 18770552 Dated: 27-07-07 Dr. Shehla Ahmed Salary June, 07 (3) Cheque No. 18770553 Dated: 27-07-07 Dr. Tariqa Chishty Salary June, 07 (4) Cheque No. 18770554 Dated: 27-07-07 Dr. Yasmin Azhar Salary June, 07 (5) Cheque No. 18770557 Dated: 27-07-07 Dr. Ayesha Irfan Salary June, 07
3,000 7,000 4,000 7,000 2,000
Cheque No. 18770587 Dated: 04-08-07 for Arts Council of Pakistan WHT
1,400
Cheque No. 18771621 Dated: 29-08-07 for M/s Verson 02
3,000
Less: Transfer of $5,000 [@60.52] from PICIC US $ A/c # 9962-0351 recorded in cash book but not credited by the bank Pay Order (in favour of NIFT) debited from bank a/c but not deducted from cash book
Balance as per Bank Statement Dated: 31-08-2007
48,400 341,952
302,600 1525
(304,125)
37,827.36
Bank Reconciliation PICIC Commercial Bank Ltd., Pak Rupee A/C No. 9962-0300 as on 30-09-2007
Page No. 1
Rupees
477,906.48
Balance as per Cash Book (Cr.) as on 30th September, 2007 Add: Cheques issued but not presented to bank for payment Shikarpur (1) Cheque No. 15151295 Dated: 2-03-07 for teacher honorarium Miss Asia for Dec., 06 to Feb., 07 (2) Cheque No. 18769350 Dated: 2-06-07 for teacher honorarium Miss Asia for March, 07 to May, 07 (3) Cheque No. 18771659 Dated: 6-09-07 for teacher honorarium Miss Nawab for June, 06 to Sep., 07
3,000 3,000 2,000
Sukkur (1) Cheque No. 15151280 Dated: 2-03-07 for teacher honorarium Miss Zamiran for Dec., 06 to Feb., 07 (2) Cheque No. 15151282 Dated: 2-03-07 for teacher honorarium Miss Shabana for Dec., 06 to Feb., 07 (3) Cheque No. 15151286 Dated: 2-03-07 for teacher honorarium Miss Zubaida for Dec., 06 to Feb., 07 (4) Cheque No. 18769362 Dated: 2-06-07 for teacher honorarium Miss Zubaida for March, 07 to May, 07 (5) Cheque No. 18771665 Dated: 6-09-07 for teacher honorarium Miss Zamiran for June, 07 to Sep., 07 (5) Cheque No. 18771666 Dated: 6-09-07 for teacher honorarium Miss Shabana for June, 07 to Sep., 07 (5) Cheque No. 18771667 Dated: 6-09-07 for teacher honorarium Miss Amina for June, 07 to Sep., 07
3,000 3,000 3,000 3,000 3,000 3,000 3,000
T. M. Khan (1) Cheque No. 18769335 Dated: 2-06-07 for teacher honorarium Miss Hawa for March, 07 to May, 07
3,000
Doctors (3) Cheque No. 18770553 Dated: 27-07-07 Dr. Tariqa Chishty Salary June, 07
4,000
Balance as per Bank Statement Dated: 30-09-2007
36,000
513,906.48
Page No. 1
Rupees
483,656.86
Balance as per Cash Book (Dr.) as on 31st July, 2007 Add: Cheques issued but not presented to bank for payment Shikarpur (1) Cheque No. 15149156 Dated: 1-11-06 for teacher honorarium Miss Sanam for October, 06 (2) Cheque No. 15149920 Dated: 1-12-06 for teacher honorarium Miss Asia for November, 06 (3) Cheque No. 15151295 Dated: 2-03-07 for teacher honorarium Miss Asia for Dec., 06 to Feb., 07 (4) Cheque No. 18769350 Dated: 2-06-07 for teacher honorarium Miss Asia for March, 07 to May, 07 Sukkur (1) Cheque No. 15149167 Dated: 1-11-06 for teacher honorarium Miss Zubaida for October, 06 (2) Cheque No. 15149938 Dated: 1-12-06 for teacher honorarium Miss Zubaida for November, 06 (3) Cheque No. 15151280 Dated: 2-03-07 for teacher honorarium Miss Zamiran for Dec., 06 to Feb., 07 (4) Cheque No. 15151282 Dated: 2-03-07 for teacher honorarium Miss Shabana for Dec., 06 to Feb., 07 (5) Cheque No. 15151286 Dated: 2-03-07 for teacher honorarium Miss Zubaida for Dec., 06 to Feb., 07 (6) Cheque No. 18769356 Dated: 2-06-07 for teacher honorarium Miss Zamiran for March, 07 to May, 07 (7) Cheque No. 18769362 Dated: 2-06-07 for teacher honorarium Miss Zubaida for March, 07 to May, 07
1,000 1,000 3,000 3,000 8,000 1,000 1,000 3,000 3,000 3,000 3,000 3,000 17,000
T. M. Khan (1) Cheque No. 18769335 Dated: 2-06-07 for teacher honorarium Miss Hawa for March, 07 to May, 07
3,000
Cheque No. 18769333 Dated: 1-06-07 for teacher honorarium De. Ayesha Irfan for May, 07
3,000
Cheque No. 18770513 Dated: 05-07-07 for CitiBank A/C opening
100,000 106,000
Cheque No. 18770551 Dated: 27-07-07 Dr. Afshan Jaffery Salary June, 07 Cheque No. 18770552 Dated: 27-07-07 Dr. Shehla Ahmed Salary June, 07 Cheque No. 18770553 Dated: 27-07-07 Dr. Tariqa Chishty Salary June, 07 Cheque No. 18770554 Dated: 27-07-07 Dr. Yasmin Azhar Salary June, 07
4,000 7,000 4,000 7,000
Cheque No. 18770555 Dated: 27-07-07 Dr. Shagufta Ahmed Salary June, 07 Cheque No. 18770556 Dated: 27-07-07 Dr. Uzman Shah Salary June, 07 Cheque No. 18770557 Dated: 27-07-07 Dr. Ayesha Irfan Salary June, 07
7,000 4,000 2,000
Page No. 2
35,000 Cheque No. 18770558 Dated: 28-07-07 Mr. Waseem Khan VTC Contractor Cheque No. 18770561 Dated: 28-07-07 M/s. Izhar Construction (Pvt. ) Ltd. For VTC Cheque No. 18770562 Dated: 30-07-07 M/s. Farooq Sons
28,125 37,500 4500 70,125
Less: Cheques deposited but not yet cleared by the bank
Balance as per Bank Statement Dated: 31-07-2007
236,125 719,781.86 -
719,781.86
Bank Reconciliation PICIC Commercial Bank Ltd., Pak Rupee A/C No. 9962-0300 as on 31-08-2007
Page No. 1
Rupees
293,552.36
Balance as per Cash Book (Cr.) as on 31st August, 2007 Add: Cheques issued but not presented to bank for payment Shikarpur (1) Cheque No. 15151295 Dated: 2-03-07 for teacher honorarium Miss Asia for Dec., 06 to Feb., 07 (2) Cheque No. 18769350 Dated: 2-06-07 for teacher honorarium Miss Asia for March, 07 to May, 07
3,000 3,000
Sukkur (1) Cheque No. 15151280 Dated: 2-03-07 for teacher honorarium Miss Zamiran for Dec., 06 to Feb., 07 (2) Cheque No. 15151282 Dated: 2-03-07 for teacher honorarium Miss Shabana for Dec., 06 to Feb., 07 (3) Cheque No. 15151286 Dated: 2-03-07 for teacher honorarium Miss Zubaida for Dec., 06 to Feb., 07 (4) Cheque No. 18769362 Dated: 2-06-07 for teacher honorarium Miss Zubaida for March, 07 to May, 07
3,000 3,000 3,000 3,000
T. M. Khan (1) Cheque No. 18769335 Dated: 2-06-07 for teacher honorarium Miss Hawa for March, 07 to May, 07
3,000
Doctors (1) Cheque No. 18769333 Dated: 1-06-07 for Dr. Ayesha Irfan for May, 07 (2) Cheque No. 18770552 Dated: 27-07-07 Dr. Shehla Ahmed Salary June, 07 (3) Cheque No. 18770553 Dated: 27-07-07 Dr. Tariqa Chishty Salary June, 07 (4) Cheque No. 18770554 Dated: 27-07-07 Dr. Yasmin Azhar Salary June, 07 (5) Cheque No. 18770557 Dated: 27-07-07 Dr. Ayesha Irfan Salary June, 07
3,000 7,000 4,000 7,000 2,000
Cheque No. 18770587 Dated: 04-08-07 for Arts Council of Pakistan WHT
1,400
Cheque No. 18771621 Dated: 29-08-07 for M/s Verson 02
3,000
Less: Transfer of $5,000 [@60.52] from PICIC US $ A/c # 9962-0351 recorded in cash book but not credited by the bank Pay Order (in favour of NIFT) debited from bank a/c but not deducted from cash book
Balance as per Bank Statement Dated: 31-08-2007
48,400 341,952
302,600 1525
(304,125)
37,827.36
Bank Reconciliation PICIC Commercial Bank Ltd., Pak Rupee A/C No. 9962-0300 as on 30-09-2007
Page No. 1
Rupees
477,906.48
Balance as per Cash Book (Cr.) as on 30th September, 2007 Add: Cheques issued but not presented to bank for payment Shikarpur (1) Cheque No. 15151295 Dated: 2-03-07 for teacher honorarium Miss Asia for Dec., 06 to Feb., 07 (2) Cheque No. 18769350 Dated: 2-06-07 for teacher honorarium Miss Asia for March, 07 to May, 07 (3) Cheque No. 18771659 Dated: 6-09-07 for teacher honorarium Miss Nawab for June, 06 to Sep., 07
3,000 3,000 2,000
Sukkur (1) Cheque No. 15151280 Dated: 2-03-07 for teacher honorarium Miss Zamiran for Dec., 06 to Feb., 07 (2) Cheque No. 15151282 Dated: 2-03-07 for teacher honorarium Miss Shabana for Dec., 06 to Feb., 07 (3) Cheque No. 15151286 Dated: 2-03-07 for teacher honorarium Miss Zubaida for Dec., 06 to Feb., 07 (4) Cheque No. 18769362 Dated: 2-06-07 for teacher honorarium Miss Zubaida for March, 07 to May, 07 (5) Cheque No. 18771665 Dated: 6-09-07 for teacher honorarium Miss Zamiran for June, 07 to Sep., 07 (5) Cheque No. 18771666 Dated: 6-09-07 for teacher honorarium Miss Shabana for June, 07 to Sep., 07 (5) Cheque No. 18771667 Dated: 6-09-07 for teacher honorarium Miss Amina for June, 07 to Sep., 07
3,000 3,000 3,000 3,000 3,000 3,000 3,000
T. M. Khan (1) Cheque No. 18769335 Dated: 2-06-07 for teacher honorarium Miss Hawa for March, 07 to May, 07
3,000
Doctors (3) Cheque No. 18770553 Dated: 27-07-07 Dr. Tariqa Chishty Salary June, 07
4,000
Balance as per Bank Statement Dated: 30-09-2007
36,000
513,906.48
Related Documents
Excel Files > Bank Reconciliation 2
November 2019 15
Excel Files > Bank Recociliation
November 2019 3
Bank Reconciliation
November 2019 19
Bank Reconciliation
May 2020 7
Procedure For Bank Reconciliation
November 2019 16