How do I Import Sales Thresholds?

TimeForge’s sales thresholds are a powerful tool to allow you to budget and monitor your labor costs. Using the sales thresholds, you can set up a target budget based on labor costs, labor hours, or labor shifts. To easily import the sales threshold information, follow these steps.

Start with a CSV file

Start_with_a_CSV_file.png

Start by creating a CSV file with the necessary information, such as the sales category, position or department, the start date and end date, the threshold, and minimums and maximums.

Note: Each threshold should be on its own line.

Go to Import Data

Go_to_Import_Data.png

Navigate to the Import Data screen.

Choose Your CSV File

Choose_Your_CSV_File.png

Click on Browse and navigate to the CSV file, and then click on Upload Data.

Map the Fields and Import

Map_the_Fields_and_Import.png

You can choose to import a number of fields in the thresholds. For example:

  • Sales Type / Sales Category – Enter the sales category, such as Gross Sales, or Total Skiers
  • Position Name – Enter the TimeForge Position Name (you can use positions or department thresholds)
  • Department Name – Enter the TimeForge Department Name (you can use positions or department thresholds)
  • Threshold Start Date – Enter the date the threshold begins
  • Threshold End Date – Enter the date the threshold should end
  • Threshold Min Value – Enter the minimum value for the threshold
  • Threshold Max Value – Enter the maximum value for the threshold

When you’re done, click on Import Data, and TimeForge will load your data, and show you any warnings or errors when it’s done.

How Do I Import Sales in a CSV?

iSometimes, typing sales information into each day or hour of your week can be a tedious process. TimeForge includes a CSV importer to make bulk data entry much easier. Follow these steps to import your sales with a CSV file.

Navigate to the Sales Categories

Navigate_to_the_Sales_Categories.png

To import sales, first navigate to the Sale Categories list.

media_1325088264838.png

Select the Import Sales for the sales category you would like to import.

media_1325088286549.png

A pop-up will appear to allow you to import your sales data. Sales data should follow the format specified – and should be in a CSV (not Excel) format. The columns should be:

Date
Start Time
End Time
Amount
Department (if applicable)

Choose if the sales are Manager Projections or Actual Figures.

A few hints for using the software import:
1. You cannot currently import data on top of data that already exists. The import tool cannot be used for updating information at this time.
2. Make sure that your number formatting for the Amount column doesn’t include commas. For example, “1234″ is a valid number to import, but “1,234″ is not a valid number.
3. If you are importing data for the whole day, set the start time and end time to be your open and closing times for your location or business.
4. If you are using departments, make sure to the names match the TimeForge names exactly – otherwise, those sales will not be imported.

If using Departments, Set the Import Data

If_using_Departments__Set_the_Import_Data.png

If you are using departments within TimeForge, make sure check the sales import check box for the departments you want to import. If the import check box is not selected, your import will fail for those departments.

Updating Productivity Thresholds by Position

Measuring and monitoring productivity is very important in many businesses, and is a critical part for scheduling employees for many businesses. With TimeForge, there are several ways to budget – including straight one-to-one budgets, comparing labor to sales (or some other metric), and productivity analysis. In most cases, the budget process can be broken down by location, department, or position – providing a lot of power for the financial experts in your organization.

Navigate to the Employee Positions

wpid3797-media_1323452974521.png

After logging in, navigate to Employee->Positions

Locate the Positions

wpid3798-media_1323453065256.png

Locate the position that needs to have the sales thresholds modified, and click Edit.

Click on Threshold

wpid3799-media_1323453095669.png

All of the sales thresholds are stored within the Threshold sub tab. Choose this tab.

Select a Sales Category, and Enter Thresholds

wpid3800-media_1323453118218.png

At this point, choose an applicable sales category for the position, and then modify or update the start date, end date, desired ratio, the minimum, and the maximum. Make sure to click on Save before you finish.

Thresholds, What do they Mean?

wpid3801-media_1323456980988.png

Defining Thresholds can be somewhat confusing, because there are a number of ways to budget for your business, location, department, or position. Here’s a guide to some of these values:

1. Each Sales Category can be tied to different metrics for comparison. For example, you can compare labor costs, hours, or shifts in a day to your sales numbers. In this case, Paid Skier Visits is being compared to an “H”, or hours.

