Clients and Fees

The "Clients and Fees" database is designed to help manage client relationships and project billing for a company. It includes tables for clients, invoices, projects, staff, staff on projects, and staff skills.
Clients and Fees Database Illustration


The "Clients" table stores information about the company's clients, including their name, the date they became a client, address, and other details that might be relevant to the company's interactions with them.

The "Invoices" table tracks information about invoices sent to clients, including a unique reference number, the status of the invoice (such as whether it has been paid or is overdue), the date it was issued, the date it was paid, any discounts applied, and other details that may be relevant to the invoice.

The "Projects" table records information about projects that the company is working on for clients, including the name of the project, the client it is for, the start and end dates, a description of the project, other relevant details, and a reference to the invoice that will be used to bill the client for the work.

The "Staff" table stores information about the company's employees, including their name, a photo, their job type, phone number, email address, address, and other details that might be relevant to their employment.

The "Staff On Projects" table links staff members to the projects they are working on, along with their role on the project, the dates they are working on it, and their hourly rate for the work.

The "Staff Skills" table records information about the skills that each staff member possesses, along with their level of expertise in each skill. This table can be used to help assign staff members to projects that require specific skills.

To help you make the system work for your needs, we have developed the following service program:

  • Discuss your needs with our staff.
  • We’ll determine and confirm the workflow logic of your database.
  • We’ll create a ready-to-use database to fit your exact business model.
  • You’ll get a solution designed especially for your needs.

Any support materials, such as spreadsheets and real-life work samples would be very helpful as they would help us better understand your business process.

We offer free system configuration assistance
(up to 4 hours of consulting work).

If you decide that our database is not exactly what you need - you owe nothing.
Like what you see? Try Clients and Fees Database today!