How do I import transactions and use 1-200 Data Completion workpaper?
Introduction
Transactions can be imported into Agile Audit and SMSF Audit engagements to allow auditors to drill down into the detail from the Trial Balance level. It is important to note however, that the import transactions feature should only be run after the Trial Balance has been imported into the engagement.
Note: For SMSF Audits of funds administered in either Class Super or BGL, the transactions import is performed automatically when using the relevant fund import integration option.
Method for Agile audit
In OPT Optimiser, ensure you have answered Yes to the Transactions question. With the Trial Balance imported, go to the Data page | Import screen to Import Transactions CSV.
In this screen you will be provided with some requirements that your CSV file must meet. If your file adheres to the outlined requirements, simply drag and drop it, or browse for it in the designated file upload space.
Transaction import rules:
Transactions can only be imported in CSV format.
The required fields for the CSV are date of transaction, reference number, transaction description, account number, transaction source, and transaction amount.
Once done, you will be required to identify the delimiter used in the file. In this case, the delimiter is a Comma. Click Continue.
You will now notice that your uploaded file has appeared under a transactions section.
Click on the Assign Data Fields button to begin mapping the columns of the file as fields. You can also use the bin icon to delete the imported file if it is incorrect.
If you have selected to map the file, you will see the screen below.
Use the dropdown arrow next to Import as to assign the columns to the appropriate areas.
For the transaction source column, you will need to choose the Document Type field, and then map the abbreviations to each of the different types of journals you are importing. This will ensure that the journal entries are identified correctly.
Once you have completed the mapping, click Import. It will then take you back to the transactions upload screen where you can see it has been mapped.
From here, you can see the status of the import and choose to save the format of the data layout to save time on assigning data fields with each import.
Where can I view Transactions?
The transactions can be viewed via two methods.
Option 1: After you have imported transactions, in the Data screen, you will see a new section called transactions. Press Transactions to review the details.
1-200 Data Completeness Workpaper
If you have imported transactions, you may use the 1-200 Data Completeness workpaper to assist you in determining whether the trial balance and general ledger are not missing any data that could lead to inconsistencies and errors that impact accuracy and reliability.
If the data is complete and accurate you should not have a large variance within the Difference between TB & GL column.
Related Articles
How do I use the Data tab?
The Data tab within both SMSF Audit and Agile Audit includes a number of screens, and is where data can be imported, viewed, analysed and referenced to. The following video walks through each of these screens, and summarises what can be done in ...Importing data from XERO to IDEA
There is no direct import from XERO to IDEA. You must first export the Trial Balance and General Ledger from XERO. Then import them into IDEA. Create the files in XERO Select Accounting> Advanced> Export Accounting Data Trial Balance: Select ...How do I import a new year-end TB over the existing trial balance?
After you have finished auditing the interim / planning trial balance, you may be required to import the final trial balance when you acquire it from the client. To import a new Trial Balance Go to the Data tab Select import Choose the reimport ...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 ...Import client's financial data from a CSV file for analysis
Formatting your client data in .csv format The following procedure uses Microsoft Excel to prepare the .csv file, but you can use any editing tool to produce the import file. Note: Journal and ledger data should conform to the following guidelines: - ...