Anand Kumria wrote:

> > Having said that, if you take money, organise meetings, etc, etc... you
> > really DO have an obligation to keep the books. Surely some where in this
> > conglomeration of computing talent, someone knows how to keep a spread
> > sheet. Can't be that hard. Nothing clever. Just a spread sheet.
> 
> Actually the answer is no.
> 
> Surprising isn't it?
> 
> For the last two years we have no one with this mystical 'spread sheet talent'
> sally forth and say "Yes, I'll be the Slug treasurer".

Okay, basic accounting for small organisations, like Slug.

Start with a monthly/periodic financial report like this.

Balance at beginning of month              $xyz.  in bank
                                             $q.  in hand

                                           $qpr   in total (A)

Income (break down into categories)
       Membership           $g
       Tea money            $h
       Install-Fest Profit* $j                  
       Miscellaneous        $k

       Total Income         $m (B)

Expenditure
       Administration       $n
       Cuppa Stuff          $p
       Obscure Fest Loss*   $r
       Miscellaneous        $s
 
       Total Expenditure     $t (c)

Balance at end of month                    $uvx  = A+B-C.


* For Fests, get the organisers to prepare a one page summary of income,
expenditure, two of them to sign it and attach all receipts they
have.      


Your spreadsheet is really just two pages (income & expenditure) with
columns as above and just gives a year to date. So long as you keep it
upto date, it is very easy.


--
   Terry Collins {:-)}}} Ph(02) 4627 2186 Fax(02) 4628 7861  
   email: [EMAIL PROTECTED]  www: http://www.woa.com.au  
   WOA Computer Services <lan/wan, linux/unix, novell>

 "People without trees are like fish without clean water"

-- 
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://slug.org.au/lists/listinfo/slug

Reply via email to