Inventory - Profit/Loss Reporting

  • 1
  • Question
  • Updated 11 months ago
Hoping someone could help, we have recently set up our inventory and have our products which we build using inventory assemblies, I have noticed that in our profit and loss now the expenses for the inventory items only show once we build them, has anyone worked with assemblies before? Is there a more in-depth tutorial or coaching for working with inventory on Reckon and how using inventory will affect different reports withing the company system? Any help would be most appreciated. 
Photo of Tiffany Jennings

Tiffany Jennings

  • 140 Points 100 badge 2x thumb

Posted 3 years ago

  • 1
Photo of DebonAir

DebonAir

  • 5,952 Points 5k badge 2x thumb
I have been testing this for you and there is certainly a problem. I cannot get any of my inventory items to show on a P&L at all.
The only time it will show on the P&L is after I sell the inventory &/or inventory assembly item. Makes no difference in Cash or Accrual reporting.
Big Problem.
Unless someone else can assist to advise why this is happening???
(Edited)
Photo of John G

John G, Information Support Analyst

  • 27,510 Points 20k badge 2x thumb
That's right DebonAir, inventory items are only booked to Profit & Loss when they are sold.  Until then they sit on the Balance Sheet in the Inventory Asset account.  On a sale of inventory items, Reckon Accounts background accounting will credit the Inventory Asset account and Debit the Cost of Goods Sold account.

Open an invoice that contains an inventory item and click on the Journal button to see all the transactions that Reckon Accounts carries out.


regards,
John
Photo of DebonAir

DebonAir

  • 5,952 Points 5k badge 2x thumb
Oh yes, sorry, have not been dealing with inventory for a few years now and totally forgot about this. Just having a bad day!
Photo of F&S

F&S

  • 100 Points 100 badge 2x thumb
i have a similar issue, we input stock in as one code eg swarf, but then we steel it under another eg light steel, so I do not see the bills show in the profit and loss.

what do i need to do to fix this? do i need to some how transfer the swarf stock on hand to the light steel which is sitting at a negative on hand and swarf  has stock on hand.

sorry new to Reckon

Hi F&S

In order to track stock accurately, you must configure the one Item for both Sales & Purchases.  This is how the program knows to increase this stock Item (when purchased) & deduct from stock (when sold)