A simple monthly budget sheet needs planned amounts, actual entries and a clear way to compare them. Choose the month first, then decide which categories and sign convention you will use.

For a small workbook, a summary sheet and a transaction sheet are a useful starting point. Keep the numbers tied to the records you use to check them.

Example budget plans income of 3500 and spending of 2100, leaving a planned remainder of 1400.

Use a stated month and one consistent sign convention. Original instructional illustration.

Start with a small example

Category

Illustrative planned amount

Income

3500

Rent

1200

Food

450

Transport

150

Other spending

300

These amounts are a workbook exercise. Planned spending totals 2100, leaving 1400 from the example income. Replace the categories and values with your own records.

Separate plan and actual

Give the summary distinct columns for planned and actual amounts. Add a difference column and say which subtraction it uses. Actual minus plan will be positive when spending is above the planned amount.

For example, if planned food spending is 450 and actual food spending is 480, =C2-B2 gives 30 when Plan is in B2 and Actual is in C2. Label that result “30 over plan” in the review. A difference needs context. If an expense belongs to a different month, check its date and the method used to assign it before interpreting the category result.

Transaction rows have date, description, category and amount, with checks for transfers and duplicate entries.

A small transaction table supports category totals. Original instructional illustration.

Keep a traceable transaction list

Use a row for each entry with a date, description, category and amount. A reference to the source record can help when an amount needs checking.

Identify transfers so the same movement is not accidentally counted as both a new expense and another expense when money leaves the destination account. Make the treatment consistent with the purpose of your own sheet.

Reconcile before interpreting

  1. Check the reporting month.

  2. Compare entries with the source records.

  3. Look for duplicates, missing amounts and inconsistent categories.

  4. Check the summary ranges include the intended rows.

  5. Save a dated copy after the review.

You can build and edit the workbook locally in Ulet. Keep a small check like the example totals on a separate practice sheet when you want to understand how the summary works. Ulet Spreadsheet Editor.