Consume SFTP exports

Configure scheduled exports

This feature is optional and can be enabled independently of the inbound flow. The outbound format is independent from the inbound format: a client can send CSV and receive XLSX. Agree the outbound folder, format, frequency, run time, and time zone. Use a sortable name such as:

getbill_export_20260724_183000.xlsx

Understand XLSX exports

An operational XLSX export contains:

Créance, for human review, with debts and follow-up subrows;
Data, for automated integration, with one row per debt and follow-up combination.

The sample workbook’s Notes sheet is documentary and is not guaranteed in generated exports.

Understand CSV exports

The CSV export is a flat UTF-8 file with BOM and semicolon delimiter. It contains one row per debt and omits XLSX follow-up subrows. To make reconciliation with an inbound file easier, the header starts with ID, then Invoice Reference, Internal ID, and Debtor Reference. Shared import/export fields then follow the inbound order as closely as possible: identity, contacts, address, debt, amounts, and status. Export-only columns come afterwards.

Understand column availability

The published French sample exposes the same 75 headers in both operational XLSX sheets:

Créance shows one main row per debt followed by its optional follow-up subrows;
Data shows one row per debt/follow-up combination, or one debt row when no follow-up exists.

The published French CSV sample exposes 70 headers and one row per debt. These counts cover standard columns before any client-specific fields are appended. Generated export labels follow the export locale. Their meanings and availability remain those in the dictionary below. A blank calculated field generally means that the debt has no corresponding value, event, dispute, or payment plan.

Identification, debtor, and debt

Field	Availability	Format	Meaning
`ID`	CSV + XLSX	Text	Displayable GetBill identifier of the exported debt; for a grouped row, the representative debt’s identifier.
`ID interne`	CSV + XLSX	Text	Stable technical reference received as `ID interne` on import.
`Date d'import`	CSV + XLSX	`YYYY-MM-DD HH:MM:SS`	French sample header for the debt creation date, rendered in the export time zone. Generated English exports label this column `Import date`.
`Prénom`	CSV + XLSX	Text, comma-separated contacts	Primary contact first name followed by secondary contact values.
`Nom`	CSV + XLSX	Text, comma-separated contacts	Primary contact last name followed by secondary contact values.
`Téléphone`	CSV + XLSX	Text, comma-separated contacts	Primary phone followed by secondary contact numbers.
`E-mail`	CSV + XLSX	Text, comma-separated contacts	Primary email followed by secondary contact addresses.
`Société créancière`	CSV + XLSX	Text	Creditor company associated with the debt.
`Société du débiteur`	CSV + XLSX	Text	Business debtor’s legal or trading name.
`Adresse`	CSV + XLSX	Text	Consolidated debtor address.
`IBAN`	CSV + XLSX	Text	IBAN stored on the debt when available.
`Référence facture`	CSV + XLSX	Text	Invoice business reference; blank for a global account balance.
`Référence débiteur`	CSV + XLSX	Text	Debtor or account business reference.
`Objet de la dette`	CSV + XLSX	Text	Debt source or label.
`Date d’émission`	CSV + XLSX	`YYYY-MM-DD`	Date on which the invoice was issued.
`Date de naissance`	CSV + XLSX	`YYYY-MM-DD`	Debtor birth date when supplied.
`Date d'échéance`	CSV + XLSX	`YYYY-MM-DD`	Date on which the debt became due.
`Résumé`	CSV + XLSX	Text	Cleaned consolidated summary for the debt or group.
`Lien débiteur GetBill`	CSV + XLSX	Absolute URL or blank	Link to the debtor record in GetBill; blank when no debtor is attached to the debt.
`Lien créance GetBill`	CSV + XLSX	Absolute URL	Link to the debt and its history in GetBill.
`Lien de paiement`	CSV only	URL	External payment link stored on the debt.
`Identifiants`	CSV only	Text	Login information or additional reference imported with the debt.

Amounts, status, and activity

