Well I've set up a pretty basic spreadsheet across 3 (working on 4th) sheets at the moment.
Sheet 1 = 'Main'. Column headers such as 'Opening Balance, General budget, Special items (i.e. buying a new phone, hardware, anything exempt from normal items), General expenses, Total expenses, Total income, Difference (Total income - Total expenses) and Closing Balance.
This sheet just generally outlines money going in and out, and I can see the variation per month.
Sheet 2 = 'Expense'. Basically a recording of all my expenses. I end up with 2 figures, General expenses and Total expenses, which I copy into my main sheet.
Column headers are 'Month, Date, Expense (short descriptiun), Expense cost, Cumulative cost. After each month I leave a spare row to add the Total expenses (same as final cumulative cost. I also subtract the cost of Special items to give the General expenses.
Sheet 3 = 'Income'. A recording of my various ingoings. Works in a similar way to the expense sheet, and I end up with a 'Total income' figure.
Column headers are 'Month, Date, Income, Income amount, Cumulative amount'. Under each month I have the Total income too.
Sheet 4 = 'Special'. A work in progress, using it to monitor my special items or irregular purchases that should be 'paid off'. Also going to be used for loans.
Might sound a bit complicated, but I did it in an hour or so, and was quite interesting. The real challenge is updating it regularly