Additionally, sales can be categorized by department or by location. For example, a single department may have sales, and the location may have some additional sales. In this case, Paid Skier Visits is a “L”, or Location level sales category.

2. Sales Thresholds can be established by day, week, month, quarter, year, or whatever other date range you would like. Enter a start date range here.

3. End the end date of your sales threshold.

4. Enter the desired ratio you would like to have, when comparing this particular position to your sales for the day or week. This number can be either a “large” number (such as 20, representing 20%), or a “small” number (such as 0.0135, representing an actual number).

5. Enter the minimum number for your staffing requirements. In this case, we are comparing the threshold to hours, so this field represents 8 hours as a minimum (per day).

6. Enter the maximum number for your staffing requirements. In this case, we are comparing the threshold to hours, so this field represents 32 hours as a maximum (per day).

Adding a User to the TF100 Time Clock

This lesson will demonstrate how to add a user (or admin user) to the TF100 biometric time clock for use with TimeForge.

Step 1: Press the Menu Button.

Step_1_Press_the_Menu_Button.1.png

If it asks for admin affirmation, have an admin put their fingerprint on the fingerprint scanner.

Step 2: Go to the User Management Screen

Step_2_Go_to_the_User_Management_Screen.png

Make sure the arrow is pointing to “User Manage” and Press OK.

Step 3: Choose User or Admin

Step_3_Choose_User_or_Admin.png

Choose how you would like to enroll. You may select either “Enroll User” or “Enroll Admin”. Both of these steps follow the same process, the only difference is the User’s access level.

Step 4: Enroll the fingerprint

Step_4_Enroll_the_fingerprint.png

In the enroll menu, select “Enroll FP”. A screen will pop up asking you to select OK or press ESC.

Step 5: Enroll the fingerprint

Step_5_Enroll_the_fingerprint.png

Press the OK button to enroll a new fingerprint for your user.

Step 6: Enter an enrollment number or PIN

Step_6_Enter_an_enrollment_number_or_PIN.png

Enter a UserID / pin for the user, assign to the user you are registering and then press OK. No other user can have the same UserID / pin.

Remember the UserID (you’ll need it to link their TimeForge account).

Step 7a: Place the employee’s fingerprint on the scanner

Step_7a_Place_the_employee_s_fingerprint_on_the_scanner.png

You must place your finger 3 times to verify.

Step 7b: Continue enrolling your fingerprints

Step_7b__Continue_enrolling_your_fingerprints.png

If an error occurs while reading the staff member’s fingerprint, it will prompt you to place your finger three times again.

Once it is complete you will see an option to Save the fingerprint. Hit OK.

Step 8: The next screen should ask if you want to Continue.

Press ESC on this screen.

Step 9: Enroll backup fingerprints

Step_9_Enroll_backup_fingerprints.png

Now we will enroll up to 3 additional ‘backup’ fingerprints for this user.

Press OK.

Step 10: Repeat Steps 7 – 9

Follow Step 7, 8, and 9 again with a different finger. You can do this up to 4 times, for 4 fingers.

When you are finished with all of the fingers, then press ESC 2 times at the Backup Enroll screen to go back to the Enroll User screen.

Linking Employees to Fingerprints on the Standalone Time Clock

This lesson will demonstrate how to link your employees’ fingerprints to the TF100 biometric time clock.

Step 1: Start the Software

Step_1_Start_the_Software.png

Start the Standalone Time Clock Software.

Step 2: Choose Fingerprint Sync

Step_2_Choose_Fingerprint_Sync.png

Select Fingerprint Sync from the File Menu. Another screen will pop-up.

Step 3: Choose an Employee

Step_3_Choose_an_Employee.png

Use the drop down box to select employees that have not been linked to a pin/User ID on the TF100 Time Clock.

Step 4: Enter a PIN

Step_4__Enter_a_PIN.png

Once an employee has been chosen, select the Pin/UserID on the TF100 Time Clock that corresponds to that employee.

(Note: Employees that are not linked in TimeForge will not be recognized for tracking time and attendance.)

Step 5: Link The Employee and PIN

Step_5_Link_The_Employee_and_PIN.png

Once the pin has been selected, click the Link button.

Step 6: Verify

