Marion is a Speech Language Pathologist with a home office

Marion loves what she does, and that she can be home when Emma gets home from school... Click on the title to read the story.

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS

Q&A Week 3 Working Papers: Mastering QuickBooks Software

Click on the title to register for Week #4

Here are the questions from Week #3

Q: Ongoing dilemna regarding professional judgement..client hands me a receipt that has some sor tof business expense written on it.. because I know the client, I know it's a personal expense...how do I handle this? Just go with what's written on the receipt?  It's such a grey area..
A: Highly recommend several activities to help with ethical dilemnas like this one. One, take an ethics course, CGA BC offers them. Two. Read the IC-01 about Civil Penalties on the CRA website and learn about the penalties for ignoring what you know. After you've read that guide, consider the penalties for ignoring that niggling feeling that you should know better, the minimum fine is $1,000 and the maximum is $100,000. I found it makes it much easier for me to listen to my gut when I know my pocketbook could be affected directly.

Q: Can you show how you will tie your ADJ TB references into the OneNote file?
A: I would include the ADJ Trial Balance references on the WTB (Working Trial Balance) in QuickBooks and then include a copy of the WTB in the OneNote file

Q:Can you sort to find transactions dated for a prior yearend, but entered after a specific date in the year year?
A: Yes, by adding an Entered/Last Modified column to the detailed transaction report, then filtering the Report Date Range for last year and then Sorting by Entered/Last Modified

Q: Do we need to do a working paper for each account?
A: Yes, probably a good idea, and even for accounts for which there is a nil balance beginning and ending, as there may be transactions that went through the account and those may be important.  One example, might be where a Deposit is received from a customer and it's coded to a Clearing Account.  Then the Deposit is paid out to the Shareholder directly, without any transaction recorded or reporting a dividend payout. (Ugly coyote, very fraudulent)

Q: Eileen mentioned 2 courses, Auditing, aka external audit firms do this type of audit and Internal Audit, aka Management Auditor audit internally for effectiveness and/or efficiency. Can she list typical places where these courses are available for bookkeepers who aren't accounting students as in CA, CGA, CMA?
A: Your local college will have equivalency courses.

Q: I perform a number of new QuickBooks setups annually, typically with similar GL's. Is there any suggestion on how to bring in the customized/memorized report list to the new install re Lead Sheets, Ledgers Reports, Mgmt Reports Etc.?
A: Go to the MemRep List. Select the MemRep you want to export. Go to the bottom of the list and select Memorized Report dropdown menu. Select Export Template, name it and save. Open the new data file, go to the MemRep List and Import Template. Edit the Template to ensure it's compatible.

Q: In the P&L report, double clicking on the total provides a more detailed report, showing debits and credits which is a fast way to see if something is posted backwards
A: Same with any account or category on any Summary report, such as the Balance Sheet, Income Statement, Customer Receivables, Payables. But.. that report doesn't give you as many options to add columns or to filter as does the Custom Reports > Custom Transactions Detail. You'll find Custom reports on the drop down of Reports on the top menu bar.  That report opens you up to all the possibilities that exist.  Drilling down only provides some of the functionality.

Q: What do you do if a company starts as a sole proprietor then gets incorporated? Do you have to do a different company when incorporated?
A: Great question, in fact, I'd say it's the best of the day.  Yes, it's absolutely essential to start a new business and and a new general ledger, as well as to register for a new BN #, WCB #, Payroll & GST/HST, etc. A company is a separate legal entity.  When the sole proprietorship winds down, they must sell their assets, net of their liabilities, if they choose, to the new company.  There is the possibility to roll the assets, net of payment for those assets, plus taking back shares, tax free via a S. 85 rollover and that requires a written contract between the sole proprietor and the company. This isn't something that you just do, this is something you pay an expert in this area of taxation to do, as not doing it right can cost big. For example, if you didn't sell the goodwill of the business and take back shares and boot (debt) there could be a significant problem down the road should the goodwill grow and the company never bought it at the beginning.

Q: Which Item Type would you use for COGS/Revenue?
A: You could use any or all of the types. It depends on what you are doing.  There are various types and you might use any one of them, depending on how you wanted your reporting to look.  Try out some different types to see what the reporting looks like by going to the Report drop down menu and selecting Jobs, Time & Mileage reporting, and open up the Sales by Item Profitability reporting.  Remember that you have to record the Customer Name on the Purchases to get this type of reporting to work (I know it's not logical, and if you don't know the customer name, make up a fake one and use it on the Purchases in the Item side of the Tabs to get the reporting to work)

