Import data from QuickBooks Online
QuickBooks Online is a supported online data import source in Caseware Cloud that allows you to seamlessly bring accounting data into Caseware Cloud engagements. Using this connector reduces manual data entry and supports consistent account mapping, grouping and financial reporting across engagements.
The QuickBooks Online connector supports automated imports for:
-
Trial Balance data - A worksheet in which all ledgers are compiled into debit and credit columns in order to ensure a company's bookkeeping system is mathematically correct.
-
General Ledger data - Full transaction details for the selected reporting period.
To Import data from QuickBooks Online:
-
Navigate to the Data page and select the Datasets tab.
-
Select Add data.
-
Under IMPORT FROM DATA CONNECTOR, select QuickBooks Online from the list. If it is not visible, enter QuickBooks Online into the Search box to find it.
-
When prompted, sign in to QuickBooks Online using the OAuth sign in page.
-
Grant the necessary permissions to allow access. The account you use to log in via OAuth for the data connector must also have the required permissions to import data.
-
In Select dataset type, choose the type of dataset you are importing. QuickBooks Online supports the following datasets:
-
Trial balance
-
General ledger
These imported datasets follow standard Caseware forms and are compatible with automated
financial reporting, analytics and mapping workflows.
Ensure the End date is correct.
In Prior years, you have the option of importing data related to the last five years:
-
Select Import the last 5 years of final trial balance data to import final balances.
-
Select Import the last 5 years of planning trial balance data to import planning balances.
-
-
Select Next.
-
At the Confirmation stage, review the information and select Import.
Note:The import status displays on the Datasets tab while the data is loading. If you navigate away from the Datasets tab while the data is importing, the import will continue. When you return, you can view the status of the import.
Your import is now complete.
To view the imported data, click View data next to the dataset you imported. A new page appears displaying the data. By default, all the columns in your dataset display.
Working with imported data
When you select QuickBooks Online as a data source, the import wizard guides you through the import process, including:
-
Selecting the dataset type.
-
Confirming the year start and end dates.
-
Selecting prior-year import options, if applicable.
After the import is complete, the datasets appear on the Data | Datasets tab. You can then:
-
View Trial Balance and General Ledger data.
-
Assign financial groups.
-
Use the data in financials, analytics and collaboration workflows.
Reimport data
You can reimport data from QuickBooks Online at any time. Caseware applies the standard reimport behavior.
When you reimport data:
-
Existing accounts are overwritten with the reimported data for accounts that already exist in the engagement.
-
New accounts in the reimported data are added to the engagement.
-
Accounts not included in the reimport data are removed unless they have prior-year balances, contain adjustments, or are linked to issues or annotations.
To learn more about reimport data, see Import data from online accounting software.
