Skip to content
Dsposal
PaperworkPaperworkIntermediate

Trace and Reports

Follow a record's whole chain from first quote to final invoice, find work that has not been billed, and build, save and export reports from Paperwork

8 min readUpdated 2026-10-26tracechain

Trace and Reports both live under Overview in the sidebar. Use Trace to follow one piece of work from the first quote to the final invoice and see where it stopped. Use Reports to pull data into a spreadsheet.

Trace a record from quote to invoice

Trace shows everything connected to a record in one tree: the opportunity, the sales converted from it, the jobs raised from those, the purchase orders and the invoices and credit notes. You need to be able to view at least one of Sales, Jobs, Invoicing or Opportunities to open it.

Find the record

Click Trace in the sidebar and type into the search box. It searches sales, jobs, opportunities, purchase orders and invoices together, by number, customer, site or supplier — for example a sale number or INV0001. Keep typing if you see "Keep typing to search…". To narrow the search, click + Customer, and then + Site once a customer is chosen.

Narrow by stage if you need to

The strip under the search box counts the opportunities, sales, jobs, purchase orders and invoices in view. Click a stage to search within it, and Clear stage to go back.

Open its chain

Click a result. With the search box empty you can also pick from Where you left off (records you traced before), Newest, or Needs attention — see below.

The page then shows a summary and the tree:

  • Chain counts the records and breaks them down by type.
  • Invoiced shows how much of the chain's value has been invoiced, as an amount and a percentage. It is left out if you cannot see the money.
  • Needs attention appears when the chain has jobs that are Ready to Invoice but not billed. It names the oldest wait and the amount unbilled, and Go to job jumps to it.

In the tree, click a record to inspect it and click an arrow to fold a branch. The panel beside it shows the record's fields and money, with an Open button for the record itself (for example Open Job) and Trace from here to make it the root. A record you are not allowed to see appears as a locked row, for example "Job · you don't have access", so the chain stays whole without leaking its details.

You will find the same tree on the Trace tab of an opportunity, sale, job or invoice.

Fix a gap in a chain

Where a chain stops short, Paperwork adds a row to say so, with a button to take the next step:

RowWhat it meansButton
No invoice raisedA job is Ready to Invoice and nothing has been billedRaise invoice
Not converted yet"Nothing has been raised from this yet — no agreement, and no job."Convert to agreement, then Convert to job
No jobs yet"Nothing has been scheduled from this agreement."Create job

A price list never offers Convert to job or Create job, because a price list cannot raise a job.

Find work that has not been billed

Open Trace with the search box empty and choose Needs attention. It lists every job that is Ready to Invoice, with the customer and site, the value, and how long it has been waiting, plus the number of chains and the total unbilled. It needs both Jobs and Invoicing access. Click a row to open its chain.

Build a report

Click Reports under Overview. Every report is a dataset shown as a card with its name, what one row represents, and how many columns it can give you. Cards are grouped by area — Sales, Jobs, Invoicing, Purchase orders, Customers, Suppliers and Opportunities — and you only see an area if your role can view it. The Opportunities area disappears if your organisation hides Opportunities. If you see "No reports are available for your permissions", ask someone who can manage roles (typically a person with the Paperwork Owner role) for view access to the areas you need.

Choose a dataset

Click a card. The page opens with a filter rail on the left, a preview of the first 50 rows, and the number of rows that match.

Filter the rows

The rail shows only the filters that dataset offers, such as Records (Active, Archived, Deleted or All), Statuses, Departments, Owners, Customers, Suppliers, Hazardous waste or Expiry status. A Date basis picker chooses which date the range applies to, with ready-made ranges such as Last 30 days and This quarter, or your own From and To. Switch on Include records without a date to keep undated rows.

Choose the columns

Click Columns to switch columns, or whole groups, on and off. Reset to default puts them back.

Export

Pick CSV or XLSX, then click the export button beside it. It names exactly what you are about to download, for example "Export 4,212 rows as CSV". It is greyed out, with a tooltip saying why, if nothing matches or no columns are selected.

An export is capped at 500,000 rows. If more match, the button reads "Export first 500,000 of …" and a message tells you to narrow the filters.

Save a report for your team

Click Save report, give it a Name, and click Save. Saved reports appear under Saved reports at the top of the Reports page for everyone in your organisation who can view that data. Anyone who can view that data can click Run to download it, or Open in builder from its three-dot menu to change it. Whoever saved it, or an organisation Owner, can Rename or Delete it. Inside a saved report, Save changes updates it and Save as new keeps the original.

See what each report covers

Sales

  • Sales — one row per sale, with its customer, site, totals and linked documents.
  • Sale waste lines — one row per waste line, with pricing, primary cost, and hazardous and ADR detail.
  • Sale extras — one row per extra, non-waste charge, with its pricing and primary cost.
  • Sale line costs — one row per supplier cost on a sale's waste or extra lines, whether or not it is the cost used for margin.
  • Sale transport parties — one row per carrier or disposal site on a sale, with its registration details and whether that registration is still valid.
  • Sale emails — one row per email recipient, with its delivery status.

The date bases are Created, Issue date, Valid from and Valid to.

Jobs

  • Jobs — one row per job, with its customer, site, transport, booking, totals and linked documents.
  • Job waste lines, Job extras and Job line costs — the line-level equivalents.
  • Deleted jobs — who deleted each job and when, with a link back to it.
  • Waste returns — one row per waste movement, built for your Environment Agency return, with EWC and R/D codes in their EA form and the job's selected disposal site as the receiving facility.
  • Job emails — one row per email recipient, with its delivery status.

The date bases are Created, Requested date, Scheduled start, Waste received date and Status changed. For Status changed, also choose the Status entered.

Invoicing

  • Invoices and credit notes — one row per document, with its customer, lifecycle, totals and linked jobs.
  • Invoice lines — one row per line, waste and extras together, with its pricing, nominal coding and the job it came from.
  • Invoice emails — one row per email recipient, with its delivery status.

Narrow these by status, by invoice or credit note (Invoice kinds), and by customer and site. The date bases for invoices and invoice lines are Created, Invoice date, Due date, Authorised, Sent and Voided.

Purchase orders

Supplier purchase orders, Supplier purchase order lines and Purchase order emails. Purchase orders have no permission of their own, so these reports follow your Jobs access.

Customers, Suppliers and Opportunities

  • Customers, Customer sites and Customer custom lists.
  • Suppliers, Supplier sites and Supplier registrations. The registrations report filters by Expiry status — Expired, Expiring soon, In date or No expiry date — and Within (days) sets your own "expiring soon" window, 30 by default. Last refreshed from EA shows when each registration was last checked against the public register; a blank means it has never been fetched.
  • Opportunities — one row per opportunity, with its stage, value, customer or lead, and any sales it has produced.

Know the two columns that fill in over time

Neither is an error, and neither needs anything from you.

  • Status changed only sees status changes from the day recording began. A job whose status last moved before then will not appear when you filter on that date. Every change since is recorded, so the gap closes as jobs move on. The other job dates cover the full history.
  • Local authority is looked up from the postcode the next time an address is saved. Until then it exports blank on customers, customer sites, suppliers, supplier sites, registrations and sale transport parties. Editing and saving the record fills it in.

What to do next

Keep moving

Next steps

Explore further

Related Guides