Using QuickBooks to Track Marketing ROI (Without Buying Another Tool)

Three custom fields and one report in QuickBooks can tell you your cost per booked job by marketing channel. Setup takes under 15 minutes. No additional software required. No monthly subscription. No integration headaches.

67% of contractors with fewer than 5 employees already use QuickBooks, according to Intuit’s small business survey. Most use it exclusively for invoicing and expense tracking. They enter income, categorize expenses, and hand the file to their accountant at tax time. Marketing spend goes into a generic “Advertising” expense category, and the connection between dollars spent and jobs booked disappears.

You don’t need a $200/month CRM to track basic marketing ROI. QuickBooks can do it with the setup you already have.

Setting up marketing tracking in 15 minutes

Step 1: Create a custom “Lead Source” field (3 minutes)

In QuickBooks Online, go to Settings > Custom Fields. Create a new custom field called “Lead Source” and set it as a dropdown with these options:

• Google Ads
• Google LSA
• Google Organic
• Google Business Profile
• Facebook Ads
• Nextdoor
• Referral / Word of Mouth
• Repeat Customer
• Yard Sign / Vehicle Wrap
• Direct Mail
• Thumbtack / HomeAdvisor
• Other

Attach this field to Invoices and Estimates. Every invoice you create will now have a Lead Source dropdown. The entire setup takes 3 minutes.

A contractor on r/sweatystartup described adding this single custom field and discovering that his vehicle wrap — a $3,500 one-time investment — had generated $42,000 in attributed revenue over 8 months. He’d been considering spending $6,000 on a new wrap for his second truck. The data made the decision obvious.

Step 2: Create marketing expense sub-categories (5 minutes)

Most contractors dump all marketing spend into one “Advertising” category. Break it out by channel so you can calculate cost per lead by source.

Go to Chart of Accounts and create sub-accounts under your existing Advertising or Marketing expense account:

• Marketing: Google Ads
• Marketing: Google LSA
• Marketing: Facebook Ads
• Marketing: Direct Mail
• Marketing: Nextdoor
• Marketing: Thumbtack / HomeAdvisor
• Marketing: Other

When you record a marketing expense, assign it to the specific sub-category. Your $1,200 Google Ads bill goes into “Marketing: Google Ads,” not the generic bucket. Your $450 direct mail campaign goes into “Marketing: Direct Mail.”

This takes 5 minutes to set up and 10 seconds per transaction to maintain. At the end of each month, you’ll see exactly how much you spent on each channel.

Step 3: Track lead source on every invoice (2 minutes per invoice)

Train yourself (and your team) to select the Lead Source on every invoice. When a customer calls and you ask “How did you find us?”, note the answer and select it when creating the estimate or invoice.

This is the discipline step that determines whether the system works. If you skip the lead source on half your invoices, the data is useless. If you tag every single invoice, you have a complete picture of revenue by channel.

ServiceTitan’s industry data shows that contractors who consistently ask “how did you hear about us?” improve their marketing attribution accuracy by 40-60%. Most customers answer the question without hesitation. The ones who say “I don’t remember” or “the internet” get tagged as “Google Organic” or “Other.”

Running your first ROI report

Monthly marketing ROI report

After 30 days of tagging lead sources and categorizing marketing expenses, pull this report:

Revenue by lead source: In QuickBooks, run a Sales by Customer Detail report and filter or group by the Lead Source custom field. This shows total invoiced revenue from each marketing channel.

Marketing spend by channel: Run a Profit and Loss report and expand your Marketing expense category to see spend by sub-account.

Calculate cost per booked job: Divide your monthly spend on each channel by the number of invoices tagged with that lead source.

Example from a 3-month tracking period:

Channel	Monthly Spend	Jobs Booked	Revenue	Cost Per Job
Google Ads	$2,400	12	$21,600	$200
Google LSA	$1,800	15	$18,750	$120
Referral	$0	8	$16,800	$0
Facebook Ads	$800	3	$4,200	$267
Yard Sign	$50 (replacement)	4	$6,400	$13

