Share
Report
6,010I need to change the way we are doing commission reporting. We currently commission our sales and service staff based on when they have become profitable for the company (there is an algorithm that determines a "break even" point for each individual). We then run sales / cogs reports based on the "front end" sales history tables. The expenses are being pulled from the "back end" GL FRx reports that we have. Then we have to compare the sales / cogs report minus the expenses to see their "P&L". I would like to have all of this information based off of GL accounts and not the "front end" sales history tables.
Now to my question...
What is the best way to code sales and cogs to a particular GL unit? Currently we have our default GL accounts setup on the inventory item card. Our current account structure is this:
aaa-bb-cc
aaa = Account Name (ex. Equipment Sales, Equipment COGS, Equipment Expense)
bb = Division Name (ex. Corporate, Irrigation, Equipment)
cc = Location Name (ex. General, Sales Person Name, Service Person Name)
Our account numbers are as follows:
400 - Sales
500 - COGS
600 - Expenses
All of our default inventory accounts are setup to go the the based on the division that sells the inventory and the General location account. Equipment parts are setup up 400-4-21 (Sales - Equipment - General).
What I am wanting to do is when an equipment part is sold by a particular sales person, change the GL account for each line item (because each part will go to one of many 400 and 500 accounts depending on what the part is) to represent (Sales - Equipment - Salesperson and COGS - Equipment - Salesperson).
Our expenses are already being coded to the (Expenses - Equipment - Salesperson). If I can get the Sales and COGS coded to the salesperson as well then I will be able to look at a true P&L on each individual salesperson.
Sales - Equipment - Salesperson
COGS - Equipment - Salesperson
- ________________________________
Gross Margin
- Expenses - Equipment - Salesperson
_________________________________
Net Income
Any ideas on the best way of doing this? I would prefer to make it as automated as possible but I am open for ALL suggestions (especially the INEXPENSIVE ones).
*This post is locked for comments
All responses (
Answers (
