...
Note, that activities and price lists are not imported, your consultant will create these in your system according to the information provided in the spreadsheet below.
...
ACTIVITIES & PRICE LISTS
Tip |
---|
Download the activities & price list file here. Please delete the example rows highlighted in yellow. |
...
COLUMN HEADER | FIELD DESCRIPTION | FORMAT | REQUIRED | |
---|---|---|---|---|
Activity Type | There are three types of activities: Time: Employees are assigned a single default activity for time entry, i.e. Designer | Text Time | Yes | |
Purchases: Products or services that you purchase and on-sell to the client, i.e. printing | Text Purchases | Yes | ||
Materials: Products or services that you have purchased up-front and want to on-sell a portion of the total cost to the client, i.e. stock images
| Text Materials | If relevant | ||
Activity Name | Give each activity a name that is meaningful in your business. Users will select activities and add to price quotes, invoices and purchase orders. Streamline activities where possible, for example Creative Services Manager and Creative Services Lead is the same role, price per client and person, this should be one activity. | Text E.g. Account Executive | Yes | |
Activity Phase | Used to group activities together for reporting. For example, activities Account Executive, Account Manager, Senior Account Manager and Group Account Director could all be grouped into activity phase ‘Client Services’. | Text E.g. Creative, Finance, Client Services, Development etc | Yes | |
Cost | Time: Average cost per hour to the agency, usually a blended rate. | Number | Yes | |
Purchases: Leave blank | Number | No | ||
Materials: Leave blank | Number | No | ||
Default Rate Card | Row 1: This is your default rate card, give it a name that users will easily recognise when selecting (this is how it will appear throughout the system). | Text E.g. Default Rate Card | Yes | |
Row 2: Confirm the currency of the rate card. | Text E.g. AUD, USD, NZD, EUR, GBP etc | Yes | ||
Rows 3+: The sales rate you are charging the client for each activity on your default rate card.
| Number E.g. 250.00 | Yes | ||
Additional Rate Cards | Row 1: Give each additional price list/rate card a unique name that users will easily recognise when selecting (this is how it will appear throughout the system). You can have as many price lists as required. Please add as many columns as needed. | Text E.g. Coca Cola Rate Card; Discounted Rate Card; USD Rate Card etc | No | |
Row 2: Confirm the currency of the rate card. | Text E.g. AUD, USD, NZD, EUR, GBP etc | No | ||
Rows 3+: The sales rate you are charging the client for each activity on the rate card.
| Number E.g. 220.00 | No |
...
Related articles
Filter by label (Content by label) | ||||||
---|---|---|---|---|---|---|
|
...