---
title: "Implementation > Import Price Quotes"
canonical: "https://technology.bytangram.com/space/TGKB/1073250353/Implementation%20%3E%20Import%20Price%20Quotes"
format: markdown
---
When first setting up your WorkBook system, a starting set of data can be imported, including price quotes. To import data successfully it is important to understand the data structures and the format required in the import data sheet.
Things to note:
- Data is imported once, so it is important to ensure accuracy and consistency prior to uploading.
- Not all fields are required at import, optional fields can be added to the system manually at a later date when/as required.
---
## IMPORT PRICE QUOTES
> ✅ Download the Price Quotes import file below.
> Macro (attachments)
| **COLUMN HEADER** | **FIELD DESCRIPTION** | **FORMAT** | **REQUIRED** |
| --- | --- | --- | --- |
| **Price number** | Number of the price quote being referenced.
> 📝 If the Price quote has multiple lines, using the same Price Number on those price quote lines. | Number | Yes |
| **Job no** | The WorkBook job number the price quote belongs to.
> 📝 If the Price quote has multiple lines, using the same Job No on those price quote lines. | Number | Yes |
| **Activity** | The activity number that the price quote line is tied to. Each price quote line can only have 1 activity.
Activities are created and managed via the **settings** module> **price lists & activities** > **activities** | Number | Yes |
| **Activity text** | The name of the activity | Text | No |
| **Phase no** | The phase number.
> 📝 If the Price quote has multiple lines in 1 phase, using the same Phase No on those price quote lines. | Number | Yes |
| **Phase name** | The phase name.
> 📝 If the Price quote has multiple lines in 1 phase, using the same Phase Name on those price quote lines. | Text | Yes |
| **Line number** | The number of the line being referenced | Number | Yes |
| **PriceQuoteName** | Specify the name of the price quote.
> 📝 If the Price quote has multiple lines, using the same Price Quote Name on those price quote lines. | Text | Yes |
| **Hours** | The amount of hours that has been quoted to the client | Number | No |
| **Hourly Rate** | The billable hourly sales rate for each hour | Number | No |
| **Cost Rate** | Total internal cost to the agency for each activity line | Number | No |
| **Material Sale** | The sales price of materials | Number | No |
| **Material Cost** | The total cost of materials | Number | No |
| **Amount** | The total amount inc. material cost and total billable amount (Hours x Hourly rate).
> 📝 If the Price quote has multiple lines, this must be used as Line amount. The total amount of the whole Price quote will be calculated automatically by the system. | Number | No |
| **Profit margin** | The profit as a percentage on purchases | Number | No |
| **Status** | The status of the quote:
10 = Under preparation
20 = For approval
40 = Approved internally
50 = Approved externally
> 📝 If the Price quote has multiple lines, using the same status on those price quote lines. | Number
> ⚠️ Can only be 10, 20, 40 or 50 | Yes |
| **Purchases** | The purchase cost of an activity
> 📝 Does not need to be completed if hours and hourly rate or material sale is applied | Number | No |
| **Currency** | The currency code applied to the price quote e.g. EUR, AUD, SGD, USD, GBP etc.
> 📝 Must be the same for all lines on the price quote - only one currency per price quote can be chosen | Text | Yes |
| **Currency rate** | The conversion rate from company currency | Number | No |
| **Resource** | ID of the employee that the price quote line is tied to. Each price quote line can only have 1 employee. Use the same number used in the [employee import](https://tangram.atlassian.net/wiki/spaces/TGKB/pages/613056585)
> 📝 This can be found in the Ref Key field in **employee settings** if you no longer have the import file.
> 📝
> 📝 WorkBook Resource ID (WB Employee ID) can also be used in case the employee is created manually in WorkBook.
> 📝
> 📝 Example: if the WB employee ID = 578, then the value in this column will be WB#578.
 | Text | No |
---
### Related articles
> Macro (contentbylabel)