SE
SmartEngagement
Working Papers
CaseWare Working Papers
AnalyticsAI
CaseWare AnalyticsAI
Time
CaseWare Cloud Time
PCR
OnPoint PCR (Preparation Compilation Review)
RCT
CaseWare  ReviewCompTax
PBC
CaseWare  Cloud Provided by Client Requests
Audit International
CaseWare  Audit International
SE
SmartEngagement
Working Papers
CaseWare Working Papers
AnalyticsAI
CaseWare AnalyticsAI
Time
CaseWare Cloud Time
PCR
OnPoint PCR (Preparation Compilation Review)
RCT
CaseWare  ReviewCompTax
PBC
CaseWare  Cloud Provided by Client Requests
Audit International
CaseWare  Audit International

Import the client's transactions to a CaseWare RCT engagement

Deze functie is alleen beschikbaar in CaseWare Samenstel.


If you’re using an online accounting software or a third-party accounting software, you typically get the option to choose to import transactions data as you import the trial balance data.

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:

  1. Prepare the CSV file.
  2. Import the CSV file.
  3. 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.

Validity requirements for transactions CSV file

Stap 2: Import the CSV file

  1. Drag and drop the file or browse.

    Drag and drop here or browse the CSV file.

  2. Select the desired field delimiter.

    Beschikbare opties:

    • Comma (,)
    • Tab (\t)
    • Vertical Bar (|)
    • Semicolon (;)
    • Record Separator (\u001e)
    • Unit Separator (\u001f)
  3. Select Continue.

    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.

Map values button displays for fields that can have multiple values.

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.

The field 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:

  1. Map each field in the source CSV with the desired target field from the available fields on th page.

  2. If value mapping is needed for a specific field, the MAP VALUES button displays to allow you to map values.

    1. Once you select MAP VALUES, a dialog displays showing the target values and drop-downs for each source value that needs to be mapped.

    2. Make your selections, then select OK once you’re done.

  3. Once you finish mapping all the fields, select Import.

  4. Close the Import Transactions page and go back to your engagement file.

  5. A message displays at the bottom of the page confirming a successful import.

  6. Select Accounts from the left panel.

  7. Notice how accounts with transactional data now display in blue.

  8. Select an account balance to view its transaction details.

The following figure shows accounts with transactional data (in blue).

Accounts with transactions display in blue on the page.

The following figure shows the transaction details for a specific account (in this example, transaction details for Insurance: Liability Insurance account).

Transactions for Liability Insurance

Was dit artikel nuttig?

Ja
Nee
This content is exclusively related to Rct and has been filtered out. Select the PRODUCTS dropdown in the top navigation to modify your filter settings.

Stay Connected

Subscribe to receive updates on the latest articles and news for CaseWare products.

Your download will start immediately after you subscribe.

Please enter a valid email.
No thanks, I just want the file.