Tracking Commission Payments

[Justin]

We currently enter in individual sales onto an Excel Spreadsheet, it works fine but as we get busier it takes too much time.

I want a system where I can log each sale with associated details and then run a simple report at the end of each quarter which shows sales for each designer (they get their own report) and how much we need to pay them.

I'm looking at a very simple database to do this. I've set up a Google Form which works fine and is quicker than the spreadsheet. I now need to be able to run the reports but can't find a suitable add on.

Anyone know how I can do this or if there's an easier way to log the sales?

[pisquee]

You could set a lot of that up in Excel with COUNTIF/SUMIF
Speed up entry of makers with drop down lists

[GoonerGary]

Something like this, or perhaps a free alternative?

https://aspengrovestudios.com/product/f ... ocommerce/