**Brief High Level Summary/Project:**
We need a secure database application that allows us to pay brokers' commissions via ACH/direct deposit and via paper checks. Application needs to perform simple calculations and provide a variety of simple pre-scripted reports. Database application needs to be accessible over a small office network. (More specific features/needs will follow.)
**Please note: We strongly prefer local, Elk Grove/Sacramento, CA candidates, but will consider developers from the Northern California Bay Area.
If interested, please provide a time and cost estimate for the project that I have described.
If you have already created an application similar to what I have described, please be sure to tell us about it.
We prefer a smart, communicative, down-to-earth developer who is also a great project manager because we need him/her to be self-managed.
I have been collecting a list of features, but expect the developer to help me refine the software requirements.
Anticipate that the developer will be selected based on past similar projects completed, qualifications, location, ease of communication, and cost.
We look forward to hearing about your solution! Thank you for your interest!
I have been collecting a list of features, but expect the developer to help me refine the software requirements (after a bidder is selected).
**Here are a few features (not an all-inclusive list):**
?€? Two or more users must be able to connect concurrently through the local area network to the database server.
?€? Calculate commissions based on the premium, splits, life company commission, percent-payout and life company fees (if applicable).
(Refer to "~sales_sheet self-contained.pdf." I anticipate that this document will used for data entry.)
?€? Flexible payout rules that can change. Need to be able to alter payouts, and splits. (For example, some brokers will do split tiers of their commissions based on premium dollar amounts. Say you have a total premium of $20mil. and at $5 million production you'll split: 80% of commission the commission to Joe Broker, 10% to SPI, 10% to Sue Broker; remaining $15mil premium is then subject to further tiers-splits. (Can provide an example later.)
Basic broker contract is to split 90%-10% of their 4% commission based on a premium. (Refer to "~[url removed, login to view]" for the basic breakouts).
?€? Ability to run scheduled back-ups (need a back-up/recovery solution ?).
?€? Security features (need bank acct information encrypted?)
?€? Easy database user maintenance (i.e. User permissions, accounts)
?€? Ability to add and remove brokers, change business relationships.
?€? (Very important) Ability to suppress/suspend commission payouts. For example, an unlicensed broker should not be paid. We may have received commissions but need to suspend paying them to broker. (Reconcile commissions and credit broker, but do not pay.)
?€? Need to be able to easily handle charge backs, premium adjustments,
?€? Some data entry validation. For example: Force dollar amounts to be keyed twice (pass field on match) to help with quality control or key the premium/production and commission amounts twice, etc;
?€? Application will need to create a NACHA ACH file
- When broker's ACH has been initiated/ we need an email or fax
to go out to broker stating the dollar amount, case name and life company
for the commission payment.
**Paper Check Payments:**
- Application will need to print out commission checks
(The "[url removed, login to view]" shows a report on a check-run.
We may need a similar report for checks and ACH payments.)
Prefer to have pre-scripted reports. (See example reports attached:"[url removed, login to view]," "report_production_by_month.pdf.")
?€? Report of money received that is unaccounted-for/unmatched. This report should at least include the case name, life company, date of receipt, and the commission amount.
?€? Report of outstanding commissions ?€" for example a report of unpaid
commissions older than 21 days.
?€? Report and derived totals of the Overrides account amounts (monthly and year-to-date). For each broker and life company: monthly and year-to-date production and commission totals. (See [url removed, login to view] and [url removed, login to view] examples.)
?€? Report on commission and production changes for cases other than the
current month. (This will help us reconcile any end-of-month discrepancies
when charge-backs or adjustments have been made.) (Maybe we won?€™t need this because the data is now centralized?)
?€? Other reports:
o End-of-month and yearly report for both Commissions and Overrides
accounts (may be able to use the other reports above)
o End-of month and yearly report of commission check/payment ?€œdetail?€
o General ledger/balance report of commission account
- General ledger/balance report for Overrides Acct
Applications have been submitted (sorted by case name)
Contracts that have been mailed (sorted by broker and case name)