Spreadsheet: 120063d1314962697-adding-values-based-on-both-month-and-text-criteria-saving-rev1
Sheet: Jun

Category | Date | Description | Credit | Debit | Running Balance
Salary | 2011-06-30 00:00:00 | BANK GIRO CREDIT REF ICEGRADE LTD, ICEGRADE | 2020.84 |  | 4635.65
Phone | 2011-06-29 00:00:00 | DIRECT DEBIT PAYMENT TO VODAFONE LIMITED REF 25984152M024009, MANDATE NO 0004 |  | -41.29 | 2614.81
Social | 2011-06-28 00:00:00 | CARD PAYMENT TO BED,13.50 GBP ON 25-06-2011 |  | -13.5 | 2656.1
Social | 2011-06-28 00:00:00 | CARD PAYMENT TO THE WHITE HOUSE,8.50 GBP ON 26-06-2011 |  | -8.5 | 2669.6
Social | 2011-06-28 00:00:00 | CARD PAYMENT TO THE WHITE HOUSE,6.95 GBP ON 26-06-2011 |  | -6.95 | 2678.1
Social | 2011-06-28 00:00:00 | CARD PAYMENT TO BED,5.50 GBP ON 25-06-2011 |  | -5.5 | 2685.05
Petrol | 2011-06-28 00:00:00 | CARD PAYMENT TO SAINSBURYS PETROL,51.29 GBP ON 26-06-2011 |  | -51.29 | 2690.55
Food | 2011-06-28 00:00:00 | CARD PAYMENT TO TESCO STORE 2590,33.71 GBP ON 26-06-2011 |  | -33.71 | 2741.84
Food | 2011-06-27 00:00:00 | CARD PAYMENT TO TESCO STORES SACAT,3.07 GBP ON 24-06-2011 |  | -3.07 | 2775.55
Social | 2011-06-25 00:00:00 | CASH WITHDRAWAL AT NATIONAL WESTMINSTER BANK ATM WOKING, WOKING, 30.00 GBP, ON 25-06-2011 |  | -30 | 2778.62
Social | 2011-06-25 00:00:00 | CASH WITHDRAWAL AT NATIONAL WESTMINSTER BANK ATM WOKING, WOKING, 60.00 GBP, ON 24-06-2011 |  | -60 | 2808.62
Social | 2011-06-23 00:00:00 | CASH WITHDRAWAL AT HSBC BANK PLC ATM 400129KINGSTON, KINGSTON MNY B, 10.00 GBP, ON 23-06-2 |  | -10 | 2868.62
Social | 2011-06-21 00:00:00 | CARD PAYMENT TO STRADA,49.28 GBP ON 11-06-2011 |  | -49.28 | 2878.62
Holiday 2012 | 2011-06-21 00:00:00 | CARD PAYMENT TO VIR ATL [PHONE],615.30 GBP ON 19-06-2011 |  | -615.3 | 2927.9
Social | 2011-06-21 00:00:00 | CARD PAYMENT TO FLARES GUILDFORD,24.70 GBP ON 18-06-2011 |  | -24.7 | 3543.2
Food | 2011-06-21 00:00:00 | CARD PAYMENT TO [NAME] ON 18-06-2011 |  | -8.01 | 3567.9
Petrol | 2011-06-18 00:00:00 | CARD PAYMENT TO SAINSBURYS PETROL,49.08 GBP ON 16-06-2011 |  | -49.08 | 3575.91
Social | 2011-06-17 00:00:00 | CASH WITHDRAWAL AT TESCO PERSONAL FINANCE ATM TESCO K UPN TH, KINGSTON UPON T, 120.00 GBP, |  | -120 | 3624.99
Petrol | 2011-06-17 00:00:00 | CARD PAYMENT TO ESSO PARK GARAGE GROUP PL,15.05 GBP ON 14-06-2011 |  | -15.05 | 3744.99
Misc | 2011-06-14 00:00:00 | CARD PAYMENT TO BOOTS,WOKING,12.24 GBP ON 11-06-2011 |  | -12.24 | 3760.04
Clothes | 2011-06-14 00:00:00 | CREDIT FROM H & MON 2011-06-11 | 14.99 |  | 3772.28
Food | 2011-06-11 00:00:00 | CARD PAYMENT TO TESCO STORES SACAT,2.50 GBP ON 09-06-2011 |  | -2.5 | 3757.29
Social | 2011-06-11 00:00:00 | CASH WITHDRAWAL AT LLOYDS TSB BANK PLC ATM WOKING (309980), WOKING, 20.00 GBP, ON 10-06-20 |  | -20 | 3759.79
Petrol | 2011-06-09 00:00:00 | CARD PAYMENT TO SAINSBURYS PETROL,49.07 GBP ON 07-06-2011 |  | -49.07 | 3779.79
 | 2011-06-07 00:00:00 | INTEREST PAID AFTER TAX 0.32 DEDUCTED | 1.29 |  | 3828.86
Food | 2011-06-07 00:00:00 | CARD PAYMENT TO SACAT SAINSBURYS,15.03 GBP ON 05-06-2011 |  | -15.03 | 3827.57
Social | 2011-06-07 00:00:00 | CARD PAYMENT TO THE LEGION,6.30 GBP ON 04-06-2011 |  | -6.3 | 3842.6
 | 2011-06-06 00:00:00 | BANK GIRO CREDIT REF FAIRFX CLT GBP1, [NAME] |  |  | 3848.9
Misc | 2011-06-06 00:00:00 | CASH WITHDRAWAL AT SAINSBURY S ATM BURPHAM, GUILDFORD, 10.00 GBP, ON 05-06-2011 |  | -10 | 2034.53
Social | 2011-06-04 00:00:00 | CASH WITHDRAWAL AT NATIONAL WESTMINSTER BANK ATM WOKING, WOKING, 50.00 GBP, ON 03-06-2011 |  | -50 | 2044.53
Social | 2011-06-01 00:00:00 | CASH WITHDRAWAL AT TESCO PERSONAL FINANCE ATM TESCO K UPN TH, KINGSTON UPON T, 30.00 GBP, |  | -30 | 2094.53
Car insurance | 2011-06-01 00:00:00 | [NAME], MANDATE NO 0010 |  | -864 | 2124.53
Rent | 2011-06-01 00:00:00 | REGULAR TRANSFER PAYMENT TO ACCOUNT 090133 29153404, MANDATE NO 1 |  | -100 | 2988.53
Petrol | 2011-06-01 00:00:00 | CARD PAYMENT TO SAINSBURYS PETROL,50.99 GBP ON 30-05-2011 |  | -50.99 | 3088.53
Food | 2011-06-01 00:00:00 | CARD PAYMENT TO SAINSBURY'S S/MKT,19.98 GBP ON 30-05-2011 |  | -19.98 | 3139.52