1 · From Harvest
Export detailed time, not a summary.
In Harvest, open Reports → New report → Detailed time, choose the date range and people you need, then use Export → CSV. Your plan and permissions determine which records you can export. Administrators can also export all time from Settings → Import/Export.
Keep an untouched copy of that download. A PDF or a project-total spreadsheet does not contain the individual entries this importer needs. If you customize the export, include the eight columns below with these exact headings.
If your export has First Name and Last Name, rename those headings to First name and Last name in a separate working copy. Keep the original download unchanged.
Checked against Harvest’s export instructions on November 15, 2026. Time Invoice Studio is not affiliated with Harvest.
2 · Before upload
Keep these eight headings.
Column order can vary. Headings must be unique and match the spelling below. Save as UTF-8 CSV; keep each file under 2 MiB and 5,000 entries. Split larger exports into non-overlapping date ranges.
| Column | Example | What to check |
|---|---|---|
Date | 2026-10-26 | Choose YYYY-MM-DD or M/D/YYYY in Import history. Supported dates are in 2000–2100. |
Client | Ridgeline Collective | The client name from your export. |
Project | Brand strategy | The project name, kept under its client. |
Task | Workshop | A task name is required on every row. |
Notes | Discovery, kickoff and alignment | Keep the column even when a note is blank. Quote notes that contain commas. |
Hours | 3.3333 | More than zero and at most 24 decimal hours per entry, up to four decimal places. Use Hours, not Hours Rounded. |
First name | Alex | Match each source person to a person in your workspace before importing. |
Last name | Morgan | Keep first and last names in separate columns. |
Scroll the table sideways to read all three columns.
Extra columns such as Billable, Invoiced, a rate, or an external reference stay with the original row. They do not set a new billing status or recreate an invoice. A nonblank Currency must be exactly USD. Currencies are never converted; do not relabel another currency to make it pass.
The example includes External reference and Rounded hours to show how extra fields are retained. Its total uses Hours.
If two people share a name, include a reliable User ID or Email column from your source to distinguish them. If you cannot tell whose entries they are, stop before matching; do not guess.
3 · In Time Invoice Studio
Preview first. Match people. Then import.
- Open Import history as the workspace owner. Choose the date format used in your file, then choose your CSV. A preview does not add time records.
- Check the receipt and displayed rows. Compare the source count, valid count and hours with Harvest. Review the grouped totals by date, person, client and project. The row table shows only the first 100 entries, although the counts cover the whole file. No batch can be imported while any row has a problem.
- Match every source person to the right current member. Only current workspace members can be chosen, within the ten-person workspace limit. Adding someone requires them to accept an email-verified invitation and grants them workspace access; matching alone does not. If a former teammate cannot join, keep their rows in your original export and contact support before proceeding. Never map them to another person just to finish.
- Import the reconciled batch. Its entries appear as archived history. The receipt keeps the original file, extra fields and your person mapping.
Trying it without an account
The sample’s Import history has a Try the synthetic sample button for its fictional firm. Your own files belong in your private trial workspace. The downloadable example above is a different five-person file, so its counts differ from the sample firm’s built-in export.
To reverse an import, choose Undo beside the batch in Import receipts, then confirm Undo import. This removes the batch’s entries from active history while retaining its source and audit record. Later edits are preserved, and the undo result explains what was kept.
4 · Your next billing period
Leave old invoices in the old system.
Choose a date from which your team will log new time here. Finish and retain earlier invoices, expenses, payments and tax records in Harvest or your accounting system. This CSV import carries time history; it does not migrate those records, attachments, account access or a running timer.
Set the rates for new work, invite your team, then log, submit and approve the new entries. Only approved new time can enter a new invoice. An imported row marked “uninvoiced” in Harvest still remains archived here.
If you later leave, download your complete workspace as JSON and export new time in Harvest’s import format. Keep your original Harvest downloads alongside it.
If the file is rejected
- Missing required column
- Compare the header row with the eight names above, including lowercase “name”. Keep Notes even if every note is blank.
- Date or hours error
- Select the file’s date format before previewing again. Use decimal hours such as 1.5, not 1:30, and no more than four decimal places. In the preview, choose Download rows to fix (CSV) (the button includes your error count). The report includes every rejected entry, including those beyond the first 100 shown, its row number and all its issues. Row numbers include the file’s headings and blank rows. Correct your original CSV and preview it again; the report itself is not an import file. Each distinct preview uses retained-file capacity, including rejected files.
- Duplicate or overlapping row
- Compare the flagged entries with your untouched source and earlier receipts. Remove only confirmed duplicates. Separate real entries with the same date, client, project, task, notes, hours and person are also flagged, even if their external references differ. The importer cannot accept both unchanged: preserve them and contact support before importing incomplete history. Do not change hours or notes to force acceptance. Uploading the same bytes returns the existing receipt; it does not add a second batch.
- Size, record or retained-file limit
- The workspace allows 20,000 time records and 100 retained files, with up to 20 MiB of original CSV files and 96 MiB of preserved source and previews in total. Each stored preview is limited to 8 MiB, so a wide file can be rejected below the 2 MiB upload allowance. Invalid and undone previews retain capacity. Import history shows the upload and record limits; an error explains a retained-storage limit. Splitting a file does not bypass workspace limits. Contact support before adding more files when the retained allowance is reached.
Try the workflow before moving a file.
Open the fictional firm, inspect its import receipt, then make an invoice from approved new work.
No card for the trial. $49 buys a 30-day workspace pass for up to ten people. No automatic renewal.