Kapalı

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.

Beceriler: Excel, Google Analytics, Google Sheets, Bilgilendirme Grafikleri / İnfografikler, Data Analytics

Daha fazlasını gör: 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

İşveren Hakkında:
( 1 değerlendirme ) Dubai, United Arab Emirates

Proje NO: #27520473

Bu iş için 36 freelancer ortalamada $74 teklif veriyor

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 Daha Fazla

$100 USD in 4 gün içinde
(58 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(83 Değerlendirme)
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 Daha Fazla

$78 USD in 3 gün içinde
(15 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(13 Değerlendirme)
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 Daha Fazla

$100 USD in 7 gün içinde
(9 Değerlendirme)
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 Daha Fazla

$75 USD in 7 gün içinde
(13 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(21 Değerlendirme)
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 in 3 gün içinde
(9 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(5 Değerlendirme)
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 Daha Fazla

$100 USD in 7 gün içinde
(2 Değerlendirme)
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 Daha Fazla

$100 USD in 2 gün içinde
(2 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
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 in 7 gün içinde
(1 Yorum)
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 in 4 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$78 USD in 7 gün içinde
(0 Değerlendirme)
0.0
ahmedbedeir1980

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

$111 USD in 3 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$100 USD in 3 gün içinde
(0 Değerlendirme)
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 in 5 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$90 USD in 7 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$100 USD in 4 gün içinde
(0 Değerlendirme)
0.0