Crew Numbers for Sheets

Help

How to connect, what's in each table, and how to build your own sheets on top of it.

Connect · What's in each column · Refresh and Google's limits · Your own formulas · Plans · Disconnect · Privacy

Connect your account

  1. In Google Sheets, open Extensions, then Crew Numbers for Sheets, then Open Crew Numbers.
  2. Pick the app you use (for example, Crew Numbers for Housecall Pro or CrewPay for Gusto) and press "Get a connection code".
  3. Open your app's Sheets settings. The sidebar links to it. Type the 8-character code and pick which tables this sheet may read.
  4. Come back to the sheet. The sidebar notices on its own and shows your business name.
  5. Tick the tables you want, pick the dates and the schedule, and press "Fill my sheet".

Each spreadsheet connects on its own. A bookkeeper can connect one sheet per client. Your client types the code in their app; you don't need their login. The code works for 10 minutes.

What's in each column

Each table gets its own tab, starting with "CN". Row 1 is the header. Money is in your account's currency. A blank cell means the app doesn't know that number yet (for example, no labor cost was entered). It's never a made-up zero. Dates are in your business's time zone.

Columns never move or get renamed. When your app adds a new column, it shows up at the end of the table.

CN Jobs

ColumnWhat it holds
Job #The job number in your app.
JobThe job's title.
ClientWho the job was for.
DateThe day the work was done.
Part of a recurring jobYes if this row is one visit of a repeating job.
CrewWho worked on it.
ServicesWhat was sold on the job.
RevenueWhat the job brought in.
LaborWages for the time on the job, with your labor burden if you set one.
MaterialsParts and materials cost.
ProfitRevenue minus labor and materials.
Margin %Profit as a share of revenue.
Profit isWhether the profit is complete or an estimate.
NoteWhy a number is missing or estimated.
Open in the appA link to the job.

CN Crew

ColumnWhat it holds
Crew memberThe person.
HoursHours worked in the date range.
Jobs workedHow many jobs they were on.
Revenue shareTheir share of the revenue from those jobs.
Labor costWhat their time cost.
Profit contributedTheir share of the profit.
Revenue per hourRevenue share divided by hours.
Callbacks (estimate)Return visits to the same job, as a rough count.
Jobs left out of profitJobs missing the costs needed to count them.
NoteWhy a number is missing or estimated.

CN Clients

ColumnWhat it holds
ClientThe client.
JobsJobs for them in the date range.
Revenue, Profit, Margin %From those jobs.
Invoiced to dateEverything you've ever billed them.
Owes todayWhat they owe right now.
NoteWhy a number is missing or estimated.

CN Services

ColumnWhat it holds
Service, CategoryWhat you sell and its group.
JobsJobs that included it.
Revenue, Profit (estimate), Margin %For that service. Profit is split across services on a job, so it's an estimate.

CN Money Owed

ColumnWhat it holds
Invoice #, ClientThe open invoice and who owes it.
Balance owedWhat's still unpaid.
Days late, How lateDays past due, and the group (not due yet, 1–30, 31–60, 61–90, over 90).
Due (or issued)The due date, or the issue date if there isn't one.

CN Pay Lines

Only pay runs you've locked in your app. Crew Numbers and CrewPay work out pay; they don't run payroll, move money or file taxes.

ColumnWhat it holds
Crew member, DateWho, and the day the work was done.
TypeHourly, per job, commission, bonus or deduction.
Job or itemWhat the line is for.
How it's paidThe pay rule used.
HoursHours, for hourly lines.
AmountWhat this line pays.
NoteAnything changed by hand.
Period start, Period endThe pay period.

Refresh and Google's limits

Your own formulas, notes and charts

Plans

The add-on is free to install. Refreshing needs a Crew Numbers or CrewPay plan that includes Google Sheets: any paid plan, or the Sheets only plan where your app offers it. Free trials include Sheets for the whole trial. If your plan stops including Sheets, your tables stay but stop refreshing, and the sidebar links to your app's billing page.

Disconnect

In the sidebar, "Disconnect this sheet" removes the connection and stops the schedule. Your tables stay. You can also revoke the sheet in your app's Sheets settings.

Privacy

The add-on can only see the spreadsheet you use it in, and only calls your Crew Numbers or CrewPay account. Read the privacy policy.