amiz - 3:51 pm on Feb 19, 2013 (gmt 0)

We are running an ecommerce website that have this cash flow:

Orders:

1)Users place orders on our website on our propriety PHP platform – each order has a unique order ID with one or more item\product in the invoice

Billing:

1)Credit card billing via authorize.net and other payment providers
2)PayPal
3)Google checkout
4)Wire

expenses:

1)We are Paying more then 40 suppliers after ~30 days (we get one big invoice for many unique order ID’s and in some cases we get invoice for “Product Name” X “quantity” without reference to order ID )
2)We pay also DHL\UPS on a monthly invoice for the shipping
3)We pay some service providers to do some custom work on the products themselves
4)We buy materials to help us fulfill the orders (packages) – this can be one big invoice every 3 months
5)We do PPC and SEO marketing
6)We pay salaries
7)Payment providers take their fee
8)General expenses

discrepancies:

1)returns and refunds
2)Chargebacks


Question:

We want a service or a software that we will use to input all our data to make sure
That we are not over paying our supplier’s and to monitor our gross margins on a monthly and also on order or group of orders level.

For example we want to know that in order id 123456 we charged the customer for 100$
We paid the supplier 40$ , UPS 10$ , payment provider fee was 2.5$ and our gross margin on this order was 47.5%.

We want to repeat this check on a group of orders from supplier X in time frame Y

What do you recommend? Do you know any software that can do it
Or do we need to program it in our back office?

Thanks,