How to Set Up a Basic Personal Budget in Google Sheets

To begin your budget, open a new Google Sheet and give it a clear name like Monthly Budget. Start by creating four column headers in the first row: Category, Planned Amount, Actual Amount, and Difference. This layout allows you to compare what you intended to spend against what you actually spent.

Dedicate the first section of your sheet to income. List every source of money coming in, such as your primary salary, side hustles, or dividends. At the bottom of this list, use the SUM function to automatically calculate your total monthly income.

Below your income section, create a category for fixed expenses. These are costs that rarely change, such as rent, mortgage payments, or insurance premiums. Enter the expected cost for each in the Planned Amount column to establish your baseline costs.

Next, add a section for variable expenses. These include fluctuating costs like groceries, dining out, and entertainment. Since these change often, it is helpful to leave the Actual Amount column blank until you start logging your real-time spending throughout the month.

To make the sheet functional, enter a subtraction formula in the Difference column. Subtract the Actual Amount from the Planned Amount for each row. This will instantly show you if you are under budget or if you have overspent in a specific category.

Finally, create a summary row at the bottom of the page. Subtract your total expenses from your total income to find your net balance. To make the sheet more visual, you can use conditional formatting to turn cells red whenever the difference becomes a negative number.