What columns should a sales order tracking Excel template include?

At minimum: Client Name, Service Type, Date of First Contact, Proposal Date, Proposal Value, Status, Follow-Up Date, and Notes. Useful additions: Close Probability (%), Actual Close Date, Invoice Amount, Payment Received Date. The most important column for freelancers is Status—every row needs a current status so you can instantly see what needs action.

Is Excel or Google Sheets better for sales tracking?

Google Sheets is generally better for freelance sales tracking because it's accessible from any device, automatically saves, and can be shared with a bookkeeper or assistant if needed. Excel is fine if you prefer it and don't need multi-device access. The template structure is identical—copy it into whichever tool you prefer.

When should I replace my Excel tracking with a real CRM or proposal tool?

When you're spending more than 30 minutes per week updating the spreadsheet, when proposals are slipping through because the manual system is too slow, or when you're sending more than 10 proposals per month. A dedicated proposal tool with automatic status tracking saves time and reduces errors at that volume.

Sales Order Tracking Excel Template: Free Download and Setup

A sales order tracking Excel template for freelancers should include columns for: Client Name, Service, Proposal Date, Proposal Value, Status (Lead/Sent/Viewed/Accepted/Declined), Follow-Up Date, Invoice Sent, Invoice Paid, and Notes. Keep one row per opportunity. Review weekly. The template works best when it’s simple enough that you actually maintain it—complexity is the enemy of consistent use.

The simplest sales tracking system that gets used consistently beats the most sophisticated system that gets ignored. Here’s a practical Excel template for tracking freelance proposals and orders, with the columns that matter and the ones to skip.

Before building a complex tracking system, consider what you actually need to answer from it: Which proposals are outstanding? Which follow-ups are overdue? Which invoices haven’t been paid? A well-structured spreadsheet answers all three in about 30 seconds per week.

The core template structure

Here’s the column set that covers most freelance sales tracking needs:

Column A: Client Name The company or person name. Enough detail to identify the prospect.

Column B: Service / Project Type What you’re selling. Useful for filtering and for analyzing which service types close at higher rates.

Column C: First Contact Date When did this lead enter your pipeline? Helps you track average time-to-close and identify prospects who’ve gone cold.

Column D: Proposal Sent Date When did you send the proposal? Used to calculate how long each opportunity has been in the pipeline.

Column E: Proposal Value The estimated or proposed project value. Important for prioritizing follow-ups—a $10K proposal that’s stalling deserves more attention than a $500 one.

Column F: Status The most important column. Use consistent shorthand: L (Lead), PS (Proposal Sent), V (Viewed/Opened), N (Negotiating), A (Accepted), D (Declined), IP (In Progress), INV (Invoiced), P (Paid).

Column G: Follow-Up Date When is your next scheduled follow-up for this prospect? Filter by this column every Monday to see who needs attention.

Column H: Invoice Amount The actual invoiced amount (may differ from proposal if scope changed).

Column I: Invoice Sent Date When was the invoice sent?

Column J: Payment Received Date When was it paid? Blank means outstanding.

Column K: Notes Anything relevant: key client contact, decision-maker name, competitor mentioned, special pricing.

How to use it weekly

The weekly review takes 10–15 minutes:

Open the spreadsheet
Filter by “Follow-Up Date” = today or earlier. These need action.
Scan all rows with Status = PS (Proposal Sent) and no follow-up in the last 5 days. Add a follow-up date.
Check all rows with Status = INV and Payment Received Date = blank. If overdue, initiate a payment follow-up.
Update any statuses that have changed since last week.
Close out declined or dead opportunities by changing status to D and moving them to an archive sheet.

Color-coding the Status column makes the weekly review faster. Use green for Accepted/Paid, yellow for Sent/Viewed/Negotiating, red for Overdue/Stalled. At a glance, you can see the health of your pipeline without reading every row.

Setting up the spreadsheet in Google Sheets

Open Google Sheets and create a new sheet named “Pipeline”
Add the column headers in Row 1 (freeze this row so it stays visible when scrolling)
Create a second sheet named “Archive” with the same headers
In the Status column, use Data Validation (Data menu → Data validation) to create a dropdown with your status codes—this prevents typos and keeps data consistent
Format the Follow-Up Date and Proposal Sent Date columns as dates
Add conditional formatting to the Status column: green fill for A/P, yellow for PS/V/N/IP, red for overdue (you can flag overdue by comparing Follow-Up Date to today)
Create a simple summary at the top: COUNTIF formulas showing count of each status type

Sample formulas

Count active proposals: =COUNTIF(F:F,"PS")+COUNTIF(F:F,"V")+COUNTIF(F:F,"N")

Total pipeline value: =SUMIF(F:F,"<>D",E:E) (sum of Proposal Value where status isn’t Declined)

Close rate: =COUNTIF(F:F,"A")/(COUNTIF(F:F,"A")+COUNTIF(F:F,"D")) (Accepted divided by Accepted + Declined)

Overdue follow-ups: =COUNTIFS(G:G,"<"&TODAY(),F:F,"<>A",F:F,"<>D",F:F,"<>P") (follow-up dates in the past that aren’t closed)

When to upgrade

This spreadsheet approach works well up to about 15–20 active proposals at a time. At higher volumes, manual updates become error-prone. Signs you’ve outgrown the spreadsheet:

You’re updating it less than weekly because it feels like work
You’ve missed follow-ups because the spreadsheet wasn’t current
You want automatic notifications when proposals are opened
You want proposal-to-invoice conversion in one step

At that point, a dedicated proposal tool that auto-updates status when proposals are sent, opened, and accepted—and that converts accepted proposals to invoices without re-entering data—is worth the monthly cost.

Ready to send stronger proposals?

Build, send, and track proposals in one place so follow-up is easier.

Start your free trial →