How to sync your calendar data with Mbrella?

Need to keep track of your employees' office presence? Learn how to sync your calendar data with Mbrella using our file template system. Whether you choose to use our SFTP server for automatic uploads or prefer manual imports, we've got you covered. 💼

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) ❗
1. IN_OFFICE (calendar open)
2. HOMEWORKING (accepts home working allowance)
3. WEEKEND (calendar closed)
4. PUBLIC_HOLIDAY (calendar closed)
5. DAY_OFF (calendar closed)
6. 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! 🤝

Import your payroll export to SD Worx (mysdworx)