joined:June 16, 2005
We are running an ecommerce website that have this cash flow:
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
1)Credit card billing via authorize.net and other payment providers
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
1)returns and refunds
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?