Stencils for Painting Jobs: How I Finally Stopped Losing Track of My Inventory, Clients, and Sanity

A painter's system for tracking stencils, paint stencil inventory, job photos, and client files in Google Sheets — so nothing falls through the cracks between jobs.

Last spring I showed up to a nursery remodel with three boxes of stencils for painting an accent wall — and not one of them was the floral stencil the client had picked during our walkthrough six weeks earlier. It was buried somewhere in my garage, probably behind the 5-gallon buckets of Kilz. The client had her phone out showing me the Pinterest board. I had nothing but a vague text thread from March and a sinking feeling in my stomach. That job cost me two hours of driving, one awkward conversation, and the quiet realization that my "system" of saving everything in my head and my truck's center console had finally, fully broken.

If you paint houses, murals, accent walls, or commercial interiors, you already know the actual painting is the easy part. It's everything around the painting — the estimates, the color selections, the stencil inventory, the before-and-after photos you promised the client, the subcontractor invoices you need for taxes — that slowly buries you. I spent the better part of last year building a Google Sheets setup that keeps all of this in one place, and it's saved me from more than a few repeat trips. Here's exactly how I did it.

Why Painting Contractors Need More Than a Notes App

Most painters I know, myself included, start out managing everything through some combination of text messages, a yellow legal pad, and maybe a shared Google Drive folder with 400 unsorted photos in it. That works fine when you're doing two jobs a month. It stops working when you're juggling six, each at a different stage, each with a different paint spec, and at least two of them involving custom stencil work.

The core problem isn't laziness — it's that painting jobs generate a weird mix of visual and text-based information. You need the client's address, the square footage, the paint codes, AND the photos of the wall damage you found behind the crown molding. You need the signed estimate AND the picture of the stencil layout they approved. No single app handles all of that well. CRMs are overkill and expensive. Notes apps can't show you a timeline. Google Drive is a graveyard of unnamed JPEGs.

Google Sheets isn't glamorous, but it's the one tool where I can see every job in a row, every detail in a column, and — this is the part that actually changed things — attach the relevant files directly to each row so they're not floating around in some disconnected folder.

The Job Tracker: One Row Per Job, Everything Attached

The backbone of my setup is a single sheet called "Jobs." Each row is a project. The columns cover the basics: client name, address, phone, start date, estimated end date, status (Estimate / Scheduled / In Progress / Complete / Invoiced), total quoted, total paid, and notes. Nothing revolutionary — any contractor could set this up in ten minutes.

What made it actually useful was adding columns for file attachments. I have one column for the signed estimate PDF, one for "Before Photos," one for "After Photos," and one for "Stencil/Design References" — that last one is where I drop the client's inspiration images, the specific stencil product links, or photos of the stencil layout taped to the wall before I commit to paint. This is where I use FileFox, because dragging a photo into a cell is a lot faster than linking out to Drive and hoping I remember which folder is which.

The status column uses data validation (a dropdown) so I can filter by "In Progress" and see only the active jobs. Simple, but it means I open one sheet on Monday morning and know exactly where everything stands.

Tracking Your Stencil for Wall Painting Inventory (Before It Eats Your Garage)

This was the part that took me the longest to figure out, mostly because I didn't think I needed a system for stencils until I'd bought the same damask pattern three times. If you do any decorative work — accent walls, nurseries, restaurant interiors, rental staging — you accumulate stencils fast. Geometric patterns, flower stencils, alphabet letter stencils for kids' rooms, custom Mylar cuts for commercial logos. They pile up.

I now keep a second sheet called "Stencil Inventory." Each row is one stencil. Columns:

• Stencil Name (e.g., "Large Dahlia Floral 24×24")
• Type (Floral / Geometric / Alphabet / Custom / Damask / Border)
• Size (dimensions in inches)
• Material (Mylar / Cardstock / Adhesive-backed / Reusable plastic)
• Condition (New / Good / Worn — Replace Soon / Retired)
• Location (Garage Shelf B / Job Site / Lent to Miguel)
• Photo of Stencil (attached directly in the cell)
• Last Used On (linked to the job name from the Jobs sheet)
• Purchase Price
• Supplier / Source URL

The photo column is the one that actually saves me from the "wrong stencil" problem. When a client says they want "that leafy one," I can scroll through thumbnails instead of describing patterns over the phone like I'm narrating a podcast about wallpaper. I snap a photo of each stencil flat on a white surface when I first get it, drag it into the cell, and it's there forever.

The condition column is key, too. Mylar stencils hold up well but cardstock ones don't survive more than a few uses, especially with thicker latex paints. If I see "Worn — Replace Soon" in the inventory before I load the truck, I can reorder with a few days to spare instead of discovering it on-site when the edges are feathering.

Client Files, Color Specs, and the Before/After Photo Problem

Every painting contractor has a phone full of job photos with no labels. You scroll back three months trying to find the "before" shot of that living room in Lakewood and instead find 47 photos of a ceiling water stain from a completely different house. It's digital chaos.

My fix was simple: I take before and after photos on-site and upload them directly into the job row in my tracker that same day. Not that evening. Not that weekend. Right there, standing in the client's house, while I still know which job it belongs to. It takes 30 seconds with FileFox — I just open the sheet on my phone browser, find the row, and drop the images in.

