Quote Tracking Sheet

What Is a Quote Tracking Sheet?

A Quote Tracking Sheet is a tool used by Australian businesses to monitor the status of price quotes issued to potential clients. Think of it as a "lite" version of a Customer Relationship Management (CRM) system. Instead of paying for expensive software, many Australian tradies and small business owners use spreadsheets in Excel or Google Sheets to manage this process.

This document does more than just list numbers. It acts as a central hub for your sales pipeline. It records who you quoted, how much you quoted, and whether the client accepted the work. For a busy plumber in Sydney or a graphic designer in Melbourne, this sheet is the difference between a profitable month and a mess of lost paperwork.

Under the Income Tax Assessment Act 1997, businesses must keep records of all transactions. A tracking sheet supports this by creating an audit trail that links your initial quotes to your final invoices. It helps you prove your income derivation to the ATO if they ever ask questions.

While the primary purpose is organisational, this sheet also serves as a legal record of offers and acceptances. It helps you manage contract formation timelines and ensures you do not accidentally honour outdated prices. It is a simple but powerful way to stay on top of your business administration.

When to Use This Document

You should use a Quote Tracking Sheet as soon as you start sending out price estimates to customers. If you are in the habit of writing a quote, saving a PDF, and then forgetting about it until the client calls, you need this tool. It is essential for any business that offers bespoke services or variable pricing rather than a fixed retail price tag.

This document is particularly useful for tradespeople, consultants, and service providers. It is vital when you are dealing with high volumes of leads. If you have five active quotes, you might remember the details. If you have fifty, you will struggle without a system.

You should also use this sheet when you need to follow up with clients. Industry practice suggests that many sales are lost simply because the business owner forgot to check in. A tracking sheet reminds you to contact a "cold" lead before they go to a competitor.

Furthermore, use this sheet when you need to analyse your business performance. If you want to know why your conversion rate dropped last month, the data in this sheet will tell you. It helps you spot pricing issues or identify which months are busiest for your specific industry.

Key Sections and Required Elements

To make your tracking sheet effective, you need to include specific columns. These sections ensure you meet your legal obligations while giving you the data you need to run your business.

Quote & Client Identification

This section is about linking your internal records to the actual work. You must include a Unique Quote ID. This should match the reference number on the PDF quote you sent to the client. This makes it easy to find the file later if a dispute arises.

You also need to record Client Details. This includes the client's name, address, and contact information. If the client is another business, record their ABN. Keeping the ABN handy is useful when you eventually raise a tax invoice, as the ATO requires ABNs on B2B invoices.

The Date Issued is a mandatory field. This establishes the timeline for your validity period. It also helps you sort your records chronologically at tax time. Finally, note the Source of the lead. Did they find you on Google, or were they a referral? This helps you decide where to spend your marketing budget next year.

Financials & Validity

This section protects your cash flow and legal standing. You must record the Total Quote Value. This allows you to forecast revenue. It is helpful to have a separate column for the actual cost of labour or materials so you can see your potential margin at a glance.

The Valid Until Date is critical. In Australian contract law, a quote is usually an offer that can be withdrawn at any time before acceptance. However, if you state the quote is valid for 30 days, you are generally bound to that price for that period. Tracking this date prevents you from starting work on a quote that expired three months ago when material prices have since gone up.

Compliance & Privacy

This section is often overlooked but is essential for modern Australian businesses. You need a column for Consent Status. Under the Spam Act 2003, you cannot send commercial electronic messages without consent. Your sheet should track whether the client opted in to receive email marketing or SMS updates from you.

If you handle sensitive information, you might need a Data Classification column. This is relevant for NDIS providers or health services. If the sheet notes that "Sensitive Data" is held, it triggers higher security requirements under the Privacy Act 1988 to ensure that data is encrypted or stored securely.

How to Write a Quote Tracking Sheet (Step by Step)

Setting up a tracking sheet is straightforward. You can build this in Microsoft Excel, Google Sheets, or Apple Numbers. Follow these steps to create a system that works for your business.

Step 1: Create the Framework

Open a new spreadsheet and create your headers across the top row. Use the sections listed above as your guide. Common headers include: Quote ID, Client Name, Date Issued, Description of Work, Total Value, Valid Until, Status, and Follow-up Date.

Step 2: Define Your Status Values

You need a system to know where every job stands. The most effective method is to use a "Status" column with specific drop-down values. Standardise your language to avoid confusion. Recommended values include:

• Draft: You are preparing the quote but have not sent it yet.
• Sent: The quote has been emailed or delivered to the client.
• Open: The client has received it and is considering it.
• Follow-up Required: You need to contact the client to nudge them.
• Accepted: The client has agreed to the price.
• Rejected: The client declined or went with someone else.
• Expired: The validity date passed without acceptance.

Step 3: Enter Data Immediately

Do not rely on memory. As soon as you hit send on an email, enter the details into the tracking sheet. This takes two minutes but saves hours of headaches later. Record the value and the validity date immediately.

Step 4: Set a Follow-Up Schedule

Use the "Follow-up Required" status proactively. If you have not heard back in a week, change the status and flag the date. A simple phone call or email asking if they have any questions can significantly increase your conversion rate.

Step 5: Convert to a Job

