
Kapalı
İlan edilme:
Teslimde ödenir
I’m getting ready for a full warehouse count and want to slim my Sage 50 item list from roughly 20,000 SKUs down to about 5,000 genuinely active ones. The file is regularly updated, but years of slow-moving and non-selling products are still sitting there, skewing reports and slowing searches. The plan is straightforward: • Use Sage 50’s sales-history data to pinpoint every item with no meaningful movement in our agreed-upon time window and deactivate, delete or zero those SKUs. • Prepare a clean, compact item list for a physical count, then import the verified quantities back into Sage 50 so valuation, COGS and on-hand reports match what’s actually on the shelves. I’ll supply a fresh company backup plus any exported reports you need. You’ll bring strong Sage 50 inventory know-how, Excel or Crystal Reports skills for bulk analysis, and a clear, documented workflow I can repeat next year. Deliverables • A repeatable method (macro, custom report or step-by-step guide) that flags obsolete SKUs using sales data. • Cleaned Sage 50 file or import sheets showing only ~5,000 active items. • CSV template and instructions for the physical count import. • Reconciliation report proving Sage 50 quantities align with the final count within ±1 %. If you’ve handled large-scale Sage 50 cleanups or sales-driven obsolescence projects before, I’d love to hear how you approached them and the timeline you foresee for wrapping this up.
Proje No: 40075879
58 teklifler
Uzaktan proje
Son aktiviteden bu yana geçen zaman 1 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
58 freelancer bu proje için ortalama $418 USD teklif veriyor

With over seven years of experience as a Full stack developer emphasizing on areas like Web scraping, automation and solving complex data problems, I am confident that I can help you with your Sage 50 Inventory Worksheet Cleanup & Count project. My career exposure includes working with top companies such as DXC technologies and Elite Services. Such interactions have sharpened my skills in data manipulation, analysis using advanced tools including Excel, VBA macros and VB6 which I believe will excel with your need for bulk analysis and a repeatable method to identify and handle obsolete SKUs efficiently. Over time, I've developed strong data cleansing skills which would be critical for your project. My grasp of Sage 50 operations coupled with data-focused programming languages like Python will aid in providing you with accurate lists of ~5,000 active items ensuring that skewing reports from slow-moving and non-selling products will be a thing of the past. Having worked on large-scale projects before, I understand the importance of detailed reconciliation and guarantee to provide it -- quantities aligned with the final count within ±1 %.
$500 USD 7 gün içinde
8,6
8,6

Having worked as a data analyst for several years, I have gained significant experience in sorting and cleaning large datasets, making me a perfect fit for your Sage 50 inventory cleanup project. I understand the importance of maintaining accurate and up-to-date databases, and I'm well-versed in extensive software like Excel or Crystal Reports that can facilitate the process. My key strength lies in my ability to use complex data to drive actionable insights, and this is especially relevant in your case where a clean, compact item list can greatly help improving report accuracy. In previous projects similar to yours, I have typically approached them by first conducting an in-depth analysis of the existing data to identify meaningful patterns or identifying zero-moving items. By leveraging Sage 50's sales history data as you've mentioned and combining it with my skill-set including data mining and web scraping, we can ensure obsolete SKUs are flagged effectively. Additionally, my proficiency in MS Excel will also facilitate bulk handling of data with ease. Furthermore, delivering value through specific tools is not just my goal but rather providing you with a documented workflow that can be repeated next year for similar projects. If you choose me for the job, be assured of precise and satisfactory results delivered within your specified timeline. Excited to put my skills to work for you!
$250 USD 1 gün içinde
7,6
7,6

