My Year Long Paypal Experiment
- Thread starter Essellohbeebeewhy
- Start date
Essellohbeebeewhy
OzCardTrader
Guys to figure this out do I need to use a calculator and add them up or can PayPal give me a total? CBF with the first option
---------- Post added 26-02-2010 at 08:40 AM ----------
Hmmm... $6166.52US ... but sold $2167.98US
how'd you do it mate? calculator? you guys are cheating, i bloody saved every single one of my reciepts!
didnt realise until i posted this thread that i thought you could just use paypal history 
I guess. Download the "Comma delimited" version of the last 12 months with Tabs and it should make it an excel file, then you can send it over 
---------- Post added 26-02-2010 at 10:24 AM ----------
I used to do that...then realised I likely wouldn't need them, but was keeping my Forestry industry alive
---------- Post added 26-02-2010 at 10:24 AM ----------
how'd you do it mate? calculator? you guys are cheating, i bloody saved every single one of my reciepts!
I used to do that...then realised I likely wouldn't need them, but was keeping my Forestry industry alive
Essellohbeebeewhy
OzCardTrader
download it to a CSV file for a year period.
Then turn on auto filter on all the columns.
For Type - ignore currency conversion (as this is a duplicate of the stuff in aud when converting money to USD etc..)
For status - filter by completed
For Ammount Column - filter out all positive values as this is money that has come in from bank (if you look at type will say Added Funds from Bank Account)
this will give you a total spent.
to get AUD total you could just filter by Added Funds from Bank Account and it should be slightly more than spent as it will be in AUD.
HOWEVER THIS IS ASSUMING YOU DO NOT HAVE MONEY IN PAYPAL. Like me every transaction I do always does this. my paypal sits at $0 all the time.
Then turn on auto filter on all the columns.
For Type - ignore currency conversion (as this is a duplicate of the stuff in aud when converting money to USD etc..)
For status - filter by completed
For Ammount Column - filter out all positive values as this is money that has come in from bank (if you look at type will say Added Funds from Bank Account)
this will give you a total spent.
to get AUD total you could just filter by Added Funds from Bank Account and it should be slightly more than spent as it will be in AUD.
HOWEVER THIS IS ASSUMING YOU DO NOT HAVE MONEY IN PAYPAL. Like me every transaction I do always does this. my paypal sits at $0 all the time.
hairyangryfella
Tag Team Quads 93/94
how'd you do it mate? calculator? you guys are cheating, i bloody saved every single one of my reciepts!
Slobby... I have never EVER used this term before, but...
ROFL!!!!
lol i dont pirnt receipts out haha.
paypal history gives you a CSV but does not provide transaciton ID (maybe I didnt tick all options who knows).
Date Time Time Zone Name Type Status Currency Amount Receipt ID Balance
24/02/2010 21:32:57 AEDT RockYou, Inc. Pre-approved Payment Sent Completed USD -10 0
24/02/2010 21:32:57 AEDT From Australian Dollar Currency Conversion Completed USD 10 10
24/02/2010 21:32:57 AEDT To US Dollar Currency Conversion Completed AUD -11.53 0
24/02/2010 21:32:57 AEDT Bank Account Add Funds from a Bank Account Completed AUD 11.53 11.53
NOTICE HOW FOUR LINES ARE ALL THE SAME TRANSACTION HAHA. SO need to filter out three of those lines.
also nick, just wait. it took about 5mins for mine. don't touch anything it will get there.
paypal history gives you a CSV but does not provide transaciton ID (maybe I didnt tick all options who knows).
Date Time Time Zone Name Type Status Currency Amount Receipt ID Balance
24/02/2010 21:32:57 AEDT RockYou, Inc. Pre-approved Payment Sent Completed USD -10 0
24/02/2010 21:32:57 AEDT From Australian Dollar Currency Conversion Completed USD 10 10
24/02/2010 21:32:57 AEDT To US Dollar Currency Conversion Completed AUD -11.53 0
24/02/2010 21:32:57 AEDT Bank Account Add Funds from a Bank Account Completed AUD 11.53 11.53
NOTICE HOW FOUR LINES ARE ALL THE SAME TRANSACTION HAHA. SO need to filter out three of those lines.
also nick, just wait. it took about 5mins for mine. don't touch anything it will get there.
7th try and it timed out again
Looks like i'll be spending 3 hours tonight doing it manually
What do you mean it timed out? Are you highlighting and saving?
Request a download from PayPal. It will take a few minutes but they send it to you as an e-mail! No need to manually download it or risk it being timed out.
If you have been doing the PayPal download/e-mail method, disregard my post
Essellohbeebeewhy
OzCardTrader
hahaha thanks mate! i tried to get into a habbit of printing them off so and filing them away so i wouldnt think of what i was doing and how long it would take..a years a long time!
7th try and it timed out again
Looks like i'll be spending 3 hours tonight doing it manually
get on those buttons mate! hahahahaha
What do you mean it timed out? Are you highlighting and saving?
Request a download from PayPal. It will take a few minutes but they send it to you as an e-mail! No need to manually download it or risk it being timed out.
If you have been doing the PayPal download/e-mail method, disregard my post
Me no comprende
Im going into history>D/load history then it says "Choose from one of the two options below" Then i select from the 01/01/09 to now then file types as "Tab Delimited"
then click d/load history and it just times out after 3 minutes of loading
I can't see any option for email history?
Me no comprende
Im going into history>D/load history then it says "Choose from one of the two options below" Then i select from the 01/01/09 to now then file types as "Tab Delimited"
then click d/load history and it just times out after 3 minutes of loading
I can't see any option for email history?
Weird...mine took me straight to a page stating something about the size being large so it will be e-mailed to me to download
