I do basically the same thing, BUT I auto pay everything that I can, and just update the amounts as I get the ebills emailed to me. We get paid on the 1st and 15th every month. All our auto payments happen on the same day each month for each account, there is no variation. I have 14 autopays every month, and only 3 where I have to do manual online payments (3 credit cards for everyday expenses). So, I just divide the month in half and list all the bills paid from the 1-14 and then the 15-31. When we get paid, I update the excel running bank account balance sheet and copy/paste the bills from the monthly bills spreadsheet. We use 3 different rewards credit cards to charge things (one is for groceries and dining out, one is for travel expenses and dining out, and one is for Disney expenses and gas). 1 card gets paid in the first half and the other 2 in the second half. I just update the balances as the month goes on so I know what the running tally is. Our pay is also steady...same amount each week, so it makes it very easy to see how much money we will have on future pay days and project forward for the purposes of knowing how much we can spend on the credit cards. I always project the excel bank account balance spreadsheet forward by one pay period to make sure we can pay all our obligations with the pay coming in that month.
It's possible to use autopay and ALSO keep very close track of when and how much the bills are. I mean, most of my autopays are fixed amounts anyway (auto insurance, life insurance, IRA contribution, 529 contribution, rent, car payment, cable, cell phone, Netflix). The only ones that change are the utilites (gas, water, electric). So, I really only have to update 3 bill amounts every month as the ebills roll in.