Data Flow

Causal reads the following financial statements from QuickBooks:
  • P&L
  • Balance Sheet
  • Cash Flow
These are converted into Data sources in Causal, letting you connect variables in Causal to line items in the financial statements.
Causal doesn't write any data back to QuickBooks.

Connecting to QuickBooks

  1. 1.
    Go to the Data Sources page:
  2. 2.
    Click on QuickBooks under the New Data Source section.
  3. 3.
    Click Connect to QuickBooks and follow the instructions in QuickBooks' authentication flow.
  4. 4.
    Select the Account and Dataset you'd like to connect to, using the dropdowns.
  5. 5.
    Click Create Data Source. You can now use your QuickBooks data source in the same way as other data sources in Causal.

Disconnecting from QuickBooks

To disconnect from QuickBooks, select your QuickBooks data source from the Data page and click Disconnect.

Import data until

By default, Causal pulls in data for all periods (e.g. months) where data is available (or in the case of Xero/QuickBooks, until the last completed month).
However, in certain instances it may be useful to pull in data only until a specific month, for example: when your accounting books are not ready yet. To do that you'll need to enable Import data until (go here to read more).


Can you bring in dimensions (e.g. Classes and Department/.. etc) from QuickBooks into Causal as a category?

Yes! When importing data from QuickBooks, you have the option to bring in each GL code:
  • As is (no dimensional breakdown)
  • Split by Class
  • Split by Department/ Location/ Division /...
Last modified 6mo ago