How do I track quotations, invoices and payments in one place?
Keep one list with a row per customer deal and a stage: quote sent, approved, invoiced, paid. Review it each week and nudge the stuck ones. A shared sheet is enough for a small business; move to software only when the sheet stops being updated or the list grows too long to read.
Who asks this: An owner of a small Indian business who sends quotes, raises invoices and chases payments in three different places, and cannot say at any moment which deals are waiting on whom.
The steps
1. Define the stages in plain words
Write four or five stages that match how you sell, for example quote sent, approved, invoiced, part paid and paid. Each stage has one clear meaning and one owner. The sales head signs this off, so everyone uses the same words.
2. Make one row per deal
Create a list with the customer, the deal, the amount, the stage, the date it entered that stage and the next action with a date. Move existing quotes and open invoices into it on one afternoon. From then on, nothing lives only in a chat or a notebook.
3. Update the stage the same day
When a quote goes out, an order is approved, an invoice is raised or money arrives, the person involved changes the stage that day. The accounts person owns the paid stage and the sales person owns the others. A list that is a week old is not trusted.
4. Look for stuck rows every week
Sort by the date a row entered its stage. Anything that has sat in quote sent for ten days, or in invoiced for longer than the credit period, needs a nudge. Assign each stuck row to a person with a date.
5. Send the right nudge
A stuck quote needs a follow-up with something useful; a stuck invoice needs a polite reminder with the invoice number and the date. Use the same wording for similar cases so the team does not improvise, and record the reply in the row.
6. Decide when a sheet is no longer enough
A sheet is fine while one or two people update it daily and the list fits on a few screens. Move to software when updates are missed, several people need to edit at once, or you need reminders to go out without anyone remembering.
A worked example
illustrative
A small interior-design studio in Bengaluru handles about fifteen live projects. The partner builds a sheet with a row per project: the client, the quote amount, the stage and the date of the last change. On Friday she sorts by the stage date. Two quotes have waited twelve days, so the designer sends a short follow-up with a revised layout; one client approves the next Tuesday. One invoice of about two and a half lakh rupees has been unpaid for three weeks beyond the agreed period, so the accountant sends a reminder, and the client pays within two days. The sheet shows the studio exactly where money was waiting.
What goes wrong
- Stages are defined differently by each person, so the list cannot be compared.
- The list is updated at month end, so the weekly review is based on old facts.
- Quotes, invoices and payments are in three separate files that never meet.
- Nobody owns the next action, so stuck rows stay stuck.
- Reminders depend on someone remembering, and they stop in a busy week.
- The list grows to hundreds of rows with no archive, and nobody can read it.
How Demystify OS helps
Follow every enquiry to a bookingEarly access
Shows one industry's version of this idea: every enquiry is followed until it becomes a booking, with each stage visible.
See what travellers still oweAvailable
Shows what customers still owe, which is the paid stage of the same list for a travel business.
Weekly summaryEarly access
A weekly summary gives the owner one short read of what moved and what is stuck.
Mysty WorkersEarly access
Mysty Workers can be set up with you to read whatever record you connect, keep a list with a stage for each customer, nudge the stuck stages for your approval and summarise the list each week. A pipeline-register routine is not yet a standard catalogue entry.
What it does not do. Demystify OS does not replace your accounting books or raise invoices from this list; it reads the record you connect and reminds people, and a person confirms every stage change that matters.
Questions people ask
Is a spreadsheet really enough?
For many small businesses, yes. A shared sheet with a clear stage and a next action works as long as it is updated daily and reviewed weekly. The problem is rarely the tool; it is that updates are missed and nobody looks at stuck rows.
What stages should I use?
Use the smallest set that matches how you sell: quote sent, approved, invoiced, part paid and paid is common. Add a lost stage with a reason. Fewer stages make the list easier to keep up to date and easier to read.
How do I keep the team updating it?
Make the weekly review use only this list, and ask each person to explain their stuck rows. When the list is the meeting, people update it. Keep the number of columns small so an update takes under a minute.
When should I move to proper software?
When updates are regularly missed, several people need to work at once, or you need automatic reminders. Before that, a better routine usually helps more than new software. Choose software that matches the stages you already use.
How is this different from my accounting software?
Accounting records what happened for the books. This list tracks the people side: who has the quote, who is waiting on whom and what the next action is. The two should agree on amounts, but they answer different questions.
Apply for the beta.
Demystify OS is invite only, and a person reads every application.
Apply for the beta