thinkQuickBooks

helping right brain professionals navigate the left brain world of accounting

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

UPDATED APRIL 2019

“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 able to 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 following the same guidelines.

STEP ONE: ADD NEW TAX RATE

  • Open the Sales Tax centre from the left navigation bar
  • Choose ‘Manage sales tax’ in the upper right-hand corner

SS1

  • Select ‘Add rate’

Add rate

  • Fill out as shown

Add rate detail

  • Click ‘Add’

STEP TWO: ADD NEW TAX RATE

  • Select ‘Add rate’

Add rate 2

 

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

Add rate detail 2

  • Click ‘Add’

STEP THREE: ADD GROUP RATE

  • You should be back in Manage sales tax
  • Select ‘Add tax’ in the upper right-hand corner

Add tax

  • Click ‘Add’ next to Group rate

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.

Add tax detail with text

  • Click ‘Add’

REVIEW YOUR WORK

  • You should see the two tax rates along with the group that you just added.

New rates and group

  • SMART TIP: Inactivate the two tax rates you just added by selecting ‘Make inactive’ so that only the group rate appears as a choice on transactions.

TEST THE CODE

Here’s an example credit card expense. When using the ‘NFP Purchases’ tax code, $5.50 posts to the GST/HST Payable account and the other $5.50 posts back to the expense account.

Staples

Staples Journal

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.

Advertisement

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

UPDATED OCT 2019

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 following the same guidelines.

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

STEP ONE: ADD TAX RATE

  • Open the Sales Tax centre from the left navigation bar
  • Choose ‘Manage sales tax’ in the upper right-hand corner

SS1

  • Select ‘Add rate’

Add rate.png

  • Fill out as shown.

Add rate detail

  • Click ‘Add’

STEP TWO: ADD TAX RATE

  • Select ‘Add rate’

Add rate 2.png

  • Fill out as shown. Note you want to choose Expense – this is how you’re mapping the ineligible portion.

Add rate detail 2.png

  • Click ‘Add’

NOTE: 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 if you’ve turned them on in settings.

Audit Log

IMPORTANT!

If you do NOT want the unrecoverable portion of the tax in its own expense account, use the Account ‘Non-tracking‘ as shown here. It will post back to the same expense account used on the transaction.

ME Blog Post Updated SS

STEP THREE: ADD GROUP RATE

  • You should be back in Manage sales tax
  • Select ‘Add tax’ in the upper right-hand corner

Add tax.png

  • Click ‘Add’ next to Group rateGroup Rate.png
  • 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.

Group Rate Detail.png

  • Click Add

REVIEW YOUR WORK

  • You should see the two tax rates along with the group that you just added.

Review your work clean.png

  • SMART TIP: Inactivate the two tax rates you just added by selecting ‘Make inactive’ so that only the group rate appears as a choice on transactions.

TEST THE CODE

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

Milestones Entry.png

Milestones Journal.png

NOTES:

I always do a dry run 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 in any way OR inactivated at this time.

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. NOTE: If you are an accountant, you CANNOT currently do this using the Reclassify Transactions feature. For some reason the custom sales tax codes does not show up in the reclassify feature.

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

JULY 2019: SCREENSHOTS ARE OUT OF DATE AND WILL BE UPDATED SHORTLY. STAY TUNED!

“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.

How to change product and service prices in QBO

Question: I recently increased my prices. Right now, I have to remember to change them every time I create an invoice. Is there a way to make the new prices stick?

Answer: There is, and it can be done in three simple steps. Here’s what to do:

1. Click on the gear menu in the upper right hand corner. Then choose Products and Services from the Lists column.How_to_update_prices

2. Click on Edit to the far right of the item you’d like to update.Edit_button

3. Enter your new Sales price/rate. This does not affect any existing transactions, only new ones. Click Save and close.Update_price

Now when you create an invoice or other sales transaction, the new price will show up on your form.

CRA info for businesses and individuals affected by the Fort McMurray and north-east fires

The CRA has issued a news release for those people affected by the recent fires in Alberta. 

I called the CRA this afternoon to get a bit more information for one of my customers who has lost her home in Fort McMurray. I found out that the CRA has set up a Fort McMurray help line. Call the general phone line at 800-959-8281 (individuals) or 800-959-8281 (businesses) and ask to be transferred. The Fort McMurray help line is located in Calgary and currently open 8-6pm MST.

If you are affected by the fires and unable to file or pay your taxes on time, you can request taxpayer relief. You can submit your request by filing form RC4288.

Here are a few things I found out about the form:

Who should file this form? Individuals or businesses affected by the fires who are unable to file or pay their taxes on time. This includes sales tax and payroll tax. Complete one form per taxpayer/business.

