# How to Make a Simple Budget Spreadsheet

Step by step, learn how to make a simple budget spreadsheet: set up income and expense columns, add sum formulas, and track planned versus actual costs.

You make a simple budget spreadsheet by opening a blank sheet, labeling columns for date, category, and amount, and adding a few sum formulas to total income against expenses. The same setup works in Excel and Google Sheets, and one file can track a tournament's fees, prizes, and supplies. This page gives the setup steps, the columns that matter, and the formulas that keep a running total. 

## Set up the first columns 

A clean budget sheet starts with a header row that names each column before you type any numbers. Build columns for date, category, description, and amount, then add a column that marks each line as income or expense. A separate column for planned versus actual costs lets you compare what you expected with what you spent. Keep one row per transaction so the sheet stays easy to read and sort. 

## Use formulas for running totals 

Formulas turn a list of numbers into a budget, and sum formulas are the ones you need first. A SUM formula over the amount column gives the whole total, while SUMIF totals one category or only the income rows. Copy the formula down as you add rows so a running total updates on its own. Excel and Google Sheets share the same formula names, so the file works in either. 

## Track expenses during the event 

An expense tracking spreadsheet works when entries go in as costs happen, not all at the end. Log each payment on the day with its date and category so the running total stays honest. Compare that total against the planned figure to see which budget categories are ahead or behind. Review the sheet between rounds or at the end of each day of the tournament. 

## Match categories to the event 

Budget categories should mirror the money your group actually moves, such as entry fees, venue costs, prizes, and food. List income sources and expense types apart so a single formula can total each side. Group small items under one label instead of creating a category for every purchase. Clear categories make the difference between planned and actual costs easy to read. 

## Questions About Budget Spreadsheets 

### How do I create a financial spreadsheet in Excel from scratch? 

You create a financial spreadsheet in Excel from a blank workbook by adding a header row with date, category, and amount, then typing your first entries below it. Add a SUM formula under the amount column to total everything. Format the amount column as currency so values read clearly. Save the file under a name that tells you which event it covers. 

### Can I make my own budget spreadsheet instead of using a template? 

Yes, you can make your own budget spreadsheet with four or five columns and one sum formula. A template saves time, but a hand-built sheet fits your event categories and stays simple to follow. Start with the columns for date, category, and amount, then add more only when the budget needs them. Building it yourself also teaches you what each formula does. 

### How do I keep track of expenses in Excel during a tournament? 

You keep track of expenses in Excel by entering each cost on the day it happens, with its date and category. A running total from a sum formula shows the current spend without any manual adding. Check that total against the planned figure for each category after every round. This habit keeps the expense log current and ready for a final review. 

### What is the difference between planned and actual costs in a budget spreadsheet? 

Planned costs are the amounts you expect to spend, and actual costs are the amounts you really spend. A budget spreadsheet holds both side by side so the gap between them is visible. Subtract the actual from the planned figure in a column to see each difference. That comparison shows which categories need attention before the event ends.
