First off I'll say that spreadsheets are an absolute danger for someone who is financially illiterate, even for those skilled in money management, they are a dangerous tool. Its far too easy to read the bottom line without factoring in all the intangible costs of day to day living.
As an example, the TV License bill, DW believed she had paid it, she hadn't noticed that it had bounced because the day she paid it online, it then took several days to hit her account. By that point, she believed that it had been paid and had taken the money from her account.
That was not her fault, in this day and age we believe that the banks make instantaneous payments - they don't.
So the red final demand drops through the letterbox, three months later. I'm sure there were reminders between, but I never got to see them.
A spreadsheet would show that it had been paid, so now the spreadsheet is out of balance with the reality of the account.
This is reconciliation comes into play. Another example, because she has so mismanaged her two bank accounts, monthly she gets hit with excess charge fees. She does actually have a great deal of difficulty understanding a bank statement, or the use of debits and credits.
I'm not against spreadsheets, I use them all the time for forecasting and future planning. But we still have a significant amount debts to pay off, so I actually use a financial diary plus the online banking facilities. And reconcile daily, if I can pare back in one place to remove a debt earlier then I will ( I loath interest rates - especially the dangerous payday loan ones).
Another example, she was about to go on an all day business trip. A couple of days before she went I asked her to visualise her day, early morning taxi to tube station, pick up a latte at the station, plus a magazine a bottle of coke and a book or 2 for the travel. Arrive Taxi to location, lunch, taxi to station, latte or a glass of wine, another bottle of coke, taxi home.
Before she started the visualisation exercise I had asked how much the day out would cost, DW replied nothing as the train ticket has been paid for by work. Sheepishly after the visualisation exercise, she reckon she'd get through a tonne easily.
You see the trouble with short term debt especially payday loans and the fact that some of them have been defaulted on. We have to scrape together certain amount by certain periods to avoid excess fees etc.
With the TV license example above, I was sorely tempted not to pay it, as the cost at that moment would have reduced our weekly budget down to less than £50 - £30ish of which was for DW work travel. That was a tight week, but it would have been a false economy, cos of the £1k fine.
I've only recently become a SAHD mainly as the wrap around childcare costs of the last three months of the previous year swallowed all my pay. DW works zero day contracts, so if she doesn't go to work she doesn't get paid for that day. As she earns a lot more than me the common sense option is for me to do all the home work, and ensure that she has the travel money to work, breakfast lunch and dinner preped for her and not to worry about that telephone call cos one of the DC's has fallen sick at school or its a snow day or a flood.
Also its an hour from school to home (we are moving very soon to be closer to the school).
Thank you for the information about the CAP course... that is what I'm trying to teach her. We've (meaning me) have suffered from a lot of dishonesty and opacity, plus a lack of communication of delineated boundaries. When we were both working (each out of the house for 12 hours), we were both doing long days and the evenings with the DC's being a bit stroppy about bedtime. We're working towards honesty, transparency and firmly delineated boundaries. It doesn't mean I'm a skinflint scrooge and that I'm treating her like a child, What I'm trying to encourage is a questioning, thoughtful attitude to how we use money.
As an example, Saturday she wanted somekind of serum thingy, the one she used to buy was about £50 quid for a bottle that was the size of my thumb. She's then dropped to buying one at about £20 on Saturday, she compared two and bought the cheaper one... subsequently she's told me that using the forums here she's found that the Aldi one is better and significantly cheaper.