Paypal/Ebay

NEF

Free Member
Jan 14, 2008
290
16
Durham UK
Can anyone who uses Ebay/Paypal tell me the process of how you print out the transaction sheets (paypal/ebay) showing the seller fees i.e 3 % paypal, and the ebay fees... Just for my records.. Someone may go about things a lot better than myself.. Is there a streamlined system for it..
 
Ebay fees are invoiced to you monthly, so that part is easy.

For paypoo simply download your history, one of the columns details their commission, the following might be of some help in speeding up calculations.

"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."
 
Upvote 0
do it monthly - if you miss the 3 month limit you start to get into trouble obaining the historic details. Alternativley we have founf KashFlow.co.uk great - sucks your paypal accounts and fees into the books and translats foreign currnecy too. G Checkout and other transactions are manual - but the fact they can do paypal is a HUGE release on resources
 
Upvote 0

DuaneJackson

Free Member
Jul 14, 2005
8,642
1,100
Brighton / London
Alternativley we have founf KashFlow.co.uk great - sucks your paypal accounts and fees into the books and translats foreign currnecy too. G Checkout and other transactions are manual - but the fact they can do paypal is a HUGE release on resources

Good to hear : )

I haven't recorded any details from the last year, so I'm trying to gather them now... oops...:eek:

If you're going to try KashFlow, when you set up the PayPal stuff tick the box to disable it, then ask support to backdate it for you. We can backdate a year no problem.
 
Upvote 0
S

silvermusic

I use eBay's File Exchange to download sales data into a standard .CSV file which can be imported into Excel. Much easier than trying to work with their invoices. Take a look at http://pages.ebay.co.uk/file_exchange/ It's free to subscribe to and probably one of ebay's best kept features.

For accounts I print off just the top page of the invoice and use the data downloaded from File Exchange for the detail. Being a spreadsheet format it makes things so much easier.

PayPal records can be downloaded the same way from the PayPal site, and the good news is they never expire, I can still download stuff from 2001 from when I first got a PayPal account. This may also be of use if some of your sales data is missing from eBay after 3 months. Although the main invoices stay on the system for 18 months.
 
Last edited by a moderator:
Upvote 0

Latest Articles