Page 1 of 1

Re: Tracking Commission Payments

Posted: 08 Jan 2022, 14:59
by 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?

Re: Tracking Commission Payments

Posted: 09 Jan 2022, 22:00
by pisquee
You could set a lot of that up in Excel with COUNTIF/SUMIF
Speed up entry of makers with drop down lists

Re: Tracking Commission Payments

Posted: 14 Jan 2022, 11:25
by GoonerGary
Something like this, or perhaps a free alternative?

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