Hi, I can help you clean up your Sage 50 inventory properly and safely, so your warehouse count is faster, more accurate, and repeatable next year. How I’ll approach it: Use Sage 50 sales history to identify SKUs with no meaningful movement in your agreed time window Analyze data via Sage reports + Excel / Crystal Reports for bulk accuracy Classify items to deactivate, zero, or remove (per best practice, not risky deletions) Prepare a clean active-item list (~5,000 SKUs) for physical counting Create a CSV import template and guide for entering counted quantities Import final counts back into Sage 50 Reconcile inventory, valuation, COGS, and on-hand quantities to within ±1% What you’ll receive: A repeatable method (custom report, Excel workflow, or step-by-step process) to flag obsolete SKUs using sales data Cleaned Sage 50 file or import sheets with only active items Physical count CSV template + instructions Clear reconciliation report proving Sage matches the final count I’ve handled large Sage 50 inventory cleanups where years of inactive SKUs distorted reporting, and I focus on accuracy, documentation, and future reuse, not one-off fixes. Happy to review your backup and confirm timeline once we define the sales-history window.
$500 USD 7 gün içinde
6,8
6,8

Hi, I can help you streamline your Sage 50 inventory by identifying and removing inactive SKUs using sales-history data, leaving you with a clean, count-ready list of truly active items. I have hands-on experience with Sage 50 inventory cleanups and bulk analysis using Excel and custom reports, and I’ll deliver a repeatable, well-documented process you can reuse in future years. I’ll also prepare the import templates, support the physical count upload, and reconcile quantities so valuation and COGS align accurately. I can work from your backup file and move quickly while keeping everything controlled and auditable. Thanks & Regards Mussadiq Hussain
$250 USD 7 gün içinde
6,6
6,6

Hello, Having worked as a virtual assistant for over 8 years, I have gained extensive experience in data analysis and processing, making me an excellent fit for your Sage 50 cleanup project. I understand the criticality of accurate inventory tracking and the impact it can have on the overall business functionality. Therefore, streamlining your inventory list by eliminating redundant SKUs is a task I am well-equipped to handle. My adeptness with Excel and other digital tools will enable me to efficiently dig into your Sage 50 sales-history data and identify the non-moving items, aligning with your need to narrow down the list to approximately 5,000 active SKUs. Having performed extensive data analysis in the past, including cleaning up large-scale inventories, I assure you that I have both the skills and expertise required to deliver accurate results within a satisfactory timeframe. In addition to data analysis, my proficiency extends to other areas vital for this project such as data entry and processing. This means not only can I reduce your inventory effectively but also import verified quantities back into Sage 50 meticulously maintaining reports that match your physical count. Furthermore, I understand the importance of creating a repeatable method for future use; thus, I will provide a concise yet comprehensive guide enabling smooth operations in years to come. Choose me, Ayodele, for an effective, efficient and reliable Sage 50 inventory cleanup & count. Thanks!
$300 USD 3 gün içinde
6,2
6,2

Hello, Greetings of the day! I have a vast experience of working in Advanced Excel and I have completed many projects based on Advanced Excel. I have read your requirements and I can complete your project within time frame with proper and efficient work. I am a full time Freelancer and available to start your project immediately. I have an experience of below skills • Changing Raw Data into Presentable Data which can be easily under stood. • Use of Advanced Excel Formula • Data, Power Query, Tables & Formatting • Conditional Formatting • Advanced Charting • Pivot Tables & Pivot Reporting • VBA & Macros • Data Analysis • Anova analysis in Excel • Statistic & Modeling using Excel • Forecasting & Trend Analysis & many more …. I am ready to work on a Sample file also if required. Please initiate the chat so that we can discuss more about project and start the project. Thanks & Regards Sneh
$500 USD 3 gün içinde
6,2
6,2

Hi! Here is your Professional Accountant having 12 years of experience in the accounting field. I handle clients for all accounting needs, including Property Business Clients I offer Bookkeeping using QuickBooks, XERO, and Excel. Let’s connect Regards Muhammad Arslanullah
$750 USD 7 gün içinde
5,4
5,4

