Skip to main content
This sync will allow you to sync invoices from invoicing software to accounting software. Invoices sync

​
Default scope:

This integration sync will allow:
  • automatic synchronization of sales and/or purchase invoices (with attachment) from an invoicing software to an accounting tool.
  • synchronization of customers and suppliers (third parties):
    • if the third party doesn’t yet exist in accounting, the flow will try to find a match based on the following criteria:
      1. auxiliary accounting account vs. auxiliary account entered in the invoicing software
      2. VAT number
      3. company/SIRET number
      4. auxiliary accounting account vs. customer/supplier name
    • if no match is found, then a new customer/supplier is automatically created in the accounting system
Note that this is the default scope, based on your requirements this can be modified.

​
Mappings

Mappings are the way to map the data from the invoicing software to the accounting software.
Note that these are the default mappings, based on your requirements these can be modified.
1

Connect invoicing tool

This step allows user to connect its invoicing tool through apikey, credentials or oauth2.
2

Connect accounting tool

This step allows user to connect its accounting tool through apikey, credentials or oauth2.
3

Sales VAT rates/codes

This step allows you to specify the VAT code to use in accounting for each sales VAT rate existing in the invoicing software.

Reproduce this step by using the following API call(s) :
GET folders
GET vat codes
GET retrieve all taxes
4

Purchase VAT rates/codes

This step allows you to specify the VAT code to use in accounting for each sales VAT rate existing in the invoicing software.

Reproduce this step by using the following API call(s) :
GET vat codes
GET retrieve all taxes
5

VAT codes for rounding

Select the VAT codes to use for possible rounding differences.

Reproduce this step by using the following API call(s) :
GET vat codes
6

Journals

This step allows you to specify whether entries are made in a sales or purchase journal.

Reproduce this step by using the following API call(s) :
GET journals
7

Accounting accounts

  1. Sales Account (products): This step allows you to specify the accounting account to use in sales invoice lines if the information is missing in the invoicing software OR if the account mentioned in the invoicing software doesn’t exist or is not active in accounting.
  2. Purchase Account (expenses): This step allows you to specify the accounting account to use in purchase invoice lines if the information is missing in the invoicing software OR if the account mentioned in the invoicing software doesn’t exist or is not active in accounting.
  3. Customer Collective Account: This step allows you to specify the accounting account that serves as the customer collective in accounting. Generally, this is account 411
  4. Supplier Collective Account: This step allows you to specify the accounting account that serves as the customer collective in accounting. Generally, this is account 401
  5. Account to use for possible credit rounding: In some invoicing software, the sum of lines doesn’t always equal the invoice total due to VAT rounding. If the sum of lines is less than the invoice total, then a line is added to the invoice to balance this in accounting. Generally, this is account 758
  6. Account to use for possible debit rounding: In some invoicing software, the sum of lines doesn’t always equal the invoice total due to VAT rounding. If the sum of lines is greater than the invoice total, then a line is added to the invoice to balance this in accounting. Generally, this is account 658

    Reproduce this step by using the following API call(s) :
    GET chart of accounts
    (Filter on class 4, 6 and 7 accounts)
8

Discounts and rebates

This step allows you to specify whether discounts need to be specified in a separate account for discounts, rebates and debates ; it is an optional step. If not activated the discounted amount is directly deducted from the product/charges account.

Reproduce this step by using the following API call(s) :
GET chart of accounts
(Filter on class 6 and 7 accounts)

​
Configuration

  1. Synchronization Start Date: choice of the date from which invoices will be synchronized.
💡Synchronization starts automatically each night.
  1. Do you want to create entries as draft/pending?
    This option allows creation of “pending” accounting entries in the accounting software. This means the accountant must validate each entry before it is recorded. Some accountants prefer this approach for better control. Note that this is not supported by all accounting tools.
  2. Do you want to synchronize invoices without attachment?
    Do you want invoices to be synchronized to accounting when the PDF/attachment is missing in the invoicing software? If you select “no”, then sales and purchase invoices without PDF/attachment will not be synchronized until the PDF/attachment is provided.
  3. What do you want to synchronize?
    You can specify the integration scope: purchase and sales invoices, sales invoices only, or purchase invoices only.
  4. Label Settings
    This step allows you to define how accounting entry labels are composed. An accounting label is a description associated with an accounting entry that helps clarify each accounting entry. Four options are available:
  • The line linked to a customer/supplier account has the customer/supplier name as label / Other lines have the description from invoicing software as label
  • Customer/supplier name on all lines
  • Customer/supplier name + description of invoice lines on all lines
  • Customer/supplier name + invoice number on all lines

​
Troubleshooting

​
Appendix

​
Appendix 1: The account number doesn’t exist or is not active in the accounting system.

The account number of one of the items in the invoice is not found or is not active in the accounting system. If you have this error, it means that the account number used to create the invoice does not exist or is not active in the accounting system. The sync is working as follows:
  1. If available, we use the account number specified in the invoicing tool for the items of the invoice.
  2. We try to create the invoice with those account numbers in the accounting system.
  3. If the account number does not exist or is not active in the accounting system, we retry with the default account number specified in the mapping (Default account number for products & expenses).
  4. If the account number still does not exist or is not active in the accounting system, we raise an error. The invoice is not created in the accounting system.
This issue can happen in 2 cases:
  • the account number specified on the invoicing software doesn’t exist or is not active in the accounting tool
  • the default account number specified in the mapping doesn’t exist anymore in the accounting tool OR is not active in the accounting tool
What you can do:
  • Use a correct and valid account number in the invoicing tool for the items of the invoice or create and activate the account number in the accounting system.
  • Make sure the default account number in the mapping does exist or create the account number in the accounting system.

​
Appendix 2: The partner doesn’t exist in the accounting system.

The client/supplier referenced in the invoice is not found in the accounting system. If you have this error, it means that the client/supplier referenced in the invoice was created in the accounting system but does not exist anymore. This can happen if the accountant has deleted the client/supplier in the accounting system. What you can do:
  • Check if the client/supplier exists in the accounting system.
  • If the client/supplier does not exist, create a new one in the accounting system.
  • Contact Chift’s support to re-sync the client/supplier in the invoicing tool.