Importing a Trial Balance into Agile Audit

Importing a Trial Balance into Agile Audit

To import a Trial Balance into an Agile Audit engagement, navigate to the Data page.




In the import screen, you will see there are options to import from Excel or CSV, as well as from the Quickbooks and Xero platforms.


Importing from Excel / CSV:


Click on the Excel or CSV button.



 

Click on the Browse for a file button.




Browse to, and select the required excel file, and click Open.        


   

Each column in the trial balance needs to be defined by selecting the appropriate dropdown option above it.



For each column, make one of the following selections:

Trial Balance column

Import column selection

Account number

Account Number

Account description

Account Name

Current year account balance

Choose one of the following: 

  • CY (Current Year: Debit and Credit combined column)

  • CY – Debit (Current Year: Debit column only)

  • CY – Credit (Current Year: Credit column only)

Prior year account balance

Choose one of the following: 

  • PY (Prior Year: Debit and Credit combined column)

  • PY – Debit (Prior Year: Debit column only)

  • PY – Credit (Prior Year: Credit column only)


Note: To exclude a column from being imported, select Do not import.


Checkboxes in the first column: Untick those rows which do not represent trial balance data, and are to be excluded from being imported.

This can include any of the following:

  • Heading rows

  • Title rows

  • Sub-totals

  • Grand total


Upon making the appropriate selections, click Import.

        




    • Related Articles

    • Agile Audit Process Map

      The Agile Audit process map attached in this FAQ below illustrate the best methodology to use our CaseWare Agile Audit for an audit engagement. To go alongside the process map, a series of FAQs are below to provide details on parts of the process ...

    • Consolidation in Agile Audit

      Although consolidation is a feature in Agile Audit, it is important to be aware of a few key rules/best practices: 1. Only Trial Balance and journal data will be consolidated - there is no consolidation of risks or documentation between entities ...

    • Why is my Trial balance balancing in Excel but not in CaseWare

      If your trial balance in Microsoft Excel is balancing well, but not in CaseWare it is likely that there are existing duplicated account numbers within your Excel Spreadsheet. CaseWare Working Papers will only allow unique account numbers to be ...

    • Enabling Agile Audit for staff

      After Agile Audit ANZ has been enabled on your firm’s CaseWare Cloud site, a Cloud administrator will need to assign the app to the relevant staff to access and use.  This is done one of two ways: Both options below can only be performed by a Cloud ...

    • Getting Started - Agile Audit

      Before following the below steps, please ensure that all relevant staff have the Agile Audit ANZ app enabled within their cloud account. See Enabling Agile Audit for staff to learn how to. Step 1: Create an Agile Audit engagement For more ...