Need to move a set of Excel spreadsheets that create a monthly commission report into a real database and program. We have two separate accounting systems so we need to do each step twice.
The process is as follows:
1. run monthly sales report A into Excel
2. run monthly payments report B into Excel
3. run monthly sales report B into Excel
4. run monthly payments report B into Excel
There are two other spreadsheets that also need to be incorporated...
Cost of Goods by Invoice (invoice#, cost$)
Commission by Invoice (invoice#, comm%)
Commissions are paid monthly and some people are on a draw, so the draw calculation needs to be a part of the commission report.
Everything is keyed off of invoice #
Currently we cut and paste the data from all of these spreadsheets into one big spreadsheet that we keep. We have a separate summary spreadsheet for each of 8 sales people. That's lots of cutting and pasting and we sometimes make a mistake.
We need a program to be able to load the excel spreadsheets into our MS SQL database making sure there are no duplicates or unapproved changes.
Need a separate program to be able to run a couple of canned reports against the MS SQL so that we can give a sales person their commission report. See attached Commission Report.
13 freelancers are bidding on average $385 for this job
In order to make the project 100% perfection and satisfactory, communication is the only key. So we can communicate with you daily through messanger and updates the development. See PMB for more details.