Closed

Mail-in Rebate Administration System

This project received 16 bids from talented freelancers with an average bid price of $1145 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$750 - $1500 USD
Total Bids
16
Project Description

specs in attachment


Mail-in Rebate System
Project Goal: Web Based System that allows the input, manipulation and reporting of Mail-In Rebate Data
Input of Mail-in Rebate Data
• First name
• Last Name
• Address
• City
• State
• Zip
• Email address
• Tax ID (not required)
• Date of Birth
• Retailer
• Brand
• Reference (not required)
• Paid Out Date (not required)
• Pay or Not Pay (selection)
• Status: Approved/Denied/Not yet Redeemed/Duplicate (selection, not required)
Security and Authentication
• https with password authentication (because we could be storing SS information), your going to need this data behind a firewall in PCI compliance environment.
Reporting (.pdf or excel)
• Mail-ins by Retailer by State – IE # of Mail Ins in August Program, report similar to the one broken down by States below
• All Approved/Denied by Retailer – For a data range, view all approved/denied entries by a specific Retailer.
• Filters
o By default do not show Denied/ Not yet Redeemed, with the option to view those
Exportation of Data
• Export of data to check processor in proper format
• Option to mark all exported data as approved and set paid-out date
Tools
• Find and View Duplicates – Report that would find all sets of duplicates for a Retailer/Brand/All and filtered by date range and an option to mark each one as a duplicate if needed.
Show the following information in the tool: Payee name, Reference, Payout Amount, Street City, State, Zip, Country, Retailer, Brand
Find and View Likes - Report that would find all sets of like entries(similar but non-exact information) for a Retailer/Brand/All and filtered by date range and an option to mark each one as a duplicate if needed.
Show the following information in the tool: Payee name, Reference, Payout Amount, Street City, State, Zip, Country, Retailer, Brand
Import Data from Excel – either the programmer can do it one-time or we can create a tool to have you import the data from an excel spreadsheet
Search Tool – Find specific entries by name, address, zip, Brand, Retailer, Reference with option to override any of the information

Example Report:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online