I have been keeping an excel-based diary of spending for the last 3 or 4 years. It has certainly been successful in helping us see where our money is going, but it hasn't been a great success in terms of helping us to control spending, changing habits and building wealth (now, in fairness, the last few years have seen 2 babies arrive, wedding, house etc)
But in 2019, we are taking it more seriously, and have devised a system which so far is working very well for us.
We each have a Revolut card, and we top it up every Sunday with money from our current account. Each of us can spend whatever we want (Coffee, clothes, lunches out, drinks . . . whatever) on this card and none of this money is tracked on the spreadsheet. No one has to answer to the other for any purchases they make on their Revolut card. These weekly topups appear on my budget spreadsheets as a single line called "pocket money"
Everything else - bills, groceries, petrol, spending on the kids etc - all comes from the current account and is tracked on the spreadsheet. I enter these transactions every day from the KBC app, usually when I'm in work.
We are trying to sit down at the beginning of every month to review the previous month and agree on the next month's budget.
As I say, at the moment, it's working well. Both of us have agreed that the Revolut method is making us stop and think about the money we had been throwing away on eating out, sweets, coffees etc. Because we both have things we actually want to buy for ourselves, we are therefore finding ourselves really cutting back on the rubbish.