Forum

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? :thumb:

Interesting approach - I am sure some folx use Terapeak to search and find.

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?

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

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.

I do my excel sheets based on each order I place. Here is a screenshot of what mine looks like.

http://i49.tinypic.com/1pb6o2.jpg

thats pretty cool marysman. fancy PMing me the formula? no worries if not man

you got good formulas going there good job

Interesting and nice profit.

Colourful too - no wonder it`s inspirational.

Can you email me a blank copy of this? :)

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.

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.

No problem, if you guys want a copy msg me your email(s). I'll send ya a copy of my excel spreadsheet.

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.

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.

That is ok because you can add the formula if you knew how and had the time.

Thanks for the link and sharing your info.

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

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.

If your selling the same items over and over the excel works great

but becareful you dont do your tax returns and not account for returned or credited items

I think its best to do daily or weekly print outs rather than running totals

That way if you religiously add the sales on the date of payment, its very easy to look back through your records and correct mistakes etc

even if your just monitoring profits

You never know you might notice interesting market trends (like everyone who buys on a friday sends stuff back etc)

I use Outright.com and an order management software. Keeps awesome track of tax info, daily, weekly, monthly, and yearly expenses/profits and percentages.

Tax Returns...Right :behindsofa:

This is what mine looks like. Except I separate by website and input item number. I want to see how much each item sells at each venue... Amazon will almost always make more then ebay. However ebay I can sell quanity faster because auction listings are guaranteed sells, yet lower amounts. Its a fine balance.

Definitely also good to separate by venue. Can also make a new book with the same template.

I use a custom-built web-application for this purpose. It automatically grabs sales data from eBay Api and places it all into one page. Works great. I will be starting a thread here soon for it. Thanks,

That would be awesome. I'm looking forward to hearing about it!! Any chance u would help us out and give acouple of copies away? Pm me

I will not be charging a king's ransom for it, that's the whole purpose of my development. Offer cheap but best solutions to ebay sellers. I will be maintaining a mini-fee per month basis and ofcourse I will offer free first month for a few people, it's not a problem. :)

My thread is life in the BST section, automated eBay accounting..:clap:

Hi,

What is the formula to keep the calculation going?

Excel has addition functions to use and expand upon