Guidelines for Format of Financial Statements

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
  1. Refer to articles here for the procedure to get the supported format from the accounting software, 
  2. If you are unsure, you may like to check with your clients and get documents in supported format.
  3. For financials that do not belong to the supported software types (Xero, Quickbooks, MYOB, ACCPAC), please contact support team with the documents. You can do so right from with the tool.

2.   Are there multiple tabs in your excel documents?  
  1. Make sure you have followed the process for downloading documents
  2. Note: If there are multiple sheets in the GL, PL or FA documents, the main tab should be labelled GL, PL or FA respectively. 
  3. Check for hidden sheets.
  4. The system will prompt you if this requirement is not met.

3.   Ensure there are not multiple year/month financials in the PL

  1. Ensure you have followed the process for downloading PL
  2. Check for hidden columns
  3. Note: If there are multiple amount columns in the PL, only the last column is read into the system. 

4.     General Ledger document cannot have any Balance sheet (BS) items

  1. Please ensure you have followed the process for downloading GL.
  2. Note: If you the GL with BS items you will have to remove them before uploading documents.


    • Related Articles

    • 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 ...

    • 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 ...

    • Xion Formatted Statements

      This article shows you the format for financial statements - GL, PL & FA that will be read in when Software Type Xion is chosen. General Ledger (GL) Download Xion GL Template Column Details: Date column accepts dates in all valid formats.  Note: As ...