Model Boat Mayhem

Please login or register.

Login with username, password and session length.
Pages: [1]   Go Down

Author Topic: club accounts and membership  (Read 871 times)

Klunk

  • Global Moderator
  • Full Mayhemer
  • *****
  • Offline Offline
  • Posts: 4,877
  • If you know who I am, please remind me!!
  • Location: luton, beds
club accounts and membership
« on: September 29, 2017, 04:07:42 am »

Im looking for a simple easy to use program for club accounts and to track membership.
At present i have membership in excel, but our accounts are still old school in a book so looking to amalgamate the 2 items....and saving a job on the committee!
Any ideas.... preferable free software is best.
Logged
SECRETARY - LUTON AND DISTRICT MODEL BOAT CLUB
full time penguin

kinmel

  • Full Mayhemer
  • *****
  • Offline Offline
  • Posts: 759
  • Colwyn Bay M.B.C.
  • Location: Conwy, in sunny north Wales
Re: club accounts and membership
« Reply #1 on: September 29, 2017, 07:11:46 am »

It can all be done in Excel. that is how I did it while temporary Treasurer.

PM. me an email address and I will send you a copy of the spreadsheet and you can see how it works and adapt it to suit you.
Logged

Klunk

  • Global Moderator
  • Full Mayhemer
  • *****
  • Offline Offline
  • Posts: 4,877
  • If you know who I am, please remind me!!
  • Location: luton, beds
Re: club accounts and membership
« Reply #2 on: September 29, 2017, 07:26:46 am »

Thanks kinmel
Logged
SECRETARY - LUTON AND DISTRICT MODEL BOAT CLUB
full time penguin

malcolmfrary

  • Full Mayhemer
  • *****
  • Offline Offline
  • Posts: 5,773
  • Location: Blackpool, Lancs, UK
Re: club accounts and membership
« Reply #3 on: September 29, 2017, 09:12:13 am »

Just add another column to the right, call it "Paid" or something equally imaginative and put the amount there.  Do a "Sum" at the bottom of the column, you then know your clubs income for the year.  Save the old spreadsheet and start a new one for each club year, you automatically know who has paid and what your current membership income is.  Ours is done using LibreOffice, but at this level, everything is the same.
Logged
"With the right tool, you can break anything" - Garfield

TheLongBuild

  • Full Mayhemer
  • *****
  • Online Online
  • Posts: 4,412
  • Build em, and play hard..
  • Location: Everywhere, But Nowhere !! But mainly in England....
    • Runcorn & District Scale Model Boats
Re: club accounts and membership
« Reply #4 on: September 30, 2017, 09:54:22 pm »


I Just use Excel
I Have the Cash Book Page and then the summary page for the Annual Accounts to summarise the Expenses / Income using Vlookups etc.
Pages: [1]   Go Up