MYOB Financial Statements

MYOB Financial Statements

This document describes the steps to download the PL and GL statements from your MYOB account. The general format for the statements from MYOB is also listed here. Files in this format will be read in by the AI.TaxAssist tool when you choose Software Type as MYOB.

Steps to Download PL from MYOB
  1. Choose the client/company's MYOB file for whom you would like to download the PL for and login to the MYOB software. Click on Reports.                                                                                                                                                                                                             
  2. Under Profit & Loss choose Year to Date.                                                                                                                                                                                                                                                                              
  3. In the dialog that opens, choose the correct Date from and To for which you want the PL report.                                                                                                                                                                 
  4. In the Finishing tab, make sure to check the box next to Include Account Numbers. Click on the Display button when done.                                                                                                                    
  5. To export out the PL report, click on Send To button at the bottom of the screen and choose Excel from the list. The Profit and Loss report will now be downloaded to a destination folder of your choice.                                

Sample PL downloaded from MYOB 




Steps to Download GL from XERO

  1. Choose the client/company's MYOB file for whom you would like to download the GL for and login to the MYOB software. Click on Reports.                                                                                                                                                                                                     
  2. Under Accounts choose General Ledger (Detail).                                                                                                                                                                        
  3. In the dialog that opens, choose the correct Date from and To for which you want the GL report. Click on the dropdown list button next to Accounts.                                                                                                                                                                                       
  4. In the list that opens uncheck all items that have account numbers 1- to 3-. These are the Balance Sheet items that should not be listed  in the final GL report.                                                                                                                                                                                         
  5. Click on Finishing tab and make sure to uncheck the box next to Include Accounts with No Activity. This is to omit all the GL accounts that have 0 amounts. Once done click on the Display button.                                                                                                                                     
  6. You can use the option Screen Report under View on the top bar to align the report correctly. Once done, choose Print Preview from the View dropdown list.                                                                                                                                                                            
  7. The final report is ready to be exported out. To export out the GL report, click on Send To button at the bottom of the screen and choose Excel from the list. The Profit and Loss report will now be downloaded to a destination folder of your choice.     
          

Sample GL downloaded from MYOB 


    • Related Articles

    • Guidelines for Format of Financial Statements

      This article lists all the rules that must be followed before you upload documents into the AI.TaxAssist tool. 1.     Select the correct source accounting software of the financial documents in the system Refer to articles here for the procedure to ...

    • ACCPAC Financial Statements

      This document showcases the general format for the statements that are downloaded from ACCPAC software. Files in this format will be read in by the AI.TaxAssist tool when you choose Software Type as ACCPAC. Sample PL downloaded from ACCPAC Sample GL ...

    • Quickbooks Financial Statements

      This document describes the steps to download the PL and GL statements from your Quickbooks account. The general format for the statements from Quickbooks is also listed here. Files in this format will be read in by the AI.TaxAssist tool when you ...

    • Xero Financial Statements

      This document describes the steps to download the PL, GL and FA statements from your Xero account. The general format for the statements from Xero is also listed here. Files in this format will be read in by the AI.TaxAssist tool when you choose ...

    • Financial Documents Required

      In order to produce the tax computation, AI.Taxassist system requires a few financial documents from your client. The documents required are listed below, Note: General Ledger should only contain P/L items. No items from Balance Sheet should be ...