Estimates from the takeoff
Barry copies your estimate sheet and enters quantities from the takeoff, so your own formulas and unit prices do the pricing.
All integrations
WIP Report – 2026ShareDM
Review WIP
Barry fills in your Google Sheets.
Barry reads your estimate, job-cost and WIP sheets and keeps them current from your books and takeoffs.
WIP Report – 2026ShareDM↶↷100% ▾Normal text ▾Default (Arial) ▾− 11 +BIU
F3fx
=E3-B3*D3| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | October 2026 | Contract | Cost to date | % done | Billed | Over/(under) |
| 2 | Maple Street Office | 780,000 | 702,000 | 72% | 523,000 | (38,600) |
| 3 | Riverside Medical Office – TI | 1,020,000 | 640,000 | 63% | 655,000 | 12,400 |
| 4 | Harbor Street Retail | 480,000 | 210,000 | 44% | 198,000 | (13,200) |
| 5 | Oakview Dental Clinic | 640,000 | 128,000 | 20% | 160,000 | 32,000 |
| 6 | Lakeside Urgent Care | 1,310,000 | 1,180,000 | 92% | 1,205,200 | 0 |
| 7 |
+WIPJob costEstimatesCert register
October WIP filled in from QuickBooks. 3 jobs flagged.
Active jobs14Under-billed$51,800Over-billed$44,400
Barry
Maple Street is at 90% of cost but 72% complete, so it’s under-billed. I flagged it on the WIP tab.
Maple Street Office, F2−$38,600
What Barry does in Google Sheets.
Barry fills estimate sheets from the takeoff, builds the monthly WIP tab from your books and keeps your certification register current.
WIP filled in every month
Cost to date, percent complete and billings land on your WIP tab, with over- and under-billed jobs flagged.
Cert register kept current
Barry reads the expiry dates in your cert register and prepares renewal paperwork before anyone’s ticket lapses.
Ask for it in plain words.
Send Barry a message like one of these and it sets up the work across Google Sheets and your other connected tools.
“Copy our estimate sheet for Hillcrest and fill the quantities from the takeoff. Leave the formulas alone.”
Estimate from takeoffWhen you ask“On the 1st, fill the WIP tab from QuickBooks and flag any job that’s over- or under-billed by more than $10,000.”
Monthly WIP tab1st of the month · 8:00 AM“Every Friday, check the job-cost tab against budget and draft follow-ups for invoices on the AR tab over 30 days.”
Job cost and AR checkEvery Fri · 3:00 PM“When a date in the cert register is 30 days out, prepare the renewal form and send it to me to check.”
Certification renewals30 days before expiry
How Barry connects to Google Sheets.
Connect once, say what you need, and stay in control of anything that leaves your business.
Connect Google Sheets
Sign in with Google and pick the sheets Barry can read, and which of them it may update. Barry only sees what you give it.
Tell Barry the job
Describe the work the way you’d brief a new hire. Barry sets it up and tells you when it will run.
Approve what goes out
Drafts for customers, GCs and subs wait for your OK. The routine work gets done, and Barry tells you what it did.
Questions about Barry and Google Sheets.
- Will Barry break my formulas?
- No. Barry writes values into the cells and columns you already use and leaves formulas, tabs and headers alone. Version history shows every change.
- Can Barry read a sheet without changing it?
- Yes. Point it at a price list or crew roster as read-only and Barry uses what’s there without writing anything back.
Works alongside Google Sheets.
Barry works across all your connected tools at once. See every integration
