Building Your Price Book: A Template Walkthrough
Our Google Sheet template is a powerful calculator designed to make creating your flat rate price list simple and accurate. For your convenience, a copy of these instructions is also included on the ‘Instructions’ tab within the Google Sheet itself.
Important First Step: Make a Copy of the Template Before you begin, you must save a copy of the Google Sheet to your own Google Drive. The original template is view-only, ensuring every user gets a clean version. To make your own editable copy:
- Open the Google Sheet.
- Go to the File menu in the top-left corner.
- Select Make a copy. Your new, editable version will open, and you can now follow the steps below.
Step 1: Customize with Your Business Information Open your copied Google Sheet and go to the “Input Details” tab. Replace the placeholder logo and enter your company’s name, address, phone number, and email.
Step 2: Enter Your Labor Costs In the same “Input Details” tab, fill in your core labor rates. Enter your Labor Cost per Hour, After Hours Labor Cost per Hour, and any flat After Hours Surcharge. Save this file as your master template.
Step 3: List Your Services, Costs, and Time Navigate to the “Price Book” tab. This is where you will build your list of services, organized by category. For each service you offer (e.g., “Toilet flapper” under “Accessories”), fill in two cells:
- Item Cost: The price of the flapper (e.g., $15).
- Estimated Hours: The time it takes to do the job (e.g., 0.5 hours).
Step 4: Get Your Automated Prices As you fill out Step 3, the template instantly does the calculations for you based on the formulas in the “Instructions” tab. In the same row, you will see two prices automatically appear:
- Standard Price
- After Hours Price
Repeat this process for all your services to build your complete price list.
Step 5: Review Your Printable Price Book Once your prices are calculated, click the “Printable Report – Full Summary” tab. This tab collects all your services and prices into a clean, professional document that you can print and put in every truck or save as a PDF.