A personal budget workbook

The problem

Build a monthly budget in your own Excel that records income and spending, shows the balance by category and month, and warns when a category is over its limit.

Requirements

Technologies

Step by step

  1. Create the Transactions Table and a Settings sheet with the category list and limits.
  2. Add data validation for categories and types.
  3. Build the summary with SUMIFS and absolute references to the settings.
  4. Add conditional formatting, a chart and a PivotTable, then protect the formulas.

Expected result

A reusable budget workbook that stays correct as new transactions are added.

How it is evaluated

Ways to improve it