I gang

Commission Report

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.

Færdigheder: Visual Basic

Se mere: draw commission excel, draw commission spreadsheet, visual basic cost, sales person for commission, need of cost accounting, c# report, cost accounting systems, cost accounting spreadsheet, cost accounting 2, big-lots, big lots, big 4 accounting, monthly commission report, excel sales draw commission, commission draw report, draw commissions spreadsheet, excel monthly commissions report, monthly commission database, monthly commission spreadsheet, sales commission draw spreadsheet, draw commission report, commission draw spreadsheets, commission spreadsheet excel, monthly commission reports, commission spreadsheet

Om arbejdsgiveren:
( 39 bedømmelser ) Highland Village, United States

Projekt-ID: #278279

Tildelt til:

anhhn

Please see PM for more information

$250 USD in 10 dage
(1 bedømmelse)
2.8

13 freelancere byder i gennemsnit $385 for dette job

rajhansh

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 Mere

$250 USD in 12 dage
(13 bedømmelser)
4.1
pandu17521

Please check your PM!

$500 USD in 10 dage
(0 bedømmelser)
0.0
srilatha74

We can do it

$450 USD in 10 dage
(0 bedømmelser)
0.0
contactisoft

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

$400 USD in 7 dage
(0 bedømmelser)
0.0
dilshat

Hi! I am already developing a similar sort of application using [url removed, login to view], Dilshat

$300 USD in 3 dage
(0 bedømmelser)
0.0
ankesh13

We will provide you the quality solution in your require timeline

$400 USD in 10 dage
(0 bedømmelser)
0.0
FMFSolutions

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

$250 USD in 10 dage
(0 bedømmelser)
0.0
Digitplex

Hi Buyer Please see the PMB. Thanks

$250 USD in 10 dage
(0 bedømmelser)
0.0
lsalazarv

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

$350 USD in 10 dage
(0 bedømmelser)
0.0
sslsoftwares

we have done such projects

$550 USD in 10 dage
(0 bedømmelser)
0.0
servesoft

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.

$550 USD in 5 dage
(0 bedømmelser)
0.0
kamalgaba

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 databas Mere

$500 USD in 10 dage
(0 bedømmelser)
0.0