Q: If the bookkeeper provided the working papers, would it be reasonable to expect some savings for the client on the accountant's year end fees? 
A: You'd think so, but I doubt it, as the accountant still has to review all the work, and that still takes time.  It helps the bookkeeper and the business to ensure they have done everything possible to reduce the accountant's time though, and provides a level of assurance that to the best of their ability they have done everything possible to reduce costs.

Q: You were going to explain Name and Source Name and why you need both
A: The Source Name is the name of the Vendor on a Bill.  When you assign a Customer to that cost, you'll find that the reporting picks up the Customer name in the Name field.  If there's no Customer name included in the Bill on the cost line, then the default is to report the Name as the same as the Source Name. See the Q&A above discussing the use of Item Profitability and why it's required to allocate costs to customers in order for the Item Profitability and Job Profitability by Customer reporting to work.  If your costs of goods sold have all been assigned to Customer Names, then you'll find that the Item Profitability and the Job Profitability reports agree to the Income STatement Revenue less COGS (Net Profit before Expenses) but only if you used Forms and on those Forms utilized the Items side of the tabs to record the COGS.



  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS

How to be a 'Paper Angel' for your parents

Concerned about your parents and how you could help with downsizing?

Click here to see 24 fillable forms and be sure to flip through the pages...

Purchase the Word Fillable forms for $3.95 plus tax

The forms are delivered in two versions, Microsoft Word 2003 and 2007 (.doc and .docx) and the 2007 versions works in Microsoft Word 2010.

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS

Paper Angels

When I explain to people that I'm writing this book about how to organize your paper, each person I tell, in turn tells me about how there is someone they are close to who is struggling with the process of doing exactly that, taking over the financial affairs or becoming concerned about the financial affairs of a senior who is close to them.

It may be mom and dad who are just not as competent as they once were, or it could be the spouse who cared about the finances in the couple has developed early onset dementia, or it's the widow struggling to take on the finances after a lifetime of being looked after in that way.

My municipality, Delta, BC has a program called "Snow Angels" where seniors can call in if they need their snow shovelled if there's a storm. An army of volunteers signed up to help, but reports from the recent snow fall were that seniors who had signed up almost all called in to say that someone was caring for their needs and the didn't require assistance.  The volunteers weren't needed this time around.

I wonder if you created a program for seniors to help them to organize their paperwork, hence the "Paper Angels" to assist in the process of downsizing, would volunteers be met with the same resistance to assistance? Probably. Most seniors, until they can't do it for themselves, are likely to resist any efforts to assist them with their paper.  They've after all handled it this far, no need to rock the boat.

But if you are one of the 'watch crew' monitoring how a senior is doing, one of the leading indicators may be that their tax return filing isn't being completed correctly.  And these days, CRA is more likely to catch that than it ever was before as their programs to cross check the TSlips to the income reported are much more vigilant than they used to be.  The Auditor General in Canada brought to the CRA's attention that there wasn't enough cross checking, especially on slips like T3's.  That's probably been rectified by now, and combine that with some pretty stiff penalties for not reporting your income, and the senior in your life may get a notice that their bank is being garnisheed for some pretty substantial coin, and not just for tax not paid, but based on 20% of income not reported.

Why would they care if income wasn't reported, even if there is no tax owing? Because both federal and provincial social benefit programs, for example OAS, GIS, Pharmacare, Medical Services Plan, all have substantial programs to assist low income seniors and the threshold is based on the calculation of net income.

Where would you start?  Click here to see what the forms look like!

I'm writing a story to show how it's possible. It's in re-write mode at the moment, so you'll have to wait. If you need to get started right now, some tools to assist you to organize the paper. I sell a starter kit of 24 checklists in Word Fillable Format, for $3.95 plus tax. You can enter information into the Word form, save it, then call it up later to add or edit the file. Create multiple files for you, your parents, your kids..

If you're in your 50's and have aging parents, or you're one of the aging parents, and you can use Word and know how to save a Word document, it's easy.  If you aren't, you could print out the forms, and complete them by hand.
In either case, you'll need a banker's box, preferably one with a lid attached, or a plastic tub that holds legal size folders, plus a package of legal size folders to get started.

