Spreadsheet: 541634d1507451950-grouping-transactions-from-bank-account-anz-2016-09-09_2017-10-08-etaf
Sheet: Sheet1

 | Column Labels
 |  | 000000000000Cheque 100121 | 000000000000Cheque 100122 | 000000000000Cheque 100124 | 000000000000Cheque 100125 | 000000000000Cheque 100130 | 000000000000Cheque 100131 | 4055-****-****-7277 | 6155   CA2Z Technologies Ltd | 6155   CAltezano Queen Stree | 6155   CAvondale Food Market | 6155   CAvondale Primary Sch | 6155   CBarkers | 6155   [NAME] | 6155   CBetter Burger Vulcan | 6155   CBp Connect Junction | 6155   CCivic Car Park | 6155   CDelta Coffee | 6155   CEyewear Direct | 6155   CFactory Frames | 6155   CFarro Fresh [NAME] | 6155   [NAME] | 6155   CFruitworld Mt Roskil | 6155   CGreenwoods Aquatic | 6155   CGrey [NAME] | 6155   CHalal Meat And Spice | 6155   [NAME] | 6155   CHorizon Laundromat | 6155   CJ&Y Newstep Limited | 6155   CJc Dairy Shop Limite | 6155   CLife Pharmacy Wilkin | 6155   [NAME] | 6155   CMitre 10 Mega New Ly | 6155   [NAME] Physiothera | 6155   CNew World New Lynn | 6155   CPt [NAME] | 6155   CPt [NAME] | 6155   CQuandahari Bazaar | 6155   [NAME] | 6155   [NAME] | 6155   CSkycity The Federal | 6155   [NAME] | 6155   CSt Pierres [NAME] | 6155   CThe Punters Dairy | 6155   CThe Thirsty Dog | 6155   CThornton'S Pharmacy | 6155   [NAME] | 6155   CToyworld [NAME] | 6155   CVictoria Street Car | 6155   CWaitakere Gymnastic | 6155   CWl New Lynn Central | 6155   CXpress Mart K Road | 6155Visa Debit Card Fee | 6915   CAri Auckland Ltd | 6915   CAvondle Easy Laundro | 6915   CBallantynes | 6915   CBebabo | 6915   CBff Adventureland & | 6915   [NAME] | 6915   CCaltex [NAME] | 6915   CCaltex Western Sprin | 6915   CCatroux | 6915   CColumbus Cafe Takapu | 6915   CCotton On Kids 9223 | 6915   [NAME] | 6915   [NAME] | 6915   [NAME] | 6915   [NAME] | 6915   [NAME] | 6915   CFarmers   Lynmall | 6915   CFarmers   St Lukes | 6915   CFarmers - St Lukes | 6915   CFarmers - Takapuna | 6915   CFarro Fresh [NAME] | 6915   CGrey Lynn Butchers | 6915   CGrey [NAME] | 6915   CHauraki Corner Cella | 6915   CHorizon Laundromat | 6915   CJust Cuts St Lukes | 6915   CKyoto | 6915   CLes Mills World Of F | 6915   CLife Pharmacy Orewa | 6915   CLife Pharmacy St Luk | 6915   CLong Room | 6915   CLook Sharp Store | 6915   CLotsa Goodies Sc | 6915   [NAME] | 6915   CLynnmall Pharmacy | 6915   CMassey Pharmacy | 6915   CMerchant Liquor | 6915   CNew World Ilam | 6915   CNew World New Lynn | 6915   CNew World Wakatipu | 6915   CNew Zealand Dryclean | 6915   CNz Pest Control | 6915   [NAME] | 6915   [NAME] | 6915   CPt Chevalier Post Sh | 6915   [NAME] | 6915   CRocket Superette | 6915   CSelwyn Village Cafe | 6915   CShaky Isles | 6915   CStirling Sports Taka | 6915   CTexan Art Schools | 6915   CThe Womens Bookshop | 6915   CWaitakere Gymnastic | 6915   CWalker & Hall St Luk | 6915   CWhitcoulls 096 | 6915   CWhitcoulls 100 | 6915   CWoodworks | 6915Visa Debit Card Fee | A I Bates & Associat | Airpoints [NAME] | [NAME] | Asb [NAME] Asb Paihia B | At Hop Auckl4835-****-****-6155  Df | Auckland Council | [NAME] | Avon Studios | AvondaleAnz  S3B1334 Avondale | Bakers Delig4835-****-****-6155  Nf | Barfoot & Thompson | [NAME] | [NAME] Bnz Ohakune | Bp Connect J4835-****-****-6155  Nf | Bp Connect R4835-****-****-6155  Nf | Brothers Bre4835-****-****-6155  Df | Burger King4835-****-****-6155  Nf | C/Down Pt ChWbc  W1Ar164 C/Down Pt Ch | Cheque 100120 | Cheque 100123 | Cheque 100126 | Cheque 100127 | Cheque 100128 | Cheque 100129 | Church Night4835-****-****-6155  Nf | [NAME] | Countdown4835-****-****-6155  Nf | [NAME]If | Direct Rentals | Eagle Painting | EAnzgle0103649455 | Farmers 12294835-****-****-6155  Nf | Four Square4835-****-****-6155  Df | Fruit World4835-****-****-6155  Nf | Go | Gorman4835-****-****-6915  If | [NAME]  S3A1252 Grey Lynn Br | Hub Convenie4835-****-****-6155  Df | Jac & Jack P4835-****-****-6915  If | Jones The Gr4835-****-****-6155  Df | Kokako4835-****-****-6155  Df | [NAME] | Mint Homes Ltd | Monthly A/C Fee | Nat Pk Servi4835-****-****-6155  Df | New World Ne4835-****-****-6155  Df | Newton PsKwbk Kb8105 Newton Ps | Nikhil Himal4835-****-****-6155  Nf | Okawa Rotoiti Timesh | Pak N Save [NAME] | Pt [NAME] | [NAME] B | [NAME] | Queenstown P4835-****-****-6155  Df | Rainbows End4835-****-****-6155  [NAME] | [NAME] | [NAME] | Savings | School | [NAME] | Stellar Projects | Taylored Studios | The Bach4835-****-****-6155  Nf | The Bottleo4835-****-****-6155  Nf | To: [PHONE] | To: [PHONE] | To: [PHONE] | To: [PHONE] | Total Home Tech | Transfer4055-****-****-7277 | Turkish4835-****-****-6155  Nf | Unichem Grey4835-****-****-6155  Nf | [NAME] L4835-****-****-6155  Df | Waiwera Ther4835-****-****-6155  Df | Wh Smith Syd4835-****-****-6915  If | Z [NAME] | (blank) | Grand Total
