A colleague of mine shared this handy Excel tip he uses to reward good behavior and chore performance to calculate his child's weekly allowance. He started it when his son was only about three years old, using fun stickers to mark simple chores and good days of listening and following directions.
Here is what the most recent version looks like:
Over the years, the spreadsheet and process have evolved. At about age 5, they switched to stickers shaped like different coins: a quarter for a task that was really well done, a penny for those that could have gone a whole lot better. This has the added value of teaching his child about the coins and their different values.
To create the form, he simply made good use of the various layout features in Excel:
Download the calendar as a starting point, or create your own rewards chart using these handy techniques.
I started out with Excel for this too, but being a software geek I ended up building a web site to track it and to let the kids sign in to see their balances. Since then, it's evolved into an online "Virtual Family Bank" that parents can use to teach their kids all kinds of good personal finance habits. If interested, please check it out at FamZoo.com