Tax Audit from Hell? – Part 2

bookkeeper NewmarketA couple of weeks ago I thought this would be part two of a three part series, even though it was originally planned for two. But thankfully it appears we’re on the final leg of this very long and stressful journey. Let me take you back as to why this has been the tax audit from Hell.

In my previous blog, I finished with the auditor’s request for a 2011 personal breakdown of expenses and income. And, the income wasn’t just related to T4s and Child Tax Benefits. It related to every deposit made to all of their bank and investments accounts along with that of their children for all of 2011. The auditor wanted closing balances of all their accounts at 2010 and opening balances for 2012 which included but wasn’t limited to:

  • Mortgage statement
  • Childrens’ RESPs
  • TFSAs
  • RRSPs
  • investments accounts
  • Savings accounts

After supplying him with all the information he requested, he still needed bank copies of all their deposits that weren’t obvious, i.e., Child Tax Benefits direct deposits and personal tax return refund deposits etc., for the full year. It took my clients weeks for the bank to request and receive all of this old information. The auditor was not satisfied until he received a copy of the individual cheques deposited, front and back, along with the reason for my clients receiving the monies. If there weren’t cheques deposited, he wanted the details of the cash deposited, from the bank. We’re talking how many $10s, $20s, $50s etc. that were deposited. He was relentless. He even went so far as to telephone my client’s next door neighbour to ask why the neighbor had written a cheque to my client, FOR LESS THAN $400! Needless to say my client was upset and embarrassed, and the neighbour was shocked that an auditor would call and ask what he considered a private matter. Thankfully they have been neighbours for a very long time and my client had shared the details of what was going on.

For the last couple of months we had told the auditor we wanted this all resolved by the beginning of this month. My clients didn’t want this hanging over their head going into the busy holiday season, and there was nothing left for them to do or supply. When I contacted the auditor on a Monday near the end of November, he said he didn’t know if he would get to it before the holiday season, as he also had other accounts he was working on and he was going on holidays. When I asked him when his holidays were booked, he said he didn’t have to book them he could take time off whenever he wanted. That just didn’t sit right with me. So two days later, I called him and got the voice message that he was away on holidays but I could leave a message for his supervisor, which I did.

The following day the supervisor contacted me and explained that the auditor was on “a leave of absence” and since he had been monitoring the file, he was up to speed on the status. He said he felt everything was accounted for and he would report that no further action was required. He also said my clients would be receiving a letter, in a few weeks, indicating that the audit was finished and nothing further was required. I told my clients to be cautiously optimistic as there could be some minor interest or penalty on a couple of potential issues, but that it was over.

So what would you do if you were presented with an audit that delved so deeply into your business and/or personal transactions for a year? Do you have the paperwork and the answers? Are you comfortable dealing with CRA, and do you have the time and patience? Before you respond to an audit request, ask a professional’s opinion on:

  • The best way to proceed
  • How your records should be presented, and
  • Do you have any options as to the timing of the audit and the location where it is to be held?

Do you really want the auditor camped out at your dining room table for potentially weeks at a time? You need to know your rights, the laws and the extent that the CRA can disrupt your life and that of your family’s.

As always, I welcome your feedback. You can connect with me via email or telephone, leave a comment right here on the site or click the contact tab at the bottom of the screen if you are reading this blog post on the website.

Until next time,


Are you Prepared for an Audit from Hell? – Part ONE

bookkeeper NewmarketIn early May 2014 I received a call from a long-time client of mine. They just received a call from Canada Revenue Agency (CRA) saying they were being audited for the year 2011. My client is sharp. He didn’t panic or get angry, but simply asked “how do I know who you really are based on a telephone call?” And, “I want your request in a letter before I do anything further”. My client also contacted their CA as they weren’t sure who was to do what, and what was to happen next. Little did we know this would become the Audit from Hell for both my clients and me. Continue reading

5 Tips & Tricks for QuickBooks Online (QBO)

QuickBooks Online Pro Advisor NewmarketIn the past month I’ve spent numerous hours training new and transitioning clients in QuickBooks desktop and QBO. While some are new to either version, I’ve found those transitioning from the desktop version to the online version experiencing a bit of a culture shock. To ease the transitioning hiccups, here are 5 tips and tricks for QBO to make the entering and retrieving of information go a little smoother.

1. In order for you to allocate the GST/HST in QBO you must first set-up Sales Tax. You do this by selecting the Sales Tax tab from the menu bar and follow the on screen guidelines. QBO then automatically adds two default accounts; GST/HST Payable and GST/HST Suspense. You cannot allocate a payment amount directly to the GST/HST Payable account. But, you can allocate it to the GST/HST Suspense account. If you can’t easily relate to the word Suspense you can rename it to something that will be more familiar to you i.e. Clearing.

2. Generating reports in QBO. There are not as many reports available in QBO as there are in the desktop version, but generating them is pretty straight forward. Balance Sheets and Profit and Loss statements are about the same, but other reports are significantly different. As an example; to inquire and generate the total amount you paid to a supplier is different. Go to:

  • Reports,
  • Expenses by Supplier Summary,
  • Select the Date Range and then
  • Customize. Remember, this shows the amount expensed without HST.

