Hello, I have two massive google sheet tabs. 1. with all sales and 2. with all purchases. row items typically include code, product name, date purchased/sold, qty purchased/sold. I'd like to have a third tab, that runs a line by line, by code, date (purchased and sold), cost (see attached template of the third tab) to generate an inventory aging report so that i can see what we purchased is sold. if not sold, how many days it remained since the date the stock came in to store and categorize them in order of days stock remained in stores (as per purchase document). I'd also like some easy to see infographics based on the aging eg. bar/pie charts with costs, grouped by product group, category, classification. eg. spare parts belonging to a specific product range such as consumables, engine parts, tire-tube, filters etc along with an a/b/c analytics considered for this inforgraphics. Thank you.
36 freelances font une offre moyenne de 74 $ pour ce travail
Hi, As I understand you are looking for Inventory aging report in Google sheets. It would help to get into a quick discussion. Keen to work on this project. Recently completed Google Sheets/Google Maps based project Plus
I can perfectly help you with that. I am a professional Financial Analyst, Google Sheet and Excel expert holding years of experience in utilizing advance level tools and functions of Excel (including VBA and Macro) to Plus
Hi, I have carefully reviewed the detailed job description and the excel file uploaded, on this job post. Utilizing my hands-on rich job experience in Inventory Management & Supply Chain Management and my expertise in Plus
Hello? I have worked on Google App/Script projects to what you are looking for, and I am confident I can exceed your expectations. I have attached samples of work very similar to what you are seeking. # coin api Plus
Hello I am a data visualizer + information designer. Past 6 years, I have been into data visualization where, my keen area of interest is to find insights, create stories from data sets and build interactive visualiza Plus
Marhaba Ranjit, I'm a dashboard expert I understand your request and create a master-sheet that summarizes all your purchases,sales and stock activity. We can add a timetable and as many filters as you like Presentatio Plus
I have checked the Sheet Hello, Gratitude For The Job Posting If You Crave We Perform A Small Demo Work For You. We Are Very Positive For This Job Because We Have An Immeasurable Skills And Healthy Experience. We Ar Plus
Dear Client, Speed & Professionalism are my skills. I saw your description & i'm pretty sure that i can pull of it. I am ready to start now within 10% discount. Let's discuss in chat. Best Regards Monirul
Hi, Greetings! ✅checked your project details Inventory Aging Report on Google Sheets and Analytics/Infographics Attachments 2020 09 04 Inventory Aging Report [login to view URL] ✅Completed Time : 24 hours(independent and fast Plus
Hello Client, Greetings!! I am Excel Expert with an experience of working in excel for more than 15 years. I will be able to create Inventory Ageing Report in Google Sheets. Looking forward to work with you!! Thanks Plus
Happy to do this file for you! Hey there, my name is Daniela. I graduated from law school, and worked on several positions as an accountant, account manager, billing specialist. I speak English, as well as Italian (l Plus
Hi I am a professional data scientist and I am well versed with Google spreadsheet. I can provide you the inventory ageing ananlysis and dashboard on Excel. DM me for more details Regards, Sangamesh KS
Hello, I'm Accounting student. I understand what you need. I can finish the project in the time that you prescribed, can provide you with utmost quality.
Keen eye for detail, will ensure accurate and efficient work. Can explore code/programming to deliver work. Knows data visualization
Dear Project Owner I place my bid based on my expertise in python and data analytics and data visualization, excel and Google analytics. I have done these kind of works before. I have a master's degree in big data ana Plus
Excellent and professional experience in category management and inventory control with insightful and actionable analysis
Dear Mr, May i ask some question regarding your data? 1. do you have specific column that connects purchase & sales? for ex purchase Inventory: Invt Group: A1, Invt name: A , Invt batch A26092019, and in the sales Plus
i will do it because i have a lot of experiance on google sheet... I am happy to answer any queries that you may have. Looking forward to working with you. Thanks...
Hi Let me tell you my self, I have more than 2 year experience in google app script and I had integrated google sheet with the API integration and also I have knowledge of the google sheet in how data will be extract Plus
Hi, I understood your requirements. You want to know how many days a product is in inventory before it’s sold. I can help you achieving it. I built google sheet automations for more than 100 clients. And I am a Busi Plus