Hi Seddon,
I can understand a few anomalies where people give when they don't have funds to cover it, and for a difference between estimated exchange rates and the actual exchange rate that applied when the transaction was processed (currencies float and are quite capable of moving between the moment you are aware of a donation and the moment it is converted into one of the currencies you bank in). But I'd expect such anomalies to be a tiny fraction of a percent. OK one of these days we will have a record breaking donation day in a currency that then devalues by half before we convert that money into dollars, but I don't recall any spectacular devaluations in the last two weeks.
Is it worth checking to see why these numbers in the frdata dump are only a rough guide?
If its something as innocent as our estimates still working on say 2012 currency conversions and the actual currency conversions are based on the day rate, then meh. But if one set of figures is gross before credit card and other transaction costs and the other figures are net, or one set assumed a UK Gift Aid sign up as high as Wikimedia UK could have got and the reality was much lower, then I'd be alarmed at such a difference.
Jonathan
Hey Andreas
A very quick email just noting I don't know the method by which that
frdata
dump is created (its very old and not maintained) but it would seem
that
numbers in the frdata dump are only useful as a rough guide.
We are basing our numbers on internal accounting figures which is more representative of the actual cash flow since it is more closely based
on
actual cleared payments.
Seddon
It's mostly the fact that it's a low priority dump, isn't maintained actively, some of the queries used to produce it are old and probably need updating and some of them are definitely broken (the refund sheet certainly is). It includes some major gifts donations (which we don't include in our campaign target for online fundraising), but almost certainly not others. So all in all it just needs an overhaul (the YTD sheet only includes $59,000,000 for the last calendar year which is some $18,000,000 short.
Something to look into.
Seddon On Thu, Dec 8, 2016 at 9:36 AM, WereSpielChequers < werespielchequers@gmail.com> wrote:
Hi Seddon,
I can understand a few anomalies where people give when they don't have funds to cover it, and for a difference between estimated exchange rates and the actual exchange rate that applied when the transaction was processed (currencies float and are quite capable of moving between the moment you are aware of a donation and the moment it is converted into one of the currencies you bank in). But I'd expect such anomalies to be a tiny fraction of a percent. OK one of these days we will have a record breaking donation day in a currency that then devalues by half before we convert that money into dollars, but I don't recall any spectacular devaluations in the last two weeks.
Is it worth checking to see why these numbers in the frdata dump are only a rough guide?
If its something as innocent as our estimates still working on say 2012 currency conversions and the actual currency conversions are based on the day rate, then meh. But if one set of figures is gross before credit card and other transaction costs and the other figures are net, or one set assumed a UK Gift Aid sign up as high as Wikimedia UK could have got and the reality was much lower, then I'd be alarmed at such a difference.
Jonathan
Hey Andreas
A very quick email just noting I don't know the method by which that
frdata
dump is created (its very old and not maintained) but it would seem
that
numbers in the frdata dump are only useful as a rough guide.
We are basing our numbers on internal accounting figures which is more representative of the actual cash flow since it is more closely based
on
actual cleared payments.
Seddon
Wikimedia-l mailing list, guidelines at: https://meta.wikimedia.org/ wiki/Mailing_lists/Guidelines New messages to: Wikimedia-l@lists.wikimedia.org Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/wikimedia-l, mailto:wikimedia-l-request@lists.wikimedia.org?subject=unsubscribe
Dear Katherine and Wikimedians,
I'm not sure if this email will go through to this list or not, since I've gotten some bounce backs, but I'm writing to let you know of a last minute grant writing workshop in SF at Congresswoman Nancy Pelosi's office tomorrow at 11 am. I just emailed the following to the SF Quaker Meeting (on 9th Street) list about this opportunity. (And World University and School, of which I'm the founder, president and presiding clerk, donated CC WUaS to CC Wikidata last October 2015).
Dear Friends,
Do you know anyone in SF Friends' Meeting who might be interested, at this last minute, in a grant-writing workshop in Congresswoman Nancy Pelosi's office tomorrow morning at 11am? The workshop still has spaces available. I'm seeking to write grants via Nancy's office for Friendly-informed World University and School. (I'm heading to the Federal Building on 7th Street from the SF Friends' Meeting House with Quakers for a 10am meeting there - to join in a Quaker conversation beforehand. For this 10 am Quaker gathering, Friends are gathering at 9 am at SF FM, probably partly to get into the Federal Building early to deal with their "Airport Security" per Jocelyn Yow's email below, and possibly for Meeting as well. I'm leaving my little Swiss Army pocket knife at home right now). If interested, you would need to RSVP with Jocelyn Yow for this at Jocelyn.Yow@mail.house.gov soon.
Friendly greetings, Scott worlduniversityandschool.org
- Scott
From *Jocelyn Yow*
Field Representative
*Congresswoman Nancy Pelosi, Democratic Leader*
Greetings,
Thank you for your RSVP for tomorrow’s grants workshop at 11a.m. at 90 7th Street, San Francisco, California 94103 .
As a reminder, all visitors must present government-issued photo identification, such as a valid state driver license, ID card or passport, to gain access to the Federal Building. Entering the building is much like airport security, and will require extra time. Arriving early is highly recommended to allow for security procedures. The San Francisco Federal Building is located one block south of the Civic Center/UN Plaza Muni and BART Station http://www.bart.gov/stations/civc. The closest parking garage is the SOMA Grand, 1160 Mission Street, at $2 an hour http://www.yelp.com/biz/soma-grand-garage-san-francisco.
We still have spaces available. If you know anyone else who is interested in attending, feel free to bring them along to the workshop.
Thanks,
*Jocelyn Yow*
Field Representative
*Congresswoman Nancy Pelosi, Democratic Leader*
90 – 7th Street, Ste 2-800, San Francisco, CA 94103
Tel (415) 556-4862 | Fax (415) 861-1670
www.pelosi.house.gov http://www.house.gov/pelosi
www.DemocraticLeader.gov http://www.democraticleader.gov/
On Thu, Dec 8, 2016 at 6:17 PM, Joseph Seddon jseddon@wikimedia.org wrote:
It's mostly the fact that it's a low priority dump, isn't maintained actively, some of the queries used to produce it are old and probably need updating and some of them are definitely broken (the refund sheet certainly is). It includes some major gifts donations (which we don't include in our campaign target for online fundraising), but almost certainly not others. So all in all it just needs an overhaul (the YTD sheet only includes $59,000,000 for the last calendar year which is some $18,000,000 short.
Something to look into.
Seddon On Thu, Dec 8, 2016 at 9:36 AM, WereSpielChequers < werespielchequers@gmail.com> wrote:
Hi Seddon,
I can understand a few anomalies where people give when they don't have funds to cover it, and for a difference between estimated exchange rates and the actual exchange rate that applied when the transaction was processed (currencies float and are quite capable of moving between the moment you are aware of a donation and the moment it is converted into
one
of the currencies you bank in). But I'd expect such anomalies to be a
tiny
fraction of a percent. OK one of these days we will have a record
breaking
donation day in a currency that then devalues by half before we convert that money into dollars, but I don't recall any spectacular devaluations
in
the last two weeks.
Is it worth checking to see why these numbers in the frdata dump are
only a
rough guide?
If its something as innocent as our estimates still working on say 2012 currency conversions and the actual currency conversions are based on the day rate, then meh. But if one set of figures is gross before credit card and other transaction costs and the other figures are net, or one set assumed a UK Gift Aid sign up as high as Wikimedia UK could have got and the reality was much lower, then I'd be alarmed at such a difference.
Jonathan
Hey Andreas
A very quick email just noting I don't know the method by which that
frdata
dump is created (its very old and not maintained) but it would seem
that
numbers in the frdata dump are only useful as a rough guide.
We are basing our numbers on internal accounting figures which is more representative of the actual cash flow since it is more closely based
on
actual cleared payments.
Seddon
Wikimedia-l mailing list, guidelines at: https://meta.wikimedia.org/ wiki/Mailing_lists/Guidelines New messages to: Wikimedia-l@lists.wikimedia.org Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/wikimedia-l, mailto:wikimedia-l-request@lists.wikimedia.org?subject=unsubscribe
-- Seddon
*Advancement Associate (Community Engagement)* *Wikimedia Foundation* _______________________________________________ Wikimedia-l mailing list, guidelines at: https://meta.wikimedia.org/ wiki/Mailing_lists/Guidelines New messages to: Wikimedia-l@lists.wikimedia.org Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/wikimedia-l, mailto:wikimedia-l-request@lists.wikimedia.org?subject=unsubscribe
wikimedia-l@lists.wikimedia.org