Yeah, this is the one they gave me,
http://pool.biblepay.org/SAN/Expenses/BiblePay_audit_2018.pdf, in response to the audit questions. And the ciqueue service rep said something like "and don't ask for one again as we will not provide you one again" and I thought, hmm thats not right, because we can't even click on our history right now from the web (we have too many records for their server to handle). So Ill push to ask for one every year. Anyway, it looks like a good resource, so please use it.
EDIT: We can also explain to Theymos that it matches our exec theymos to the penny also.
I tried to copy the data from the PDF but I get symbols,
I tried to use a program to extract the data tables to excel but also get symbols hmmm,
Is there an excel file this PDF is based upon?
Anyways, I went through manually and picked out and summed the Payments,
Does this look correct?
=
Just refreshing everyone, my goal is to get us Bitcointalk Forum advertising, this was Theymos's last response to us (he is head Forum admin of Bitcointalk):
I'd probably only be comfortable with BiblePay if a lot more info, news, and third-party reviews of your practices come out.
As-is, I'm not particularly convinced by your responses to my previous concerns (though admittedly I don't have time to spend more than a few minutes looking at it),
and I see a lot of red flags. If I was convinced that BiblePay was like "Litecoin with a bible theme and a donation thing", then I'd probably allow it.
Reference:
https://bitcointalksearch.org/topic/m.47033776=
UPDATE: I went ahead and tweeted at CEO Jim and other high up Compassion people, hope it helps!
https://twitter.com/BiblePay/status/1076580683940798464UPDATE 2: Jim Liked our Tweet!
Yeah, this PDF has to be one of the most convoluted formats I've seen - so it was in unicode, so I ended up converting it to ASCII and saving it and importing into excel but the columns were staggered (every other page had an extra column) then each other page had 1 less column, actually some were random, so anyway I ended up writing a program to import this thing into excel, so now we have the data here:
http://pool.biblepay.org/san/expenses/Compassion2018Audit.xlsxHowever looking at it is really strange in that some of the months seem doubled. When I said it matched to the penny, I was referring to the grand total credit memo matching what we show as of the same date (IE we paid 143,901 in 2018 up to that time, we received a 25,404 credit and now have a 17,606 balance matching ours) however the individual detail rows gyrate up and down in the sheet's details (sometimes double) - you can clearly see we didnt have 650 orphans per month between February and August (which is what the charges allude to, if you divide the 241,131 charges by 10 months and $38 per month, we would have had 625+ orphans), but anyway, I did add rows I-L with the summary per month from Compassion and sum per month from BiblePay to try to reconcile.
I'll let you take a look at the totals now to see if you catch my drift- you can pull the expense and revenue records from pool.biblepay.org accountability to see they match the figs I pasted in I-L.
For now I am just guessing that the person creating the audit found some inaccuracies in their data and had to enter journal entries to match our data (as I sent her our data to ask her if we would get a credit for the N canceling children so she knew up front what we had) and this probably resulted in 2* the journal entries on their side (doubling the charges) and then 2* the payments, etc.
Anyway the good news is if you look at row 14-15 in the summary we are still within a dollar.
I have to check out but let me know if there is something else I can do with this tomorrow.