50/30/20 budget spreadsheet

To understand a 50/30/20 split, apply the percentages to a sample amount. On 1000 units, the blocks are 500, 300 and 200, totaling 1000 again.

Ready to print

View preview

Currency

US dollar ($)
Pound sterling (£)

Recording example

To understand a 50/30/20 split, apply the percentages to a sample amount. On 1000 units, the blocks are 500, 300 and 200, totaling 1000 again. State which category you assign to each block.

Check the data

These percentages are a calculation structure you can change, not a recommendation for your spending. After changing a percentage, check the total and the base amount used.

Check formulas and units

Test the sheet with two or three simple amounts and check the total manually. Distinguish input cells from calculated cells. Do not add amounts from different currencies or periods as though they were equivalent; the template organizes the data you enter.