Skip to content
cairnscale

Discuss a project

Workflows & reporting

Follow a job across the spreadsheet, inbox and software that share it. Find where someone still has to put it right.

Worked example

Order reconciliation

One edition for the whole team

The guide for visitors exercise follows a document from competing copies to an approved edition, an owner and a check. Bring an invented document when discussing a similar workflow.

Everyday workflows

CRM implementation or rebuild

Configure agreed stages, access, import rules and ownership. Include operator training.

What you should be able to do
A team can track enquiries, stages and follow-up
How we would check it
Sample enquiry completes its lifecycle. Restricted user and deduplication tests pass.
Start with this question
At which stage do leads tend to lose their owner?
Discuss this scope

Build a project brief online

CRM, spreadsheet and workflow integration

Deliver one integration with logged exceptions, repeat-safe processing, owner training and an acceptance test.

What you should be able to do
One reliable handoff between two systems
How we would check it
A valid and rejected case produce the agreed result. Retries do not duplicate the destination action.
Start with this question
Which field does someone copy between tools every day?
Discuss this scope

Build a project brief online

Customer support inbox routing and knowledge drafting

Connect one approved support inbox, classify known issue types and route exceptions for human handling.

What you should be able to do
Queries reach the correct person with a useful draft response
How we would check it
Incorrect or uncertain routing falls back to a reviewer. Sensitive entries are kept within approved destinations.
Start with this question
Which enquiries get passed around before anyone answers?
Discuss this scope

Build a project brief online

Enquiry and onboarding automation

Connect one intake channel, validation, assignments and confirmation.

What you should be able to do
Incoming requests reach the right owner with usable context
How we would check it
Valid, invalid and duplicate requests are exercised. Handovers and human exception reviews are demonstrated.
Start with this question
What should happen in the minute after an enquiry arrives?
Discuss this scope

Build a project brief online

Inbound call routing and appointment intake

Configure approved inbound call handling, staff escalation and optional consented transcription.

What you should be able to do
Callers can reach a person or leave an actionable request
How we would check it
Escalation and unanswered-call scenarios pass. Client approves recording notices, retention and human fallback.
Start with this question
Which callers need to reach a person straight away?
Discuss this scope

Build a project brief online

Invoices, approvals and back-office automation

Implement an agreed approval path or read-only export with a reviewable exception queue.

What you should be able to do
Staff spend less time transferring and checking records
How we would check it
Totals and status reconcile across agreed sources. No posting or external action occurs without the agreed approval.
Start with this question
Which exception stops an otherwise routine approval?
Discuss this scope

Build a project brief online

Managed automations and workflow support

Monitor agreed workflows, report exceptions and reserve time for change requests.

What you should be able to do
A named person owns recurring workflow reliability
How we would check it
An injected test failure triggers the agreed escalation. Monthly report includes timeliness, exception rates and open actions.
Start with this question
Which recurring job do you still check by hand each morning?
Discuss this scope

Build a project brief online

Spreadsheet to internal application

Model the approved rules, import a clean sample, build a small internal app and document migration.

What you should be able to do
An ageing spreadsheet becomes a controlled workflow
How we would check it
Fixture totals match the agreed spreadsheet baseline. Concurrent changes and user roles behave as specified.
Start with this question
Which rule in your workbook is hardest to explain to a new starter?
Discuss this scope

Build a project brief online

Work scheduling and capacity optimisation

Model agreed constraints for people, stock, time or transport, and supply an explainable plan.

What you should be able to do
The buyer can compare feasible schedules and see trade-offs
How we would check it
Test schedules satisfy the agreed hard constraints. The buyer can reproduce the baseline comparison.
Start with this question
Which constraint makes your schedule unravel first?
Discuss this scope

Build a project brief online

Workflow automation diagnostic

Map one process, build a demonstration with approved sample material, measure effort and specify the implementation.

What you should be able to do
A measured baseline and a costed improvement plan
How we would check it
Buyer confirms the baseline and scope. Demo meets a named acceptance criterion.
Start with this question
Which job feels slow even though each individual step is quick?
Discuss this scope

Build a project brief online

Data and reporting

Data cleanup, matching and deduplication

Profile an agreed source, define match rules, produce exception and rollback files.

What you should be able to do
The buyer gets one traceable, cleaner working dataset
How we would check it
Merge precision is measured on a reviewed sample. The buyer can undo and audit merges.
Start with this question
Which duplicates are expensive to merge by mistake?
Discuss this scope

Build a project brief online

Database migration and reconciliation

Inventory schemas, migrate a bounded dataset, reconcile counts and test rollback and downtime.

What you should be able to do
The new store holds complete, testable records
How we would check it
Counts and sampled values reconcile. A dry run and rollback are recorded before cutover.
Start with this question
Which totals must match before you can sign off a migration?
Discuss this scope

Build a project brief online

Invoice and bookkeeping reconciliation support

Match approved payment and invoice exports and produce exceptions for the bookkeeper to review.

What you should be able to do
The owner can review mismatches with source evidence
How we would check it
Matched and unmatched totals reconcile to supplied exports. Buyer or bookkeeper approves corrections and any posting.
Start with this question
Which reference is usually missing from an unmatched payment?
Discuss this scope

Build a project brief online

Operational dashboard and metric design

Agree definitions and views, connect approved sources, and deliver an editable dashboard.

