thinkQuickBooks

helping right brain professionals navigate the left brain world of accounting

Archive for the tag “software”

HOW TO SET UP TAX RATES FOR A CHARITY IN QBO TO SPLIT THE GST/HST ON SALES 60/40%

DEC 2018. THESE INSTRUCTIONS ARE NO LONGER WORKING DUE TO THE CHANGES IN THE SALES TAX CENTRE. I WILL UPDATE THE INSTRUCTIONS AS SOON AS POSSIBLE. 

“If your charity is a GST/HST registrant, you have to use a special net tax calculation for charities. When you use this calculation, you generally remit 60% of the GST/HST you charge and claim ITCs only on certain items, where all the conditions for claiming ITCs are met. In addition, you can claim the PSB rebate of the GST/HST paid or payable on your eligible purchases and expenses and for which you cannot claim ITCs, whether the GST/HST relates to your commercial activities or exempt activities.”

Source: https://www.canada.ca/en/revenue-agency/services/forms-publications/publications/rc4082-gst-hst-information-charities/gst-hst-information-charities.html#P283_24869

What does this mean? When you charge and collect tax on sales, you will remit 60% and keep 40% of the amount collected. And although you will only be claim ITCs on certain items (know the rules), you will be eligible for the PSB rebate, meaning you will receive a rebate for 50% of the GST or federal part of the HST paid on purchases.

See my other blog post HOW TO SET UP THE GST/HST PUBLIC SERVICE BODIES’ (PSB) REBATE IN QBO here.

Here’s how to set this up in QBO. We’re going to add two new tax rates, then a new tax group. I’m in a GST only province, so I’m going to set this up with the 5% GST in mind. You can modify this to work in different provinces by adjusting the percentages.

STEP ONE: ADD NEW TAX RATE

  • Click on Taxes from the left navigation bar
  • Click on Add tax in the upper right-hand corner

Add tax from sales tax centre

  • Choose Tax rate

Add Tax Rate Expanded

  • Fill out as shown

GST 60 Percent Sales

  • Click Save

 

STEP TWO: ADD NEW TAX RATE

  • Click on Taxes from the left navigation bar
  • Click on Add tax in the upper right-hand corner

Add tax from sales tax centre

  • Choose Tax rateAdd Tax Rate Expanded
  • Fill out as shown

GST 40 Percent Keep as Income

  • Click Save

 

STEP THREE: ADD GROUP RATE

  • Click on Taxes from the left navigation bar
  • Click on Add tax in the upper right-hand corner

Add tax from sales tax centre

  • Choose Group rate

Add group rate

  • Fill out as shown

NFP on Sales Group Rate

  • Click Save

REVIEW YOUR WORK

SS1

New rates and group for 60 40 split

TIP: You can inactivate (by toggling Off) the two tax rates you just added so that only the group rate appears for selection on transactions.

 

NOTES:

I always test these out first in the test drive file. Here’s the link: https://qbo.intuit.com/redir/testdrive_ca

Use names and descriptions for the tax rates and group rate that make sense to you. Just remember that the group rate cannot be edited.

Rules around charities can be complicated. Please check the CRA website for more information.

Advertisements

HOW TO SET UP THE GST/HST PUBLIC SERVICE BODIES’ (PSB) REBATE IN QBO

DEC 2018. THESE INSTRUCTIONS ARE NO LONGER WORKING DUE TO THE CHANGES IN THE SALES TAX CENTRE. I WILL UPDATE THE INSTRUCTIONS AS SOON AS POSSIBLE. 

“If your charity is a GST/HST registrant, you have to use a special net tax calculation for charities. When you use this calculation, you generally remit 60% of the GST/HST you charge and claim ITCs only on certain items, where all the conditions for claiming ITCs are met. In addition, you can claim the PSB rebate of the GST/HST paid or payable on your eligible purchases and expenses and for which you cannot claim ITCs, whether the GST/HST relates to your commercial activities or exempt activities.”

Source: https://www.canada.ca/en/revenue-agency/services/forms-publications/publications/rc4082-gst-hst-information-charities/gst-hst-information-charities.html#P283_24869

What does this mean? When you charge and collect tax on sales, you will remit 60% and keep 40% of the amount collected. And although you will only be claim ITCs on certain items (know the rules), you will be eligible for the PSB rebate, meaning you will receive a rebate for 50% of the GST or federal part of the HST paid on purchases.

See my other blog post HOW TO SET UP TAX RATES FOR A CHARITY IN QBO TO SPLIT THE GST/HST ON SALES 60/40% here.

Here’s how to set this up in QBO. We’re going to add two new tax rates, then a new tax group.

