Our year end was 31st March 2016 this is only my second full financial year with GP2013. I closed the financial year 18th May having reconciled all the ledgers posting went fine, checked the balances into the new year all ok reports printed, checked balances carried forward into 2017 all ok straight forward. I have the auditors coming on the 1st June and today I thought I would print off the Stock Ledgers, Purchase ledgers as at year end in preparation. What I have now found is that the inventory and creditors no longer balance with the financial ledger.
To take the inventory for example reconciled stock close was 274,321 now in Financial Transactions at year end it is 308,662 when I run a stock ledger trial balance as at 31st March it is still 274,321. When I run a financial year end trial balance stock is still 274,321
I suspect someone has managed to post a batch of purchase invoices as April 2015 instead of April 2016 as all my period end balances have changed for stock and creditors from April 2015 by 34,341 (308,662 - 274,321) even though the periods were marked as closed. I have spent a full day searching for the transactions that might have caused these differences without any results.
Does any one have any ideas for tracing transactions in all ledgers from the time I did the year end close to trace what has impacted the previous years balances.
Any help appreciated I have a reputation of clear concise and accurate accounts over many years with our auditors !
Kind Regards
Rozt
*This post is locked for comments
1) Do you have multiple BBF entries in the GL20000 tables?
2) Look at the DEX_ROW_TS entry for your BBF entry. Then look for anything posted after that date (look at the DEX_ROW_TS ) in the GL30000 tables. That will show you anything that was posted to a prior year after you ran YE Close
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156