# Wedding and event budget planner (Excel) (free Excel)

> Suppliers with agreed prices, deposits and balances, due dates and late payments, a payments log, a guest list with replies and tables, and a budget summary.

Source: https://softwiro.com/templates/wedding-event-planner
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Wedding and event budget planner (Excel)

A free Excel template for a wedding or event budget. Enter your suppliers, the amount agreed with each and the final payment date, then log every deposit and payment. The sheet calculates the amount paid, the balance and each supplier's status (paid, balance due, payment approaching or late). Add your guest list with replies and tables, and it counts confirmed attendance. The "الملخص" (Summary) then compares the budget with what you have agreed and what you have paid.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-wedding-event-planner.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-wedding-event-planner-blank.xlsx)

Excel file (.xlsx) · 110 KB · 7 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

## Example from the sheet

| كود المورد | المورد | الفئة | المتفق عليه | إجمالي المدفوع | المتبقي | أيام حتى السداد | الحالة |
| --- | --- | --- | --- | --- | --- | --- | --- |
| V01 | قاعة الورد | قاعة | 60,000.00 | 40,000.00 | 20,000.00 | 44 | متبقي |
| V02 | استوديو لمسة | تصوير | 15,000.00 | 5,000.00 | 10,000.00 | 47 | متبقي |
| V03 | ديكور الأحلام | ديكور وكوش | 18,000.00 | 6,000.00 | 12,000.00 | 4 | يقترب السداد |
| V04 | كيترينج السعادة | طعام وضيافة | 45,000.00 | 15,000.00 | 30,000.00 | -7 | متأخر |
| V05 | دي جي ريتم | موسيقى ودي جي | 6,000.00 | 6,000.00 | 0.00 |  | مسدد |
| V06 | مطبعة الدعوات | دعوات وتذكارات | 4,000.00 | 0.00 | 4,000.00 | 19 | متبقي |
| V07 | ستوديو التجميل | مكياج وتجميل | 5,000.00 | 1,000.00 | 4,000.00 |  | متبقي |
| V08 | سيارات الزفاف | سيارات | 3,000.00 | 3,500.00 | -500.00 |  | مدفوع زيادة |
| V09 | بدلة العريس | فستان وبدلة |  | 0.00 |  |  | بدون سعر |

Example from the “الموردون” tab (Arabic), with the numbers and formulas that are in the file.

## What is inside

- "الإعدادات" (Settings): Today's date (or =TODAY()), the event budget (150,000 in the example), the event date (18 December 2026 in the example) and the number of days before a due date at which a warning appears (7 in the example).
- "الموردون" (Suppliers): Code, supplier, category, phone, agreed amount and final payment date. The sheet then calculates the deposit paid, total paid, balance, days to the due date and status (paid, balance due, payment approaching, late, overpaid or no price). The example has nine suppliers, and the table has room for 200.
- "الدفعات" (Payments): Every amount you pay, with the date, supplier code, type (deposit, installment or final payment) and a note. The supplier name fills in automatically. Room for 2,000 payments.
- "المدعوون" (Guests): Name, group (groom's family, bride's family, friends, work colleagues, other), number of people, phone, reply status and table number. The sheet then calculates confirmed attendance and the standing of each invitation (confirmed, no table, declined or awaiting reply). Room for 500 invitations.
- "الملخص" (Summary): The budget, the amount agreed, what is left of the budget, the amount paid, the balance still owed to suppliers, overpayments, the percentage paid and the days left to the event. It also shows supplier statuses, the number of invitations, confirmed attendance, declines and replies awaited, the average agreed cost per confirmed guest, a table of suppliers by category and a table of guests by group.

The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.

## What makes it different

Open "الموردون" (Suppliers) to see who is late, whose payment date is close and how much is left for each one. Open the "الملخص" (Summary) to see whether your agreements have gone over budget, how much you have paid so far and how many guests have confirmed, without going back through messages and papers.

## How to use it