Field	Availability	Format	Meaning
`Montant`	CSV + XLSX	Decimal number	For an individual debt, the amount stored on the debt before payments and credit notes are deducted. For a grouped row, the remaining group balance after payments and active credit notes.
`Montant récupéré`	CSV + XLSX	Decimal number	Calculated only for a `Soldé` or `Partiel` debt: paid-installment total when available, otherwise the debt amount when paid, or the stored paid amount when partial. A grouped row sums these values.
`Devise`	CSV + XLSX	Currency code or symbol	Value stored on the debt, for example `EUR` or `€`.
`Direction`	CSV only	Localized text	Summary direction of the latest relevant interaction.
`Statut`	CSV + XLSX	Localized text	Current debt status or consolidated group status.
`Sous le seuil de relance`	CSV + XLSX	Localized Yes / No	Indicates whether reminders are suspended below the threshold. The debt remains due.
`Seuil de relance`	CSV + XLSX	Decimal number	Reminder threshold stored on the debt, in its currency. Blank if the exporting user does not belong to the owning company.
`Catégorie`	CSV + XLSX	Text	Configured debt category.
`Scénario`	CSV + XLSX	Text	Assigned reminder workflow.
`Nombre de relances`	CSV + XLSX	Integer	Total number of counted follow-ups.
`Nombre de réponses`	CSV + XLSX	Integer	Total number of counted responses.
`Crédits dépensés`	CSV + XLSX	Integer	GetBill credits consumed by follow-ups.
`Score`	CSV + XLSX	Number	Debt repayment score; for a grouped row, the group’s average repayment score.
`SMS`	CSV + XLSX	Integer	Count of SMS interactions.
`Emails`	CSV + XLSX	Integer	Count of email interactions.
`Répondeurs`	CSV + XLSX	Integer	Calls for which an answering machine was detected.
`Messages vocaux VMS`	CSV + XLSX	Integer	Ringless voice messages sent through the VMS/RVM channel.
`WhatsApp`	CSV + XLSX	Integer	Count of WhatsApp interactions.
`Courriers`	CSV + XLSX	Integer	Count of postal letters.
`Appels`	CSV + XLSX	Integer	Count of calls.
`Score d'appel`	CSV only	Score out of 5	The same repayment score rendered out of 5; blank when unavailable.
`Statut d'appel`	CSV + XLSX	Text	Summary of call statuses.
`Détails des appels`	CSV + XLSX	Structured text	Available call dates, directions, durations, and summaries.
`Historique des statuts`	CSV + XLSX	Structured text	Chronological status changes.

Settlement origin and payment reconciliation

These seven columns separate online payments from settlements recorded outside online payments. An online payment may come from the portal or a direct link managed by GetBill: this origin does not distinguish those two journeys. All supported payment service providers (PSPs) are covered, including PayZen, Stripe, Adyen, and GoCardless. The dictionary retains the headers from the published French samples; generated exports use their configured language.

Field	Availability	Format	Meaning
`Origine du règlement`	CSV + XLSX	Text, origins separated by `+`	Online payment followed by the PSP, manual settlement, reimport, or settlement outside online payments followed by the accounting connector. Several origins may coexist. An undetermined origin indicates insufficient history; a refund to verify indicates a partial refund whose amount is unavailable. French samples use `Paiement en ligne`, `Manuel`, and `Réimport`.
`Montant encaissé en ligne (net des remboursements)`	CSV + XLSX	Decimal number or blank	Confirmed PSP payments less known refunds. Excludes test payments and offline settlements. Blank when a partial refund cannot be quantified. This amount is before commissions and fees.
`Montant soldé hors paiement en ligne (manuel / réimport / comptabilité)`	CSV + XLSX	Decimal number or blank	Amount settled outside PSP payments, based on recorded settlements or identifiable settlement actions: manual, reimport, or accounting. Blank if part of the settlement has an undetermined origin. This amount does not represent funds collected by GetBill.
`Dates des paiements PSP`	CSV + XLSX	`PSP: reference = YYYY-MM-DD HH:MM:SS`, entries separated by `;`	Known payment date for each transaction, in the export time zone. Marked as unknown when unavailable.
`Références des transactions PSP`	CSV + XLSX	`PSP: reference`, entries separated by `;`	Available references for reconciliation with the provider statement. Multiple identifiers for one transaction are separated by `/`.
`Auteur du solde manuel`	CSV + XLSX	Text, authors separated by `;`	Author name when available, otherwise their identifier or an unknown-author label. Blank when no manual action is identified.
`Encaisseur enregistré par transaction PSP (montant net)`	CSV + XLSX	`PSP: reference = company (ID identifier): amount currency`	Company recorded on each transaction and amount net of refunds, before fees. Multiple entries are separated by `;`. A missing collector is marked as unknown; an unquantified refund is marked for verification.

