inventory control

The company in which i work is a two wheeler manufacturer. for which i have to maintain at least 100 types of inventory. And i have to maintain it . i want to maintain the inventory in excel. But i am unable to find out any formula for this purpose. i have to maintain opening balance, received, issued and closing balance. can any one tell me how to do it in easy format.

Replies (1)

HI Ejaz


u can maintain in excel easily.What is ur purpose reporting r control of each SKU ?

if possible send me the sku's i will try to help out.

pls send to my mail id-   kaushiikar @ gmail.com

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
28 October 2026
Assistant Director/ Associate Director-Finance & Accounting

Krea University

Chennai

CA

View Details
Company
20 November 2026
Charted Accountant

Cothas Coffee Co.

Bengaluru

CA

View Details
Company
ARTICLESHIP 14 November 2026
Article Assistant

Jitendra Agarwal & Associates

Bengaluru

CA Inter

View Details
Company
21 November 2026
Asst. Manager / Deputy Manager

Aco Perfumes & Cosmetic Pvt Ltd

Mumbai

CA

View Details
Company
ARTICLESHIP 29 October 2026
Article Assistant (CA Inter / CMA Inter) - Thrissur

Varma Raja & Associates

Thrissur

CA Inter

View Details
Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details
Company
ARTICLESHIP 16 November 2026
Audit Executives

Loonker Godawat And Company

Bengaluru

B.Com

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details