Building a budget spreadsheet for small eisteddfodau

A well-designed budget spreadsheet gives a small eisteddfod committee a shared view of its finances. It shows what the event is expected to cost, where income will come from, when payments are due, and how much flexibility remains if plans change. This is especially useful when several volunteers are sharing responsibility for venue hire, competitions, performers, refreshments, publicity, and administration.

The spreadsheet does not need to be complicated. A clear workbook with consistent categories and realistic estimates can support better decisions than a large file filled with unexplained figures. The aim is to create a practical financial plan that the committee can update throughout the year and use during meetings.

For local eisteddfodau, budgeting also reflects the event’s wider purpose. A surplus may help fund future workshops, support young performers, maintain traditional activities such as folk dancing and cerdd dant, or keep entry fees affordable. Financial control therefore protects the character and accessibility of the festival.

Start with a clear financial purpose

Before entering figures, agree what the budget needs to help the committee decide. A small eisteddfod may need to answer questions such as whether it can afford a second venue, whether a new competition should be introduced, or whether ticket prices need to change. These decisions give the spreadsheet a practical focus.

Set a budget period that covers the entire event cycle. For many committees, this will run from the first planning meeting through to the final payment and review after the eisteddfod. Include early commitments such as deposits, printing, insurance, adjudicator bookings, and grant applications. A budget that starts only a few weeks before the event will miss important cash pressures.

Record who is responsible for maintaining the file and how often it will be reviewed. A treasurer may own the spreadsheet, while an event secretary or programme coordinator supplies updates. Store it in a shared location with sensible access controls, and keep dated copies before major changes. This creates an audit trail without making administration burdensome.

Choose categories that reflect the event

Begin with income categories. Common headings include entry fees, ticket sales, programme sales, donations, sponsorship, grants, refreshments, stall fees, and fundraising activities. If the eisteddfod receives support from a community council, arts body, local business, or cultural fund, record each source separately. Separate figures make it easier to track conditions attached to grants and identify which activities generate reliable income.

Expenditure should be divided into useful working groups rather than one long list. Venue and facilities might include room hire, heating, cleaning, security, furniture, and accessibility arrangements. Programme and competition costs could include adjudicators, accompanists, prizes, certificates, medals, music licences, and score sheets. Marketing, catering, volunteer expenses, insurance, equipment hire, postage, and bank charges deserve their own lines when they are material.

Use a consistent level of detail. It is helpful to separate hall hire from equipment hire, but there is little value in creating separate rows for every packet of stationery. A category is useful when it helps someone understand, approve, or control spending. Add a notes column for supplier names, quotation dates, grant restrictions, or whether an amount is confirmed.

Build the workbook around decisions

A simple workbook can contain four sheets: budget summary, detailed transactions, cash flow, and assumptions. The summary presents the headline figures. The transaction sheet lists individual expected and actual amounts. The cash-flow sheet records when money is likely to arrive or leave the account. The assumptions sheet explains how estimates were calculated.

Useful columns in a detailed budget include:

Use formulas rather than repeatedly typing totals. For example, the summary can add all rows marked as income and subtract all rows marked as expenditure. Conditional formatting can highlight unpaid invoices, overspent categories, missing estimates, or grants that have not yet been confirmed. Keep formulas protected where possible, while allowing authorised volunteers to update input cells.

The summary should show expected income, expected expenditure, projected surplus or deficit, confirmed income, committed expenditure, and available cash. These measures are different. A projected surplus may include grant income that has not yet been awarded, while available cash shows what can be spent immediately. Presenting both prevents an optimistic forecast from masking a short-term cash problem.

Estimate income and expenditure honestly

Use evidence for each estimate. Previous eisteddfod accounts are a strong starting point, but update them for inflation, changes in attendance, new supplier prices, and altered venue arrangements. Ask suppliers for written quotations where possible. For income, use conservative attendance assumptions rather than relying on a sold-out event.

Separate confirmed, probable, and uncertain income. A signed sponsorship agreement belongs in a different category from a hoped-for donation. The same approach applies to spending: a booked adjudicator is a committed cost, while an optional workshop may remain a proposal. A simple status field can make this distinction visible.

Include a contingency reserve. The right amount will depend on the size and risk of the event, but a small percentage of variable costs can protect the committee from urgent transport, replacement equipment, extra cleaning, or a rise in printing costs. Do not hide contingency inside every line, because that makes it difficult to see how much flexibility remains.

A breakeven calculation can guide ticket and entry-fee decisions. If fixed costs are £3,000 and the average contribution from each attendee is £8 after variable costs, the event needs 375 attendees to cover those fixed costs. This calculation should be treated as a planning tool, not a guarantee. Free tickets, family concessions, complimentary seats, and unsold programmes may all affect the final result.

