MYOB Essentials

How do I link my MYOB accounting data direct to my application?

1. Select MYOB button 2. A MYOB window will automatically appear. Enter your email address and MYOB password and select login 3. After you successfully log in, the MYOB Authorisation window will appear 4. Select Allow and you're done

Q: How do I upload my MYOB Essentials financial information? How to generate reports from MYOB Essentials

  1. Log in to your MYOB Essentials account
  2. A Dashboard page will appear
  3. Ensure that the account profile is set to the business that is applying for the loan by selecting the My Businesses on the top right hand side of the dashboard. Select the Business name that will appear on the next page

Your business trading accounts

  1. Select Reports on the top of the page and select All Reports
  2. Select General Ledger Details under Business Reports section
  3. Set the date From to be 365 days from today and To to be today's date.For example if today is 13th May 2016, the date should be set at "From" 14/05/2015 "To" 13/05/2016
  4. Select the Select Accounts dropdown box, untick the Select/Unselect all.Ensure to include all business trading accounts by ticking them, including the ones you use to make ATO payments
  5. To hide the dropdown box, scroll up and select Hide Accounts
  6. Select Update
  7. Select XLS and a window browser will appear. Select Save File to your preferred location and convert the excel file to CSV (to learn more about this file format, go to 'What is a CSV File')

Your Balance Sheet

  1. Select Reports on the top of the page and select All Reports
  2. Select Balance Sheet under Business Reports section
  3. Ensure that As at date is today's date. Select refresh
  4. Select XLS and a window browser will appear. Select Save File to your preferred location and convert the excel file to CSV (to learn more about this file format, go to 'What is a CSV File')

Your Profit and Loss

  1. Select Reports on the top of the page and select All Reports
  2. Select Profit & Loss under Business Reports section
  3. Set the date From to be 365 days from today and To to be today's date. For example if today is 13th May 2016, the date should be set at "From" 14/05/2015 "To" 13/05/2016
  4. As MYOB produces the report using the 30 June financial year cut-off, you may need to generate 2 reports
  5. Ensure the Breakdown is set at Total and Compare To fields are unticked
  6. Select Export and XLS
  7. A window browser will appear. Select Save File to your preferred location and convert the excel file to CSV (to learn more about this file format, go to 'What is a CSV File')

What is a CSV File?

A CSV file looks very similar to excel but without the formatting functions. This reduces the file size so it's smaller to upload and easier for the bank to make assessment of the information provided

How to convert excel to CSV?

To convert the XLS (excel) file to CSV, open the exported excel file, select File and the top left hand side and then select Save As. A window will open, locate 'Save as Type' dropdown box at the bottom of the window and choose CSV (Comma Delimited) (*.csv). Select Save.

MYOB AccountRight

How do I upload my MYOB AccountRight financial information using the latest edition?

1. Open your MYOB AccountRight accounting package

2. The Welcome to AccountRight box will appear

3. Select on the Business Name that is applying for the loan

4. Enter in your User ID and Password and select OK

5. The Command Centre page will appear

Your business trading accounts

1. Select Reports menu (at the top of the AccountRight window) and select Index to Reports

2. Select Banking on the left hand side and select Bank Register

3. Under Filter Report, set the "Dated from" to be 365 days from today.

4. For example if today is 13th May 2016, the "Dated from" date is 14th May 2015 and 'To' date is 13th May 2016. Select Display Report

5. Select the blue dropdown box on the top left hand side. Go to Export and select CSV.

6. A window browser will appear, select Save

Your Balance Sheet

1. Select Reports menu (at the top of the AccountRight window) and select Index to Reports

2. Select Accounts on the left hand side and select Balance Sheet under Balance Sheet

3. Ensure that the "As of" date is today's date and the "Financial year" is the current financial year

4. Ensure that "Report Level" is set at Level 4

5. Select Display Report and the file will appear

6. Select the blue dropdown box on the top left hand side. Go to Export and select CSV

7. A window browser will appear, select Save

Your Profit and Loss

1. Select Reports menu (at the top of the AccountRight window) and select Index to Reports

2. Select Accounts on the left hand side and select Profit & Loss Statement under Profit & Loss