Step_6_Verify.png

You can verify that the employee was linked properly by checking the drop down box under “Employees with linked pin”.

Step 7: Repeat for other Employees

Step_7_Repeat_for_other_Employees.png

Repeat steps 3-6 for all employees that have fingerprints and IDs on the Time Clock. If you make a mistake and need to reset the Pin/UserID that an employee is linked to, simply select them from the “Employees With Linked Pin” drop down box and click Reset. They should appear back in the “Employees Without Linked Pin” list again.

When you are finished, just click the X at the top right of the screen to close out the Fingerprint Mapping tool.

Adding TimeClock IPs to the Back Office Standalone

This lesson will demonstrate how to add TF100 time clocks to the TimeForge Standalone Timeclock software, allowing users to clock in and out using their fingerprints.

Step 1: Start the Software

Step_1_Start_the_Software1.png

Start the TimeForge Attendance Standalone Timeclock.

Step 2: Sync Time Cards

Step_2_Sync_Time_Cards.png

Select Time Clock Sync Settings from the File Menu.

Step 3: Enter IP Addresses

Step_3_Enter_IP_Addresses.png

Enter each Time Clock IP in the TimeClock IP box and click the Add IP button. It will process the IP and check to see that it is in the network.

Once the IP address has been added successfully, the IP Address you just entered will disappear allowing you to enter another one.

Step 3a: Invalid IP

Step_3a_Invalid_IP.png

If you input a TimeClock that has an invalid IP, or is not configured to connect to the network properly, a message box will pop up.

Step 4: Set Sync Frequency

Step_4_Set_Sync_Frequency.png

If you’d like to update how often TimeForge pulls attendance data off of the TimeClock, you can change it from the Update Sync Frequency drop down box.

Simply select a time period and click Update. If you do not update the sync frequency, it will default to syncing every minute.

Getting an IP for the TF100 TimeClock

This lesson will describe how to set up network access for your TF100 timeclock, an Internet-enabled biometric timeclock.

Step 1: Press the Menu Button.

Step_1_Press_the_Menu_Button..png

If there is an Admin fingerprint registered, you might be required to use that to log into the menu screen.

If no admin users have been added, you won’t need to validate an Admin fingerprint.

Step 2: Go To Options

Step_2_Go_To_Options.png

Press the down arrow and highlight “Options”

Step 3: Press OK

Step_3__Press_OK.png

After going to the “Options” screen, press the “OK” button.

Step 3: Add an IP Address

Step_3_Add_an_IP_Address.png

Press the down arrow and highlight “IP Addr” and then press OK.

Step 5: Enter the IP address

Step_5__Enter_the_IP_address.png

You should be at the IP Address entry screen.

If there is no IP Address listed, you will need to input one yourself using the number pad. Please enter an IP address that is not currently used on your network.

If there is an IP address already listed, that the device found (for example, using DHCP), write it down for reference.

You will need to remember the IP address for entry into the time clock software.

Step 6: Set the Gateway Option

Step_6_Set_the_Gateway_Option.png

Next, scroll down to the Gateway option and press OK.

This should show you the gateway this device is trying to talk to. Make sure its the same gateway the back office servers are connected to.

When done, press OK. Your timeclock is completely configured.

How do I use the TimeForge Facebook application?

Want to get your schedule for the upcoming week? Need to see who’s clocked in … right now? Want to see your sales totals for the day while you’re at home? You can perform all of these labor management tasks, and more, on our TimeForge website.

However, you can also do these tasks (and others) using Facebook – from anywhere you can access Facebook applications.

This lesson discusses using the TimeForge Facebook app.

Search for TimeForge on Facebook

Search_for_TimeForge_on_Facebook.png

From your facebook account search for TimeForge Employee Scheduling, or go straight to http://apps.facebook.com/timeforge

TimeForge Application

TimeForge_Application.png

From the TimeForge application page click on the Go to Application button.

Login to Facebook Application

Login_to_Facebook_Application.png

Using your TimeForge username and password, log in to the TimeForge Facebook application.

View your TimeForge Account Inside of Facebook

View_your_TimeForge_Account_Inside_of_Facebook.png

Using the TimeForge Facebook application, you can view schedules and time cards, review and send messages, and perform many other TimeForge functions, without ever leaving Facebook!

