top of page
MT Logo.jpg

1. Client Information:

1.1 Details Client:

  • Client ID: 9965DR67UH67

  • Company Name: Mahendra Technosoft

  • Contact Information:​  

    • Primary Contact:​

    • Billing Contact:​

    • Technical Contact:​

    • Physical Address:​

      • House/Building Number: ​903, F-Block

      • Street Address: Aura County, Ubale Nagar, Wagholi 

      • City: Pune

      • State: Maharashtra

      • Postal Code: 412207

      • Country: ​​​​​India

1.2 Contact Details:

  • Contract ID : 7858586

  • Contract Start Date: 13/12/2019

  • Contract End Date: 13/12/2029

  • Contract Type: annual, monthly, project-based

  • Contract Terms : pdf.file [A brief summary of key contract terms or a link to a full contract document (PDF, online document)]

  • Contract Value : 

  • Contract Value: $25,000

    • Breakdown of Contract Value:

      • Website Design: $5,000

      • Development and Coding: $12,000

      • E-commerce Integration: $5,000

      • SEO and Testing: $3,000

    • Payment Terms:

      • 40% upfront ($10,000)

      • 40% after project milestones are reached ($10,000)

      • 20% upon project completion and approval ($5,000)

  • Renewal Date : 14/12/2029

1.3 Account Status (Active/Inactive):

  • Account Status: "Active," "Inactive," "Suspended," "Pending"

  • Status Change Date: 14/02/2024

  • Status Change Reason : "Contract expired," "Client request," "Non-payment"

2. Services Information:

  • Service ID : 5886594758

  • Service Name: Digital Marketing

  • Service Description: Digital Marketing is the cornerstone of business success in today’s digital-first world.

  • Service Features/Specifications

    • List Format

      • Custom Design: Fully responsive, modern, and user-friendly layouts.

      • E-commerce Integration: Shopping cart, payment gateway integration, and product catalog setup.

      • Content Management System (CMS): Easy-to-use platform for managing website content (e.g., WordPress, Joomla).

      • SEO-Friendly Architecture: Optimized structure, meta tags, and site speed for better search engine ranking.

      • Ongoing Support: Bug fixes, security updates, and minor content updates.​​

  • Service Start Date (for the client): 12/2/2023

  • Service End Date (for the client, Optional): 15/2/2025

  • Service Status (for the client): Active

  • Service Level Agreement (SLA) (Optional): pdf

  • Related Resources/Documentation (Optional): Documents

screenshot-20250124-234239.png

3. Domain Information:

  • Domain ID: 123455891

  • Domain Name: mahendratechnosoft.com

  • Registration Date:12/2/2023

  • Expiry Date:12/2/2029

  • Registrar: GoDaddy, Namecheap, Google Domains

  • Domain Status: "Active," "Pending Transfer," "Expired," "Redemption Period"

  • Name Servers:  ns1.example.com, ns2.example.com

  • WHOIS Privacy: Indicates whether WHOIS privacy protection is enabled for the domain. [enabled]

  • Auto-Renewal: Indicates whether auto-renewal is enabled for the domain. [enabled]

  • Domain Email Accounts: [Domain email related data]

4. Website Hosting Information:

  • Hosting Account ID: 4587895687

  • Hosting Plan: "Shared Hosting," "VPS Hosting," "Dedicated Server," "WordPress Hosting"

  • Renewal Date: 14/11/2026

  • Storage Quota: 10GB, 50GB, 100GB [The total storage space allocated to the hosting account]

  • Storage Used: 5GB, 25GB, 70GB [The current amount of storage space being used]

  • Bandwidth Quota: 100GB, 500GB, 1TB [The monthly bandwidth allowance]

  • Bandwidth Used: 500GB [The amount of bandwidth used in the current billing cycle]

  • Server Location: "US East," "EU West," "Asia Pacific"

  • Control Panel: cPanel, Plesk, DirectAdmin

  • SSL Certificate Status: Expired

  • Backup Status: Backup frequency: Weekly

  • Uptime: 99.9% uptime guaranteed

5. Email Information:

  • Email Account ID: 45879859458.

  • Domain ID: 4587584525.

  • Email Address: info@mahendratechnosoft.com.

  • Email Platform: Google Workspace

  • Account Status: Active

  • Storage Quota: 50GB

  • Storage Used: 5GB

  • Last Login: 14/5/2024, 7:30 PM.

  • Forwarding Addresses : Baner, Pune

  • Aliases:sales@mahendratechnosoft.com

  • Email Client Configuration Details: incoming/outgoing mail servers

