What settings must I follow for the proper functioning of the Sage GE connector?

  • Updated
This article details the synchronization process between Sage GE and your Qonto Accounting Hub, as well as the important rules to follow to ensure correct posting of entries. Before starting, please refer to the main article How can I set up synchronization of my accounting entries with Sage GE?.
 

What happens when a folder is created in the Qonto Accounting Hub ?

When a Sage GE folder is created in the Qonto Accounting Hub, the following elements are automatically retrieved from Sage GE:
  • The chart of accounts for the current fiscal year
  • The existing auxiliary codes
  • The journal codes

How does synchronization of the accounting reference data work?

Once the connection is established, the accounting reference data is synchronized between Qonto and Sage GE as follows:
  • Third parties: third parties are sent, created, or updated in Sage GE when entries are sent
  • Auxiliary accounts: auxiliary accounts are sent, created, or updated in Sage GE
  • PCG accounts: PCG accounts are created in Sage GE when entries are sent. If an account does not exist in Sage GE, its label will automatically be set as "Account" followed by the number (example: 610123456 - Compte 610123456). You will then need to manually correct the label in Sage GE
 

What rules apply to bank entries?

Limit on bank entry labels
 
Sage GE limits bank entry labels to 30 characters — they will be truncated beyond that. However, the full label remains visible in the "comment" field of the entry in Sage GE.
 
Numbering and attachments of bank entries
  • If an attachment is linked to a bank entry, the Sage GE document number is populated with the invoice number. The PDF file name corresponds to this number. Sage GE does not allow retrieval of multiple attachments for the same bank entry — this is a limitation of Sage
  • If no attachment is linked to the bank entry, Qonto populates the Sage GE document number with a unique technical identifier. Do not modify this number: it is essential for Qonto to identify possible rejections by Sage GE
  • Sage GE has automatic numbering for the document number, configurable on the journal. This setting applies automatically when the entry’s document number is empty
ACK codes in entry comments
 
In Sage GE, the comments of each entry contain a code in the form #AAAAA#: a unique identifier of the entry, essential to verify its proper creation in Sage GE, do not delete it.
 

What Sage GE accounting constraints must I respect?

  • The recording date (posting date) of the invoice determines the fiscal year on which the entries arrive in Sage GE
  • Entries containing an allocation to a control account (401, 411...) without an attached auxiliary account will be rejected by Sage GE
  • Entries posted to a closed journal or a closed fiscal year in Sage GE will be rejected by Sage GE
  • Entries with a posting date in a non-open fiscal year in Sage GE will remain pending synchronization on the Accounting page of the Qonto Accounting Hub and cannot be sent
  • Entries for a fiscal year older than the two most recent open fiscal years in Sage GE will be rejected — only the two most recent fiscal years can receive entries