[CO] Bulk Upload - Electronic invoice

Use an electronic invoice for every sale of goods or services. For the general upload steps and format rules, see the Colombia bulk upload manual.

Each row in the file is one invoice with one item.

Column by column

Document

ColumnValue / formatRequiredNotes
IssuerValue given by BrintaYesIdentifies which of your companies (and prefix) issues the document.
Invoice External IdYour own IDRecommendedYour reference for the invoice.
Invoice Dateyyyy-mm-ddYesIssue date.
Invoice Due Dateyyyy-mm-ddNo
Invoice Document TypeinvoiceYesLowercase.
Invoice TypedebitYes
Invoice CurrencyCOP or USDYes
Invoice Exchange RateNumberWhen currency is not COPExchange rate to COP.
Invoice Payment Method Typecash, credit card, debit card, bank transfer, digital walletNoHow the buyer pays.
Invoice Purchase Order NumberTextNoPurchase order related to the invoice.
additionalInfoFree textNoObservations printed on the invoice.

Buyer

ColumnValue / formatRequiredNotes
Buyer External IDYour own IDNoYour reference for the buyer.
Buyer Typebusiness or personYesbusiness for companies, person for individuals.
Buyer Tax Registration TypeNIT, CC, tax_idYesNIT for companies, CC for citizenship cards, tax_id for buyers abroad.
Buyer Tax Registration NumberTax IDYesFor a NIT, include the verification digit (DV) at the end.
Buyer NameTrade nameNo
Buyer Legal NameLegal nameYesAs registered at the RUT.
Buyer CountryISO codeYesCO for buyers in Colombia.
Buyer StateISO 3166-2 codeNoExample: CO-DC. See department codes.
Buyer CityCityNoExample: Bogotá.
Buyer Address LineStreet and numberNo
Buyer Postal Code6 digitsNo
Buyer EmailEmailNoThe invoice is sent to this address.

Item and VAT

ColumnValue / formatRequiredNotes
Item NameTextYesDescription of the goods or service.
Item CategoryTextNoYour category for the item.
Item QuantityNumberYesUse 1 for services or a single unit.
Unit AmountNumberWhen quantity > 1Price per unit before taxes.
Item DiscountNumberNoDiscount amount on the line.
Item AmountNumberYesLine amount before taxes.
VAT Rate0.19, 0.05 or 0Yes0.19 general rate, 0.05 reduced rate, 0 exempt or excluded.
VAT AmountNumberYesItem Amount × VAT Rate.

Withholdings (only when they apply)

ColumnValue / formatRequiredNotes
ReteIVA RateDecimalNoVAT withholding rate, e.g. 0.15. Leave empty when there is no ReteIVA.
ReteIVA AmountNumberWith ReteIVA RateVAT withholding amount.
ReteICA RateDecimalNoICA withholding rate as a decimal, e.g. 0.00966 for 9.66 per thousand. Leave empty when there is no ReteICA.
ReteICA AmountNumberWith ReteICA RateICA withholding amount.

Leave Reason, Original Invoice BRINTA Id, Original Item Id and Without Invoice empty: they are only for credit notes.

Example row

ColumnValue
Issuer(your issuer value)
Invoice External IdINV-2026-0001
Invoice CurrencyCOP
Invoice Date2026-03-31
Invoice Due Date2026-04-30
Invoice Document Typeinvoice
Invoice Typedebit
Buyer Typebusiness
Buyer Tax Registration TypeNIT
Buyer Tax Registration Number9017840303
Buyer Legal NameCLIENTE EJEMPLO S A S
Buyer CountryCO
Buyer StateCO-DC
Buyer CityBogotá
Buyer Email[email protected]
Item NamePayment processing services - March 2026
Item Quantity1
Item Amount1000000
VAT Rate0.19
VAT Amount190000
ReteIVA Rate0.15
ReteIVA Amount28500

Things to check before uploading

  • The NIT includes the verification digit.
  • VAT Amount equals Item Amount × VAT Rate.
  • Withholding rates are decimals and each one has its amount.

Did this page help you?