Multiorganization Reports
Background: We are a chapter-based organization with almost 50 chapters. Each chapter is a 501(c)3 organization and uses Xero as its accounting software, meaning each one is treated as an individual organization in Xero.
Every week, as the PM, I need to report on the health of each individual chapter. Currently, this process involves me manually switching into each organization's dashboard, checking if their bank is synced, identifying any unreconciled transactions, and recording the date of the oldest unreconciled transaction. This currently costs me ~1.5 hours per week.
Purpose: A report that would allow users the ability to extract KPIs from multiple organizations that they manage.