Resolutions for common errors that occur when integrating actuals from Quickbooks
Article Contents:
- Invalid COA Structure
- No Retained Earnings Accounts or Multiple Retained Earnings Accounts
- Income Statement Actuals Not Matching QuickBooks
Invalid COA Structure
An invalid COA structure error typically occurs when a Chart of Accounts (COA) import from QuickBooks includes an account that references a missing or incorrect parent account, often due to the parent being deleted or an inconsistent structure in the QuickBook Chart of Accounts.
To resolve this issue, first check QuickBooks to review the accounts specified in the Jirav error message for any necessary updates. If needed, you may need to contact Intuit Support for assistance in correcting the account structure.
If you'd like to proceed without making changes in QuickBooks, Jirav Support can help adjust the import to allow it to go through. Please submit a support ticket, and our team will assist you.
No Retained Earnings Accounts or Multiple Retained Earnings Accounts
Jirav automatically identifies Retained Earnings by looking for an Equity account containing the phrase "Retained Earnings." If multiple accounts match or no accounts meet this criteria, a warning is issued. To resolve this warning update your QuickBooks Chart of Accounts to ensure there's only one account labeled Retained Earnings.
Income Statement Actuals Not Matching QuickBooks
If you notice differences between your income statement actuals in Jirav and QuickBooks Online (QBO), it may be due to category settings. This issue can occur when transactions with classes and/or locations were created in QBO, but later, class and/or location tracking was disabled.
To resolve this issue, enable Track Classes and/or Track Locations in Quickbooks and then reimport the data to Jirav.
- Check Class Tracking in QBO:
- Go to QBO > Gear Menu > Account and Settings > Advanced > Locate the Categories section.
- If Track Classes and/or Track Locations it's disabled, enable it.
- Import into Jirav:
- Once tracking is on, import your data into Jirav from Settings > Actuals.
Another factor contributing to discrepancies in the Income Statement Actuals between QuickBooks and Jirav may be the incorrect selection of the Accounting Method in Jirav. It is essential to select the appropriate Accounting Method, either Accrual or Cash. To resolve this issue, please follow the steps outlined below:
- Adjust Accounting Method:
- Navigate to Settings ⚙️ > Company > Accounting > Choose right Accounting Method
- Navigate to Settings ⚙️ > Company > Accounting > Choose right Accounting Method
- Import into Jirav:
- Once the right Accounting Method is set, import your data into Jirav from Settings > Actuals