Find Jobs
Hire Freelancers

Database Application for Paying Commissions

$30-5000 USD

Cancelled
Posted over 15 years ago

$30-5000 USD

Paid on delivery
**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! ## Deliverables 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 "~[login to view URL]" 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, reimbursements, advancements. ?€? 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; **ACH Payments:** ?€? 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 "[login to view URL]" shows a report on a check-run. We may need a similar report for checks and ACH payments.) **Reports:** Prefer to have pre-scripted reports. (See example reports attached:"[login to view URL]," "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 [login to view URL] and [login to view URL] 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 Nice-to-haves: Applications have been submitted (sorted by case name) Contracts that have been mailed (sorted by broker and case name)
Project ID: 3386582

About the project

Remote project
Active 15 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Nov 12, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.