GL report different to balance sheet report
Help needed please! When I run a GL report for 1 Jan 23 to 31 Jul 23, the closing balances for the accounts are wildly different to the closing balances in my balance sheet report as at 31 Jul 23...
Forum Discussion
Hi Rebekah5
Thank you so much for your post .This is because in the new MYOB, account balances in the Balance sheet are only made up of reconciled transactions, or transactions that have been entered manually, The calculated balance does not have to match the balance sheet. Any unreconciled transactions would cause the two figures to be different (these might be unpresented cheques or deposits).
The calculated statement balance from the Reconcile Accounts screen will reflect what is cleared in the bank reconciliation NOW. So make sure you are putting in the correct date in the bank statement date, and then see if the calculated statement balance is correct. If not, also check if there are any outstanding transactions. Sometimes a transactions can be edited and cause it to become "unticked". If there is is anything available for ticking - see if this will fix the issue.
Also check that the Last Reconciled date is 30/6/16. It is possible you completed the reconciliation and did not press the "Reconcile" button to finalise. Printing the report will not complete the reconciliation - you have to go back and click Reconcile.
Please do let me know how you go on this.
Regards,
Earl
