Spreadsheet: 126648d1319807471-calculate-a-due-date-cekidot
Sheet: Sheet1

[NAME] August 2011 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | Types | [NAME] | Amounts | Column1 | Column2 | Column3
 | ( INCOME ) ===>>> |  |  | ( BILLS ) ===>>> |  |  | ( FOOD/PETROL/CALOR GAS/CAFE ) ===>>> |  |  |  |  | ( BALANCES ) ===>>> |  |  | Income Types |  |  | 2011-08-01 00:00:00 | BAC | Income 2 | 182.3 | 1377.85 | 'Main | '600849-68034660
 |  |  |  |  |  | -36.85 |  |  |  |  |  | Income: |  |  | Income 1 | *Income 1* |  | 2011-08-01 00:00:00 | POS | '2679 29JUL11 , SHOWCASE CINEMAS , COVENTRY GB | -7.8 | 1370.05 | 'Main | '600849-68034660
 |  |  |  |  |  | -12.57 |  |  |  |  |  |  |  |  | Income 2 | *Income 2* |  | 2011-08-01 00:00:00 | POS | '2679 30JUL11 , ASDA STORES 4602 , COVENTRY GB , CASH BACK 20.00 | -129.23 | 1240.82 | 'Main | '600849-68034660
 |  |  |  |  |  | -25 |  |  |  |  |  |  |  |  | Income 3 | *Income 3* |  | 2011-08-01 00:00:00 | POS | '2679 29JUL11 , SHOWCASE CINEMAS , COVENTRY GB | -10.6 | 1230.22 | 'Main | '600849-68034660
 |  |  |  |  |  | -27 |  |  |  |  |  |  |  |  |  |  |  | 2011-08-01 00:00:00 | POS | '2679 30JUL11 , ASDA STORES 4602 , COVENTRY GB | -5.6 | 1224.62 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Income 4 | *Income 4* |  | 2011-08-01 00:00:00 | POS | '2679 30JUL11 , ASDA STORES/ , PETROL , COVENTRY GB | -30.04 | 1194.58 | 'Main | '600849-68034660
 |  |  |  |  |  | -43 |  |  |  |  |  |  |  |  | From Other | *Other Income* |  | 2011-08-01 00:00:00 | D/D | 'TV LICENCE MBP | -12.43 | 1182.15 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-02 00:00:00 | BAC | INCOME 1 | 114.8 | 1296.95 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  | Outgoings: |  |  |  |  |  | 2011-08-02 00:00:00 | POS | '2679 01AUG11 , PDSA PETAID , ENTERPRISE , COVENTRY GB | -50 | 1276.95 | 'Main | '600849-68034660
 | TOTAL: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-02 00:00:00 | POS | '2679 31JUL11 , MBNA EUROPE CS / , CHESTER GB | -50 | 1226.95 | 'Main | '600849-68034660
 | CASH WITHDRAWN FROM BANK |  |  |  |  |  |  |  |  |  |  | Difference + or - |  |  | Outgoing Types and Bank References |  |  | 2011-08-03 00:00:00 | POS | '2679 02AUG11 , E.ON ENERGY , SOLUTIONS , NOTTINGHAM GB | -27.45 | 1199.5 | 'Main | '600849-68034660
 |  |  |  |  |  | -450 |  |  |  |  |  |  |  |  | SUPERMARKETS / FOOD SHOPS |  |  | 2011-08-05 00:00:00 | POS | '2679 04AUG11 , ASDA STORES 4602 , COVENTRY GB , CASH BACK 20.00 | -100 | 1099.5 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-05 00:00:00 | POS | '2679 04AUG11 , POUNDWORLD 124 , COVENTRY GB | -24 | 1075.5 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Argos | *ARGOS LTD* | *POS* | 2011-08-08 00:00:00 | BAC | Income 3 | 3077 | 1452.5 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ADSA 4231 | *ADSA STORES LTD , 4231* | *POS* | 2011-08-08 00:00:00 | POS | '2679 07AUG11 , WM MORRISON 069 , COVENTRY GB | -33.71 | 1418.79 | 'Main | '600849-68034660
 |  |  |  | BT Credit Card |  |  |  |  |  |  |  | CashInBank | 1195.55 |  | Asda Supermaket | *ASDA STORES * | *POS* | 2011-08-08 00:00:00 | POS | '2679 07AUG11 , LIDL UK , COVENTRY GB | -8.99 | 1409.8 | 'Main | '600849-68034660
 |  |  |  | Natwest Credit Card |  |  |  |  |  |  |  | Income |  |  | Asda Petrol | *ASDA *PETROL* | *POS* | 2011-08-08 00:00:00 | POS | '2679 07AUG11 , WM MORRISON 069 , COVENTRY GB | -16.09 | 1393.71 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  | Sub total |  |  | Asda Backie | *ASDA BACCIE* | *POS* | 2011-08-08 00:00:00 | S/O | RENT, FP 08/08/11 30 , 313451234617824913000N | -795 | 998.71 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  | Outgoings |  |  | B AND M BARGAINS | *B AND M BARGAINS* | *POS* | 2011-08-12 00:00:00 | CHG | 22JUL A/C [PHONE] | -12.95 | 985.76 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  | SubTotal: |  |  |  |  |  | B&Q | *B AND Q * | *POS* | 2011-08-12 00:00:00 | POS | '2679 11AUG11 , ASDA STORES 4602 , COVENTRY GB | -5.3 | 980.46 | 'Main | '600849-68034660
 | TOTAL: |  |  | TOTAL: |  |  | SubTotal: |  | TOTAL: |  |  | Current Balance |  |  | Boots | *BOOTS* | *POS* | 2011-08-15 00:00:00 | BAC | Income 4 | 182.3 | 1162.76 | 'Main | '600849-68034660
 |  |  |  | Average Monthly Bills |  |  |  |  |  |  |  | Projected Available |  |  | Car MOT and Servicing | *TMS * | *POS* | 2011-08-15 00:00:00 | POS | '2679 12AUG11 , ADSA STORES LTD , 4231 , COVENTRY GB | -5.1 | 1157.66 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Currys | *CURRYS* | *POS* | 2011-08-15 00:00:00 | POS | '2679 12AUG11 , ADSA STORES LTD , 4231 , COVENTRY GB , CASH BACK 20.00 | -29.85 | 1127.81 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FORCES REUNITED | *FORCES REUNITED * | *POS* | 2011-08-15 00:00:00 | POS | '2679 14AUG11 , TESCO UPT 4097 , COVENTRY GB | -30.03 | 1097.78 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dominos Pizza | *DOMINOS.CO.UK* | *POS* | 2011-08-15 00:00:00 | C/L | 'OMNICASH 14AUG, CHARGE 1.50 | -31.5 | 1066.28 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  | 2011-08-14 00:00:00 |  |  |  |  |  | Game | *GAME* | *POS* | 2011-08-16 00:00:00 | BAC | Income 1 | 114.8 | 1181.08 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hks Bury Hill Brum, Petrol | *HKS BURY HILL , [NAME]* | *POS* | 2011-08-17 00:00:00 | DPC | Other Income | 200 | 1381.08 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ikea | *IKEA* | *POS* | 2011-08-18 00:00:00 | POS | '2679 17AUG11 , ADSA STORES LTD , 4231 , COVENTRY GB , CASH BACK 20.00 | -89.58 | 1291.5 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Johal | *JOHAL SUPERMARKET* | *POS* | 2011-08-18 00:00:00 | POS | '2679 17AUG11 , ADSA STORES LTD , 4231 , COVENTRY GB | -14.09 | 1277.41 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LIDL UK | *LIDL UK* | *POS* | 2011-08-18 00:00:00 | POS | '2679 17AUG11 , PAPA JOHNS , COVENTRY GB | -16.77 | 1260.64 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lloyds Parmacy | *LLOYDS PHARMACY* | *POS* | 2011-08-22 00:00:00 | POS | 2679 19AUG11 , WWW.DOMINOS.CO.UK ,  GB | -13 | 1247.64 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | *WM MORRISON * | *POS* | 2011-08-22 00:00:00 | POS | '2679 20AUG11 , B AND M BARGAINS , COVENTRY GB | -25.4 | 1222.24 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | *WM MORRISONS ,* | *POS* | 2011-08-22 00:00:00 | POS | '2679 21AUG11 , LIDL UK , COVENTRY GB | -144.93 | 1077.31 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Morrisons Petrol / Gas | *MORRISONS PETROL ,* | *POS* | 2011-08-22 00:00:00 | POS | '2679 18AUG11 , WWW.SEVERNT , RENT.CO.UK , B'HAM [NAME] | -27.23 | 1050.08 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | *POS* | 2011-08-22 00:00:00 | C/L | 'COVENTRY 22AUG | -20 | 1030.08 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | *W M MORRISONS CAFE,* | *POS* | 2011-08-23 00:00:00 | BAC | Income 3 | 402.8 | 1432.88 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Netto | *NETTO* | *POS* | 2011-08-25 00:00:00 | POS | '2679 24AUG11 , ROYAL AND SUNALLIANCE , LIVERPOOL GB | -67.95 | 1364.93 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAPA JOHNS | *PAPA JOHNS* | *POS* | 2011-08-25 00:00:00 | POS | '2679 24AUG11 , SAINSBURY'S S/MKT , CT HOUSE GRN GB , CASH BACK 20.00 | -57.97 | 1306.96 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PDSA PETAID | *PDSA PETAID* | *POS* | 2011-08-25 00:00:00 | POS | '2679 24AUG11 , SAINSBURY'S S/MKT , CT HOUSE GRN GB , CASH BACK 20.00 | -34.19 | 1272.77 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Poundland | *POUNDLAND LTD * | *POS* | 2011-08-25 00:00:00 | POS | '2679 24AUG11 , THE RANGE , COVENTRY GB | -13.49 | 1259.28 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | *MURCO SERVICE STAT* | *POS* | 2011-08-26 00:00:00 | BAC | INCOME 4 | 182.3 | 1441.58 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POUNDWORLD 124 | *POUNDWORLD 124* | *POS* | 2011-08-30 00:00:00 | BAC | Income 1 | 114.8 | 1556.38 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PIZZA HUT | *PIZZA HUT* | *POS* | 2011-08-30 00:00:00 | POS | 2679 29AUG11 , FORCES REUNITED , GRP , MELKSHAM GB | -9.99 | 1546.39 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sainsburys Store | *SAINSBURY'S S/MKT* | *POS* | 2011-08-30 00:00:00 | POS | '2679 29AUG11 , ADSA STORES LTD , 4231 , COVENTRY GB | -13.98 | 1532.41 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sainsburys Petrol | *SAINSBURYS PETROL* | *POS* | 2011-08-30 00:00:00 | POS | '2679 27AUG11 , WM MORRISON 069 , COVENTRY GB | -12.72 | 1519.69 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sainsburys Baccie | *SAINSBURY'S BACCIE* | *POS* | 2011-08-30 00:00:00 | C/L | 'LLOYDS BANK 27AUG | -20 | 1499.69 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | *SERIF* | *POS* | 2011-08-30 00:00:00 | C/L | 'ROYAL BANK 30AUG | -20 | 1479.69 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Settlers Software | *22APR11 , DRI*UBISOFT STO* | *POS* | 2011-08-30 00:00:00 | D/D | [NAME] | -45.42 | 1434.27 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Showcase Cinems | *Showcase Cinemas* | *POS* | 2011-08-31 00:00:00 | POS | '2679 30AUG11 , TESCO STORES 5168 , COVENTRY GB | -20 | 1414.27 | 'Main | '600849-68034660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | *TESCO STORE* | *POS*
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tesco Petrol | *TESCO UPT* | *POS*
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tesco Baccie | *TESCO BACCIE* | *POS*
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | THE RANGE | *THE RANGE* | *POS*
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | *M6 TOLL* | *POS*
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wilkinsons | *WILKINSON* | *POS*
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BILLS |  | D/D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Volvo Insurance | *ROYAL AND SUNALLIANCE* | D/D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Television Licence | *TV LICENCE MBP* | D/D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E.ON ENERGY | *E.ON ENERGY* | D/D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scottish Power Electricity | *SCOTTISH POWER * | D/D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scottish Power Gas | *WWW.SCOTTIS* | D/D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PayPal Payments | *PAYPAL INC* | D/D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BT Phone/Broadband | *BT GROUP PLC* | D/D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sky |  | D/D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Water | *WWW.SEVERNT * | D/D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Severn Trent Water | *SEVERN TRENT WATER* | D/D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HOMESERVE INSURANCE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rent | *RENT*
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bank Charges | *A/C [PHONE]* | *POS*
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BT Credit Card Payments | *MBNA EUROPE CS /*
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NatWest CC Payments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile Phones
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cash Outgoings
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ATM | *COVENTRY * | C/L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | To Me | *CALL REF.NO. * TO A/C 68123419* | DPC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RBS | *ROYAL BANK* | C/L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | From NatWest Bank | *[PHONE]  08APR 1516* | B/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shop Cash Machine | *OMNICASH* | C/L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Paypoint Cash Machine | *PAYPOINT* | C/L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | To Theh EX | *CALL REF.NO. 0889 , Other* | DPC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | To Pay Rent |  | DPC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LLOYDS HITW | *LLOYDS* | C/L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sainsburys Cash | *SAINSBURYS 26APR* | C/L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BW = Bank Withdrawal