A sales order tracker doesn’t have to be complex. Six columns and consistent updates are all you need. This minimal approach scales from zero orders to 100+ without becoming unwieldy.
The Core Six Columns
Create a table with these headers: Client Name, Order Date, Project, Amount, Status, Follow-Up Date. That’s it. A solo freelancer can track an entire business in six columns. This simplicity is deliberate. Fewer columns mean you’ll actually use the tracker.
Client Name is self-explanatory. Order Date marks when the agreement was made. Project is a two-word description so you remember what it is. Amount is the total contract value. Status is one of three: Active, Completed, or Paid. Follow-Up Date is when you next contact the client. Six fields capture what matters while staying simple enough to update weekly without friction.
Status Simplicity
Limit status to three options: Active (work ongoing), Completed (delivered, waiting on payment), Paid (money received). Too many statuses create confusion. These three answer what matters: Is work happening, is it done but unpaid, or is it over? Simple status means updating your tracker takes 10 seconds per order.
Add a rule: Every Friday, update all statuses. If a project finish date was Monday and it’s now Friday, move it to Completed. Simple discipline prevents data rot. Make it a ritual: Friday at 3pm, open your tracker and spend 10 minutes updating. This habit keeps your pipeline visible.
The Follow-Up Date Trigger
The Follow-Up Date is your system’s engine. Every morning, scan your tracker. Any order with a follow-up date matching today gets your attention. Today is May 28? Find all May 28 dates. Send those follow-ups.
Set follow-up dates strategically. Proposal sent on May 1 gets a follow-up for May 8. Project due May 20 gets follow-up for May 22 to check status. Payment due May 29 gets follow-up June 5 to chase payment. This one column structures your entire sales rhythm.
When to Graduate to Software
Stick with this tracker until you hit 100+ open orders or updates become a chore. At that point, consider software that automates the updates. Waco3 removes the discipline requirement by automatically tracking dates and flagging follow-ups.
For a freelancer with 10-20 active orders, this simple tracker serves well for years. Its simplicity is its strength.
Optional Columns for Extra Insight
Once the core six columns feel natural, consider adding optional ones: Client Email (for quick lookups), Project Type (lets you filter by service category), Notes (capture win/loss reasons), and Revenue by Month (rolling total of expected income).
Don’t add these columns until they solve an actual problem you’re experiencing. Start simple. Complexity comes later if you need it.
The best tracker is the one you’ll actually use. Simple beats sophisticated.
Ready to send stronger proposals?
Build, send, and track proposals in one place so follow-up is easier.
Start your free trial →
