Skip to main content

Importing Rate Cards from CSV

Import company and client rate cards from a CSV file, so you can set up or update many service rates at once.

Rate cards hold your standard service rates, so you don't have to type prices into every deal and budget. You can build them by hand, or import them from a CSV file when you have many services to add at once.

Importing works for your company rate card and for client-specific rate cards.

👉 To change prices on rate cards you already have, such as a yearly increase, see Updating Rate Cards Using Export and Import.

Download the Template

Go to Settings > Data import and click Download .csv templates.

Download the Rates .csv template.

Fill In the Template

Each row is one service on a rate card. The template has these columns:

Name

The name of the service.

Description

Optional. A description of the service.

Company

The client company, for a client-specific rate card. Leave it empty to add the service to your company rate card. If no company with this name exists, it’s created.

Rate Card

The name of the rate card. If a rate card with this name already exists, the services are added to it.

Unit

hour, day, or piece.

Estimated Hours

Optional. How many hours you estimate the service takes.

Quantity

How many hours, days, or pieces the service includes.

Rate

The price for one hour, day, or piece.

Currency

The currency code, for example USD, EUR, or AUD.

Service Type

The service type the service belongs to.

Billing Type

Time and materials (or Actuals), Fixed, or Non billable. See Billing Types.

Fixed Cap Enabled

Yes to set a fixed cap on a Time and materials service, so the client is never invoiced more than its total. Otherwise No or empty.

Booking Tracking Enabled

Yes to let people be booked on this service in the Resource Planner. Otherwise No or empty.

Expense Tracking Enabled

Yes to let people log expenses on this service. Otherwise No or empty. Only works when Unit is piece.

Time Tracking Enabled

Yes to let people track time on this service. Otherwise No or empty.

Markup

Optional, a percentage, with or without the % sign.

Discount

Optional, a percentage, with or without the % sign.

📌 Don't delete any columns, even ones you don't need. Leave them empty instead, or the import won't work.

Upload the File

Drag your file into the upload box on Settings > Data import, or click the box to choose it.

Productive checks the file for errors and marks each problem with ⚠️. Hover over the symbol to see what's wrong.

Fix errors right in the import window, so you don't need to edit the CSV and upload it again. Then click Check for errors.

When there are no errors left, click Proceed to import, then Import.

Your imported rate cards are now in Settings > Rate cards, where you can review and edit them.

Did this answer your question?