When should I file this form? As soon as you get any notices with penalties and/or interest. If you haven’t filed your tax return yet, wait until you do so. Don’t file the form until/unless there are penalties and/or interest to waive.

How should I file this form? Mail your form to the Winnipeg Tax Centre. The address can be found on the bottom of the form. You can also submit the form online using the CRA My Business Account or My Account for Individuals if you have it set up. Anyone you have added as a representative (your accountant or bookkeeper for example) can also submit this form online. As of right now, requests are not being taking over the phone, but this could change.

What address should I use? Use any address where you’re currently getting mail. This does not have to match what the CRA has on file, it’s simply a mailing address.

What about section 3 – Supporting documentation? The form mentions a police/fire report and insurance statements. I was told that as of right now, the CRA doesn’t have a whole lot of information on what exactly will be required if you’re filing for relief. Call before filing to find out what is required.

This is the information I have as of today. I’m sure that the CRA is busy sorting out the particulars and getting agents up to speed on processes. Again, if you have any questions at all, please call the help line. They are very helpful. My heart goes out to all of those affected by the fire.

Vote For the Top 100 ProAdvisors of 2016

Customers, friends, and fellow bookkeepers, it’s that time again! I need your vote to become an Insightful Accountant Top 100 ProAdvisor for 2016. It’s one vote per person, and filling out the entire survey is optional. What’s required is your first name, last name, email, and a check-mark next to my name (alphabetical by last name, look for Marnie Stretch, I’m a ways down).

Voting is only one part of the process, so it’s not strictly a popularity contest (thank goodness!). It’s based on several other criteria including certifications, social media presence, relationships with third-party apps, and more.

I love helping people become knowledgeable in QuickBooks and business finances. And hopefully, I’ve helped you somewhere along the line, so you won’t mind taking a moment to cast a vote in my favor!

Thanks in advance, it would great to have this honor three years in a row.

VOTE HERE

How do I enter the Small Business Job Credit refund into QuickBooks or QBO?

This week, I’ve been noticing that the Job Credits for Small Business have been appearing in many of my customers’ CRA online accounts. I haven’t seen any refund cheques or deposits yet, but those should be starting to roll in soon.

You might remember the Hiring Credit for Small Business (HCSB) that was around for several years and ended in 2013. This is similar. One notable different is that the CRA will be sending out the refunds rather than having small businesses apply the credits to an upcoming payment.

What’s the Small Business Job Credit?

The Small Business Job Credit will effectively lower small businesses’ Employment Insurance (EI) premiums from the current legislated rate of $1.88 to $1.60 per $100 of insurable earnings in 2015 and 2016. Any firm that pays employer EI premiums equal to or less than $15,000 in those years will be eligible for the credit. Almost 90% of all EI premium-paying businesses in Canada will receive the credit, reducing their EI payroll taxes by nearly 15%.

Source: http://www.fin.gc.ca/n14/14-120-eng.asp

How will I get the credit?

No action necessary. The Canada Revenue Agency will automatically calculate the credit, meaning no paperwork for you.

The credit will not be carried forward. You will receive a refund by direct deposit (if you’ve signed up for it) or mailed cheque less any outstanding amounts on your account.

This credit can be entered as income or as a reduction in your EI expense.

How do I enter this into QuickBooks?

Banking > Make Deposits

2016-03-11_1317

How do I enter this into QBO?

Plus Sign > Bank Deposit

2016-03-11_1324

For more information about the Small Business Job Credit, check out http://www.cra-arc.gc.ca/whtsnw/tms/sbjc-eng.html

Holiday bonus? What you must know if you’re issuing bonus cheques using QBO Payroll.

THE PROBLEM:

I wrote a bonus paycheque using QBO Payroll and the calculations are wrong.

A NOTE:

Intuit payroll engineers are aware of this issue and are working on a resolution.

THE SCENARIO:

It’s December, a time for staff parties, office treats, and hopefully… bonuses! Today I sat down to issue one such paycheque in QBO. The president of the company wants to pay her hard-working husband a net discretionary bonus of $6000, so this will need to be grossed up. This employee is maxed out on his CPP contributions for the year and doesn’t contribute to EI. His federal and provincial TD1 amounts are set to the 2015 default amounts. His vacation policy is set to pay 9.6% each pay period. Discretionary bonuses are not vacationable in any of the provinces. If you want to confirm this, please check with your provincial department of labour. And make sure you know the difference between discretionary and non-discretionary bonuses (which are vacationable).

There are two ways to pay bonuses in QBO. The first way is to select ‘bonus’ as a pay type when setting up (or editing) the employee. I suggest using this method if you want to include non-discretionary bonuses on regular paycheques. The second way is to simply select Bonus only from the Run Payroll drop down menu when you want to issue a bonus.

