video1.0<iframe src="https://www.loom.com/embed/3eb3560ab91f434f9dbe423ca2ee1737" frameborder="0" width="2294" height="1720" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>17202294Loomhttps://www.loom.com17202294https://cdn.loom.com/sessions/thumbnails/3eb3560ab91f434f9dbe423ca2ee1737-88411737928adaa0.gif134.959This Loom demonstrates importing time and attendance data from BrightHR, processing it with smart formulas, and uploading results to Xero. It keeps an October date range and shows a couple of employees, James and Oliver Grey, with the system pulling data live and summarizing start times, end times, and a type indicating breaks. The validation step checks the data against Xero and applies rules to calculate ordinary time with breaks removed, overtime across days, and different casual rates for Oliver Grey. When ready, the user clicks upload and 21 lines are uploaded to a single pay run, with breaks deducted automatically and pay items created in Xero.