Importing from online accounting software
Importing from Xero Online
If you use Xero Online to manage your client data, you can import these files directly into Analytics by logging into your Xero account and selecting the appropriate file. Xero imports currently only support up to one year of transaction data.
To import client data from Xero Online into Analytics:
Ensure that you have the Editor role or equivalent privileges. To connect to the Xero file, ensure that you have a valid Xero account and that you've been assigned the Standard user or Auditor role on the file. For more on users and roles in Xero Online, see their help materials.
In your Analytics engagement, select Add Data File | Import File From Xero.
A new browser window will open with the Xero login page. Enter your account credentials and select Login.
Select the appropriate client from the drop-down list, then select Allow access for 30 mins.
Select the checkboxes next to the client files you want to import, specify a Current fiscal year end date, then select Import.
Note: The Current fiscal year end date affects how the data is displayed, as well as the defaults for date-based Analytics tests. All data in the file, regardless of date, will be imported.
The client file from your Xero account is now available for use in Analytics, and is displayed in the Data Files pane.
Importing from QuickBooks Online
If you use QuickBooks Online to manage your client data, you can import these files directly into Analytics by logging into your QuickBooks account and selecting the appropriate file.
Related Articles
Importing from desktop accounting software
You can import to Analytics from a wide variety of desktop accounting packages. You can import client data for analysis from a number of desktop accounting suites. Downloading CaseWare Transformer First, you'll first need to download the CaseWare ...Detecting misstatements in your file with CaseWare Cloud Analytics
Analytics offers several tests specifically designed to look for misstatements, errors, or possible fraud in your client file to help assess risk and ensure that reported information conforms with accounting standards. These tests produce reports, ...Common import errors in CaseWare Cloud analytics
Problem When you attempt to import your file, you receive a prompt that the file is invalid. Solution Analytics only accepts .csv files and valid Transformer .zip files. If your client data is in a file type Analytics does not currently support (such ...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: - ...Import from MYOB Account Right Live
The Cloud Import Tool doesn't have a taskbar icon, so if the application is hidden in the background, please use Alt-Tab to switch to the tool. The CaseWare Desktop Import Tool now supports the ability to import from MYOB Account Right Live through ...