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
08 October 2026
Accounts and Tax Associate

POOJA R TELI & CO

Pune

CA Inter

View Details
Company
ARTICLESHIP 30 September 2026
CA Article Assistant

CA Suraj Garg & Associates

New Delhi

CA Final

View Details
Company
ARTICLESHIP 08 October 2026
ARTICLE TRAINEE

S.B.G. & CO. CHARTERED ACCOUNTANTS

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 23 October 2026
CA Articleship / Article Assistant

M N Rao & Associates LLP

Vijayawada

CA Inter

View Details
Company
21 October 2026
CA INTER/ BCOM WITH EXPERIENCE

CA S KUMAR GUPTA & CO

Amritsar

CA Inter

View Details
Company
ARTICLESHIP 25 October 2026
Article Intern (CA Articleship)

Arpan Bohra & Co

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 07 October 2026
Article assistant

S.K.Bajpai & Co.

Noida

B.Com

View Details
Company
Featured 03 October 2026
Accountant

A P Lodha and Associates

Jalna

B.Com

View Details