New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

eBay Spreadsheet Template


Post Reply New Thread Subscribe

 
Thread Tools
steen

 
Member Since: Aug 10, 2010
Posts: 11
steen is on a distinguished road

steen is offline
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!
QUOTE Thanks
chscag

 
chscag's Avatar
 
Member Since: Jan 23, 2008
Location: Fort Worth, Texas
Posts: 40,927
chscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond repute
Mac Specs: 27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, 3 iPods, Yosemite

chscag is offline
Learning how to use Excel 2011. LINK
QUOTE Thanks
BrianLachoreVPI

 
BrianLachoreVPI's Avatar
 
Member Since: Feb 25, 2011
Location: Maryland
Posts: 3,742
BrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant future
Mac 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

BrianLachoreVPI is offline
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.
QUOTE Thanks
steen

 
Member Since: Aug 10, 2010
Posts: 11
steen is on a distinguished road

steen is offline
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?
QUOTE Thanks

Post Reply New Thread Subscribe


« iCAL not syncing with Google Calendar! | PDF problem »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Ebay account was hacked ace.13unibody Schweb's Lounge 9 11-07-2010 04:13 PM
Buying on ebay richhen Apple Notebooks 6 09-01-2010 03:29 PM
Ebay Photos lilly Switcher Hangout 1 05-29-2010 08:10 PM
got scammed on ebay.. looking for advice Quashu Schweb's Lounge 30 11-08-2009 06:32 PM

All times are GMT -4. The time now is 11:19 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?