Import a client's financial data from a CSV file for analysis
This feature is only available with CaseWareCloud Analytics, part of the CaseWare Cloud suite.
CaseWare Cloud enables you to upload client data and produce Analytics reports. These reports can then be saved to Cloud, downloaded to your computer or exported directly to Working Papers to be included in your engagement.
Note: If your data is from one of the following accounting software, you can following the instructions in Upload accounting data from another accounting software for analysis.
- AuditXML 3.x
- MyOB AccountRight Live 2013 - 2016
- Pastel Partner 12.1-14.0
- QuickBooks CA 2012 - 2017
- QuickBooks US 2012 - 2017
- Sage 50 Accounting (Peachtree - WIN) 2012 - 2017
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:
- Each row must represent either a debit or a credit, meaning each transaction takes up at least two rows.
- No more than one transaction ID column.
- No more than one amount column, with debits as negative amounts and credits as positive amounts. If your files do not conform to this formatting, you can adjust them later.
To format a .csv file for import into Analytics:
In your accounting software, export your client file in an editable format (such as .txt, .xls or .csv).
Open the file in Excel.
Select each blank row in your file. Right-click on any blank row and select Delete.... In the Delete dialog, select Entire row, then click OK.
Delete all rows containing:
totals or subtotals.
Click File | Save As and choose:
CSV (Comma delimited) as the Save as type.
Unicode (UTF-8) as the Encoding (under Tools | Web Options at the bottom of the dialog).
Enter a file name and click Save.
The client data can now be imported into your Analytics engagement.
Importing .csv files into Analytics
Import your formatted .csv client file into your Analytics engagement. During this process, you will have the option to map the columns of your import file to the data columns in Analytics.
To import a .csv file into Analytics:
Ensure that you have the Editor role, or equivalent privileges.
From the Cloud menu, select Analytics.
Select the Analytics engagement, then select Add Data Files.
Select the appropriate option. After you select a file, the File Import dialog opens.
Select New File: Upload a file from your system.
Select Existing File: Select a file from the Files page in Cloud.
You can map your file from the File Import dialog, or wait until after the import is complete. You will need to map the file before you can perform most Analytics tests.
To map the file from this dialog:
Enter a description of the file in the Description field.
Select the predefined Analytics Type that best matches the file. The Type determines which Column meanings will be available to select from. If none of the Types are a good match, select Unassigned.
If your file has a header row, select the Contains Header checkbox and specify its row number under Specify row containing column names. This is set to 1 by default. Do the same for the First row of data, which is set to 2 by default.
For each column, select whether you want to include it in the import by selecting or deselecting Ignore selected column.
For each column, specify a Column name, Column type, and Column meaning that best match the data. If no available meanings are appropriate or you're unsure which meaning to assign, leave the column Unmapped. True/False data can be imported, but not mapped.
When the upload is complete, the data file will appear in black in the Data Files pane. If you mapped the file, a summary of its data will appear in the Profile page.
Was this helpful?Yes
In this article
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.