For example, a €108 debt paid €40 through PayZen and €68 recorded manually has origin Paiement en ligne PayZen + Manuel in French, online amount 40, and offline amount 68, assuming no refunds. Manuel describes settlement origin; the Repris manuel debt status describes manual takeover of collection and does not by itself prove settlement. Reimport includes a balance reduced to zero or a reference missing from a complete file when that origin is recorded. To prepare a remittance, reconcile PSP references, dates, and the recorded collector against provider statements. An online payment may have been collected by the creditor or an agent. Neither Montant récupéré, Relance ayant déclenché le paiement, nor Paiement associé relance is sufficient to determine funds to remit. These columns do not calculate the final remittance or contractual commission. Amounts cover the available history of exported debts, without automatically restricting payments to the statement month. In the Data sheet, debt amounts repeat for each follow-up: deduplicate by debt before summing them.

Disputes, payments, and installments

Field	Availability	Format	Meaning
`Litige`	CSV + XLSX	Structured text	Disputes applied to the debt, including state and date when available.
`Catégories de litige`	CSV + XLSX	Text list	Detected or applied dispute themes.
`Catégories d'objection`	CSV + XLSX	Text list	Detected objection themes.
`Accord de paiement`	CSV + XLSX	Structured text	Proposed, accepted, or generated payment arrangement.
`Relance ayant déclenché le paiement`	CSV + XLSX	Structured text	Follow-up directly associated with the payment when available; otherwise a best-effort attribution based on recent eligible interactions.
`Mois du plan`	CSV + XLSX	Integer	Planned payment-plan duration in months.
`Date de début du plan`	CSV + XLSX	`YYYY-MM-DD`	Payment-plan start date.
`Montant du premier paiement`	CSV + XLSX	Decimal number	Planned first payment.
`Échéances (total)`	CSV + XLSX	Integer	Total generated installments.
`Échéances (payées)`	CSV + XLSX	Integer	Paid installments.
`Échéances (en retard)`	CSV + XLSX	Integer	Unpaid installments whose due date has passed.
`Montant échéances payées`	CSV + XLSX	Decimal number	Sum of paid installments.
`Montant échéances en retard`	CSV + XLSX	Decimal number	Sum of overdue installments.
`Montant échéances restantes`	CSV + XLSX	Decimal number	Sum of installments remaining to be paid.
`Prochaine échéance (date)`	CSV + XLSX	`YYYY-MM-DD`	Date of the earliest eligible upcoming unpaid installment; blank when only overdue, paid, or cancelled installments remain.
`Prochaine échéance (montant)`	CSV + XLSX	Decimal number	Amount of that earliest eligible upcoming installment; blank under the same conditions.
`Détail des échéances`	CSV + XLSX	Structured text	Installment numbers, amounts, dates, and statuses.

XLSX follow-up details

These nine fields are populated on Créance subrows and corresponding Data rows. They are blank on a debt row with no follow-up.