3. As MYOB produces the report using the 30 June financial year cut-off, you may need to generate 2 reports

4. Ensure that the "From" date is set at 01/07/YYYY (most recent year of 1st of July) and "To" is today's date.

5. For example if today is 13th May 2016, the date should be set at "From" 01/07/2015 "To" 13/05/2016

6. Ensure that "Report Level" is set at Level 4

7. Select Display Report and the file will appear

8. Select the blue dropdown box on the top left hand side. Go to Export and select CSV.

9. A window browser will appear, select Save to your preferred location

10. Repeat 1-6 to generate the second report with setting the "From" date to be 365 days from today and "To" date to be 30/06/YYYY (last financial year). For example if today is 13th May 2016, the date should be set at "From" 14/05/2015 "To" 30/06/2015

If you have rolled over your transactions to this financial year, to generate the last year's transactions report:

1. Close the MYOB AccountRight software and reopen it

2. Select Open your company file and your document browser will appear

3. This time, select on the last year's file for the business that is applying for the loan

4. Enter in your User ID and Password and select OK

5. The Command Centre page will appear

6. Select Reports on the top of the page and select Index to Reports

7. Select Bank Register under Cheques and Deposit section

8. Select Customise on the middle bottom of the window. The Report Customisation - Bank Register will appear

9. Select the Accounts dropdown box and untick the blue tick box

10. Select all business trading accounts, including the ones you use to make ATO payments by selecting on the most left hand side of the cell. Select OK

11. Set the "Dated from" to be 365 days from today and "To" date to be 30/06/YYYY (last financial year). For example if today is 13th May 2016, the date should be set at "From" 14/05/2015 "To" 30/06/2015

12. Select Display on the right bottom window and the file will appear

Select Send to and choose Comma Separated Text File and the file will be opened. Select Save to your preferred location

Your Balance Sheet

1. Ensure the MYOB business account is in the current financial year

2. Select Reports on the top of the page and select Index to Reports

3. Select Accounts, then Standard Balance Sheet under Balance Sheet section

4. Select Customise on the middle bottom of the window. The Report Customisation - Standard Balance Sheet will appear

5. Ensure that the "As of" date is set to today and the "Financial Year" is set to the current financial year

6. Ensure that "Report Level" is set at Level 4

7. Select Display on the right bottom window and Balance Sheet will appear

Select Send and choose Comma Separated Text File and the file will be opened. Select Save to your preferred location

Your Profit and Loss

1. Ensure the MYOB business account is in the current financial year

2. Select Reports on the top of the page and select Index to Reports

3. Select Accounts, then Profit & Loss (Accrual) under Profit & Loss section

4. Select Customise on the middle bottom of the window. The Report Customisation - Profit & Loss (Accrual) will appear. As MYOB produces the report using the 30 June financial year cut-off, you may need to generate 2 reports

5. Ensure that the "Dated From" date is set at 01/07/YYYY (most recent year for 1st of July) and "To" is today's date. For example if today is 13th May 2016, the date should be set at "From" 01/07/2015 "To" 13/05/2016

6. Ensure that the "Financial Year" is set correctly to the current financial year

7. Ensure that "Report Level" is set at Level 4

8. Select Display on the right bottom window and the file will appear

9. Select Send to and choose Comma Separated Text File and the file will be opened. Select Save to your preferred location

Repeat 1-9 to generate the second report with setting the "From" date to be 365 days from today and "To" date to be 30/06/YYYY (last financial year). For example if today is 13th May 2016, the date should be set at "From" 14/05/2015 "To" 30/06/2015

MYOB AccountEdge

How do I upload my MYOB AccountEdge financial information?

1. Open your MYOB AccountEdge accounting package

2. Select Browse and your document browser will appear

3. Select on the file for the business that is applying for the loan

4. Enter in your User ID and Password and select OK

5.The Command Centre page will appear

Your business trading accounts

1. Select Reports on the top of the page and select Index to Reports

2. Select Banking, then Bank Register under Cheques and Deposit section

3. Select Customise on the middle bottom of the window. The Report Customisation - Bank Register will appear

4. Select the Accounts dropdown box and untick the blue tick box

