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).
Related resources
Replies (5)
Please login or register to join the discussion.
Thanks - I'll take a look at DataDear.
I don't think its possible to do in Xero reports as far as I can tell (i.e. you can have Tracking Category as a column vs a rows of accounts, but not a rows of accounts AND tracking categories vs columns of periods).
We use Data Dear for exactly that sort of thing, however I would be interested to hear if there are any other tools / Addons we could use?
I used to use the Excel add-in from Quick Win Developments but they changed their pricing model and I see its now become this:
https://www.flexfinancialreporting.com/
There is a free option although I haven't looked at its scope.
By the way, any 3rd party add-on will be constrained by the Xero API. In this case it is likely to need to query the Journals entity (and join to Accounts if you must have Account Description) and make a pivot table to give you multiple period columns.
Which begs the question, how many Tracking Categories are there, and how often do you want to do this? If only a few you could download individual P&Ls and aggregate them in Exccel.