This table tells you everything you need to know about where your marketing dollars work hardest. In this example, Google LSA produces the most jobs at the lowest cost per acquisition. Facebook Ads costs 2x more per job with lower average tickets. The yard sign is the most cost-efficient channel by far.

A plumbing contractor on the Owned and Operated podcast described running this exact analysis after three months of QuickBooks tracking. He discovered that Thumbtack was generating leads at $85 each, but those leads closed at only 12% and averaged $650 per job. His effective cost per booked Thumbtack job was $708. Google LSA leads cost $45 each, closed at 28%, and averaged $1,100 per job. Effective cost per booked LSA job: $161. He eliminated Thumbtack entirely and redirected the budget.

Advanced tracking with classes

Using QuickBooks classes for job-level attribution

If you’re on QuickBooks Online Plus or Advanced, Classes provide another layer of tracking. Create classes for each marketing channel and assign them to income and expense transactions. Classes let you run a Profit and Loss by Class report showing revenue, job costs, and marketing costs by channel in a single view.

Revenue minus job costs minus marketing costs by channel = true profit by marketing source. This shows which channels produce the highest-margin jobs, not just the most jobs.

What QuickBooks tracking can’t do

No pipeline visibility

QuickBooks tracks completed transactions — invoices and payments. It doesn’t track your sales pipeline. You can’t see how many estimates you sent, how many are pending, or which leads went cold without converting.

For pipeline tracking, you need a CRM like Jobber, Housecall Pro, or GoHighLevel alongside QuickBooks. The CRM tracks leads through your sales process. QuickBooks tracks the financial outcome. Together, they show the full picture.

No automated attribution

QuickBooks relies on manual input. Someone has to ask “How did you find us?” and someone has to select the right lead source on every invoice. There’s no call tracking, no form integration, and no automatic tagging.

Manual attribution is better than no attribution. The data won’t be perfect — some customers won’t remember how they found you, and some invoices will get tagged incorrectly. But 80% accuracy on marketing attribution is infinitely more useful than 0% accuracy.

No website visitor tracking

QuickBooks tracks customers who’ve already bought from you. It can’t track who’s visiting your website, browsing your service pages, or researching your company before they pick up the phone.

95-97% of your website visitors leave without becoming a customer. QuickBooks never sees them. Your Google Ads spend drives traffic to your site, but QuickBooks only captures the 3-5% that converts into a phone call and a booked job.

Website visitor identification fills that gap by matching anonymous visitors to real homeowner identities. Those identified homeowners can be reached through direct mail, phone outreach, or targeted follow-up — and when they book a job, you tag the lead source in QuickBooks and track the full ROI.

Making QuickBooks tracking a habit

The Monday morning review

Set a recurring 15-minute block every Monday morning to review your marketing data in QuickBooks. Pull your revenue by lead source for the previous week. Compare it against your marketing spend for the month to date.

This weekly review keeps marketing decisions grounded in data rather than gut feeling. When a vendor calls pitching a $500/month advertising package, you can pull up your QuickBooks data and compare their projected cost per lead against what your current channels actually deliver.

Quarterly budget reallocation

Every 90 days, run a full marketing ROI analysis using your QuickBooks data. Compare cost per booked job, average revenue per job, and total revenue by channel. Reallocate budget from underperforming channels to channels that produce higher returns.

Contractors who track marketing ROI — even with basic tools like QuickBooks — spend 23% less on marketing while generating the same or higher revenue, according to a 2024 analysis by the Small Business Administration. The savings come from cutting channels that produce activity but not revenue, and doubling down on channels where every dollar produces a measurable return.

Your QuickBooks data combined with upstream marketing attribution from your CRM creates a complete view of where your jobs come from and what they cost to acquire. You don’t need enterprise software to make data-driven marketing decisions. You need the discipline to tag every invoice and review the results weekly.