How Do I Archive Reports (Schedules and Payroll)?

In some cases, it’s important to export and save time sheet or schedule information from TimeForge to something like Excel, for a backup, or if you sell your business, or need to further manipulate or crunch the data.

In this lesson, you’ll see how to export payroll information to an Excel spreadsheet, and save it for future use.

Tip: These steps will work for any TimeForge report, including the ability to export data from schedules, absentee reports, or any other TimeForge report.

Go To The Reports Section

wpid2961-Go_To_The_Attendance_Reports.png

Navigate to the Reports section in either Attendance, Schedules, or Sales (if configured).

Identify the Report to Run

wpid2962-Identify_the_Payroll_Report_to_Run.png

Identify which report you want to run to export the time sheets, payroll hours, schedule, or other data.

While there are many different reports available in TimeForge, the Payroll Detail reports are going to be most helpful for archiving and filing time cards.

Enter Your Own Dates

wpid2959-Enter_Your_Own_Dates.png

1. Choose “Enter your own Dates” if given the option.

2. Enter the date range (begin date and end date) that you’d like to export

Export to Excel

wpid2960-Export_to_Excel.png

1. Make sure to export to Microsoft Excel for easy copy / paste and manipulation if needed at a later date for analysis.

Save the File for Your Records

wpid2963-Save_the_File_for_Your_Records.png

Finally, save the resulting spreadsheet on to your computer, or archive the file for use later.

How do I Add New Log Entries to the Daily Log?

The TimeForge Daily Log is a great way to communicate with staff members and other management staff.

The Daily Log consists of 3 different logs:
- A Manager Log, which is only viewable by Managers and Supervisors (if configured).
- A Staff Log, which contains notes from management to staff members.
- An Audit Log, which contains important tracking information from within TimeForge

Adding New Daily Log entries allows other staff members or managers to view the messages, sent from management.

Navigate to the Daily Log

Navigate_to_the_Daily_Log.png

To add a new log entry navigate to the Daily Log tab.
- Click on the Daily Log sub-tab.
- Choose a appropriate log (Manager Log, Staff Log).
- Choose the date to add the entry.

Add A New Entry

Add_A_New_Entry.png

After making a category go to Add a New Log Entry.

Select the Category, and Employee if Applicable

Select_the_Category__and_Employee_if_Applicable.png

Complete the log entry. If it is an important note, and you would like it to be immediately viewable by staff members, then mark the notes as ‘Important‘ to appear in the Important Notes section for staff members and managers.

Upload a Document

Upload_a_Document.png

If you would like to upload a supporting document (such as an HR manual, staff document, picture, or scan), click on upload and select a file. Follow the easy instructions to upload the document from your computer to the TimeForge servers.

heartWhat some of our clients have to say ...

We are one year into it now, well past being enamored with the newness. We are married to TimeForge. It's as essential to us now as any of our management tools today, and we very happy about that.- Steve @ Hermosa Cyclery
We really like the program so far. I know that it is geared towards restaurants, but we are a real estate company and we love it because it is inexpensive and it is so easy to use.- Nicole @ Exit Premier Realty
The Timeforge scheduling system has not only increased our efficiency tremendously; decreased the errors in what is normally an error prone environment; it has also saved us ten times what it costs us each month.- Michael @ Tiara Cafe
I would highly recommend TimeForge to anyone making work schedules. ... What used to take 1-2 hours, now takes 15 minutes. The reports section is comprehensive and useful.- Lawrence Payne @ Mid Pacific Country Club
I've been really pleased with this latest version of TimeForge. I'm really getting familiar with this program and its become a great time saver! Keep up the good work!- Loren @ Fresh Produce
Before using TimeForge, creating a schedule took 2 hours. With TimeForge, it takes less than 10 minutes.- Gail @ Kerr Drug

Quick Contact

3417 73rd Street
Suite G
Lubbock, TX 79423

Phone: 1 866 684 7191
Fax: 1 866 684 7191
E-Mail: info@timeforge.com

 

About TimeForge

The best tools available for managing labor in the restaurant, retail, food-service, and hospitality industries. Includes time management, employee scheduling, and other labor management tools.

© 2010 Labor Management – TimeForge Manual | All Rights Reserved