Complex Commission schedule

I have a client that is requesting for a 2.5%(of total sale) commission plan on anything purchased in cash. If, however, it is purchased with a credit card then the total is less 4% then the original plan follows.

eg. $1000 watch. Cash? - Commission equals 2.5% of $1000 // Same watch paid with Credit? - Commission equals 2.5% of $960. --$40 less of the $1000 sale.

I hope you understand. Of course if a customer pays a combination of cash and credit then of course there will be some complex mix of the above scenario.

So I'm asking if this is even possible outside of their own hand made record keeping or should I have a sit down with the owner to discuss how she needs to make a business decision regarding her complex commission plan? Help!

Reply to
Tech1117
Loading thread data ...

This is something that is best handled with a query directed to the database from Excel, Access or whatever other query/reporting tool you prefer.

In the simplest form, setup an Excel sheet to query the database table(s) containing the sales history you want to work with (presumably weekly or monthly), and then build your if/then calcs based on the criteria you have shown in your message. This will provide your user with a relatively automated solution to this requirement.

HTH

Pacific Computer Systems Miles Baidack

Supporting Business Since 1985 Phone: (808)395-8156 or (808)277-8156

"Tech1117" wrote:

Reply to
Miles B

Reply to
Tech1117

If the Excel option does not work to your liking, and you're looking for some custom reporting options, drop me an email and we'll see if there is anything we can help you with.

Reply to
Ryan

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.