• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

FIFO Calculation

sreepathi

New Member
Dear Members,

Kindly help me with the following scenario, Purchase, Sales are entered manually, Closing Stock as per Physical stock available,

Requirement:

For Sales: Qty will be entered manually, but price as per FIFO METHOD

For Closing Stock: Qty and Rate has to get calculated as per FIFO Method
Right now after physical stock verification Closing Stock is getting entered manually, i am unable to crack formula






ADD OR MINUSTYPEDATEPARTICULARSSL.NO. QTY RATE VALUE
ADDOpening Balance1
01/01/2021​
OPENING BALANCE-272 2,000.00 86.94 1,73,880.00
01/01/2021​
OPENING BALANCE-283 1,550.00 86.94 1,34,757.00
ADDPurchase4
09/01/2021​
INV NO.13934 DT.8-1-20215 5,000.00 88.02 4,40,100.00
20/01/2021​
INV NO.14491 DT.19-1-20216 5,000.00 88.02 4,40,100.00
25/01/2021​
INV NO.14862 DT.25-1-20217 5,000.00 88.02 4,40,100.00
30/01/2021​
INV NO.15214 DT.29-1-20218 3,000.00 88.02 2,64,060.00
30/01/2021​
INV NO.15236 DT.29-1-20219 2,000.00 88.02 1,76,040.00
07/01/2021​
INV NO.15239 DT.29-1-202110 500.00 86.94 43,470.00
MINUSSales11
20/01/2021​
3095/20.01.21-3512 1,500.00 88.02 1,32,030.00
MINUSClosing Stock13
31/01/2021​
CLOSING STOCK-3614 2,000.00 88.02 1,76,040.00
31/01/2021​
CLOSING STOCK-3715 3,000.00 88.02 2,64,060.00
31/01/2021​
CLOSING STOCK-3816 3,369.90 88.02 2,96,618.60
31/01/2021​
CLOSING STOCK-3917 - -
31/01/2021​
CLOSING STOCK-4018 - -
31/01/2021​
CLOSING STOCK-4119 - -
EQUALSConsumption20
31/01/2021​
CONSUMPTION-4221 14,180.10 87.71 12,43,758.40
 

Attachments

  • STock.xlsx
    10 KB · Views: 7
You have been asking questions about FIFO calculations on different occasions (here and elsewhere), but you do not give indications if the provided solutions/suggestions worked, or even acknowledged the help you received
 
Back
Top