So weve been doing the whole roommate thing for a few years now and usually Splitwise is my go-to for everything but things have gotten really messy lately since we upgraded to a Walmart+ membership to save on gas. We live about 20 minutes from the nearest supercenter so delivery is a lifesaver but the receipts are driving me insane.
Theres four of us now in this apartment and everyone has different diets. One guy is super into name brands only while I try to stick to the Great Value stuff to keep my personal budget under 150 a month but the receipts just show a giant lump sum with tax added at the end. Ive tried exporting the data to a spreadsheet but the formatting is always wonky and I spend my entire Sunday morning trying to figure out who owes for the 12-pack of soda versus the shared paper towels. Its making me super anxious because Im the one putting my card down and I feel like Im accidentally subsidizing everyone elses snacks because I cant get the math to work with the delivery fees and tax distribution.
Is there any easier way to tag items in the cart or a third party tool that actually plays nice with the Walmart app? I really dont want to keep manually typing in 60 items every week just to make sure Im not getting screwed...
Wow, I have been in your exact shoes! Last year I lived with three guys who ate like horses while I was trying to save every penny. It was a total nightmare! Testing two different ways was quite the journey. First, going full nerd led to a custom Google Sheet for importing the Walmart CSV data. It sounded fantastic but the technical reality was a mess because Walmart changes their item descriptions constantly... one week it is Great Value Milk and the next it is just GV MLK. The formatting is so unreliable for exports! Then the Splitwise itemized scan seemed like a fix. It is seriously amazing for speed, but I am super cautious about the math. Sometimes it misses the delivery fee or glitches on the tax! Ngl, I eventually just went back to the old school method of highlighting a digital receipt. It is the only way to be 100% sure you dont end up paying for someone elses soda!
Honestly, trying to automate Walmart receipt scraping is a total dead end. Their digital receipt formatting is a nightmare to parse, and third-party receipt scanners are unfortunately not as good as expected when it comes to line-item tax distribution. I had issues with almost every OCR tool out there because they fail to calculate the mixed tax rates correctly. The quickest fix is managing this at checkout. Just use the shared cart feature in the Walmart app. Have everyone add their own items, and take screenshots of the individual subtotals before you actually place the order. For shared items like paper towels, just split that specific amount evenly at the end. It is way easier than trying to untangle the giant lump sum afterwards.