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.







