Nigerian Wedding Budget Spreadsheet: Costs & Setup

How-to basics · Updated November 21, 2026

A Nigerian wedding budget spreadsheet is a shared, item-by-item plan for what each event will cost, what vendors have quoted, what has actually been spent and what remains unpaid. In Excel for Microsoft 365, set up columns for category, item, budget, quote, actual cost, amount paid, balance and due date; then use simple formulas to keep the totals current.

Why a Nigerian wedding budget needs its own plan

Many Nigerian weddings involve more than one gathering or ceremony: a traditional wedding, a church or other religious service, a civil ceremony, a reception, or a combination of these. The sequence, names and expectations vary by family, faith, culture and location. A spreadsheet helps you see whether a cost belongs to one event or is shared across several, rather than accidentally budgeting for the same item twice.

Planning can also involve several decision-makers. The couple, parents, relatives and friends may contribute money or take responsibility for particular purchases. Record who is paying for each item and whether a contribution is promised, received or still uncertain. A hoped-for contribution is not the same as money available to pay a deposit.

Use the workbook as a planning record, not as a claim about what a wedding should cost. Venue prices, food, transport, clothing and vendor fees differ widely by city, guest count, date, service level and negotiation. There is no single reliable national price list.

A practical spreadsheet layout

Start with a main sheet named Budget. One row should represent one purchasable item or service, not a broad heading such as “reception.” This makes it easier to compare a quote with the original plan and to see which costs are unpaid.

  • Event: traditional ceremony, reception, religious service or another event in your schedule.
  • Category: venue, food, clothing, photography, transport or another spending group.
  • Item or vendor: a specific service, product or supplier.
  • Budgeted amount: the amount you have allocated before selecting a vendor.
  • Quoted amount: the current written offer, including any stated fees.
  • Actual amount: the final agreed or invoiced cost; update it when the amount becomes known.
  • Amount paid and balance: track deposits and later payments separately.
  • Due date, owner and status: note when money is due, who is following up and whether the item is planned, booked, paid or cancelled.

In Excel, put these headings in columns A through I in this order: Event, Category, Item or vendor, Budgeted, Quoted, Actual, Paid, Balance, Due date. Add Owner and Status in columns J and K if useful. Keep all money values in naira and format the amount columns consistently. If a vendor quotes in another currency, record the original currency and the exchange-rate assumption in a separate note; do not quietly mix currencies in a naira total.

Categories to include, and what not to assume

Build the list from the events you are actually holding. Typical planning headings might include venue and furniture, food and drinks, clothing and accessories, photography and video, music or entertainment, decoration, invitations, transport, accommodation, beauty services, gifts, and administrative or religious arrangements where relevant. Some expenses may be shared across the day; others belong only to one ceremony.

Traditional wedding customs and family expectations are not identical across Nigeria. Discuss the appropriate items with the people involved rather than treating a generic internet checklist as a rule. If there are customary items, family gifts or other agreed obligations, list them in language everyone understands, identify the person responsible for arranging them, and confirm whether the amount is a purchase cost, a contribution or something handled outside the couple’s cash budget.

Guest count can drive several costs at once. Keep a current expected count and a confirmed count if invitations are still changing. Catering, seating, drinks, invitations and transport may respond differently to the final number, so avoid multiplying every category by the same per-person rate.

Build the workbook step by step

  1. Agree on the available ceiling. Separate money already available from contributions that are only being discussed. Decide whether the budget includes all events, just the couple’s share, or a wider family plan.
  2. List events and decisions. Write down the ceremony dates and the major choices that affect cost, such as venue, guest range, meal format and clothing arrangements.
  3. Enter line items. Add a separate row for each meaningful cost. Split a bundled vendor package into components when doing so helps you compare offers or track payments.
  4. Set a budget before accepting quotes. Use the Budgeted column as your planning limit and the Quoted column for the supplier’s current offer. Record what the quote includes and when it expires in a notes column or a separate Notes sheet.
  5. Update commitments and payments. Once a supplier is selected, note the agreed amount, deposit, payment dates and cancellation terms from the written agreement. Update the actual amount and paid amount when transactions occur.
  6. Review it together on a schedule. A brief weekly review is useful during active booking. Assign one person to maintain the workbook, and agree that significant changes are recorded rather than left in chat messages.

In Microsoft 365 for Windows, select the headings and data, then use Insert > Table to make the range filterable. This makes it easier to view only one event, vendor status or category. Excel for Mac also has Insert > Table; the ribbon appearance can vary slightly by update. Save the workbook somewhere the intended collaborators can access, and be deliberate about who can edit it.

Useful formulas for totals and balances

These formulas use ordinary cell ranges and work in Excel for Microsoft 365. Put the formula in the indicated cell, then copy it down where appropriate. Format the result as currency or a number with separators; formatting changes how a value looks, not its underlying arithmetic.

