How I automated the mid-month BIK proration nightmare in Xero

[Suseendaran]

I’m an engineer and accountant, and like many here, I’ve been frustrated with how Xero Payroll handles Benefits-in-Kind (BIK). Specifically, when an employee joins or leaves mid-month, or changes a car/medical plan, Xero doesn't automate the HMRC proration logic.

I ended up building a tool via the Xero API that does the math and syncs the benefit lines in seconds. I'm curious—for those managing UK payroll, how are you currently handling mid-year P11D changes? Are you still stuck in Excel, or have you found a better workaround?