Home For accounting professionals General accounting discussion
Current updates regarding coronavirus (Covid-19) and the precautions AAT are taking will be continually updated on the below page.

Please check this link for the latest updates:
We hope you are all safe and well and if you need us we will be here. 💚


Excel

jhilljhill Settling In NicelyRegistered Posts: 23
Hello everyone. in need of some help.

does anyone have a current stocklist template that i could use to keep track of stock. something like stock = X
+ Additions=x
- sales =X
BAL = X

Comments

  • PoodlePoodle Experienced Mentor Registered Posts: 711
    Hi jhil


    I do not have one set up but you could create a simple one with the following formula that will help to track numbers of items, not value

    Head up row 1 as follows

    1A Stock detail
    1B Stock code
    1C Opening stock
    1D Purchases
    1E Sales
    1F Closing stock

    I would suggest that you then reformat the cells from row 2 downwards to general numbers that match your units

    Then in
    2F enter the formula =C2+D2-E2
    and paste this formula down enough rows to cover number of stock items

    then start entering your stock

    2A enter your stock name (no formula)
    2B enter the stock code (no formula)
    2C enter the number of items held at opening stock
    2D enter number of items purchased
    2E enter the number of items sold
    2D will automatically calculate the result.

    and so on down the rows.

    jhill, I see from other threads that you are using Sage. If you have sage line 50 you could elect to use the stock control option there and that will enable you to keep stock values as well, thus saving duplication of work.

    Poodle
  • jhilljhill Settling In Nicely Registered Posts: 23
    cheers poodle. if i have any further trouble i will let you know
Sign In or Register to comment.