Skip to main content

One-Time Bulk Update of Invoice Tags via CSV

Kolleno can assist with a one-time assignment of tags to invoices via CSV on request.

Kolleno Support avatar
Written by Kolleno Support
Updated this week

Overview

As a courtesy, the Kolleno team can assist with a one-time bulk assignment of tags to invoices. It usually happens during your onboarding.


Required Format

Your CSV file should contain the following columns:

Column

Description

invoice_ref

Invoice reference or other unique identifier (depending on your settings).

tag_name

The tag you want to assign to that invoice.

Example CSV:

invoice_ref,tag_name
INV001,urgent
INV002,reviewed
INV003,urgent
INV004,payment_plan

Notes:

  • Tags will be created automatically if they don’t exist.

  • Multiple rows can assign the same tag to different invoices.

  • Each row represents one invoice–tag relationship.


How It Works

  1. Invoice Matching
    Invoices are matched based on the selected identifier — you can choose from:

    1. ref = the reference visible to customers.

    2. id = Kolleno ID of the invoice.

    3. source_id = the ERP ID of the invoice.

  2. Tag Creation
    If a tag doesn’t exist, it will be created automatically with a default color.

  3. Tag Assignment
    New tags are added to existing invoice tags. Existing tags are never replaced or removed.

  4. CSV Validation
    The system checks that the CSV follows the required format before processing.


Sending the File

When sending the CSV to Kolleno Customer Support, please:

  • Confirm which field is the unique identifier (example: customer reference)

  • Ensure all users listed already exist in Kolleno

  • Provide the file with plenty of time in advance


Important Notes

  • This import is done manually by the Kolleno team. Please limit the number of requests.

  • Kolleno will aim to process the file as soon as possible, but no timing guarantees can be made.

  • Ensure the CSV file is UTF-8 encoded, uses commas as separators, and encloses values in double quotes (especially if values contain commas or special characters).

Did this answer your question?