Yeah this. After futzing with Excel for over a decade, I switched to GNUcash and the budgeting didn't work, then two other commercial products which didn't work, then I tried to design a product which would solve the problem and that didn't work either. So here I am back on a spreadsheet.
The problem is sometimes things aren't ideal or simple to represent. A spreadsheet forms no restrictions so you can ad-hoc futz with split transactions and all sorts without shooting yourself or getting stuck. Every other way of handling this is just pain and friction.
The problem is sometimes things aren't ideal or simple to represent. A spreadsheet forms no restrictions so you can ad-hoc futz with split transactions and all sorts without shooting yourself or getting stuck. Every other way of handling this is just pain and friction.