Journals stock in SAGE

Londina
Londina Registered Posts: 814 Epic contributor 🐘
Hiya

a basic question, hope someone can help me.

I need to account stock purchased of £600 and sold of £1000 for the current year end 31/03, can somebody please let me know which journal I have to do in SAGE?

Comments

  • groundy
    groundy Registered Posts: 495 Dedicated contributor 🦉
    If the sale and purchase have gone through bank account then would they nor be payment and receipt postings rather than journals?
  • Londina
    Londina Registered Posts: 814 Epic contributor 🐘
    thanks but nothing to do with the bank account, I need to record the stock therefore this has to be done by journals!

    otherwise in the opening/closing stock account which figures you will find?:huh:
  • martin1971
    martin1971 Registered Posts: 6 New contributor 🐸
    More information is required, is the stock purchased on credit? for cash? sold on credit? for cash?

    Generally entries for stock purchase/sale are as follow:

    Stock Purchase:
    Dr: Stock
    Cr: A/P

    Stock Sale:
    Entry 1
    Dr: COS
    Cr: Stock
    Entry2
    Dr: A/R
    Cr: Sales

    Hope that helps.
  • Monsoon
    Monsoon Registered Posts: 4,071 Beyond epic contributor 🧙‍♂️
    Londina wrote: »
    Hiya

    a basic question, hope someone can help me.

    I need to account stock purchased of £600 and sold of £1000 for the current year end 31/03, can somebody please let me know which journal I have to do in SAGE?

    I'm confused by the question.
    Purchases of £600 are Dr Purchases; Cr Bank OR Creditors (depending on whether they were paid for or on credit).

    Did you sell the £600 for £1000? Or did you sell £1000 which included £400 of opening stock?

    What is the balance of stock at the beginning of the year?
    What is the balance of stock at the end of the year?
  • martin1971
    martin1971 Registered Posts: 6 New contributor 🐸
    I believe she meant purchase of stock for £600 and the sale of the same stock for £1000 creating £400 gross profit.
  • Monsoon
    Monsoon Registered Posts: 4,071 Beyond epic contributor 🧙‍♂️
    martin1971 wrote: »
    I believe she meant purchase of stock for £600 and the sale of the same stock for £1000 creating £400 gross profit.

    Thanks :)

    In which case, there are no journals.
    The purchases and the sales should have been completed in the normal postings.
    Dr Purchases (not stock) for goods bought, Cr Bank or creditors
    Cr Sales for values sold, Dr Bank or Debtors.

    Stock journals relate to opening and closing stock, not purchases and sales of items in the year.
  • Londina
    Londina Registered Posts: 814 Epic contributor 🐘
    oh guys thanks so much for the replies, I realised I did explain myself really badly!

    Try to put it in a simpler way,what I meant was:

    Purchase invoices
    1)quantity 50 £230
    2)quantity 40 £100
    3)quantity 30 £270

    Total purchase £600

    Sales invoices
    1)quantity 50 £500
    2)quantity 40 £500

    Total sales £1000

    So obviously 30 pieces are left worth of £270, how to account these?
    by doing journals?:
    DR Stock Balance sheet £270
    CR Stock P&L £270

    Then for the new financial year? Sure by looking the accounts you would like to find out straight way how much stock value is left? oh I'm so confused in such a basic thing!!:001_unsure:

    thanks for any help!
  • martin1971
    martin1971 Registered Posts: 6 New contributor 🐸
    Londina asked about purchase and sale of stock not opening and closing stock entries. I never said that purchase and/or sale of stock should be done using journal, I basically explained what entries are made in accounts when you purchase/sale stock.

    As I said before, more information is required in order to provide correct answer.

    edit:
    Your entry is correct
    Dr Balance Sheet
    Cr P&L

    Thats all, in your new financial year, balance in BS is your opening stock in new financial year.
  • Monsoon
    Monsoon Registered Posts: 4,071 Beyond epic contributor 🧙‍♂️
    martin1971 wrote: »
    I never said that purchase and/or sale of stock should be done using journal, I basically explained what entries are made in accounts when you purchase/sale stock.
    I wasn't implying otherwise, sorry if it came across that way. I was simply adding more clarification to your already correct answer :001_smile:

    Londinia, yes, you have it right. :)

    Additional info:
    Remember that stock is valued at the lower of cost price, and the net resaleable value.
    For example, if the 30 pieces that cost £270 could only be sold in the future for £200 (because they were damaged or obsolete for example) the closing stock journals would be at a value of £200 not £270.
  • Poodle
    Poodle Registered Posts: 711 Epic contributor 🐘
    Closing journals Sage

    Hi Londina

    I think that I now understand your question.

    You have already made and accounted for the purchases and sales in the year and it is only the final stock figure that you are having a problem with.

    In Sage for your closing stock figure post a journal dated the last day in your accounting period 31/03 as follows:

    Dr 1000 Stock (BS) £270.00
    Cr 5201 Closing stock (COS) £270.00

    Then in your new accounting period post a journal dated the first day 01/04 as follows:

    Cr 1000 Stock £270.00
    Dr 5200 Opening stock(COS) £270.00

    These codes are already in Sage as a default and so when you now run the P& L report it will now brng in the stock and produce the right result

    Hope this helps

    Poodle
  • Londina
    Londina Registered Posts: 814 Epic contributor 🐘
    faerie9 wrote: »
    Additional info:
    Remember that stock is valued at the lower of cost price, and the net resaleable value.

    I remember this is the case, but why do we need to use the FIFO/LIFO method sometimes?

    Many thanks to the others for the replies, you have been very helpful and kind!!:thumbup1:
Privacy Policy