Here are the columns we read. All of them.
TrueDue takes a CSV or Excel export of your open items and works out which column is which. This is the whole vocabulary it matches against — generated from the code that does the matching, so it cannot drift from what the product actually does.
Written the way these systems write them
The wordings below are taken from real exports out of QuickBooks Online and Desktop (A/R Aging Detail), Xero, NetSuite, Microsoft Dynamics 365, Sage, SAP (FBL5N), DATEV and Lexware, in English and German. Your export does not have to match exactly — matching is scored, not literal, and you confirm the result before anything is imported.
Required
Without these four a file cannot be reconciled, and TrueDue will say so rather than guess.
Invoice number
34 recognized headings
- beleg
- beleg nr
- beleg-nr
- belegfeld 1
- belegnr
- belegnummer
- bill no
- bill number
- doc no
- doc number
- document no
- document nr
- document number
- dokumentnummer
- inv no
- invoice
- invoice #
- invoice no
- invoice num
- invoice number
- invoice ref
- num
- our ref
- re-nr
- rechnung
- rechnung nr
- rechnungs-nr
- rechnungsnr
- rechnungsnummer
- rechnungsnummer extern
- ref
- reference
- referenz
- voucher no
Customer name
35 recognized headings
- account name
- beschriftung
- bill to
- bill to name
- company
- company name
- customer
- customer full name
- customer name
- debitor
- debitor name
- debitorenname
- debitorname
- debtor
- debtor name
- empfaenger
- empfänger
- firma
- firmenbezeichnung
- firmenname
- kontakt
- kontenbeschriftung
- kontobeschriftung
- kontobezeichnung
- kunde
- kunden name
- kundenbezeichnung
- kundenname
- kundenname firma
- name
- name 1
- rechnungsempfaenger
- rechnungsempfänger
- sold to
- sold to name
Due date
27 recognized headings
- date due
- due
- due date
- due on
- duedate
- faellig
- faellig am
- faellig zum
- faelligkeit
- faelligkeitsdatum
- fällig
- fällig am
- fällig zum
- fälligkeit
- fälligkeitsdatum
- fälligkeitstermin
- maturity
- maturity date
- net due
- net due date
- netto fällig
- nettofaelligkeit
- nettofälligkeit
- valuta
- valutadatum
- zahlbar bis
- zahlungsfrist bis
Outstanding amount
36 recognized headings
- amount
- amount due
- amount open
- amount remaining
- amountdue
- balance
- balance due
- betrag
- betrag offen
- due amount
- invoice amount due
- noch offen
- offen
- offen brutto
- offene posten
- offener betrag
- offener betrag brutto
- offener posten
- offener saldo
- op betrag
- op-betrag
- op-saldo
- open
- open amount
- open balance
- outstanding
- outstanding amount
- remaining
- remaining amount
- restbetrag
- restforderung
- restsaldo
- saldo
- summe
- unpaid amount
- zahlbetrag offen
Recognized, not required
If your export carries these, TrueDue uses them. If not, nothing breaks.
Customer number
32 recognized headings
- a/c
- account
- account code
- account no
- account number
- acct
- customer account
- customer code
- customer id
- customer no
- customer number
- debitor nr
- debitorenkonto
- debitorennr
- debitorennummer
- debitornr
- debitornummer
- debtor number
- kd nr
- kdnr
- kontakt nr
- kontaktnummer
- konto
- konto nr
- kontonr
- kontonummer
- kto nr
- ktonr
- kunden nr
- kundenkonto
- kundennr
- kundennummer
Invoice date
18 recognized headings
- beleg datum
- belegdatum
- bill date
- buchungsdatum
- date
- date of invoice
- datum
- document date
- dokumentdatum
- erfassungsdatum
- invoice date
- issue
- issue date
- issued
- posting date
- rechnung datum
- rechnungsdatum
- transaction date
Currency
16 recognized headings
- belegwaehrung
- belegwährung
- cur
- curr
- currency
- currency code
- document currency
- hauswaehrung
- hauswährung
- local currency
- transaction currency
- waehrung
- waehrungscode
- währung
- währungscode
- whg
Invoice amount
25 recognized headings
- amount
- betrag
- betrag (brutto)
- betrag brutto
- brutto
- brutto betrag
- bruttobetrag
- bruttosumme
- gesamt brutto
- gesamtbetrag
- gross
- gross amount
- invoice amount
- invoice total
- invoiced amount
- original
- original amount
- originalbetrag
- originalwert
- rechnungsbetrag
- rechnungsbetrag brutto
- rechnungssumme
- summe
- total
- total amount
Status in your system
6 recognized headings
- belegstatus
- invoice status
- payment status
- status
- zahlstatus
- zahlungsstatus
Your reference
18 recognized headings
- external id
- externe id
- guid
- id
- internal id
- interne id
- lfd nr
- line id
- record id
- ref
- reference
- referenz
- source id
- trans no
- transaction id
- transaction no
- transaktionsnummer
- uuid
Contact name
5 recognized headings
- ansprechpartner
- contact
- contact name
- contact person
- kontaktperson
Contact email
7 recognized headings
- contact email
- e-mail-adresse
- email address
- mailadresse
Customer type (company or private person)
17 recognized headings
- b2b b2c
- b2b/b2c
- b2c/b2b
- client type
- customer category
- customer type
- debitorart
- debitorenart
- geschäftskunde/privatkunde
- gewerblich/privat
- kundenart
- kundenkategorie
- kundentyp
- personenart
- privat oder gewerblich
- privat/gewerblich
- privatkunde/geschäftskunde
Customer country
18 recognized headings
- billing country
- country
- country code
- country/region
- customer country
- iso country
- kundenland
- laendercode
- laenderkennzeichen
- laenderkuerzel
- land
- ländercode
- länderkennzeichen
- länderkürzel
- lkz
- nation
- rechnungsland
- staat
Start from the template
A file with every column above and three invented example rows. Fill it from any system that can export a spreadsheet — or use it to check that your export has what it needs.
The example companies and addresses are invented. Delete those rows before importing.
Connect the mailbox
TrueDue sends from one dedicated collections mailbox of yours and reads the replies that come back to it. Available today is the connection over IMAP/SMTP; the direct connections for Microsoft 365 and Google Workspace are set up on request.
Microsoft 365
Outlook · Exchange Online — direct connection on request
What your IT needs to do
- Once it is set up for you: an administrator grants admin consent once for two Microsoft Graph application permissions. No password is exchanged.
- Recommended: an Exchange application access policy that limits these permissions to the collections mailbox. Without it, Microsoft applies them tenant-wide.
Application permissions
Mail.SendMail.ReadWrite
On request: please write to us before you order. Exchange Online does not accept IMAP/SMTP with a password, so a Microsoft 365 mailbox cannot be connected the other way today.
Google Workspace
Gmail — direct connection on request
What your IT needs to do
- Available today: connect the mailbox over IMAP/SMTP with an app password, if your Workspace admin allows it (see “Any other provider”).
- Direct connection, once it is set up for you: a Workspace super admin authorizes the TrueDue client ID (shown in TrueDue) once under Security → Access and data control → API controls → Domain-wide delegation. No password is exchanged.
Exactly these two scopes
https://www.googleapis.com/auth/gmail.sendhttps://www.googleapis.com/auth/gmail.modify
Google has no way to limit domain-wide delegation to one mailbox, so the authorization technically covers your whole domain within those two scopes. TrueDue uses the Google mailboxes stored for your organization and selects the corresponding address for each operation. Depending on the plan, multiple mailboxes are available; this selection does not narrow Google’s technically domain-wide authorization. Deleting the client ID entry revokes it.
Any other provider (IMAP/SMTP)
Available today — IONOS, Strato, all-inkl, Hetzner, mailbox.org, Exchange Server on-premises …
What your IT needs to do
- IMAP and SMTP server with port, from your provider's documentation. TLS is required; unencrypted connections are refused.
- The mailbox user name and preferably an app password rather than the mailbox password. It is stored encrypted and never shown again.
- To revoke access, delete or change that app password at your provider.
In every case, your customers see your address and replies land in your mailbox. With Google Workspace and IMAP/SMTP the inbox is checked at regular intervals for new replies.
What it will not do
- It will not guess a year. A DATEV date with a day and a month but no year is refused, never filed under an assumed year.
- It will not expand a number Excel has mangled into scientific notation. Expanding it would invent a confident, wrong invoice number that then goes out on a reminder.
- It will not sum two lines that look like the same invoice. Summing them would be inventing a figure, which is the one thing an import must never do.
- It will not accept a status it does not recognize. A status is either one we curated or it is unknown; there is no third, guessed option.
- It will not silently change a currency on an existing invoice.
Rows it cannot read are quarantined and shown to you, never applied. A file with more than half its rows malformed is refused outright.
Try it with your own file
Explore the product views and discuss with us how your export will be imported.
View the product