Adding (and Managing) Work Codes

CONVENTIONS

QuickTIPs (and Links) are highlighted in blue.

Permission-based items are highlighted in red.

System navigation is italicized.

 

ADDING (AND MANAGING) WORK CODES

Work Codes, by their very nature, are somewhat complicated. CurrentTrack® recommends breaking the work of your agency down into blended Categories with easy-to-understand abbreviations and up-to-date hourly rates. For example:

TIP: If Employees bill at different hourly rates, create separate Work Codes for each (e.g. Tom = 100.00 and Allison = 125.00). When they record time, they can do so under their own Codes. The Rates associated with each will only be displayed within the Production Estimate form and [job] Financial Report, not within the Time Sheet drop-down menu.

Other Work Codes to consider are Principal, Account Planning, Art Direction, Production, Project Management, Estimating, Research, Strategic Planning, SEO/SEM Facilitation, and Web Content Development. The number of Codes included in CurrentTrack depends upon how detailed your agency is in its time tracking. An unlimited number of Categories and Work Codes can be entered. They flow through CurrentTrack, enabling some of its most useful features such as the Production Estimate, so take care to enter and edit them correctly.

 

ADDING A WORK CODE

To create a Work Code, go to Admin — System Administration — Manage Work Codes.

A Work Code must be filed beneath a parent Work Category. If the applicable Work Category already exists (e.g. Account Service), simply click on its name and then Add Work Code. If the parent Work Category does not yet exist, click Add Work Category. Next, enter the Name and Rate of the Category (e.g. Account Service at a Rate of 150.00); click Submit.

Next, create a Work Code beneath the new Category by going to Work Category (name) — Add Work Code.

Enter a Name (e.g. Account Service), Code (e.g. AS) and Rate (e.g. 150.00). Don’t worry about the length of the Name. The field is unlimited and CurrentTrack will automatically create a Key at the bottom of the edit Time Sheet screen. As elsewhere in CurrentTrack, avoid using comma + number combinations (e.g. 1,000.00) in the Rate field.

Next, determine where you’d like the Code to appear within CurrentTrack. If you’d like it to appear in the Time Sheet Code drop-down menu, for example, check the box beneath Use in Time Sheets. If you’d like it to appear in your Production Estimate form, check the box beneath Use in Production Estimates. If the Code will be used in the Production Estimate form, check the corresponding boxes beneath Requires Qty, Can be Outsourced, Outsourced by Default, Can be Taxed, and Can be Marked Up; click Submit.

TIP: A good rule of thumb when creating Production Estimate Work Codes is, if you’ve assigned it a Qty. field, it’ll also need an Outsourced box. The equation CurrentTrack will use is as follows: Qty. x Outsourced (yes) x Cost = Net Cost + Tax and/or Markup = Subtotal.

Any number of Work Codes can be added beneath a Work Category. For example:

TIP: If you’re adding a Work Code, and it’s typically freelanced, assign both Qty. and Outsourced boxes. You can then enter the number of Hours spent on the Task (e.g. Copywriting) in its Qty. field (e.g. 3 [Hours]). If the Task is done in-house, no Qty. or Outsourced boxes are necessary. Simply enter the number in the Hours/Cost field (e.g. 3 [Hours of Copywriting]).

CHANGING A WORK CODE RATE

In order to change a Work Code Rate (e.g. Account Service from 150.00 to 200.00), you’ll need to first create a new Work Code that reflects the change(s) by going to Work Category (name) — Add Work Code.

Next, deactivate the old Work Code by going to Work Category — [click] Name. Locate the desired Work Code line and un-check the boxes beneath Use in Time Sheet and Use In Production Estimate, as well as any other check-marked criteria; Submit.

Existing Rates cannot simply be overwritten. You wouldn’t want to change the dollar figures on a Production Estimate you’d already given to the Client or on a Time Sheet that had already been recorded, for example.

ARCHIVING A WORK CODE

To archive a Work Code, go to Admin — System Administration — I Want To: Manage Work Codes — [click on] Work Category [Name]. Locate the desired Work Code line and un-check the boxes beneath Use in Time Sheet and Use In Production Estimate, as well as any other check-marked criteria; Submit. 

