
Closed
Posted
Paid on delivery
Windows and doors sales sheet base on square meter!! Google Sheets & AppSheet Developer Needed for Quotation, Invoice & Sales Tracking System Description We are looking for an experienced Google Sheets and AppSheet developer to build a professional quotation, invoice, and sales tracking system for our company. The system will be based on Google Sheets + AppSheet and will be used daily by our sales team. The goal is to create a simple but powerful internal system that manages: Customers Quotations Invoices Receipts Sales performance tracking Main Features 1. Customer Database The system must store and organize customer information, including: Customer Name Phone Email Address Project location Notes This will allow us to maintain a complete customer list that we can access anytime. 2. Quotation System Users must be able to create quotations based on price per square meter. Categories will include for example: Aluminum PVC Glass Other materials The system must automatically calculate totals. Every new quotation must automatically generate a unique quotation number. 3. Discount Control The Admin must control the maximum discount each user can give. Example: Salesperson A → max 5% discount Salesperson B → max 10% discount Users cannot exceed the discount percentage set by the Admin. 4. Invoice System Each quotation must be able to generate up to 3 invoices, such as: Deposit invoice (example 50%) Progress invoice (example 30%) Final invoice (example 20%) The percentages must be adjustable. Each invoice must automatically generate a unique invoice number. 5. Receipt System After payment of each invoice, the system must generate a receipt. Typical workflow: Quotation → Invoice 1 → Receipt 1 → Invoice 2 → Receipt 2 → Invoice 3 → Receipt 3 Each receipt must generate a unique receipt number automatically. 6. Project Completion & Feedback When the project is finished, the system must allow us to record: Customer feedback Project notes Completion status All information must remain stored for future reference. 7. Sales Performance Tracking The system must track the performance of each salesperson. We need to see: How many quotations each salesperson created How many quotations were successfully closed Sales value generated There must also be a visual graph/dashboard that shows the performance of each salesperson. 8. Admin Control Panel The Admin must be able to: Set price per square meter for different product categories Manage users Control maximum discount percentage per user View all data View sales statistics Perform data backups 9. Multi-User System The system should support up to 10 users. Each user can see only their own quotations and invoices The Admin can see everything 10. Data Storage All data must be stored in Google Sheets, with a clean and organized structure. 11. Interface The system must be built with AppSheet and be easy to use on: Mobile Tablet Desktop Requirements Strong experience with Google Sheets Strong experience with ability to build a clean and scalable structure Project Goal Build a reliable internal system that allows our company to: manage customers create quotations generate invoices and receipts track sales performance store project feedback
Project ID: 40282571
85 proposals
Remote project
Active 6 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
85 freelancers are bidding on average $140 USD for this job

Hello, As an experienced Google Sheets and AppSheet developer, I bring top-notch skills in database development and mobile app development to the table. My team at Our Software has a proven track record of delivering high-quality projects that prioritize user experience, scalability, and clean data organization - all attributes crucial for the system you're seeking. With our capabilities, we will provide a centralized system with clean data storage in Google Sheets that can be easily accessed from mobile, tablet, and desktop devices. Moreover, we understand the significance of managing customer relationships efficiently for any business. By creating a robust Customer Database, we'll intensify your ability to access historical customer information such as project locations, notes, contacts, etc., anytime you need. Closely aligned with this is our proficiency in designing Quotation Systems that will provide accurate price calculations based on square meter measurements for various product categories like Aluminum, PVC, Glass among others. Additionally, our expertise extends to implementing features which will allow Admins to granularly control discount percentages individual salespersons can offer while quoting. Not only this but also setting item prices as per square meter will be a breezy job for us. And if you- like every entrepreneur- worry about data security then let me assure you that it won't be a concern with us. Being deta Thanks!
$130 USD in 3 days
8.6
8.6

Hi there, ★★★ GOOGLE SHEETS Expert ★★★ 7+ Years Experience ★★★ I understand you need a system for managing customers, quotations, invoices, and sales tracking. My approach will be: - Create a customer database in Google Sheets. - Build a quotation system that calculates totals automatically. - Set up discount controls for each user. - Develop an invoice and receipt system with unique numbers. - Add a dashboard for sales performance tracking. What is your budget for this project? Let's discuss this further. Regards, Burhan Ahmad
$450 USD in 14 days
8.4
8.4

Hi, I understand the challenge of building an efficient and scalable sales tracking system tailored for your windows and doors business. With my strong expertise in Google Sheets, AppSheet, and database structuring, I can craft a seamless internal system to manage customers, quotations, invoices, receipts, and sales performance with precision and ease. I have extensive experience designing multi-user platforms with admin controls, automated unique number generation, discount restrictions, and dynamic dashboards for strategic insights. My approach will ensure your sales team can access and operate the system easily across mobile, tablet, or desktop devices while maintaining data integrity and security. I’ve shared an initial estimate based on your description, and once we go over a few technical or functional details, I’ll confirm the exact cost and delivery schedule. I propose to start with data structure planning and AppSheet interface design, aiming to deliver a robust MVP within 7 days. What specific user roles and permissions, beyond admin and salesperson, do you foresee needing in the system? Thanks, Asad
$75 USD in 3 days
8.2
8.2

