Project Detail

Commission Report  

Commission Report is project number 278279
posted at Freelancer.com. Click here to post your own project.

 

| More
Free Trial For New Buyers
 

Status:

Selected Providers: anhhn

Budget: $250-750

Created: 06/23/2008 at 23:52 EDT

Bid Count: 13

Average Bid:
$ 385

06/28/2008 at 23:52 EDT

Project Creator: mrcrossmedia
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (34 reviews)

Bid On This Project
 

Description

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.


Additional files submitted:
Murphy-Todd 2008 (February).xlsx
Promo Job Costing Report.xls

Job Type

Messages Posted:1 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

anhhn

 

250

10 days

06-24-2008 06:14 EDT

10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10
(1 reviews)

Please see PM for more information

help

pandu17521

 

500

10 days

06-24-2008 00:10 EDT

(No Feedback Yet)

Please check your PM!

help

srilatha74

 

450

10 days

06-24-2008 00:33 EDT

(No Feedback Yet)

We can do it

help

contactisoft

 

400

7 days

06-24-2008 02:20 EDT

(No Feedback Yet)

Dear Sir, SERIOUS BIDDER. Please check PM. Regards, Jainam Shah, iSoft Solutions.

help

dilshat

 

300

3 days

06-24-2008 03:19 EDT

(No Feedback Yet)

Hi! I am already developing a similar sort of application using delphi.Regards, Dilshat

help

ankesh13

 

400

10 days

06-24-2008 06:04 EDT

(No Feedback Yet)

We will provide you the quality solution in your require timeline

help

FMFSolutions

 

250

10 days

06-24-2008 10:33 EDT

(No Feedback Yet)

Both programs can be prepared and tested (on both sides) within this time frame. We assure no bugs and timely delivery! Price can be negotiated.!

help

Digitplex

 

250

10 days

06-24-2008 10:50 EDT

(No Feedback Yet)

Hi Buyer Please see the PMB. Thanks

help

lsalazarv

 

350

10 days

06-24-2008 12:23 EDT

(No Feedback Yet)

I offer you the warranty of my application will generate you the excel report and it will load it in the sql database.

help

sslsoftwares

 

550

10 days

06-25-2008 03:06 EDT

(No Feedback Yet)

we have done such projects

help

servesoft

 

550

5 days

06-25-2008 09:33 EDT

(No Feedback Yet)

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.

help

kamalgaba

 

500

10 days

06-26-2008 07:28 EDT

(No Feedback Yet)

Sir, I think no other person can do this project better then me. And further support will also be excelent from my side. I have around 7 yrs of experience in visual basic 6, MS-access, SQL server, My-sql and database programming of this type. With the reporting in Crystal reports, ms-excel and also DOS based printing. Please give me a chance to prove myself. Thanks Kamal

help

rajhansh

 

250

12 days

06-26-2008 08:50 EDT

(No Feedback Yet)

Sir, I have deigned a similar kind of application(for my office use) that reads data from a excel sheet and populates a sybase database. I will be able to deliver you the product that you need with a superb front-end(GUI).

help


    Bid on this Project