Tracking Summary

The Tracking Summary Report generates a list of your tracking options showing activity in a particular group of accounts for a specific time period.

To get accounting report data from Xero you need to be logged in into Xero. Then you need to select from the menu Add-ons -> G-Accon for Xero -> Get Accounting Reports -> Tracking Summary.

Select Tracking Summary option from the drop down menu. G-Accon for Xero provides the ability to set up the Date Range for your data manually or you can refresh your data dynamically. Date range suggestion is not to exceed 365 days.

Tracking Summary Report

You have the ability to set up the Date Range (To and From) dynamically. The report data will be calculated based on the selected Date Range.

You also have the ability to set up the Date Range (To and From) statically. The report data will be calculated based on the selected Date Range.

There are required and optional attributes for the Tracking Summary report:

  1. Accounts (account names)
  2. Column Titles (optional)
  3. Tracking Categorie

You have the ability to select the desired accounts or you can select all of the accounts. You can choose what columns needs to be in your report by selecting items in the Columns Titles.

And the most important you have ability to select tracking categories and tracking options. Activity will only display for an option if transactions have been assigned to an account.

If there are transactions occurring in the account group chosen that were not tracked, these are displayed as Unassigned.

Opening and Closing balances are displayed for each category option across all accounts used by that option based on the date range. The balances are based on the financial year to date for revenue and expense based accounts and a balance of all transactions for asset, liability and equity based accounts.

Net activity shows the outcome of all approved transactions (except purchase orders and quotes) in and out of the accounts belonging to the account group.

As usual G-Accon for Xero provides Optional features that might be useful for your business for both reports.

Accounts

You have the ability to select only Tracking Category and any Tracking Category Options:

Xero provides Optional features that might be useful for your business.

This image has an empty alt attribute; its file name is image-366.png
Pull Settings


Change Pull Settings allows you to perform the following operations:

  1. Create a new Google Sheet
  2. Display Report Title
  3. Create Deep Link to Xero
  4. Display only account codes
  5. Keep Original Formatting
  6. Remove total/summary rows
  7. Retrieve headers
  8. Create a data Table around pulled data
  9. Freeze Data Table Header
  10. Exclude Auto Refresh
  11. Display report summaries
  12. Remove empty dividing rows

You can also provide the start cell, for instance, A11. And provide the name of the template in Template Name field, for instance, Template #1.

To schedule the auto Refresh, you can use option Schedule a Refresh. The important to remember this settings will take effect only if the master auto refresh process in turned on. See the Automation process explanation.

This image has an empty alt attribute; its file name is image-367.png
Schedule a Refresh


To execute the process, click on the “Execute” button. The Tracking Summary details will be populated on the Google Sheet.