Skip to content
← Reports & tax

Enter your idea

Reports & tax: Reporting

Categories

Balance Sheet Tracking Categories

Xero has tracking categories for Profit & Loss reporting.
Our single entity charity uses tracking categories to produce a profit and loss report by fund where the fund type is an option within a fund category.
We need the same for the balance sheet to produce a balance sheet report by fund on an ongoing basis.
For example, income and expenditure transactions on a bank account can be tracked, but not the bank account balance itself. Ditto for liability accounts etc.
This would also need a tracking option/field on manual journals.

3 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Allan Revers shared this idea  ·   ·  Report…  ·  Admin →
Existing functionality  ·  AdminDavina Roper (Admin, Xero) responded  · 

Thanks for raising this and Im happy to say this functionality is already available in Xero. You can use tracking categories and options to report on your Balance Sheet by fund, in addition to using tracking for Profit and Loss reporting.

To view the Balance Sheet by fund:

  1. Set up your fund type as a tracking category, with each fund as a tracking option.
  2. Ensure the relevant transactions are assigned to the appropriate fund.
  3. Open the Balance Sheet report and use the tracking filter to select the required fund.

When creating a manual journal, you can also select the relevant tracking category and option on each journal line. This allows the journal entries to be included in reporting for the appropriate fund. Tracking is also available when importing manual journals using the tracking fields.

Please note that some system accounts, such as bank, accounts receivable and accounts payable accounts, may have restrictions on direct manual journal entries. Xero uses the Tracking Transfers account to help keep the Balance Sheet balanced when it’s filtered by tracking.

You can find further guidance in Assign tracking options to transactions, Add, import and post manual journals 😊

Show previous admin responses (2)
Comments are closed An error occurred while saving the comment
  • David Spacey commented  ·   ·  Report

    I'd very much support the need for Xero to provide a Balance Sheet split by tracking category / charitable fund.

  • Laura Catlett commented  ·   ·  Report

    I need this too. I have a parent-child subsidiary, but the sub is not wholly owned by the parent, so I need separate balance sheets, but they share the same bank account. Since Xero is driven by the bank reconciliation, not journal entries, I need to use one client company and utilize a tracking category for the sub, and the tracking options to track different P&L elements within each entity. What is the work around? I'm setting up these two companies, but when writing a manual journal entry to reclass conversion balances between the two entities, and it does not appear to be possible. I ran all this by the "expert" before I started, have an email with his instructions. He never told me the last step, the manual journal entry, isn't possible. Yes, Please. Tracking Categories need to have the ability to be used for the entire financials, not just P&L.