Sedang Disiapkan

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.

Kemahiran: Visual Basic

Lihat lebih lanjut: 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

Tentang Majikan:
( 39 ulasan ) Highland Village, United States

ID Projek: #278279

Dianugerahkan kepada:

anhhn

Please see PM for more information

$250 USD dalam 10 hari
(1 Ulasan)
2.8

13 pekerja bebas membida secara purata $385 untuk pekerjaan ini

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 Lagi

$250 USD dalam 12 hari
(13 Ulasan)
4.1
pandu17521

Please check your PM!

$500 USD dalam 10 hari
(0 Ulasan)
0.0
srilatha74

We can do it

$450 USD dalam 10 hari
(0 Ulasan)
0.0
contactisoft

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

$400 USD dalam 7 hari
(0 Ulasan)
0.0
dilshat

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

$300 USD dalam 3 hari
(0 Ulasan)
0.0
ankesh13

We will provide you the quality solution in your require timeline

$400 USD dalam 10 hari
(0 Ulasan)
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 dalam 10 hari
(0 Ulasan)
0.0
Digitplex

Hi Buyer Please see the PMB. Thanks

$250 USD dalam 10 hari
(0 Ulasan)
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 dalam 10 hari
(0 Ulasan)
0.0
sslsoftwares

we have done such projects

$550 USD dalam 10 hari
(0 Ulasan)
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 dalam 5 hari
(0 Ulasan)
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 Lagi

$500 USD dalam 10 hari
(0 Ulasan)
0.0