Balance Sheet With Ten Days Notice

I am creating a balance sheet for my company that seems pretty simple (date, transaction type, amount, and balance), except for one thing: 10 days before every bill is due (and before every purchase is made), expense amounts are supposed to show up in the balance sheet as a deduction from the current balance, so that the sheet projects what the balance will be in 10 days. Do I need a macro for that? If so, what would it look like? It needs to be blank if it's more than 10 days out, and then suddenly appear in the balance sheet once it's 10 days away from due date.