Complete the fillable forms, and while you're at it, start dredging up the paper to put it into the folders in the same order.  By the time you're finished, you should have no paper left in all those nooks, crannies, drawers, cupboards and closets.  There should be a pile of shredding, consisting of empty envelopes that every senior I've ever met seems to hoard.  Lord knows why you would keep the envelopes for your bank statement instead of stapling everything together for the month and keeping it in a pile, flat, so you can sort through it easily to find something is quite beyond me. Included in that pile of shredding will likely be grocery lists, letters you don't want found when you die, hydro and telephone bills for many years prior, articles you thought you would respond to...and I could go on.

Why would you want to see those bank statements again?  Several really great reasons.  First, you want to check that all of your income has been reported,and the fastest way to ensure it's been captured is to make a list of your deposits during the year, documenting any deposits that aren't income as to the reason for the receipt.  You'll need them if you're ever audited, or if you die, it will give your executor assurance that returns were filed correctly, so it's a great idea to keep them with your paperwork.

The second, is to check for medical expenses, as even if you don't have taxable income, if you do have some income from working, there is a significant, as in over $1,000 Refundable Medical Expense Supplement to claim per person for claiming medical expenses if you are a low income earner.  Even if you don't pay tax, you should always keep your medical receipts, because in the year you die, you can claim back 24 months prior for medical expenses on your final return.

Be your own Paper Angel first, then start to help others if and when they ask for your assistance.  Making the transition to old age, and not being able to care for your own financial transactions can be easier if you've got systems in place.

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS

Working in 'what-if' land

Question: Eileen, a client ask me if we can estimate an corporate tax return.  I told him that I have to do the bookkeeping to come up the numbers.
Answer:

To know enough, you'd need to really know your client, this couldn't be someone you have no idea about or about their business or their knowledge of business and taxes.

If they wanted to come up with estimated numbers, you could run a return  on an estimated basis to see how much tax would be owing, but of course you would want to ensure they signed off that this was not even an estimate it was a ‘what if’ scenario, based on the following assumptions and make them tell you the assumptions they used to arrive at the numbers.


I’d suggest you purchase the CGA Canada Public Practice Manual and look at the FOFI section for guidance on doing FOFI as there are two types.  CGA BC also runs classes for a half day on practice management which include something on dealing with clients who want a 'what-if'.

FOFI is short for Future Oriented Financial Information (I was the contributor of this section of the CGA Canada manual many years ago now)


  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS

TurboTax Online Student WorkBook...if you want to learn about tax...

