Some order management platforms have some of these features.
You described an ecommerce store, do you have some sort of order management system hooked to its backend?
Here's an example of an Ecom platform mated with an Order Management platform, one that speaks QuickBooks, estimates profits on discrete orders:
Here's a list of some order management platforms for a popular (cheap) Ecom platform, you can find many here:
My first reaction is you're trying to micro-track in far too great of detail, although I suspect you were partially 'thinking out loud' in some points of your post. I don't know if there's any off the shelf software that will do everything you want. But with that aside:
|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) |
If your supplier doesn't provide invoices with something as basic an order ID you couldn't obviously import the data into whatever platform you're using. The UPS fees they're charging you are likely variable so there's no real way you can get your numbers to completely lineup with theirs to do a flawless audit. I know we have a lot of suppliers who struggle to even send us a PDF invoice every month rather than a mailed hard copy and you probably do too. To get the amount of precision you want I don't think is realistic in a lot of the cases.
What I do is simply do a random audit of invoices, and audit a few lines. My experience in many years of doing this is almost all suppliers are honest about doing this and for as many unfavorable mistakes they make, they make just as many favorable mistakes.
This should be easy enough to add in because everything follows a pretty standard rate schedule. Probably not the most useful thing though because most payment providers tend to have the same rates +-1% so probably consider it by default in any calculations you do.
4)We buy materials to help us fulfill the orders (packages) – this can be one big invoice every 3 months
6)We pay salaries
I don't think you'd want to try and assign these costs on a per product level. Possibly packaging but even that is a slippery slope.
Now if you want a software solution where you can view a group of orders in a certain time frame for a certain supplier, many order management software suites will do this for you (I know ours, Linnworks, will do it) although you're not going to boil down the expenses quite as much as you're looking for.
Isn't this part of what a financial system is for? I use Quickbooks and can pull reports for all of this information.
|Isn't this part of what a financial system is for? I use Quickbooks and can pull reports for all of this information. |
If you're doing a lot of online orders you almost need a separate order management suite. Quickbooks is great in many ways but doesn't give anything close to the amount of attention needed for individual orders (and it doesn't pretend to either).
Votrechien - we are exclusively online on several marketplaces. The op mentions having to pay his invoices and invoice profitability. These are financial transactions and you should use an accounting system - whether QB or something more robust. We track our orders by marketplace and state/country, items, etc. Our invoices are entered, we have reminders to pay items, payment terms built in, etc. This is standard stuff.
Thanks for the answer
So basically you are saying that if I will input all the data to QuickBooks I can have this information?
If I get one big invoice from a supplier I can bind segments of this invoice to the relevant order ID in our system?
Sounds like you need a more high end accounting program. Look into Microsoft Dynamics. You would have to create some integration with your website but it is capable of doing it.
You probably can do it with Quickbooks - I am not an expert in your data, your mileage may vary. But, something like MS Dynamics (as mentioned above), xtuple, or others would give more functionality.
It sounds like that, so far, you are not using any financial software whatsoever. That is dangerous when running a business. You have to have a bookeeping system, either manual (nightmare for e-commerce) or computerized.