“Transaction not in balance” Journal Synchronization error

The following Journal entries referenced in the Synchronization Log may not synchronize with Quickbooks due to a missing or invalid G/L account for COGS in Configuration Management. This article is written for users that are posting COGS by product class. The same procedures can be used for other sales / COGS posting options.

Symptoms:

Synchronization log contains the following error:

Error Journal Submit GLJournalBatch: error while creating journal entry 01xxxx: There was an error when saving a General Journal transaction. QuickBooks error message: Transaction not in balance.

Common Causes:

  • A COGS account used in Acctivate has been renamed in the QuickBooks Charts of Accounts.
  • The COGS adjustment account is not set for every product class.
  • Warehouses are missing GL accounts in Configuration Manager

Follow these steps to resolve this problem:

  1. Find the journal entry number(s) from the synchronization log.
  2. Run the Inventory Detail Journal report (in the Transactions folder under Inventory Reports).
  3. Set the Journal ID equal to the journal entry number (i.e. Journal ID = 0010001).
  4. Open Product Information for the products listed on the report to determine which product classes have incorrect accounts.
  5. Open Configuration Management -> Inventory -> Product Class and lookup the Product Class ID (ex. Equipment).
  6. Look at the “COGS GL Acct / Seg” and “COGS Adj GL Acct Seg” and replace these accounts with the proper GL accounts from QuickBooks. Consult with an accounting professional if you need assistance selecting the proper GL Account.
  7. After selecting the proper GL Account, synchronize with QuickBooks.

In some instances, this Journal sync error may be received due to some miscalculation of a transaction. If you are unable to resolve this error, submit a support request and Acctivate Technical Support can review these errors with you.

Posted in QuickBooks and Sync - Last modified on September 16, 2015Cassandra Creasy
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support request.