PayPal question

[standard]

How do you folks like, track/compile your sales from PayPal? The history and report sections of that site seem retarded. If I try to do a jan-june overview of payments received, History gives me a pretty useless multiple page html table (so i can sit there with a calculator?) If I try reports, they don't go larger that 31 days, and even if they did, they only export as tab delimited or crv (?) format.

is there something i am missing? i was thinking i'd just do a jan-june bulk paypal entry into Quicken, then do another for the 2nd half of the year. (i'm not tracking individual products sold, etc). i hate counting shit.

[andydiesel]

i invoice all sales in quickbooks as the sales come in.

when i enter in the payment in quickbooks i just specify what method was used for payment

[Unitus]

my wife deals with this a lot tom. i'll ask her for ya.

[JohnHoward]

Last tax time I somehow got mine over into a google doc.. I must have downloaded the crv. But yeah, PayPal history interface terrible.

[ajosephb]

The easiest way to calculate the fees you have paid for the year would be to:

Download your transaction history for the year you wish to calculate and import it into Microsoft Excel
Change the column format to Accounting by:
Click the Letter in Microsoft Excel above the Fee column. The entire column will be highlighted
Right click on the highlighted area and select 'Format Cells'
Choose Accounting in the category window with 2 decimal places and click 'OK'
Click in the empty cell under the last amount in the Fee column and press the 'Auto Sum' button at the top of excel (looks like a sideways letter 'M')
The column will change, asking you to verify if you want a sum of the current highlighted column. Simply press the enter key on your keyboard and your sum of fees will be calculated and entered into the cell you clicked on in step 3.

Note: PayPal cannot help you with any issues regarding Microsoft Excel. You need to download your history as Comma delimited or Tab delimited to be able to import to Microsoft Excel.

If you have any more questions, please feel free to ask.

[andydiesel]

oh shit if you are trying to calculate fees do what ajb says.

i just went through all this for taxes this year and did the ssame thing,

[standard]

coool... i'll bookmark this for later.

yes, this was for poster sales and figuring out the fees, etc.

i ain't no money-man.

thanks

[andydiesel]

coool... i'll bookmark this for later.

yes, this was for poster sales and figuring out the fees, etc.

i ain't no money-man.

thanks

it took me calling them to get it explained to me. once i was walked through it, it was super easy. it's beyond me why they just can't tell you what you have been billed in fees. My merchant account people were able to do it for me.

[John A]

fuck that... ERRWON is action to cogitate minify my character.