Share this content

Customised TB in Xero (or tool using Xero data)

Customised TB (or P&L) report - by account code AND tracking category

Didn't find your answer?

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).

Customised Xero TB
Chris Jones
 

Replies (5)

Please login or register to join the discussion.

avatar
By johnt27
19th Nov 2020 12:44

Use DataDear, A N Other reporting app or edit the P&L reports in Xero

Thanks (1)
avatar
By joneschrisuk
19th Nov 2020 13:15

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).

Thanks (0)
avatar
By BigBadWolf
26th Feb 2021 11:13

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?

Thanks (0)
A Putey FACA
By Arthur Putey
26th Feb 2021 11:31

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.

Thanks (0)
A Putey FACA
By Arthur Putey
26th Feb 2021 11:55

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.

Thanks (0)
Share this content