With Service Timecard you can create custom template exports. This allows you to create exports that will fit the requirements of your accounting system imports.
The following article will walk you through the process of creating custom export templates and making them your default template for your Service Timecard.
Video Walkthrough
The following link will take you to Part 4 of 4, of a video series that walks users through utilizing Service Timecard. This video will show you how to create a custom Template.
Service Timecard Sharing Data with Other Systems (Video, Part 4)
How to Create a Custom Template
- Log in to timecard.servicetrade.com
- Click Settings in the sidebar.
- Click the Template Settings accordion to expand the menu.
- Click the Add Template button, to begin creating a custom Template.
- Note: For each new account created, you will see the Templates Default (Clock Type) and Labor Default (Labor Type). These cannot be deleted, and are automatically created when Service Timecard is activated for your account.
- Note: For each new account created, you will see the Templates Default (Clock Type) and Labor Default (Labor Type). These cannot be deleted, and are automatically created when Service Timecard is activated for your account.
- Enter a custom Template Name then click Next.
- Select a Type of Template then click Next.
- Labor - will display Labor Type Items sourced to relevant Techs in ServiceTrade.
- Clock - will display Clock Event from relevant Techs in ServiceTrade.
- Expenses - Will display non-Labor Type Items sourced to relevant Techs in ServiceTrade.
- Select whether you would like to have Item Codes Ungrouped or Grouped.
- An ungrouped export will have a single Job Item per row separated by Item Code and date.
- A grouped export will contain a single Tech per row with a sum of Job Items by Item Code in the weekly period.
A grouped template will NOT show any date fields (used on date, begin date, date.) It will only show the sum of all activities, items, and events for a specific week per technician.
- Check to select 1 or more of your Templates columns' data sources from the Columns drop-down menu.
- For a table of these data source columns and their definitions, Definitions of Service Timecard Template Data Sources.
- Rename the default column names to your desired heading names, if necessary.
- Example: If you selected the technician_id default column, but your accounting system spreadsheet header for this field needs to be user_id. You would rename the technician_id column to user_id.
- Drag and drop the columns fields to Order the Columns for your custom Template export.
- Click Finish when done.
Note: When setting a default export, this will either be grouped or ungrouped as you cannot have more than one default template for the template types (Labor items and Clock events.)
How to Manage Templates
- Log in to timecard.servicetrade.com
- Click Settings in the sidebar.
- Click the Template Settings accordion to expand the menu.
- Follow the steps in the next sections for viewing, setting as default, editing, and deleting templates.
How to View and Set Templates as Default
- On the relevant Template row, click the eye-shaped View More icon.
- This will show you the type, grouped type, column fields, and header names
- Click Save as Default to make this the default export template.
How to Edit Templates
- On the relevant Template row, click the pencil Edit icon.
- Default Templates cannot be edited.
- Follow the same steps in How to Create a Custom Template.
How to Delete Templates
On the relevant Template row, click the trashcan Edit icon.
Note: There is no prompt. This will delete your template immediately.
Import a STAC Template
Time card has an Import STAC Template option that allows you to create a template that you can use for your STAC imports.
Important Note: The ServiceTrade Accounting Connector (STAC) requires a Premium or Enterprise ServiceTrade Subscription and is a paid add-on. Please contact your ServiceTrade Salesperson or your Account Manager if you want to learn more about STAC.
- Log in to timecard.servicetrade.com
- Click Settings in the sidebar.
- Click the Template Settings accordion to expand the menu.
- Click the Import STAC Template button.
- Enter your STAC ID. This is found in your STAC recipe URL (e.g YXL0sHI7SKda)
- Enter your STAC Basic Token. This is found in the code section of your recipe.
- Click Next.
- Enter a Template Name.
- Click Next.
- Select a Template Type.
- Click Finish.
Comments
0 comments
Please sign in to leave a comment.