Here are a couple of Excel templates we use for T1 clients that bring in receipts that need to be categorized. Both have the ability to be imported into the appropriate schedules in TaxCycle.
I had a small business client that was registered for GST. They provided a sales summary showing total sale, GST charged, and total charged on their invoices for the year but their expenses (just over 70 expense receipts were organized but not totaled.I simply edited the two columns for ITCs and GST on Sales. You can remove the two lines of entry (used in the attachment) for another master.)
I have designed various Excel workbooks for proprietorships, extra small corporations (ie consultants), rental properties, etc. The workbooks are integrated with each worksheet being linked to summary reports and GST returns (if applicable). Many of my clients too small for the likes of QuickBooks, Sage50 or Xero find them quite easy to work with and they sure make my life easier when preparing statements and tax returns.
If anyone is interested in something along this lines, feel free to contact me at cracctg@shaw.ca
Is the offer still open for those excel spreadsheets? I have a bunch of clients that don’t fit the mold for regular use of software and thinking excel would be the way to go.
I have written a sophisticated excel workbook to cover most of the clients but I did some programing in it, so you have to allow macros for it to run. The programing just does automation, posting and error checking. I am working on integrating it with a T2125 in taxcycle (Not done yet). If there is interest I will accelerate my efforts.
If you are interested I can send you a link for download. Unfortunately since it is an *.xlsm file it will not be allowed to be uploaded here and I understand that as people can hide Viruses in them.
This looks like it will do an amazing job. I am in conversation with a new client this may be perfect for and have some commission sales people that I believe this will work for.
Thank you for sharing your hard work and stay safe.