Inbound field reference

The CSV and XLSX templates use the same 26 columns. An optional column is not necessarily without effect: depending on the field, a blank cell preserves an existing value, applies a default, or leaves a feature unavailable. The published templates use the French headers below. GetBill also recognizes translated headers generated by its import templates; keep one header language consistently within a file.

Build a minimum row

Case	Required fields
Invoice debt	`Référence facture`, strictly positive `Montant`, usable `Téléphone` or `E-mail`, then `Nom` or `Société du débiteur`
Debtor/account balance	`ID interne`, `Référence débiteur`, strictly positive `Montant`, usable `Téléphone` or `E-mail`, then `Nom` or `Société du débiteur`
Credit note	Its own `ID interne`, a negative `Montant`, and the target `Référence facture` or fallback `Référence débiteur`

Every new positive debt requires Nom or Société du débiteur. A correctly matched update may omit these identity fields. A correctly matched credit note may omit identity and contact details.

Row references

Field	Requirement	Format	Use / blank value
`Référence facture`	Required for invoice granularity; conditional for a credit note	Stable text unique within the scope	Identifies the invoice and finds the debt in later imports. For a credit note, identifies the credited invoice. Leave blank for a global account balance.
`ID interne`	Required for an account balance and a credit note	Stable text unique within the scope	Technically identifies a global balance or the credit note itself. For a positive invoice debt, it may be blank when `Référence facture` is stable.
`Référence débiteur`	Required for an account balance; optional for an invoice	Stable business identifier	Identifies the debtor or account, supports grouping, and acts as the fallback credit-note target.

Link invoices to a debtor

A Référence facture identifies an invoice. A Référence débiteur identifies the individual, company, or account that owns it. Therefore, multiple Référence facture values can share the same Référence débiteur: repeat the same identity and contact details on every row.

Référence facture	Référence débiteur	Prénom	Nom	E-mail
`INV-SYNC-001`	`CUST-SYNC-001`	Jean	Dupont	`jean.dupont@example.com`
`INV-SYNC-002`	`CUST-SYNC-001`	Jean	Dupont	`jean.dupont@example.com`
`INV-SYNC-003`	`CUST-SYNC-002`	Marie	Martin	`marie.martin@example.com`

A new invoice for the same debtor receives a new Référence facture, not a new Référence débiteur.

Never reuse a stable reference for another debtor or debt. An existing reference triggers an update, not a new creation.

Identity and contacts

Field	Requirement	Format	Use / blank value
`Civilité`	Optional	For example `M.`, `Mme`, `Monsieur`, or `Madame`	Personalizes reminders. GetBill normalizes recognized variants; blank does not impose a title.
`Nom`	Conditional on creation	Text; comma-separated for multiple contacts	Required for a positive creation without `Société du débiteur`. Optional for a correctly matched update or credit note.
`Prénom`	Optional	Text; comma-separated for multiple contacts	Completes the debtor or contact identity. Optional on creation and for a correctly matched update or credit note.
`Téléphone`	Conditional	Valid national or international number; comma-separated for multiple numbers	`Téléphone` or `E-mail` is required in every positive-debt row, including an update. Enables phone and SMS channels. On an accepted update, a blank cell does not overwrite the existing phone; the row must then provide a valid `E-mail`.
`E-mail`	Conditional	Valid email address; comma-separated for multiple addresses	`Téléphone` or `E-mail` is required in every positive-debt row. Enables email reminders. On an accepted update, a blank cell clears the existing email; to preserve it, omit the entire column and provide a valid `Téléphone`.

Costly phone destinations

The SFTP bridge retains an otherwise valid debt with a costly phone destination. GetBill configures the choice per bridge-managed campaign, disabled by default; the SFTP partner has no field to set it. When not allowed, it records expensive_destination_not_accepted as a non-blocking warning and restricts SMS, RCS, calls, WhatsApp, and voicemail for that phone; email and postal reminders remain eligible. Bridge results expose warnings, warning_count, and warnings_omitted after asynchronous processing. Campaigns sharing a timeline remain independent. For comma-separated contacts, supply every contact’s fields in the same order; the first contact is primary. Do not leave an empty intermediate value: GetBill removes blank items from each column independently before matching positions.

Field	Two-contact example
`Prénom`	`Jean,Marie`
`Nom`	`Dupont,Martin`
`Téléphone`	`+33601020304,+33605060708`
`E-mail`	`jean.dupont@example.com,marie.martin@example.com`

Address

Field	Requirement	Format	Use / blank value
`Adresse`	Optional	Complete free-form address	Provides a directly usable address. It may coexist with structured components.
`Numéro`	Optional	Street number with an optional suffix	Structured address component. When blank, GetBill may extract a number found at the beginning of `Rue`.
`Rue`	Optional	Street name, optionally prefixed by its number	Structured component used to rebuild `Adresse`.
`Code postal`	Optional	Text, so leading zeroes are preserved	Completes the postal address.
`Ville`	Optional	Text	Completes the postal address and postal-mail context.
`Pays`	Optional	Country name	Specifies the address country. It does not replace the country calling code required by an ambiguous international phone number.

Debt, payment, and status

Field	Requirement	Format	Use / blank value
`Objet de la dette`	Optional	Text	Describes the debt source in reminders and screens.
`Société créancière`	Optional	Legal or trading name	Distinguishes the creditor for grouping, reporting, and credit-note matching.
`Montant`	Required on creation and for a credit note; optional for an existing reference	Decimal number without a currency symbol	`Montant` is required on creation and must be positive. For an existing reference, blank preserves the balance, zero settles it, and a negative value imports a credit note.
`Devise`	Optional	Currency code or symbol, such as `EUR` or `€`	Currency for the balance and payments. GetBill converts recognized codes to symbols. A blank cell or unrecognized value becomes `€`; when the column is entirely absent, the import uses `EUR`. The resulting value is also applied on an update.
`IBAN`	Optional	IBAN as text	Stores the bank reference used by configured payment journeys.
`Lien de paiement`	Optional	External URL; `https://` recommended	Associates an external payment link with the debt. GetBill stores the value without validating its format. Blank on creation stores no external link; blank on an accepted update clears the existing link. Configured GetBill payment methods are independent from this field.
`Date d’émission`	Optional	`YYYY-MM-DD`	Date on which the invoice was issued.
`Date d’échéance`	Optional	`YYYY-MM-DD`	Date on which the debt became due; used in reminder context and exports.
`Identifiants`	Optional	Text	Login information or an additional reference that may be returned to the debtor and in exports.
`Statut`	Optional	`En cours`, `Soldé`, `Échoué`, `Archivé`, `Résolu`, or `Repris manuel`	`Statut` is optional. Blank on creation applies `En cours`; blank on update preserves the current status.

Any unrecognized header with a non-empty cell is retained as a dynamic variable, except explicitly retired legacy aliases. These fields are outside the standard contract: agree their names and uses during onboarding.

Prepare the file

Return to the format, naming, and synchronization rules.

Get started

Guides

SFTP integration

Company API

Creditors API

Debtors API

Debts API

Timelines API

Campaigns API

Settings API

Invoice documents API

Followups API

Todos API

Status API

Build a minimum row

Row references

Link invoices to a debtor

Identity and contacts

Costly phone destinations

Address

Debt, payment, and status

Prepare the file

​Build a minimum row

​Row references

​Link invoices to a debtor

​Identity and contacts

​Costly phone destinations

​Address

​Debt, payment, and status

Prepare the file

Build a minimum row

Row references

Link invoices to a debtor

Identity and contacts

Costly phone destinations

Address

Debt, payment, and status