For color specs, I keep a column that stores the exact paint codes (e.g., "SW 7015 Repose Gray, eggshell, walls" and "BM OC-17 White Dove, semi-gloss, trim"). But I also attach the color fan deck photo or the custom-matched swatch photo in an adjacent column. Why? Because six months later when the client calls asking for the touch-up color, I can see the actual swatch, not just a code that might have been a custom match.

Estimates, Invoices, and Not Losing $800 Because You Forgot to Follow Up

I lost an $800 exterior job last year because I sent the estimate and then just... never followed up. The client went with someone else. When I texted her a month later she said, "Oh, I figured you weren't interested — I never heard back." That one stung enough to make me build a proper estimate-tracking column.

In my Jobs sheet, I have a column called "Estimate Status" with a dropdown: Sent / Viewed / Accepted / Declined / Expired. Next to it, a date column for "Follow-Up By." I set a conditional formatting rule: if the follow-up date is today or past and the status is still "Sent," the row turns yellow. It's not a fancy CRM — it's a colored row that yells at me when I open the sheet.

That's the custom formula for conditional formatting (applied to the whole row, where D is Estimate Status and E is Follow-Up Date). Yellow highlight, hard to ignore. I also attach the estimate PDF directly in the row so when I call the client to follow up, I can pull it up instantly instead of digging through my email.

For invoicing, I keep it in the same row — once a job is complete, I attach the invoice PDF, update the status to "Invoiced," and add a "Paid" checkbox column. At tax time, I filter by the year and "Paid = TRUE" and hand the whole thing to my accountant. She called it "the most organized thing a painter has ever given me," which is a low bar, but I'll take it.

Keeping It All Connected Without Overcomplicating It

I've tried Jobber. I've tried Housecall Pro. They're fine tools, but they cost $40–$80/month and half the features don't apply to painting. I don't need GPS fleet tracking. I don't need automated appointment reminders for a job where I'm texting the client directly anyway. What I need is a central place where I can see all my jobs, find any file, and not lose track of my stencil inventory. Google Sheets does that for free (or close to it — FileFox is $9/month, and my accountant is... more than that).

The key is keeping the number of sheets manageable. I run three: Jobs, Stencil Inventory, and Supplier/Sub Payments. That's it. I tried adding a "Lead Pipeline" sheet and a "Marketing Tracker" and a "Vehicle Maintenance Log" and it became another abandoned system within two weeks. Three sheets. If it doesn't fit in three sheets, it probably doesn't need to be tracked.

What to Build First (Start Here, Today)

If you're reading this on your phone between coats drying, here's what to do first: open a new Google Sheet, name it "[Your Name] Painting Jobs 2025," and create one row for every active job you have right now. Just the basics: client name, address, status, amount quoted, and one column for notes. Don't worry about stencil inventory or invoice tracking yet. Get the active jobs in rows first.

Once that feels natural — give it a week — add your file columns. Signed estimates, before/after photos, whatever you're currently losing track of. That's when a tool like FileFox actually earns its keep, because dragging a photo into a cell is the difference between a system you maintain and a system you abandon.

The stencil inventory sheet can wait until a rainy Saturday when you're reorganizing the garage anyway. Take a photo of each stencil, log it, note the condition. Future you — the one standing in a client's nursery trying to remember if you already own a large floral stencil or need to order one — will be grateful.

Frequently Asked Questions

What's the best way to track stencils for painting in a spreadsheet?

Create a dedicated sheet with columns for stencil name, type (floral, geometric, alphabet, etc.), size, material, condition, storage location, and a photo attached directly in the row. The photo column is what actually saves you time — you can visually scan your inventory instead of describing patterns from memory. Update the condition column after every use so you know when a stencil needs replacing before you're on-site.

How do I organize before and after photos for painting jobs?

The simplest method is attaching photos directly to each job row in a Google Sheets tracker using a file-attachment add-on like FileFox. Create separate columns for "Before Photos" and "After Photos" and upload images on-site the same day you take them. This eliminates the problem of scrolling through hundreds of unlabeled photos on your phone trying to match them to the right job weeks later.

Can I use a stencil for wall painting more than once?

It depends on the material. Mylar stencils can last dozens of uses if you clean them promptly after each application. Cardstock or paper stencils typically survive 2–5 uses before edges start feathering and paint bleeds underneath. Adhesive-backed stencils are usually single-use. Track the condition of each stencil in your inventory so you can reorder before a job, not during one.

What's the best free alternative to painting contractor software?

Google Sheets paired with a file-attachment tool covers 80% of what most painting contractors need: job tracking, estimate follow-ups, photo documentation, and basic invoicing. Dedicated contractor software like Jobber or Housecall Pro adds features like scheduling automation and GPS tracking, but at $40–$80/month, many solo painters and small crews find a well-organized spreadsheet does the job for a fraction of the cost.

How do I track paint stencils for pumpkins and seasonal jobs?

Add a "Season/Category" column to your stencil inventory sheet and tag seasonal items (pumpkin stencils, holiday window designs, etc.). Filter by that column when seasonal work comes around so you can quickly see what you already own and what condition it's in. For one-off seasonal gigs, note the client and date in a "Last Used" column so you have a ready-made contact list for the following year's outreach.