At Mbrella, we're committed to making your mobility management as integrated and seamless as possible with your existing HR tools. That's why our calendar feature allows you to import your calendar data directly into Mbrella. This ensures that commuting allowances are only paid for actual office attendance days, aligning perfectly with your day-to-day operations and keeping your allowances in check.
Here’s why you’ll love this update:
No more guesswork: import non-office days like holidays, sick leaves, or any other absences into Mbrella. If they're not at the office, they're not on your dime for commutes.
Fraud prevention: With automatic disabling of non-office days in the Commute Planner, there’s no chance of accidental or fraudulent km claims. Already created trips will get automatically deleted as well.
Effortless import: Just export your calendar file from your time registration tool, put it in our template format and upload it to Mbrella. In seconds, watch your calendar align with real employee presence. Or automate the import via our SFTP server.
How it works
You can import calendar data in two ways:
Set up recurring uploads to our SFTP server
Use the Import Calendar button on Mbrella Web
💡 Tip: While we also offer a Public API for user synchronization, this file import method provides a convenient alternative.
File structure and requirements
Basic specifications
Format: Monthly .xlsx file
Content: Three main columns
payroll_id | event_date | event_type |
123456 | YYYY/MM/DD | WEEKEND |
123456 | YYYY-MM-DD | PUBLIC_HOLIDAY |
123456 | YYYY-MM-DD | IN_OFFICE |
123456 | YYYY-MM-DD | HOMEWORKING |
123456 | YYYY/MM/DD | DAY_OFF |
123456 | YYYY-MM-DD | NOT_IN_OFFICE |
Supported event types (in priority order) ❗
IN_OFFICE (calendar open)
HOMEWORKING (accepts home working allowance)
WEEKEND (calendar closed)
PUBLIC_HOLIDAY (calendar closed)
DAY_OFF (calendar closed)
NOT_IN_OFFICE (calendar closed)
Important things to know
Full-day events only
You control which days to import (both in-office and not-in-office)
No period limitations - import any timeframe
Only dates included in your file will be processed
Multiple events on the same day? System follows the priority order above
Calendar events override existing registrations ❗
Example: A bike trip registered on a newly marked not-in-office day will be automatically deleted
How to get started
Prepare your file:
Follow our template format
Include relevant event types
Provide your time registration codes to Mbrella
Choose your import method:
SFTP: For automatic recurring uploads
Manual: Via the Import Calendar button (Note: Button visibility depends on your account plan)
Homepage>Employees>Add Employees>Import Calendar
What's next
Need SFTP setup details? Check our SFTP file exchange documentation
Need help with your calendar synchronization? Our support team is here to assist! 🤝