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.
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.
Two files. Two layouts.
| Source | Item | Rate |
|---|---|---|
| INV-104 | BR-12 · 24 pcs | £12.00 |
| INV-105 | CT-08 · 10 pcs | Not shown |
| Template | Different columns | Map again |
A missing price is unknown, not automatically zero.
One workbook. Each invoice separate.
| Invoice | Item code | Price |
|---|---|---|
| INV-104 | BR-12 | £12.00 |
| INV-105 | CT-08 | Review price |
| Source links | Attached to rows | Retained |
Review the flagged price, then export the checked file.
Remove line-by-line re-entry and repeated column mapping.
Missing prices, repeated document numbers and unmatched item codes.
What comes in.
- Source PDFs or spreadsheets
- The destination's current import template
- Existing item codes and customer or supplier records
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.
What runs, and who checks.
Read 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.
Match 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.
Export, 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.
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.
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.
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.
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