Application to Telephone Department for Telephone Connection Transfer
Dear readers ! in this post we have provide a application format for Transfer your Telephone Connection
Friday, June 26, 2020
Application for Telephone/ Landline Plan Change | टेलीफोन / लैंडलाइन योजना परिवर्तन के लिए आवेदन
Application for Telephone/ Landline Plan Change
Dear readers through this Post we have provide you a application format for Change your Telephone Tariff Plan. Very Simple format.
Saturday, June 6, 2020
Excel - Sale Purchase Profit Loss | How to Make Sale Purchase Profit Loss Sheet In 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
Subscribe to:
Posts (Atom)