Cancelled

Simple Client Database required urgently

Require a php/mysql driven site that contains an editable list of clients/owners and their properties. We need the ability to invoice them for every service we perform on a particular property and need to know if an invoice has been paid or is outstanding.

Specifically:

Information stored about “Client/Owner “

• Contact Person

• Address

• City

• Province

• Postal Code

• List of Properties we service

Information about Properties:

• Tax Roll number (unique identifier)

• Type of Property

• Address

• City

• Province

• Postal Code

• Appeal Deadline (Day and Month only)

• “Notes Section” need the ability to add several different notes to a specific property file

• Invoices that have been billed to the Client/Owners

o Status of such invoice: Paid or unpaid?

Invoices

• When a particular property Invoices are billed to the “Client /Owner” (first part of information on invoice) with respect to service performed on a specific property (second part of information on invoice). The invoice would have our letterhead and the ability for us to add amounts that are being billed, notes explaining the transaction, a place to add sales tax

• Each invoice would have a different invoice number (unique identifier)

• We need to be able to indicate that the invoice has been paid

Queries

• Need to be able to search for all properties by:

o Tax Roll number (would produce one search result)

o Client/Owner (would show all properties of client/owner that we provide service for)

o Province (would show all properties located in a particular province)

o City (would show all properties located in a particular city)

o Type of Property (would show all properties of a certain type that we provide services for)

o Paid invoices (would show list of all properties that have paid invoices)

o Unpaid invoices (would show list of all properties whose invoices have not yet been paid)

o Appeal Deadline (would show sorted by date, all properties' appeal deadlines)

• Need to be able to search for invoices:

o Invoice number (this would show one search result)

o Unpaid Invoices (this would show all invoices that are unpaid)

- Invoice date (this would list all invoices by date)

I require the ability to have 3 administrator accounts.

FYI - The nature of our business is: Fairtax appeals the property taxes for owners' various properties. Upon successfully doing so, we invoice the owner for our services with respect to that specific property.

Skills: PHP, SQL

See more: sql database business, simple file database, services database, person required for accounts, business owners database, mysql database administrator service, mysql client, TAXES, tax and accounts, simple letterhead, service tax, service database , mysql database administrator, invoices/month, database queries, database administrator, client services, appeal, simple notes database, list sorted, city code able, simple contact database, mysql number sql, queries database, billed

About the Employer:
( 0 reviews ) Delhi / NCR, India

Project ID: #584667

27 freelancers are bidding on average $308 for this job

phpplay

Please check PM. Thanks

$525 USD in 7 days
(21 Reviews)
5.8
worldofharry

Hello, I have excellent rating on ScriptLance (worldofharry). I can do this with ease. On request, I can also share a link with similar operations for reference. Thanks!!!

$199 USD in 5 days
(28 Reviews)
4.7
santakamal

I am well experienced in PHP, MySql based Custom CMS based site. I can do this project. Please see PMB.

$200 USD in 15 days
(7 Reviews)
4.1
zencartin

Hi , We are interested , Please check PMB...

$800 USD in 7 days
(2 Reviews)
3.3
jamsabhi

Please check PMB

$600 USD in 10 days
(4 Reviews)
3.1
webhotdesign

Hi Sir,we can do this,Please view PMB,thanks

$250 USD in 15 days
(2 Reviews)
3.3
axeacc

Hi, Please check PM for details. Thanks

$250 USD in 8 days
(4 Reviews)
2.6
jenwork

Interested in your [url removed, login to view] to hear from you

$200 USD in 10 days
(3 Reviews)
2.6
benbowler

I've built similar software for local business. I have the required experience in PHP and MySQL and can complete the project in 5 days. I'm a genuine freelancer from Britain looking to build my portfolio. You can see m More

$160 USD in 5 days
(1 Review)
1.4
karanraina2009

hi i will do your project. plz check pm,b regards karan

$900 USD in 7 days
(0 Reviews)
0.0
dhanasekartech

I can do this.. please let me know.

$125 USD in 15 days
(0 Reviews)
0.0
PSNInfotech

Please read your PMB. Regards, PSN Infotech Solutions

$200 USD in 15 days
(0 Reviews)
0.0
sunnytn

I have a very good team of web developers and we can do this work with our full concentration and you have a good quality for further projects.

$150 USD in 22 days
(0 Reviews)
0.0
AlexeiBo

Hi! I'm ready to create your project. With regards, Alexei

$400 USD in 11 days
(0 Reviews)
0.0
adi25

Hello, I am sure. I can do this job.

$70 USD in 3 days
(0 Reviews)
0.0
Ranjeet76

We will fullfill all your requirements.

$31 USD in 2 days
(0 Reviews)
0.0
thedzibans

We are a ten member team who have professionally mastered the skills of Web Design and Development. We provide excellent quality service within our clients’ budget to their utmost satisfaction. We offer an outstandi More

$225 USD in 15 days
(0 Reviews)
0.0
xpertcsv

Expert work from Xperts!!

$250 USD in 5 days
(0 Reviews)
0.0
monalizz

After understanding the project i would take less take very less time time to finsh the project.

$30 USD in 2 days
(0 Reviews)
0.0
ranesh26

Hi I can develop this client database. I will sent pm with further details. Thank.

$250 USD in 7 days
(5 Reviews)
0.0