Dear Hugo41, My name is Faisal, and I bring over 7 years of experience in data management and inventory optimization, particularly with Sage 50. I understand the intricacies involved in refining your item list from 20,000 to 5,000 active SKUs. I will meticulously analyze the sales-history data to identify items that have shown no meaningful movement during our agreed-upon time window. My approach will ensure that each step is executed with precision, enabling me to deactivate or remove obsolete items efficiently. This will be done while maintaining a structured documentation process to facilitate easy replication for future audits. I place a strong emphasis on maintaining clear communication throughout the project. I will provide regular updates and seek your input where necessary, ensuring that all aspects align with your expectations. Following the cleanup, I will create a clean item list, a comprehensive reconciliation report, and a user-friendly CSV template for the physical count import. I am committed to delivering all project components by the agreed deadline, backed by strong attention to detail and a tailored process that can serve your future needs. I look forward to the opportunity to assist you in this critical project. Best regards, Faisal
$500 USD 7 gün içinde
4,9
4,9

Hello there, thank you for considering my proposal. I am excited about the opportunity to assist you with streamlining your Sage 50 item list for the upcoming full warehouse count by identifying and removing inactive SKUs. Leveraging Sage 50's sales-history data, I aim to deactivate, delete, or zero out non-performing products to optimize your inventory management. With my expertise in Sage 50 inventory management, Excel, and Crystal Reports, I will deliver a clear and documented workflow for future use, along with a cleaned item list for the physical count. I look forward to collaborating on this project to enhance your operational efficiency. Regards, CA. Swati Jain, CPA | Indian CA & CS
$336 USD 1 gün içinde
4,4
4,4

Hi, I am a CPA with over 5 years of experience in bookkeeping, inventory accounting, and ERP clean-ups, with hands-on expertise in Sage 50 and advanced Excel reporting. I can streamline your Sage 50 item master by using sales-history data to identify slow-moving and obsolete SKUs, reducing the list from ~20,000 items to the ~5,000 that are genuinely active and relevant for operations and reporting. I will analyze sales movement within an agreed time window, flag items with no meaningful activity, and prepare clear deactivate/delete or zero-quantity actions. Alongside this, I’ll deliver a clean item list for your physical count and a structured CSV import so verified quantities flow back into Sage 50 accurately, ensuring inventory valuation, COGS, and on-hand reports align with reality. Deliverables will include a repeatable workflow (custom report, Excel method, or step-by-step guide), cleaned import sheets, physical count templates, and a reconciliation report confirming Sage 50 balances match the final count within ±1%. I’m comfortable working from a company backup and can complete the full cleanup efficiently with clear documentation for future yearly counts. Regards, Humayun Khan
$250 USD 7 gün içinde
4,6
4,6

As an experienced and dedicated Sage 50 expert, I can offer you the perfect solution for your inventory cleanup and count needs. With a strong background in Accounting, Data Entry, Data Processing, and Excel, I am highly skilled at sifting through large datasets and zeroing in on relevant information. Utilizing Sage 50's sales-history data, I can thoroughly analyze the SKUs, identifying those that have had no meaningful movement within the agreed-upon timeframe to be deactivated or deleted. My ability to provide a clear and documented workflow also ensures that the process is repeatable next year or whenever you need it again. Moreover, my designs are not just tailored for aesthetics but also focused on functionality and efficiency. This translates into a clean and compacted item list for your physical count - which will be accurately imported back into Sage 50 using an easy-to-follow CSV template and instructions provided by me. Not only will I complete this project within the desired timeline, but I also guarantee accurate reconciliation between your actual stock and Sage 50 quantities. My commitment to regular updates throughout the project ensures that we are always on the same page. Choose me for quality work, adaptability to new technologies, and a commitment to delivering tailored solutions that dazzle and inspire. Let's get started on streamlining your warehouse data!
$500 USD 7 gün içinde
4,6
4,6

Dear Hiring Manager, I am excited about the opportunity to assist with your Sage 50 Inventory Cleanup & Count project. With my expertise in Sage 50 inventory management and data analysis, I am well-equipped to streamline your item list and ensure accurate reporting. Utilizing Sage 50's sales-history data, I will efficiently identify and deactivate unnecessary SKUs, providing you with a clean and concise item list for the upcoming warehouse count. My experience in Excel and Crystal Reports will enable me to analyze data in bulk and create a seamless workflow for future use. I have successfully completed similar projects in the past, and I am confident in my ability to deliver the desired results efficiently. I look forward to discussing my approach and timeline for completing this project with you further. Thank you for considering my proposal. Best regards,
$250 USD 7 gün içinde
3,9
3,9

