Open a spreadsheet program
Create a new blank sheet
Label columns for income, expenses, dates, and notes
List all income sources
List all fixed expenses
List all variable expenses
Add estimated amounts for each item
Add actual amounts for each item
Include a column for differences
Sum total income
Sum total expenses
Calculate net balance
Separate expenses into categories
Format cells as currency
Highlight important totals
Add formulas for automatic calculations
Create a monthly summary section
Review and update the spreadsheet regularly