en:wiki:compta:exportximport

Différences

Ci-dessous, les différences entre deux révisions de la page.

Lien vers cette vue comparative

Les deux révisions précédentes Révision précédente
en:wiki:compta:exportximport [2026/10/17 10:47] – Automatic push translation eneuvilleen:wiki:compta:exportximport [2026/10/23 21:32] (Version actuelle) – Automatic push translation eneuville
Ligne 58: Ligne 58:
   * Transaction ID: generated automatically; it is not stored   * Transaction ID: generated automatically; it is not stored
   * Journal code: derived from the document’s account assignment or from the journal entry   * Journal code: derived from the document’s account assignment or from the journal entry
-  * Entry date: the document or journal entry date+  * Entry date: the document date or journal entry date
   * Due date: the document’s due date   * Due date: the document’s due date
   * Document number: the document number, for a document, or the document number linked to the journal entry, for a journal entry. This document number consists of a letter and digits. This is the document’s internal number, prefixed by “C” (customer invoice), “A” (customer credit note), “F” (supplier invoice) or “W” (supplier credit note).   * Document number: the document number, for a document, or the document number linked to the journal entry, for a journal entry. This document number consists of a letter and digits. This is the document’s internal number, prefixed by “C” (customer invoice), “A” (customer credit note), “F” (supplier invoice) or “W” (supplier credit note).
Ligne 65: Ligne 65:
   * Amount: the relevant amount   * Amount: the relevant amount
   * C/D: C or D depending on whether it is a credit or a debit   * C/D: C or D depending on whether it is a credit or a debit
-  * Reference: the document number if it is a document, the entry number if it is an entry. In the latter case, it is prefixed with ‘E’ (E456, for example)+  * Reference: the document number if it is a document, or the entry number if it is an entry. In the latter case, it is prefixed with ‘E’ (E456, for example)
   * budget: budget code (for journal entries)   * budget: budget code (for journal entries)
   * account description: the description of the chart of accounts entry   * account description: the description of the chart of accounts entry
Ligne 76: Ligne 76:
 :WARNING: It is your responsibility to check the export data before importing it into your accounting software! :WARNING: It is your responsibility to check the export data before importing it into your accounting software!
  
-:WARNING: Gestan For sales, it handles VAT rates on debits, receipts and the option on debits. However, for purchases, Gestan only handles VAT on debits and receipts.+:WARNING: Gestan For sales, it handles VAT schemes on debits, receipts and the option on debits. However, for purchases, Gestan only handles VAT on debits and receipts.
  
 ==== Export options ==== ==== Export options ====
Ligne 89: Ligne 89:
   * to pad accounts with a configurable number of zeros: for example, if you prefer to see 70600000 rather than 706, simply set the option to pad to 8 characters   * to pad accounts with a configurable number of zeros: for example, if you prefer to see 70600000 rather than 706, simply set the option to pad to 8 characters
  
