Checkbook Register - Possible to auto-enter deposits/withdrawals on certain dates?

I wasn't sure which was the appropriate forum, as I'm not sure (if it is possible) whether it would require a macro, VBA, a formula, or what.

I'm wanting to make a checkbook register. That part I can do (I am totally an Excel idiot, but I'm fairly decent with Google and I couldn't seem to find anything about this), but I'm wondering if auto-drafts are possible. What I'd like to do is have a table of regular auto-withdrawals (or deposits, for that matter) and then on the appropriate day have them auto enter into the register. Ideally, I'd like them to enter 2-3 days in advance, or even at the beginning of the month.

For example: Netflix on the 1st, Life Insurance on the 12th, Auto Insurance on the 15th, etc.

Is Excel capable of this? If so, could anyone link me to how, or describe how? Thanks.