Track cash flow throughout the planning cycle

A profitable event can still face a cash shortage if large bills arrive before ticket income or grant payments. Create monthly columns, or weekly columns during the final preparation period. Enter opening cash, expected receipts, expected payments, and closing cash for each period. This quickly shows when the bank balance may be under pressure.

Mark payments according to their actual due dates rather than the date of the event. Venue deposits, insurance, prize orders, printing, and accompanist fees may all be payable weeks in advance. Add a payment status such as planned, invoice received, approved, paid, or queried. This helps the treasurer follow up without searching through emails and paper files.

Keep restricted funds visible. A grant intended for children’s workshops or accessibility improvements should not be treated as general money. Add a funding-source column and, where necessary, a separate restricted-funds summary. This protects the committee from accidentally spending money outside the terms agreed with a funder.

Community relationships can strengthen both income and practical support. Local businesses may provide sponsorship, prizes, refreshments, or equipment, while neighbouring organisers may share supplier knowledge. Building those connections can make future budgets more realistic; resources such as organiser networking advice can help committees develop useful local and national contacts.

Compare the plan with actual results

The budget should remain active after the first approval. At each committee meeting, update actual receipts and payments, then compare them with the original estimate. A variance column can show the difference in pounds and as a percentage. Large variances should include a short explanation, such as increased hall costs, lower ticket sales, or a successful sponsorship drive.

A monthly review is usually enough during the early planning period. Increase the frequency as the event approaches, particularly when invoices and ticket income are moving quickly. Use a version date on the summary sheet so everyone knows whether the figures are current.

After the eisteddfod, complete a short financial review. Compare the final outcome with the approved budget and identify which estimates were accurate, which suppliers changed their charges, and which income sources were dependable. Record practical lessons for the next committee. This historical information becomes one of the most valuable inputs for future budgeting.

The post-event review should also consider value and participation. A low-cost activity may have attracted many children or strengthened a traditional art form even if it did not generate income. Financial reporting can recognise these outcomes alongside the final surplus or deficit, giving the committee a fuller picture of the eisteddfod’s community benefit.

Use a simple comparison framework

A budget is easier to discuss when key categories are visible in one place. The following format can be adapted to a spreadsheet summary and expanded with actual figures, payment dates, and responsible volunteers.

Budget area Estimated income Estimated cost Useful evidence Review point
Tickets and entries £ £ Previous attendance and entry records Compare sales with capacity
Venue and facilities £0 £ Written quotation and deposit terms Check access and cleaning costs
Competitions and prizes £0 £ Adjudicator rates and prize schedule Confirm commitments early
Grants and sponsorship £ £0 Award letters and sponsor agreements Separate confirmed funds
Programme and publicity £ £ Print quote and distribution plan Monitor quantities ordered
Refreshments and stalls £ £ Supplier prices and expected demand Track stock and wastage
Workshops and cultural activity £ £ Tutor fees and participant numbers Check restricted funding
Contingency £0 £ Agreed percentage of variable costs Use only with approval

When transferring this structure into a spreadsheet, avoid merging cells or relying on colour alone. Clear labels, filters, and accessible text are more dependable for volunteers using different devices or needing screen-reader support. Use pounds consistently, show whether figures include VAT, and round estimates sensibly while retaining exact invoice values in the transaction sheet.

Make financial responsibilities practical

A committee budget works best when responsibilities are agreed in advance. One person may approve spending, another may maintain the ledger, and a third may check bank statements or invoices. For a small organisation, these roles may be shared informally, but separating approval and payment where possible provides useful oversight.

Set a spending limit for routine purchases and require committee approval for larger commitments. Keep receipts, invoices, grant correspondence, and sponsorship agreements together in a digital folder. Use file names that include the supplier, date, and amount. Good records make the annual report easier and protect volunteers if questions arise later.

Build these habits into the event timetable:

At the final meeting before the event, review the latest forecast rather than the original budget alone. Confirm that expected income is still realistic, identify any unpaid deposits, and decide who can authorise urgent purchases. This short check can prevent last-minute decisions from becoming financial surprises.

A useful spreadsheet should support confidence, accountability, and cultural ambition. When the figures are clear, committees can protect essential activities, set fair prices, and explain their decisions to funders, volunteers, performers, and the wider community. The document becomes a shared working tool rather than a file used only for reporting.

Start with last year’s accounts, create a small set of income and expenditure categories, and enter every known commitment. Add conservative forecasts, a contingency reserve, and a cash-flow view before the next planning meeting. With regular updates and clear responsibilities, even a modest local eisteddfod can manage its finances carefully while preserving the welcoming Welsh traditions that bring people together.