Running A Business

profilejacobmartin
BudgetTemplateQuarterly1.xlsx

Budget

BUDGET ACTUAL VARIANCE
Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Total
£ £ £ £ £ £ £ £ £ £ £ £ £ £ £ %
Income Income Income
Membership fees 0 Membership fees 0 Membership fees 0 0 0 0 0 ERROR:#DIV/0!
Fundraising activities 0 Fundraising activities 0 Fundraising activities 0 0 0 0 0 ERROR:#DIV/0!
Sporting events 0 Sporting events 0 Sporting events 0 0 0 0 0 ERROR:#DIV/0!
Grants 0 Grants 0 Grants 0 0 0 0 0 ERROR:#DIV/0!
Sponsorship 0 Sponsorship 0 Sponsorship 0 0 0 0 0 ERROR:#DIV/0!
Merchandise 0 Merchandise 0 Merchandise 0 0 0 0 0 ERROR:#DIV/0!
Bar 0 Bar 0 Bar 0 0 0 0 0 ERROR:#DIV/0!
Legacies 0 Legacies 0 Legacies 0 0 0 0 0 ERROR:#DIV/0!
Gifts 0 Gifts 0 Gifts 0 0 0 0 0 ERROR:#DIV/0!
Bank interest 0 Bank interest 0 Bank interest 0 0 0 0 0 ERROR:#DIV/0!
Bar 0 Bar 0 Bar 0 0 0 0 0 ERROR:#DIV/0!
Other 1 0 Other 1 0 Other 1 0 0 0 0 0 ERROR:#DIV/0!
Other 2 0 Other 2 0 Other 2 0 0 0 0 0 ERROR:#DIV/0!
Other 3 0 Other 3 0 Other 3 0 0 0 0 0 ERROR:#DIV/0!
Total income 0 0 0 0 0 Total income 0 0 0 0 0 Total income variance 0 0 0 0 0 ERROR:#DIV/0!
Expenditure Expenditure Expenditure
Staff wages 0 Staff wages 0 Staff wages 0 0 0 0 0 ERROR:#DIV/0!
Coach fees 0 Coach fees 0 Coach fees 0 0 0 0 0 ERROR:#DIV/0!
Rent and service charges 0 Rent and service charges 0 Rent and service charges 0 0 0 0 0 ERROR:#DIV/0!
Utilities 0 Utilities 0 Utilities 0 0 0 0 0 ERROR:#DIV/0!
Insurance 0 Insurance 0 Insurance 0 0 0 0 0 ERROR:#DIV/0!
Repairs 0 Repairs 0 Repairs 0 0 0 0 0 ERROR:#DIV/0!
Marketing 0 Marketing 0 Marketing 0 0 0 0 0 ERROR:#DIV/0!
Travel 0 Travel 0 Travel 0 0 0 0 0 ERROR:#DIV/0!
Sporting events 0 Sporting events 0 Sporting events 0 0 0 0 0 ERROR:#DIV/0!
Bar and merchandising costs 0 Bar and merchandising costs 0 Bar and merchandising costs 0 0 0 0 0 ERROR:#DIV/0!
Sinking fund 0 Sinking fund 0 Sinking fund 0 0 0 0 0 ERROR:#DIV/0!
Other 1 0 Other 1 0 Other 1 0 0 0 0 0 ERROR:#DIV/0!
Other 2 0 Other 2 0 Other 2 0 0 0 0 0 ERROR:#DIV/0!
Other 3 0 Other 3 0 Other 3 0 0 0 0 0 ERROR:#DIV/0!
Total expenditure 0 0 0 0 0 Total expenditure 0 0 0 0 0 Total expenditure variance 0 0 0 0 0 ERROR:#DIV/0!
Surplus / (deficit) 0 0 0 0 0 Surplus / (deficit) 0 0 0 0 0 Favourable / (adverse) variance 0 0 0 0 0 ERROR:#DIV/0!
DISCLAIMER
Information is for guidance only and does not constitute formal professional advice. As such, no reliance should be placed on the information contained in this template. In particular you should confirm the accuaracy and validy of any formulas used. Advice should be sought from the relevant expert(s) as necessary.

Sheet2

Sheet3