Social Club Accounting Spreadsheet

Club Resource Kit Generic Profit and Loss Statements - Budget v Actual Directions for use: The following spreadsheets have been designed to assist club administrators in the day to day running of their clubs. The spreadsheets can assist club treasurers with yearly budget preparations and financial reporting. This file contains the following information (in separate tabs along the bottom of the spreadsheet): a) A budget template ('Budget Profit & Loss') b) An actual profit & loss statement template ('Actual Profit & Loss') c) A balance sheet template ('Actual Balance Sheet') d) A cash flow statement template ('Actual Cash Flow') e) A cash book template ('Cash Book') f) A daily takings template ('Takings') Formulas have been entered for ease of use. Income and expenditure sub-headings can be changed to suit club's specific needs. If you need to insert rows please do so prior to the 'Total' row as to not affect the formulas. Where cells are highlighted in RED there are formulas in here which flow from another spreadsheet . Please complete information in the Calc spreadsheet - this will automatically provide figures for you.

spreadsheet .

(Enter Club Name here) BUDGETED PROFIT & LOSS STATEMENT FOR THE PERIOD (Enter period here) Oct-01

Nov-01

Dec-01

Jan-02

Feb-02

Mar-02

Apr-02

May-02

Jun-02

Jul-02

Aug-02

Sep-02 Total

Actual 99/00

Variance

INCOME Membership Subscriptions Canteen Income Donations Sponsorship Fund Raising Social Gate Receipts Facility & Hall Hire Interest Received Raffle Receipts Social Club/Bar Takings Merchandise Signage Other Events Grants Sundry Income Total Income

-

-

-

-

-

-

-

-

-

-

-

-

-

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -

-

EXPENSES Administration Expenses Advertising & Promotion Affiliation Fees Amortisation Audit Fees Bank Charges Cleaning Depreciation Raffle Electricity & Gas Fund Raising Insurance Telephone Social Club Interest Paid Canteen Equipment Ground Hire Facility Hire Grounds Maintenance Coaching Payments Player Payments Trophies Uniforms Rent

-

0 0

-

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Sundry Expenses

-

0

Total Expenses

-

-

-

-

-

-

-

-

-

-

-

-

-

-

$0

NET PROFIT/(LOSS)

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

(Enter Club Name here) ACTUAL PROFIT & LOSS STATEMENT FOR THE PERIOD (Enter period here) Oct-01

Nov-01

Dec-01

Jan-02

Feb-02

Mar-02

Apr-02

May-02

Jun-02

Jul-02

Aug-02

Sep-02 Total

Variance to budget

Budget

Last Year Actual

Variance to Last Year

INCOME Membership Subscriptions Canteen Income Donations Sponsorship Fund Raising Social Gate Receipts Facility & Hall Hire Interest Received Raffle Receipts Social Club/Bar Takings Merchandise Signage Other Events Grants Sundry Income Total Income

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0 0

-

-

-

-

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

-

-

EXPENSES Administration Expenses Advertising & Promotion Affiliation Fees Amortisation Audit Fees Bank Charges Cleaning Depreciation Raffle Electricity & Gas Fund Raising Insurance Telephone Social Club Interest Paid Canteen Equipment Ground Hire Facility Hire Grounds Maintenance Coaching Payments Player Payments Trophies Uniforms Rent

Sundry Expenses

-

-

0

-

-

0

-

-

$0

$0

Total Expenses

-

-

-

-

-

-

-

-

-

-

-

-

-

-

NET PROFIT/(LOSS)

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

(Enter Club Name here) BALANCE SHEET AS AT (Include date)

9/30/2002

9/30/2001

0

0

0

0

0

0

TOTAL NON CURRENT ASSETS

0

0

TOTAL ASSETS

0

0

0

0

TOTAL NON CURRENT LIABILITIES

0

0

TOTAL LIABILITIES

0

0

TOTAL NET ASSETS

0

0

MEMBERS FUNDS Represented by: Revaluation reserve of leasehold property Current Year Profit/(Loss) Accumulated Profits

0 0

TOTAL MEMBERS FUNDS

0

CURRENT ASSETS XXX Bank Account XXX Cash Management Account Cash on Hand Bond for rented premises Stock on Hand Receivables Other TOTAL CURRENT ASSETS

NON CURRENT ASSETS Fixed Assets Less: Accumulated Depreciation

Leasehold Improvements Less: Accumulated Amortisation

Formation Costs Other

CURRENT LIABILITIES XXX Bank Account Provision for audit fees Provision for accounting fees Trade Creditors Other TOTAL CURRENT LIABILITIES

NON CURRENT LIABILITIES Loan Members Loans - unsecured Other

0

(Enter Club Name here) STATEMENT OF CASH FLOWS (Enter date here)

2002

2001

CASH FLOWS FROM OPERATING ACTIVITIES CASH RECEIPTS Membership Gate takings Canteen Donations Other

0 0 0 0 0

TOTAL CASH RECEIPTS

0

CASH PAYMENTS Club related activities Building occupancy (repairs/rent/rates) Canteen Equipment Other

0 0 0 0 0

TOTAL CASH PAYMENTS

0

0

NET CASH FLOWS FROM /(USED IN) OPERATING ACTIVITIES

0

0

Opening Bank Balance

0

Closing Bank Balance

0

0

0

(Enter Club Name here) CASH BOOK (Enter date here) CASH RECEIPTS Date

Particulars

Membership

Total for the Year

Gate takings

0

Canteen

0

Donations

0

Other

0

Total

Receipt #

Banked Amount

Cheque #

Banked Amount

0 0 0 0 0 0 0 0 0 0

0

CASH PAYMENTS Date

Particulars

Total for the Year

Club related activities

Building occupancy (repairs/rent/rates)

0

Canteen

0

Equipment

0

Other

0

Total

0

0 0 0 0 0 0 0 0 0 0

(Enter Club Name here) DAILY TAKINGS for the Bar/Canteen/Kitchen = Todays Date

STARTING FLOAT Sales Raffle Expenses TOTAL CASH AT END

0

Less FLOAT

0

TOTAL CASH COLLECTED

0