When Qonto submits entries to your accounting production software, the software performs a consistency check and may reject them for certain reasons. This article lists the main rejection cases and the corrective actions to take.
How can I identify an entry with a synchronization error?
Entries rejected by your accounting software are indicated in the Accounting area:
- On the left, select your Client
- Click on the "To Verify" tab
- Synchronization errors are indicated in the "Status" column on the right, or by applying a filter on the status.
When there is a synchronization error, the entry status appears as Synchronization Failed.
To know the reason for the rejection, hover your mouse over this Synchronization Failed message — the error message returned by your accounting software will appear.
You can click on the entry to review and correct it in Qonto (or adjust the settings in your accounting software depending on the case).
Then, in Qonto, you must mark the entry as verified.
The entry will be resent at the next click on the Synchronize button in Qonto or automatically the following night, depending on your automatic sending settings.
What are the main Sage GE rejection reasons and how to fix them?
Error 1 — "The purchase, sales, OD journal, etc. is locked or read-only"
- Cause: the Sage GE journal is not open. The invoice posting date may fall within a fiscal year not opened in Sage GE, or the journals may be locked despite an open fiscal year
- Solution: open the necessary journals in Sage GE, then in Qonto, mark the invoice as verified: the invoice entries will be resent at the next synchronization
Error 2 — "The analytical axis does not exist. On-the-fly creation is not allowed"
- Cause: analytical data is expected by Sage GE, but Qonto does not provide analytical data
- Solution: in Sage, allow the import of entries without analytical data then in Qonto, mark the invoice as verified: the invoice entries will be resent at the next synchronization
Error 3 — "At least one line has a failure status; the allocation of the line amount is incorrect on at least one of the analytical axes"
- Cause: analytical data is expected by Sage GE, but Qonto does not provide analytical data
- Solution: in Sage, allow the import of entries without analytical data then in Qonto, mark the invoice as verified: the invoice entries will be resent at the next synchronization
Error 4 — "Account (401000) or other is collective"
- Cause: a collective account (401, 411, 421...) was used without an associated auxiliary account in the accounting allocation
- Solution: in Qonto, Edit the invoice by adding the missing auxiliary account then mark the invoice as verified: the corrected invoice entries will be resent at the next synchronization
Error 5 — "Account xxxxxxxxx is locked"
- Cause: the entry attempts to be sent to a closed fiscal year or a closed account — often caused by an input error in the posting date
-
Solution: you have three options:
- in Qonto, Edit the invoice by adding the missing auxiliary account then mark the invoice as verified: the corrected invoice entries will be resent
- Exclude the invoice from the Qontable Space if it is too old
- Modify the account or fiscal year settings in Sage GE, then mark the invoice as verified in Qonto: the corrected invoice entries will be resent at the next synchronization
Error 6 — "The fiscal year (2020, 2021...) is not part of the last 2 open fiscal years"
- Cause: the entry attempts to be sent to a fiscal year that is not among the two most recent open fiscal years in Sage GE
-
Solution: you have three options:
- Adjust the open fiscal years in Sage GE (maximum two consecutive fiscal years, including one covering the posting date)
- Modify the invoice posting date in Qonto
- Exclude the invoice in the Qontable Space if it is too old
Error 7 — "Import cursor locked"
- Cause: periods are locked in the Sage GE import settings
-
Solution:
- In Sage GE, go to Utilities > Import Cursor Settings > Lock Tab and uncheck the locked periods
- Mark the invoice as verified in Qonto: the invoice entries will be resent at the next synchronization
Error 8 — Entries remain stuck "synchronizing"
- Cause: Qonto has sent the entries to the Sage cloud, but they have not yet been injected into Sage GE
- Solution: open the accounting of the folder in Sage GE to trigger the import of entries sent by Qonto (see below for more solutions).
Error 9 — Other errors ("Object reference not set", "String or binary data would be truncated", "Record not found", "The document is not settled")
- Contact Qonto support indicating the exact error message displayed
What to do if my entries remain synchronizing?
Entries stuck in the Entries synchronizing tab mean that Qonto has successfully sent them to the Sage cloud, but they have not yet been injected into Sage GE.
First, verify that the API is enabled on the Accounting page of the Qontable Space. If not, consult the main article on connecting Sage GE. If the API is enabled, apply the solutions below.
Solution 1 — Close and reopen the Accounting page of the folder in Sage GE
- In Sage GE, open the relevant folder
- Click the Accounting button — this triggers the injection of entries from the Sage cloud
- If you were already in the folder's accounting, close it and reopen it
If entries remain stuck after this, proceed to solution 2.
Solution 2 — Check and reactivate the Qonto Marketplace in Sage GE
- In Sage GE, open the relevant folder and click the Marketplace button (shopping cart icon)
- Check the status of the Qonto connector:
- If the Qonto Marketplace is deactivated, activate it
- If an error message about the reference administrator appears: ask your Sage GE administrator to reauthenticate via Processes > GE Connector > Reference Administrator > Authenticate Reference Administrator Account
- Once the Marketplace is active, reopen the Accounting page of the folder in Sage GE to trigger the injection of pending entries
⚠️ When the reference administrator needs to reauthenticate, Sage GE displays the message at each opening: "For security reasons, the GE Connector security certificate has expired... It is necessary for the reference administrator to identify again."
For more information, consult the official Sage documentation: Sage GE Help — Administrator Reconnection and the associated video tutorial.
What to do if a red triangle appears on the Integration page?
A red triangle on the "Integration" page of the Qontable Space indicates a configuration problem with the accounting period. This procedure should also be followed if Qonto support asks you to deactivate and then reactivate the Marketplace in Sage GE.
Step a — Check the accounting period in Sage GE
- In Sage GE, open the relevant folder via the Accounting button
- Position yourself on the fiscal year covering today's date
- Go to Year Menu > Fiscal Year Period and verify that the fiscal year covers today's date
⚠️ A maximum of two consecutive fiscal years must be open in Sage GE, without interruption between them. If this is not the case, adjust the open fiscal years before continuing.
Step b — Deactivate then reactivate the Qonto Marketplace
- In Sage GE, on the relevant folder, click the Cart button (Marketplace)
- Double-click on the Qonto line and click Deactivate — confirm
- Return to the Marketplace screen, double-click again on Qonto
- Check the box "I accept the interactions described above" and click Activate
- Once activated, click Resynchronize fiscal years from the Marketplace screen
What to do if the Sage GE connector is disconnected?
If the Sage GE connector indicator appears disconnected on the Accounting page of the Qontable Space, follow these steps to reactivate it.
- Open Sage GE and the relevant folder
- In the folder's Marketplace (Cart button), check the status of the Qonto connector
- If the box is not checked, double-click the Qonto icon to open the activation window
- Check "I accept the interactions described above" and click Activate
- Return to the Accounting page of the Qontable Space — the connector indicator should turn green
What to do if Sage GE reports batches to import just after the first connection?
When first connecting your folders to the Sage GE API, it is normal for Sage GE to display messages reporting rejected third-party batches when opening the accounting. These messages appear because Qonto automatically sends third parties and accounts without entries during the initial connection, and Sage GE rejects them.
⚠️ These error messages have no consequences — ignore them and click OK. When you send real entries to Sage GE, any rejections will be displayed in the Qontable Space, under Accounting Menu > Rejections tab.
Useful links: