Inventory Asset - Opening and Closing stock

Bernessa Roost
Bernessa Roost Member Posts: 20 Reckoner Reckoner

Hi brains trust.

The company accountant is concerned our inventory asset allocations is set up incorrectly as our Chart of Account is not balancing to the balance sheet. The accountant is not overall familiar with Reckon, he is familiar with systems that track stock through opening and closing stock accounts and the inventory asset account is used for Journal entry's.

Our Company is set up with all inventory items tracking through "Other Current Asset - Inventory Asset".

COGS and Income are posting to this account, every transaction is tracking. I have checked all inventory items are set up correctly as per the screen shot attached.

Should Reckon be posting to an open and closing stock account?

Any suggestions where I could look to find where the balance sheet discrepancy is?


Answers

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,754 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    edited October 2021

    The Items themselves should be set up linked to the appropriate sales or expense/COGS account, not inventory asset.

    The Inventory Asset account is where RA posts the value movements to accordingly, as transactions are entered. (You will see at the bottom of the each Item screen, the Inventory Asset account is linked there only)

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    shaz@accounted4.com.au

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
  • Bernessa Roost
    Bernessa Roost Member Posts: 20 Reckoner Reckoner

    Hello Shaz,

    I hope you are well today!

    Thank you for your response, very much appreciate your time.

    All items are set up as below, Purchase against COGS, Sales against Income, Asset account - Inventory Asset.

    I have checked every item to ensure they are correctly entered yet my balance sheet is not balancing to my chart of accounts.


  • Acctd4
    Acctd4 Accredited Partner Posts: 3,754 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert

    The balances in your Chart of Accounts (CoA) are real-time running balances - & therefore on an "Accrual" basis - & go back from the very start of the company file to date, whereas your Balance Sheet will be for a specific period in time.

    The Balance Sheet also has the option to reflect figures on a Cash or Accrual basis but - as above - the running balances shown in your CoA are always Accrual only.

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    shaz@accounted4.com.au

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)