I am thrilled to offer my skills in data management, specifically in Excel and Sage 50. With over three years of experience handling large-scale inventory cleanups and obsolescence projects, I possess the intricate knowledge of Sage 50 that you're looking for. By leveraging my strong analytical skills I can comb through your warehouse's sales history data and analyze it on Excel or Crystal Reports to identify low-performing products, allowing us to guage a comprehensive strategy for deactivating, removing, or zeroing those SKUs. Additionally, thanks to my proficient capabilities in Microsoft Suite - including Excel - I will be able to prepare a clean and concise item list for your impending physical count. I also have the expertise to successfully import the verified quantities back into Sage 50, ensuring perfect alignment with regard to valuation, COGS and on-hand reports. This means you'll end up with a slimmed-down list of just about 5,000 genuinely active SKUs that resonate with your business needs.
$250 USD 1 gün içinde
3,7
3,7

As we dive into your Sage 50 Inventory Cleanup & Count project, I'll bring to the table a wealth of experience in bookkeeping and a strong command over accounting software like Sage. With 5+ years of expertise, I've developed an efficient workflow which will be perfect for your data cleanup and organization needs. I've handled large-scale data cleaning projects before with businesses that had similar challenges, a sizable inventory list overloaded with slow-moving products, resulting in skewing reports and sluggish searches. Proficiency in Excel and Crystal Reports is vital for this assignment, and as someone who lives in spreadsheets, manipulating data comes naturally to me. Your plan resembles the method I used in a recent project where I successfully cleaned up 15,000 SKUs down to just 5,000 active ones. This resulted in accurate valuation, COGS, reconciled quantities and efficient searching capability. Our timeline for this Sage project can be adjusted to your preferences but based on past projects of similar scale; we have managed to complete them within two to three weeks. In conclusion, I offer you not only my technical skills but also a partnership mindset that'll tailor my services to your unique business requirements. Let's work collaboratively to streamline your inventory management using Sage 50, simplifying your financial journey together.
$400 USD 7 gün içinde
3,6
3,6

As an experienced bookkeeper with a strong command over popular accounting software including Sage 50, I believe I'm the perfect fit for your inventory cleanup project. Over the years, I have effectively assisted my clients in purging their product lists from redundant SKUs and reconciling data accurately and efficiently post-physical counts. My skills in Excel and Crystal Reports are immensely valuable for the kind of bulk analysis and sales-driven obsolescence strategy you are seeking. Your project’s goals align extremely well with what I do best. Utilizing Sage 50's sales history data is a smart move, and I can even build you a macro or custom report to flag stagnant SKUs to speed up future cleanups. Efficiency and attention to detail are my trademarks, evident in my ability to work swiftly without sacrificing precision - saving you valuable time while ensuring an accurate outcome. By choosing me for your project, you're benefiting from my extensive experience, streamlining your inventory list down to only 5,000 active items, and receiving a detailed step-by-step guide that makes the entire process reproducible next year. Besides, I promise you complete confidentiality and dedication to surpass your expectations at all times. Let's embark on this financial journey together!
$450 USD 7 gün içinde
3,5
3,5

Hello, I’m eager to collaborate with you and look forward to hearing from you. Let’s connect at your convenience so we can get started right away. Warm Regards, Zahrah
$250 USD 1 gün içinde
3,6
3,6

As someone who thrives on helping companies optimize their operations, I can confidently say that I'm highly qualified for your Sage 50 Inventory Cleanup & Count project. With my strong data analysis expertise and Excel proficiency, I've been able to streamline complex inventory management systems for large warehouses in the past. I'm accustomed to handling datasets of varying magnitudes and with diligent effort, I can help you slim down your current 20,000 SKUs to a lean, more manageable 5,000 active items. In short, my solid track record in undertaking large-scale cleanups and my adept ability to stitch together complex data processes make me an excellent fit for your project. My goal is always innovation through efficiency - let's channel that into your inventory management system so you can have reliable valuations, accurate COGS calculations, and on-hand reports reflecting reality. Let's work together to not only achieve clean data but also provide sustainable solutions that set you up for future success.
$500 USD 7 gün içinde
3,2
3,2

