pull down to refresh

Cool beans. I would be interested to learn how you made the process of documenting these expenses frictionless for yourself

It's certainly not frictionless, but not too much work, either.

I keep a sheet where I manually enter the tracked purchases as I make them, like this:

DateItem# unitsUnitssatssats / unit
2025-10-03Electricity148.1kWh24382.758164.637
2025-10-03Water3.4kl14629.6554302.840

(A lookup table of the items I'm tracking autofills unit names given an item's name)

Another pivot table then helps aggregate monthly average sats/unit prices and change values per item.

Takes a few minutes for each purchase because we usually buy more than just the tracked item(s) with sats. So I break out the fraction for each tracked item from the total price.
But since I pay the full bill in sats, that's an easy calculation.

reply