If you want to sort your names list because it's out of order, Open a Write Cheque Form, click on the dropdown on the Payee Name then select Ctrl L and a Names List opens up.
At the bottom left corner of the names list you can click and select Sort List to return the list of Names to alphabetical order.
It reminds me of the 'Sorting Hat' in Harry Potter because it's secreted away so you have to know how to find it, and remembering what to click is a pain for those of us passing through menopause...
Isn't everyone at Intuit except Scott Cook under 40, and they don't wear progressive lenses and can still read small print. (LOL)... and they can remember stuff like this.
Why they can't just put the Names List on the List of Lists on the Menu Bar is quite beyond me.
QuickBooks List Sorting Tip
Meals at 100%
Someone recently told me that they have weekly meetings with all the staff and because everyone is there, they write off the meals. Something at the back of my brain objected to that claim.
See S. 67.1(2)(f) for limitation to six events per year
And.. if employees are being fed regularly and aren't contributing their fair share, there may be a taxable benefit called an empoyee fringe benefit that applies. Click here to see IT470 Employee Fringe Benefits for more information.
Session 2: Working Papers Series Q&A
What an interesting session with great commentary and thoughtful questions. We covered starting up a working paper file in Microsoft OneNote, explored the 2012 Report Centre, then focused on creation of reports for Lead Sheets and the intricacies of Modifying and Memorizing reports, and ended with Grouping of reports to facilitate instant creation of a group of reports. Below are the Q&A.
Oh yes, forgot to mention it, but your homework is to read the second article on the Resources page before next Wednesday.
Q: Is a public accounting licence required to prepare and sign off on NTR statements:
A: Apparently not! I didn't know that you could sign off on NTRs if you weren't licenced, but apparently you can.
Rumour is that might change if there's a merger as the three bodies will pressure for a change to provincial/territorial and federal Companies Acts. See more on this question below. In no other profession can non professionals do work relating to the profession without anyone complaining.
Q: Are these webinars available on the IPBC website
A: No, they will be available for sale on my website. Link to my website via my Partner page (for member prices) on the www.ipbc.ca website home page or directly www.taxdetective.ca/shop.html (non member prices)
Q: At the end will you show examples of each of these categories under each tab?
A: I think this question relates to my commentary about the types of engagements, Draft for Management, NTR, Review and Audit. No, I don't have time to create working paper samples for each type. Anyone who wants to take that on as a rather ambitious project is welcome to do so and share with the others. I'll post a link and credits on the Resources page if anyone does that! Happy to share.
Q: Breaking Bad LOL
A: This was in response to my commentary that most of us are women in the bookkeeping industry and the role models TV is portraying these days about our industry involve women who are supporting a meth cook, and a motor cycle gang. Gemma plays the role of accountant as well as matriarch (sound familiar?) in Sons of Anarchy.
Q: Can we get a copy of this page to use as a reference?
Q: Will you be posting this to the website in the next few days?
A: The resource page has useful links and I will update it to include the OneNote PDF at the end of the series
Q: Can you not save the PDF under File: in QB instead of Emailing it to yourself?
A: Yes, thanks for pointing that out, I hadn't noticed File>Save as PDF, learned something from you today! That's why I do this!
Q: Can you show how to save a PDF to the OneNote page?
A: Showed how to attach a file to the page.
Q: Are copies of my PowerPoint available on my website?
A: Not yet, they will be on the resource page at the end. It's a work in progress, I add content as we go through the materials.
Q: Would you be willing to share a live copy of your OneNote file?
A: Not unless I was absolutely sure that it was secure. Louie P and I talked about that and decided it probably wasn't a good idea unless we had some technical assistance with ensuring it was secure.
Q: Great stuff Eileen! Is this file from MS OneNote going to be available on the IPBC website for downloading?
A: No, it will show up on the Resource page at the end of session 5. Have you read the articles yet? The first article provides a great way to review Lesson 2, as it walks you through the report modification process very thoroughly with snapshots along the way.
Q: OneNote package would be very nice as we could then open it and play around with how it actually works.
A: Start your own NoteBook and experiment. That's what I'm doing. I just figured out that this was a cool way to create paperless working papers two days before the first session. We're learning together.
Q: Is the QuickBooks Update button available in Excel 2007?
A: To explain, I was showing how the new report Update to Excel feature works between QuickBooks 2012 and Excel. You'd have to experiment to see if it works with 2007 or check with Intuit support, it's probably on their website support page somewhere. If not start a query in Live Community and see if anyone knows. Please report back to me and I'll let everyone know next week.
Q: I have been signing off on NTR's for 41 years, are you sure they are restricted in BC?
A: Turns out my assumption was not correct. There is nothing in the Companies Act in BC to restrict the preparation of NTR's to CA, CGA, CMA. Apparently, it's also possible to request under that Act to prepare an audit if you aren't licensed by your body to audit, and it's very rarely done. With the merger the three bodies coming together will likely press for NTRs to be added to the list of engagement types that are restricted to someone with a designation.
Q: I was told by a CGA practice reviewer that it isn't necessary to sign an NTR at all.
A: Don't know about that, but given anyone can prepare an NTR, that might well be the case. I am checking with CGA BC
Q: IF we make changes in QuickBooks, will the Excel report we save in OnNote be updated automatically?
A: No, it's necessary to facilitate the update either from the Excel end, or from the QuickBooks Update your spreadsheet end.
Q: IPBC provides its members with an engagement letter template for FS and T2
A: Yes, IPBC has a number of templates they have developed for members to access. If you are a member, check out the member templates on the www.ipbc.ca website.
Q: Are you sure the link is active (auto update) when you attach a file to OneNote?
A: Yes, when you attach a file, you are actually linking to the latest version of that file. Test it if you don't believe me.
Q: Where would you find the laws for the Province?
A: The www.CANLII.org website has all the laws for all the provinces and federal law as well as court cases. Each province will have it's own Companies Act. In BC, it isn't necessary to prepare financial statements for a company in certain circumstances, you can just prepare a tax return. I meant to mention that but the thought was fleeting and I moved on.
Q: Can you tell me how to create a new OneNote file when I have a file already?
A: Just add a new NoteBook, more than that, check out the Microsoft website for videos of how to use OneNote
Q: What is the acronym NTR?
A: Great question, NTR is Notice to Reader, and it's also called a Compilation Engagement. The terms are used interchangeably. This type of engagement has a standard that the work has not been reviewed or audited and has been compiled from what you were given. CGAs, CA's and CMAs have a standard that there must also be reasonability checkups and that we can't associate with a compilation which we believe would be false or misleading.
An NTR or Compilation isn't required to follow GAAP either, though if it would be misleading we can't associate. CGAs, CMAs and CAs have varying standards of care for preparation of NTRs and are required to have practice reviews by their associations to ensure that standard of care is maintained.
From a risk perspective, preparing statements and signing them can be a risky thing to do any time you don't know your client. Even though there isn't the same standard of care as a review or an audit, always ask yourself, do you want to be associated with these numbers, and what if someone sued because your name was on that page because they made a financial or other decision based on your signature being on that page, regardless of the type of engagement.
Ask yourself every time you sign, are you prepared to put out the deductible on your insurance? My deductible is $1000, what's yours? Do you know? And then, are you prepared to work with an insurance adjuster, doing exactly what they ask so as not to invalidate your insurance coverage to mitigate the circumstances, which may involve a settlement of some kind to make the problem go away to minimize damages?
Q: You can download a free program called DoPDF7 that functions as a printer. Your print your report, selecting P0PDF7 from your printer list to create a PDF report.
A: There are a number of PDF printers out there for free. QuickBooks comes with it's own PDF printer. I make no comment on your particular program as I haven't used it, but have used others, like CutePDF, but not for a few years, haven't needed to. I use SnagIt by www.techsmith.com and can turn anything into a PDF or any other file format. I pay for SnagIt and appreciate the program for many reasons as I use it to snag copy for articles and Procedure Manuals all the time. Couldn't live without it.
Q: You mentioned a 4th type of engagement?
A: Yes, I did. Draft for Discussion Purposes Only - Subject to Change. This is the type of engagement that you are preparing for internal management use.
See you all next week for round three. Remember, attending all five sessions entitles you to participate in the draw at the end for a one user, one year ProAdvisor licence and there are four of them available to be won.
Thanks for the prizes, Intuit Canada! www.proadvisor.ca to see what's included in a membership if you qualify for ProAdvisor status (payroll will be extra). Intuit will provide an equivalent if you don't qualify or you are already a ProAdvisor.
Videos from Session #1 and #2
It's possible to purchase the videos from Working Paper series on my website in the shopping cart.
To access member prices login to the www.ipbc.ca website and find the Partner page for me, Eileen Reppenhagen, CGA, TaxDetective to obtain the link to purchase at member prices. Non members can also link to the shopping cart that way, or go directly to www.taxdetective.ca/shop.html to find the working paper series products page. You can use PayPal or Visa/Mastercard to pay online, or call me if you'd rather pay via credit card over the phone. 604-943-7414
All video sales have a responder so you will get an email immediately after purchase, directing you to Click here to download and SAVE your videos to your desktop. You can play them as many times as you like, there's no expiry date.
Every accountant in the country probably just got a phishing message that could compromise their Twitter account.
If you click on a message that says
"you seen what this person is saying about you? and then there's a URL terrible things"
It comes as a direct message from someone you know who may not know they are sending this message.
Here's what to not do: Do not click to see what it is.
And here's what to do:
- Change your Twitter password
- Tell the person who sent it, look up their email and let them know they need to change their Twitter password as they have been compromised
- Hopefully they aren't using the same password for Twitter that they use for everything else, because they should change all those passwords too.
Keeping up with tax changes.. to learn more follow What's New on the CRA website
Did you know that corporate and personal income tax rate changes in 2011 and 2012 affect how beneficial it is to pay dividends versus paying salary?
If you haven't considered those tax rate changes into your formula, you might be unpleasantly surprised to find that dividends aren't necessarily your best option, especially if you have a personal services business.
Long Haul Truckers meal deduction amount goes up to 80% (2011) from 75% (2010)
http://www.cra-arc.gc.ca/tx/ndvdls/tpcs/ncm-tx/rtrn/cmpltng/ddctns/lns206-236/229/trnsprttn/mp-lnghl-eng.html
CCA on manufacturing and processing equipment acquired after March 19, 2007 and before 2014 is straight line 50%, See Class 29 for details in the link below computers
If you purchased a computer after January 27, 2009, and before February 2011, the CCA class is Class 52, a temporary class which had accelerated CCA. After January 2011, it's Class 50, at 55%
http://www.cra-arc.gc.ca/tx/bsnss/tpcs/slprtnr/rprtng/cptl/dprcbl-eng.html#class52
2011 is the first year you can claim Children's Art's Credit
http://www.cra-arc.gc.ca/tx/ndvdls/tpcs/ncm-tx/rtrn/cmpltng/ddctns/lns360-390/370/menu-eng.html
2012 is the first year you can claim the new Family Caregiver Amount, which is blogged about in earlier columns, and you need to get documentation confirming infirmity of spouses, children, relatives who are dependent before adjusting your TD1 with your employer to ensure you aren't paying too much tax during 2012.
http://www.cra-arc.gc.ca/nwsrm/fctshts/2011/m11/fs111122-eng.html
And in 2011, if you don't file your corporate tax returns electronically, there are penalties where revenue exceeds $1 Million and here's what's new for corporations;
http://www.cra-arc.gc.ca/tx/bsnss/tpcs/crprtns/menu-eng.html?bsn