|
05-10-2012
| | Senior Member | | Join Date: Apr 2010
Posts: 853
Thanks: 3
Thanked 39 Times in 30 Posts
Activity: 0% Longevity: 81% | | keeping a track of profits - software
I want to be more serious when it comes to my ebay trading. Like i know exactly what each sells make me in profit and my weekly/monthly/yearly profits.
What do you guys use to do this please? |
The complete step-by-step guide to get back to selling today!
| |
05-10-2012
| | Executive [VIP] | | Join Date: Dec 2009
Posts: 76,043
Thanks: 5,943
Thanked 8,927 Times in 8,218 Posts
Activity: 100% Longevity: 83% | |
Interesting approach - I am sure some folx use Terapeak to search and find.
|
05-10-2012
| | Executive [VIP] | | Join Date: Sep 2010
Posts: 14,302
Thanks: 1,110
Thanked 4,934 Times in 3,399 Posts
Activity: 0% Longevity: 79% | |
I'm a small fish so I just use an excel spreadsheet to track all my profits and expenses related to those items. Not sure what the big time sellers use.
|
05-10-2012
| | Senior Member
Threadstarter  
| | Join Date: Apr 2010
Posts: 853
Thanks: 3
Thanked 39 Times in 30 Posts
Activity: 0% Longevity: 81% | | Quote:
Originally Posted by marysman78 I'm a small fish so I just use an excel spreadsheet to track all my profits and expenses related to those items. Not sure what the big time sellers use. | have you got it set up with formulas?
|
05-10-2012
| Senior Member | | Join Date: Sep 2009
Posts: 1,644
Thanks: 204
Thanked 252 Times in 209 Posts
Activity: 0% Longevity: 84% | |
money in the front door minus money out the back door
pretty much all that matters to me on a basic level
you need to talk to my mrs........... whooooooaa
|
05-10-2012
| Executive [VIP] | | Join Date: Oct 2011
Posts: 529
Thanks: 118
Thanked 157 Times in 116 Posts
Activity: 0% Longevity: 72% | |
Quickbooks! Imports directly from PayPal, then your manually enter your stock as it comes in, expenses, etc. Voila P/L, taxes, income statement, everything you need.
|
05-10-2012
| | Executive [VIP] | | Join Date: Sep 2010
Posts: 14,302
Thanks: 1,110
Thanked 4,934 Times in 3,399 Posts
Activity: 0% Longevity: 79% | | Quote:
Originally Posted by arshavin have you got it set up with formulas? | I do my excel sheets based on each order I place. Here is a screenshot of what mine looks like. | The Following 6 Users Say Thank You to MM78 For This Useful Post: | |
05-10-2012
| | Senior Member
Threadstarter  
| | Join Date: Apr 2010
Posts: 853
Thanks: 3
Thanked 39 Times in 30 Posts
Activity: 0% Longevity: 81% | |
thats pretty cool marysman. fancy PMing me the formula? no worries if not man
|
05-10-2012
| Junior Member | | Join Date: Apr 2011
Posts: 280
Thanks: 18
Thanked 20 Times in 21 Posts
Activity: 0% Longevity: 75% | |
you got good formulas going there good job
| The Following User Says Thank You to Killuminati For This Useful Post: | |
05-10-2012
| | Senior Member | | Join Date: Dec 2008
Posts: 855
Thanks: 149
Thanked 92 Times in 73 Posts
Activity: 0% Longevity: 89% | |
Interesting and nice profit.
| The Following User Says Thank You to eternity4u For This Useful Post: | |
05-10-2012
| | Executive [VIP] | | Join Date: Dec 2009
Posts: 76,043
Thanks: 5,943
Thanked 8,927 Times in 8,218 Posts
Activity: 100% Longevity: 83% | |
Colourful too - no wonder it`s inspirational.
| The Following User Says Thank You to rsot For This Useful Post: | |
05-10-2012
| Senior Member | | Join Date: Aug 2009
Posts: 1,026
Thanks: 432
Thanked 102 Times in 70 Posts
Activity: 0% Longevity: 85% | | Quote:
Originally Posted by marysman78 I do my excel sheets based on each order I place. Here is a screenshot of what mine looks like. |
Can you email me a blank copy of this? |
05-10-2012
| Senior Member | | Join Date: Apr 2012
Posts: 46
Thanks: 3
Thanked 2 Times in 2 Posts
Activity: 0% Longevity: 69% | |
thats great, i never even thought of using excel... that may sound stupid, but ive just benn writing it down on a sheet of paper, im gonna start the excel system up now, thanks.
|
05-10-2012
| Subscribed [VIP] | | Join Date: Feb 2012
Posts: 24
Thanks: 3
Thanked 9 Times in 5 Posts
Activity: 0% Longevity: 70% | |
try this inFlow Inventory Software | Inventory System
very nice all-in-one software, including stock control, profit, cost, invoice.
from purchase order to sale orde.
and it has a free version which supports up to 100 type (product, supplier, customer) and unlimited sales order/purchaser order.
free version good for those small business that don't have a large variety. or upgrade to regular.
i'm using it, pretty good, only thing that is not so good is it does not help you track down ebay/pp fees and delivery cost.
| The Following 4 Users Say Thank You to davisyip For This Useful Post: | |
05-11-2012
| | Executive [VIP] | | Join Date: Sep 2010
Posts: 14,302
Thanks: 1,110
Thanked 4,934 Times in 3,399 Posts
Activity: 0% Longevity: 79% | |
No problem, if you guys want a copy msg me your email(s). I'll send ya a copy of my excel spreadsheet.
| The Following User Says Thank You to MM78 For This Useful Post: | |
05-11-2012
| Banned | | Join Date: Apr 2009
Posts: 8,605
Thanks: 1,580
Thanked 2,029 Times in 1,356 Posts
Activity: 0% Longevity: 87% | |
Awesome spreadsheet.
She must have the formulas working so you will need to make sure you do not
clear off her numbers and wipe off her formulas for each cell area.
|
05-11-2012
| | Executive [VIP] | | Join Date: Sep 2010
Posts: 14,302
Thanks: 1,110
Thanked 4,934 Times in 3,399 Posts
Activity: 0% Longevity: 79% | |
Well the Ebay and Paypal fee's are not formula based, I use eBay Fees Calculator 8.2 by Ryan Olbe (updated July 12, 2011) to calculate those. The rest are pretty basic formulas.
|
05-11-2012
| Banned | | Join Date: Apr 2009
Posts: 8,605
Thanks: 1,580
Thanked 2,029 Times in 1,356 Posts
Activity: 0% Longevity: 87% | |
That is ok because you can add the formula if you knew how and had the time.
|
05-11-2012
| Banned | | Join Date: Apr 2009
Posts: 8,605
Thanks: 1,580
Thanked 2,029 Times in 1,356 Posts
Activity: 0% Longevity: 87% | | Quote:
Originally Posted by marysman78 | Thanks for the link and sharing your info.
|
05-12-2012
| Senior Member | | Join Date: Mar 2012
Posts: 341
Thanks: 3
Thanked 89 Times in 56 Posts
Activity: 0% Longevity: 69% | |
I made a spread sheet similar to marysman78...
my columns are....
item cost, price paid, shipping paid, ebay fee, paypal fee, shipping cost, P&L
|
05-12-2012
| | Executive [VIP] | | Join Date: Sep 2010
Posts: 14,302
Thanks: 1,110
Thanked 4,934 Times in 3,399 Posts
Activity: 0% Longevity: 79% | | Quote:
Originally Posted by davisyip try this inFlow Inventory Software | Inventory System
very nice all-in-one software, including stock control, profit, cost, invoice.
from purchase order to sale orde.
and it has a free version which supports up to 100 type (product, supplier, customer) and unlimited sales order/purchaser order.
free version good for those small business that don't have a large variety. or upgrade to regular.
i'm using it, pretty good, only thing that is not so good is it does not help you track down ebay/pp fees and delivery cost. |
Is there a way to add Ebay/PP fee to the program?
|
05-14-2012
| Subscribed [VIP] | | Join Date: Feb 2012
Posts: 24
Thanks: 3
Thanked 9 Times in 5 Posts
Activity: 0% Longevity: 70% | | Quote:
Originally Posted by marysman78 Is there a way to add Ebay/PP fee to the program? | Not quite sure, been using this program for a while but still did not figure this out.
but i usually keep track of my paid in and paid out separately, all other fees eg packing material, shipping cost, pp/eb fee, and other expense related to my sales are tracked on an excel sheet
this way i can work out the profit for the whole month.
| The Following User Says Thank You to davisyip For This Useful Post: | |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts HTML code is Off | | | |