Clients
Pike: Customers
Carries over: Client names, synced from QuickBooks Online, Xero or FreshBooks where connected.
You set in Pike: A customer number on every customer. Pike imports customers from QuickBooks or Xero when you connect it.
Template columns: customerName, customerNumber
Projects
Pike: Projects
Carries over: Project name from the connected tool, client, billing method, budget.
You set in Pike: A project number for each project, and the Everhour billing method and budget as columns.
Template columns: projectNumber, title, customerNumber, billingType, budgetAmount, budgetHours, hourlyRate
Tasks
Pike: Tasks
Carries over: Task name, number, status and type from the connected tool, task billing override.
You set in Pike: Nothing when Pike imports tasks from Asana or Jira. Otherwise one assignee per row in the tasks file.
Template columns: title, projectNumber, description, status, assigneeEmail, dueDate, billableStatus
Members
Pike: Members
Carries over: Name, billable rate and cost rate on the Members page.
You set in Pike: The email each member signs in with, plus workspace role, team and a cost profile.
Template columns: email, displayName, team
Time (Reports)
Pike: Time entries
Carries over: Day, member, project, task, reported time, billable and non-billable time, time comments, invoiced amount.
You set in Pike: Member emails where the report shows names, and approval state for weeks approved on the Team page. Check whether your report includes it.
Template columns: date, hours, email, projectNumber, taskTitle, note, billableStatus, approvalStatus, invoiced
Expenses
Pike: Expenses
Carries over: Expense amount, project, billable flag.
You set in Pike: Check whether your report includes expenses. Expense categories in Pike.
Template columns: date, amount, projectNumber, email, category, description, billableStatus
Invoices
Pike: Invoice history from accounting
Carries over: Everhour copies exported invoices to QuickBooks Online, Xero or FreshBooks as drafts.
You set in Pike: Nothing. The CSV route does not import invoices.
Everhour bills through the project’s Billing method: Non-billable, T&M (project rate), T&M (members rate) or Fixed-fee. Map the T&M methods to `timeAndMaterials`, Fixed-fee to `fixedFee` and Non-billable to `nonBillable`. A project rate goes into `hourlyRate`.
For T&M (members rate) projects, Everhour bills each member at their billable rate, with optional project overrides. Set those rates in Pike after upload. Hour budgets go to `budgetHours` and fee budgets to `budgetAmount`. Recurring budgets reset per period in Everhour, so set them up as retainers in Pike.
Everhour stores a cost rate for each member on the Members page, applied from a chosen date. Set each member’s Pike cost profile from the current cost rate.