6. Project Information:

  • Project ID : 2565891475866

  • Client ID : 5868959222

  • Project Name: Pharmagrowth

  • Project Description: Pharmagrowth specializes in providing tailored growth solutions for businesses in the pharmaceutical and healthcare sectors.

  • Service Type: Web Development.

  • Project URL : https://www.pharmagrowthhub.com/

  • Included Project Services: many-to-many relationship as a project can have multiple services and a service can be part of multiple projects

  • ProjectServiceID : 587948578

  • Project ID :125DH26637

  • Service ID :58745895455

  • Tools and Technologies Used: WordPress

  • Project Start Date: 12/1/2024

  • Current Phase: Development

  • Estimated Completion Date: 12/2/2025

  • Actual Completion Date : 14/2/2025

  • Progress : 30%

  • Deployment Status: Pending

  • Deployment Environment: Production

  • Deployment Date: 14/2/2025

  • Deployment Notes (Optional): Production

  • Materials & Resources: This can be handled in several ways:

  • File Storage/Links: Cloud Storage

  • Embedded Documents: For smaller documents, you might store the content directly in the database (less common for large files).

  • Fields in the database could be:

  • Resource ID:124578689

  • Project ID:5689484588

  • Resource Name: Development

  • Resource Type: Document

  • Resource : https://www.mahendratechnosoft.com/

  • Project Team : Information about the team members working on the project.

  • ProjectTeamID :58976895

  • Project ID:586897896

  • User ID:5689785289

  • Role: Developer

  • Database Design: Expanded

  • Projects Table: Includes all fields mentioned above except related tables

  • ProjectServices Table: Junction table for the project-service relationship

  • ProjectResources Table: For materials and resources

  • ProjectTeam Table: For project team members

  • Client Portal Display:

  • Project Overview : Cards

  • Project Name: Development

  • Service Type: Business consulting

  • Current Phase: Initiation

  • Estimated Completion Date: 16/11/2022

  • Progress: Hold

  • Project details: It is related to content creation, website design, consulting services, or something else

  • Project Description: Do you need help drafting a project proposal, timeline, or plan

  • Project URL: https://www.interioprop.com/

  • Included Services: Business consulting

  • Tools and Technologies Used: Wix Studio

  • Project Start Date: 15/06/2021

  • Current Phase: Incomplete

  • Estimated/Actual Completion Date: 15/02/2024

  • Deployment Status : Completed

  • Materials & Resources: Document

  • Project Team: Name with Development Team

7. Assigned Manager Contact Information:

  • Manager ID : 58798965456

  • Manager Name: Punam Sharma

  • Job Title/Role: Project Manager

  • Phone Number: +91-6897895895

  • Email Address: info@mahendratechnosoft.com

  • Profile Picture/Avatar : Photos

  • Department/Team : IT Department

  • Brief Bio/Introduction : Introduction

8. Invoices/Billings Information:

  • Invoice ID: 6897568956

  • Client ID: 9685874589

  • Invoice Number: INV-2024-10-001

  • Invoice Date: 25/5/2024

  • Due Date: 16/02/2024

  • Invoice Items: Products

  • InvoiceItemID:8989654789

  • Invoice ID: 6DH568955 

  • Item Description: Details

  • Quantity: 8

  • Unit Price: $56548

  • Total Item Price: $5468

  • Subtotal: 658455156

  • Tax Amount: 588795615

  • Discount Amount:  45%

  • Total Amount: 273763

  • Payment Status: Paid

  • Payments: This requires a separate table to track payments made against invoices:

  • Payment ID: 8565465

  • Invoice ID: 4584688

  • Payment Date: 25/5/2023

  • Payment Method: Credit Card 

  • Payment Amount: $5564

  • Calculations: 4568655615

  • Remaining Amount: $45564

  • Total Outstanding Balance: $456

  • Total Revenue: $4556569562

9. Support tickets

  • Invoice ID: 6897568956

  • Client ID: 9685874589

  • Invoice Number: INV-2024-10-001

  • Invoice Date: 25/5/2024

  • Due Date: 16/02/2024

  • Invoice Items: Products

  • InvoiceItemID:8989654789

  • Invoice ID: 6DH568955 

  • Item Description: Details

  • Quantity: 8

  • Unit Price: $56548

  • Total Item Price: $5468

  • Subtotal: 658455156

  • Tax Amount: 588795615

  • Discount Amount:  45%

  • Total Amount: 273763

  • Payment Status: Paid

  • Payments: This requires a separate table to track payments made against invoices:

  • Payment ID: 8565465

  • Invoice ID: 4584688

  • Payment Date: 25/5/2023

  • Payment Method: Credit Card 

  • Payment Amount: $5564

  • Calculations: 4568655615

  • Remaining Amount: $45564

  • Total Outstanding Balance: $456

  • Total Revenue: The sum of all Total Amount values for invoices within a specific date range.

bottom of page