As an experienced Full stack developer for over 7 years, I strongly believe I have what it takes to deliver an exceptional internal system that perfectly fits your needs. Having worked with top companies Metlife GOSC, DXC technologies and Elite Services, I am no stranger to complex projects and providing top-notch digital solutions for businesses. Firstly, my strong experience with Google Sheets is a major asset to your project. I am very familiar with developing clean and scalable structures on the platform which aligns perfectly with your project requirement of a well organized and efficient data storage system. Secondly, my extensive background in Database Development and Software Architecture will be paramount in creating a robust quotation, invoice and sales tracking system that is easily manageable, efficient and reliable. Lastly , my commitment to "100% Employer Satisfaction" extends beyond just completing a project but maintaining long-term, professional relationships with clients. This means you can expect continuous support even after the delivery of this project. I am available EST TIME from 8 AM TO 12 PM, So let's get started on this project together!
$220 USD in 4 days
7.8
7.8

Hello, I’ve carefully reviewed your project requirements and fully understand your need for a robust quotation, invoice, and sales tracking system based on Google Sheets and AppSheet. I can confidently handle this project and deliver a system that is both user-friendly and scalable for your sales team. My approach will begin by structuring a clean, well-organized Google Sheet backend with separate tabs for customers, quotations, invoices, receipts, and performance tracking. I will implement dynamic formulas and data validation to calculate totals, enforce discount limits, and auto-generate unique IDs for quotations, invoices, and receipts. Using AppSheet, I will create an intuitive interface for mobile, tablet, and desktop access, ensuring multi-user access with admin controls for pricing, user management, and sales dashboards. Visualizations and performance graphs will be integrated to track sales effectively. To ensure smooth operation, I will provide a quick “how-to” guide for data entry, updates, and future scaling. Would you like the dashboard to include real-time updates of salesperson performance by project completion? I’m ready to start immediately and deliver a fully functional system tailored to your needs. Best Regards, Aneesa
$150 USD in 1 day
7.3
7.3

Hi, there, I'm an experienced Google Sheets and AppSheet developer with a strong background in creating internal systems for companies. With a focus on customer management and sales tracking, I am confident in delivering a professional solution tailored to your needs. ✅ To start, I will design a customer database to store essential information such as names, contact details, and project locations for easy access. ✅ Next, I will develop a quotation system based on price per square meter, including categories like Aluminum, PVC, and Glass, with automatic total calculations and unique quotation numbers. ✅ For invoice management, I will implement a system that generates up to 3 invoices per quotation with adjustable percentages and unique invoice numbers. ✅ Discount control will be a key feature, allowing admin to manage maximum discounts for each user to ensure pricing integrity. ✅ Finally, I will create a user-friendly interface using AppSheet for seamless usage across mobile, tablet, and desktop platforms. I look forward to working with you. Best Regards. Brayan
$200 USD in 3 days
6.1
6.1

Hello, I’ve gone through your project details, and this is something I can definitely help you with. With over 10 years of experience in mobile and web app development, including expertise in Google Sheets and AppSheet, I can create a tailored system for managing customers, quotations, invoices, and sales tracking for your team. I prioritize clean structure and scalability to ensure your internal processes run smoothly. I will review your requirements, develop a robust system that meets your needs, and keep you updated throughout the process. You can view my portfolio here: https://www.freelancer.in/u/ixorawebmob I’m interested in your project and would love to understand more details to ensure the best approach. Could you clarify: 1. Do you have specific design preferences for the interface? 2. Are there any additional features or integrations you'd like to include? 3. What's your expected timeline for completion? 4. How do you envision monitoring the performance of the sales team? Let’s discuss over chat! What specific design preferences do you have for the interface? Regards, Arpit
$155 USD in 25 days
7.5
7.5

I've built several Google Sheets + AppSheet systems for construction and building material companies, so your windows and doors quotation system based on square meter pricing is right in my wheelhouse. I'll structure your Google Sheets backend with linked tables for Customers, Quotations, Invoices, and Receipts, then build an AppSheet front-end your sales team can use on any device. The quotation engine will auto-calculate totals from sq/m pricing across your material categories (Aluminum, PVC, Glass), while admin-controlled discount caps per salesperson ensure pricing integrity. I'll implement your split-invoice logic (deposit/progress/final) with auto-generated quotation numbers and a sales performance dashboard. I can start immediately.
$30 USD in 1 day
6.0
6.0

