cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
RickyO
Level 1

Accounting for CRA Income Tax in Quickbooks Online?

Hi out there.  Wondering if anybody can help me with recording Canadian Income tax payments properly in Quickbooks online.

 

For Tax year 2018 I filed a T2 for my company in March of 2019.  It generated an amount owing which I payed to the CRA via my company bank account in March 2019.  I now have the transaction in my bank account and I'm confused as to how to categorize it in quickbooks.

 

Is the payment an expense?  ie: should I enter an expense transaction for that amount, categorize it as "Taxes Paid" and match the record to the bank transaction and be done with it?  (Not that I am an accountant but my sense says no).

 

What I tried to do was set up a liability account in the chart of records called "Taxes Owed".  I then created a Bill from Vendor CRA for the tax amount and categorized it under the "Taxes Owed" category.  So far so good.  Accounts Payable shows the amount, and the "Taxes Owed" account gets incremented by the transaction.  I then paid the transaction matching to the bank record.  What happened was the Accounts Payable account was happy.. being zeroed out but the balance in the Liability account "Taxes Owed" did not get affected.  There were not options to reference this account in the Bill Payment.  My sense says that when I pay an income tax bill the taxes owed should be descreased accordingly.

 

What am I missing here?  Is there another or better way to handle this?  Thanks for you help in advance and patience with my challenges with Quickbooks and accounting.

 

Cheers, Rick

7 Comments 7
Anonymous
Not applicable

Accounting for CRA Income Tax in Quickbooks Online?

Your on the right track but missed a switch ...

You can account for taxes due at the end of last year as an AP item or separately as 'taxes due' - but you accidentally did both.

The CRA bill you created should have been an 'income tax expense' - then the payable become part of AP and the subsequent EFT payment is a a "vendor bill payment'.

Alternately the liability could be created by JE and posted to your 'tax due' account, then the cash payment would be a check applied to that account (no vendor bill).

RickyO
Level 1

Accounting for CRA Income Tax in Quickbooks Online?

Hi Mike, thanks so much for responding. It's really appreciated. So if I understand correctly there's a couple ways to do this,  so with your patience I'm going to try and walk myself through the QuickBooks solutions using your reply as guide.

The CRA bill you created should have been an 'income tax expense' - then the payable become part of AP and the subsequent EFT payment is a "vendor bill payment'.

If I understand your correctly  I would:

  1. In the chart of accounts create an account of type "Expense" and Detail Type "Taxes Paid" call it "Income Tax Expense"
  2. Create a Bill with the CRA as the vendor and the category as the expense account "Income Tax Expense" and the amount being what the 2018 T2 filing called for as a payment.
  3. Go to Banking, find the EFT payment which matches the Bill payment and add.


So the net effect of this the tax bill gets added to accounts payable (liability) , zeroed out with the pmt but because the "Income Tax Expense" account was of type "Expense" the expense lives on as a line item in the income statement reducing the taxable income for the 2019 tax year.. Pretty much the same as any expense. So I think I might not have this right as the expense stays?

Alternately the liability could be created by JE and posted to your 'tax due' account, then the cash payment would be a check applied to that account (no vendor bill).

So in this scenario, assuming I have a liability account called "Taxes Owed" and an expense account called "Income Tax Expense" I would:

 

  1. Do a journal entry for the tax bill amount:
  2. Debit "Income Tax Expense" (increases the expense)
  3. Credit "Taxes Owed" (increases the current liability of Tax Owed)
  4. Find the transaction in Banking, classify it as a Transfer to Account "Taxes Owed"
    (Same effect as a JE - Debit "Tax Owed" , Credit "Bank Account")

Have I got that right?

Now looking at the two situations.. the net effect is the bank pmt to CRA reduces the bank account and zeros the liability account (whether it's an AP account or a "Taxes Owed" account) and the expense lives on. So the two scenarios are effectively the same. hmm. Maybe the expense living in 2019 vs 2018 is messing with my head.

So if I had done this properly in 2018 on the last day of the year.. I would have made a provision for taxes owed, and paid it so things would have been trued then and then adjusted in 2019 vs. being fully expensed and paid in 2019.

 

Any further clarifications or comments would again be greatly appreciated.  Thanks so much, Rick

Anonymous
Not applicable

Accounting for CRA Income Tax in Quickbooks Online?

I think you undestand now.
But I was assuming that we would correct the 2018 statement now by dating the CRA vendor bill (or JE) to Dec.31, 2018. Leave the cash payment on its real date obviously.
If for some reason you dont want to correct 2018 then the 'tax expense' will become part of 2019. If your doing that then make separate expenses for Taxes - Last Year and Taxes - This Year so its more clear in your reports whats happened.
RickyO
Level 1

Accounting for CRA Income Tax in Quickbooks Online?

Yes, I kind of already filed the T2 for 2018 and paid it this year figuring I was done but that kicked off this conundrum lol.  So what you are saying is I could just do the JE for 2018 dated in 2018 and then apply the EFT to the liability account now.   Is it worth going back and refiling the T2 to accommodate this fix or will it create more problems than its worth?  I can see that keeping everything in this year would create a double expense when I add the 2019 tax owing stuff at the end of the year.  I can definitely make sure they are noted as separate.  What do you think worth it?

 

Thanks for everything.  That's great!!

Anonymous
Not applicable

Accounting for CRA Income Tax in Quickbooks Online?

Yes - Post the 2018 tax expense into the 2018 year. There is no need to refile the 2018 T2 because income tax expense is ignored for tax purposes anyway.

But when you file the 2019 T2 you should show that the change in 2018 RE was just for 2018 income tax - If you have a tax filer this should be no problem for them. 

Anonymous345
Level 1

Accounting for CRA Income Tax in Quickbooks Online?

Hello there,

I have followed your discussion on how to categorize Income tax on Quickbooks online.

 

My question here however is how does one categorize income taxes paid to the CRA on quickbooks self employed?

JamesM4
QuickBooks Team

Accounting for CRA Income Tax in Quickbooks Online?

Hello Anonymous345. Thanks for joining this thread. In order to categorize your transactions correctly, I recommend checking out the following article that shows you how to: Categorize transactions in QuickBooks Self-Employed. Feel free to ask questions as you browse through the article. I'll be here.

Need to get in touch?

Contact us