Keep the system. Take manual work out of the reporting workflow.
A care organisation used Shiftbase but assembled its own reports from multiple exports. AYAL built a connected application that retrieves data, performs calculations and brings it together in usable Excel reports.
Assemble it all again.
- Export multiple files
- Combine data and calculate
- Check the results and prepare reports
Select. Generate. Continue.
- Choose the period and filters
- Generate the report
- Preview and download Excel
Personnel and time data
Selection, calculations and report assembly
Excel reports for the organisation’s administration
One place for the work around the numbers.
Generate reports
Process timesheets, rosters, plus/minus hours and correction history into Excel reports with multiple sheets, tailored to the organisation’s administration.
Handle corrections
Alongside reporting, the application supports processing batches of corrections in Shiftbase, giving follow-up work a defined workflow too.
Look up contracts
Find contract details and contract history in the same application when a result needs more context.
Extend the tools around the work.
The brief was a reporting workflow tailored to the organisation’s administration. Shiftbase remains the source system; the connected application uses its API to retrieve data and perform agreed actions. AYAL designed and built the integration, processing and user interface.
From editing files to requesting a report.
The user chooses the selection and receives an assembled report. Repeatedly combining exports and calculating results by hand is removed from this reporting workflow. Attention can move to reviewing and using the result.
Is your team still doing manual work between existing tools?
Tell us which data you need and which steps take time today. We can explore what your existing software already supports and where a focused addition would help.
Discuss your workflowAutomation & integrations