Results 1 to 4 of 4
  1. #1
    eBay Spreadsheet Template

    Member Since
    Aug 10, 2010
    Posts
    11
    eBay Spreadsheet Template
    Hi, I'm hoping someone could help me with providing a template (or help me create a formula) to track your eBay sales.

    I've been trying to create a formula or find a template that involves the following:

    -Original Purchase Price
    -Sold Price
    -Shipping Charged
    -Actual Shipping
    -eBay fees
    -PayPal fees
    -Total Profit
    -etc...

    Any help would be great. I'm having some trouble. Thank you!

  2. #2
    eBay Spreadsheet Template
    chscag's Avatar
    Member Since
    Jan 23, 2008
    Location
    Fort Worth, Texas
    Posts
    45,277
    Specs:
    27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, iPhone 6+, 3 iPods, Yosemite
    Learning how to use Excel 2011. LINK

  3. #3
    eBay Spreadsheet Template
    BrianLachoreVPI's Avatar
    Member Since
    Feb 24, 2011
    Location
    Maryland
    Posts
    3,733
    Specs:
    March 2011 15" MBP 2.3GHz i7 Quad Core 8GB Ram | Mid 2011 27" iMac 3.4 GHz i7 16 GB RAM 2 TB HDD
    I think I'm with Charlie on this one. The list you've given is pretty much as fundamental as it gets with spreadsheets - and even if I whipped one up for you - if you aren't familiar enough with Excel to do the basics, such as you've listed - it would be of no use to you. Spend a little time, familiarize yourself with the basics and then make it yourself - and you'll be much better served.

  4. #4
    eBay Spreadsheet Template

    Member Since
    Aug 10, 2010
    Posts
    11
    Sorry, I forgot to mention I'm using Numbers `09. I am able to do adding, subtracting, sum, etc... Simple formulas. But I want to make it so that I can subtract ebay and paypal % automatically... for example:

    sold for price + shipping charge - ebay final value fee - my purchase price - paypal fee -actual shipping cost - ebay listing fee = total profit

    Like I said I can make a simple formula but how do I format the cells entitled "ebay final value fee" and "paypal fee" to be set to an automatic percentage? I don't know if that's clear. As I'm sure many of you know when you sell something on eBay they take a final value fee out (I think it's 9% of the sold price) and PayPal takes a certain percentage also. How do I make that be set automatically for that column?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. how to use spreadsheet in mac?
    By michelleyang in forum Switcher Hangout
    Replies: 7
    Last Post: 07-13-2015, 02:10 PM
  2. Is there a spreadsheet that will.................
    By royalpei in forum Switcher Hangout
    Replies: 6
    Last Post: 09-29-2012, 10:24 AM
  3. Spreadsheet
    By Only child in forum OS X - Apps and Games
    Replies: 9
    Last Post: 05-17-2011, 09:31 PM
  4. Help with spreadsheet.
    By heartman6nmh in forum OS X - Apps and Games
    Replies: 1
    Last Post: 12-21-2010, 08:43 PM
  5. Template Cocoa Template generated from Cannot NSLog
    By Bracer in forum OS X - Development and Darwin
    Replies: 2
    Last Post: 10-16-2009, 04:18 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •