Show Closing stock in P&L report
Options
Fozzie_9198383
Member Posts: 15 ✭
Not having much luck since taking accounts to hosted. Now when I run a P&L closing stock does not show but opening stock does. We don't run a stock system as our work is produced in an external system so it's a journal that has been done for years. Doesn't show in my P&L v Budget. All entries are there when I look at registers.
0
Comments
-
Hello Fozzie,
Thanks for asking.
You may want to consult a Reckon Accredited Partner to have your company file setup properly for your specific situation.
Generally, purchases of stock items will be added to the Inventory Asset account. When you sell the item its average cost value will be transferred from the Inventory Asset account to the Cost of Goods Sold account to allow a determination of Gross Profit. If all done correctly you should be able to match a physical stock-take to the item numbers stored in the Inventory module at any point in time and your Gross Profit a proper reflection of reality.
It sounds that you will need to make a general journal adjustment for your inventory item movement manually through a general journal - add in purchases to the Inventory Asset account and subtract the cost of goods sold over the reporting period to give you an Inventory Asset value in line with your inventory holding.
Hope this helps.
regards,
John0 -
I understand accounting. We dont receipt stock as an inventory item. Never have we deal in sheets of steel that are cut and there is scrap etc. Managed in our job database. Its easier to jnl in opening and closing entries never been an issue before. I have been in contact with tech support. I have found other issues with Reckon and unfortunately may have to change after many years. Had issues with Reportable super had to fix that for years now when i run p&l i can see issues with mv allowance and i guess its the same fix jumping into pay delete issue reenter. Its becoming all too hard to work around Reckons issues.0
-
Thanks Fozzie,
All the items you refer to are resolvable through proper configuration. Its understandable that as a business grows, the way software handles particular issues may become daunting. Reckon Accredited Partners thrive on circumstances like this and it is an avenue worth exploring.
regards,
John0 -
Check dates on the journal if correct, open the journal and then click ctrl+Y, this will show you the detail that is recorded. This can be used on any form ie cheque, bill, tax invoice etc very useful?0
-
Thanks, I will try that. Tech Support downloaded our file & trying to work out the issues. All of a sudden it dawned on me to do a rebuild, thought I might have been advised to do that...seems like my COGS is reporting correctly, now the closing stock figure is coming through. I can now drill down to detail on the chart of accounts, I can drill down on the P&L for details. I still had the issue of having to go into old pay records deleting the record and re-enter but that is something i have been dealing with for some time. So i guess that's the lesson, rebuild the file, not sure if this is something that should be done on a regular basis but I certainly won't forget it in a hurry had a lot of angst over the last couple of days.
0
Categories
- All Categories
- 6.9K Accounts Hosted
- 11 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.2K Reckon Payroll 🚀
- 21 📢 Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 3.1K Reckon One
- 7 📢 Reckon One - Announcements
- 11 Reckon Invoices App
- 14 Reckon Insights
- 114 Reckon API
- 830 Payroll Premier
- 326 Point of Sale
- 2K Personal Plus and Home & Business
- 74 About Reckon Community