Find Jobs
Hire Freelancers

Inventory Aging Report on Google Sheets and Analytics/Infographics

$50-100 USD

Closed
Posted over 3 years ago

$50-100 USD

Paid on delivery
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.
Project ID: 27520473

About the project

33 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
33 freelancers are bidding on average $74 USD for this job
User Avatar
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 perform Data Analysis, Data Visualization, Financial Analysis, Financial Modeling and various types of Analysis, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project.
$50 USD in 1 day
4.8 (115 reviews)
6.7
6.7
User Avatar
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 all relevant techniques of Google sheets, I will deliver a professional job including the Inventory aging report along with the listed variety of charts with costs, grouped by product group, category and classification exactly as per your requirements. Please take a look at the few samples out of my work collection available on the "Inventory Management" and "Dashboards & KPI Reports" portfolio in my profile using the link below: https://www.freelancer.com/u/dfexcel. Please revert to fix up a call preferably a screen sharing session, to discuss the finer details in order to finalize at the earliest. Look forward to work with you soon. Thank you for your time and patience. Regards, Devashish
$78 USD in 3 days
5.0 (22 reviews)
6.3
6.3
User Avatar
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 projects with good feedback. https://www.freelancer.com/projects/google-maps-api/Goolge-Maps-personal-Pins/details https://www.freelancer.com/projects/google-sheets/need-help-with-google-sheets/details https://www.freelancer.com/projects/javascript/Advanced-Google-sheet-app-script/details https://www.freelancer.com/projects/excel/Google-Sheet-Formula-24741350/details Let me introduce myself as an expert in Google spreadsheets and Google docs. I am well versed with scripting in Google spreadsheets using Apps script, writing custom functions in Google spreadsheets, creating charts, custom functions, linking spreadsheets etc. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks
$100 USD in 4 days
5.0 (75 reviews)
6.2
6.2
User Avatar
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 Presentation will be professional and usage friendly Will include a few charts and pie of course let us discuss your request further John
$75 USD in 7 days
5.0 (75 reviews)
5.4
5.4
User Avatar
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 Are Waiting For Your Response. Thanks!
$50 USD in 1 day
4.9 (25 reviews)
4.3
4.3
User Avatar
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
$50 USD in 3 days
4.9 (19 reviews)
3.9
3.9
User Avatar
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 (language in which I've done my studies) and Romanian. Canva/Photoshop skills, as well as managing pages on different social media (Facebook, Instagram, etc). I have experience as an translator, and customer service, as well as marketing and writing contents. Here for any question you might have.
$100 USD in 2 days
5.0 (4 reviews)
4.0
4.0
User Avatar
Hi! eCommerce Website enhancement I'm interested in the project. Alkapton so we; We are an advertising and marketing agency serving small and medium-sized businesses to adapt to digital transformation and improve their communication channels. We have an operating and entrepreneurial spirit. We create value with our educated and experienced team in communication, marketing, design and software. Alkapton; It works like a design school. We constantly research, learn and develop our customers to do our job in the best way possible. We admire knowledge and the sharing of knowledge. By assimilating the work of our customers, we offer them smart solutions, not excuses. In the most creative region of Istanbul; We work in Galata. We will be pleased to meet you for your needs.
$50 USD in 7 days
5.0 (2 reviews)
2.6
2.6
User Avatar
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 & Regards Parmeshwar Bhandari
$100 USD in 7 days
5.0 (2 reviews)
2.3
2.3
User Avatar
This is a quick service that is done within 24 hours and I can finish in a few minutes if possible. I will do the best for you and also provide extra services with unlimited revisions even after you accept your order I can also give it.
$50 USD in 3 days
5.0 (1 review)
1.9
1.9
User Avatar
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
$50 USD in 1 day
5.0 (4 reviews)
2.0
2.0
User Avatar
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 analytics from university of Barcelona. I know there will be many bids even with lower bid price than me. I can assure you quality work. Please consider my bid
$78 USD in 7 days
5.0 (2 reviews)
0.7
0.7
User Avatar
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.
$90 USD in 7 days
5.0 (1 review)
0.4
0.4
User Avatar
I have past experience in inventory management sheets preparation for spare parts in warehouses also - I can do ABC , FSN , inventory quality and sales quality analysis with ageing also.
$50 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello sir, I understand your expectation and I am ferfect in data entry as well as account so I can complete this in the given period of time with 100% accuracy
$75 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear sir, I have read and understood the project requirements fully. I am experienced data entry specialist in updating products in ecommerce websites ,images,videos and all. I can provide good long term service with best quality. Let us discuss via chat to start.
$75 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi , Dear sir i am right now available to do this job , i am also having very much experience to tackle inventory like this condition , please reply i will give you the demo first. regards, taj
$75 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I work with data analysis for update navigable maps and I think that this case is easy and i can provide a great report about your items
$70 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i can do your work perfectly. Hi i am an certified excel vba Expert. For Professional works -Hire me.
$83 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I read through the job details extremely carefully and I am absolutely sure that I can do the project and I can completes your project on time and within your budget. thanks!
$52 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED ARAB EMIRATES
Dubai, United Arab Emirates
5.0
1
Payment method verified
Member since Mar 19, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.