MYOB Account right reports excluding end of year adjustment journals
We have 2 teams working in a ledger, my team does regular data entry, reconciliations etc.
The 2nd team calculates costing reports, creating accrual journals, tracking stock produced and sold, and preparing Cost Centre reports each month.
My team reconciles MYOB BAS report by proving it via P&L, Asset trading and payroll reports. We found that the Accrual Journals were throwing out our reconciliations, so we came up with a system that all Accrual entries were tagged with “Year- End Adjustment”.
We ran our reports excluding Year- End Adjustments, and our reconciliations balanced, and the other teams could run their reports including Year- End Adjustment, and get a true Accrual costing report.
The Accrual team started posting Journals in the ledger July 2021, and we have had not any incorrect balances until June 2023 reconciliations where it appears that the June 2022 closing stock figures have added to June 2023.
We can’t find a reason for it, so have posted a manual journal to remove the prior year balances.
Apart from the obvious, it concerns me what other balance sheet codes are picking up last year’s balances, without having to reconcile each code manually.
Either way, we need to find out why it is happening and how to fix it
Thanks