Overview:
When syncing Shopify settlement summaries to QuickBooks Online, you may receive the following error:
“JournalEntry Number already exists.”
This error occurs when a journal entry with the same reference number already exists in QuickBooks Online. QuickBooks does not allow duplicate journal entries with identical reference numbers, so the settlement summary cannot be synced.
For example, if a settlement summary has the reference number Cash_260313, but a journal entry with the same reference number already exists in QuickBooks Online, the settlement summary will fail to sync.
How to Resolve the Error:
There are two ways to resolve this issue.
Option 1: Update the Existing Journal Entry
Update the reference number of the existing journal entry in QuickBooks Online so that it no longer conflicts with the Shopify settlement summary.
Once updated, you can manually sync the settlement summary by navigating to:
Shopify → Apps → Parex Bridge QBO → All Settlements → Select “Unsynced” → Send to QuickBooks
Select the respective settlement summary and click Send to QuickBooks.
Alternatively, let our support team know once the reference number has been updated, and we can assist with resyncing the pending summary.
Option 2: Use a Different Reference Number
If you prefer not to modify the existing journal entry, we can sync the settlement summary using a modified reference number by appending “-1”.
For example:
Original: Cash_260313
Modified: Cash_260313-1
This provides a unique reference number and allows the settlement summary to sync without conflicting with the existing journal entry.
Please contact our support team if you would like us to use a modified reference number for the pending summary.