Reporting receipt of waste: spreadsheet or connected software?
GOV.UK's guidance on reporting receipt of waste names two ways to get a load into Defra's service: you upload Defra's spreadsheet, or connected software sends the records across for you. For a skip yard or transfer station with one to twenty staff the spreadsheet is usually the practical route, provided something fills it from the loads you have already recorded.
The two routes GOV.UK names
GOV.UK's guidance on reporting receipt of waste sets out two ways to get a load into Defra's waste tracking service. The first is Defra's spreadsheet: each load goes on their template, with their columns in their order, and someone at your yard uploads the file. The second is software that sends the records across for you with no file to hand over, the route the guidance calls the API, and Defra publishes a list of software providers whose products work that way.
The records Defra ends up with are the same either way. What differs is who does the sending, when it happens, and how much the yard has to change to suit the route. That is the whole of the decision in front of you, and it is worth a few minutes rather than a few weeks.
Why the spreadsheet suits a yard with one to twenty staff
A two-truck firm meets the same rule as a national operator and pays a far larger share of its income to meet it, which is the reasoning small sites keep running into. The spreadsheet route asks for nothing to be built: Defra publish the template, your yard uploads the file, and the timing stays with the person who knows which loads came in.
The real cost of the spreadsheet route is not the upload. It is the typing. Thirty loads a day keyed a second time off weighbridge tickets is somebody's afternoon, and it is where a handwritten error turns into a row Defra will not take. So the question to ask of any product, whichever route it reports by, is simple:
- Does it hold every field Defra asks for on a load, captured once?
- Does it produce the rows in Defra's column order, or does the office reformat them?
- Does it suit a yard your size at a price you would sign off?
Answer those three and the route tends to decide itself.
From the weighbridge ticket to Defra's template
- Record the load once, at the weighbridge
A digital transfer note on a mobile or tablet with the fields the Environment Agency requires on it, waste type, European Waste Catalogue code, quantity, carrier details and destination, completable in under two minutes.
- Pick the dates you are reporting
On the receipts screen you choose a date range rather than hunting through a pile of tickets. The loads you recorded in that window are the rows that go out.
- Export the rows in Defra's column order
The export lays the rows out in the order Defra's template expects, so there is no reformatting and no retyping between your register and the file.
- Upload the file in your own time
Your yard uploads to Defra's service, so the decision about when a batch goes sits with the person who knows the loads. The two working day clock and what to do with a rejected row are covered on their own pages.
What that changes in a small office
One keying, not two
The load is recorded at the weighbridge, and the file Defra wants is an export from those records rather than a typing session in the office on Friday.
No per-load limit to watch
Both plans cover one site with unlimited waste transfer notes and unlimited tracked registrations, so a busy month does not change the bill.
The records stay yours
Everything is kept while the account is open, readable and exportable, because waste records have to span quarters and inspections. A lapsed trial does not lock them away.
Questions
What are the two ways to report receipt of waste?
GOV.UK's guidance names two. The first is the spreadsheet: each load goes on Defra's template and someone at your yard uploads the file. The second is connected software that sends the records across for you, with no file involved, the route the guidance calls the API. The information Defra ends up with is the same, so the choice is about who does the sending and what that asks of your yard.
Can I use my own spreadsheet instead of Defra's?
Not for the upload. The service expects Defra's template, with its columns in its order and its headings spelled its way, so a sheet you built for the office will be refused however good the data in it is. That is why a yard with a perfectly tidy sheet still ends up retyping every load. The receipts export page sets out exactly what the exported file contains and the column order it uses.
Does the connected software route need a developer?
Only if you intend to build the connection yourself, which is a software project rather than a purchase. The usual path is to buy from a provider that has already written it, which is what Defra's provider list exists to help with. For a site with one to twenty staff the useful test is not whether that route sounds more modern, it is whether a product fits a yard your size at a price you would sign off.
When does uploading a spreadsheet stop being practical?
It stops being practical at the point where the typing becomes the job. One upload a week with a handful of loads on it is a ten minute task. Thirty loads a day keyed in a second time from weighbridge tickets is a person's afternoon, and it is where handwritten errors creep in. The fix is usually not a different route, it is stopping the second keying, so that the file is an export rather than a typing session.
Will the spreadsheet route be withdrawn?
Nobody outside Defra can tell you that. GOV.UK's guidance on reporting receipt of waste is the page to watch, and it is worth a look each quarter rather than once a year. The practical hedge is to keep the loads themselves in a system that holds every field Defra asks for, rather than in the uploaded files. If the route ever changes, the records are still complete and still exportable.
Does being on Defra's provider list mean the software is approved?
Defra publishes a list of software providers for reporting receipt of waste, and being listed means a product works with the service. It is not a quality mark, and it says nothing about whether a product suits a two-truck yard. Judge a product on what it does at your weighbridge and what it charges. Skiplog is written to help you meet the reporting requirements, which is not the same as guaranteeing an outcome that also depends on what you record.
What does Skiplog do with the loads I record?
It captures each load once on a mobile or tablet with the fields the Environment Agency requires, then turns a date range on the receipts screen into rows in Defra's template column order for your yard to upload. The register keeps those records while the account is open, readable and exportable, so the same load does not get typed twice and the file is not a separate piece of bookkeeping.
What happens if a row is wrong?
A rejected row matters because the clock on the load keeps running while you work out which one it was. Two sibling pages cover that ground: one on catching upload errors before you send the file, and one on what to do when Defra rejects a load, including the fresh deadline a rejection notice sets. The page on the two working day limit explains the timing those pages depend on.