Manage Data with Excel

Using Excel File to Manage Data

Hour Timesheet provides a Microsoft ®Excel template for the purpose of creating and managing account data (Employees, Charge Codes, and Pay Types). This import must be utilized if you have checked the “custom” feature in the setup wizard.

Understanding the Data Import Process

Step 1. Open the Microsoft® Excel Import File
Step 2. Prepare the file. Enter your company data

Employees

Charge Codes

Pay Types

Step 3. Import the updated Microsoft® Excel file (your company data) in to your Hour Timesheet site.

Login to your Hour Timesheet login page as user with admin or accountant role

Navigate to the Settings menu item

Click the Import Data tab

Click the Request for Import button to initiate the import process.