Sum of Amount | -4020.5 | -99 | -81 | -99 | -36 | -57 | -27 | -1090 | -7245 | -17.4 | -16 | -6 | -50 | -13.2 | -15 | -21 | -4 | -19 | -150 | -54 | -108.74 | -79 | -88.02 | -357.8 | -141.09 | -51.23999999999999 | -5 | -16.7 | -12 | -22 | -30.98 | -8.8 | -87.15 | -25 | -79.08 | -13.99 | -25.6 | -25.85 | -57.7 | -23 | -144.75 | -17.2 | -9 | -14.2 | -63.5 | -19.99 | -60.8 | -19.99 | -6 | -141 | -40.48 | -6.48 | -10 | -195 | -15.5 | -389 | -297.5 | -25.5 | -17.25 | -46.63 | -53.9 | -24 | -12.2 | -29.95 | -535.3499999999999 | -178.55 | -63.45 | -304.61 | -3 | -107.93 | -24.98 | -60.16 | -65.94 | -127.51 | -32.59 | -15 | -35.99 | -14.2 | -21 | -6.3 | -130 | -51.98 | -42.98 | -12 | -63.5 | -4.9 | -23.4 | -28.6 | -17.99 | -26.98 | -77.11 | -18420.85 | -139.33 | -67 | -180 | -69 | -9.7 | -61.33 | -17.4 | -5.7 | -12.2 | -26 | -99.99 | -37 | -15.55 | -136 | -39 | -139.17 | -33.45 | -22 | -10 | -287.5 | -10550 | -320 | -200 | -14 | -2084.31 | -519.73 | -45 | -20 | -13.5 | -1797 | -18 | -100 | -21.94 | -28.46 | -4.5 | -3.8 | -60 | -50 | -530 | -71 | -35 | -7 | -100 | -38.9 | -4 | -20.28 | -565.7900000000001 | -358.01 | -10000 | -100 | -9.59 | -7.99 | -617.0500000000001 | -10600 | -477.48 | -400 | -35.96 | -240.38 | -3.5 | -88 | -47.5 | -1545 | -162.5 | -11.39 | -453.77 | -40 | -49.95999999999999 | -820 | -56.24 | -37.59 | -100 | -145 | -20 | -6 | -14000 | -1375 | -50 | -27.5 | -284.14 | -3415.5 | -1466.25 | -10 | -46.99 | -7102.020000000002 | -187764.1199999999 | -721866.08 | -452804.42 | -4200 | -37794.61 | -15.5 | -15.99 | -47 | -2 | -22.13 | -25.6 |  | -1513932.8