[CO] Bulk Upload Manual

This manual explains how to issue electronic documents in Colombia by uploading a file with the Brinta bulk template. It covers the steps in the dashboard, the general rules that apply to every row, and links to one guide per document type.

Supported document types

Document	`Invoice Document Type`	`Invoice Type`	Guide
Electronic invoice (Factura electrónica de venta)	`invoice`	`debit`	Invoice
Support document (Documento soporte)	`purchase invoice`	`support_document`	Support document
Credit note	`credit note`	`credit`	Credit notes

1. Steps to upload a file

Go to Invoicing → Outgoing → Bulk Uploads. In the left menu, expand Invoicing, then Outgoing, and click Bulk Uploads.
Click "Create Invoice". A window opens to choose the creation method.
Select "Bulk Upload". Choose the option on the left (cloud icon with an arrow).
Select the adapter. In Select adapter, choose the Colombia adapter of the company that issues the documents and click Next.
Upload the file. Upload the completed template as .xlsx or .csv. You can follow the result of each document in the upload detail.

2. Template

Request the Colombia template from your Account Executive (AE) and fill it in following the format of each column.

The template has two tabs:

Template CO: the columns to fill in. Red headers are mandatory.
Guide - Reference: a short description of each column.

❗️
Clean the template before uploading
The Template CO tab comes with an example row, sample values and a color legend. Delete all of it before you add your own rows, so the file only contains your documents.

3. Rules for every row

Topic	Rule	Example
One row, one document	Each row is one document with one item.
Header names	Keep the column headers exactly as in the template. Do not rename, translate or merge them.	`Buyer Legal Name`
Fixed values	Always lowercase.	`invoice`, `credit note`, `business`
Dates	`yyyy-mm-dd`. Format the cell as text so Excel does not change it.	`2026-03-31`
Amounts	Numeric cells, dot as decimal separator, no thousands separator.	`1000000.50`
Rates	Decimal, not a percentage.	`0.19` for 19%
NIT	Number with its verification digit (DV) at the end.	`9017840303`
Country	ISO 3166-1 alpha-2 code.	`CO`
State	ISO 3166-2 code of the department. See the table below.	`CO-DC`
Postal code	6 digits.	`110111`
Currency	ISO 4217 code.	`COP`, `USD`
Issuer	The issuer value given to you during onboarding. It identifies which of your companies issues the document.

Colombia department codes

Department	Code	Department	Code
Amazonas	`CO-AMA`	La Guajira	`CO-LAG`
Antioquia	`CO-ANT`	Magdalena	`CO-MAG`
Arauca	`CO-ARA`	Meta	`CO-MET`
Atlántico	`CO-ATL`	Nariño	`CO-NAR`
Bogotá D.C.	`CO-DC`	Norte de Santander	`CO-NSA`
Bolívar	`CO-BOL`	Putumayo	`CO-PUT`
Boyacá	`CO-BOY`	Quindío	`CO-QUI`
Caldas	`CO-CAL`	Risaralda	`CO-RIS`
Caquetá	`CO-CAQ`	San Andrés	`CO-SAP`
Casanare	`CO-CAS`	Santander	`CO-SAN`
Cauca	`CO-CAU`	Sucre	`CO-SUC`
Cesar	`CO-CES`	Tolima	`CO-TOL`
Chocó	`CO-CHO`	Valle del Cauca	`CO-VAC`
Córdoba	`CO-COR`	Vaupés	`CO-VAU`
Cundinamarca	`CO-CUN`	Vichada	`CO-VID`
Guainía	`CO-GUA`	Huila	`CO-HUI`
Guaviare	`CO-GUV`

4. Common errors

Error	Cause	How to fix it
Value not accepted for a fixed field	`Invoice`, `Credit Note`, `Business` with capital letters, or no dropdown value.	Use lowercase, exactly as listed.
`Invoice Type` does not match the document	For example `purchase invoice` with `debit`.	`invoice` → `debit`, `purchase invoice` → `support_document`, `credit note` → `credit`.
Wrong NIT	NIT without its verification digit.	Add the DV at the end.
Wrong amount	`1.000.000,50` instead of `1000000.50`, or the cell is text.	Dot for decimals, no thousands separator, numeric cell.
Wrong withholding rate	ReteICA entered per thousand (`9.66`) instead of as a decimal.	Use the decimal: `0.00966`.
Wrong date	Date in `dd/mm/yyyy` or `mm/dd/yyyy`.	Use `yyyy-mm-dd` and format the cell as text.

5. Checking the result

Go to Invoicing → Outgoing → Bulk Uploads and open the upload with the eye icon.
Download the report. The last columns show the error message for each failed row.
Fix only the failed rows and upload them again in a new file.

For questions about this process, contact the Brinta team.