Yeah I mean I understand the money flows, but it's so tedious to keep my credit card transactions, splitwise, and venmo open while I'm entering things in the spreadsheet.
A budgeting UI that managed this would be amazing, but I understand other people may not keep track of their money flows this way so it doesn't necessarily surprise me that it's not already built.
When you spend $100 at the grocery store you make an entry with $100 subtracted from assets:bank, $50 added to expenses:groceries, and $50 added to assets:receivables.
Once your friend pays you $250 for your outlay, you add them to assets:bank and subtract them from assets:receivables.
It’s a little tedious in a spreadsheet, because each transaction results in at least two new rows, so it can feel redundant, but this is basically double entry accounting that can handle this and many other situations.