[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
| Column | Value / format | Required | Notes |
|---|---|---|---|
Issuer | Value given by Brinta | Yes | Identifies which of your companies (and prefix) issues the document. |
Invoice External Id | Your own ID | Recommended | Your reference for the invoice. |
Invoice Date | yyyy-mm-dd | Yes | Issue date. |
Invoice Due Date | yyyy-mm-dd | No | |
Invoice Document Type | invoice | Yes | Lowercase. |
Invoice Type | debit | Yes | |
Invoice Currency | COP or USD | Yes | |
Invoice Exchange Rate | Number | When currency is not COP | Exchange rate to COP. |
Invoice Payment Method Type | cash, credit card, debit card, bank transfer, digital wallet | No | How the buyer pays. |
Invoice Purchase Order Number | Text | No | Purchase order related to the invoice. |
additionalInfo | Free text | No | Observations printed on the invoice. |
Buyer
| Column | Value / format | Required | Notes |
|---|---|---|---|
Buyer External ID | Your own ID | No | Your reference for the buyer. |
Buyer Type | business or person | Yes | business for companies, person for individuals. |
Buyer Tax Registration Type | NIT, CC, tax_id | Yes | NIT for companies, CC for citizenship cards, tax_id for buyers abroad. |
Buyer Tax Registration Number | Tax ID | Yes | For a NIT, include the verification digit (DV) at the end. |
Buyer Name | Trade name | No | |
Buyer Legal Name | Legal name | Yes | As registered at the RUT. |
Buyer Country | ISO code | Yes | CO for buyers in Colombia. |
Buyer State | ISO 3166-2 code | No | Example: CO-DC. See department codes. |
Buyer City | City | No | Example: Bogotá. |
Buyer Address Line | Street and number | No | |
Buyer Postal Code | 6 digits | No | |
Buyer Email | No | The invoice is sent to this address. |
Item and VAT
| Column | Value / format | Required | Notes |
|---|---|---|---|
Item Name | Text | Yes | Description of the goods or service. |
Item Category | Text | No | Your category for the item. |
Item Quantity | Number | Yes | Use 1 for services or a single unit. |
Unit Amount | Number | When quantity > 1 | Price per unit before taxes. |
Item Discount | Number | No | Discount amount on the line. |
Item Amount | Number | Yes | Line amount before taxes. |
VAT Rate | 0.19, 0.05 or 0 | Yes | 0.19 general rate, 0.05 reduced rate, 0 exempt or excluded. |
VAT Amount | Number | Yes | Item Amount × VAT Rate. |
Withholdings (only when they apply)
| Column | Value / format | Required | Notes |
|---|---|---|---|
ReteIVA Rate | Decimal | No | VAT withholding rate, e.g. 0.15. Leave empty when there is no ReteIVA. |
ReteIVA Amount | Number | With ReteIVA Rate | VAT withholding amount. |
ReteICA Rate | Decimal | No | ICA withholding rate as a decimal, e.g. 0.00966 for 9.66 per thousand. Leave empty when there is no ReteICA. |
ReteICA Amount | Number | With ReteICA Rate | ICA withholding amount. |
Leave Reason, Original Invoice BRINTA Id, Original Item Id and Without Invoice empty: they are only for credit notes.
Example row
| Column | Value |
|---|---|
Issuer | (your issuer value) |
Invoice External Id | INV-2026-0001 |
Invoice Currency | COP |
Invoice Date | 2026-03-31 |
Invoice Due Date | 2026-04-30 |
Invoice Document Type | invoice |
Invoice Type | debit |
Buyer Type | business |
Buyer Tax Registration Type | NIT |
Buyer Tax Registration Number | 9017840303 |
Buyer Legal Name | CLIENTE EJEMPLO S A S |
Buyer Country | CO |
Buyer State | CO-DC |
Buyer City | Bogotá |
Buyer Email | [email protected] |
Item Name | Payment processing services - March 2026 |
Item Quantity | 1 |
Item Amount | 1000000 |
VAT Rate | 0.19 |
VAT Amount | 190000 |
ReteIVA Rate | 0.15 |
ReteIVA Amount | 28500 |
Things to check before uploading
- The NIT includes the verification digit.
VAT AmountequalsItem Amount×VAT Rate.- Withholding rates are decimals and each one has its amount.
Updated about 6 hours ago
Did this page help you?
