Skip to content

Instantly share code, notes, and snippets.

@mpurdon
Created April 4, 2023 18:08
Show Gist options
  • Save mpurdon/f52ae8216d1ec851873abacea047720f to your computer and use it in GitHub Desktop.
Save mpurdon/f52ae8216d1ec851873abacea047720f to your computer and use it in GitHub Desktop.
Example expense categories for statement_parser
{
"Income": {
"display_order": 1,
"": {
"credit TT": "Employer",
"Payroll Deposit": "Employer",
"Online Banking 3rd party deposit": "Employer"
}
},
"Business Expenses": {
"display_order": 2,
"Office Supplies": {
"STAPLES": null
},
"Computer Hardware": {
"CANADA COMPUTER": "Canada Computers",
"BEST BUY": "Best Buy",
"SYSTEM76": "System76",
"NEWEGG.COM": "NewEgg.com"
},
"Computer Repair": {
"FUTURE-TECH CAN": "Future Tech Canada"
},
"Online Services": {
"CINCH SHARE": "Cynch Share Social Media Marketing",
"CODERO.COM": "Codero Server Hosting",
"GOOGLE ADWORDS": "Google Adwords",
"GOOGLE *GSUITE": "Google Hosting",
"GOOGLE *SVCSAPP": "Google Hosting",
"GOOGLE CC @GOOG": "Google Hosting",
"Amazon web": "Amazon Web Services",
"Amazon Digital": "Amazon Web Services",
"GITHUB.COM": "GitHub Development Platform",
"SLACK": "Slack Messaging App",
"MONIKER": "Moniker Domain Name Service",
"DROPBOX": "Dropbox File Hosting Service",
"DropboxInc": "Dropbox File Hosting Service",
"LASTPASS": "LastPass Password Management",
"Spotify": "Spotify Podcast Client",
"CANVA*": "Canva Graphic Design Tool",
"DESIGN BUNDLES": "Canva Design Bundles"
},
"Memberships": {
"ACM ": "Association for Computing Machinery"
},
"Software": {
"POSTMAN": "Postman"
}
},
"Other Expenses": {
"display_order": 3,
"Bank Fees": {
"Overdraft handling fee": null,
"Monthly fee": null,
"Funds transfer fee TT": "Fee for Transfer from Client",
"View item online fee": null,
"Overdraft interest": null,
"INFO PROTECTOR PLUS": "Info Protector Plus Identity theft protection",
"NSF item fee": null
},
"Medical": {
"COLDSTREAM": "Coldstream Dental",
"COLD STREAM DEN": "Coldstream Dental",
"OSHAWA PHYSIOTH": "Oshawa Physiotherapy",
"DR.TIM LEE": "Dr. Tim Lee Ophthalmologist",
"OPTIMAL EYE": "Optimal Eye Care Optometrist",
"LH - MY CHART": "Lakeridge Health Charge"
},
"Insurance": {
"MANULIFE": "Manulife Life Insurance",
"Mortgage Insurance": "Manulife Mortgage Insurance",
"MORTGAGEPROTECT": "Manulife Mortgage Insurance",
"RBC TRAVEL INS": "RBC Travel Insurance",
"CERTAS": "Certas Home and Auto Insurance"
},
"Education": {
"ALGONQUIN COLLEGE": "Algonquin College Tuition",
"VIRTUAL HIGH SCHOOL": "Virtual High-school Tuition",
"OCAS APP": "Ontario Colleges Application"
}
},
"Tax Payments": {
"display_order": 4,
"": {
"CRA-PAST TAX": "CRA Arrears",
"CRA-REV TX OWI": "CRA Installment",
"Tax Refund CANADA": "CRA Installment"
}
},
"RRSP Contributions": {
"display_order": 5,
"": {
"RSP Contribution": null
}
},
"Charity": {
"display_order": 6,
"": {
"WORLD VISION": "World Vision Canada",
"BENEFIT CAMPAIGN": "Make-A-Wish Canada",
"CAMH FOUNDATION": "CAMH Foundation",
"HOSP FOR SICK": "Hospital for Sick Kids",
"SICKKIDS": "Hospital for Sick Kids"
}
},
"Housing and Utilities": {
"display_order": 7,
"Mortgage": {
"Mortgage payment": "Equitable Bank",
"Mortgage Equitable Bank": "Equitable Bank",
"EQUITABLE BANK": "Equitable Bank"
},
"Property Taxes": {
"Property Tax CITY OF OSHAWA": "Oshawa Property Taxes"
},
"Phone": {
"Telephone Bill": "Rogers Business Mobile Phone",
"KOODO": "Koodo Family Mobile Phone Plan",
"Koodo": "Koodo Family Mobile Phone Plan",
"VONAGE": "Vonage Landline VOIP",
"TELUS MOBILITY": "Telus Business Mobile Phone"
},
"Gas": {
"Enbridge": null
},
"Electricity": {
"Utility Bill Pmt OPUC": "Oshawa PUC"
},
"Water": {
"DURHAM WATER": "Durham Region Water"
}
},
"Ignore": {
"display_order": 8,
"Pets": {
"SIMCOE ST N VET": "Simcoe Street Veterinary Clinic",
"URBAN NATURE": "Urban Nature Store"
},
"Home Improvement": {
"HOME DEPOT": "Home Depot",
"LOWES": "Lowes",
"LOWE'S": "Lowes",
"RONA MILLWORK": "Rona",
"IKEA": "Ikea",
"ELDON LIGHTING": "Eldon Lighting",
"CANADIAN STANDARDS ASS": "Canadian Standards Inspection"
}
},
"Food": {
"display_order": 9,
"Uber": {
"UBER * EATS": "Uber Eats",
"UBER* EATS": "Uber Eats",
"UBER CANADA": "Uber Eats"
},
"Skip": {
"SKIPTHEDISHES": "Skip the Dishes"
},
"Instacart": {
"INSTACART": "Instacart"
},
"Uber Groceries": {
"UBER CORNERSHOP": "Uber Groceries"
},
"Sobys": {
"VOILA": "Soby's Groceries"
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment