QScope

Import a pricing document

Read their spreadsheet without retyping it

A bill arrives as somebody else’s spreadsheet or PDF. QScope reads it on your own machine and rebuilds the arithmetic upward from the items, rather than trusting the totals the file printed for itself.

  • Rows become lines: reference, description, quantity, unit, rate and value
  • Sections are kept, in the order the document had them
  • Read on your own machine, so the pricing never leaves it

30 days free, no card.

Import a pricing document
Import · what the file contained
Lines read42
Sections kept7
Rows skipped as headings9
Value of lines read£2,190,000.00

Every line the reader found is shown before anything is saved, so what enters the job is what you approved.

What comes in

Spreadsheets and PDFs, read as items

The file you receive was built for printing, not for valuing against.

  • Rows become lines: reference, description, quantity, unit, rate and value
  • Sections are kept, in the order the document had them
  • Read on your own machine, so the pricing never leaves it
Import a pricing document
Import · what the file contained
Lines read42
Sections kept7
Rows skipped as headings9
Value of lines read£2,190,000.00

Every line the reader found is shown before anything is saved, so what enters the job is what you approved.

The arithmetic

Rebuilt upward, not trusted downward

A printed total is a claim; the items are the evidence.

  • Quantity times rate is recalculated on every line
  • Section subtotals are recomputed from the lines, not copied from the file
  • A line that does not multiply out is flagged, not silently accepted
Import a pricing document
Import · checks on the way in
Lines that multiply out41
Flagged for review1
Printed total in the file£2,191,300.00
Rebuilt from the items£2,190,000.00

When the file’s own total and the rebuilt total disagree, you see both figures and the lines that carry the difference.

After the import

A bill like any other, with a record

Once the lines are in, the job runs exactly as if you had priced them yourself.

  • Valuations value against the imported lines
  • The original file stays attached to the project record
  • What was changed after import sits in the audit trail
Import a pricing document
Imported bill · in the job
Source filekept with the project
Lines in the bill42
Certified against them£151,719.32
Left to certify£140,048.61

The bill remembers where it came from. If a figure is challenged, the original document is one click away.

See it running before you sign up

Who it is for

Four chairs, one valuation on the table

You are applying

You value it, and the certificate cuts it

You value the work line by line and submit the application. When the certificate lands short, the difference is argued line by line too, and your valuation is the evidence.

Applying for payment
the same measurement

You are certifying

You cut it, and you sign your name

You value the same lines from the other chair and issue the certificate. Every percentage you cut has to survive the question of why, a month or a year later.

Certifying payment

You are doing both

You value your own work, alone

You price it, you value it and you apply for it yourself, between site visits. The certificate still has to add up as if a surveyor had built it.

Doing both yourself

You are reporting

You certify value the lender pays on

You certify value in place so the lender can release the next tranche. The valuation is the same arithmetic; the reader was never on site.

Recommending a drawdown

The client, the architect and the tenderer are not on this list. They are the people you let in on a link: they see the one document you sent them, answer it, and that answer is written into the record. No account, no licence, no charge, on every plan.

FAQs

The questions this page raises most often, answered without a sales pitch at the end.

Spreadsheets and PDFs with a recognisable table of items. The reader shows you every line it found before anything is saved, so a file it reads badly costs you a look, not a corrupted bill.

The document is read on your own machine and only the lines you approve enter the project. The original stays attached to the record for evidence.

That is the point of importing this way. The arithmetic is rebuilt from the items, and where the printed total disagrees with the rebuilt one, both are shown with the lines that carry the difference.

Yes. Enter what has been certified against each line so far and carry on from there. You are not blocked from issuing while the rest of the bill goes in.

From the blog

The part nobody teaches you, written down

Three pieces from the same corner of a contract as this page, answered at length and without a sales pitch at the end.

All 174 pieces

Keep reading

The three parts this page leans on

Bring one priced document in

Take the last bill you were sent, read it in, and compare the rebuilt total with the one printed at the bottom. If they differ, you have learned something worth knowing.

30 days free, no card.

Rather ask first? Write to help@qscope.co.uk and you will get a reply within one working day, Monday to Friday.