treasurer for scout group

taskeytaskey Font Of All KnowledgeRegistered Posts: 1,800
evening all

i have recently become the treasurer for our local scout group. just wondering if anyone else does this and where to start on the accounts. basically it has never had anyone in this position before so the scout leader has the bank card in his wallet - eeek!!! and that is how it run. could anyone email me some basic excel templates i could use for bank rec's, payments and receipts. it only needs to be basic as it is not a busy group.

all help would be greatl appreciated.

many thanks in advance

tracy

tracy.askey@yahoo.co.uk

Comments

  • JanJan Experienced Mentor Registered Posts: 654
    I've emailed the spreadsheet I use for our motor club, basic but does the job adequately.

    Well done for volunteering for the "job" !!
    stu441982
  • taskeytaskey Font Of All Knowledge Registered Posts: 1,800
    thanks jan, i have not received the email, could you possibly try agan.

    many thanks

    tracy

    tracy.askey@yahoo.co.uk

    or

    tracy.askey@mac.com
  • JanJan Experienced Mentor Registered Posts: 654
    Sorry Tracy, just checked my emails tonight & yours was still sat in the out box, DOH! Think it was maybe a bit late :laugh:
    stu441982
  • stu441982stu441982 Registered Posts: 1
    Hi Tracy.. I'm thinking about doing the same thing.. How did you get on and could one of you please send me the spreadsheets too?
  • ChristinaChristina Just Joined Registered Posts: 31
    I've tried several of the free software offerings and the only one that came close to useful for our Group was Quickfile - which is now not free :/ but not hugely expensive the last time I looked. And it may be possible to get it half-price if you are able to use/Quickfile will accept your District's charity number.

    Although VT Cashbook is simple you'd still need spreadsheets to keep track of subs and payments for camps, etc, and also keeping track of restricted funds. This is where Quickfile's project tagging really comes in handy.

    Stu, does your group use Online Scout Manager? Apparently they do 'financial accounts' with Gold or Gold+ membership. Though we have the Gold subscription and I can't find how to access the financial accounts part so can't tell you anything about it I'm afraid. But it may be worth looking into.
  • Leighs5Leighs5 Registered Posts: 4
    Hi, I too have just started as the treasurer of out local scout group, and would appreciate a spreadsheet for the accounting side please.
  • KoopaCooperKoopaCooper London, UKMAAT, AATQB Posts: 158
    I was asked if I'd be interested in being the Treasurer for my Scout Group too, as the other Leaders know that I'm now a junior accountant...but then it turned out that because I'm a Leader, I'm automatically disqualified from any positions on the Group Exec committee (Treasurer included). Oops! xD

    So, @taskey ...

    "basically it has never had anyone in this position before"

    You mean you're the Group's first Treasurer, then? Or just that nobody before you had any solid accounts/books knowledge to go on, and just kinda winged it? xD
    Accounts Assistant, ғɪᴀʙ ᴀᴀᴛǫʙ ᴍᴀᴀᴛ

    AAT
    Level 2 - 17 Jun 2015
    Level 3 - 22 Jan 2016
    Level 4 - 19 Dec 2017
    MAAT - 27 Mar 2018

    ACCA...
  • Leighs5Leighs5 Registered Posts: 4
    I took over in December, the past treasurer, retired due to ill health. The accounts were paper based, I have been tasked (and would prefer) spreadsheets and online banking with dual authorisation. I have experience of Sage line 50, Sage 200 (CRM) ITrent, Oracle, NSPIS and Origin. I am an intermediate user of Excel, and would prefer to not have to create the spreadsheet from scratch. I hope the above has clarified my position, also I am retired. Many thanks in anticipation of your assistance.
  • ChristinaChristina Just Joined Registered Posts: 31
    @Leighs5 have you been in touch with your District Treasurer? They might have something, or know someone who does. They should be supporting you anyway.
  • KoopaCooperKoopaCooper London, UKMAAT, AATQB Posts: 158
    @Christina makes an excellent point - the District Treasurer, maybe even the County Treasurer, should have some ability to be able to help you out (if they aren't too busy, that is). You could also try contacting the Treasurers of other Groups in your District. Any one of them may be able to help also.

    Best of luck!
    Accounts Assistant, ғɪᴀʙ ᴀᴀᴛǫʙ ᴍᴀᴀᴛ

    AAT
    Level 2 - 17 Jun 2015
    Level 3 - 22 Jan 2016
    Level 4 - 19 Dec 2017
    MAAT - 27 Mar 2018

    ACCA...
    Christina
  • Leighs5Leighs5 Registered Posts: 4
    Many thanks, I have been InTouch with the District treasurer, who has kindly provided an excellent cash book with reconciliation and year end accounts.
    Christina
  • KoopaCooperKoopaCooper London, UKMAAT, AATQB Posts: 158
    Leighs5 said:

    Many thanks, I have been InTouch with the District treasurer, who has kindly provided an excellent cash book with reconciliation and year end accounts.

    Good to know there are reliable, helpful District Execs out there. Ours is...eh. :P (Par for the course with Lambeth, sadly...! lol)
    Accounts Assistant, ғɪᴀʙ ᴀᴀᴛǫʙ ᴍᴀᴀᴛ

    AAT
    Level 2 - 17 Jun 2015
    Level 3 - 22 Jan 2016
    Level 4 - 19 Dec 2017
    MAAT - 27 Mar 2018

    ACCA...
  • Leighs5Leighs5 Registered Posts: 4
    Anyone use Access for invoicing?
  • David BallantyneDavid Ballantyne DurhamRegistered Posts: 78
    Just for info, you could use either one of the following free open software finance packages. They would both be perfectly suitable for small scout group accounts.

    Gnucash
    KMyMoney
    David Ballantyne
    Connect with me on LinkedIn!
    Ballantyne Accountants
Sign In or Register to comment.