# HRWiki talk:Ledger

##  Compensating for PayPal fees

I've made an executive decision to start deducting PayPal surcharges from transactions. I've been floating the wiki cents on the dollar from my own pocket in order to keep those surcharges transparent, but I just started thinking about the surcharges that will acrue on $1,000 worth of donations. I'm not sure I want to float the wiki that much. :) — 12:00, 8 Mar 2005 (MST) Okay, I just made the changes. I let everything slide prior to March 1, 2005, but from now on each donation posted on the ledger will reflect the 2.7% plus US$0.30 surcharge from PayPal. In case anyone is paying extremely close attention, there was one transaction that I had mistakenly dated March 8, 2005 that should've been dated March 7, 2005. I moved it and recalculated the running balance for each of those rows. — 12:24, 8 Mar 2005 (MST)

##  New Ledger

The old ledger was getting a bit unweildy, so I'm now using Excel to manage things. I'm using the excellent CSV to wiki table converter (I've installed a tweaked ledger converter on our server) to transfer my spreadsheet data to the wiki. I've also started attributing names to donations again. As this list starts to get too long, I'll probably archive it off onto other pages by year or by quarter. — 11:35, 9 Mar 2005 (MST)

##  Balanced the books...

I sat down today to balance my PayPal account and started noticing something funny. I kept coming up owing the wiki around $50, so I dug into the numbers a little deeper and made some updates. I did find a few duped transactions on this ledger. When people pay with eChecks, PayPal puts the transaction on two lines — one for when the check arrives and again when the check clears — and in some cases those have been more than a week apart. I wasn't paying attention and had accidentally recorded a few of those as two separate donations. I've also gone back through some of the earlier transactions and changed the amount to reflect PayPal fees. At one point I had decided to cover those fees myself, but I decided I don't want anything fudged on this ledger. Since I had already said I would eat those fees, I threw$12 back into the coffers to compensate.

Let me know if there are any questions. — 06:06, 2 Aug 2005 (UTC)

Do you plan on added The Brothers' Chaps $250 donation to this ledger, JoeyDay? Or are you not going to record that transation? - Joshua 21:44, 21 November 2005 (UTC) I'm still deciding. I'd rather not answer this here right now. I need to figure out if I can even deposit the check first. :) — 22:47, 21 November 2005 (UTC) I see that you added it. (Do you still get to keep the check with the li'l SB and HR on it?) Anyway, it seems you forgot to link to Matt Chapman. (Unless that's intentional.) Just pointing that out... - Joshua 01:28, 6 December 2005 (UTC) No, I don't get to keep the check. Yes, the non-linking was intentional. — 02:03, 6 December 2005 (UTC) ##  Current balance Out of date with the table. — 08:19, 16 September 2006 (UTC) Fixed. Thanks. -- Tom 21:03, 16 September 2006 (UTC) ## $9.41

I've noticed many donations ammount to $9.41, which is (my guess)$10.00 over PayPal, after their fees. Which got me thinking, what exactly would be the total USD donation that would need to be sent over PayPal to equal a $10.00 net donation result? (And perhaps also the gross ammount for a net of$20 or $25 and$50 increments). I think it'd be a useful bit of info for the page, but my calculating abilities are somewhat limited to figure the required ammount out. Thunderbird 09:40, 13 November 2006 (UTC)

I figured this out for $20 a couple of months ago, and applying the formula I worked out right afterward to simplify the calculation for any future donations gave me this: It would be$10.61. $20 is$20.91, $25 is$26.06, and $50 is$51.80. The basic formula to figure it out is 0.971x = y + .3 where x is what you give to PayPal and y is what's left after the fees. —  10:33, 13 November 2006 (UTC)
Shouldn't it be $0.971\left(x+\mbox{arm and a leg}\right)=y+.3$? 10:45, 13 November 2006 (UTC)
Well, I wouldn't go that far. —  10:55, 13 November 2006 (UTC)
So, solving for x, we get $x = \frac{y+0.3}{0.971}$. Plug in the amount you want to appear in the ledger as y and then do the arithmetic. — It's dot com 05:37, 22 November 2006 (UTC)
Also, here's a handy website that automatically calculates fees for you: http://ppcalc.com/. 01:51, 7 April 2008 (UTC)

##  Table Background

Can somebody give the table a white background? My monobook puts all HRWiki pages in grey, and it looks weird now that the table's transparent. - Super Sam 05:16, 22 November 2006 (UTC)

Hi, if we want to link our donation to our username, can we just go ahead and insert the link? I'm a bit wary about just jumping straight in, in case there's policies in place to prevent 'donation usurping' or other such unseemly activity. --Lor 11:10, 4 December 2006 (UTC)

Hm, well, I just found the discussion on the 'Thank You' page for donators. I've put my request up there. --Lor 11:10, 4 December 2006 (UTC)

I would no longer like my name tied to this wiki, and would like it to be changed to username only. Thanks. -JestyTalk

##  Latest Donation

Doesn't look like my donation has gone through yet, but when it does, could it please be displayed as my name (Sam Horn) and linked to my Fanstuff userpage? (The donation will go through as from "Vicki Horn".) - Super Sam 02:22, 24 June 2007 (UTC)

Sorry it took me so long to notice this request and honor it. Your name is now fixed on the ledger. Cheers! — 01:04, 14 October 2007 (UTC)

###  Mark II

The Ledger certainly is updated in practically real-time. Unsure if you add links / change names every so often, but if you don't, could I please get the request above repeated? - Super Sam 12:11, 7 March 2008 (UTC)

Done. — 17:56, 12 March 2008 (UTC)

##  Current Balance

The ledger hasn't seem to be updated in awhile is there a current balance? --66.183.222.111 16:24, 10 July 2007 (UTC)

I've just updated the ledger. I'm sorry it had been so long. We're working on a system that will keep the ledger up-to-date automagically. Cheers! — 20:49, 10 July 2007 (UTC)

##  New Special:Ledger

I've just enabled a new Special page I created, Special:Ledger, and redirected the old HRWiki:Ledger page to it. This new ledger page pulls its information from a database application which can automatically capture and record PayPal donations. In other words, this ledger should keep itself up-to-date without any intervention by an administrator. I've entered all our transactions (going back to 2003) into the new system, but even up until a couple days ago I was still finding things I'd copied wrong. I think it's all correct now, but I'd appreciate having half a dozen people (or however many people are willing) check the old ledger against the new one for accuracy and let me know any mistakes you find by placing a reply here. Thanks. — 21:48, 17 February 2008 (UTC)

The new ledger looks great! Although I remember sending in $11.01 on November 1, 2005, but I do not see it on the newer version. —THE PAPER PREEEOW 17:45, 19 February 2008 (UTC) Oh, I'm glad you caught that. I actually noticed that myself on one of my last passes through the data, but then neglected to follow-up and figure out what had gone wrong. I'm looking into it now, but I'm not finding a transaction when I search within an appropriate date range in PayPal. Could this have been a snail-mailed check? (I do see, however, that a couple people followed your lead in November 2006.) — 20:20, 19 February 2008 (UTC) Well, I just went ahead and added that transaction to the ledger, solely because it was on the old ledger and is one I remember receiving because of the significance of the amount. However, I'd still like to dig up concrete proof that it happened just for my own sanity and proper bookkeeping, so let me know if you recall it being a check or a PayPal payment. Cheers! — 21:20, 19 February 2008 (UTC) Due to the significance of the amount I actually remember seeing that on the ledger and I recall it being noted that it was a paper check. — 03:48, 17 September 2008 (UTC) ##  Name Please to be writing "Nat Paulsen" and linking to me userpage? Heimstern Läufer 04:41, 15 September 2008 (UTC) Done. — It's dot com 17:11, 5 March 2009 (UTC) ##  more names Item 2304 should be linked to me and (unless the name is a coincidence) a star added to 2305. — 03:41, 17 September 2008 (UTC) Done. — It's dot com 17:11, 5 March 2009 (UTC) ##  Username listed please Hi, I just threw five bucks plus change into the tin, could I get item 3133 listed as and linked to my username please? Thanks very much! :D TwoWingedCat 15:45, 10 December 2009 (UTC) Done. Thanks! — It's dot com 02:44, 11 December 2009 (UTC) Okay, I donated$10.61 (big surprise there, eh?) and I'd like to have my name link to my userpage. Thanks in advance. 00:01, 21 October 2010 (UTC)
Done. — It's dot com 03:16, 21 October 2010 (UTC)

##  Change in PayPal Deducted Amounts

We have a problem. For as long as I can remember the amount PayPal deducted for itself in charges for donating here was 61 cents. Well, I paid $10.61 and it was fine. Someone else paid$10.61 and they got not 61, but 71 cents deducted from their purchase. What's going on here? (And yes, I realize I spelled "deducting" wrong. It was a typo, mind you.) 20:39, 22 October 2010 (UTC)
It was an international transaction. The fee is slightly different for those. — It's dot com 21:27, 22 October 2010 (UTC)
Yeah. Only after making that transaction I remembered that Mastercard does that here. Elcool (talk)(contribs) 00:59, 23 October 2010 (UTC)