Here is a xlsx spreadsheet template for summarising and categorising transactions.
The summary tab adds up the transactions under the same categories in the other tabs.
You can create tabs of any name as long as you specify the name in row 1 of summary. They could be month name or week number.
In January tab, column I is where you code the transactions, and Column B is the amount (-ve for expense, +ve for income). You can ensure the category exists in column I by setting data validation to a list back to summary categories. You can list any category you want in the summary tab.
I have developed this over several years of tracking my income and expenditure. I download a csv of my transactions from my bank accounts, code, then analyse once a month. Once a year I check against my budget, see if anything needs adjustment. I don’t have a strict budget, but I do like knowing where my money is going and coming from.