The spreadsheet route
A prescribed spreadsheet can transfer DWT data without purchasing dedicated software. The wider process still includes preparing, checking, correcting, submitting and tracking the information.
- No software licence for the spreadsheet route
- Familiar file-based process
- Manual validation and version management remain
Using DWT software
Dedicated software can manage the work around the file, including validation, correction, submission status and exceptions.
- Central visibility
- Controlled correction process
- Submission and exception management
Which route is practical?
The right route depends on movement volumes, number of sites, data quality, existing systems and how much manual administration the organisation is prepared to manage.
How TRACE fits
TRACE can use a structured DWT file as an input, then manage validation, supported corrections, submission and status visibility around it.