Suljettu

Inventory Aging Report on Google Sheets and Analytics/Infographics

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.

Taidot: Excel, Google Analytics, Google Sheets, Infografiikka, Data Analytics

Näytä lisää: prepare monthly report excel sheets, stock inventory project report, aging report, google data studio sales template, google analytics, google sheets report templates, google analytics spreadsheet add-on filters, google analytics spreadsheet add-on, free google data studio templates, google data studio, best google data studio templates 2020, excel aging report, accounting aging report data sample, creating aging report excel, aging report file oracle apps, excel formula aging report accounting, free aging report excel format, inventory sales report system using visual basic60, google ecommerce analytics via php, printing aging report oracle 12i excel

Tietoa työnantajasta:
( 1 arvostelu ) Dubai, United Arab Emirates

Projektin tunnus: #27520473

36 freelancers are bidding on average $74 for this job

finecodervw

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 Lisää

$100 USD 4 päivässä
(58 arvostelua)
5.8
daniyal3214

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 Lisää

$50 USD 1 päivässä
(83 arvostelua)
5.8
dfexcel

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 Lisää

$78 USD 3 päivässä
(15 arvostelua)
5.5
nemanjadj20

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 Lisää

$100 USD 1 päivässä
(13 arvostelua)
4.9
hemsphere

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 Lisää

$100 USD 7 päivässä
(9 arvostelua)
4.6
JohnRikz

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 Lisää

$75 USD 7 päivässä
(13 arvostelua)
3.7
Sanket2124

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 Lisää

$50 USD 1 päivässä
(21 arvostelua)
3.8
Monirulop

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 3 päivässä
(9 arvostelua)
3.5
kingqueen369

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 Lisää

$50 USD 1 päivässä
(5 arvostelua)
2.9
Exceltechguru

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 Lisää

$100 USD 7 päivässä
(2 arvostelua)
2.2
daninec96

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 Lisää

$100 USD 2 päivässä
(2 arvostelua)
1.9
ksanalytics

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 1 päivässä
(2 arvostelua)
1.9
aparnadirisala

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 7 päivässä
(1 arvostelu)
0.4
kimchlle

Keen eye for detail, will ensure accurate and efficient work. Can explore code/programming to deliver work. Knows data visualization

$67 USD 4 päivässä
(0 arvostelua)
0.0
bgdguy2010

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 Lisää

$78 USD 7 päivässä
(0 arvostelua)
0.0
ahmedbedeir1980

Excellent and professional experience in category management and inventory control with insightful and actionable analysis

$111 USD 3 päivässä
(0 arvostelua)
0.0
stevanpekandi

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 Lisää

$100 USD 3 päivässä
(0 arvostelua)
0.0
vw7288945vw

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...

$100 USD 5 päivässä
(0 arvostelua)
0.0
rajfaldu88

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 Lisää

$90 USD 7 päivässä
(0 arvostelua)
0.0
sureshkatla

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 Lisää

$100 USD 4 päivässä
(0 arvostelua)
0.0