Global Mobility Reporting
Adding work locations for global workers and fetching corresponding vesting data relevant for tax purposes is possible with Ledgy’s Global Mobility feature.
Global tax mobility is the concept of tracking taxes owed across countries in the event an employee resides in multiple countries over the duration of their vesting schedule.
This article explains the required steps to use global mobility reporting within Ledgy, the current configured global mobility reports and feature limitations.
Stakeholder work locations
On the “Stakeholders page”, one can manage work locations for stakeholders.
Currently, there are two options for adding stakeholder work locations:
Add work locations for individual stakeholders
Create or edit existing stakeholder
Navigate and expand the “Location history” section
Add effective work location start dates for relevant countries
Add work locations using stakeholder bulk edit in Excel
Click the “Bulk” edit button
In the bulk edit card, select the “Work location” Excel export template
Click “Download work location file”
In the exported Excel sheet, the following actions are supported:
Adding a single work location
For a given stakeholder row, add the effective work location date and country code
Adding multiple work locations
Duplicate the given stakeholder row and add the effective work location date and country code
Edit
Update existing values
Remove
Remove a row that contains populated work location fields
Once all changes have been applied, upload the relevant Excel file within the bulk edit card
Global mobility reports
Once stakeholder work locations have been added, one can view and export Ledgy’s global mobility reports.
Currently, we support three pre-configured reports relevant for global mobility reporting:
Reports the location history grouped by stakeholder
Reports for each grant, all vesting tranches and corresponding work location history overlap where each vesting tranche period is based on its tranche start date
Reports for each grant, all vesting tranches and corresponding work location history overlap where each vesting tranche is based on the vesting start date (or grant date)
Stakeholder work locations
Navigate to Reports > Global mobility > Select: Work locations
The report shows the full location history of all stakeholders that have work location added in Ledgy
Highlights
Country
Location start
Location end
Location days
Location percentage over the
Ratio = location days / total duration in days since the first work location was registered
Vesting tranches
Navigate to Reports > Global mobility > Select: Vesting tranches
The reports shows the overlap of each vesting trance for a given grant to the stakeholder’s registered work locations.
Only vesting trances that overlap with a work location are reported in the grid
Each work location period is defined as the “Location start date” until and not including the next “Location start date”
“Location end date” is the date before the next “Location start date”
Each vesting tranche period is defined as the “Tranche start date” until and not including “Tranche vest date”
Highlights
Location days (overlapping the corresponding vesting tranche period)
Location % (overlapping the corresponding vesting tranche period)
Ratio = Location days / Total vesting period days
Vested per location
Vested per location = Tranche amount * (Location days / Vesting tranche days)
Accrued vesting tranches
Navigate to Reports > Global mobility > Select: Accrued vesting tranches
The reports shows the overlap of vesting start, “Date”, until a given “Tranche vest date” for a given grant to the stakeholder’s registered work locations.
Only vesting trances that overlap with a work location are reported in the grid
Each work location period is defined as the “Location start date” until and not including the next “Location start date”
“Location end date” is the date before the next “Location start date”
Each vesting tranche period is defined as the “Date” (Grant date or Vesting start date) until and not including “Tranche vest date”
Highlights
Location days (overlapping the corresponding vesting tranche period)
Location % (overlapping the corresponding vesting tranche period)
Ratio = Location days / Vesting tranche days
Vested per location
Vested per location = Tranche amount * Location days / Vesting tranche days
Feature limitations
Stakeholder work locations
Only support adding country name as stakeholder work location. Currently, we don’t yet support adding more granular work location information such as state level information.
Global mobility reports
Only support reporting on work location overlap per vesting tranche. Currently, we don’t yet support more taxable events such as grant or award date, exercise or sale
We currently don’t support any country specific logic.