![]() These can be compared to rows of other Tracking Categories and Tracking Categories Levels and they can contain both Actuals, Budgets and Variances as well as Reforcecasts, Revenue, COGS, Expenses Profit and Margin %. ![]() The examples at the head of the article show multiple columns of Tracking Categories and Options and Tracking Category Levels. If for example you have 6 Cost Centre tracking options and you want to report on these in Xero then you will need to create 6 budgets in Xero and define 6 Profit & Loss reports, each filtering for the particular tracking category option.įor more complex situations such as Divisional reporting the BI4Cloud solution can provide more extensive flexibility and capability. However you cannot have multiple columns of Tracking Categories or have their Budgets in columns nor can you use Tracking Categories Actuals and Budgets in Group Totals.įor simple situations this functionality may be adequate but if there are many Tracking Category values it can become difficult to maintain budgets and reports. You can then select a Budget column to appear in the Profit & Loss in Xero by selecting the name of Tracking Category Budget. A Profit & Loss for Tracking Category "Event" Option "King Lear". The Profit and Loss reports in Xero can be setup to run for one or more Tracking Category and Tracking Option eg. Scanton, Miami, North, South, East) and then the user can enter budget figures for each GL account and period in Xero. In Xero you can enter an Overall Budget or Budgets by Tracking Category.Ī tracking category budget is created by entering a budget description, selecting the Tracking Category ( eg Event, Venue, Cost Centre) and then choosing which Tracking Option it is for ( eg. The video below shows how to use several of these options in action. This permits reporting by all the transaction dimensions in various formats including Pivot or Filter by each of the Tracking Categories. Once refreshed Bi4Cloud provides reporting of these tracking categories in all reports. In Xero you can rename existing Tracking Options to take advantage of the BI4Cloud Virtual Header feature but you will need to force a Full refresh of the data to BI4Cloud for it to take effect. Tracking Categories are then allocated in Xero to each line of each Transaction. Using BI4Cloud you can even create Virtual Header Levels of Tracking Options using a ' - ' in the names and have up to 4 levels. ![]() In our example we've created one Tracking Category for Events and one for Venues. Tracking Categories are setup within Xero in Accounting > Advanced > Tracking Categories
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |