Published: 1 June 2026
Audience
- Admin
Objective
This article explains how to import time entries into PSOhub in bulk using the Excel import template. Use this method when migrating historic hours from another tool into existing PSOhub projects.
Prerequisites
You must have Admin access in PSOhub.
Your hours import file must be prepared and ready to upload. See Import Hours: Preparing your import file for guidance on filling in the template correctly.
Roles must already be assigned to the relevant users in PSOhub.
⚠️ Important: If hours approval is enabled in your organization, imported hours will be created with an unapproved status and will follow your standard approval workflow. If hours approval is disabled, imported hours will be automatically approved. Consider setting a time entry freeze for your team during the import period to prevent manually entered hours from being auto-approved unintentionally.
Steps
- Navigate to Time & Expenses and select Hours.
- Click Import.
- Click inside the upload box and select your completed import file, or drag it into the upload area. The file must be in .xlsx format.
- Review the imported rows in the preview grid. Check for any validation errors before proceeding.
- Click Import hours.
- Review the confirmation message and click Proceed.
- Click OK to complete the import.
💡 Tip: Before importing your full file, test with a small selection of rows first — typically 3 to 5 entries. This lets you verify that the data imports correctly before committing to the full dataset.
Result
Your time entries are created in PSOhub and will appear immediately in the Hours list, linked to their respective projects and contract lines.
If any rows contain errors, PSOhub will indicate which information is incorrect or missing. Correct the affected rows in your file and re-import.
Next Steps
✅ Import your expenses
Bring over expense records linked to your imported projects.
How to Import Expenses
✅ Migrate to PSOhub
Return to the migration guide to track your progress and complete the remaining steps.
Migrate to PSOhub
FAQs and Troubleshooting
A time entry was imported but is not linked to the correct project. Why?
The project name in your import file must match an existing project in PSOhub exactly, including capitalization and spacing. Check for differences and re-import the affected rows.
A team member's hours were not imported. Why?
The user email in your import file must match an existing PSOhub user, and the role must already be assigned to that user. Verify both in PSOhub before re-importing.
The import failed after I uploaded my file. What should I check?
Confirm that the column headers in your file match the original template exactly. Do not rename, remove, or reorder any columns. Re-download the template and copy your data into a fresh copy if needed.
Why are my imported hours showing as unapproved?
If hours approval is enabled in your organization, all imported hours are created with an unapproved status by default. They will need to go through your standard approval workflow before they are counted as approved.