Overview

The Audit Sight Template streamlines the process of importing comparative trial balance and journal entry data for your client. Follow the steps below to ensure a smooth and successful data import.

⚡ Best Practice: Always download the latest available template from the application before importing data. The template is frequently updated with improvements.

📌 What Data Can Be Imported?

The Audit Sight template allows users to import:

✅ Accounting data only

✅ Banking data only

✅ Both accounting and banking data

📊 Importing Accounting Data

Step 1: Complete the Comparative Trial Balance Tab

1️⃣ Obtain the Comparative Trial Balance – Retrieve the comparative trial balance from your client.

2️⃣ Paste the Data – Copy and paste the trial balance data into the Comparative Trial Balance tab of the template.

3️⃣ Complete Account Mapping – Assign each account a type (Asset, Liability, Equity, Income, Expense) and select an account mapping category.

4️⃣ Map the chart of Accounts Optional – Assign each account to a financial statement line item.

💡 Tip: The Mapping Categories tab provides a list of recommended categories, but you can create custom categories if needed. If you choose not to map the chart of accounts to financial statement categories, Audit Sight's Machine Learning Rules Engine will assign categories automatically.

📢 Why We Need the Comparative Trial Balance

The comparative trial balance is a critical part of the import process because it allows us to run data validation tests to ensure a complete general ledger is uploaded. Without this data, we cannot verify that all relevant journal entries are included, which may lead to errors in the audit process.

Step 2: Complete the Journal Entries & Lines Tab

1️⃣ Gather Journal Entry Data – Obtain journal entry details from your client for the same period as the trial balance.

2️⃣ Copy and Paste the Data – Paste the journal entries into the Journal Entries & Lines tab.

3️⃣ Sort Entries by Journal ID – Ensure journal entries are properly organized and sorted by Journal Entry ID for seamless processing.

🏦 Importing Banking Data

Step 1: Banking Accounts Tab

If importing bank transactions, enter: ✅ Full bank account numbers (not just the last four digits). ✅ Bank account names in the appropriate columns.

Step 2: Banking Transactions Tab

If including bank transactions, provide: ✅ Transaction dates, descriptions, amounts, and account numbers. ✅ A unique Resource ID for each transaction.

⚠️ Warning on Banking Data: Some banking exports will flip the signs of banking data. In Audit Sight, positive bank transactions represent money coming into the bank, while negative amounts represent money leaving the bank. Ensure that the data is formatted correctly before importing.

✅ Audit Sight Data Validations

💡 This tab is included to help check your work before you upload it to the solution.

To ensure a proper upload with no issues, make sure all validations are green before submitting.

📜 Key Reminders & FAQs

📍 Data upload will be consolidated to a single entity.

If you need entity-level insights, a file will need to be completed per entity.

🚨 Maintain the Template Structure

🚫 Do not:

Change tab names, tab order, or add extra tabs.
Hide any existing tabs.

Any modifications to the tab structure will prevent the data import from completing successfully.

⚠️ Do Not Leave Blank Rows in Data

Ensure that your data is entered as one continuous block with no empty rows in between.

💱 Currency Consistency

The currency of the banking data must match the currency of the accounting data. If the currencies are different, you will need to convert the data manually or use our data conversion services.

📌 What Happens If I Do Not Have a Journal Entry ID?

If you do not have a Journal Entry ID, you will need to use our data conversion services. Be sure to include the underlying source data for proper processing.

📅 What Happens If the Dates in the Template Are Outside of the Reporting Period?

If the dates in the template are outside of the reporting period, this can cause an error in the results. Be sure to adjust the dates to match the correct reporting period before importing.

📂 Can't Get the Data Fully Entered Into the Template?

If you are having trouble completing the template, our team frequently assists with fixing partially completed templates. This service is covered under our data conversion services.

🏢 For New Companies

If the company is new for the prior period, enter 0s for all amounts.

📖 Definitions & Data Fields

Comparative Trial Balance Tab

Field	Description
Account ID	Unique ID (usually a 4-digit code) used to identify the account.
Account Name	The name of the account (e.g., Accounts Receivable).
Beginning Balance	Account balance at the start of the testing period.
Ending Balance	Account balance at the end of the testing period.
Account Type	Classification (Asset, Liability, Equity, Income, Expense).
Account Mapping	Assigned financial statement line item (see Mapping Categories tab).
Is a Bank Account?	Specifies if the account is a bank account.
Account Description (optional)	Optional field for additional identifiers (e.g., location, class).

Journal Entries & Lines Tab

Field	Description
Journal ID	Unique identifier for the journal entry.
Journal Entry Description	Full description of the journal entry posted to the General Ledger.
Posted Date	The accounting date (not the data entry date).
Account ID	ID corresponding to the Chart of Accounts in the accounting system.
Journal Line Description	Description of the transaction line within the journal entry.
Debit Amount	Increases an asset/expense or decreases a liability/equity account.
Credit Amount	Increases a liability/equity account or decreases an asset/expense account.

📧 Need Help?

For additional support, contact our Customer Success Team at: 📩 support@auditsight.com