
Kapalı
İlan edilme:
Teslimde ödenir
Project Description: I need a professional Excel expert to build a fully automated salary management workbook for my service manpower business. The system should record daily salary transfers, track employee totals, prevent duplicate entries, and automatically lock data after entry. Required Excel Features: Master Data Sheets A. Company Master Sheet Company name Bank account details IFSC Contact person details B. Employee Master Sheet Employee ID (must be unique) Employee name Company ID Bank details Salary amount Start date Notes Employee ID should have a restriction: no duplicates allowed. Salary Transfer Sheet Every salary transfer entry will be recorded daily. Columns: Date, Employee ID, Company ID, Amount, Bank Ref No., Month (YYYY-MM). As soon as the entry is made, the row should get locked automatically (VBA allowed). Automation Requirements Duplicate Employee ID check — show ERROR if someone enters the same EmployeeID again. Auto-lock row after data entry in Employee Master + Transfer Sheet. Data validation & clean UI. Pivot tables or formulas for monthly and yearly tracking. Reporting / Summary Sheet Automatic monthly salary total per employee Automatic yearly salary report Total transferred amount summary Optional dashboard requested if possible What I Need from the Freelancer A clean, professional Excel file With VBA (if required) for row-locking Easy to use and scalable Delivered in .xlsx and .xlsm formats Bonus (Not Mandatory) Simple dashboard with slicers Icons and formatting Delivery Within 2–3 days Should include a short guide explaining how to use the file.
Proje No: 40056012
23 teklifler
Uzaktan proje
Son aktiviteden bu yana geçen zaman 2 ay önce
Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
23 freelancer bu proje için ortalama ₹1.596 INR teklif veriyor

Hi, I have read the job description and now ready to start. I will provide 100% quality. Please send me a message for discussion. Let's discuss the job. Thanks
₹1.050 INR 1 gün içinde
5,4
5,4

Dear Client, Let’s get started right away!!! Feel free to chat with me anytime. I’m a ⭐5-star rated freelancer with strong expertise in Excel and data analytics, and I’ve completed 1000+ projects across multiple platforms with 7+ years of experience. I will build a professional, scalable salary-management workbook (delivered as .xlsx and .xlsm) that includes Company & Employee masters with duplicate-ID checks, a daily Salary Transfer sheet that auto-locks rows after entry (VBA), data validation and clean UI, monthly/yearly summaries (pivot or formulas), and an optional simple dashboard with slicers plus a short user guide — I’ll ensure duplicate prevention, auto-locking, and printable reports work reliably before delivery. Best regards
₹8.000 INR 1 gün içinde
5,5
5,5

Professional Excel VBA developer ready to do the required salary tracking and managment workbook. Samples of previous works and clients' reviews in links, copied below. https://www.freelancer.com/projects/excel/Fix-excel-VBA-36198376/reviews
₹5.000 INR 3 gün içinde
5,0
5,0

I have done a similar project a week ago. I am sure you will give me more projects after this. I am interested to do this project too and ready to complete this within the timeline. Pls check my profile to see all rating and reviews given by clients. Hoping to hear from you soon.
₹700 INR 7 gün içinde
5,0
5,0

Dear Sir, I have carefully reviewed your instructions and I am confident that I can complete this project efficiently. I would appreciate the opportunity to work on this project, and I assure you that I will deliver high-quality work with unlimited revisions. Moreover, I am committed to working on your project even after the work is completed. Please let me know if you have any questions or concerns. I look forward to your response. Thank you for your time. Best regards, SYEDA NIMRA
₹1.050 INR 1 gün içinde
4,0
4,0

As a dedicated, experienced MIS and VBA developer with over 3 years under my belt, I believe I am excellently positioned to handle your custom Excel sheet. My expertise in automating workflows and building scalable reporting systems - using not only Excel and VBA but also Power BI and Tableau - ensures that I possess the range of skills required for your project. Moreover, my proficiency isn't limited to just Excel; I also bring web development abilities (HTML, CSS, WordPress) and a strong digital marketing background to the table. This means that not only will you be getting a comprehensive solution for your immediate needs of MIS and VBA-based automation, but you could also have access to a long-term partner who can help you harness other data-related avenues for growth like SEO, Google Ads, email campaigns, and social media marketing. With me as your contractor, you're not just getting an expert to build your desired automated salary management workbook; you're also gaining someone who values communication, scalability, and meeting deadlines. I look forward to collaborating closely with you to create a clean professional Excel file which not only addresses your current needs but is also easy to use and can be scaled as your business grows.
₹1.500 INR 1 gün içinde
4,1
4,1