NEW! You can now post the non-deductible portion back to the original expense account. This is the method I am outlining below. The non-deductible portion previously posted to a GST/HST Expense account that was automatically created by QBO (old method).

NOTE! For non-profit set ups already in place using the old method, you cannot change the existing set up. You will have to start from scratch with the steps below. If starting mid-year, you can go back and re-code individual transactions with the new sales tax code. Consider when you want to implement.

We’re going to add two new tax rates, then a new tax group. We’re not going to touch any of the existing rates. We may need them for other qualifying purchases (know the rules). I’m in a GST only province, so I’m going to set this up with the 5% GST in mind. You can modify this to work in different provinces by adjusting the percentages.

STEP ONE: ADD NEW TAX RATE

  • Click on Taxes from the left navigation bar
  • Click on Add tax in the upper right-hand corner

 Add tax from sales tax centre

  • Choose Tax rate

Add Tax Rate Expanded

  • Fill out as shown

GST ITC 50

  • Click Save

 

STEP TWO: ADD NEW TAX RATE

  • Click on Add tax in the upper right-hand corner

Add tax from sales tax centre

  •  Choose Tax rate

 Add Tax Rate Expanded

  • Fill out as shown. Note the Non-tracking – this is how you’re mapping back to the original expense account.

GST ITC 50 Non taxable non tracking

  • Click Save

 

STEP THREE: ADD GROUP RATE

  • Click on Add tax in the upper right-hand corner. 

Add tax from sales tax centre

 

  • Choose Group rate

Add group rate

  • Fill out as shown. You’re creating a group called NFP Purchases (or similar) that includes the two tax rates you created in steps one and two. NOTE: BE CAREFUL ADDING THE GROUP RATE. IT CANNOT BE EDITED.

Purchases Group Rate

  • Click Save

 

REVIEW YOUR WORK

 SS1

New rates and group

TIP: You can inactivate (by toggling Off) the two tax rates you just added so that only the group rate appears for selection on transactions.

NOTES:

I always test these out first in the test drive file. Here’s the link: https://qbo.intuit.com/redir/testdrive_ca

Apply same principals for setting up rates in different provinces.

Use names and descriptions for the tax rates and group rate that make sense to you. Just remember that the group rate cannot be edited.

Here’s a link to setting up rates in Ontario, for desktop: http://intuitglobal.intuit.com/iq/quickbooks/docs/HST_Charity_xONx.pdf

Rules around charities can be complicated. Please check the CRA website for more information.

HOW TO SET UP TAX RATES FOR MEALS & ENTERTAINMENT IN QBO

DEC 2018. THESE INSTRUCTIONS ARE NO LONGER WORKING DUE TO THE CHANGES IN THE SALES TAX CENTRE. I WILL UPDATE THE INSTRUCTIONS AS SOON AS POSSIBLE. 

The following guide will help you set up a Meals & Entertainment tax code so that the ineligible amount automatically posts to its own expense account. This frees you from doing those periodic calculations and journal entries. I’m in a GST only province, so I’m going to set this up with the 5% GST in mind. You can easily modify this to work in different provinces by adjusting the percentages.

Here’s how to set this up. We’re going to add two new tax rates, then a new tax group.

STEP ONE: ADD TAX RATE

  • Click on Taxes from the left navigation bar
  • Click on Add tax in the upper right-hand corner

Add tax from sales tax centre

  • Choose Tax rate

Add Tax Rate Expanded

 

  • Fill out as shown.

GST Eligible

 

  • Click Save

 

STEP TWO: ADD TAX RATE

  • Click on Add tax in the upper right-hand corner

Add tax from sales tax centre

  • Choose Tax rate

Add Tax Rate Expanded

  • Fill out as shown. Note the Account filled in as Expense – this is how you’re mapping the ineligible portion.

 

GST Ineligible

 

  • Click Save

Here’s a look at the audit log to see what happened behind the scenes. QBO automatically added a new account called GST/HST Expense. You can change the name if desired (i.e. Non-Deductible GST Expense) as well as the category account type (i.e. Other Expenses) from the Chart of Accounts. You can also assign an account number, just remember to click on the pencil icon to add the number.

Added New GST Account

STEP THREE: ADD GROUP RATE

  • Click on Add tax in the upper right-hand corner

Add tax from sales tax centre

 

  • Choose Group rate

Add group rate

 

  • Fill out as shown. You’re creating a group that includes the two tax rates you created in steps one and two. NOTE: BE CAREFUL ADDING THE GROUP RATE, IT CANNOT BE EDITED.

ME Group

  • Click Save

