Import the client's transactions to a CaseWare RCT engagement
Deze functie is alleen beschikbaar in CaseWare Samenstel.
If you’re importing the client’s data from a CSV file, you need to first import the trial balance data then import the transactions CSV to populate the transactions data in your engagement.
Import from a CSV file
Go to the Data page and select Import in the left pane, then Import Transactions CSV. To successfully import transactions from a CSV file, you need to:
- Prepare the CSV file.
- Import the CSV file.
- Map the fields.
Stap 1: Prepare the CSV file
Make sure the transactions CSV file is valid. The validity requirements display in the page once you select Import Transactions CSV.
Stap 2: Import the CSV file
Drag and drop the file or browse.
Select the desired field delimiter.
- Comma (,)
- Tab (\t)
- Vertical Bar (|)
- Semicolon (;)
- Record Separator (\u001e)
- Unit Separator (\u001f)
Upon a successful file import, a confirmation message displays at the bottom of the page.
Stap 3: Map the fields
To complete the transactions import process, you need to map the source fields in the CSV file to the desired target values that match the data.
There are four main value categories for the target fields: Core, Additional Fields, Subledger Master and Account Master. Each category and its subsequent fields is listed on the page with field description to help you map the values correctly.
In some cases, once you map a field, the MAP VALUES button displays because there are further mappings that you need to make within this field. For example, the Document Type field (which is part of the Core category). Once you map this field to the desired source field in the transactions CSV, you need to select MAP VALUES and map the values within this field to target values as well.
The following figure shows an example of field value mapping for Document Type. Note that Document Type has been mapped to cw_js field in the source CSV file. In the process of value mapping, the target value General Ledger Entries (GJ) values is mapped to GJ from the CSV file.
Summary of the field mapping process
To summarize the field mapping process for importing transactions in a few steps:
Map each field in the source CSV with the desired target field from the available fields on th page.
If value mapping is needed for a specific field, the MAP VALUES button displays to allow you to map values.
Once you select MAP VALUES, a dialog displays showing the target values and drop-downs for each source value that needs to be mapped.
Make your selections, then select OK once you’re done.
Once you finish mapping all the fields, select Import.
Close the Import Transactions page and go back to your engagement file.
Select Accounts from the left panel.
Select an account balance to view its transaction details.
A message displays at the bottom of the page confirming a successful import.
Notice how accounts with transactional data now display in blue.
The following figure shows accounts with transactional data (in blue).
The following figure shows the transaction details for a specific account (in this example, transaction details for Insurance: Liability Insurance account).
Was dit artikel nuttig?Ja
In dit artikel
Onlangs bekeken artikelen
Subscribe to receive updates on the latest articles and news for CaseWare products.
Your download will start immediately after you subscribe.No thanks, I just want the file.