1. Welcome Guest to the new look forum. For more information refer to this thread
    Dismiss Notice

Question? Unit accounts password

Discussion in 'Finances and Fundraising' started by RHJones19, Sep 28, 2017.

  1. RHJones19

    RHJones19 Beginner (10+ posts)

    Joined:
    Nov 10, 2010
    Messages:
    17
    Likes Received:
    0
    Hi all

    I have agreed to be a Guide units admin 'clerk', which will be including dealing with the unit finances. I have downloaded the unit accounts pack from the website, but I want to view the equations/codes they're using. Does anyone know what this password is or how I can find it out

    Thanks

    Roz
     
  2. Tregi

    Tregi Veteran (100+ posts)

    Joined:
    Jun 2, 2008
    Messages:
    1,840
    Likes Received:
    20
    Hi,
    The accounts package is all locked down so it can't be altered. What are you looking to see on it?
    It's actually a pretty simple spreadsheet that just copies information from one cell to another, adds up colums and takes them away elsewhere!

    Are you looking to see if it can be altered or just intriged?

    Sent from my SM-G850F using Tapatalk
     
  3. caroline68

    caroline68 Regular (50+ posts)

    Joined:
    Aug 14, 2015
    Messages:
    55
    Likes Received:
    17
    I love, i just add in the figures and it does all the adding up and carrying over to other pages etc. You can't move boxes (if you wanted to put in another order for example) like you would in excel, it doesn't like that! I think its locked down so that peopel like me who don't have a huge amount of accounting experience can use it without getting into a muddle!
    My Guide leader friend is an accountant and works with spreadsheets all the time, so she finds it very annoying that she can't do lots of the things she would normally do with a spreadsheet and so has made her own!
     
  4. RHJones19

    RHJones19 Beginner (10+ posts)

    Joined:
    Nov 10, 2010
    Messages:
    17
    Likes Received:
    0
    I'm trying to customise a streadsheet so that it is suitable to the needs of the unit and I want to know what equations are being used and how they set it up to automatically carry over information
     
  5. Quack

    Quack Veteran (100+ posts) Staff Member Moderator GuiderPlus

    Joined:
    Jul 11, 2008
    Messages:
    4,579
    Likes Received:
    137
    I use my own version which is very similar layout and does a simple income & expenditure account. My version has cash, bank, transfers ( cash to bank, bank to cash) and the various analysis columns. I've used it for years, even before the official version came out. Not everyone has spreadsheet or accounting experience so using the official version allows them to keep a record which provides the necessary formats and layouts.

    If you are setting up your own, I wouldn't try and copy the official version, but do your own thing so you understand the mechanics etc. The important thing is that the income and expenditure account at the end of the year includes the essential catagories, subs, rent, activities, events etc and you can see how the unit has performed, ie made money or lost money and what the balances brought and carried forward are.
     
  6. Tregi

    Tregi Veteran (100+ posts)

    Joined:
    Jun 2, 2008
    Messages:
    1,840
    Likes Received:
    20
    What are your needs that you are trying to meet??? It may be that the spreadsheet already does it, but you aren't aware of it....
     
  7. foreverandalways

    foreverandalways Veteran (100+ posts)

    Joined:
    Nov 14, 2008
    Messages:
    160
    Likes Received:
    0
    I have a Mac that doesn't have Excel, only the Apple equivalent - Numbers. The accounts pack has converted to a Numbers document and all the password protection has come out of it.

    Do let me know if you want to know anything specific, but the only thing I've found is useful in the editable version is adding pages so all my information is in the one document!
     

Share This Page