Retyping into QuickBooks
You pay for every job twice: once when the crew writes it down, and again when you retype it into QuickBooks.
This sheet costs you about $9,450 a year
FIELD_TICKETS_MONTHEND_copy2_USE THIS ONE.xlsx
| A · Date | B · Job | C · Crew | D · Hours | E · Tons | F · Billed? | |
|---|---|---|---|---|---|---|
| 1 | 3/04 | Oak St Parking Lot | Mike | 9 | 46 | yes |
| 2 | 3/06 | Hwy 12 patch | Dale | can't read | 18 | no |
| 3 | 3/11 | Riverside Apts | Mike | 7.5 | #REF! | ? |
| 4 | 3/13 | Sunrise Church lot | Tony | (sheet lost in truck?) | no | |
| 5 | 3/18 | Oak St Parking Lot | Mike | 6 | 31 | typed twice? |
| 6 | ||||||
| 7 | ||||||
| 8 |
- That sheet costs you
- $9,450/yr
- Time back
- 6 hrs/week
- Every ticket is
- Typed once
The math: 6 hrs/week × 1 person × 50 weeks × $30/hr = $9,000, plus 5% for mistakes and rework = $9,450/yr.Starting point: Small shops describe a day or more each week retyping clipboard sheets and tickets into QuickBooks. Adjust it to match your shop.
- Entered once, in the field. The crew fills this out on site, so nobody reads handwriting or retypes it later.
- The math is done for you. Material, labor, and total are figured as the numbers go in, so the invoice amount is never a guess.
- Billing starts the day the work is done. One tap sends the ticket to your bill queue and on to QuickBooks, with no month-end pile.