Skip to content
All workflows

Finance & documents01

Stop typing the same document into another system.

Turn a batch of quotations, invoices or purchase orders into a checked import workbook for the accounting tool you already use.

Illustrative workflow · Fictional sample records, not a delivered client project or measured result.

Follow the change

From incoming information
to something usable.

An employee opens a document, copies its header, then enters every item again. Repeat that across a backlog and a small typing task becomes days of work. Automate the reading, mapping and checking between the source and the import.

Switch between the source and the checked result. The sample shows what the software would organise, calculate or flag.

Batch 026Fictional example
Compare the incoming information with the checked output
What arrivesBatch 026

Two files. Two layouts.

What arrives: Two files. Two layouts.
SourceItemRate
INV-104BR-12 · 24 pcs£12.00
INV-105CT-08 · 10 pcsNot shown
TemplateDifferent columnsMap again

A missing price is unknown, not automatically zero.

Checked outputBatch 026

One workbook. Each invoice separate.

Checked output: One workbook. Each invoice separate.
InvoiceItem codePrice
INV-104BR-12£12.00
INV-105CT-08Review price
Source linksAttached to rowsRetained

Review the flagged price, then export the checked file.

Source retainedChecks appliedPerson reviews

Less repeated work

Remove line-by-line re-entry and repeated column mapping.

Earlier checks

Missing prices, repeated document numbers and unmatched item codes.

01 / The starting point

What comes in.

  • Source PDFs or spreadsheets
  • The destination's current import template
  • Existing item codes and customer or supplier records

02 / The useful result

What comes out.

A reviewed workbook with separate document numbers and a source reference for each line. Quotes, invoices and supplier orders use their own templates.

The work behind the result

What runs, and who checks.

  1. Document processingRead the batch once
    Software handles
    Extract headers and item lines while retaining the source file, page and document identity.
    People check
    Check low-confidence readings against the original.
  2. Accounts or purchasingMatch and check the lines
    Software handles
    Map the supported template, suggest existing items and flag missing prices or duplicate document numbers.
    People check
    Resolve ambiguous matches. Confirm any genuinely included, zero-priced item.
  3. AccountsExport, import and reconcile
    Software handles
    Create the workbook and retain a record of the exported documents.
    People check
    Import into the destination and compare its accepted documents, quantities and totals with the batch.

When the straightforward path breaks

A row has no price.

The reader can extract a valid item and quantity without finding a price. Silently changing that blank to zero makes a clean-looking file with the wrong commercial meaning.

Show the source beside the row. Keep the value unresolved until someone supplies a price or confirms the item is included.

The review point

A person makes the call.

Confirm uncertain readings, item matches and missing values before importing. A prepared workbook is not evidence that the accounting system accepted it.

How to know it helped

Measure the actual work.

Time a matched batch from opening the first source to accepted import. Count corrected cells, rejected rows and duplicate documents as well as minutes.

Start with a real example

Bring the work you keep doing twice.

A recent job and its documents are enough to start. We trace the repeated steps, check where mistakes enter and define a useful first build around your existing tools.

Discuss this workflow