Use the method shown below to extract balance sheet & profit&Loss reports from both the current (reporting) and historical (comparative) years.
First, extract the balance sheet to Excel format. (select the exact report shown)
Be sure to line up the dates with the reporting period. For tax purposes, typically 30/06/20xx. DO NOT modify any other filters.
Pay careful attention to which folder on your computer you save the file to. Use Desktop if in doubt.
Then extract the Profit&Loss report. Be sure to line up the dates with the reporting period. For tax purposes, typically 01/07/20xx to 30/06/20xx.
Pay careful attention to which folder on your computer you save the file to. Use Desktop if in doubt.
Now select the "Financials" menu item.
Select "MYOB Accounting Classic".
Choose a pair for the comparative year i.e balanceSheet.xls at 30/06/2016 and profitLoss.xls from 01/07/2015 to 30/06/2016. Then hit Upload. Repeat for the reporting year i.e balanceSheet.xls at 30/06/2017 and profitLoss.xls from 01/07/2016 to 30/06/2017.
Order of import is not important. i.e. you might import the reporting period pair (balance sheet & profit&Loss) first.
If you need to make changes in the accounts, simply re-import after you've made those changes.
Once you've imported the files, navigate to Accounts and resolve any classification errors.
Check out some of the related Article:
Getting Started with Mapping Accounts
Chart of Accounts Taxonomy
Alternatively, you may also use our LodgeiT Smart Excel Utility, and choose "MYOB Accounting Legacy". LEARN MORE
