working through ledger scripts

3 files changed, 631 insertions, 0 deletions

diff --git a/ledgerscripts/apply_categories.pl b/ledgerscripts/apply_categories.pl
new file mode 100644
index 0000000..94bb913
--- /dev/null
+++ b/ledgerscripts/apply_categories.pl
@@ -0,0 +1,30 @@
+#!/usr/bin/env perl
+
+use warnings;
+use strict;
+
+
+open (my $cat_file, "<", "expense_categories") or die 
+    "Can't open expense_categories file";
+
+my %categories;
+
+while (local $_ = <$cat_file>) {
+    if (/(.*)@(.*)/) {
+        $categories{$1} = $2;
+    }
+}
+close $cat_file;
+
+local $/ = ""; # switch to paragraph mode
+
+while (my $block = <>) {
+    if ($block =~ m/\d{4}.*\* (.*)\n.*(Expenses:.*)£/s) {
+        while (my ($k, $v) = each %categories) {
+            if ($k eq $1) {
+                $block =~ s/$2/Expenses:$v/;
+            };     
+        }
+        print $block;
+    };
+}
diff --git a/ledgerscripts/expense_categories b/ledgerscripts/expense_categories
new file mode 100644
index 0000000..39835be
--- /dev/null
+++ b/ledgerscripts/expense_categories
@@ -0,0 +1,597 @@
+PNET1056659-3 DD@Internet:Broadband                         
+ROYAL LONDON DD@Insurance:Life Assurance                   
+SANTANDER MORTGAGE DD@Mortgage                                  
+SCOTTISHPOWER DD@Utilities:Electricity & Gas               
+NCC - RECEIPTS ACC DD@Council Tax                              
+TV LICENCE MBP DD@TV Licence                                 
+ZURICH INSURANCE DD@Insurance:Home                             
+4424 TWEEDMOUTH )))@Food:Groceries                          
+NORTHUMBRIAN WATER DD@Utilities:Water                          
+HARVEY W LEMON CTF PP382029B SO@Child:Harvey:Child Trust Fund                          
+SECUREPAY.MBNA.CO. CHESTER VIS@SCHOOLGATEWA*BERWI BERWICK UPON VIS@Food:School Lunches                       
+ARDMOOR LTD NORTH BERWICK VIS@Clothing                                 
+ASDA PETROL£UPT442 TWEEDMOUTH VIS@Car:Petrol                          
+TESCO STORES 6181 BERWICK VIS@Food:Groceries                             
+Amazon.co.uk*KW7BB AMAZON.CO.UK VIS@Household:Goods                             
+Amazon Prime*NV5OR amzn.co.uk/pm VIS@Household:Goods                             
+SPOTIFY LONDON VIS@Internet:Streaming:Spotify                          
+INT'L 0011478366 DIGITALOCEAN.COM SURREY USD 45.24 @ 1.3464  Visa Rate VIS@Internet:Servers                           
+Non£Sterling Transaction Fee DR@Fees                                        
+INT'L 0011493627 ETSY ETSY.COM VIS@Household:Goods                             
+SCHOOLGRID LTD DD@Food:School Lunches                        
+SCHOOLGRID LTD DD@Food:School Lunches                        
+B&M 013 £ BERWICK BERWICK£UPON£ )))@Household:Goods                             
+Amazon.co.uk*O654V AMAZON.CO.UK VIS@Household:Goods                             
+POST OFFICE COUNTE BERWICK£UPON£ )))@Postage                                    
+LONDIS HIGH FIELD BERWICK£UPON£ )))@Postage                                     
+PLUSNET PLC PAY AC DD@Communication:Mobile                        
+CARD FACTORY BERWICK )))@Gifts                                       
+WH SMITH BERWICK£O£TWE )))@Household:Goods                            
+CASTLEGATE PHARMAC BERWICK£UPON£ )))@Prescription                                
+SAVERS HEALTH & BE BERWICK£UPON£ )))@Pharmaceuticals                            
+ICELAND BERWICK )))@Food:Groceries                              
+HOME BARGAINS BERW BERWICK )))@Household:Goods                             
+PAYPAL *JACKSONSAR 35314369001 VIS@Courses                          
+PLUSNET PLC PAY AC DD@Communication:Mobile                        
+WM MORRISONS STORE BERWICK UT VIS@Food:Groceries                            
+BLYTH SPORTS CENTR BLYTH NE24 VIS@Days Out:Swimming                           
+THE SWAN CENTRE BERWICK )))@Days Out:Swimming                           
+4424 TWEEDMOUTH )))@Food:Groceries                              
+C S ADDISON BERWICK£UPON£ )))@Food:Takeaway                             
+INT'L 0045543115 DOMESTIKA INC 4159940789 USD 36.48 @ 1.3486  Visa Rate VIS@Learning:Course                            
+Non£Sterling Transaction Fee DR@Fees                                        
+AMZNMktplace amazon.co.uk VIS@Household:Goods                           
+STITCH N TIME BERWICK£UPON£ )))@Household:Repairs                          
+INT'L 0068336439 DOMESTIKA INC 4159940789 USD 20.23 @ 1.3531  Visa Rate VIS@Courses                          
+Non£Sterling Transaction Fee DR@Fees                           
+ZURICH INSURANCE DD@Car:Insurance                          
+ROYAL MAIL GROUP L CHESTERFIELD VIS@Postage                           
+AMZNFreeTime 353£12477661 VIS@Household:Goods                           
+NETFLIX.COM 18665797172 VIS@Internet:Streaming:Netflix                           
+HMRC SELF AS SHIP 6522646472K OBP@Joanna:Tax:National Insurance                          
+AMZ*Amazon.co.uk AMAZON.CO.UK VIS@Household:Goods                            
+AMZNMktplace amazon.co.uk VIS@Household:Goods                          
+NEXT DIRECTORY ONLINE VIS@Clothing                          
+MARKS&SPENCER PLC INTERNET VIS@Clothing                          
+TESCO STORES 6181 BERWICK VIS@Food:Groceries                          
+OLD SCHOOL BE CONON BRIDGE VIS@Clothing                         
+MARKS&SPENCER PLC BERWICK UPON )))@Food:Groceries                          
+NIIB T/A NORTHRIDG DD@Car:Repayment                         
+Amazon.co.uk*CD3F7 AMAZON.CO.UK VIS@Household:Goods                          
+INT'L 0015820398 BANDCAMP HYPERDUB 402£935£7733 VIS@Internet:Music                           
+NATIONAL LOTTERY I WATFORD VIS@Lottery                           
+SAVERS HEALTH & BE BERWICK£UPON£ VIS@Household:Goods                          
+WH SMITH BERWICK£O£TWE VIS@Household:Goods                          
+CARD FACTORY BERWICK )))@Gifts                           
+FAMILY EQUITY PLAN DD@Child:Sophie:Junior ISA                          
+THE MALTINGS BERWI BERWICK UPON )))@Food:Restaurant                          
+TESCO STORES 6181 BERWICK VIS@Food:Groceries                          
+AMZNMktplace amazon.co.uk VIS@Gifts                          
+THE CROSS INN LTD BERWICK£UPON£ )))@Food:Restaurant                         
+TESCO STORES 6181 BERWICK )))@Food:Groceries                          
+Non£Sterling Transaction Fee DR@Fees                           
+AMZNMktplace amazon.co.uk VIS - mortar and pestle@Household:Goods                          
+JACKSONSART.COM NE LONDON VIS@Joanna:Art Materials                          
+BLACKWELL S EDINBURGH )))@Books                          
+STARBUCKS EDINBURG EDINBURGH )))@Food:Cafe                          
+PIZZA EXPRESS EDINBURGH 185 )))@Food:Restaurant                          
+Q PARK OMNI EDINBURGH )))@Car:Parking                           
+HOME BARGAINS BERW BERWICK )))@Household:Goods                           
+SAVERS HEALTH & BE BERWICK£UPON£ )))@Household:Goods                           
+CARD FACTORY BERWICK )))@Gifts                           
+PNET1056659£3 DD@Internet:Broadband                          
+AMZNMktplace amazon.co.uk VIS@Computer:Hardware                           
+WM MORRISONS STORE BERWICK UT )))@Food:Groceries                          
+WM MORRISONS STORE BERWICK UT )))@Food:Groceries                           
+WM MORRISONS STORE BERWICK UT )))@Food:Groceries                          
+WM MORRISONS STORE BERWICK UT )))@Food:Groceries                           
+SCHOOLGRID LTD DD@Food:School Lunches                          
+ROYAL LONDON DD@Insurance:Life Assurance                          
+SANTANDER MORTGAGE DD@Mortgage                        
+SCOTTISHPOWER DD@Utilities:Electricity & Gas                        
+NCC £ RECEIPTS ACC DD@Council Tax                         
+TV LICENCE MBP DD@TV Licence                          
+NORTHUMBRIAN WATER DD@Utilities:Water                          
+AMZNMktplace amazon.co.uk VIS@Household:Goods                           
+PLUSNET PLC PAY AC DD@Communication:Mobile                           
+HARVEY W LEMON CTF PP382029B SO@Harvey:Child Trust Fund                          
+INT'L 0098332607 DIGITALOCEAN.COM SURREY USD 45.24 @ 1.3428  Visa Rate VIS@Internet:Servers                          
+Non£Sterling Transaction Fee DR@Fees                           
+INT'L 0098347285 ETSY ETSY.COM VIS@Household:Goods                           
+Amazon Prime*FT5DX amzn.co.uk/pm VIS@Household:Goods                           
+ZURICH INSURANCE DD@Insurance:Home                          
+SPOTIFY LONDON VIS@Internet:Streaming:Spotify                          
+PLUSNET PLC PAY AC DD@Communication:Mobile                           
+THE WORKS BERWICK UPON )))@Household:Goods                          
+WM MORRISONS STORE BERWICK UT )))@Food:Groceries                          
+SAVERS HEALTH & BE BERWICK£UPON£ )))@Pharmaceuticals                          
+HOME BARGAINS BERW BERWICK )))@Household:Goods                           
+WM MORRISONS STORE BERWICK UT VIS@Food:Groceries                          
+ROBERTSONS (BERWIC BERWICK£UPON£ )))@Gifts                          
+CARD FACTORY BERWICK )))@Gifts                           
+SAVERS HEALTH & BE BERWICK£UPON£ )))@Pharmaceuticals                           
+COSTA COFFEE 43037 BERWICK£UPON£ )))@Food:Cafe                          
+WH SMITH BERWICK£O£TWE )))@Household:Stationery                           
+PLUSNET PLC PAY AC DD@Communication:Mobile                           
+GOOGLE *Google Pla g.co/helppay# VIS@Computer:Software                          
+CANNON FISH RESTAU 01289331480 )))@Food:Restaurant                 
+NORTHUMBERLAND CC MORPETH VIS@Household:Garden:Refuse                          
+SECUREPAY.MBNA.CO. CHESTER VIS@WM MORRISONS STORE BERWICK UT )))@Household:Goods                           
+WM MORRISONS STORE BERWICK UT )))@Food:Groceries                          
+INT'L 0056350183 Etsy.com £ Damlaro Dublin VIS@Gifts                          
+INT'L 0056350184 Evernote Zurich VIS@Computer:Software                          
+ZURICH INSURANCE DD@Car:Insurance                          
+ASDA PETROL£UPT442 TWEEDMOUTH VIS@Car:Petrol                          
+NETFLIX.COM 18665797172 VIS@Internet:Streaming:Netflix                           
+MCDONALDS DUNBAR 1478 )))@Food:Takeaway                           
+4424 TWEEDMOUTH )))@Food:Groceries                          
+AMZNFreeTime 353£12477661 VIS@Household:Goods                           
+TESCO STORES 6181 BERWICK )))@Food:Groceries                          
+LADY LIBERTINE EDINBURGH )))@Recreation:Pub                           
+LADY LIBERTINE EDINBURGH )))@Recreation:Pub                           
+200016 CHQ@School:Trips                         
+NORTHUMBERLAND CC MORPETH VIS@Car:Parking                          
+AMZNMktplace amazon.co.uk VIS@Household:Goods                           
+TAFFYS BERWICK UPON )))@Household:Goods                           
+NIIB T/A NORTHRIDG DD@Car:Repayment                         
+MALTINGS BERWICK 01289 330999 VIS@Recreation:Cinema                          
+WM MORRISONS STORE BERWICK UT VIS@Food:Groceries                         
+BLYTH SPORTS CENTR BLYTH NE24 VIS@Recreation:Swimming                           
+ICELAND BERWICK )))@Food:Groceries                           
+BERWICK DENTAL BERWICK )))@Health:Dentist                          
+NEXT DIRECTORY ONLINE VIS@Clothing                          
+HM PASSPORT OFFICE DURHAM VIS@Travel:Travel Documents                         
+HM PASSPORT OFFICE DURHAM VIS@Travel:Travel Documents                          
+HM PASSPORT OFFICE DURHAM VIS@Travel:Travel Documents                          
+TESCO STORES 6181 BERWICK )))@Food:Groceries                          
+NEXT RETAIL LTD TWEEDMOUTH )))@Clothing                          
+MAX SPIELMANN LTD BERWICK£UPON£ )))@Travel:Travel Documents                           
+MAX SPIELMANN LTD BERWICK£UPON£ )))@Travel:Travel Documents                           
+MAX SPIELMANN LTD BERWICK£UPON£ )))@Travel:Travel Documents                           
+BRITISH BEEF JERKY MORPETH )))@Food:Cafe                           
+FAMILY EQUITY PLAN DD@Child:Sophie:Junior ISA                          
+CARD FACTORY BERWICK )))@Gifts                           
+SAVERS HEALTH & BE BERWICK£UPON£ )))@Pharmaceuticals                          
+Amazon.co.uk*2R1UW AMAZON.CO.UK VIS@Household:Goods                          
+B&M 013 £ BERWICK BERWICK£UPON£ )))@Household:Goods                           
+INTERFLORA BRITISH SLEAFORD VIS@Gifts                          
+MARKS&SPENCER PLC BERWICK UPON )))@Food:Groceries                          
+ROYAL MAIL GROUP L CHESTERFIELD VIS@Postage                           
+JUMP 360 NEWCASTLE SEAHAM )))@Days Out                           
+DOBBIES NORTHUMBERLAN )))@Food:Groceries                          
+JUMP 360 NEWCASTLE SEAHAM )))@Food:Cafe                           
+CASTLEGATE PHARMAC BERWICK£UPON£ )))@Pharmaceuticals                           
+TESCO STORES 6181 BERWICK )))@Food:Groceries                          
+WM MORRISONS STORE BERWICK UT )))@Food:Groceries                          
+SCHOOLGRID LTD DD@Food:School Lunches                          
+SCHOOLGRID LTD DD@Food:School Lunches                          
+ROYAL LONDON DD@Insurance:Life Assurance                          
+SANTANDER MORTGAGE DD@Mortgage                         
+SCOTTISHPOWER DD@Utilities:Electricity & Gas                         
+NCC £ RECEIPTS ACC DD@Council Tax                         
+TV LICENCE MBP DD@TV Licence                          
+INT'L 0074110201 DIGITALOCEAN.COM SURREY USD 45.24 @ 1.3301  Visa Rate VIS@Internet:Servers                          
+Non£Sterling Transaction Fee DR@Fees                           
+PNET1056659£3 DD@Internet:Broadband                          
+HARVEY W LEMON CTF PP382029B SO@Harvey:Child Trust Fund                          
+INT'L 0081147394 ETSY ETSY.COM VIS@Fees                           
+ETRmytrip_uk_LIFOA ONLINE VIS@Travel:Air Tickets                         
+Amazon Prime*2R8TX amzn.co.uk/pm VIS@Household:Goods                           
+PLUSNET PLC PAY AC DD@Communication:Mobile                           
+ZURICH INSURANCE DD@Insurance:Home                          
+SPOTIFY LONDON VIS@Internet:Streaming:Spotify                          
+WM MORRISONS STORE BERWICK UT )))@Food:Groceries                          
+NEXT DIRECTORY ONLINE VIS@Clothing                          
+DIRECT PETS BERWICK UPON )))@Household:Goods                          
+EBBCARRS CAFE EYEMOUTH )))@Food:Cafe                          
+WM MORRISONS STORE BERWICK UT )))@Food:Groceries                          
+INT'L 0021606756 RYANAIR  @Fees                           
+Non£Sterling Transaction Fee DR@ANIMAL FRIENDS INS FIRST PAYMENT DD@Insurance:Cat                           
+ROBERTSONS (BERWIC BERWICK£UPON£ )))@Clothing                          
+CARD FACTORY BERWICK )))@Gifts                           
+SAVERS HEALTH & BE BERWICK£UPON£ )))@Pharmaceuticals                           
+CARD FACTORY BERWICK )))@Gifts                          
+ICELAND BERWICK )))@Food:Groceries                           
+HOME BARGAINS BERW BERWICK )))@Household:Goods                          
+THE WORKS BERWICK UPON )))@Gifts                           
+PLUSNET PLC PAY AC DD@Communication:Mobile                           
+CAFFE NERO 304 BER BERWICK UPON )))@Food:Cafe                           
+MARITIMO LOUNGE SOUTHAMPTON )))@Recreation:Pub                           
+MARITIMO LOUNGE SOUTHAMPTON )))@Recreation:Pub                           
+PLUSNET PLC PAY AC DD@Communication:Mobile                           
+AMZNMktplace amazon.co.uk VIS@Household:Goods                           
+ZURICH INSURANCE DD@Car:Insurance                          
+IZ *ASHLEIGH AFFLE AYTON )))@Joanna:Hair                          
+TESCO PAY AT PUMP BERWICK VIS@Car:Petrol                          
+NETFLIX.COM 18665797172 VIS@Internet:Streaming:Netflix                           
+AMZNFreeTime 353£12477661 VIS@Household:Goods                           
+TESCO STORES 6181 BERWICK )))@Food:Groceries                          
+WM MORRISONS STORE BERWICK UT )))@Food:Groceries                          
+INT'L 0048178349 TALK PYTHON TRAINI PDXWEBPROPERT USD 39.00@Learning:Course                          
+Non£Sterling Transaction Fee DR@Fees                           
+AMZNMktplace amazon.co.uk VIS@Joanna:Art Materials                          
+W M MORRISON PETRO@Car:Petrol                          
+ROYAL MAIL GROUP L CHESTERFIELD VIS@Postage                          
+CARD FACTORY BERWICK )))@Gifts                           
+HOME BARGAINS BERW BERWICK )))@Household:Goods                          
+NIIB T/A NORTHRIDG DD@Car:Repayment                         
+AMZNMktplace amazon.co.uk VIS@Household:Goods                           
+SECUREPAY.MBNA.CO. CHESTER VIS@TESCO STORES 6181 BERWICK VIS@Food:Groceries                 
+ROYAL MAIL GROUP L CHESTERFIELD VIS@Postage                           
+DVLA DRIVER ONLINE SWANSEA VIS@Car:DVLA                          
+DEYN S DELI BERWICK£UPON£ )))@Food:Restaurant                    
+B&M 013 £ BERWICK BERWICK£UPON£ )))@Household:Goods                           
+FAMILY EQUITY PLAN DD@Child:Sophie:Junior ISA        
+ANIMAL FRIENDS INS DD@Insurance:Cat                  
+TESCO STORES 6181 BERWICK VIS@Food:Groceries                         
+WM MORRISONS STORE BERWICK UT )))@Food:Groceries                          
+JOHN SCOTT BAKERY KELSO TD5 )))@Food:Takeaway                          
+CANNON FISH RESTAU 01289331480 )))@Food:Takeaway                          
+4424 TWEEDMOUTH )))@Gifts                           
+SUMUP  *THE ALNWIC ALNWICK )))@Food:Takeaway                  
+WM MORRISONS STORE ALNWICK )))@Food:Groceries                           
+PNET1056659£3 DD@Internet:Broadband                          
+NEXT DIRECTORY ONLINE VIS@Clothing                          
+ICELAND BERWICK VIS@Food:Groceries                     
+Amazon.co.uk*299UZ AMAZON.CO.UK VIS@Household:Goods                           
+ICELAND BERWICK )))@Food:Groceries                          
+HOME BARGAINS BERW BERWICK )))@Household:Goods                           
+PLUSNET PLC PAY AC DD@Communication:Mobile               
+SCHOOLGRID LTD DD@Food:School Lunches            
+SCHOOLGRID LTD DD@Food:School Lunches            
+ROYAL LONDON DD@Insurance:Life Assurance       
+SANTANDER MORTGAGE DD@Mortgage                         
+SCOTTISHPOWER DD@Utilities:Electricity & Gas    
+NCC £ RECEIPTS ACC DD@Council Tax                         
+TV LICENCE MBP DD@TV Licence                          
+ZURICH INSURANCE DD@Insurance:Home                    
+HARVEY W LEMON CTF PP382029B SO@Harvey:Child Trust Fund           
+MARKS&SPENCER PLC INTERNET VIS@Food:Groceries                          
+WWW.HXPAYMENTS.COM HYTHE VIS@Car:Parking                       
+AMZNMktplace amazon.co.uk VIS@Household:Goods                   
+Amazon Prime*299RX amzn.co.uk/pm VIS@Household:Goods                           
+SPOTIFY LONDON VIS@Internet:Streaming:Spotify       
+WM MORRISONS STORE BERWICK UT )))@Food:Groceries                          
+ALDI 22 777 BERWICK UPON )))@Food:Groceries                          
+4424 TWEEDMOUTH )))@Food:Groceries                           
+INT'L 0090716483 DIGITALOCEAN.COM SURREY USD 43.84 @ 1.3082  Visa Rate VIS@Internet:Servers                          
+Non£Sterling Transaction Fee DR@Fees                           
+INT'L 0090732960 ETSY ETSY.COM VIS@Household:Goods                           
+AMZN Digital*29922 353£12477661 VIS@Books                           
+MARKS&SPENCER PLC BERWICK UPON )))@Food:Groceries                           
+MALTINGS BERWICK 01289 330999 VIS@Recreation:Theatre                          
+PLUSNET PLC PAY AC DD@Communication:Mobile                           
+SAVERS HEALTH & BE BERWICK£UPON£ )))@Household:Goods                           
+CARD FACTORY BERWICK )))@Gifts                           
+THE MALTINGS BERWI BERWICK UPON )))@Food:Restaurant          
+HOME BARGAINS BERW BERWICK )))@Household:Goods                           
+SAVERS HEALTH & BE BERWICK£UPON£ )))@Household:Goods                           
+PLUSNET PLC PAY AC DD@Communication:Mobile                           
+CARD FACTORY BERWICK )))@Gifts                          
+HOME BARGAINS BERW BERWICK )))@Household:Goods                           
+WM MORRISONS STORE BERWICK UT )))@Food:Groceries                          
+W M MORRISON PETRO BERWICK UPON )))@Car:Petrol                          
+J D WETHERSPOON PL WATFORD VIS@Food:Restaurant                          
+INT'L 0052581930 TESCO STORES 3560 ROSCOMMON EUR 5.79 @ 1.1962  Visa Rate )))@Food:Groceries                           
+Non£Sterling Transaction Fee DR@Fees                           
+INT'L 0052581931 LIDL IRELAND LTD BALLINA EUR 19.78 @ 1.1958  Visa Rate )))@Food:Groceries                          
+Non£Sterling Transaction Fee DR@Fees                           
+INT'L 0038193561 RYANAIR     U7YJGI PAYPAL COM VIS@Travel:Air Tickets                           
+INT'L 0038193562 RYANAIR     ZIEM6R PAYPAL COM VIS@Travel:Air Tickets                           
+INT'L 0059209427 Cormican School & Roscommon EUR 5.99 @ 1.1956  Visa Rate )))@Joanna:Art Materials                           
+Non£Sterling Transaction Fee DR@Fees                           
+INT'L 0059209426 STEAM PURCHASE SEATTLE VIS@Gifts                          
+ZURICH INSURANCE DD@Car:Insurance                          
+NETFLIX.COM 18665797172 VIS@Internet:Streaming:Netflix                           
+SHELL NORTH ROAD BERWICK ON TW )))@Food:Groceries                           
+INT'L 0065801698 SSP IRELAND LTD DUBLIN EUR 32.45 @ 1.1921  Visa Rate )))@Food:Restaurant                          
+Non£Sterling Transaction Fee DR@Fees                           
+INT'L 0065801699 WH SMITH DUBLIN AIRPOR EUR 2.90 @ 1.1934  Visa Rate )))@Food:Groceries                           
+Non£Sterling Transaction Fee DR@Fees                           
+INT'L 0065801700 APPLEGREEN FRENCHP FRENCHPARK EUR 41.82 @ 1.1958  Visa Rate )))@Car:Petrol                          
+Non£Sterling Transaction Fee DR@Fees                           
+AMZNFreeTime 353£12477661 VIS@Household:Goods                           
+FAREWILL.COM LONDON VIS@Legal:Will                          
+WM MORRISONS STORE BERWICK UT )))@Food:Groceries                          
+ALDI 22 777 BERWICK UPON )))@Food:Groceries                          
+NIIB T/A NORTHRIDG DD@Car:Repayment                         
+TESCO STORES 6181 BERWICK )))@Food:Groceries                          
+The Homestead Cafe Coldstream )))@Food:Cafe                           
+HWLB AMZN Digital*2E8XL 353£12477661 VIS@Books                           
+Amazon.co.uk*2E0FH AMAZON.CO.UK VIS@Household:Goods                           
+IZ *THE LOOKOUT BE BERWICK ON TW )))@Food:Cafe                           
+WM MORRISONS STORE BERWICK UT )))@Food:Groceries                          
+Plusnet monthly payment@Communication:Mobile                        
+Argos - Harvey new bed@Household:Furniture                       
+Mark Clegg - Harvey bedroom@Household:Decorating                    
+Homebase@Household:Decorating                        
+Tesco weekly shop@Food:Groceries                             
+Homebase - rubble sacks@Household:Decorating                       
+Morrisons - food for lunch@Food:Groceries                             
+Plusnet mobile@Communication:Mobile                        
+Berwick Decorating Centre@Household:Decorating                       
+M&S Lunch on Friday@Food:Groceries                             
+Homebase@Household:Goods                            
+Amazon something@Household:Stationery                        
+Next Clothing (jumper?)@Clothing                                  
+Zurich insurance@Car:Insurance                              
+Foulis chippy@Food:Takeaway                             
+Nextflix@Internet:Streaming:Netflix                  
+Stitch in time sewing shop@Household:Repairs                           
+Glendale paints@Household:Decorating                      
+Card Factory@Gifts                                       
+Savers pharma@Household:Pharmaceuticals                   
+B&M stuff@Household:Goods                            
+Post Office - Leslie present@Postage                                    
+Next - Sophie dress@Clothing                                   
+Castlegate Pharmacy@Prescription                                
+Amazon something@Household:Goods                             
+Next - Jo jumper@Clothing                                  
+Royal Mail@Postage                                    
+Morrisons - food for lunch@Food:Groceries                             
+House of Illustration Jo course@Learning:Course                          
+Northridge Finance Car@Car:Repayment                             
+Asda@Food:Groceries                              
+Homebase something@Household:Goods                            
+Morrisons food@Food:Groceries                            
+Swan Centre Swimming@Days Out:Swimming                           
+Homebase polythene sheeting@Household:Goods                             
+Etsy something@Household:Goods                             
+Amazon something@Household:Goods                            
+Fastmail@Internet:Email                              
+Transaction Fee@Fees                                        
+Amazon something@Household:Goods                            
+Family Equity Plan@Child:Sophie:Junior ISA                   
+Cash and Carry Carpets@Household:Furniture                      
+Boden@Clothing                                   
+Amazon something@Household:Goods                             
+The Maltings Lunch@Food:Restaurant                            
+Royal Mail@Postage                                     
+Morrisons@Food:Groceries                            
+Pizza Express The Fort@Food:Restaurant                            
+Amazon kids stuff TBC@Household:Goods                            
+Odeon Cinemas@Recreation:Cinema                         
+C S Addison Chippy@Food:Takeaway                             
+Hobbycraft@Joanna:Art Materials                       
+Odeon food@Food:Takeaway                              
+Odeon food again@Food:Takeaway                             
+Morrisons petrol@Car:Petrol                                 
+Blyth Sports Centre Swimming@Recreation:Swimming                         
+Amazon something@Recreation:Swimming                         
+Amazon something@Household:Goods                            
+Joanna Hair-do@Joanna:Hair                                
+Savers@Household:Goods                             
+B&M something@Household:Goods                            
+Home bargains@Household:Goods                             
+Card factory@Gifts                                       
+M&S food bits@Food:Groceries                             
+Plusnet broadband@Internet:Broadband                         
+School grid@Food:School Lunches                        
+School grid@Food:School Lunches                        
+Royal London Life Assurance@Insurance:Life Assurance                   
+Santander Morgage@Mortgage                                  
+Scottish Power@Utilities:Electricity & Gas               
+Council Tax@Council Tax                               
+TV License@TV Licence                                 
+Water@Utilities:Water                            
+LNER - to Murrayfield@Travel:Rail Tickets                        
+Harvey bedside table Amazon@Household:Furniture                        
+Amrans curry@Food:Takeaway                             
+Aldi food@Food:Groceries                             
+B&M something@Household:Goods                             
+Morrisons food@Food:Groceries                             
+Home bargains@Household:Goods                             
+Plusnet mobile@Communication:Mobile                        
+Harvey Child Trust Fund@Child:Harvey:Child Trust Fund              
+Next - my trousers@Clothing                                   
+Next - Sophie tights@Clothing                                   
+Ardmoor Boots@Clothing                                   
+Digital Ocean@Internet:Servers                           
+Fees@Fees                                        
+Google Play store - calendar app@Communication:Mobile:Apps                   
+Amazon something@Household:Goods                             
+Passport photos@Passport                                    
+Zurich House Insurance @Insurance:Home                             
+NEXT DIRECTORY@Clothing                                   
+Spotify@Internet:Streaming:Spotify                 
+M&S@Food:Groceries                              
+Plusnet mobile@Communication:Mobile                        
+B&M something@Household:Goods                             
+Google Play Store Conversations App@Communication:Mobile:Apps                   
+Google Play Store Conversations App@Communication:Mobile:Apps                   
+Google Play Store Conversations App@Communication:Mobile:Apps                   
+The Maltings Lunch@Food:Restaurant                            
+Greggs@Food:Takeaway                              
+John Scott Bakery Kelso@Food:Takeaway                             
+Sainsburys@Food:Groceries                             
+Morrisons food@Food:Groceries                             
+Amazon something@Household:Goods                            
+Aldi food@Food:Groceries                             
+Fox Den Drinks Bristol@Recreation:Pub                              
+Hover domain for XMPP server@Internet:Domains                            
+Transaction Fee@Fees                                        
+Plusnet mobile@Communication:Mobile                        
+Cafe Nero Edinburgh@Food:Cafe                                   
+Za Za Bazaar Bristol@Recreation:Pub                             
+Zurich car insurance@Car:Insurance                              
+Morrisons food@Food:Groceries                             
+Tesco weekly shop@Food:Groceries                             
+Nextflix@Internet:Streaming:Netflix                  
+Savers@Household:Goods                            
+B&M something@Household:Goods                            
+M&Co Harvey Pants@Clothing                                   
+Costa Coffee@Food:Cafe                                   
+Costa Coffee@Food:Cafe                                   
+Greggs@Food:Takeaway                              
+Boots the Chemist@Pharmaceuticals                             
+Murrayfield Drink Tent@Recreation:Pub                             
+Sainsburys@Food:Groceries                              
+Home Bargains@Household:Goods                             
+WH Smith@Household:Stationery                        
+Scotsmans Lounge Edinburgh@Recreation:Pub                             
+White Heart Edinburgh@Recreation:Pub                             
+HMI Market Street Cafe Edinburgh@Food:Cafe                                   
+Amazon Digital@Household:Goods                             
+Amazon@Household:Goods                             
+Savers@Household:Goods                             
+The Works@Household:Goods                            
+B&M something@Household:Goods                            
+Home Bargains@Household:Goods                            
+The Dolphin Plymouth@Recreation:Pub                             
+Burger King Edinburgh Aiport@Food:Takeaway                              
+Sainsburys@Food:Groceries                              
+Northridge Finance Car@Car:Repayment                             
+The Furness Railway Barrow@Recreation:Pub                              
+Card factory@Gifts                                       
+WH Smith@Household:Stationery                       
+The Mule on Rouge Berwick@Food:Cafe                                   
+The Works@Household:Goods                             
+INT'L 0026634567 ETSY ETSY.COM VIS@Gifts                                      
+INT'L 0026634566 ETSY ETSY.COM VIS@Gifts                                       
+Non-Sterling Transaction Fee DR@Fees                                        
+INT'L 0019087339 Fastmail Pty Ltd Melbourne USD 6.00 @ 1.3392  Visa Rate VIS@Internet:Email                              
+G C GRIEVE BERWICK UPON )))@Household:Stationery                        
+G C GRIEVE BERWICK UPON )))@Household:Stationery                       
+TESCO STORES 6181 BERWICK VIS@Food:Groceries                             
+PAYPAL *WHITE STUF 35314369001 VIS@Gifts                                      
+HOME BARGAINS BERW BERWICK )))@Household:Goods                             
+COSTA COFFEE 43037 BERWICK-UPON- )))@Food:Cafe                                  
+THE WORKS BERWICK UPON )))@Household:Goods                            
+WH SMITH BERWICK-O-TWE )))@Household:Goods                             
+ROBERTSONS BERWICK-UPON- )))@Clothing                                    
+Amazon.co.uk*LU1I5 AMAZON.CO.UK VIS@Gifts                                       
+SECUREPAY.MBNA.CO. CHESTER VIS@FAMILY EQUITY PLAN DD@Child:Sophie:Junior ISA                    
+NEXT DIRECTORY ONLINE VIS@Clothing                                   
+AMZNMktplace amazon.co.uk VIS@Gifts                                      
+AMZNMktplace amazon.co.uk VIS@Gifts                                      
+BLUE LIGHT CARD LEICESTER VIS@Household:Goods                             
+WM MORRISONS STORE BERWICK UT VIS@Food:Groceries                             
+AMZNMktplace amazon.co.uk VIS@Gifts                                      
+TESCO STORES 6181 BERWICK VIS@Food:Groceries                             
+Microsoft*Xbox Reading VIS@Computer:Software:Games                    
+NEXT RETAIL LTD TWEEDMOUTH )))@Clothing                                    
+4424 TWEEDMOUTH )))@Food:Groceries                             
+ROYAL MAIL GROUP L CHESTERFIELD VIS@Postage                                     
+Microsoft*Xbox Reading VIS@Computer:Software:Games                    
+COSTA COFFEE 43037 BERWICK-UPON- )))@Food:Cafe                                   
+SumUp  *Stephens B Dunfermline )))@Food:Takeaway                              
+THE WORKS BERWICK UPON )))@Household:Goods                            
+PNET1056659-3 DD@Internet:Broadband                         
+Non-Sterling Transaction Fee DR@Fees                                        
+INT'L 0097482518 DIGITALOCEAN.COM SURREY USD 43.25 @ 1.3194  Visa Rate VIS@Internet:Servers                           
+ROYAL MAIL GROUP L CHESTERFIELD VIS@Postage                                     
+HM PASSPORT OFFICE DURHAM VIS@Passport                                   
+GOOGLE  Google Pla London VIS@Communication:Mobile:Apps                  
+NORTHUMBRIAN WATER DD@Utilities:Water                            
+TV LICENCE MBP DD@TV Licence                                 
+NCC - RECEIPTS ACC DD@Council Tax                               
+SANTANDER MORTGAGE DD@Mortgage                                  
+ROYAL LONDON DD@Car:Insurance                              
+SCHOOLGRID LTD DD@Food:School Lunches                        
+SCHOOLGRID LTD DD@Food:School Lunches                        
+COSTA COFFEE 43037 BERWICK-UPON- )))@Food:Cafe                                   
+SAVERS HEALTH & BE BERWICK-UPON- )))@Household:Goods                            
+BOOTS/0692 BERWICK UPON )))@Household:Goods                             
+BOOTS/0692 BERWICK UPON )))@Household:Goods                             
+ICELAND BERWICK )))@Food:Groceries                              
+HARVEY W LEMON CTF PP382029B SO@Child:Harvey:Child Trust Fund              
+SCOTTISHPOWER DD@Utilities:Electricity & Gas               
+PAYPAL *EBAY UK 35314369001 VIS@Gifts                                       
+PAYPAL *EBAY UK 35314369001 VIS@Gifts                                       
+PAYPAL *EBAY UK 35314369001 VIS@Gifts                                       
+PAYPAL *EBAY UK 35314369001 VIS@Gifts                                       
+Amazon Prime*FZ73U amzn.co.uk/pm VIS@Gifts                                       
+HOMEBASE.CO.UK 03450778888 VIS@Household:Furniture                        
+MARKS&SPENCER PLC INTERNET VIS@Household:Goods                            
+PLUSNET PLC PAY AC DD@Communication:Mobile                        
+Non-Sterling Transaction Fee DR@Fees                                        
+INT'L 0027078252 PROTONMAIL GENEVA EUR 48.00 @ 1.1690  Visa Rate VIS@Internet:Email                             
+4424 TWEEDMOUTH )))@Food:Groceries                             
+AMZNMktplace amazon.co.uk VIS@Gifts                                      
+ROYAL MAIL GROUP L CHESTERFIELD VIS@Postage                                     
+ROYAL MAIL GROUP L CHESTERFIELD VIS@Postage                                    
+Joules Limited Market Harbor VIS@Clothing                                   
+EBAY COMMERCE UK L LONDON VIS@Gifts                                      
+AMZNMktplace amazon.co.uk VIS@Gifts                                      
+AMZNMktplace amazon.co.uk VIS@Gifts                                      
+TESCO STORES 6181 BERWICK VIS@Food:Groceries                            
+ROYAL MAIL GROUP L CHESTERFIELD VIS@Postage                                     
+BERWICK GARDEN CEN BERWICK-UPON- VIS@Gifts                                      
+SPOTIFY LONDON VIS@Internet:Streaming:Spotify                 
+AMZNMktplace amazon.co.uk VIS@Gifts                                      
+INT'L 0041993653 EB *ONLINE TALK AN 801-413-7200 VIS@Courses                                   
+Non-Sterling Transaction Fee DR@Fees                                        
+INT'L 0041979037 BITWARDEN HTTPSBITWARDE USD 10.00 @ 1.3210  Visa Rate VIS@Computer:Software                           
+THE WORKS BERWICK UPON )))@Gifts                                      
+THE WORKS BERWICK UPON )))@Gifts                                      
+WH SMITH BERWICK-O-TWE )))@Gifts                                      
+GOOD SHIP ILLO BERWICK UPON VIS@Courses                                  
+AMZNMktplace amazon.co.uk VIS@Gifts                                     
+AMZNMktplace amazon.co.uk VIS@Gifts                                      
+AMZ*CCL Computers customerservi VIS@Computer:Hardware                         
+WHITE STUFF LTD INTERNET VIS@Gifts                                     
+Amazon.co.uk*TN1QP AMAZON.CO.UK VIS@Gifts                                      
+PLUSNET PLC PAY AC DD@Communication:Mobile                       
+Amazon.co.uk*S621S AMAZON.CO.UK VIS@Gifts                                      
+Joules Limited Market Harbor VIS@Gifts                                    
+PLUSNET PLC PAY AC DD@Communication:Mobile                        
+CAFFE NERO 304 BER BERWICK UPON )))@Food:Cafe                                   
+B&M 013 - BERWICK BERWICK-UPON- )))@Household:Goods                            
+MARKS&SPENCER PLC BERWICK UPON )))@Food:Groceries                             
+NETFLIX.COM 18665797172 VIS@Internet:Streaming:Netflix                  
+WM MORRISONS STORE BERWICK UT VIS@Food:Groceries                            
+ROYAL MAIL GROUP L CHESTERFIELD VIS@Postage                                     
+THE CROSS INN LTD BERWICK-UPON- VIS@Food:Restaurant                          
+THE WORKS BERWICK UPON )))@Gifts                                     
+HOME BARGAINS BERW BERWICK )))@Household:Goods                             
+B&M 013 - BERWICK BERWICK-UPON- )))@Household:Goods                            
+ICELAND BERWICK )))@Food:Groceries                             
+SAVERS HEALTH & BE BERWICK-UPON- )))@Household:Goods                             
+CARD FACTORY BERWICK )))@Gifts                                       
+WH SMITH BERWICK-O-TWE )))@Gifts                                       
+ICELAND BERWICK )))@Food:Groceries                             
+WH SMITH BERWICK-O-TWE )))@Gifts                                      
+CARD FACTORY BERWICK )))@Gifts                                       
+ZURICH INSURANCE DD@Car:Insurance                              
+AMZNFreeTime 353-12477661 VIS@Gifts                                       
+PAYPAL *NORTH ZOO 35314369001 VIS@Gifts                                      
+CARD FACTORY BERWICK )))@Gifts                                       
+ICELAND BERWICK )))@Food:Groceries                              
+BOOTS/0692 BERWICK UPON )))@Household:Pharmaceuticals                   
+NEXT DIRECTORY ONLINE VIS@Clothing                                   
+Amazon.co.uk*TE0R3 AMAZON.CO.UK VIS@Gifts                                       
+ZURICH INSURANCE FIRST PAYMENT DD@Insurance:Home                             
+Joules pyjamas@Gifts                                      
+AMZNMktplace amazon.co.uk VIS@Gifts                                      
+Morrisons shop@Food:Groceries                            
+NIIB T/A NORTHRIDG DD@Car:Repayment                             
+Castlegate Pharmacy Presecription@Prescription                                
+ROYAL MAIL GROUP L CHESTERFIELD VIS@Postage                                     
+ROYAL MAIL GROUP L CHESTERFIELD VIS@Postage                                     
+ROYAL MAIL GROUP L CHESTERFIELD VIS@Postage                                     
+ROYAL MAIL GROUP L CHESTERFIELD VIS@Postage                                     
+ROYAL MAIL GROUP L CHESTERFIELD VIS@Postage                                     
+FAMILY EQUITY PLAN DD@Child:Sophie:Junior ISA                   
+IZ *ASHLEIGH AFFLE AYTON )))@Joanna:Hair                               
+BOOTS/0692 BERWICK UPON )))@Household:Goods                             
+HOME BARGAINS BERW BERWICK )))@Household:Goods                             
+Non-Sterling Transaction Fee DR@Fees                                        
+INT'L 0057713324 DOMESTIKA INC 4159940789 USD 19.93 @ 1.3198  Visa Rate VIS@Courses                                    
+Morrisons Christmas Shop@Food:Groceries                            
+Amazon.co.uk*08979 AMAZON.CO.UK VIS@Gifts                                     
+GOOGLE  Google Pla London VIS@Communication:Mobile:Apps                  
+Joules Limited Market Harbor VIS@Clothing                                   
+NEXT DIRECTORY ONLINE VIS@Clothing                                  
+Amazon.co.uk*QO78D AMAZON.CO.UK VIS@Household:Goods                             
+ODEON CINEMAS LONDON VIS@Days Out:Cinema                           
+SHELL NORTH ROAD BERWICK ON TW )))@Car:Petrol                                 
+NEXT DIRECTORY ONLINE VIS@Clothing                                  
+AMZNMktplace amazon.co.uk VIS@Household:Goods                            
+Amazon.co.uk*9W7J6 AMAZON.CO.UK VIS@Books                                       
+HOBBYCRAFT EDINBURGH )))@Joanna:Art Materials                        
+ODEON FORT KINNAIRD )))@Food:Takeaway                              
+PIZZA HUT BOREHAMWOOD VIS@Food:Restaurant                            
+TESCO STORES 6181@Food:Groceries                             
+THE QUEENS HEAD HOTEL@Food:Restaurant                            
+EURORESCUE ROMFORD VIS@Car:Breakdown                              
+PLUSNET PLC PAY AC DD@Communication:Mobile                       
diff --git a/ledgerscripts/get_categories.pl b/ledgerscripts/get_categories.pl
index fc4fa96..554efe6 100644
--- a/ledgerscripts/get_categories.pl
+++ b/ledgerscripts/get_categories.pl
@@ -13,6 +13,10 @@ use warnings;
 local $/ = ""; # switch to paragraph mode (allow use of /m modifier below)
 
 while (<>) {
+    # we only want true expenses, no income, rebates, pocket money, etc
+    # Not all undesirable cases will be found based on this so be warned!
+    next if (/Pocket Money|Income|Assets|[Rr]ebate/);
+    next if (/-£/);
     if (/\d{4}.*\* (.*)$/m) { print $1 . "@" };
     if (/Expenses:(.*)£/) { print $1 . "\n" };
 }