Background
Audit Sight has built custom automation to streamline data uploads directly from the Crunchafi Data Extraction Full Analysis Report. This integration allows for seamless importing and efficient processing of your client data—no manual mapping or setup required.
Key Requirments
To ensure a successful upload, verify that you are running the Crunchafi Data Extraction Full Analysis Report. This report contains all the information needed for Audit Sight’s automated conversion and import process.
Step-by-Step Instructions
Download the Full Analysis Report
Log in to your Crunchafi Data Extraction account.
Navigate to your engagement and select Full Analysis Report.
Download the file to your computer.
The report should resemble the example provided in this guide.
2. Upload the File to Audit Sight
Log in to your Audit Sight account.
Select your client and navigate to Add Data→ Accounting Data → Crunchafi (Strong box) Upload.
Select the appropriate entity and upload the downloaded Full Analysis Report file.
Audit Sight will automatically detect and convert the data for import.
3. Confirm the Import
Once processed, you’ll receive a confirmation email that the data has been imported successfully.
Data Imported
Audit Sight automatically imports the following information from the Crunchafi Data Extraction Full Analysis Report:
Trial Balances
Chart of Accounts
General Ledger
❌ Note: Accounts Receivable (AR) and Accounts Payable (AP) Aging data are not imported from Crunchafi Data Extraction files.
FAQ
Is this upload option free?
Yes. The Crunchafi Data Extraction upload feature is available at no additional cost for all Audit Sight users.
What data range is imported?
Audit Sight imports the entire date range of data included in the Full Analysis Report.
What if my Crunchafi report doesn’t include all months or transactions?
You’ll need to re-run the Full Analysis Report in Crunchafi Data Extraction and ensure that all periods and entities are included before re-uploading.
Where does Audit Sight store Crunchafi mappings?
Crunchafi mappings are maintained in the Description column within the Chart of Accounts (CoA) screen in Audit Sight. This reflects how the Crunchafi category was originally imported.
Why doesn’t the mapping always match Crunchafi exactly?
Audit Sight uses its own internal set of mapping categories, which differ from Crunchafi's classification structure. Because of this, mappings cannot always translate on a one-for-one basis. Audit Sight may assign a category that best aligns with its testing framework, even if it differs slightly from Crunchafi's original label.
What happens if Audit Sight assigns a mapping category that is different from how Crunchafi has it listed?
If you’d like to update the Chart of Accounts mapping to better reflect your preferred classification, you have two options:
Update directly in the UI – Modify the mapping within the Chart of Accounts screen in Audit Sight.
Re-upload the Audit Sight (AUS) template – Download the generated template, adjust the mappings as needed, and re-upload the corrected file.
Either method will update the mappings used in testing going forward.