-If the box **Simple** is ticked, the export will be carried out without detailing the revenue accounts (see [[fr:wiki:compta:partiedouble#exemple_d_une_facture_client|example of a customer invoice]]) ''(only tick this box if you are fully aware of the implications)''.+If the box **Simple** is ticked, the export will be carried out without detailing the revenue accounts (see [[en:wiki:compta:partiedouble#exemple_d_une_facture_client|example of a customer invoice]]) ''(only tick this box if you are fully aware of the implications)''.
  
 If the **No third parties** is ticked, journal entries for third-party accounts will not be generated. If the **No third parties** is ticked, journal entries for third-party accounts will not be generated.
Ligne 95: Ligne 95:
 If the **New only** is ticked, the export will be limited to items that have not already been exported. If the **New only** is ticked, the export will be limited to items that have not already been exported.
  
-**Round** allows you to force rounding for each journal entry if necessary. Gestan, in fact, stores monetary data with all its decimal places, in order to process this data accurately. However, in some cases, there is no mathematical solution, and the journal entry may not balance due to rounding discrepancies. This tick box allows you to conventionally assign the rounding discrepancy to the most relevant tax account entry (the one with the highest amount, excluding Credit/Debit pairs with transactions of the same amount).+**Round** allows you to force rounding for each entry if necessary. Gestan, in fact, stores monetary data with all its decimal places, in order to process this data accurately. However, in some cases, there is no mathematical solution, and the journal entry may not balance due to rounding discrepancies. This tick box allows you to conventionally assign the rounding discrepancy to the most relevant tax account entry (the one with the highest amount, excluding credit/debit pairs with transactions of the same amount).
  
 ==== Suffixing via the PCG account ==== ==== Suffixing via the PCG account ====
Ligne 103: Ligne 103:
 {{fr:wiki:compta:ximport_04.png?nolink|}} {{fr:wiki:compta:ximport_04.png?nolink|}}
  
-When exporting accounting data, for entries in the revenue class (excluding the discounts granted account), the account will be suffixed with the PCG suffix.+When exporting accounting data, for revenue class entries (excluding the discounts granted account), the account will be suffixed with the PCG suffix.
  
 In the example above, if the revenue account is 708 and the VAT rate for the entry is 0, it will be posted to account 7089. In the example above, if the revenue account is 708 and the VAT rate for the entry is 0, it will be posted to account 7089.
Ligne 109: Ligne 109:
 If the export is out of balance, the credit and debit total fields are highlighted in red. If the export is out of balance, the credit and debit total fields are highlighted in red.
  
-If the discrepancy is only a few pence, it is most likely due to a rounding error in a document or a journal entry.+If the discrepancy is only a few pence, it is most likely due to a rounding error on a document or a journal entry.
  
 The first step in investigating this is to identify the document and/or journal entry causing the discrepancy. To do this, rerun the process over shorter periods until the unbalanced transactions are identified. For example, run the process over one month: if it balances, you can move on to the next month. If not, you can reduce the period to find the problematic item. The first step in investigating this is to identify the document and/or journal entry causing the discrepancy. To do this, rerun the process over shorter periods until the unbalanced transactions are identified. For example, run the process over one month: if it balances, you can move on to the next month. If not, you can reduce the period to find the problematic item.
Ligne 184: Ligne 184:
   * if the customer ID differs from the subsidiary ledger account: it is the subsidiary ledger account   * if the customer ID differs from the subsidiary ledger account: it is the subsidiary ledger account
   * otherwise:   * otherwise:
-    * if the external customer reference is not provided, it is the customer ID+    * if the external customer reference is not specified, it is the customer ID
     * if the external customer reference is provided, it is this external reference     * if the external customer reference is provided, it is this external reference
  
Ligne 201: Ligne 201:
 Gestan has supported CPS-type taxes since version 15.40.00/U10. You can generate all documents including this surcharge. For the XIMPORT export, there are no issues regarding VAT on debits, provided you specify in the settings the specific account you will be using (usually 44578 in France). However, for businesses subject to VAT on receipts, you will need to wait for version A1.00.00 of Gestan before the XIMPORT export correctly allocates payments in French Polynesia. FIXME Verification in progress. Gestan has supported CPS-type taxes since version 15.40.00/U10. You can generate all documents including this surcharge. For the XIMPORT export, there are no issues regarding VAT on debits, provided you specify in the settings the specific account you will be using (usually 44578 in France). However, for businesses subject to VAT on receipts, you will need to wait for version A1.00.00 of Gestan before the XIMPORT export correctly allocates payments in French Polynesia. FIXME Verification in progress.
  
 +\\ \\
 ----------------- -----------------
-{{wiki:tags:voir_aussi.gif?nolink |}}**Other “Accounting” articles**+ℹ️ **Other “Accounting” articles**
  
 <nspages fr:wiki:compta -nbCol=2 -textPages="" -h1 -r -simpleLineBreak > <nspages fr:wiki:compta -nbCol=2 -textPages="" -h1 -r -simpleLineBreak >
  • en/wiki/compta/exportximport.1792234064.txt.gz
  • Dernière modification : 2026/10/17 10:47
  • de eneuville