Quotation follow-ups, email routing and invoice processing
What could automation look like in the working day of a small business? These three fictional scenarios show how familiar tools such as Outlook, Excel and PDF documents could work together. They are illustrative examples, not completed client projects or reported results.
Follow up quotations without chasing separate lists
- Outlook
- Excel
- Calendar
The starting point
A small installation business sends PDF quotations through Outlook and tracks them in Excel. The owner discusses pricing and availability with customers.
The recurring work
A colleague searches sent emails, checks for replies and adds diary reminders. During busy periods, follow-ups slip or a reminder is sent while a conversation is already under way.
Before: handled manually
- 1
Find the quotation in sent emails
- 2
Check replies and update the spreadsheet
- 3
Remember which customers need a call
After: supported by automation
- 1
Record the quotation
Once sent, the customer, quotation reference and agreed follow-up date are recorded in the tracker.
- 2
Check its status
When the follow-up is due, the workflow checks for a linked reply and whether the quotation is still open.
- 3
Prepare the next step
For an open quotation, a calendar task and a draft Outlook follow-up are prepared.
- 4
Update the record
After review, the reply or contact is recorded; closed quotations receive no further reminders.
Where your judgement matters
You review the draft before it is sent. Pricing changes, negotiations and ambiguous replies remain your responsibility; uncertain matches are flagged rather than assumed.
The practical benefit: A clearer view of outstanding quotations and a consistent follow-up routine, without repeatedly checking the same emails and lists.
Classify email enquiries and give each one a clear owner
- Outlook
- Shared mailbox
The starting point
A small maintenance business receives quotation requests, appointment changes and invoice queries in one shared Outlook inbox.
The recurring work
Colleagues read the same messages, forward them internally and ask who should respond. Enquiries without a clear owner can be overlooked or answered twice.
Before: handled manually
- 1
Read each email to identify the subject
- 2
Forward it and ask who will handle it
- 3
Check later whether anyone has replied
After: supported by automation
- 1
Identify the enquiry
Each incoming message is given a suggested category: quotation, appointment, invoice or other.
- 2
Assign responsibility
Agreed routing rules assign the message to a colleague and label it in Outlook.
- 3
Prepare the response
The colleague receives a brief summary and, where appropriate, a draft reply or calendar task.
- 4
Track the outcome
The assigned colleague handles the enquiry; outstanding messages remain visible in the shared overview.
Where your judgement matters
Ambiguous emails, complaints and messages covering several subjects go to a colleague for judgement. Replies are checked before sending; the workflow does not make commitments on your behalf.
The practical benefit: Clearer ownership and fewer internal handovers, making it easier to keep customer enquiries moving rather than lost between colleagues.
Process PDF invoices and documents without retyping
- Outlook
- Excel
The starting point
A small trading business receives supplier invoices as PDF attachments in Outlook. An administrator enters the details into Excel and saves the files in a shared folder.
The recurring work
Supplier names, invoice references, amounts and due dates are entered repeatedly. File names vary, and duplicate invoices are not always easy to spot.
Before: handled manually
- 1
Open each PDF and find the details
- 2
Retype amounts and dates into Excel
- 3
Rename the file and check for duplicates
After: supported by automation
- 1
Collect the document
A PDF attachment from the agreed inbox is queued for processing.
- 2
Extract the details
The supplier, invoice reference, date, VAT and total are proposed as an entry in Excel.
- 3
Flag discrepancies
Missing fields, possible duplicates and inconsistent amounts are highlighted for review.
- 4
Approve and file
Following human approval, the tracker is updated and the PDF is saved with a consistent file name.
Where your judgement matters
The administrator compares the extracted details with the original PDF and checks VAT and amounts. Poor scans, credit notes and discrepancies are reviewed separately. Posting invoices or making payments requires explicit approval.
The practical benefit: Less repeated data entry, more consistent document records and a clearer view of items awaiting review.
Questions about putting automation into practice
Can I keep Outlook, Excel and my existing accounting software?
Often, much of your existing software can stay. I first check the versions, permissions and available features. Not every package can exchange information directly, so any limitations or necessary changes are discussed before work begins.
What happens when an enquiry or document is unusual?
We agree which cases can proceed and which need a person to review them. An unreadable PDF, an ambiguous enquiry or an unexpected amount can be flagged and paused. Uncertainty should lead to a review, not an unchecked action.
How is a workflow introduced into the business?
We start with one defined process, map the current steps and agree who is responsible. We then test routine cases and exceptions using suitable sample data. The workflow is introduced only after joint review, with guidance for the team and an agreed approach to monitoring and resolving issues.