I use Google Sheets as well to track stuff like finances, calories, workout stats. And I too have wondered about a nicer way of inputting data.

Have you looked into Google Forms? I really wish it supported custom types like list of items from named ranges. A custom UI app (in Haskell/reflex!) is what I may end up writing too.

I use ledger myself, but the issue I always run into is my wife is much less likely to keep track of what she buys and let me know so I can record it. Where that gets especially tricky is when she goes someplace and leaves a tip. Resolving tips is a real pain in the butt, especially since it comes through in the checking account at the original price and is then later processed at the tip-included price. Matching those up is a real bear.

I also had a similar issue, but then it became like a habit – every night I would check my accounts and add day's expenses (it's difficult if you have a lot of cash transactions). For the tip, wouldn't you round off to nearest full digit? You can just add that as an expense.

I used to reconcile our purchases against our online checking account every night, but the issue with tips happened when I would do that but then a few weeks later I would go through and actually balance everything out and suddenly I'd be off by a dollar and change and have to go on a deep dive to find out where I went wrong.