Hello! I can build a clean, professional, and fully automated salary management workbook for your service manpower business. Your requirements—duplicate prevention, daily salary transfer recording, automatic row locking, and clear monthly/yearly reporting—align perfectly with my Excel automation expertise and focus on reliability and usability. Looking forwards for your response.
₹1.250 INR 3 gün içinde
2,5
2,5

Hello there, I can help with the required JD. I have good knowledge in excel macros and excel formula. Let's connect to understand more and complete the project! Regards, Swetang Patel
₹1.050 INR 7 gün içinde
1,7
1,7

As an Data Analyst and experienced Excel professional, I'm confident I can create the fully automated salary management workbook you need for your service manpower business. Your project requires a complex understanding of Excel's features, and I have honed my skills in this area over my career span. In addition to proficiency with advanced functions, pivot tables and financial modeling in Excel, my expertise extends to include VBA macros. This will allow me not only to prevent duplicate entries but also to automatically lock data after entry which you have specified as a requirement. With a proven track record of delivering projects effectively on-time, I have no doubt that I meet the 2-3 days delivery period that you've requested. Plus, I ensure all of my deliverables contain guides explaining how to use the file making sure it's easy to integrate and work with. By incorporating my expertise in various technologies such as Excel, Python, SQL and Power BI, I will grant your project a comprehensive result that is scalable and meets usuário requirements efficiently without compromising clarity or user-friendly design.
₹1.050 INR 7 gün içinde
0,0
0,0

I will build a clean, professional salary-management Excel workbook (delivered as both .xlsx and .xlsm) that includes: Company and Employee master sheets (unique Employee ID validation), a daily Salary Transfer sheet with Date/EmployeeID/CompanyID/Amount/BankRef/Month, automatic duplicate-ID error checks, and VBA to auto-lock rows after data entry. I’ll add data validation, user-friendly forms/controls, pivot tables & formulas for monthly/yearly summaries, and a compact reporting sheet (with an optional slicer-driven dashboard if you want). You’ll also get a short user guide explaining how to use and maintain the file. I can deliver this within 2 business days.
₹2.500 INR 3 gün içinde
0,9
0,9

Hi after reading and understand the project thoroughly I have completely understood what you want to be done. I finished doing a similar project for someone else with all almost demands. My expertise matches you demands and I strongly feel I can complete the given task in the required time I will waiting for your response.
₹1.000,50 INR 2 gün içinde
0,0
0,0

I am reading your project details. And i am sure I handle this project because I am very hard worker and talanted. I am working on this project
₹1.250 INR 5 gün içinde
0,0
0,0

I can build your fully automated salary management Excel system exactly as required. The file will include unique Employee ID validation, clean data-entry UI, dropdown lists, and automatic row-locking using VBA. I will also set up monthly/yearly summaries, pivot-based reports, and clear formulas for accurate tracking. The workbook will be professional, easy to use, and delivered with a short user guide within the timeline.
₹600 INR 3 gün içinde
0,0
0,0

Hello, I’m Adefemi Adelugba, an Excel expert experienced in creating automated, user-friendly workbooks for payroll, data tracking, and reporting. I’m skilled in VBA, data validation, pivot tables, and dashboards, ensuring a clean, professional, and fully automated salary management system. What I Offer: Master Data Sheets: Company and Employee sheets with unique IDs and validation Salary Transfer Sheet: Daily entries with automatic row-locking and duplicate checks via VBA Automation & Reporting: Pivot tables and formulas for monthly/yearly totals, accurate data validation Optional Bonus: Dashboard with slicers, professional formatting, and icons Deliverables: Fully functional Excel workbook (.xlsx & .xlsm) with a short user guide, scalable and easy-to-use. Timeline: Can complete in 2–5 days with seamless automation, validation, and formatting. I’m confident this workbook will simplify salary management, prevent errors, and provide clear reports. Ready to start immediately. Best regards, Adefemi Adelugba
₹1.500 INR 5 gün içinde
0,0
0,0

