Stock Maintain In Excel

Stock Maintain In Excel

Dear Viewer in through this post we have sharing some videos for Maintain Stock In Excel. from these video you will get an idea for Create a stock maintenance format as you want. we will also share this template for your practice & learning. in end of this post. before using these template must watch complete video without skip any part. because in this video you will also learn How to create table, How to use hyperlink option in excel, how to use table formatting option, etc. 

Example 1

How to Maintain Stock In Excel In Hindi | Create Stock Maintain format in excel With Example

 

Example 2. 

How to maintain your stock in excel Step By Step | Stock Maintain In Excel 

@@@

 

Example 3. 

How to Maintain Stock in Excel | How to Create Stock Maintain format in excel

 

Template Download Link : #Stock_Maintain_Format

Must subscribe Our YouTube Channel and Our Gyanniti Blog  

How To Maintain Daily Expense In Excel

Maintain Daily & Monthly Expense/ Petty Cash

How to Maintain Daily And Monthly Expenses With Category & Daily Breakup | Petty Cash

Hello Viewers: In This Video Tutorial We will learn how to maintain Daily and Monthly Expenses in Excel with Multiple Categories and Complete Detail. Through this Video we will also Learn Very Useful Point of Excel Like a Formatting, Table Creating, Freeze Panes, Printing Setting, etc. so Viewer must watch this video because it's Every part is Very useful you.

How to Maintain Daily Expenses in Excel | Expenses Record Maintain in Excel

This is 2nd Template for Basic Learner In This Video Tutorial We will learn how to maintain Daily

Expenses

Dear Viewer, I hope both videos very helpful for you. kindly provide your valuable feedback and suggestions in the comments box. and Subscribe to our youtube channel.

Thanks

Pending Orders Maintain Template

How to Maintain Sales Order/ Pending Order List In Excel

Dear Viewer In This Video We Learn How to Maintain All Type Order In Excel. Like a Pending Order, sales Order, Processed order, Delivered Order etc. With Customer Details, Marketing. Person Details,  etc. With Some modification you can easily Maintain your All type order. We have share this Template with you. for your Practice or Easily create this template. before using this template must watch Complete video because this video is very helpful for making & using this template. 

Thanks

……

Pending Order List

#GyanNiti #PendingOrders, #orderlist, #salesorderlist

Excel - Sale Purchase Profit Loss | How to Make Sale Purchase Profit Loss Sheet In Excel

STEP 1: Open MS Excel

STEP 2: Press WIN + R Than Type excel and press enter 

STEP 3: When excel will open write a list of your product in collum with their serial number, net leave one collum and to another collum write purchase quantity and price with GST. and leave a collum for the total amount. in the next write sale quantity and price with GST. and leave a collum for the total amount.

(See image below)

STEP 4: To calculate the total amount of purchased items select cell of the total amount and write code =D5+E5 and than press enter. after that, you will get a total amount of items/products in the cell. do the same for sale collum. After all, you have to create the balance table for stock where your unsold item/products will list. to do this select cell of the purchase amount than - with the cell of sale amount than you will get balance stock (=D5-H5) create collum for the purchase amount and select the same cell of purchase with GST cell (by Applying =E5). to get the total amount of balance stock. multiply the purchase price with balance quantity (=M5*L5).

(See image below)

STEP 5: Now do the sum of purchase's total amount & sale's total amount. by using "SUM" formula (=SUM(F5:F9)) do the same in the Sale's & Balance's Table.

STEP 6:

Now: Purchase - Sale = Profit/Loss.

Now you will get the Sale Purchase Profit Loss Spreadsheet.

Thanks for Visiting

Download - Sale Purchase Profit Loss Spreadsheet