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

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

    • How to import a Trial balance and adjustments from an Agile audit engagement into a Cloud Financials engagement file.

      Cloud Financials provides the ability for users to easily import a mapped trial balance along with adjustments from an Agile audit engagement into a Cloud Financials engagement. This method cuts down the TB import time for users who need to create ...

    • What's New in Agile Audit?

      April 2024 This Major update includes: Enhancements: Improvements to 1-005 Independence Summary which is now displaying team member positions and new links to the new Engagement Teams table in 2-600 Overall Audit Strategy. This will improve ...

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