3. Customizing transaction reports in QBO is much different in appearance and handling. i.e. Reviewing Bank transactions in the General Ledger. Until you save your customization, the debits and credits all appear in one column. I prefer to see the debits and credits in their own column, then the running balance in the last column. To do this go to:

  • Customize Transaction Report,
  • Change Columns, and then
  • Click on the accounts you want to Add or Remove.

Once you’ve selected the account columns you want on your report you can then determine the order you want to see them but clicking on the account name and to the right, there are arrows that you use to move the accounts up or down to display in the order that meets your needs.

4. Downloading your financial reports. This is one of the first items you want to set-up once you’ve established your company in QBO. Besides insuring that all your transactions are recorded, if not necessarily matched, the Home Page will indicate the discrepancy. Your bank account could show 2 difference values; one would be the actual bank balance when you downloaded the transactions, and the other will indicate the QuickBooks balance.

The closer those numbers are to each other indicates that your bookkeeping is up to date. The same is indicated with Credit Card accounts and Lines of Credit. It also indicates how many entries have been downloaded that hasn’t been matched to QuickBooks entries. It’s a great dashboard for information at a glance.

5. Uncategorized Income and Uncategorized Expenses. These are the account names that are used when you have downloaded your financial transactions and QuickBooks doesn’t know who the funds were paid to or received from. These are the gross amounts. You can access them by either going to your downloaded information and add the correct information to each line or go to the Profit & Loss reports, and each account and total will appear. You can click on one of them then drill down (every time you see a magnifying glass you can access more information by double clicking) and allocate accordingly. These amounts are the gross amounts, so don’t forget to apply the GST/HST where applicable.

If you’re overwhelmed on where to start with QBO, or handling of the day to day transactions contact a ProAdvisor Online Accountant. We can walk you through the process remotely and answer all your questions.  As always we are here to help. You can connect with us via email or telephone, leave a comment right here on the site, or click the contact tab at the bottom of the screen if you are reading this post on the website.

Until next time,


Time to Move from QuickBooks Desktop to QuickBooks Online (QBO)?

QuickBooks Pro Online Advisor NewmarketI don’t know whether it’s customers getting into the fall routine, and their business mindset from disappointing summer weather, or the marketing Intuit is doing, but I’ve received a lot of inquiries from new and current customers about QuickBooks in the cloud. The question being; is it time to move from QuickBooks desktop to QuickBooks Online (QBO)? Continue reading

Reducing Canadian Payroll Taxes with a Tax Waiver

reducing taxesIt makes a world of difference to all business owners in surrounding themselves with intelligent and professional associates. Carolyn Bogseth is one of my associates that I certainly respect for her intelligence and genuine desire to help those she meets. Whether they are her clients or someone that would like a general investment question answered she will take the time to assist those who contact her. Below is an excerpt from her recent newsletter outlining how reducing payroll taxes can help you. Continue reading

2 Great Accounting Software Deals for Businesses

cost savingsI’ve been in the accounting, tax preparation and training business for a number of years. And over those years, I’ve developed some great relationships with customers and vendors. So it has to be big for me to get excited about sharing these 2 great accounting software deals for businesses.

Whether our businesses are operated by a single person or 20 employees, we all have challenges. For the purpose of this blog I’m referring to great software at a good price and handing over the responsibility of payroll to a 3rd party provider.

Continue reading

QuickBooks 2014 Payroll Update

quickbooks-basic-payrollI’ve received a number of emails lately regarding problems updating QuickBooks 2014 Payroll. Even though customers are registered for QuickBooks payroll, the automatic updates are not recognizing payroll which expires June 30, 2014. At our office some of the computers updated payroll automatically with an expiry of December 31, 2014 while others didn’t. We are all on the same Windows operating system.

When I contacted QuickBooks their only suggestion was to go to their website and manually download the update. No other explanation was supplied. Make sure your QuickBooks file is closed first! Here is the link for the manual update for various versions.

Continue reading

3 Rs of Child Care – Rules, Receipts and Regulations

Day Care York RegionHere at The Montana Group, we do the bookkeeping for 2 large Child Care facilities located in York Region. Whenever I get an opportunity to discuss challenges of the industry with the Executive Directors, I’m surprised and impressed by the regulations in place to help protect the children. During tax season I regularly inform clients of the rules pertaining to claiming child care expenses and the receipts that are required. The following is a summary of my discussions regarding the 3 Rs of Child Care:

1) Rules

a) If you are the only person supporting the child, you can claim child care expenses you incurred while the eligible child was living with you
b) If you are in a relationship (marriage or common-law), the person with the lower net income is to claim the child care expenses
c) Employment Insurance is not considered earned income
d) The person with the higher net income can only claim the child care expenses if:

  • The other person attended school and was enrolled in a part-time educational program
  • The other person was confined to a prison or similar institution for a period of at least two weeks

For more exceptions and detailed information, please click here.

2) Receipts that Qualify

