Receipt of waste spreadsheet upload errors, caught before you upload
If your receipt of waste spreadsheet keeps coming back refused, it is almost never the whole file, it is a handful of rows with one field wrong. Skiplog's receipts export screen is built to find those rows in the yard, hand you a file of only the rows that pass, and point each held row at the note behind it.
Why the sheet comes back refused
You pick the dates, download the sheet, open Defra's receipt of waste service, upload, and it is refused. The message names a row number, not a load you remember. So you are reading a spreadsheet backwards, counting columns to work out which ticket row 14 was, while the reporting window on that load carries on running.
The rows that fail are rarely exotic. A weight copied off a weighbridge ticket in the wrong unit. A container count nobody filled in, because the paper note never asked for one. A permit or carrier number typed with a space in the middle. One field, on one note, and the batch sits there until somebody finds it.
The awkward part is where that work happens. The error is reported at the upload, but the fix lives back in the yard's records, and the person reading the error is usually not the person who wrote the ticket. Skiplog is built to move the check earlier. Before the file leaves the office, the receipts screen checks each row against the rules the upload applies and says which loads in your date range are ready to go and which are not, and the download only carries the ready ones.
How the receipts export works
- Open the receipts screen next to the quarterly return
The receipts export sits beside the quarterly EA return, so the two reporting jobs live on the same shelf instead of in two different systems.
- Pick the dates the batch covers
Choose a date range, a week, a few days, whatever you last reported up to, and Skiplog gathers the loads your site took in over that period.
- Read the ready count before you download anything
The screen splits the range into rows that will pass and rows that will not, so you know the state of the batch while you are still sitting at the desk.
- Follow a held row back to its load
Each row that fails links through to the note it came from, so instead of a row number you have the load in front of you, with its carrier, waste and weight.
- Export in the template's column order
The file comes out with the receipt rows in Defra's template column order, so there is no reshuffling of headings before you upload.
- Upload it, with the held rows accounted for
The export takes only the rows that pass and tells you how many it held back, so the count you upload is a count you can reconcile against the day's tickets.
What changes when the check comes first
The refusal lands at your desk, not in Defra's service
A bounced upload is not just a wasted trip to the browser, it is reporting time spent on a load that was never going to go through. Knowing the state of the batch before the download turns that into a job you finish in the office.
No spreadsheet archaeology
Nobody counts columns to work out which ticket a row number refers to, and nobody has to be the person who wrote the note to understand what is being asked for.
You can say how many loads are still outstanding
A batch with two held rows reads as a batch with two held rows. That is a figure the yard can put next to the day's tickets, rather than a file that may or may not have gone in whole.
Receipt reporting lives with the records
The export works from the notes already in Skiplog and sits next to the quarterly EA return, so receipts are one more screen in the same system rather than a second one to learn.
What this does, and what stays with your yard
Skiplog produces the receipt rows in the template's column order and holds back the ones that would fail. Your yard uploads the file to Defra's service, under your own sign-in, and keeps the confirmation. We are not a submission service standing between you and the regulator, and we do not pretend to be one.
It follows that two things stay yours. The first is the accuracy of what gets typed: if a weighbridge ticket says the wrong weight, a check on the shape of the row cannot know that. The second is the template itself, which belongs to Defra and can change. Skiplog is built to help your site meet the reporting requirement and to make a held row easy to find before the file goes anywhere. It cannot promise an enforcement outcome, and any software that tells you otherwise is selling you something it does not own.
Skiplog is on a waitlist while we finish, and it is being built for the yards the mandate is hardest on: one site, a handful of staff, no compliance clerk, and the same rules as an operator fifty times the size.
Questions
Why does my receipt of waste spreadsheet upload keep failing?
In practice it is one field on one load rather than a broken file: a quantity in the wrong unit, a required box left empty because the paper note never asked for it, a reference typed with a stray space. Because the refusal is reported against a row, the hard part is working out which ticket that row was. Skiplog's receipts screen is built to run that check before you download, so the failing load is named up front.
Does Skiplog upload the receipts to Defra for me?
No. It gives you the receipt rows in Defra's template column order and holds back any row that would fail, ready for your yard to upload. The upload, the sign-in and the confirmation stay with you.
Can I export the failing rows anyway if I want to look at them?
The export is built to take the rows that pass, and to tell you how many it held back. The held rows are listed on the screen with a link each to the note behind them, so the route is to correct them and export again rather than to send a sheet you already know will bounce.
Is this the same as the quarterly EA return?
No, they are two separate jobs and Skiplog keeps them side by side. The quarterly return is a one-click CSV in an EA-specified column layout. The receipts export is for reporting the loads you take in, in the column order Defra's spreadsheet expects.
What if Defra changes the template?
The template belongs to Defra, so a change to it is a change we follow rather than control. That is also why we write about helping your site meet the reporting requirement instead of guaranteeing a compliance outcome: the accuracy of your own records and the regulator's own format sit outside the product.
How much will it cost, and can I try it first?
Two plans, both with every feature and both with a 60-day free trial: Annual at £1,188 a year, which works out at £99 a month, and Monthly at £129 a month. Receipt-of-waste rows ready for Defra's spreadsheet are included on both. Skiplog is not open yet, so the way in today is the waitlist.