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
ARTICLESHIP 16 September 2026
Article Assistant

MANUJ SHARMA AND COMPANY

Noida

CA Inter

View Details
Company
ARTICLESHIP 01 September 2026
Article Assistant

SGNG & Associates

New Delhi

CA Inter

View Details
Company
Featured 12 September 2026
Assistant Manager - Finance & Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details
Company
ARTICLESHIP 16 September 2026
CA Article Trainee

SR BAGAI & Co.

New Delhi

CA Inter

View Details
Company
17 September 2026
Chartered Accountant

Dass Gupta & Associates

Gurgaon

CA

View Details
Company
19 September 2026
CA/Semi-CA/BCom

Pravin Sarvaiya

Mumbai

CA Inter

View Details
Company
08 September 2026
Semi-Qualified Assitant

Subrahmanyam & Sivudu CA Firm

Hyderabad

CA Inter

View Details
Company
15 September 2026
Client-site CA associate

Aditya Muley and Co

Mumbai

CA

View Details