Profit And Loss Account Management Fully Automatically in Microsoft Excel
If friends want to make profit and loss seat in Microsoft Excel, then you can make it in a very easy way.
Before taking profit and loss, you have to prepare a sheet of purchase and sale in which you will enter data. Your seat of purchase will be like this.
After making the purchase seat, you will also have to make the seat of the cell, which will look something like this.
After making the seat of purchase and sale, you will have to make a seat of profit loss in which all the records will come from you, in which all the formula will have to be applied.
Stock Formula:- =SUMIF($A$4:A11,K3,$B$4:B11)-SUMIF($F$4:F11,K3,$G$4:G11)
Profit/loss Rate Formula:- =IFERROR(AVERAGEIF($F$4:F11,K3,$I$4:I11)/AVERAGEIF($F$4:F11,K3,$G$4:G11)-AVERAGEIF($A$4:A11,K3,$D$4:D11)/AVERAGEIF($A$4:A11,K3,$B$4:B11),"")
Total Sale Formula :- =SUMIF($A$4:A11,K3,$B$4:B11)-L3
Total P/L Formula:- =IFERROR(M3*N3,"")
Friends, if you want to see the step by step full process video along with the formula, then you can see it by clicking on the video below.
If you want to download the excel file for training, click on the link below
0 Comments