REVIEW YOUR WORK

  • Click the Edit GST/HST drop down; select Edit rates. Here you’ll see the two tax rates along with the group that you just added.

SS1

 

 

New Rates.jpg

  • TIP: You can inactivate the two tax rates you just added so that only the group rate appears for selection on transactions.

TEST THE CODE

Here’s an example credit card expense. $2.50 posts to the GST/HST Expense account and the other $2.50 post to the GST/HST Payable liability account.

ME code splits the GST

 

NOTES:

I always test these out first in the test drive file. Here’s the link: https://qbo.intuit.com/redir/testdrive_ca

Apply same principals for setting up in different provinces.

Use names and descriptions for the tax rates and group rate that make sense to you. Just remember that the group rate cannot be edited.

Meals themselves must be adjusted at end of period. I always let the accountant know that the ITCs have already been adjusted so they don’t make an unnecessary entry.

If you are implementing this solution mid-year, you will need to do one of two things:

  1. Adjust the ITCs on meals to back out the 50% up to the point you start using the new method.
  2. Go back to the start of the fiscal year and edit all the meal entries to code them with the new ME tax code.

 

Intuit has relaunched the QuickBooks Community forum!

As of yesterday, it’s new and improved! Well, at this point we can say it’s new 😉

https://community.intuit.com/

There are nine ‘topics’ to choose from. The first six topics relate to the US versions of QuickBooks. The last three topics are specifically for QuickBooks Canada, QuickBooks UK, and QuickBooks en Español.

If you’re a regular visitor, you’ll notice that the topics have been revised. Intuit is perhaps trying to make the language easier for the majority of users to understand (for example, ‘Customers & Getting Paid’ instead of Accounts Receivable). If you click on the QuickBooks Canada topic, you’ll probably notice that ‘Sales Tax’ is not a subtopic. I noticed this right away and definitely think it should be added back!

It appears Intuit has some kinks to straighten out, and I’m sure they’re working on them. Members don’t seem to have access to their old questions and answers. And referring specifically to the QuickBooks Canada topic, the ‘Unanswered’ questions seem to all be ‘asked about a year ago!’ That said, it’s early in the changeover and it looks like Intuit is gradually adding back content.

Opinions on the new platform aside, the community forum can be a great resource to get pretty much any question you have answered. A lot of QuickBooks gurus hang out and provide answers, generally because they love to serve and help other members with their books. You can also search the database for older questions and answers (a note about searching… right now, you have to type your search into the ‘Have a Question?’ field at the top of the page. You’ll then be taken to the results page, and the field will now be labelled ‘Search.’ Here you can search for another topic). You can also browse tags which you will see on the right hand side of the main page.

I’d love to know what you think of the new forum. And if you have a suggestion, you can contact Intuit directly. Look for the ‘Send us Feedback’ link at the bottom of all forum pages. Embrace the change!

Did you sign up for e-statements? Don’t forget to save or print!

So you’ve gone green and signed up for e-statements. Kudos to you! Here’s how going paperless helps the environment, compliments of http://payitgreen.org/

PayitGreen

There’s nothing better than neglecting my own bookkeeping and sitting down to do it a couple times a year. It fulfills my need for a challenge. LOL! (I don’t recommend this, by the way!) This last time, I went to my credit card provider’s website to download the past twelve months of statements into QuickBooks. Except eight of them were gone! Only the most recent four were available to download into QuickBooks. The missing months were easy enough to access in PDF format (they keep seven years for me), but the downloadable files were indeed gone with no way to get them back. That made for a lot of manual data entry for me.

Another of my credit card providers only saves six months, PDF or otherwise. After that, I have to contact them to retrieve the missing statements. This involves an email, a confirmation email, a password and a time limit to fetch them… which I typically miss. I then have to start the entire process of retrieval over again!

Banks and credit card issuers often make only a certain number of statements available online. In many cases, it’s only a few months. If you need to go back farther than that, you may have a few hoops to jump through. You may even be required to pay a fee.

So here’s a reminder. Save those files to your computer every couple months (and if you still prefer to print, no judgement here!).

It’s here! Intuit Canada announces release of QuickBooks 2013!

http://quickbooks.intuit.ca/accounting-software/compare-quickbooks-editions.jsp

And if you’re in the US, you can find the 2013 product link here:

http://quickbooks.intuit.com/product/accounting-software/small-business-software.jsp

I was fortunate enough to be able to beta test versions from both Canada and the US this year, which I really enjoyed. There are some interesting new features, most noticeably, the overall look. Personally, I love most of the changes with a couple small exceptions. It will be exciting to hear from users what they think of the new changes!

Post Navigation