Commission Tracking Software

Closed Posted May 31, 2010 Paid on delivery
Closed Paid on delivery

I am an independent insurance agent, and myself and several other agents have been looking for a software that would allow us to input a policy when sold that shows the monthly amount we should be getting paid by each carrier per pay cycle. This does have several hang ups. Each carrier pays on different schedules, and the commission percentages change over time.

For example.

Mutual of Omaha pays 18% per year for first 6 years, pays a 12 month advance commission (full 12 months paid at once) on the first year, then pays 10% for years 7-10, and 1% per year afterward until policy is cancelled.

UnitedHealthCare pays 20% first year, with a 6 month advance, then pays 5% per year after until policy cancellation.

It would be optimal that each carrier line could be put in the system, grouped by carrier, with subgroups of policy type (because each carrier may have different types of policy that are paid differently), then could be selected by a dropdown after they were put into the system for ease of entry.

After entry, it should show the monthly total due, and monthly amount due per carrier, and be possible to pull up the monthly due per policy.

Policies should be able to be removed easily if cancelled.

It should also be capable of showing a "charge back" which is when an advance commission is cancelled before the months which were advanced have passed, and the insurance company is owed the money back.

I believe this could be accomplished using an access database, but lack the skill to do it myself.

## Deliverables

1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the worker's Worker Legal Agreement).

A working database with working entry front end system that can be used to accomplish the outlined tasks above.

## Platform

Windows based xp and above.

Accounting MYOB

Project ID: #3467404

About the project

18 proposals Remote project Active Jun 22, 2010

18 freelancers are bidding on average $373 for this job

Euphontec

See private message.

$340 USD in 14 days
(2 Reviews)
1.9
mukesh339

See private message.

$425 USD in 14 days
(3 Reviews)
1.5
quickprogexpert

See private message.

$425 USD in 14 days
(1 Review)
0.8
kingfenix

See private message.

$382.5 USD in 14 days
(0 Reviews)
0.0
eSoftTech

See private message.

$425 USD in 14 days
(0 Reviews)
0.0
NeilSmith1962

See private message.

$297.5 USD in 14 days
(0 Reviews)
0.0
dotnetgain

See private message.

$255 USD in 14 days
(0 Reviews)
0.0
eddielonzanida

See private message.

$425 USD in 14 days
(0 Reviews)
0.0
deltatechnologix

See private message.

$425 USD in 14 days
(0 Reviews)
0.0
progress1

See private message.

$408 USD in 14 days
(0 Reviews)
0.0
muzammaljanjua86

See private message.

$399.5 USD in 14 days
(0 Reviews)
0.0
yenduttjain

See private message.

$425 USD in 14 days
(0 Reviews)
0.0
envisionops

See private message.

$297.5 USD in 14 days
(0 Reviews)
0.0
manojkar

See private message.

$425 USD in 14 days
(0 Reviews)
0.0
swordbrokenvw

See private message.

$297.5 USD in 14 days
(0 Reviews)
0.0
jameszhao00

See private message.

$425 USD in 14 days
(0 Reviews)
0.0
koolmind1

See private message.

$425 USD in 14 days
(0 Reviews)
0.0
perfectwebs

See private message.

$212.5 USD in 14 days
(0 Reviews)
0.0