Excel templates / Monthly budget

Monthly budget template

Planned against actual income and spending, with what’s left, the share of each budget used, and a savings rate.

Download the monthly budget template (.xlsx). Free, no sign-up. Works in Excel 2010 and later, Excel for Mac, Excel on the web, Google Sheets and LibreOffice.

How to use it

  1. Put the month in B2.
  2. Fill in the yellow cells: what you plan to earn and spend in column B, and what you actually earned and spent in column C.
  3. Rename the categories in A11 to A20 to suit you. Everything else updates by itself.

How it works

Learn the skills behind it

Functions used: SUM, IF, COUNTIF.

More free templates