Power BI / Xero Financial Reporting Consultant

Afid; United Kingdom; Hybrid; GBP 92,000 - 138,000; Part time

Job summary

Afid is seeking a focused short-term consultant to automate financial reporting for a UK charity by integrating Xero data into Power BI, replacing manual downloads and the existing Excel dashboard.

The engagement covers requirements gathering, data transformation, secure Xero-Power BI connections, dashboard development with key metrics, automated refresh, testing, documentation and handover to the finance team.

Remote or hybrid in the UK, start early 2027, approximately 5–10 days.

Qualifications

• Experience in Power BI dashboard development and Xero integrations.
• Strong background in management reporting and KPIs.
• Automation of financial reporting processes.

Responsibilities

• Requirements gathering and dashboard design based on existing Excel dashboard and KPI needs.
• Configure secure Xero-to-Power BI connection and data extraction.
• Develop Power Query and data models to cleanse and consolidate Xero data.
• Build an interactive Power BI dashboard mirroring and enhancing current reports (income/expenditure, balance sheet, cash flow, KPIs).
• Configure automated data refreshes, security permissions and validation controls.

Skills

Power BI dashboard development

Xero integrations

Xero API

Power Query

Data modelling

Management reporting

Tools

Power BI

Xero

Power Query

Job description

A focused short-term consultancy for a Power BI / Xero specialist to help a growing UK charity automate financial reporting and turn finance data into clearer, faster management insight.

Our partner is a UK charity entering a new phase of growth and looking to strengthen how financial information is captured, reported and used for decision-making.

The organisation currently uses Xero for finance and has an existing Excel-based financial dashboard, with reports downloaded manually from Xero. They are now seeking an experienced consultant to help automate this process by integrating Xero data into Power BI, where the organisation already holds wider organisational performance dashboards. The aim is to create a more efficient, reliable and timely financial reporting process, reducing manual downloads, spreadsheet manipulation and the risk of reporting errors.

Scope of work

The consultant will support the organisation with the following:

• Requirements gathering and dashboard design: review the existing Excel-based financial dashboard, reporting requirements, KPIs & source reports currently downloaded manually from Xero.
• Xero data integration: configure a secure connection between Xero and Power BI, using the Xero API or an appropriate approved connector, to automatically extract the financial data and reports required.
• Data transformation and modelling: develop Power Query and data model structures to cleanse, transform, validate and consolidate Xero data into a format suitable for reporting and analysis.
• Power BI dashboard development: build an interactive Power BI dashboard that replicates and enhances the existing Excel dashboard, including key financial metrics, income and expenditure reporting, balance sheet, cash flow and management KPIs.
• Automated refresh and governance: configure scheduled data refreshes, security permissions and data validation controls to support accurate, up-to-date reporting and reduce reliance on manual report downloads.
• Testing, documentation and handover: carry out user acceptance testing, resolve any issues, document data sources and refresh processes, and provide knowledge transfer to finance team users and administrators.

Person specification

This opportunity would suit a consultant with strong experience in:

• Strong systems/IT skills including Power BI dashboard development, Xero integrations, Xero API or approved Xero connectors, and Power Query and data modelling
• Management reporting, financial KPIs and dashboard design
• Financial reporting automation
• Documentation, training and handover to finance users
• Timing: Expected to start in early 2027
• Estimated input: Approximately 5–10 days, subject to consultant review
• Location: Remote / hybrid in the UK depending on availability and project needs