Would anyone be able to advise whether it's possible to produce a TB (or P&L) report in the format set out below in Xero (or with a tool using Xero data)?
1) Account code, Account name, Account Type AND Tracking Category - i.e. to split account balance into each category
2) Periods in chronological order (not reverse order)
3) Account balance for P&L accounts being for the period only not cumulative
The data must be in there, but I just can't get at it! The image below is what I'm trying to achieve. I'd like this dataset to be able to drive summary and detailed cost centre reports (which is what I'm using tracking category for).