Hi, I’ve read through your requirements and it sounds like your sales team needs a system that just works simple, reliable, and easy to use. I can build a Google Sheets + AppSheet solution that: Creates quotations, invoices, and receipts automatically, based on price per square meter Tracks discounts per salesperson and ensures they stay within limits Gives you clear visibility into each salesperson’s performance through dashboards Stores customer feedback and project notes for future reference I focus on building systems that make everyday tasks smoother, so your team can spend less time on spreadsheets and more time closing deals. If you like, I can sketch a small mockup showing how this workflow would look in practice. Looking forward to your thoughts,
$200 USD in 7 days
6.1
6.1

Hi there,Good afternoon I am Talha. I have read you project details i saw you need help with Microsoft Access, Google Sheets, Project Management, MySQL, Automation, Software Architecture, Mobile App Development, Data Management, PHP and Database Development I am pleased to present my proposal, highlighting our extensive experience and proven track record in delivering exceptional results. Our portfolio of success will showcase past projects that demonstrate our ability to meet and exceed client expectations. Glowing testimonials from satisfied clients will attest to our professionalism, dedication, and the quality of our work Please note that the initial bid is an estimate, and the final quote will be provided after a thorough discussion of the project requirements or upon reviewing any detailed documentation you can share. Could you please share any available detailed documentation? I'm also open to further discussions to explore specific aspects of the project. Thanks Regards. Talha Ramzan
$30 USD in 11 days
5.8
5.8

Hello, I am an expert with 15+ years of experience in the technical world, delivering simple to complex websites, e-commerce platforms, membership systems, and custom portals. I ensure clear communication, continued support after delivery, and 100% client satisfaction. I specialize in Mobile App Development, creating fast, user-friendly, and feature-rich apps for both Android and iOS. My focus is on modern UI/UX, API integration, real-time features, and cross-platform compatibility, ensuring your app is scalable and future-ready. If you are looking for a dedicated Mobile App Developer who delivers quality, innovation, and timely results, I’d be happy to bring your project to life. Best regards,
$100 USD in 7 days
5.6
5.6

Greetings, I see that you're looking to create a comprehensive internal system using Google Sheets and AppSheet for managing customer data, quotations, invoices, and sales tracking. This system will streamline your sales team's daily operations, allowing them to efficiently manage customer information, generate accurate quotes, and track sales performance. To tackle this project, I would start by designing a clean and organized customer database that allows easy access to all necessary information. Next, I'd implement the quotation system to automatically calculate totals and generate unique IDs, alongside a robust invoice and receipt system that follows your outlined workflow. I’ll ensure the admin control panel is user-friendly, allowing for easy management of discounts and user permissions. With my strong experience in Google Sheets and app development, I can deliver a tailored solution that meets your needs effectively. Best regards, Mehran Riaz
$130 USD in 5 days
5.4
5.4

Hello, With over 6 years of experience in PHP, Database Development, and MySQL, I have a strong background in developing professional systems like the one you are looking for. I understand your requirement for a quotation, invoice, and sales tracking system using Google Sheets and AppSheet. I am confident in providing a clear and efficient solution that will effectively manage customers, quotations, invoices, receipts, and sales performance tracking, meeting all the specified features and requirements. I would like to connect with you in chat to discuss more about your project and how I can assist you in achieving your goals. Thanks.
$250 USD in 7 days
5.0
5.0

Hi there, I appreciate the detailed description of what you're looking for. It sounds like you need a user-friendly system that can efficiently manage customer data, quotations, invoices, and track sales performance for your windows and doors business. With my 4+ years of experience in Google Sheets and AppSheet, I can help you create a structured and scalable solution that meets all these needs. My approach would involve setting up a clean database for customer information, implementing automatic calculations for quotations, and ensuring unique identifiers for invoices and receipts. Additionally, I would create an admin panel for you to manage discounts and user access effectively. One question I have is regarding the specific categories you want for materials in the quotation system. Are there any additional product types you would like to include beyond aluminum, PVC, and glass? Best regards, Arslan Shahid
$30 USD in 3 days
5.0
5.0

Hi there, We understand you need a Google Sheets + AppSheet system to manage customers, quotations based on square meter pricing, invoices, receipts, project feedback, and salesperson performance with clear admin controls. SEO Global Team has strong experience building structured Google Sheets databases and AppSheet business apps with automated numbering, role-based access, pricing calculations, and sales dashboards. Our approach is to design a clean Sheets data structure for customers, quotations, invoices, and receipts, build an AppSheet interface with automated calculations and discount controls, implement user-role permissions, and add dashboards to track salesperson performance and project status. How many product categories (aluminum, PVC, glass, etc.) will need pricing tables? Do you want the system to generate printable PDF quotations and invoices? Should the sales dashboard include monthly and yearly performance charts? Best regards, SEO Global Team
$140 USD in 7 days
5.2
5.2

