# Free Wedding Budget Tracker for Google Sheets (2024 Update)

May 8, 2024

## Wedding Budget Tracker Template for Google Sheets

Feel free to make a copy of this free and simple wedding budget tracker and customize it as you see fit.

## Simple Wedding Budget Tracker in Google Sheets

Below we outline the steps on how to make a simple wedding budget tracker in Google Sheets:

### Step 2: Set Up Your Categories

A1: Type Category. This column will list all the categories for your wedding expenses, like venue, catering, attire, etc.

B1: Type Budgeted Amount. Here, you'll enter the amount you plan to spend on each category.

C1: Type Actual Amount. This is where you'll record what you actually spend.

D1: Type Difference. This column will calculate the difference between your budgeted and actual amounts.

Click on row 1 to select it. Use the toolbar to make the text bold, change its size, or center it to make your headings stand out.

### Step 4: Enter Your Categories and Budgeted Amounts

Start in cell A2 and list all your categories. In column B (next to each category), enter your budgeted amounts for each.

### Step 5: Use Formulas for the Difference

In cell D2, enter the formula: =B2-C2. This formula will subtract the actual amount from the budgeted amount to show your over or under spending.

Drag the fill handle (a small square at the bottom right corner of the cell) down from D2 to auto-fill this formula for all your categories.

### Step 6: Track Your Spending

As you pay for services and items, enter the costs in the Actual Amount column. Watch the Difference column automatically update to reflect how well you're sticking to your budget.

Below your list of categories, add a row for totals. For example, our last category is in A4, so we type Total in A5.

In B5 (under Budgeted Amount), use the SUM function: =SUM(B2:B4) to total your budgeted amounts.

Repeat this for the Actual Amount and Difference columns. Here, we changed the background colors for the cells as well so it's easy to tell the difference.

### Step 8: Share Your Budget Tracker

If you're planning your wedding with a partner or planner, share your spreadsheet by clicking the “Share” button in the top right corner.