The article is running today ( http://tinyurl.com/7sfrw52) in the North Shore News and should be picked up by the Coquitlam Now on Friday.  

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS

Working papers for compilations

Question:
For notice to reader do we have to prepare working papers for all accounts or just the assets and liabiltiies.  Do we have review the accounts.  For notice to reader is just taking the numbers and putting in the financials format and not audited or verify.

Answer:
I know that there is always dissention about this topic. This is always the question, how much work is too much work? I'm going to answer it obliquely and hope you understand that there is a difference between doing work for tax and doing work for accounting.

If you are preparing a tax return, then you need to document your work for tax return preparation, it's not about the financial statements at all, it's about preparation of schedules, and the return(s).

There is always confusion about whether you are doing work for tax or work for financial statement preparation. I side with doing tax work, as that's what most clients are hiring you for, especially when it's compilation, as that's what will likely bite back if it's not done correctly.  There is no test in the Income Tax Act for determination of materiality. That's an accounting test. In the Income Tax Act the test is reasonability and business purpose.

Ask any accountant and they will each have their own answer.  Feel free to post yours below.  I'd love to hear them.


  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS

Naming when using QuickBooks

If you want transparency in your records, it's important to name every transaction and cross reference purchases of products that can be matched to jobs to cost of goods sold and expenses

Where appropriate naming the purchase to cross reference to the customer provides proof that your costs relate to jobs for which you've billed customers.  There's nothing worse than someone wanting me to do their books and none of the job costs are cross referenced to customers. 

Why would I say that?  Well just maybe they didn't record all of their revenue and they don't want anyone looking too closely.  I once had a client (former immediately, I will add) who informed me that they didn't bill out for jobs on certain days of the weeks, at least not on the books, so if they recorded the cost of those jobs and cross referenced to the customer, those customers wouldn't be on the books.

Another reason you want to match costs with sales is to check that you have billed out all of your costs to clients. I don't know how many times I've found customers don't bill out for all of their work.  It's no wonder they don't make a profit.

Then there's costs that are accumulated in advance of billing and when there's a cut-off period, and those costs don't match to revenue, they must be adjusted out as costs for future matching.  In other words, you don't get to claim those costs until you bill those customers.

The reverse works too, if you bill out in advance, and that revenue is not yet earned.




  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS

Just sayin' chocolate is consumable by humans...

Income tax rules about meals... more on that front..
Chocolate is a food, it's consumable by humans, therefore, giving chocolates falls under the meals and entertainment 50% deductible rules.

The only time something is considered Advertising and Promo, is when it's not consumable by humans.  It's perfectly acceptable to give dog treats instead, and those, not consumable by humans, if they really were a reasonable expense, could be gifted as a promo item. However, to make them more acceptable, you might want to ensure they have some sort of reference to your company stamped on them, not just a bag of dog treats... as Advertising and Promo should be something that advertises your company, not the company whose product you are giving away.

That's why all those big companies give away mugs, hats, etc. with their company logo on it.  They're pretty smart, they've figured out the rules and realized that chocolate isn't going to cut it, and they want to make what they do give away memorable and lasting.  They don't want you consuming it, they want you wearing it, displaying it, so the longevity matters...

I don't know how often I run across new business owners who give away chocolate.  It's just not the smartest move they could make, given the tax rules, but hey, I wouldn't turn it down, but don't expect me to display it, or keep it very long, or remember who gave it to me, because chocolate just doesn't have any of those qualities.  Just sayin'

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS

Meals & tips

If there isn't documentation of who was there, what was discussed and the business reason for a meal, it's likely that if you can't remember or don't have it written down in your documentation/calendar/file somewhere...it's going to questioned and possibly denied by an audit.

It's necessary to keep the document that shows what you ate and drank, and the credit card slip that shows you paid for the meal.  Both are actually the basis of a complete paper trail of your business expense.

Writing down who, what, and the business reason on the back of the receipt will provide you with the best paper trail possible, and doing it at the time means you don't have to rack your brain later to figure out who, what and why.

Tips are allowed to be claimed as long as they are reasonable of course, as are meals. Tips however, are not eligible for a claim for the ITC as the waitress isn't a registrant.  It's necessary to segregate out the GST/HST paid on the receipt and claim only that amount when you file your GST/HST return.

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS

QuickBooks List Sorting Tip

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.

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS

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.


  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS

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.




  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS

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.

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS

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:

  1. Change your Twitter password
  2. 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
  3. Hopefully they aren't using the same password for Twitter that they use for everything else, because they should change all those passwords too.

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS

News: IC99-1 on RDSP's just published

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS

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



  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS

Are you hoping to learn how to use QuickBooks to create working papers?

Click here for the ten part series, 20 hours of training recorded in March 2011.

Then follow that up with the five part series, another 5 hours on how to develop a working paper 'work product'

... did you know that there is fierce competition among the various accounting bodies and publishers for working paper checklists, considered 'work product', and that working paper checklists are copyrighted material?  For example, CGA Canada sells their Public Practice Manual online for $415.

What goes into the creation of working papers?
Education, knowledge, expertise, training, experience, blood, sweat and tears, hours and hours of reconciling accounts, vendors, customers, payroll, compliance with taxes, until it's right...and a significant dose of professional judgement

Click here to learn more about the working paper series

and learn how you could link your QuickBooks reports via Excel into Microsoft OneNote to create paperless working paper files to save to a PDF.

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS

Audience Appreciation

Thank you for the many encouraging remarks in the survey for the first in the working paper series.
...by way of explanation about the incomplete data file:

Comment: "I felt that perhaps the presenter was a bit unprepared because the QB file wasn't completed fully enough to allow a straightforward presentation of a topic"

I'd like to think of this working paper series as Art reflecting Life. 

Of course the file wasn't complete, that was on purpose. To tell a story it's necessary to have not only the scene, the characters, but to have obstacles to overcome so you can make a point...the moral of the story is...  There's no story without obstacles and there's really no need for working papers if the data is already perfect.

In the business of keeping records, whether you call that bookkeeping or accounting, I don't care what you call it, nothing is straightforward, and it's never completely finished until well after either the person or the company is dead, as much as several or even more years. If you're looking for an occupation where there's a finished product you hang on the wall, keep looking, this isn't it.

And much more about appreciation

...for those of you who said that I'm really easy to listen to, that the first workshop was really informative, and who really truly appreciate the time I take to build my slides and keep to the format set out, thank you! 

Your positive feedback gives me encouragement and insight. I do this for you because you do appreciate the hours and the expertise that goes into creation of these presentations.

Apology
for a mis-quote: "Here's your sign" is not Jeff Foxworthy's quote, it's to be attributed to Bill Engvall. Bill is told by Jeff to tell these jokes....

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS

Working Papers Session #1 Q&A Click here to register for #2 through #5

Click on the title to register for Sessions two through five. This is a 5 part series airing every Wednesday at 11:30 am Pacific Time over the next few weeks.  Session 1 aired January 11th and if you missed it, you can now purchase the recording, or wait until the end and purchase all five in the series for a discounted set price.  A portion of the proceeds from the event and video sales is for IPBC.

Click here to buy the recording of Session 1

Participants asked questions during the workshop and here are their questions and the answers.

Working Papers: Mastering QuickBooks Software
Session 1 Q&A

Q: If I run the Client Data Review as the Admin, can an External Accountant run another one? Or will anything I put in be seen (notes, etc) by the EA?

A:There's only one Client Data Review tool. If the EA logs in they will see the work done by the EA.
If I were to make a product suggestion to Intuit it would be to allow the same capability for date stamping as the Notes function and to insert the name of the user in with the notes.

Q: "Didn't you already manually key in an AP entry against OBE?"

A: OBE is Opening Balance Equity in case you weren't sure. No, I hadn't made any manual entries as there weren't any entries in the 'mythical' case study. If there had been, then there would have been something there. The best way to key in opening entries for vendors and customers is to use the Bill or the Invoice/Credit Memo and to create an Other Charge Item for Open Bal Equity to link to the Open Bal Equity account. Then key in each opening balance by invoice/bill so that you can pay or clear them against future deposits/Bill Payments. This requires reconciliation of each vendor/customer and is a worthwhile exercise anyway.

"Q: FYI - CGA - Canada Public Practice Manual (on CD) is available at the Vancouver Public Library looks like there is a lending copy in addition to reference copies. Useful to check before buying?

A: Thanks, didn't know that. Is someone on the Vancouver Library system able to tell me if that copy is available electronically online through their online library or only in house?
"Q: Sorry missed the info about signing up for free membership can you repeat"
A: Participants or video purchasers will find the instructions to sign in to the Resources page at the beginning and the end of the video.

"Q: Are the review sections printable?

A: The review sections don't appear to be printable. This is where having an inexpensive tool like www.techsmith.com SnagIt or knowing how to cut and paste screenshots with your Microsoft package comes in handy. If I were to make a product suggestion to Intuit it would be to make these printable and to make them exportable to Excel like other reports.

"Q: how do we get One Note

A: Microsoft OneNote is part of MS Office, but not in every version of MS Office. You may be able to purchase it separately, but I can tell you it took me quite a while to figure out how to do that when I wanted a copy on a laptop several years ago. They didn't make it easy.

"Q: Do you have to send the accountants copy to view this or any back-up copy.

A: You can view the Client Data Review Tool as long as you have the Accountant Edition. ProAdvisors get the Accountant Edition with their membership. The prizes that Intuit is offering will include this feature. This is one of the benefits of membership, having the Accountant edition.

"Q: Lots of problems with bringing back acct's copy any recommendations on reducing the number of times this fails...?

A: Call Intuit for support and if you are a ProAdvisor, those calls are free, or at least for one use licences, there is a number of free calls, I believe it's 12. See the Intuit ProAdvisor website at www.proadvisor.ca

"Q: What version of Microsoft Office has one note

A: See http://office.microsoft.com and while you're there, load a free template or find learning resources and images and you can load a free trial. It appears all three packages, including Office Home and Student come with OneNote 2010: click here

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS

Delta Library presentations

Mark your calendar,

January 19, 7 pm at Ladner Library, and/or February 15, 7 pm at Tsawwassen Library,

I've been invited to talk about Financial Literacy across the Generations.

Bring your questions about organizing your records and about tax, both personal and business and managing your money.

Big topics for only 1.5 hours... but hey, let's have some fun with it.

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS

Two more things...review the TD1 and amend back for 10 years (carefully)

1) To review the personal tax credits, it's a really good idea to read the TD1 from top right to the bottom.See the five lines where the $2,000 (federal only) Family Caregiver Amount is added? Some provinces/territories may have added a similar credit and some haven't.

