QuickBooks Online - Actual Import Instructions

Import your COA & account balances into Jirav Automatically

Your accounting data is the backbone of the Jirav Financial Model. The first step in setting this up is to import a chart of accounts and your accounting balances. 

QuickBooks Online is one of the most common accounting systems used by small businesses around the world. If you're using QuickBooks Online for your accounting system, you can follow the guide below to start hooking up your data. 

  1. Log in to Jirav.com
  2. Navigate to [Actuals] within the gear icon
  3. Find the box for QuickBooks and click on [Connect]
  4. This should redirect you to the QuickBooks website where you can enter your credentials
  5. You'll be automatically sent back to Jirav and the connection will be complete
  6. Select the date range for how far back you want to import from, click on [Import].
    Pro Tip: We recommend importing a full fiscal year plus year-to-date to start.

If multiple dimensions have been enabled within your Quickbooks account, you will be prompted to select which you would like to map to your Departments within Jirav. Learn how to change your dimension selection

Now watch as the Chart of Accounts and Trial Balances come in immediately!

Tips 

  • Make sure you have "master administrator" or "company administrator" permissions to access the QuickBooks account that you want to use.
  • If you manage multiple companies within QuickBooks Online, make sure you select the correct company to connect in Jirav.
  • Review your list of accounts to insure there are no duplicate entries.  The import will fail if there are multiple accounts with the same name.  Rename any duplicates.  Inactivating them will not work as Jirav imports all accounts, active or inactive.
  • If your QuickBooks account has more than 15 Classes Jirav will fail on the import; you can merge the Classes in QuickBooks to solve this issue; deleting Classes will not work since Jirav will count the deleted Class towards the 15 Class limit - Link for Intuit Help Article on Merging Classes
  • If you decide you would like to change which dimension from Quickbooks that you would like to map to your Departments in Jirav, navigate to Setup -> Departments. You will then click on the 3 dots next to Quickbooks and Select Dimensions.

If you haven't yet, we recommend checking out the Getting Started guide next for setting up the remaining steps within the application and to learn how to explore your data within the platform.