1. In the "الإعدادات" (Settings) sheet, enter today's date (or =TODAY() so it updates itself), the event budget, the event date and the number of days before a due date at which you want a warning.
2. In the "الموردون" (Suppliers) sheet, enter each supplier's code, name, category, phone, agreed amount and final payment date.
3. In the "الدفعات" (Payments) sheet, record every amount you pay: date, supplier code, amount and type (deposit, installment or final payment).
4. In the "المدعوون" (Guests) sheet, enter each invitation: name, group, number of people, reply status and table number.
5. The "الموردون" (Suppliers) sheet calculates the amount paid, deposit, balance, days to the due date and each supplier's status, and the "المدعوون" (Guests) sheet calculates confirmed attendance.
6. Open the "الملخص" (Summary) sheet to compare the budget with what you have agreed and what you have paid, and to see who is late and how many guests are confirmed.

**Before you start:**

- Supplier balance = agreed amount - total paid to them. A negative figure means you have paid more than agreed, and the status shows "مدفوع زيادة" (overpaid).
- Supplier status: "مسدد" (paid) if nothing is left, "متأخر" (late) if the due date has passed and a balance remains, "يقترب السداد" (payment approaching) if the due date is within the number of days in the "الإعدادات" (Settings) sheet, and "بدون سعر" (no price) if you have not entered the agreed amount.
- Remaining budget = event budget - total of the agreed amounts. If it is negative, your agreements have gone over budget.
- The deposit is the total of the payments marked "عربون" (deposit) for each supplier. It is part of the amount paid, not an extra amount.
- Confirmed attendance is the total number of people in invitations whose reply is "سيحضر" (will attend). An invitation with no reply entered counts as "بانتظار الرد" (awaiting reply).
- The names, figures and amounts in the example are made up. The sheet has room for 200 suppliers, 2,000 payments and 500 invitations.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-wedding-event-planner.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-wedding-event-planner-blank.xlsx)

Excel file (.xlsx) · 110 KB · 7 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: wedding and event budget (1/3)](https://softwiro.com/uploads/cheatsheets/wedding-event-planner/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/wedding-event-planner/en-1.jpg)[![Cheat sheet: wedding and event budget (2/3)](https://softwiro.com/uploads/cheatsheets/wedding-event-planner/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/wedding-event-planner/en-2.jpg)[![Cheat sheet: wedding and event budget (3/3)](https://softwiro.com/uploads/cheatsheets/wedding-event-planner/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/wedding-event-planner/en-3.jpg)

0 downloads · 3 pages

## Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

| In this sheet | In Custom Software from Softwiro |
| --- | --- |
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |

[See Custom Software from Softwiro](https://softwiro.com/contact) · [Ask for a demo](https://softwiro.com/contact)

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Frequently asked questions

### How are a supplier's balance and status calculated?

Balance = agreed amount - total of the payments made. If a balance remains and the due date has passed, the status is "متأخر" (late). If the due date is within the number of days set in the "الإعدادات" (Settings) sheet, it is "يقترب السداد" (payment approaching). If nothing remains, it is "مسدد" (paid), and if the amount paid is more than the agreed amount, it is "مدفوع زيادة" (overpaid).

### Is the deposit counted on top of the amount paid?

No. The deposit is part of the total paid. It is the total of the payments marked "عربون" (deposit) for each supplier.

### What does a negative remaining budget mean?

It means the total agreed with suppliers is more than the budget in the "الإعدادات" (Settings) sheet. In the example the agreed total is 156,000 and the budget is 150,000, so the remaining budget is -6,000.

### How is confirmed attendance calculated?

It is the total number of people in the invitations whose reply is "سيحضر" (will attend). An invitation marked "لم يرد" (no reply) or with no reply entered shows "بانتظار الرد" (awaiting reply) and is not counted.

### Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

### Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

### What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

### Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL [https://softwiro.com/api/mcp](https://softwiro.com/api/mcp), no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: [https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html](https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html)

More free templates for: Events and weddings

## More free templates

- Wedding and event hall booking sheet
- Car rental fleet tracker (Excel)
- Fleet fuel and maintenance tracker (Excel)
- Car showroom accounts sheet
- Freelancer projects, hours and invoices tracker
- Supplier purchase orders and payables tracker
- Charity donations and disbursements tracker
- Travel agency bookings tracker
- Laundry orders tracker (Excel)

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