Hi there, I’m excited about the opportunity to help you streamline your Sage 50 inventory ahead of your full warehouse count. With extensive experience in managing Sage 50 cleanups and optimizing inventory systems, I am confident that I can effectively reduce your SKU list from 20,000 to 5,000 active items, enhancing the accuracy of your reporting and search functionalities. I’ll utilize Sage 50’s sales-history data to identify slow-moving SKUs and systematically deactivate or delete them while meticulously documenting the process to create a clear, repeatable workflow you can rely on for future cleanups. With my solid background in Excel and data analysis, combined with your company backup and exported reports, we can ensure the final item list is both accurate and useful. Let’s discuss how we can start this project promptly to meet your timeline. Can you also provide more details about your specific time frame for this project? What specific time frame are you looking at for the completion of this project?
$610 USD 12 gün içinde
3,1
3,1

With over 9 years of experience in a variety of fields, I am confident that I possess the skills necessary to tackle your Sage 50 inventory cleanup and count project. Not only do I have an extensive background in data entry and Excel, but my effective use of specialized programs like SAGE 50 has enabled clients in the past to identify non-selling products and create efficient workflows for future projects – exactly what you're looking for. My expertise extends beyond simply cleaning up and counting your SKUs; I will offer a solution that is repeatable and helpful for years to come, using a macro, custom report, or step-by-step guide, whichever is best suited to your needs. Moreover, my familiarity with large-scale cleanups combined with my insightful analysis and reporting capabilities will ensure that every SKU without meaningful movement during the chosen timeframe is deactivated, deleted or zeroed out accurately. You can depend on me to provide you with not just a cleaned Sage 50 file containing the active ~5,000 items but also with a CSV template and instructions precisely tailored for your physical counts import. My commitment to precision is reflected in my promise of delivering reconciliation reports validating alignment of Sage 50 quantities within ±1 % of the final count - eliminating any skewing of reports that have been plaguing your inventory management.
$250 USD 1 gün içinde
3,0
3,0

This is a well-defined project and very achievable in Sage 50. I’ve handled large Sage 50 item list cleanups and inventory rationalisation projects using sales-history analysis and bulk Excel/Crystal Reports workflows. My approach is to pull multi-year sales and usage data, define a clear “no meaningful movement” rule (e.g., zero sales and zero adjustments over X months), and then flag SKUs for inactivation rather than deletion to preserve history and audit integrity. From there, I prepare a trimmed, count-ready item list, build import templates for physical counts, and run post-import reconciliation checks so on-hand, valuation, and COGS align within tolerance. I’m comfortable working directly from a company backup and exported reports, and I document every step so the process can be repeated annually without rework. Timeline-wise, assuming timely access to the backup and data, this would typically take: • 1–2 days for analysis and SKU classification • 1 day to prepare clean item lists and count templates • 1 day for import support and reconciliation Happy to walk you through a sample workflow or discuss how you define “inactive” SKUs before starting.
$750 USD 15 gün içinde
2,8
2,8

San Juan, Puerto Rico
Ödeme yöntemi onaylandı
Haz 29, 2022 tarihinden bu yana üye
$3000-5000 USD
$15-25 USD / saat
$250-750 CAD
$10-30 USD
£10-15 GBP / saat
₹1500-12500 INR
$250-750 USD
₹1500-12500 INR
$15-25 USD / saat
$2-8 AUD / saat
$250-750 USD
$100-300 USD
₹750-1250 INR / saat
₹12500-37500 INR
$30-250 USD
₹1500-12500 INR
₹37500-75000 INR
$30-250 USD
$25-50 USD / saat
£5-10 GBP / saat
₹12500-37500 INR
$10-30 CAD