2) It's possible to apply back for ten years under the fairness provisions to request a re-assessment of your taxes to claim for missed credits. But keep in mind that you must come clean on any missed income claims, or over claiming of expenses in those years at the same time under the Civil Penalties rules.  There's a new form to assist with a claim for taxpayer relief called RC4288 Request for TaxPayer Relief and sometimes, opening up old years can result in tax payable, requiring a Voluntary Disclosure to be considered.




  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS

Confused in Ontario...

This loaded with questions email arrived just now..
Eileen I've been trying to figure out how this Disability Tax Credit works. My tax person said cause I collect regular cpp & wsib I don't have a taxable income and it would do me know good to apply for it ( I am 60 ). When I asked about transferring the credit to my son, I was told cause I don't live with him I can't. I have read many links on this tax credit and not once have I seen stated that I have to live with him.This tax credit was told to me a few years ago and at that time apparently I could do it, but not now. Can you tell what the rules are for applying? Also if I can apply, can I do it separate from my income tax this year? Is the T2201 form that needs to be filed out by a doctor,is the cost covered by ohip or do I pay the cost? ...Even though I live on my own since 2004, once my son went out on his own, my income is not a lot to live on and you have to either go without or limit it so you can pay for more important stuff. Why should a child have to live at home to help out a parent that is single? If a child gives an X amount dollars to their parent to help them out with food,clothing,meds,or rent, why isn't that help towards supporting them?