What you should be able to do
Owners can reconcile a useful set of metrics
How we would check it
Sample metrics reconcile to named sources. Dashboard access and refresh behaviour are tested.
Start with this question
Which figure starts a debate every time the dashboard opens?
Discuss this scope

Build a project brief online

Reliable reporting and scheduled exports

Build approved recurring imports and exports with schema checks, provenance and alerts.

What you should be able to do
A scheduled dataset arrives with known quality
How we would check it
Replay produces one correct output. Missing or changed source schema raises a visible alert.
Start with this question
Which report still depends on someone remembering to press export?
Discuss this scope

Build a project brief online

Spreadsheet modelling and operational calculators

Build an editable model for agreed operational inputs and scenarios with test cases and instructions.

What you should be able to do
Owners can test assumptions and trace figures
How we would check it
Independent fixtures reproduce the headline calculations. Assumptions, limits and inputs are visible to the buyer.
Start with this question
Which decision would you like to try before changing the real plan?
Discuss this scope

Build a project brief online

Document workflows

Accessible PDF and document remediation

Improve tagging, headings, tables, reading order and alternative text in a bounded document pack.

What you should be able to do
Readers can navigate and understand an agreed document with assistive tools
How we would check it
Keyboard or screen-reader checks cover representative pages. Buyer receives editable source and a record of remaining issues.
Start with this question
Which document should someone be able to navigate without seeing its layout?
Discuss this scope

Build a project brief online

Document redaction and redaction QA

Use a documented redaction policy and independently verify the output and metadata before customer sign-off.

What you should be able to do
Approved information is removed from a release copy
How we would check it
Sample sensitive spans are absent from rendered and extracted outputs. Reviewer signs off release copy and residual risks.
Start with this question
Which information must be removed before a document changes hands?
Discuss this scope

Build a project brief online

PDF data extraction and conversion

Extract an agreed set of fields from supported document types and report exceptions.

What you should be able to do
A checked dataset links fields to source pages
How we would check it
Fixture fields match reviewed ground truth. Rejected pages and retention limits are visible to the buyer.
Start with this question
Which fields do you need and which exceptions should go to a person?
Discuss this scope

Build a project brief online

Private invoice and document processing pilot

Define one document type and test material, agree the hosting and review workflow, and qualify the service before live intake.

What you should be able to do
A source-linked result with clear exceptions
How we would check it
Synthetic inputs produce source-linked values. Reviewer, export and deletion paths are exercised.
Start with this question
Which invoice field would make a sample trial worthwhile?
Discuss this scope

Build a project brief online

Private transcription and meeting notes

Use approved recordings, agreed retention and transcript review. The customer authorises use and processing.

What you should be able to do
Recordings turn into searchable text and reviewed actions
How we would check it
Speaker and timestamp quality meet the sampled acceptance target. Audio and transcript retention are verified.
Start with this question
Do you need a transcript, a decision record or both?
Discuss this scope

Build a project brief online

Searchable bundles and document assembly

Prepare bookmarks, pagination and indexing against agreed rules. Authorised reviewers own any legal or regulatory submission.

What you should be able to do
An ordered pack is easy to navigate and review
How we would check it
Index and page count reconcile to the source set. A named client reviewer approves the required format.
Start with this question
Which item in a typical pack takes longest to find?
Discuss this scope

Build a project brief online

Access and oversight

Data mapping and technical privacy controls

Document data flows and implement agreed retention, deletion and access controls. Legal sign-off stays with the buyer.

What you should be able to do
Owners can explain where information goes and how to remove it
How we would check it
Data flow and subprocessor inventory are approved. Export and deletion are verified on synthetic records.
Start with this question
Which copy of a record is hardest to account for?
Discuss this scope

Build a project brief online

Marketing operations

B2B opportunity research and qualification

Research agreed buyers or public tenders, recording source, fit, exclusions and next actions.

What you should be able to do
Sales teams get a shortlist backed by public sources
How we would check it
Every entry has a source, timestamp and qualification reason. Data checks exclude suppressed recipients and unsupported claims.
Start with this question
Which condition would make you walk away from a tender early?
Discuss this scope

Build a project brief online

Tender and bid production support

Map requirements to evidence, organise draft responses and assemble the pack for buyer approval.

What you should be able to do
A bidder has an editable document pack and compliance matrix
How we would check it
Requirements matrix links to the source specification. Bidder approves claims and submits the final pack.
Start with this question
Which part of the bid still lacks a supporting document?
Discuss this scope

Build a project brief online

Training and handover

Fractional technical and automation support

Agree a retained capacity block, priorities, operating review and escalation boundary.

What you should be able to do
An owner has a technical partner with measurable commitments
How we would check it
First review sets baseline and named priorities. Monthly outcome and capacity readback goes to the owner.
Start with this question
Which recurring decision needs a second pair of hands?
Discuss this scope

Build a project brief online

Agreeing the work

Choose the outcome and the checks that matter. A written quote sets the scope, exclusions, price basis, review allowance, ownership and handover. Additional work or ongoing support needs agreement before it starts.

Tell us what needs to work

The start and end of one task, who owns it and an invented example of what goes wrong.

We work entirely online. A description is enough to start. Keep records, credentials and attachments for the transfer method we agree.

Start an email enquiry

Build a project brief online

Enquiry privacy ยท hello@cairnscale.uk