a) For caregivers providing child care services – your receipt will need to have the full name of the caregiver, address and social insurance number plus dates of care-giving services and name of child
b) Day nursery schools and daycare centres
c) Educational institutions, for the part of the fees that relate to child care services
d) Day camps and day sports schools where the primary goal of the camp is to care for children
e) Boarding schools, overnight sports schools, or camps where lodging is involved

3) Regulations

Accredited child care is governed in Ontario by the Ministry of Education. This link can help you determine which facility might be the best fit for your child. It not only tells you when the facility was first licensed but also indicates the total capacity, age groups of children it accepts, when it was last inspected and level of compliance, plus much more.

Child care receipts are some of the most commonly requested documents the Canada Revenue Agency (CRA) wants to see after personal tax returns are processed. You’ll need to respond within 30 days from the date of the letter requesting the receipts. In most cases they can be faxed to the auditor. And, they have a significant impact on determining your taxable income. Like all documentation pertaining to your personal tax returns, make sure everything is kept in a secure, dry location for 7 years.

As always, I welcome your feedback. You can connect with me via telephone or email, leave a comment here on the site or click the contact tab at the bottom of the screen if you are reading this post on the website.

Until next time,



The Montana Group – Offering Bookkeeping Services for Realtors

Newmarket bookkeeping services for realtorsAre you a Real Estate Agent in York Region? In this busy real estate season, do you struggle with filing your own paperwork on time to avoid government penalties? Do you have a solid handle on your financial position? Did you know The Montana Group offers excellent bookkeeping services for Realtors?

In a May 9, 2014 Financial Post article I was surprised to learn that in the first quarter of 2014 the number of people selling real estate reached 108,706 according to the Canadian Real Estate Association. That’s one realtor for every 245 Canadians over the age of 19! The article also mentioned that there were almost as many people selling houses as making them. So what else do I know about Realtors and Numbers?

From my customers that are real estate agents I know that;

  • They are frequently pressed for time,
  • Their own paperwork isn’t as big a concern as their buyers’ and sellers’ paperwork is to them, and
  • To those that haven’t been in the business very long, they hate the surprise of large amounts owing for personal tax and HST.

For some I do their bookkeeping quarterly, then calculate and netfile the HST for the same period. They receive Profit and Loss statements quarterly to review. This helps them keep an eye on their expenses and sometimes alerts them to some expenses that they didn’t submit receipts for, or are missing. It’s easier to request or print an online receipt within two or three months of purchasing, than twelve or fourteen months later. With the quarterly customers there are no surprises at year end. The tax returns are filed on time and the shock factor regarding the amount of HST due is kept to a minimum. For these Realtors, there is peace of mind.

For other real estate agents it’s a once a year project. With this currently being a sellers’ market the good agents are staying extremely busy and their paperwork is the least of their concerns. So if you’re a real estate agent what can you do to make the process smoother for yourself and the person that helps you with your HST calculation and personal tax return?

1) Get in the habit of putting all your receipts in the same location – whether it’s an accordion file folder, or one desktop folder for online purchases or scanned receipts.
2) Separate your receipts by month. When separating you expenses and receipts by month you’ll be able to see if the monthly broker’s report is missing along with any other monthly charges.
3) When you get your bank or charge card statements highlight which ones are for your business and put them in the monthly folder.
4) Set aside time in your schedule to make sure you have the receipts for the expenses you’ve highlighted on the statements
5) Consider a quick training session in software like QuickBooks online or the free version of Wave. This is cloud based software.
6) You can enter receipts for anywhere, anytime. Pull them out of your wallet, glove compartment or purse and enter them while waiting to meet a client. And get a little stamp that you can mark when the receipt is entered. That way there is no confusion when you run across the paperwork again, or get interrupted, and don’t know whether you’ve entered it or not.
7) If you use software it can be shared with whoever does your personal tax return and HST remittance calculation. The availability of sharing makes it easier for everyone.

You want your numbers entered accurately and in a timely manner. There’s nothing worse than working the long hours for those commission cheques then paying penalty and interest because you didn’t file with Canada Revenue Agency on time, or you couldn’t locate the receipts and your taxable income was more than it should have been.

If you’re a real estate agent that has a system that works well for you I would love to hear from you. Or, if you are in need of help or find the process tedious and time consuming, we are here to help! You can reach us by phone or email, leave a comment right here on the site or click the contact tab at the bottom of the screen if you are reading this post on the website.

Until next time,


Canadian EI (Employment Insurance) and Family Members

Canadian EI rules for familyWith the T4s being processed by CRA (Canada Revenue Agency) and PIER (pensionable and insurable earnings review) reports now being mailed, this is the time of year when CRA questions if there is a conflict with EI and Family Members.

Last week a client of mine received a PIER report requesting that he pay the employee’s EI that wasn’t deducted on the earnings shown on the T4, and the employer portion of the EI. When preparing payroll in the summer of 2013 he didn’t deduct EI from his daughter’s earnings, but the T4 showed insurable earnings and no contribution.  His question to me once he received it was “Why do I have to pay EI on my daughter. She’s only 14 and I don’t have to pay it on my wife?”

Continue reading