I can create, edit, and organize complete Excel sheets including data entry, formatting, formulas, charts, and automation. I ensure accuracy, fast delivery, and a clean, professional layout based on your requirements.
₹600 INR 2 gün içinde
0,0
0,0

Hello Sir/Madam, I have carefully read your project details. I can transcribe your text-based material accurately and format it into a clean, well-structured Google Docs document. I specialize in typing, proofreading, formatting, and converting documents into organized and readable content. What I will deliver: ✔ Fully proof-read and error-free document ✔ Clean formatting, headings, spacing & structure ✔ Google Docs version + ready-to-use PDF ✔ Optional: Data arranged neatly in Google Sheets ✔ Fast delivery and unlimited revisions until you are satisfied I am detail-oriented and experienced in data entry, transcription, PDF/Word formatting, and document cleanup. I can start immediately and share a sample page if you want to check my accuracy. Looking forward to working with you. Regards, Shashi Bhushan Kannaujia
₹650 INR 5 gün içinde
0,0
0,0

Hi, I have read the job description and now ready to start. I will provide good quality. Please send me a message for discussion. Let's discuss the job. Thanks
₹1.050 INR 2 gün içinde
0,0
0,0

Hi there, I hope you are doing well. I have carefully reviewed your requirements for a Service Manpower Salary Management System. I understand that accuracy and data integrity are your top priorities, specifically the need to prevent duplicate entries and lock data immediately after input. I am an advanced Excel user with experience in VBA and financial modeling. I can build a robust, user friendly workbook that meets all your specifications within the 2-3 day timeline.
₹1.050 INR 3 gün içinde
0,0
0,0

Hi, I can build a fully automated, error-proof salary management workbook for your manpower business exactly as described. The file will include clean Master Data sheets, strict Employee ID validation, and a daily Salary Transfer sheet where each row locks automatically after entry (using VBA). I will also set up automated monthly and yearly salary summaries, pivot-ready data, and an optional dashboard with slicers for quick insights. The final workbook will be scalable, user-friendly, and delivered in both .xlsx and .xlsm formats along with a short user guide. I can complete this within 2–3 days and ensure professional accuracy throughout. Best regards, Ajit kumar
₹600 INR 1 gün içinde
0,0
0,0

Hello, I am proficient in Excel and ready to build a fully automated salary management workbook for your manpower business. With a Master’s degree in Engineering and strong experience managing complex datasets, I bring analytical precision, efficiency, and attention to detail to every project. What I Offer: - Master Data Sheets: Company and Employee master sheets with validation rules to prevent duplicate Employee IDs. - Salary Transfer Sheet: Daily salary transfer entries with auto-locking rows after data entry. - Automation: Duplicate ID error checks, clean UI, and data validation to ensure accuracy and prevent mistakes. - Reporting: Pivot tables and formulas for monthly and yearly salary tracking, plus automatic summaries of totals. - Optional Dashboard: Interactive slicers, icons, and neat formatting for clear insights and easy navigation. - Delivery: A professional, scalable Excel file in both .xlsx and .xlsm formats, with a short guide. The result will be a neat, accurate, and automated system that saves time, prevents errors, and provides clear insights for salary management. Best regards, Chung Nga N., Dora
₹1.450 INR 2 gün içinde
0,0
0,0

Manesar, India
Ödeme yöntemi onaylandı
Ara 4, 2025 tarihinden bu yana üye
₹600-1500 INR
₹1500-12500 INR
₹1500-12500 INR
₹1500-12500 INR
₹1500-12500 INR
₹750-1250 INR / saat
₹12500-37500 INR
₹1250-2500 INR / saat
₹600-1500 INR
$10-30 USD
$250-750 USD
₹600-1500 INR
₹100-400 INR / saat
₹100-400 INR / saat
₹6000-10000 INR / saat
$10-30 AUD
$250-750 USD
$8-15 AUD / saat
£10-20 GBP
₹5000-12000 INR
₹600-1500 INR
₹1500-12500 INR
£250-750 GBP
₹12500-37500 INR
$10-60 USD