With Budgeted amounts in D2:D100, enter this in a summary cell to add the planned line-item budget: =SUM(D2:D100). For example, if the only entries are 2,250,000 and 1,200,000, the result is 3,450,000 naira. Extend the range if you add rows below row 100.

With Actual in F2 and Paid in G2, enter this in H2 for the remaining balance on that row, then copy it down: =IF(F2="",D2,F2)-G2. It uses the budgeted amount until an actual cost is entered, then uses the actual amount, and subtracts payments already made. If D2 is 2,400,000, F2 is 2,250,000 and G2 is 900,000, H2 returns 1,350,000. If the final cost is not known, treat the displayed balance as a planning estimate, not a confirmed bill.

For a per-person estimate, if B2 contains the planned guest count and C2 contains the quoted food cost per guest, enter this in D2: =B2*C2. With 250 guests and a quote of 18,000 naira per guest, the estimate is 4,500,000 naira. Confirm whether the quote includes service, delivery, drinks, taxes or other charges; the multiplication cannot account for exclusions that were not entered.

Illustrative budget example

The table below shows how categories could be grouped for a hypothetical plan. These amounts are arithmetic examples only, not current Nigerian market rates or a recommended spending level. Actual quotes may be much lower or higher, and the categories should match the specific wedding.

Example category Illustrative budget (NGN)
Food and drinks 2,250,000
Venue and furniture 1,200,000
Clothing and accessories 900,000
Photography and video 650,000
Decoration 500,000
Music and entertainment 400,000
Transport 300,000
Invitations and printing 250,000
Contingency allocation 250,000
Total 6,700,000

The total is 6,700,000 naira when those nine illustrative amounts are added. A contingency is a planned buffer for surprises, not a fee or an invitation to spend the entire amount. Set its size based on your own uncertainty and capacity, and keep it visible rather than hiding it inside unrelated line items.

Quotes, contributions and changing prices

Ask vendors for written quotes that specify the service, quantity, date, location, included items, payment schedule and validity period. Compare like with like: two catering offers may differ because one includes drinks or service staff and the other does not. In the spreadsheet, keep the quote date and a short note about exclusions. Recheck any quote that has expired or was given well before the event.

Track contributions in a separate sheet with columns for contributor, intended purpose, amount expected, amount received and date received. Link each contribution to an agreed category if the giver has specified its use. Do not subtract an unreceived promise from the available cash total. That distinction helps avoid booking a service on funds that may arrive late or change.

For each deposit, retain the receipt and the vendor’s written terms outside the spreadsheet as well. A spreadsheet can remind you when money is due, but it does not replace an agreement. If you consider borrowing to cover costs, check the actual repayment terms with the lender or a qualified professional; this budget template is not financial, tax, investment or legal advice.

Common spreadsheet problems to avoid

  • Counting a contribution twice: record a family-paid item either as a cost with a matching contribution or as an item outside the couple’s budget, and label the approach clearly.
  • Mixing estimates and confirmed prices: keep Budgeted, Quoted and Actual as separate columns so a rough allowance is not mistaken for a contracted price.
  • Forgetting payment timing: a cost can be affordable overall but difficult to pay if several deposits fall in the same week. Use due dates and paid amounts to see cash needs.
  • Leaving out small purchases: printing, delivery, last-minute supplies and transport changes can accumulate. Add them when identified rather than using a vague miscellaneous figure for everything.
  • Overwriting formulas: protect the formula column from accidental edits by keeping formulas consistent and reviewing totals after changes. Maintain a dated backup or version history.
  • Sharing too broadly: a workbook can contain contribution amounts and personal details. Share access only with people who need it, and avoid storing sensitive bank or identity information in the budget.

Frequently Asked Questions

Can I use this Nigerian wedding budget spreadsheet in Google Sheets?
Yes. The column layout and basic SUM, IF and multiplication formulas also work in Google Sheets. Menu names and some formatting steps differ, but the underlying budget structure does not depend on Excel-only features.

Should traditional and white wedding costs be in separate spreadsheets?
Usually, one workbook with an Event column is easier to reconcile because shared costs and the combined total remain visible. Use separate sheets only if different groups need separate working views; keep a reliable combined summary so the overall ceiling is not lost.

How do I handle a vendor quote in dollars or another currency?
Record the quoted amount and currency clearly, along with the date and the exchange-rate assumption used for planning. Convert it into naira only in a separate planning field, and update that estimate if the rate or the vendor’s payment terms change.

What contingency should I put in the budget?
There is no universal percentage that fits every wedding. Choose an amount you can actually set aside after listing known costs, and consider how many details are still uncertain. Treat it as a buffer and review it as real quotes replace early estimates.

How often should I update the spreadsheet?
Update it whenever a quote changes, a booking is confirmed, a payment is made, a guest-count assumption changes or a new cost appears. During the busiest planning period, a regular weekly review can catch due dates and overspending before they become urgent.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.