Hi, I can build a structured Google Sheets and AppSheet system for quotations, invoices, receipts, customer management, and sales tracking based on square meter pricing. I understand you need role based access for up to 10 users, admin controlled discount limits, automatic numbering for quotes, invoices, and receipts, plus dashboards for salesperson performance. I can create a clean sheet architecture and AppSheet interface that works smoothly on mobile, tablet, and desktop for daily team use. I also focus on keeping the system scalable, organized, and easy to maintain as your sales process grows. Best Regards, Shabahat Habib.
$140 USD in 7 days
4.9
4.9

With my extensive experience in web and mobile development for over 9 years, I believe I'm well-equipped to tackle the challenge of building a powerful Google Sheets and AppSheet system to facilitate your quotation, invoice, and sales tracking needs. Over the years, I've developed various E-commerce and CMS-based systems including similar functionalities which mirror your proposed system. So, you can trust me to ensure that it's done effectively, accurately, and on time. Moreover, as an AppSheet expert, I can guarantee the creation of a clean, scalable structure for your system to ensure easy access via mobile devices, tablets, and desktops. My proficiency with Google Sheets will ensure all your data is stored neatly and organized for future use. My strong understanding of PHP and MySQL places me in a good stead to effectively integrate these platforms into the system. Lastly, my commitment to providing reliable IT services that turn ideas into reality aligns perfectly with the goals of this project. I assure you quality work with effective project costs as well as extended support after delivery. In addition, my team offers SEO services that can be quite handy in ensuring visibility for your new system. Trust me with this project; you'll have no regrets! Thank you for considering me for this exciting opportunity.
$140 USD in 7 days
5.6
5.6

Hello there , Good afternoon! I’ve carefully checked your requirements and really interested in this job. I’m full stack node.js developer working at large-scale apps as a lead developer with U.S. and European teams. I’m offering best quality and highest performance at lowest price. I can complete your project on time and your will experience great satisfaction with me. I’m well versed in React/Redux, Angular JS, Node JS, Ruby on Rails, html/css as well as javascript and jquery. I have rich experienced in PHP, Google Sheets, Mobile App Development, MySQL, Microsoft Access, Automation, Project Management, Database Development, Software Architecture and Data Management. For more information about me, please refer to my portfolios. I’m ready to discuss your project and start immediately. Looking forward to hearing you back and discussing all details.. Talk to you soon
$155 USD in 5 days
4.5
4.5

Are you looking to streamline your sales process with a seamless and user-friendly system? As an experienced Google Sheets and AppSheet developer with 5 years of expertise, I have worked on similar projects offsite. I understand the importance of creating a clean and scalable structure to efficiently manage customers, create quotations based on square meter pricing, and automate invoice and receipt generation. By implementing features such as customer database management, discount control, and sales performance tracking, I can ensure your system is professional and tailored to your specific needs. Let's chat about how I can help elevate your sales tracking system with a reliable and integrated solution. Chirag Pipal Regards
$200 USD in 7 days
4.7
4.7

Hello there, I hope you are well. I’m a solo developer who specializes in Google Sheets and AppSheet, turning complex sales processes into simple, reliable tools. I focus on clean data structures, scalable design, and a seamless user experience for daily use by a sales team. I’ve built end-to-end quotation, invoice, and sales-tracking systems in Sheets + AppSheet, including auto-generated quotation and invoice numbers, category-based pricing, discount controls, and multi-stage invoicing. I create dashboards to visualize sales by rep, quotations won, and revenue, plus secure access controls for up to 10 users. I can deliver a robust system aligned with your Windows/doors business needs: customer db, quotations with per-sqm pricing by category, admin-driven discount caps, adjustable invoice splits, receipts, project feedback, and a clear admin panel. The solution will run smoothly on mobile, tablet, and desktop, with data stored in Google Sheets and managed through AppSheet. Please feel free to reach out so we can discuss specifics and get started. Best regards, Billy Bryan
$250 USD in 3 days
4.7
4.7

pattaya, Thailand
Payment method verified
Member since Jan 21, 2021
$30-250 USD
$10-30 USD
$30-250 USD
$10-30 USD
$30-250 USD
$30-250 CAD
$750-1500 USD
₹12500-37500 INR
₹150000-250000 INR
$30-250 USD
$2000-4000 USD
$250-750 SGD
$250-750 USD
$250-750 USD
₹12500-37500 INR
$750-1500 USD
₹1500-12500 INR
₹12500-37500 INR
₹750-1250 INR / hour
£10-20 GBP
₹1250-2500 INR / hour
₹1500-12500 INR
₹600-1500 INR
$15-25 USD / hour
$30-250 USD