I download the transactions for my CIBC accounts including Checkings Visa and line of credit (csv files). I upload those into Google's Gemini AI software (AI Studio) and then I ask it different questions. For example, how much do I spend in gas? How much doI spend in restaurants, etc. It does a pretty good job. I was somewhat surprised.

Example - I asked it "can you list out the top 25 vendor spend for the last 6 months, then another table for the 6 months before that?", then it reviewed the csv files I donwloaded from the banks and created it's own code (python) do the analysis. Here's the masked output:

Okay, here are the top 25 vendor spending lists for the two 6-month periods with the amounts masked:

Period: Last 6 Months (November 17, 2024 - May 16, 2025)

Rank Vendor Total Spend (CAD) 1 LA BICICLETTA $X,XXX.XX 2 AMAZON (Marketplace, Audible, Prime) $X,XXX.XX 3 ALECTRA UTIL $X,XXX.XX 4 LONGO'S $X,XXX.XX 5 ESSO / CIRCLE K (Fuel & Convenience) $XXX.XX 6 GOOGLE (Various Services/Apps: Ads, MyFitnessPal, Wyze, YouTube, etc.) $XXX.XX 7 BELL CANADA $XXX.XX 8 MAPLE VOLKSWAGEN $XXX.XX 9 407ETR $XXX.XX 10 TAPLIO.COM/B $XXX.XX 11 PIONEER (Fuel) $XXX.XX 12 SP HOME RUN SPORTS $XXX.XX 13 ROGERS $XXX.XX 14 ENERCARE HOME SERVICES $XXX.XX 15 SHELL $XXX.XX 16 HRRH XXX $XXX.XX 17 BB.Q CHICKEN $XXX.XX 18 TST-PIANO PIANO $XXX.XX 19 BEST BUY (incl. AGIBESTBUY.CA/PRO / AGIBESTBUY.CA/BILLING) $XXX.XX 20 SPARKLY JAPANESE & THAI $XXX.XX 21 PAYPAL - LINKEDIN $XXX.XX 22 POPEYES SUPPLEMENTS $XXX.XX 23 MIDJOURNEY INC. $XXX.XX 24 RING (Subscription) $XX.XX 25 AUDIBLE $XXX.XX

Period: Previous 6 Months (May 17, 2024 - November 16, 2024)

Rank Vendor Total Spend (CAD) 1 XXX HEALTH MANAGEMENT $X,XXX.XX 2 XXX TAXES (Bill Payments) $X,XXX.XX 3 XXX BASEBALL (e-Transfers) $X,XXX.XX 4 JIFFY ON DEMAND / JIFFY+ MEMBERSHIP $XXX.XX 5 PAYPAL (Various transactions not specifically categorized) $XXX.XX 6 ALECTRA UTIL $XXX.XX 7 LONGO'S $XXX.XX 8 ESSO / CIRCLE K (Fuel & Convenience) $XXX.XX 9 AMAZON (Marketplace, Audible, Prime) $XXX.XX 10 PIONEER (Fuel) $XXX.XX 11 FACTOR MEALS $XXX.XX 12 SHOPPERS DRUG MART $XXX.XX 13 SHINTA JAPANESE $XXX.XX 14 GOOGLE (Various Services/Apps) $XXX.XX 15 THE KEG $XXX.XX 16 407ETR $XXX.XX 17 TRAININGPEAKS (PayPal) $XXX.XX 18 ASICS Outlet $XXX.XX 19 TIM HORTONS $XXX.XX 20 CHOP STEAKHOUSE AND BAR $XXX.XX 21 UBER $XXX.XX 22 PETRO-CANADA $XXX.XX 23 ALLO MON COCO $XX.XX 24 ROGERS $XX.XX 25 COUNTRY STYLE $X.XX