That seems like a ton of work. I suppose it is good to look at the history.
When I do my spreadsheet (had to re-do it after I retired based on new income), I don't look backwards. I only look forward. The past is the past to me. I have to create a new budget. So my spreadsheet lists all my bills. I have a column for category such as credit card, household (utility, electricity, cable, etc), then other type of re-occurring bills I have. If there is an overall balance due such as a credit card, I list the overall balance and interest rates. I also have a column for when the bill is paid. I pay all of my bills either on the 1st or 15th (lines up with previous military paydays, and easy for me to remember two dates instead of multiple), so I have a column that says indicates if the bill is paid on first or 15th. About 5 days before the 1st and 15th, I review my spreadsheet and update the amounts being paid, electricity is not always the same each month. But most of my bills that do have the same payment each month like life insurance, auto insurance, etc., I have set up for auto pay though my bank web bill pay service.
I do have formulas set up to calculate the overall amount I am paying in debt/bills and another formula that adds up all of our income coming in that month (and the date they are coming in), another formula that calculates how much is left after income and bills paid. So I can see how much I have left over each month and determine what I want to do with that balance. I keep one spreadsheet per year, and each spreadsheet has a tab for every month.
I like using spreadsheets over other programs because it gives me control to see just what I want to see. Nothing more, nothing less. My bank has a entire budget tool, free, but I still prefer the spreadsheet.
I suppose mine is more of a monthly tracking and others may budget a year in advance. I just go month by month. It is much easier for me that way. Also, less depressing to focus just on the month at hand.