5. Select all business trading accounts, including the ones you use to make ATO payments by selecting on the most left hand side of the cell. Select OK

6. If you haven't rolled over your transactions for this financial year, set the "Dated from" to be 365 days from today. For example if today is 13th May 2016, the date should be set at "From" 14/05/2015 "To" 13/05/2016.

7. If you have rolled over your transactions for this financial year, set the "Dated from" to be 01/07/YYYY (most recent year for 1st of July) and "To" is today's date. For example if today is 13th May 2016, the date should be set at "From" 01/07/2015 "To" 13/05/2016. See below for more instructions.

8. Select Display on the right bottom window and the file will appear

9. Select Send and choose Comma Separated Text File and the file will be opened. Select Save to your preferred location

If you have rolled over your transactions to this financial year, to generate the last year's transactions report:

1. Close the MYOB AccountEdge software and reopen it

2. Select Open your company file and your document browser will appear

3. This time, select on the last year's file for the business that is applying for the loan

4. Enter in your User ID and Password and select OK

5. The Command Centre page will appear

6. Select Reports on the top of the page and select Index to Reports

7. Select Bank Register under Cheques and Deposit section

8. Select Customise on the middle bottom of the window. The Report Customisation - Bank Register will appear

9. Select the Accounts dropdown box and untick the blue tick box

10. Select all business trading accounts, including the ones you use to make ATO payments by selecting on the most left hand side of the cell. Select OK

11. Set the "Dated from" to be 365 days from today and "To" date to be 30/06/YYYY (last financial year). For example if today is 13th May 2016, the date should be set at "From" 14/05/2015 "To" 30/06/2015

12. Select Display on the right bottom window and the file will appear

13. Select Send to and choose Comma Separated Text File and the file will be opened. Select Save to your preferred location

Your Balance Sheet

1. Ensure the MYOB business account is in the current financial year

2. Select Reports on the top of the page and select Index to Reports

3. Select Accounts, then Standard Balance Sheet under Balance Sheet section

4. Select Customise on the middle bottom of the window. The Report Customisation - Standard Balance Sheet will appear

5. Ensure that the "As of" date is set to today and the "Financial Year" is set to the current financial year

6. Ensure that "Report Level" is set at Level 4

7. Select Display on the right bottom window and Balance Sheet will appear

8. Select Send and choose Comma Separated Text File and the file will be opened. Select Save to your preferred location

Your Profit and Loss

1. Ensure the MYOB business account is in the current financial year

2. Select Reports on the top of the page and select Index to Reports

3. Select Accounts, then Profit & Loss (Accrual) under Profit & Loss section

4. Select Customise on the middle bottom of the window. The Report Customisation - Profit & Loss (Accrual) will appear. As MYOB produces the report using the 30 June financial year cut-off, you may need to generate 2 reports

5. Ensure that the "Dated From" date is set at 01/07/YYYY (most recent year for 1st of July) and "To" is today's date. For example if today is 13th May 2016, the date should be set at "From" 01/07/2015 "To" 13/05/2016

6. Ensure that the "Financial Year" is set correctly to the current financial year

7. Ensure that "Report Level" is set at Level 4

8. Select Display on the right bottom window and the file will appear

9. Select Send to and choose Comma Separated Text File and the file will be opened. Select Save to your preferred location

Repeat 1-9 to generate the second report with setting the "From" date to be 365 days from today and "To" date to be 30/06/YYYY (last financial year). For example if today is 13th May 2016, the date should be set at "From" 14/05/2015 "To" 30/06/2015

Bank transactions

Which financial institutions are supported?

We currently support transaction files from the following banks:

NAB, CBA, Westpac, ANZ, Bank of Melbourne, Bank SA, St George, Bankwest, Bendigo Bank, Bank of Queensland and Suncorp Bank

How do I upload my transaction history?

How to export your business trading accounts

1. Log in to your Internet Banking page

2. Choose your business trading accounts including the ones you use to make ATO payments

3. Please ensure that the date range is set to 365 days from today's date and:

a. There is no more than a 31-day gap between transactions and

b. The last transaction must fall within 31 days from the date you apply.

4. Export as CSV file

Please contact your bank(s) for further help and support of exporting your business trading accounts.