Bank Statement Detail Report Report Date 30-AUG-09 12:22 By Account Page 1 of 3 Statement Number 01-JUL-2009 - VS006 Statement Date 01-JAN-09 - 31-DEC-09 Bank Branch Name Bradford Bank Name HSBC Bank Bank Account Number 46464646 Bank Account Name HSBC1 Bank Account Currency GBP Bank Account Number : 46464646 Bank Account Name : HSBC1 Bank Account Currency : GBP Reconciled Statement Lines ---------------------------Statement Line-------------- ----------------------------------------------------Transaction------------------------------------ Statement Amount Num - Type Number Amount Unreconciled Type Status Number Amount Amount Cleared Bank Charges Bank Errors ---- ---------- ------------ ---------------- ---------------- --------- ---------- ---------- -------------------- -------------------- ------------------- ------------------- 1 Payment 10011 117.50 External 1 Payment 10013 117.50 External 2 Payment 10011 0.00 External "2 Payment 10013 1,000.00 0.00 Payment Reconciled 2 1,000.00 1,000.00 0.00 0.00" "3 Payment 10011 1,175.00 External" 5 Receipt 10011 100.00 External 5 Receipt 10013 100.00 0.00 Receipt Cleared 1 100.00 100.00 0.00 0.00 6 Receipt 10011 60.00 External 26 Payment 10011 117.50 0.00 Payment Reconciled 1 117.50 117.50 0.00 0.00 36 Payment 10011 200.00 0.00 Payment Reconciled 4 200.00 200.00 0.00 0.00 46 Payment 10011 587.50 0.00 Payment Reconciled 6 587.50 587.50 0.00 0.00 56 Payment 10011 200.00 0.00 Payment Reconciled 7 200.00 200.00 0.00 0.00 "2 Payment 12-MAR-2009 5,050.00 0.00 Payment Reconciled 128 1,050.00 1,050.00 0.00 0.00" " Payment Reconciled 129 4,000.00 4,000.00 0.00 0.00" "14 Receipt 12-MAR-2009 1,000.00 0.00 Receipt Cleared 1212 1,000.00 1,000.00 0.00 0.00" "24 Receipt 12-MAR-2009 1,000.00 0.00 Receipt Cleared 1212 1,000.00 1,000.00 0.00 0.00" "34 Receipt 12-MAR-2009 1,000.00 0.00 Receipt Cleared 12545 1,000.00 1,000.00 0.00 0.00" "44 Receipt 12-MAR-2009 1,000.00 0.00 Receipt Cleared 23456 1,000.00 1,000.00 0.00 0.00" 1 Payment 06-MAY-2009 70.00 0.00 Payment Reconciled 8 75.00 70.00 0.00 -5.00 11 Payment 06-MAY-2009 5.00 0.00 Payment Reconciled 10 5.00 5.00 0.00 0.00 "21 Payment 06-MAY-2009 2,000.00 0.00 Statement Reconciled 130 2,000.00 2,000.00 0.00 0.00" "1 Misc Recei 20-MAY-2009 3,000.00 2,000.00 Payment Reconciled 191 1,000.00 1,000.00 0.00 0.00" " Statement Reconciled 102 -2,000.00 2,000.00 0.00 0.00" "2 Receipt 06-AUG-2009 176,074.00 0.00 Receipt Cleared 666 9.00 9.00 0.00 0.00" Receipt Cleared 2 9.00 9.00 0.00 0.00 Receipt Cleared 999 9.00 9.00 0.00 0.00 Receipt Cleared 99 8.00 8.00 0.00 0.00 " Receipt Cleared PB1 1,175.00 1,175.00 0.00 0.00" " Receipt Cleared 1357 2,233.00 2,233.00 0.00 0.00" " Receipt Cleared 2354 1,111.00 1,111.00 0.00 0.00" Receipt Cleared 999 999.00 999.00 0.00 0.00 Receipt Cleared 2121 500.00 500.00 0.00 0.00 Receipt Cleared 123456 210.00 210.00 0.00 0.00 Receipt Cleared PR-146594 100.00 100.00 0.00 0.00 Receipt Cleared 30 9.00 9.00 0.00 0.00 Receipt Cleared 5151 100.00 100.00 0.00 0.00 " Receipt Cleared 1000 10,000.00 10,000.00 0.00 0.00" Receipt Cleared 11103 25.25 25.25 0.00 0.00 Receipt Cleared 789 50.00 50.00 0.00 0.00 Receipt Cleared 87 900.00 900.00 0.00 0.00 " Receipt Cleared 1236 1,150.00 1,150.00 0.00 0.00" Receipt Cleared 8665 100.00 100.00 0.00 0.00 Receipt Cleared 1002 100.00 100.00 0.00 0.00 " Receipt Cleared 52113 1,150.00 1,150.00 0.00 0.00" Bank Statement Detail Report Report Date 30-AUG-09 12:22 By Account Page 2 of 3 Statement Number 01-JUL-2009 - VS006 Statement Date 01-JAN-09 - 31-DEC-09 Bank Branch Name Bradford Bank Name HSBC Bank Bank Account Number 46464646 Bank Account Name HSBC1 Bank Account Currency GBP Bank Account Number : 46464646 Bank Account Name : HSBC1 Bank Account Currency : GBP ---------------------------Statement Line-------------- ----------------------------------------------------Transaction------------------------------------ Statement Amount Num - Type Number Amount Unreconciled Type Status Number Amount Amount Cleared Bank Charges Bank Errors ---- ---------- ------------ ---------------- ---------------- --------- ---------- ---------- -------------------- -------------------- ------------------- ------------------- Receipt Cleared 51236 100.00 100.00 0.00 0.00 Receipt Cleared 15220 100.00 100.00 0.00 0.00 Receipt Cleared 2000291464 76.25 76.25 0.00 0.00 Receipt Cleared 32154 200.00 200.00 0.00 0.00 " Receipt Cleared 123456 1,175.00 1,175.00 0.00 0.00" " Receipt Cleared 9999 1,762.50 1,762.50 0.00 0.00" Receipt Cleared 854712 500.00 500.00 0.00 0.00 Receipt Cleared 8574 120.00 120.00 0.00 0.00 " Receipt Cleared 487 112,233.00 112,233.00 0.00 0.00" " Receipt Cleared 1254 1,200.00 1,200.00 0.00 0.00" " Receipt Cleared 44 1,000.00 1,000.00 0.00 0.00" " Receipt Cleared 100001 11,750.00 11,750.00 0.00 0.00" " Receipt Cleared 100002 23,500.00 23,500.00 0.00 0.00" Receipt Cleared 12345 235.00 235.00 0.00 0.00 " Receipt Cleared 1357 1,175.00 1,175.00 0.00 0.00" " Receipt Cleared 54213 1,000.00 1,000.00 0.00 0.00" 1 Non Suffic 07-AUG-2009 9.00 0.00 Receipt Reversed 666 9.00 9.00 0.00 0.00 1 Payment 13-AUG-2009 300.00 0.00 Payment Reconciled 251 300.00 300.00 0.00 0.00 ----------------- ---------------- -------------------- -------------------- ------------------- ------------------- "Net Reconciled 172,385.00 2,000.00 171,630.00 171,635.00 0.00 -5.00" Report data is only for operating units per Responsibility and Preferences. Unreconciled Statement Lines Statement Transaction Statement Line Num Type Number Number Amount Status ----- -------- ------------- ----------------- --------------------- ----------------- " 3 Payment 10013 5 1,175.00 Unreconciled" 4 Payment 10011 10689 15.00 Unreconciled 4 Payment 10013 10689 15.00 Unreconciled 6 Receipt 10013 1234 60.00 Unreconciled " 16 Receipt 10011 1234567 1,250.00 Unreconciled" " 4 Payment 12-MAR-2009 10862 5,100.00 Unreconciled" " 2 Misc Paymen 20-MAY-2009 130 3,000.00 Unreconciled" " 1 Receipt 01-JUL-2009 100 12,367.00 Unreconciled" " 1 Receipt 06-AUG-2009 1128 80,857.00 Unreconciled" 1 Payment 18-AUG-2009 12161 140.00 Unreconciled 2 Payment 18-AUG-2009 12162 70.00 Unreconciled 1 Misc Receip VS006 VS006 20.00 Unreconciled --------------------- "Net Unreconciled 85,039.00" Bank Statement Detail Report Report Date 30-AUG-09 12:22 By Account Page 3 of 3 Statement Number 01-JUL-2009 - VS006 Statement Date 01-JAN-09 - 31-DEC-09 Bank Branch Name Bradford Bank Name HSBC Bank Bank Account Number 46464646 Bank Account Name HSBC1 Bank Account Currency GBP Bank Account Number : 46464646 Bank Account Name : HSBC1 Bank Account Currency : GBP Total for Account Entered Reconciled Unreconciled Overreconciled " Payments 17,455.00 10,940.00 6,515.00 0.00" " Misc Payments 3,000.00 0.00 3,000.00 0.00" " Receipts 274,868.00 180,334.00 94,534.00 0.00" " Misc Receipts 3,020.00 1,000.00 2,020.00 0.00" Non Sufficient Funds 9.00 9.00 0.00 0.00 Rejected 0.00 0.00 0.00 0.00 Stopped 0.00 0.00 0.00 0.00 Sweep In 0.00 0.00 0.00 0.00 Sweep Out 0.00 0.00 0.00 0.00