In this article:

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. 

wedding budget tracker google sheets

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 1: Open Google Sheets

Navigate to Google Sheets in your web browser. If you're not already signed into your Google account, you'll need to do so. Click on the "+" button to create a new spreadsheet.

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.

Step 3: Format Your Headings

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.

Step 7: Adding Totals

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. 

Regularly update your tracker with new expenses and adjustments. This will help you stay on top of your budget and make informed decisions.

We hope that this article has helped you and given you a better understanding of how to make a simple wedding budget tracker in Google Sheets. If you enjoyed this article, you might also like our articles on how to resolve the problem if your Google Sheets script editor is missing and how to remove formulas in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->