Quickbooks Financial Statements

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 choose Software Type as Quickbooks.


Steps to Download PL from Quickbooks

  1. Login to your Quickbooks account.
  2. Choose the company for which you would like to download the PL for.
  3. Click on Reports from the left pane. This opens a screen with a list of all the reports that are available to you.                                                                                                                                                                                                          
  4. Click on Profit and Loss report.                                                                                                                                                                                                                                                                                                                                    
  5. Select Report Period and click on the Run Report button. 
  6. To download the Profit and Loss report, click on the Export icon and choose Export to Excel. The Profit and Loss report will now be downloaded to a destination folder of your choice.                                                                                                                                                                                                                                                                                                                                                                      

Sample PL downloaded from Quickbooks




Steps to Download GL from Quickbooks
  1. Login to your Quickbooks account.
  2. Choose the company for which you would like to download the GL for.
  3. Click on Reports from the left pane. This opens a screen with a list of all the reports that are available to you.                                                                                                                                      
  4.  Scroll down the list or use the Search bar to look for General Ledger Report. It is available under For My Accountant. Click on General Ledger to open it.          
  5. Select a Report Period. Click on the Customise button.                                                                                                                                                                                                                                                                       
  6. Click on Filter and choose All Income/Expense Accounts in the Distribution Account dropdown list.                                                                                                                                                      
  7. Click on Change Columns and make sure that Debit and Credit columns are checked. Click on Run Report button.                                                                                                                            
  8. To download the General Ledger report, click on the Export icon and choose Export to Excel. The General Ledger List report will now be downloaded to a destination folder of your choice.                                                                                                                                                                                                                                                                                                                                  

Sample GL downloaded from Quickbooks

​

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

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

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