Codesets - Reporting Extra
Save hours on reporting with a Codesets Module that transforms data automatically.
Convert information into multiple formats for funders or regulators—making submissions like MHSDS quick, accurate, and stress-free.
Charities often need to provide the same information in different formats depending on who’s asking — whether it’s funders, regulators, or partners.
The Codesets part of the Reporting Extra module takes the hassle out of this process by automatically transforming your data into the formats required.
Built into your existing database, it saves hours of manual work, ensures accuracy, and makes submissions like MHSDS quick and straightforward.
How it can help
Save time by transforming your data into multiple sets without manual re‑entry.
Essential for achieving MHSDS submissions swiftly and accurately.
Reduce admin workload by automatically reshaping data into the formats others require.
Use one piece of data in multiple ways, tailored to different reporting needs.
Improve consistency and compliance by standardising outputs directly from your database.
How it works
You tell Lamplight what the codes are that you require and how you want your data presented and we’ll set it up. Once set up, run the reports with a simple click and submit your data via a spreadsheet.
If your funders request changes, you can change the output without changing the original data. It also allows for different outputs with the same data.
* Example scenario *
You are required to provide a list of service users and their gender by a commissioner. However, instead of words, they require you to submit coded data, where ‘01’ means ‘Female’, ‘02’ means ‘Male’, and ‘03’ means ‘non-binary’.
You tell Lamplight what the codes are for each gender option, and then when you run the list, the table now shows ’01’, ’02’, and ’03’ in the Gender column. You can do this for as many fields as you like, with different rules for how the data is translated.
Let us help you
Review the data you are currently capturing and the format one or many different funders need it. Date of birth with different age ranges is a common one!
Set the metrics in place to transform the current data into the format you need.
Create templates so that the reports you need to run are easily pulled from the system in the format you need.
Understand the options so if new requirements arise in the future you’ve the skills and confidence to manage it in-house.
Already a Lamplight user?
To enable the module, go to system admin (you must be a system administrator) > your account > add or remove modules > tick the Reporting Extra Module box to turn it on in your system. Don’t forget to click ‘update my system’ to ensure it’s activated.
Read more and find full guidance on our Reporting Extra Module page.
Ready to tailor your perfect system?
Have a friendly, no-obligation chat with a real person to get all your questions answered.