SCENARIO

Which Work Codes do you recommend be included in the Production Estimate form?

We recommend including the following Work Codes in your form. These items have been listed under the corresponding Work Categories that are typically used in an advertising agency. It’s entirely up to you, of course, as to which Categories and Codes you ultimately incorporate into your system.

Account Service (Code: AS)(Rate: $130.00/hr.)       
ItemQty.OutsourcedHours/CostNet CostTaxMarkupSubtotal
Account Coordinator Time  XX  X
Account Executive Time  XX  X
Food XXXXXX
Lodging XXXXXX
MileageXXXX XX
Miscellaneous Expenses XXXXXX
Parking XXX XX
PR Coordination  XX  X
PR Planning  XX  X
PR Supervision  XX  X
Travel Time  XX  X
        
Administration (Code: A)(Rate: $100.00/hr.)       
Item
Qty.
Outsourced
Hours/Cost
Net Cost
Tax
Markup
Subtotal
Catering XXXXXX
Delivery Charges XXX XX
Entertainment XXXXXX
Legal Services XXX XX
Miscellaneous Expenses XXXXXX
PostageXXXX  X
Printing Estimation  XX  X
Printing Supervision  XX  X
Project Research  XX  X
Proofreading  XX  X
Rush Charges XXX  X
Systems Support XXX  X
Telephone Charges XXX XX
        
Creative (Code: C)(Rate: $150.00/hr.)       
Item
Qty.
Outsourced
Hours/Cost
Net Cost
Tax
Markup
Subtotal
3-D Animation XXX XX
Agency Fees  XX XX
Art Direction  XX  X
Artwork Disk(s)XXXXXXX
Audio XXXXXX
Broadcast Director  XX  X
B/W LasersXXXXXXX
Camera/Crew XXX XX
Casting XXX XX
Color OutputsXXXXXXX
Concept Development  XX  X
CopywritingXXXX XX
Creative Direction  XX  X
Film Stock XXXXXX
Graphics XXXXXX
Grip XXX XX
Illustration XXX XX
Lights XXXXXX
Location Fees XXXXXX
Location Shoot Time XXX  X
Make-up XXX XX
Master Cost XXXXXX
Miscellaneous Art Expenses XXXXXX
Miscellaneous Broadcast Expenses XXXXXX
Miscellaneous PR Expenses XXXXXX
Music XXXXXX
Photography XXXXXX
Photography Director XXX  X
Press Clipping  XX  X
Production Company XXXXXX
Product Styling XXXXXX
Props XXXXXX
Retouching  XX  X
Rights/Fees XXX XX
ScansXXXXXXX
Set Design/Construction XXX  X
Stock Photos XXXXXX
Sytlist XXX XX
Talent XXX XX
Type Formatting  XX  X
Velox(es)XXXXXXX
Video Stock XXXXXX
Voiceover(s) XXXXXX
Wardrobe XXXXXX
        
Digital (Code: D)(Rate: $150.00/hr.)       
Item
Qty.
Outsourced
Hours/Cost
Net Cost
Tax
Markup
Subtotal
Audio DubsXXXXXXX
Audio Mix XXX  X
CD DubsXXXXXXX
CD Packaging  XX  X
Film Transfer/Processing XXXXXX
HTML Tweaking  XX  X
Interactive CD Design  XX  X
Internet Planning/Design  XX  X
Internet Programming/Debugging XXX XX
Miscellaneous Digital Expenses XXXXXX
Motion Design/FX/Compositing XXX  X
Offline Video Editing XXX  X
Online Video Editing XXX  X
Sample Production XXX  X
Special Effects XXX  X
Video DubsXXXXXXX
        
Media (Code: M)(Rate: $0.00/hr.)
       
Item
Qty.
Outsourced
Hours/Cost
Net Cost
Tax
Markup
Subtotal
Billable Planning/Buying Time  XX  X
Media Fees XXXXXX
Media Research XXX  X
Miscellaneous Media Expenses XXXXXX
Post Analysis Time  XX  X
PR Newswire Service XXX  X
 

RETURN TO TABLE OF CONTENTS