I would appreciate any input you can give me on this and what I can or can't do and what would be the best way to go, if you feel I should apply.Thank you for your time and help and being there for people like myself that is confused from all this. Thanks again and have a great day.

Here's my answer because I'm sure this woman isn't the only one asking these questions, and I hope I answered all of the questions as best I can:

The official place to look for information is the Canada Revenue Agency website.CRA publishes a guide, RC4064, which explains the credits and how they work.
http://www.cra-arc.gc.ca/tx/ndvdls/sgmnts/dsblts/menu-eng.html

To apply for the DTC, your doctor(s) must complete T2201.  Read the Form T2201 to review under which section you think the doctor might be qualifying you.   Review the cumulative effects definition as it’s possible you may not meet the criteria for one severe and prolonged marked restriction, but two or more significant restrictions might equate to one marked restriction. Remember disability isn’t a diagnosis, it’s an impairment in ability. As for whether OHIP will pay for the form completion, you’d have to ask them.

As for whether or not your son supports you…let’s be really clear, money to help out is not considered to be support.  Support is direct payment to third parties for basic essentials, which is food, shelter and clothing. Interpretation bulletin IT 513 discussion about support is about as clear as you are going to get. That doesn’t mean it’s easy to understand and apply. See the Appendix for a story about support that may help explain what is meant by support.  There is no such thing as a sponsor. I don’t know where that comes from. If someone supports you, that’s not sponsorship anywhere I’ve ever seen.  Someone has made up that term. Here’s a link to what CRA says about tax credits and transfer of credits to relatives because of support (see the appendices):
http://www.cra-arc.gc.ca/E/pub/tp/it513r/README.html

As for whether or not you can transfer the credit to your son would depend on whether or not the facts show that he supports you with basic essentials, food, shelter and clothing. Medical isn’t on that list. You don’t have to live with your son for him to make the claim, but he does need to pay for basic essentials.  The problem is that with your income from CPP and WSIB aren’t you paying for the basic essentials yourself?

If your son pays for your medical costs directly to third parties (not by refunding you with money) he may be able to claim those if he supports you on Line 331 net of 3% of your net income (no $10,000 limit after 2010)

As for applying for the DTC, form T2201 is completed by your doctor.  The doctor can ask for assistance from CRA or can read or visit the CRA website to look at the videos for doctors that explain how the credit works.
http://www.cra-arc.gc.ca/tx/ndvdls/sgmnts/dsblts/qlfd-prcts/menu-eng.html

You’ll find links to that information on my website in the complimentary links down under the Family information section.
http://www.taxdetective.ca/links.html
And the direct link to my family info page:

And… as of 2012, your son, even if he can’t claim you because you don’t qualify for the Disability Tax Credit, might be able to claim an additional $2,000 federal credit for the Family Caregiver Amount if he qualifies to claim you as an Infirm Dependent over 18.

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS

IPBC Working Paper Series Starts January 11th 2012

If you don't attend all five in the series, you'll miss out on some great door prizes from Intuit Canada!

You won't want to miss out on these prizes! 

Register for each workshop separately right now on the www.ipbc.ca website at this link:

http://www.ipbc.ca/events/event_list.asp?show=&group=&start=10%2F15%2F2011&end=&view=&cid=4797

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS
ban nha mat pho ha noi bán nhà mặt phố hà nội