<p dir="ltr">Thank you Grace and Galen. I won't be able to fully absorb this until I am back from vacation and at a real computer, but I'm really glad that this reconciliation process is being done. It will be invaluable to the next year's conference committee, I am sure.</p>
<p dir="ltr">For the library that did not pay, if that was one of the Georgia libraries, please email me off list with the details of their registrations and what they did/did not pay, and I will pursue a resolution to that problem with the consortium leadership.</p>
<div class="gmail_extra"><br><div class="gmail_quote">On Jul 21, 2016 8:25 AM, "Grace Dunbar" <<a href="mailto:gdunbar@esilibrary.com">gdunbar@esilibrary.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi all,<div>I have spent quite a bit of time attempting to track down all the anomalies in the Host Budget and the SFC ledger. I also commandeered quite a bit of assistance from Galen. :)</div><div><br></div><div>Here are my findings thus far:</div><div><b>RECEIVABLES</b></div><div><br></div><div>The income amount for Sponsorships was recorded correctly as $21,200.00.</div><div>As far as I know, all those payments were received. Awaiting confirmation from the SFC. But this all looks to be correct.</div><div><br></div><div>The income amount for Exhibitors was recorded as $6,740.00. This is $285 less than should have been recorded. The total seems to have been missing an additional registration for Ebsco ($220) and a pre-conference registration ($65) for MassLNC. With those factored in, the amounts now balance for exhibitors.</div><div>* Note that exhibitors were given the option of adding additional registrations on their exhibitor agreement form so those were not tracked along with the people who registered through EventBrite.</div><div><br></div><div>This brings us to a corrected total of $28,225 for exhibitor payments.</div><div><br></div><div> Now we get into some odd issues with the attendee registrations.</div><div>The Host Budget spreadsheet matches the EventBrite numbers for registrations for the conference and pre-conferences. </div><div>The total registrations sans bad debt/refunds looks to be correct at $48,985.00.</div><div><br></div><div>However, there a few issues here that are making this difficult to reconcile with the actual ledger.</div><div>1.) If the library requested to be invoiced EventBrite knows nothing about actual payment (or lack of payment) or refunds.</div><div>2.) When refunds occur, depending on when the refund is requested, there are certain fees or portions of fees that might be assessed by EventBrite/PayPal/SFC. This makes is difficult to reconcile to the penny particularly in light of the more challenging aspects of the SFC's ledger system. </div><div>3.) Registrants names are not always listed in the ledger if a library pays by check (for example) for 4 registrants. </div><div><div>4.) Bad debt. There was a registration from a library system for 4 attendees who requested an invoice. The web site stated that invoices were non-refundable. The library ended up wanting to send 3 attendees instead of 4 and refused to recognize the invoice. They ended up just ignoring the invoice (telling us they were going to "wait for it to expire", which isn't actually a thing that happens in reality) and they re-registered the 3 people who were going to attend and paid for them with a CC. This was annoying but shouldn't have been a crippling problem in the books... however, it ended up being difficult to account for because of the way the SFC was taking its cut. I will address that down at the end of the email.</div><div><br></div><div><b>PAYBLES</b></div><div><b><br></b></div><div>The amounts paid for the Band, the Cake, the Keynote gift, EventBrite registration fees, and the Food/AV bill from the Sheraton were all completely correct and easily reconciled. The total was $66,832.56.</div><div><br></div><div>On the Host spreadsheet, the amount for the SFC donation was incorrectly listed as $7,009.50. At 10% of their original total it ought to have been $7,692.50. With the corrections I have mentioned above, the correct amount should be $7,721.00.</div><div><br></div><div>Additionally, there are the afore mentioned refunds and bad debt issues which could be as high as $1,557.13 but I would need a magic wand and some fairy dust to be certain. Or maybe another 2 days and a CPA.</div><div><b><br></b></div><div>Lastly for payables, I can find no record in the SFC ledger of a payment for the NCDCR attendees (The folks from the NC Cardinal org.) Their registrations in EventBrite are all marked as "Paid by Check", however the SFC has no payment listed in our ledger. The total of all these referenced registrations that seem to not have payment recorded is $3,930.00. I have emailed my post-conference contact at NC and asked if they could confirm payment - perhaps the check got lost in the mail.</div><div><br></div><div>So,we're closer to answers for closing out the conference. Once I have some idea of what happened with the NC payment we should be able to reconcile with some certainty.</div><div><br></div><div>~~~~~~~~~~~</div><div>To be honest, this process is being made approximately 400 times more difficult than it ought to be due to the in-house ledger system the SFC is using. I know we've all had out moments of confusion regarding the reports we get... for example, why income is reported and recorded as a negative number. But the problems with the system seem to be much deeper. As I've investigated the conference reconciliation a few things stuck out. </div><div>1.) Payment date is not recorded.</div><div>2.) Ledger cannot be reconciled easily with registrations. Double entry (or triple) is required when payment is received to ensure ledger, EventBrite, and budget tracking spreadsheet match.</div><div>3.) This brings me to what I mentioned above with the SFC cut. In the case of investigating the specific "bad debt" write off I detailed above, I noticed there was a peculiar entry for $130 related to this case. $130 didn't match what I initially thought it did (two pre-conference registrations). Instead, to the best of my ability to discern, it appears to be a write off for lazy and incorrect accounting purposes. According to the Fiscal Sponsorship agreement, the SFC gets a 10% "donation" of <b><u>gross income</u></b>. From looking at the ledger, it appears that when registrations/sponsorships are invoiced, the SFC is transferring its 10% cut immediately. </div><div>In the case of this mysterious $130 as far as I can tell, it breaks down like this.</div><div>The library was invoiced $880 for 4 registrations at the early bird rate of $220.</div><div>The SFC took it's 10% cut of $88.</div><div>The library refused to pay the invoice.</div><div>The library re-registered 3 attendees at the regular rate of $250.</div><div>The library paid $750 by CC.</div><div>The SFC did NOT take a 10% cut of that payment.</div><div>The SFC created a bad debt entry of $130. </div><div>10% of $130 is equal to the $13 difference between $88 and $75. This seems to have been done to avoid returning the $88 and taking the correct amount of $75.</div><div><br></div><div>Not only is this bad accounting practice, I don't believe it is reflective of the agreement we have with them. It seems reasonable that the SFC should only be transferring their donation after payment is received.</div><div><br></div><div>Apologies for the long email but it's been quite an eye opening investigation. I understand that this is coming a little late for substantive discussion at our meeting today but I wanted to at least get the ball rolling while we wait for other answers.</div><div><br></div><div>Kudos if you made it to the end of the email!</div><div>Grace</div><div><br></div>-- <br><div data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div style="text-align:left"><span style="font-size:x-small">Grace Dunbar, Vice President</span></div><font size="1">
Equinox - Open Your Library<br><a href="mailto:gdunbar@esilibrary.com" target="_blank">gdunbar@esilibrary.com</a></font>
<font size="1"> <br>
1-877-OPEN-ILS | </font><font size="1"><a href="http://www.esilibrary.com" target="_blank">www.esilibrary.com</a></font><span style="font-size:12.8px">
</span><font size="1"> </font></div><div dir="ltr"><font size="1"> </font></div></div></div></div></div></div></div></div>
</div></div>
<br>_______________________________________________<br>
eg-oversight-board mailing list<br>
<a href="mailto:eg-oversight-board@list.evergreen-ils.org">eg-oversight-board@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/eg-oversight-board" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/eg-oversight-board</a><br>
<br></blockquote></div></div>