When a client accepts the quote, update the status to "Accepted" and record the Date Accepted. This is vital for your records. Once accepted, you can link this row to your Project Management Template or create a formal tax invoice. The tracking sheet then acts as a historical record of the sale.

Common Mistakes to Avoid

Many Australian business owners make errors that can cost them money or get them into legal trouble. Being aware of these pitfalls will help you use your tracking sheet effectively.

Confusing Estimates with Quotes

This is a major source of liability in the trades industry. An Estimate is an approximate price. A Quote is a fixed price. If you record an "Estimate" in your tracking log as a final "Quote," you are creating a binding contract for that fixed amount.

If you charge more than a recorded Quote, you breach the contract. If you charge more than an Estimate, you are usually protected provided the increase was reasonable and communicated. Mislabeling these in your sheet leads to incorrect expectations and potential disputes with fair trading bodies in your state.

Insufficient Data Retention

It is tempting to delete rows from your tracking sheet when a quote is rejected to keep the file clean. Do not do this. Deleting records creates a "gap" in your audit trail. The ATO requires you to keep records for five years. If a client later claims you quoted them a specific price and you have deleted the record, you have no defense.

Inadequate Security

If you use cloud-based software like Google Sheets, be careful with sharing settings. Sharing the tracking sheet via a public link that anyone can open is a breach of privacy obligations. If your turnover exceeds $3 million, or if you work in health sectors, the Privacy Act 1988 applies. You must ensure that client names, addresses, and phone numbers are stored securely and not accessible to the general public.

Ignoring Small Business Thresholds

Many startups assume the Privacy Act does not apply to them because they have a low turnover. However, the exemption for businesses with an annual turnover of less than $3 million has exceptions. If you trade in personal information or are related to a larger entity, the law might still apply to you. Do not assume your data security settings can be lax just because you are a small business.

Legal Considerations (AU)

Running a business in Australia involves navigating specific laws. Your Quote Tracking Sheet is not just a piece of paper; it is a document that interacts with several pieces of Commonwealth and State legislation.

Record Keeping and the ATO

The Income Tax Assessment Act 1997 (Cth) mandates that businesses keep records of all transactions. The ATO requires these records to be kept for five years. Your tracking sheet serves as a subsidiary record to your primary tax invoices and quotes.

It demonstrates the timeline of income derivation. If the ATO audits your business, they will look for a clear link between a quote, an acceptance, and an invoice. A well-maintained tracking sheet makes this audit process smooth and protects you from penalties.

Australian Consumer Law (ACL)

You must be accurate in your pricing. Under the Competition and Consumer Act 2010 (Schedule 2), which contains the Australian Consumer Law, misleading a client about the price is illegal. Your internal sheet must accurately reflect what you told the client.

If you label a price as a "Quote" in your sheet, but sent the client a document labeled "Estimate," you are creating a dangerous inconsistency. If the client relies on that "Quote" and you try to charge more, you could be found to have engaged in misleading or deceptive conduct.

Privacy and Data Security

The Privacy Act 1988 (Cth) regulates how you handle personal information. If your tracking sheet contains client details and your business has a turnover of more than $3 million, you must comply with Australian Privacy Principles (APPs).

Specifically, APP 11 requires you to take reasonable steps to protect personal information from misuse and unauthorised access. This means password-protecting your digital files and ensuring your tablet or laptop is not left unattended in your work van where client data could be stolen.

Spam Act 2003

If you use your tracking sheet to schedule email or SMS follow-ups, you must comply with the Spam Act 2003. You can only send commercial electronic messages if the recipient has consented. Your sheet should record that consent. If a client asks you to stop emailing, you must update their status immediately to remove them from your marketing list.

Contract Formation

Under Australian Common Law, a contract is formed when an offer is accepted. Your tracking sheet is vital evidence of this timeline. By recording the "Date Accepted," you create a clear point of reference for when the work was legally agreed upon. This helps resolve disputes regarding when a contract was binding, referencing principles similar to those in the case of Masters v Cameron.

Frequently Asked Questions

Is a Quote Tracking Sheet legally required in Australia?

No, there is no specific law that says you must have a "tracking sheet." However, the laws that require you to keep tax records (ATO) and privacy records (Privacy Act) effectively make it necessary for good business governance. It is the tool you use to ensure you comply with other legal obligations.

How long should I keep the records for?

You should keep the data from your tracking sheet for at least five years. This aligns with the ATO's requirements for record keeping under the Income Tax Assessment Act 1997. Even if a quote was rejected, keep the record. It proves your business activities and pricing strategies if you are ever audited.

Can I use a paper notebook instead of a digital sheet?

Yes, you can. A physical notebook is a valid record. However, digital sheets are generally recommended for practical reasons. They are easier to search, sort, and backup. If you choose a paper notebook, you must ensure it is secure and not lost or damaged, as you are legally responsible for keeping that data safe and accessible.

Do I need a client's signature on the tracking sheet?

No. The tracking sheet is an internal document. The client does not need to sign it. The client signs the actual Quote Template or the contract. You use the tracking sheet to record that they signed the main document.

What is the difference between a Quote and an Estimate in the sheet?

In your sheet, a Quote must be treated as a fixed price that you cannot exceed without the client's agreement. An Estimate is an approximation. If you record an Estimate, you should flag in your notes that the final price may vary. This distinction is crucial for compliance with Australian Consumer Law to avoid accusations of misleading pricing.