Using the second method, I started a Bonus only payroll. Next, I chose to enter the bonus amount As net pay and clicked Continue. I entered $6,000 as the net bonus and realized that QBO is calculating gross pay in the amount of $14,658.38 which is not correct. If you recall, the employee is maxed out on CPP and EI, so the ‘grossed up’ amount of $8,082.38 is all income tax.

Additionally, QBO is calculating and adding vacation pay on the incorrect gross amount. No vacation pay should be added as discretionary bonuses are not vacationable. Unfortunately, there is no way to edit the paycheque to correct for either of these issues.

NOTE: I tried the same procedure using As gross pay and it appears that this is working correctly in terms of the income tax calculation. However, it is still adding vacation pay, which is incorrect.

THE FIX:

1. First, let’s add a new bonus policy:

From the Gear menu, choose Payroll Settings. Choose Vacation / Sick / PTO. From the Vacation and Sick Leave Policies box, choose Create to set up a new zero vacation item policy. Choose Vacation for the Category, use Bonus Zero for the description, select the Paid out each pay period radio button, add 0.0 to the Percent of pay earned. Click OK.

Holiday_Bonus_1Holiday_Bonus_2Holiday_Bonus_3

2. Next, let’s add the policy to the employee profile:

Choose Employees from the left hand navigation bar. Click on the name of the employee. Click on the blue pencil icon to the right of the word Pay. On number 4, use the drop down menu to select the Bonus Zero policy we added in step #1. Click Done on the bottom right.

3. Let’s pay the employee:

Run the bonus payroll by selecting Bonus only from the Run payroll drop down menu. Choose As net pay or As gross pay and click Continue. Select the employee(s) getting a bonus, and add the amount of the bonus (or net bonus) to the $ field. You can also add a memo if you want. Review the cheque by clicking on the blue pencil icon on the right. Confirm that the amounts are okay and click OK. You will return to the previous screen. Confirm the bank account and the pay date and select Preview payroll. On the next screen choose Submit payroll. On the next screen enter the cheque number and print pay stubs. Click Finish payroll.

4. Return the employee back to the original vacation policy:

Choose Employees from the left hand navigation bar. Click on the name of the employee. Click on the blue pencil icon to the right of the word Pay. On number 4, use the drop down menu to select the original vacation policy. Click Done on the bottom right.

SUMMARY:

This is my experience only. Yours may differ due to the many possible options in the company file, the payroll settings, and the employee profile. Use the CRA Payroll Deductions Online Calculator (PDOC) to calculate and compare figures if in doubt. And as always, consider trying it out in the test drive file first.

How the Print later feature works in QBO

Today I searched like crazy for the Print later box while creating an invoice in QBO. I double checked my Company Settings to make sure that my preferred delivery method was Print later. It was. But all I could see was the Send later box at the top of the invoice. After some exploring, I finally found the Print later box. Click on the Print or Preview option at the bottom of the invoice, and you’ll see a check mark box:

Blog_post_capture_II

HOW TO BATCH PRINT IN QBO

Once I had confirmed that my invoices were selected to be printed later, I went to find the print queue. But there isn’t one! Well, at least not like there is in desktop. Here’s how this functions in QBO. I’m using Chrome which is the preferred QBO browser.

First, go to Transactions on the left hand navigation bar. From the drop down menu, choose Sales. Click Filter. Choose Invoices for Type and Print later for Delivery Method. Click Apply.

Blog_post_capture_V

This will show you all the invoices in your print queue. Simply choose the invoices you’d like to print by checking them off and selecting Print transactions from the Batch actions drop down menu.

Blog_post_capture_VII

Your invoices will open in another Google tab (all of them in the one tab – scroll down to view). Right click to select Print, choose your printer, then click on Print. When you click back over to QBO, notice the following screen. If everything has printed correctly, select Yes. To leave them in the queue, select No.

Blog post capture

HOW TO GET RID OF INVOICES YOU DON’T WANT TO PRINT

Use this same method to remove invoices from the queue you don’t intend to print. Choose the invoices you want removed from the queue by checking them off. Choose Print transactions from the Batch actions. The invoices will open in another Google tab, just like in the previous example. Instead of printing, you’re going to close the tab that just opened. This takes you back to QBO and the message that appears in the screenshot above. You will be asked if you want to mark the selected transactions as printed. Say Yes. Your print queue should now be empty.

The nice thing about doing this in QBO (as opposed to desktop) is that you don’t have to ‘cheat’ printing the invoices to a PDF file. Note that this also works with sales receipts and expense transactions.

What to do about a blank page in QBO

QB Tip of the Day Blank Page

Post Navigation