thinkQuickBooks

helping right brain professionals navigate the left brain world of accounting

Archive for the tag “accounting software”

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

“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

“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

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.

 

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.

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.

What to do about a blank page in QBO

QB Tip of the Day Blank Page

What do to if your TD1 amounts are not updating in QuickBooks

Happy New Year! We’re a few days into 2015, and I’ve come across several client files where the current Federal and Provincial TD1 amounts are NOT updating. This is a known issue in QuickBooks desktop and hopefully there will be a fix soon.

First things thing. Please make sure you have the latest tax table installed in your software by going to Employees < My Payroll Service > Tax Tables Updates. Here’s a link explaining this in greater detail:

http://support.intuit.ca/quickbooks/en-ca/iq/Update-QuickBooks/Update-tax-tables-for-QuickBooks-Payroll/HOW15192.html

Now that you’ve confirmed you have the latest tax table, it’s important that you check your TD1 Review List to make your employees have been updated with the current Federal and Provincial amounts.  I run this report before running payroll at the start of every new calendar year. Here’s how to check:

Reports > Employees & Payroll > TD1 Review List

You will see a list of your employees. The columns contain the Payroll Province and Federal and Provincial ‘Current’ and ‘Suggested’ TD1. If the ‘Current’ doesn’t match the ‘Suggested,’double click on the amount. You will now be in the Taxes and TD1 for (Employee Name) window. Override the incorrect ‘Current’ amounts with the correct ‘Suggested’ amounts. NOTE: if you’ve ever used a ‘Custom’ amount (in other words, you’ve entered something other than the basic default amount into the employee profile), this amount will ALWAYS need to be manually updated, unless you change back to the basic ‘Suggested’ amount (and the updates are working properly). Now would be a good time to hand your ‘Custom Amount’ employees a blank Federal and Provincial TD1 form so you can update their tax credits in Quickbooks. Here’s the link to the forms for 2015:

http://www.cra-arc.gc.ca/formspubs/frms/td1-eng.html

It’s worth noting that “Individuals do not have to complete a new TD1 every year unless there is a change to their federal, provincial or territorial personal tax credit amounts. If a change happens, they must complete a new form no later than seven days after the change.” This is from the following page on the CRA website where you’ll find more information about form TD1:

http://www.cra-arc.gc.ca/tx/bsnss/tpcs/pyrll/hwpyrllwrks/stps/hrng/td1/menu-eng.html

If you’ve already run the first payroll of the year, don’t panic. Just go in and make the changes now.

 

Don’t turn on multi-currency in QBO by accident!

Don't turn on Multi-currency by Accident!

Post Navigation