Add IF (Conditional) Formulas to Xero Reports for Corporation Tax Calculations
Currently, Xero’s report builder does not support conditional logic (e.g. IF, MIN, MAX), which limits the ability to automate common financial calculations such as corporation tax.
I propose adding support for conditional formulas within reports, enabling users to apply tiered logic based on values such as operating profit.
Use Case: Corporation Tax Automation (UK)
Users should be able to define logic such as:
If operating profit is below £50,000 → apply 19%
If operating profit is between £50,000 and £250,000 → apply 19% on the first £50,000 and 26.5% on the remainder
If operating profit exceeds £250,000 → apply a flat rate of 25%
This feature would significantly enhance the flexibility of Xero’s reporting engine and align it more closely with real-world accounting requirements, particularly for advisors and businesses needing dynamic calculations.
Steven Brewer
shared this idea
Thanks for submitting your idea on Xero Product Ideas. We appreciate you taking time to let us know how we could improve Xero for you.
Your feedback will soon be reviewed by our Community team, and in the meantime this can begin to build support with votes from other community members.
If you're interested to see recent releases or get a pulse on what's coming soon see The Long and Short of it. 🙂