All work

Internal estimating tool

Turn customer documents into a structured estimate that an accounting team can review and export.

My role
Concept, workflow design, and development
Built for
An accounting team in manufacturing
Status
Used internally

The problem

Where the work gets complicated.

An estimate brings together customer requirements, dimensions, quantities, and business pricing rules. Working across documents and spreadsheets makes that information difficult to keep together as a request changes.

The approach

Build around the process.

I designed and built an application around the team’s estimating process: read the customer files, organize the required information, apply business rules, and keep the result available for review before export.

The workflow

From the first input to a useful result.

  1. 01

    Read the request

    Bring customer documents into the estimating workflow and extract the information needed for an estimate.

  2. 02

    Review the details

    Check dimensions, materials, and quantities. Resolve missing information before relying on the result.

  3. 03

    Prepare the estimate

    Apply business pricing rules and calculations, then review the estimate before exporting Excel or CSV output.

What it makes possible.

The accounting team uses the tool as a regular part of its estimating work. The application brings the request, calculations, and review into one workflow.

Where people stay involved.

Human review remains part of the process. Customer information and company pricing rules are not included in the public demonstration.

See the workflow for yourself.

The interactive example recreates a small part of the workflow using fictional requests and illustrative pricing.

Explore the technical approach
  • Document extraction feeds a structured review step, rather than treating extracted text as a finished estimate.
  • Business rules and calculations are separated from the interface so the workflow can be maintained as requirements change.
  • Excel and CSV outputs fit the team’s existing document workflow.
  • Document processing
  • Business rules
  • Human review
  • Excel / CSV

Does your team have a similar challenge?

We can start with one task, understand how it works today, and agree on a manageable first improvement.