What Freelancers Should Track in Spreadsheets

What Freelancers Should Track in Spreadsheets

A spreadsheet is often the right first system for a freelancer. It is cheap, flexible, and easy to change while you are still figuring out what your business needs.

The problem is not using a spreadsheet. The problem is tracking too little, tracking the wrong things, or building a sheet that only makes sense when you are the one staring at it.

If you are a freelancer, side hustler, consultant, photographer, lawn care operator, handyman, cleaner, or small service business owner, here is what your spreadsheet should actually track.

1. Client name and contact details

Start with the basics. Every row should make it obvious who the work is for.

Track:

• Client or customer name
• Email or phone number
• Company name if relevant
• How they found you
• Notes about the relationship

This helps you see which clients come back, which ones refer other people, and which ones create the best work.

If you already have repeat clients and ongoing jobs, this is where a simple job profitability tracker starts becoming more useful than a blank sheet.

2. Job or project name

Do not only track money by client. Track it by job.

A client can have one great project and one bad one. If everything is grouped together, you lose the lesson.

Track:

• Job name
• Service type
• Start date
• Due date
• Status
• Notes about scope

For example, a photographer might track "wedding package," "mini session," and "editing add-on" separately. A lawn care operator might track mowing, cleanup, mulch, and seasonal work separately.

3. Price quoted

Always track what you quoted before the job is done.

This gives you a record of your pricing decisions. Later, you can compare the quoted price against actual costs, actual time, and whether you would take that job again.

Track:

• Quoted price
• Deposit required
• Final price
• Discount, if any
• Reason for the price

This is where many freelancers start seeing the real problem: they are busy, but some jobs are not priced well enough.

4. Payment status

A completed job is not the same thing as a paid job.

At minimum, your spreadsheet should show:

• Not invoiced
• Invoiced
• Partially paid
• Paid
• Overdue

Also track:

• Invoice date
• Due date
• Amount paid
• Amount still owed
• Payment method

If you often wonder who still owes you money, you probably need a better payment tracking habit or a tool that keeps payment status tied to the job itself.

5. Expenses and job costs

Revenue does not tell you whether the job was profitable.

Track costs that belong to the job:

• Materials
• Supplies
• Travel or mileage
• Subcontractors
• Platform fees
• Payment processing fees
• Rentals or special tools
• Shipping or delivery

Do not wait until tax time to think about costs. Tax categories are useful, but they do not always tell you which job was underpriced.

For recurring work, job-based expense tracking is one of the fastest ways to improve pricing.

6. Hours worked

Even if you do not bill hourly, track your time.

Hours help answer the real question: was this job worth it?

Track:

• Estimated hours
• Actual hours
• Admin time
• Travel time
• Revision or rework time

A $500 job that takes 3 hours is very different from a $500 job that takes 18 hours.

This is why SideTrack focuses on profit and time together instead of only revenue.

7. Profit estimate

Your spreadsheet should calculate a simple profit estimate.

A basic version:

Revenue - job costs = estimated profit

A better version:

Revenue - job costs = profit, then compare profit against hours worked

You do not need perfect accounting precision to learn from your work. You need a consistent way to compare jobs.

If you want the structure without maintaining formulas forever, compare SideTrack vs spreadsheets.

8. Job source

Track where the job came from.

Examples:

• Referral
• Google
• Facebook
• Instagram
• Repeat client
• Marketplace
• Local group
• Word of mouth

This helps you see which channels create profitable jobs, not just leads.

9. Follow-up date

Many freelancers lose money by failing to follow up.

Track:

• Quote follow-up date
• Payment follow-up date
• Repeat work reminder
• Review/testimonial request
• Referral opportunity

A follow-up column turns your spreadsheet from a record of the past into a simple operating system.

10. Notes and lessons learned

The notes column is where your future pricing gets smarter.

Write down:

• What went well
• What took longer than expected
• What you forgot to charge for
• What the client asked for after the quote
• Whether you would take this job again

This is one of the most valuable parts of tracking. The point is not just cleaner records. The point is better decisions.

A simple freelancer spreadsheet layout

If you are starting from scratch, use columns like this:

• Client
• Job name
• Service type
• Status
• Quote date
• Due date
• Quoted price
• Final price
• Amount paid
• Payment status
• Job costs
• Hours worked
• Estimated profit
• Job source
• Follow-up date
• Notes

That is enough to start. Do not make the sheet so complicated that you stop using it.

When a spreadsheet is enough

A spreadsheet is probably enough if:

• You only have a few jobs per month
• You enjoy maintaining formulas
• You rarely forget payments or expenses
• You do not need repeatable reporting
• You are still figuring out what to track

When to move beyond the spreadsheet

You may need something more structured when:

• You repeat the same tracking every week
• You worry formulas are wrong
• You cannot quickly see unpaid jobs
• Costs are disconnected from jobs
• You do not know which services are profitable
• You want job-level profit without rebuilding reports

That is the exact gap SideTrack is built for: more structure than a spreadsheet, less weight than full accounting software.

Start with the Spreadsheets comparison, or look at the core features for job profitability, payment tracking, expense tracking, and the product cost calculator. If you want an industry-specific path, see the freelance business tracker or job profitability tracker.

Bottom line

Freelancers should track more than revenue.

Track the job, client, price, payment status, costs, hours, source, follow-up, and lessons learned.

That gives you the information you need to answer the question that matters most: which work should I do more of, and what should I charge next time?