Asset tracking

Asset tracking is a big deal for me with my trades, technologists, and micro professionals, especially for T2125, but still important on the T2, Sched 8.

Since QBDT and QBO offer a less than ideal solution I track these in a combination of Excel Asset Continuity and OneNote to house capture source docs, notes, and excel asset continuity by year.

During CRA GST Trust Examiner review, the asset reconciliation is always a tempting area in which the Trust Examiner likes to fish to send the client to CRA Audit.

I like my source docs to be complete and easy to access.

I like my Chart of Accounts to be broken down by class with sub-accounts for additions, procedure, and accum amort.

I like my T2 Sched 8 to match my Chart of Accounts.

I like my Excel to show the year over year asset continuity. (Don’t have Casware.)

I add source and destination references into my Excel.

I create annual doc bundles with the Excel continuity and source docs.

I do something similar for high net worth clients with large donations for the donations continuity.

I do something similar for high net worth clients with large donations for the donations continuity on the T1 side.

Just wondering, based on the category of this post (“Suggestions”), whether I’ve missed the suggestion. I haven’t had a problem with the TaxCycle CCA additions. It appears to allow you to be as detailed as you wish with entering additions to the various CCA classes. Is there a weakness that I’ve been missing?

1 Like

Maybe it’s just me, but based on my limited experience, I find that TaxCycle does a very good job of asset tracking… considerably better than my previous Tax software. I don’t use Quickbooks or Sage50 with much regularity so I can not comment on asset tracking features of retail bookkeeping software.

In TaxCycle, however, the Asset Manager Schedules in the T1 and T2 do work quite well for tracking individual assets. I can even drag in a clickable pdf link to an asset receipt or bill of sale in the S8Asset schedule of a T2 return under Current Year or History of Additions. Same goes for any of the T1 Asset Managers (T776, T2125, T1163, T2042 etc).


Agreed. For simple corps and simple proprietorships the TaxCycle Assets work well.

For more complex businesses with a large number of assets in several classes and/or segmented classes it would be helpful but nor required for the asset class continuity.

Examples can be many classes and many items in each class where item tracking is required. Ie farms, golf courses, landscape, tree pruners, trades with multiple vehicles.

Examples can be many few assets but high dollar value and segregated such as Gravel Truck, Cement Mixer, Dump Truck.


The point is not to have TaxCycle be the original record of entry. Instead it is a matter of reconciling individual classes per the tax return, against the classes per the bookkeeping and/or financial statements.

I’m a simple person, so perhaps why Asset Tracking in TaxCycle works well for my less complex clients. It seems to be able to capture an unlimited amount of assets. At this stage I think I’ll keep things simple. :blush:!

Here are a couple of examples of how I might use asset tracking for my basic businesses.

1 Like


Thank you. Your example is very helpful. I am new to Taxcycle. T1 since March 2017. T2 since July.

I will play with examples this month.

For those who love Excel templates, there is a freebie resource with an interesting financial model including capital asset and CCA projections. These are samples only. IFRS based. Interesting none the less.

Created by Sapling Financial Consultants.
Register and complete no charge checkout to obtain two free templates.

  1. Simple-Startup-Model-Release-v1
  2. Product-Development-Model-Release-v1

They are providing a financial modeling webinar for Equity and Debt Financing webinar through IPBC on 2017-11-23 @ 1pm MST…

Sapling Financial Blog