Triva isn't available right now.
Check out the support page for our phone number and hours
Quickbooks FAQ
Show all hidden content
Refer to the following common questions and troubleshooting information about the QuickBooks import process into the application.
General
What versions and editions of QuickBooks can I use to integrate with Accounting CS?
You can import the current and previous 2 versions of QuickBooks into Accounting CS. Accounting CS currently supports the following versions of QuickBooks:
- 2024
- 2023
This includes the following editions of QuickBooks:
- Pro
- Premier (Including Accountant's Edition)
- Enterprise
note
- Beginning with version 2016.1.0, integration with QuickBooks Online is available in the application.
- You'll need to have QuickBooks and the application installed in the same location to import client data directly. If you're working in Virtual Office CS or Software as a Service (SaaS), or your client has QuickBooks installed in their office, you'll need to use the QuickBooks Data Utility to import QuickBooks data into the application.
- The Industry Standard editions of QuickBooks, such as Construction and/or Non-profit, haven’t been tested and aren't supported for import into the application.
- Only the .QBW file can be imported and should be used as the working copy. The .QBB file or the .QBA files need to be converted to a .QBW prior to import.
- To verify the version of QuickBooks that you have installed, selectHelpthenAboutin QuickBooks.
If I re-import a client's QuickBooks data for the same time frame, will the application re-import everything or automatically create duplicates?
The subsequent import will bring over only the items that weren't included in the 1st import.
note
- If you modify a transaction in QuickBooks after it has been imported into Accounting CS, the application won't import the updates in subsequent imports. To include the changes in the application, you'll need to either manually make the changes in the application, or delete the transaction from the application so the QuickBooks transaction is included in the next import.
- If you modify an employee record in QuickBooks after it has been imported into the application, the application won’t import the changes in subsequent imports. This includes Social Security numbers that weren't imported due to the application certificate settings.
- If you manually enter a transaction in both QuickBooks and the application, the application won't see them as the same transaction, so it will import the QuickBooks transaction. This will result in duplicate transactions in the application.
Do I have to go through the mapping screens every time I import?
The import wizard remembers the mapping settings for the client after the 1st successful import. If you need to change a previously used mappings, you can unmark the
Skip data mapping screens
checkbox or select Clear All Mappings
.What fields can I edit on transactions imported from QuickBooks?
- Journal entries: subtype, journal, posting period, reference, date, description, distribution GL accounts, distribution descriptions, and distribution amounts.
- Checks: journal, posting period, distribution GL accounts, distribution descriptions, and distribution amounts.
- Deposits: bank account, journal, posting period, reference, date, description, distribution accounts, distribution descriptions, and distribution amounts.
- Payroll checks: bank account, journal, and posting period.
Troubleshooting
Why didn't my payroll checks import?
- Verify that the Payroll (After-the-fact) service is enabled on the client in Accounting CS.
- On theIntegrationtab of theClientsscreen, verify that theEmployeesandPayroll checkscheckboxes are cleared in the Don’t import section.
- In QuickBooks, verify that the payroll checks have a date, a reference number, and are not marked asPrint lateror any combination of these.
- Verify in both applications that the checks are assigned to an active bank account with an active GL account.
- Verify that the application security certificate in QuickBooks has theAllow this application to access personal data such as Social Security Numbers and customer credit card informationcheckbox marked.
Why aren't any employees showing up on the employment tax forms?
If SUTA/SUI is not set up properly in QuickBooks, it won't import into Accounting CS. The state unemployment payroll item description in QuickBooks need to contain the words
Unemployment Company
in that order and with no special characters to import successfully into the employer SUI in Accounting CS.Internal use only
- If there are error messages referencing "unemployment company", import three months or less at a time.
- Reasons balances are incorrect after completing the import
- Beginning balances are NOT imported from QuickBooks.
- To establish beginning balances in Accounting CS, re-close the year by moving the posting period back to the previous year and do one of the following:
- SelectActionsthenEnter Trial Balanceand enter the account balances in the Beginning Balance column.
- Follow Spreadsheet import - Account Balances from QuickBooks to import a spreadsheet with beginning balance numbers on it.
- Follow these steps to resolve an error message:Example error messages
- The state unemployment payroll item used on paycheck need to contain the wordsunemployment companyin the QuickBooks payroll item to import successfully.
- The given key was not present in the dictionary.
- Quick_books_transaction(Quick_books_transaction_ID Value already exists).
To resolve any of these errors, use the following information.- In QuickBooks, verify that the payroll item for SUI contains the wordsunemployment company.
- Import data in smaller increments (that is, 1 or 3 months at a time, depending on the number of transactions, this can vary.).
- Follow these steps to get the sign in fields to populate when connecting to QuickBooks Online:
- When you refresh the sign in window that displays, you may see a message that saysAn error has occurred in the script on this page.
- If your firm runs Accounting CS in any environment other than on Virtual Office or Software as a Service, you need to have Microsoft Edge for the sign in fields to display and function properly.
- Duplicate subaccounts can occur when account names in the application don't follow QuickBooks' required subaccount naming format.
- This issue can occur if the account description that is used in the application doesn’t match the naming guidelines that are required for QuickBooks integration. Any account that corresponds to a QuickBooks subaccount in the application need to match the specified naming guidelines for the account description.