Project Detail

Commission Report

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

| More

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/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 (34 reviews)

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

Report Violation

Job Type

Visual Basic

See more: accounting, commission, data, database, draw, excel, invoice, make, paid, people, program, real, report, reports, sales, sales people, sales rep, spreadsheet, sql, sql database

Messages Posted:1

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

PMB

250

10 days

06-24-2008 06:14 EDT

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

Please see PM for more information

pandu17521

500

10 days

06-24-2008 00:10 EDT

(No Feedback Yet)

Please check your PM!

srilatha74

450

10 days

06-24-2008 00:33 EDT

(No Feedback Yet)

We can do it

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.

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

ankesh13

400

10 days

06-24-2008 06:04 EDT

(No Feedback Yet)

We will provide you the quality solution in your require timeline

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.!

Digitplex

250

10 days

06-24-2008 10:50 EDT

(No Feedback Yet)

Hi Buyer Please see the PMB. Thanks

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.

sslsoftwares

550

10 days

06-25-2008 03:06 EDT

(No Feedback Yet)

we have done such projects

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.

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

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).

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.