This support note applies to:
- AO Classic General Ledger (AU)
- AO Classic (NZ)
This article details how to change the balance date on an AO Classic General Ledger.
This procedure involves:
- Preparing the ledger for the extended period (step 1 and 2)
- Printing reports and finalising the extended reporting period (step 3)
- Preparing the ledger to produce comparatives for the next 12 month year (step 4, 5 and 6)
In this article, we use the example of changing the balance date from 31st March 2017 to 30th June 2018, extending the ledger to 15 months.
Ensure you have a reliable backup before performing this procedure.
Extending the financial year to more than 12 months is not something that we recommend. When changing the financial year end to more than 12 months (for example, 15 months) the first three months are ignored, causing problems with the opening balances in the new financial year and with comparative figures.
To avoid this issue, make sure you follow the instructions below very closely to extend the balance date correctly, as this is something we cannot assist you wish.
- From within the clients general ledger go to the General Ledger menu and choose Backup Ledger Data. The Backup up Ledger's Data files window opens.
- Choose location to save to, then click OK. The message Backup Completed successfully appears.
- Click OK.
- From within the client general ledger, click the General Ledger menu and choose Options. The Ledger Configuration window opens.
- Select Record Period Balances and Record Future Periods, then click Apply. The ledger is reconfigured.
- Click OK. The Ledger Configuration window closes.
In this example, we are changing the balance date from 31st March 2018 to 30th June 2018 extending the ledger to 15 months.
- Enter all transactional data for the financial year including the extended period. For example, April 2017 to June 2018 through Transaction Entry ensuring you select the correct period to enter the data into.
- Enter all accrual journals and stock / livestock journals in the final period of the extension. For example, "6 - June 2018"
In the Fixed Assets module, post depreciation to the General Ledger for the whole period. In our example, this would be for the 15 months ending 30 June 2018 i.e. Start month is "4 - April 2017", Finish month is "6 - June 2018".
If you have added any assets during the extended period (April, May or June 2018):
Open the Fixed Asset Ledger and select the asset that has been added during the future period.
- Print the Financial Reports for the whole period including the extended months. In Step 4 - Select Accounting Periods pick the extension's balance month in the End Date field. In our example, this would be for the 15 months ending 30 June 2018, i.e. Start month is 4 - April 2017, Finish month is 6 - June 2018.
- Confirm the reports show as expected and finalise the ledger. The Report titles should read For the XX Months ended DD Month Year or As at DD Month Year. In our example, it would be for the 15 months ending 30 June 2018 or As at 30th June 2018.
- Take another backup of the ledger (see Task 1, step 1).
- When the ledger year end is changed all transactions not within the 12 current year periods of the ledger will be ignored. To correct for this you need to journal all account balances for the first periods of the ledger. To identify what periods need to be adjusted for it will be one year prior to the new (extended) balance date.
Print a Trial Balance including Opening Balances. On Step 3 of the Trial Balance Report Wizard, deselect Year To Date, Selected Period Last Year, and Year To Date Last Year, so that only a double-column Selected Period Trial Balance is printed.
If you are using Quantities, then tick Quantity as well.
In our example, new year end is 30th June 2018 therefore we should select June 2017, therefore we need to print out a Trial Balance (including Opening Balances) for the first 3 months of the 15 month period i.e. Start month is 99 - Opening Balance, Finish month is 6 - June 2017.
- Post a journal through Transaction Entry (excluding GST), posting the balances on the Trial Balance into the next period. In our example, it is entered into the 4th period, 7 - July 2017, with a data entry date of 01/07/2017.
- Select the General Ledger menu > Options and change the Year End Date to the new year-end date. In our example, the year end date would be changed to 30/06/2018.
- Select the General Ledger menu > End of Year Rollover. The ledger will roll and the year end date will change to the new year. In our example, the year end date would roll to 30/06/2019.
- Check the Opening Balances and Comparatives to make sure they are correct.
- Check the Opening Book Values on your printed Fixed Assets Schedule. If they do not reconcile with the closing book values for last year, go to the Other tab and adjust the accumulated depreciation figure for each asset. This will alter the opening book value on the assets.
MYOB INTERNAL STAFF ONLY
This procedure is NOT recommended. However, if the client wants to extend the balance date the steps are available for them to use.
We do not do this procedure for them nor do we "fix" the ledger.
If there are any issues in the ledger after performing the above steps, they'll need to restore from a backup.