Spreadsheet: 715681d1611832778-fifo-valuation-stock-register
Sheet: Stock

 |  |  | OPENING BALANCE
[NAME] | O |  | OPENING BALANCE | 1000 | 100
[NAME] | O |  | OPENING BALANCE | 2000 | 110
[NAME] | O |  | OPENING BALANCE | 3000 | 120
 |  |  | PURCHASE
[NAME] | P |  | 01/01.04.20 | 500 | 105
[NAME] | P |  | 05/02.06.20 | 200 | 112
[NAME] | P |  | 07/07.08.20 | 750 | 113
[NAME] | P |  | 15/09.10.20 | 300 | 115
[NAME] | P |  | 250/19.11.20 | 100 | 117
 |  |  | SALES
[NAME] | S |  | U1/20/0012/03.04.20 | 500 | 125
[NAME] | S |  | U1/20/0037/08.04.20 | 600 | 125
[NAME] | S |  | U1/20/0162/22.04.20 | 300 | 125
[NAME] | C |  | CLOSING STOCK
 |  |  |  | 1600
 |  |  |  | 3000
 |  |  | OPENING BALANCE
[NAME] | O |  | OPENING BALANCE | 1000 | 100
[NAME] | O |  | OPENING BALANCE | 2000 | 110
[NAME] | O |  | OPENING BALANCE | 3000 | 120
 |  |  | PURCHASE
[NAME] | P |  | 01/01.04.20 | 500 | 105
[NAME] | P |  | 05/02.06.20 | 200 | 112
[NAME] | P |  | 07/07.08.20 | 750 | 113
[NAME] | P |  | 15/09.10.20 | 300 | 115
[NAME] | P |  | 250/19.11.20 | 100 | 117
 |  |  | SALES
[NAME] | S |  | U1/20/0012/03.04.20 | 500 | 125
[NAME] | S |  | U1/20/0037/08.04.20 | 600 | 125
[NAME] | S |  | U1/20/0162/22.04.20 | 300 | 125
[NAME] | C |  | CLOSING STOCK
 |  |  |  | 1600
 |  |  |  | 3000
 |  |  | OPENING BALANCE
[NAME] | O |  | OPENING BALANCE | 1000 | 100
[NAME] | O |  | OPENING BALANCE | 2000 | 110
[NAME] | O |  | OPENING BALANCE | 3000 | 120
 |  |  | PURCHASE
[NAME] | P |  | 01/01.04.20 | 500 | 105
[NAME] | P |  | 05/02.06.20 | 200 | 112
[NAME] | P |  | 07/07.08.20 | 750 | 113
[NAME] | P |  | 15/09.10.20 | 300 | 115
[NAME] | P |  | 250/19.11.20 | 100 | 117
 |  |  | SALES
[NAME] | S |  | U1/20/0012/03.04.20 | 500 | 125
[NAME] | S |  | U1/20/0037/08.04.20 | 600 | 125
[NAME] | S |  | U1/20/0162/22.04.20 | 300 | 125
[NAME] | C |  | CLOSING STOCK
 |  |  |  | 1600
 |  |  |  | 3000
 |  |  | OPENING BALANCE
[NAME] | O |  | OPENING BALANCE | 1000 | 100
[NAME] | O |  | OPENING BALANCE | 2000 | 110
[NAME] | O |  | OPENING BALANCE | 3000 | 120
 |  |  | PURCHASE
[NAME] | P |  | 01/01.04.20 | 500 | 105
[NAME] | P |  | 05/02.06.20 | 200 | 112
[NAME] | P |  | 07/07.08.20 | 750 | 113
[NAME] | P |  | 15/09.10.20 | 300 | 115
[NAME] | P |  | 250/19.11.20 | 100 | 117
 |  |  | SALES
[NAME] | S |  | U1/20/0012/03.04.20 | 500 | 125
[NAME] | S |  | U1/20/0037/08.04.20 | 600 | 125
[NAME] | S |  | U1/20/0162/22.04.20 | 300 | 125
[NAME] | C |  | CLOSING STOCK
 |  |  |  | 1600
 |  |  |  | 3000
 |  |  | OPENING BALANCE
[NAME] | O |  | OPENING BALANCE | 1000 | 100
[NAME] | O |  | OPENING BALANCE | 2000 | 110
[NAME] | O |  | OPENING BALANCE | 3000 | 120
 |  |  | PURCHASE
[NAME] | P |  | 01/01.04.20 | 500 | 105
[NAME] | P |  | 05/02.06.20 | 200 | 112
[NAME] | P |  | 07/07.08.20 | 750 | 113
[NAME] | P |  | 15/09.10.20 | 300 | 115
[NAME] | P |  | 250/19.11.20 | 100 | 117
 |  |  | SALES
[NAME] | S |  | U1/20/0012/03.04.20 | 500 | 125
[NAME] | S |  | U1/20/0037/08.04.20 | 600 | 125
[NAME] | S |  | U1/20/0162/22.04.20 | 300 | 125
[NAME] | C |  | CLOSING STOCK
 |  |  |  | 1600
 |  |  |  | 3000
 |  |  | OPENING BALANCE
[NAME] | O |  | OPENING BALANCE | 1000 | 100
[NAME] | O |  | OPENING BALANCE | 2000 | 110
[NAME] | O |  | OPENING BALANCE | 3000 | 120
 |  |  | PURCHASE
[NAME] | P |  | 01/01.04.20 | 500 | 105
[NAME] | P |  | 05/02.06.20 | 200 | 112
[NAME] | P |  | 07/07.08.20 | 750 | 113
[NAME] | P |  | 15/09.10.20 | 300 | 115
[NAME] | P |  | 250/19.11.20 | 100 | 117
 |  |  | SALES
[NAME] | S |  | U1/20/0012/03.04.20 | 500 | 125
[NAME] | S |  | U1/20/0037/08.04.20 | 600 | 125
[NAME] | S |  | U1/20/0162/22.04.20 | 300 | 125
[NAME] | C |  | CLOSING STOCK
 |  |  |  | 1600
 |  |  |  | 3000
 |  |  | OPENING BALANCE
[NAME] | O |  | OPENING BALANCE | 1000 | 100
[NAME] | O |  | OPENING BALANCE | 2000 | 110
[NAME] | O |  | OPENING BALANCE | 3000 | 120
 |  |  | PURCHASE
[NAME] | P |  | 01/01.04.20 | 500 | 105
[NAME] | P |  | 05/02.06.20 | 200 | 112
[NAME] | P |  | 07/07.08.20 | 750 | 113
[NAME] | P |  | 15/09.10.20 | 300 | 115
[NAME] | P |  | 250/19.11.20 | 100 | 117
 |  |  | SALES
[NAME] | S |  | U1/20/0012/03.04.20 | 500 | 125
[NAME] | S |  | U1/20/0037/08.04.20 | 600 | 125
[NAME] | S |  | U1/20/0162/22.04.20 | 300 | 125
[NAME] | C |  | CLOSING STOCK
 |  |  |  | 1600
 |  |  |  | 3000