Field	Availability	Format	Meaning
`Type relance`	XLSX only	Localized text	Follow-up channel or type.
`Direction relance`	XLSX only	Inbound or outbound	Interaction direction.
`Date relance`	XLSX only	`YYYY-MM-DD HH:MM`	Processing or call date in the export time zone.
`Statut relance`	XLSX only	Localized text	Delivery, processing, or result status for the follow-up.
`Durée relance`	XLSX only	Human-readable duration	Interaction duration when applicable.
`Résumé relance`	XLSX only	Text	Cleaned interaction summary.
`Coût crédits relance`	XLSX only	Number or structured text	Credits attributed to this follow-up.
`Litiges détectés relance`	XLSX only	Text list	Disputes originating from this interaction.
`Paiement associé relance`	XLSX only	Amount and date	Up to five successful payments attributed to this interaction.

The export may append client-specific columns from extra imported variables and configured collected fields. Their labels come from the client configuration and they are outside the 70/75 standard columns.

Exported follow-up statuses

Exports use localized labels, depending on the export language. Technical values below map them to the API; they do not replace labels in exported columns.

Debt status

Technical value	French label	English label
`status.default.pending`	En attente	Pending
`status.default.processing`	En traitement	Processing
`status.default.in_progress`	En cours	In progress
`status.default.settled`	Résolu	Settled
`status.default.partial`	Partiel	Partial
`status.default.paid`	Soldé	Paid
`status.default.on_hold`	En pause	On hold
`status.default.manual_takeover`	Repris manuel	Manual takeover
`status.default.invalid_phone`	Incorrect/bloqué	Invalid/blocked
`status.default.failed`	Échoué	Failed
`status.default.archived`	Archivé	Archived

Follow-up status

Technical value	French label	English label
`on_hold`	En attente	On hold
`in_progress`	En cours	In progress
`deal_found`	Accord trouvé	Deal found
`no_answer`	Messagerie	Voicemail
`deal_not_found`	Accord non trouvé	Deal not found
`bad_behavior`	Comportement injurieux	Abusive behavior
`sent`	Envoyé	Sent
`failed`	Appel échoué	Failed call
`scheduled`	Planifié	Scheduled
`delivered`	Livré	Delivered
`read`	Lu	Read
`received`	Reçu	Received
`cancelled`	Annulé	Cancelled
`email_invalid`	Email invalide	Invalid email
`email_complained`	Plainte spam	Spam complaint
`skipped_preference`	Ignoré (préférence)	Skipped (preference)
`skipped_optimization`	Action évitée	Action skipped

Payment plans

When a concrete payment schedule exists, Accord de paiement uses:

#1=100.00@2026-01-15 | #2=100.00@2026-02-15

Each installment follows #N=AMOUNT@YYYY-MM-DD:

#(\d+)=([\d.]+)@(\d{4}-\d{2}-\d{2})

If installments have not yet been generated, the column may contain a readable description. Dedicated duration, start, and amount columns remain authoritative.

Return to the overview

Review profiles and download templates.

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

Configure scheduled exports

Understand XLSX exports

Understand CSV exports

Understand column availability

Identification, debtor, and debt

Amounts, status, and activity

Settlement origin and payment reconciliation

Disputes, payments, and installments

XLSX follow-up details

Exported follow-up statuses

Debt status

Follow-up status

Payment plans

Return to the overview

​Configure scheduled exports

​Understand XLSX exports

​Understand CSV exports

​Understand column availability

​Identification, debtor, and debt

​Amounts, status, and activity

​Settlement origin and payment reconciliation

​Disputes, payments, and installments

​XLSX follow-up details

​Exported follow-up statuses

​Debt status

​Follow-up status

​Payment plans

Return to the overview

Configure scheduled exports

Understand XLSX exports

Understand CSV exports

Understand column availability

Identification, debtor, and debt

Amounts, status, and activity

Settlement origin and payment reconciliation

Disputes, payments, and installments

XLSX follow-up details

Exported follow-up statuses

Debt status

Follow-up status

Payment plans