MMM's recent post, "What I'm teaching my son about money," (
http://www.mrmoneymustache.com/2015/05/20/what-im-teaching-my-son-about-money/ inspired my wife and me to want to try the same thing with our 6 year old daughter.
I can make my own spreadsheet that'll keep track of our daughter's deposits and withdrawals from her savings and then calculate interest on the current balance manually, once a month, but it seems like it'd be cooler and more accurate to keep track, like MMM's spreadsheet seems to do, of how many days the money has been in the account, i.e., if the money was just deposited a day before interest gets calculated, it doesn't get interest for the full month, only for the one day. It would be nice to have that in our spreadsheet, but unfortunately I have no idea how to do it myself...
Have any of you spreadsheet wizards created a spreadsheet similar to MMM's to keep track of your kid(s)' finances? Would you be willing to share your spreadsheet?
We're thinking of doing one in Google Sheets, that'll be accessible to both me and my wife via a phone or tablet and will sync when one of us makes a change. That way if my wife's out with my daughter at Target and our daughter insists on buying a new game or a snack or whatever, my wife can buy her what she wants, but she'll be able to debit the money from our daughter's account, so she has to pay for it herself.
Thanks in advance for any help you're able to give us.