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
- 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.