Clients
Pike: Customers
Carries over: Client name, email, export code, from the Clients and Contacts report.
You set in Pike: Archived clients appear only in the archived list. Check whether your report includes them.
Template columns: customerName, customerNumber, taxVatId, mainCurrency
Contacts
Pike: Customer contacts
Carries over: Contact name, email, mobile, phone, position, client.
You set in Pike: Nothing.
Template columns: customerNumber, name, email, title, phone
Jobs
Pike: Projects
Carries over: Job No., name, client, status, category, start and due date, client manager, budget.
You set in Pike: A billing type per job, from the pricing mode on its quote: Fixed Price or Calculated.
Template columns: projectNumber, title, customerNumber, status, billingType, budgetAmount, startDate, endDate, leadEmail
Phases
Pike: Phases
Carries over: Phase name on the job, from the Phases tab.
You set in Pike: Check whether your Job Task report includes the phase of each task.
Template columns: projectNumber, phase
Job tasks
Pike: Tasks
Carries over: Task name, description, billable rate, base rate, job.
You set in Pike: Assignees from Job Task Allocation, and estimated time where you plan by task.
Template columns: title, projectNumber, description, phase, assigneeEmail
Time
Pike: Time entries
Carries over: Date, time, note, staff, job, task, billable (Yes or No), billable rate and amount, cost, invoiced amount, submitted.
You set in Pike: Set `invoiced` to `yes` where the invoiced amount is above zero.
Template columns: date, hours, email, projectNumber, taskTitle, note, billableStatus, approvalStatus, invoiced
Staff
Pike: Members
Carries over: Name and payroll code. Check whether your Account Data Export includes staff email.
You set in Pike: Workspace role, team, position and cost profile.
Template columns: email, displayName
Leads and quotes
Pike: Deals
Carries over: Lead and client details from the Lead report type. Check whether your report includes a value.
You set in Pike: Deal statuses that match your lead stages.
Template columns: title, customerNumber, status, value
Invoices
Pike: Invoice history from accounting
Carries over: Pike imports invoices from the Xero or QuickBooks ledger WorkflowMAX exported them to.
You set in Pike: Nothing. The CSV route does not import invoices.
WorkflowMAX stores a base rate (cost) and a billing rate on each staff member and each task, and the Task Invoice Rate setting sets which billing rate applies. Pike takes one `hourlyRate` per project, so use the task or staff billing rate your setting points to.
The Budget field stores one approved job amount in money, which fills `budgetAmount`. Take `budgetHours` from the estimated time on the job’s quote or estimate.
The staff base rate is the hourly cost to the business, including leave and other on-costs. Set each Pike cost profile from it.