[Eg-oversight-board] Evergreen financial update as of 2015-07-13

[Ben Shum]

Hi Tim,

I'm going to link to a plain text of my pastes (since my gmail does
weird formatting and it confused me for ages too till I saw the exact
spacing):  http://list.evergreen-ils.org/pipermail/eg-oversight-board/2015-July/001091.html

The special element that isn't immediately obvious sometimes is that
there are three major headings initially:  "Expenses:Evergreen,
Income:Evergreen, and Unearned
Income:Evergreen:Conferences:Registrations".  The rest of the content
are sub-bullet items that are more descriptive of those three major
areas.

So if you only take the three major areas and add those up, then you
reach the full total as indicated.

The confusion that sometimes occurs next (and the major point I think
Ruth Frasur was trying to spell out for us during the last
discussions) is how sometimes the sub-divided accounting does not add
up to the totals.  My current analysis is that this occurs because of
label variations in the comments describing the different types of
entries in the ledger.  For example, under "Materials" at $8,506.92
sub-total, you can see "Badges" for $3,506.09 and "T-Shirts" for
$431.85 which total up to only $3937.94.  So where is the rest of the
"Materials" lines that add up to the final subtotal of $8,506.92?
They're in the ledger, but just not descriptive beyond "Materials" vs.
"Materials:Badge" or whatnot.  Maybe if there was a "Materials:Misc",
then we'd see everything else show up as "Misc" under the line.

Clarifying the nature of these gaps in the comments for each given
entry for the ledger would be the natural next step in my opinion
towards producing a ledger statement that does not invoke confusion.

PS:  For the summary, I did not include the Conservancy entries, but I
have generated these as well now:

         $-22,606.62  Income:Conservancy
         $-22,571.20    Donations
              $-0.74    Interest:Dividend
             $-34.68    Royalties
--------------------
         $-22,606.62

That constitutes the amounts that the ledger records as having gone
towards Conservancy so far in the history of the project.  We could
add this to the complete summary as one giant statement I think, as
long as we remembered that the money for Conservancy isn't usable by
the Evergreen project.  I think this is why the original ledger
commands skipped over including statements about Conservancy's
donations.

-- Ben

On Mon, Jul 13, 2015 at 2:01 PM, Tim Spindler <tjspindler at gmail.com> wrote:
> Ben,
>
> I'm not sure if I'm missing something put I put this in a spreadsheet and
> the balance I get is different than 34691.86
>
> Tim
>
> On Mon, Jul 13, 2015 at 1:43 PM, Ben Shum <bshum at biblio.org> wrote:
>>
>> Hi,
>>
>> Here is the summary as of today 2015-07-13.  I know that we're still
>> discussing how this information is presented, but I am including it
>> anyways for the next EOB meeting.
>>
>>          $198,014.38  Expenses:Evergreen
>>            $2,885.52    Banking Fees
>>          $183,638.42    Conferences
>>           $25,321.45      AV
>>           $30,569.03      Food
>>            $8,227.54      Honoraria
>>            $8,506.92      Materials
>>            $3,506.09        Badges
>>              $431.85        T-Shirts
>>              $958.30      Services:Registration
>>              $923.15      Travel
>>          $109,132.04      Venue
>>           $59,673.00        Food
>>               $70.02    Corporate Tax
>>              $488.51    Currency Conversion
>>            $6,250.00    Development
>>              $200.00    Grants
>>            $3,500.00    Graphic Design
>>               $72.00    Hosting:Domains
>>               $23.74    Postage
>>              $212.49    Promotional Items
>>               $43.43    Sales Tax
>>               $18.59      CA
>>               $24.84      MA
>>               $15.25    Shipping
>>              $615.00    Trademark:Registration
>>         $-211,746.94  Income:Evergreen
>>             $-332.50    Advertising
>>         $-132,749.78    Conferences
>>         $-105,214.28      Registrations
>>          $-26,838.00      Sponsorship
>>              $-65.51    Currency Conversion
>>          $-77,606.94    Donations
>>               $-9.51    Interest:Dividend
>>             $-312.19    Royalties
>>             $-670.50    Sales
>>          $-20,959.31  Unearned Income:Evergreen:Conferences:Registrations
>> --------------------
>>          $-34,691.86
>>
>> I did decide to compare the information between last time 2015-06-17
>> and today's and can see that for expenses, there's a new line item for
>> "Promotional Items" and the inclusion of a split Sales Tax entry for
>> "CA" in addition to "MA".  For income, the "Donations" block went up
>> because of contributions made for Outreach-related activities.
>>
>> Regards,
>>
>> -- Ben
>>
>> --
>> Benjamin Shum
>> Evergreen Systems Manager
>> Bibliomation, Inc.
>> 24 Wooster Ave.
>> Waterbury, CT 06708
>> 203-577-4070, ext. 113
>> _______________________________________________
>> eg-oversight-board mailing list
>> eg-oversight-board at list.evergreen-ils.org
>> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/eg-oversight-board
>
>
>
>
> --
> Tim Spindler
> tjspindler at gmail.com
>
> P   Go Green - Save a tree! Please don't print this e-mail unless it's
> really necessary.
>
>



-- 
Benjamin Shum
Evergreen Systems Manager
Bibliomation, Inc.
24 Wooster Ave.
Waterbury, CT 06708
203-577-4070, ext. 113