Sunday, November 15, 2009

New Features In QB

Even though Intuit does produce a new version of QB every year, and would love for all users to buy the new version each year, most people wait a few years between upgrades.  Older versions of the program will still work.  I have some clients still using the 1999 version of the program. I’m just glad they’re using QB; so I don’t push them on upgrading


The changes and new features that are added to each year’s program are somewhat subtle when compared year to year.  However, when you jump to a version of the program that is many years newer, the difference is much more extreme.


I was reading the latest Intuit ProConnection Newsletter and noticed that they have a pdf chart showing when many of the newest features since 2005 have been added to the program.  It’s interesting for anyone considering upgrading.


They also have this 7 page pdf focusing on the changes specifically for QB 2010.


 

Using QB For Rental Properties


Q:



Subject:  QUICKBOOKS V QUICKEN


Hi Kerry,
 
I stumbled on your blog by typing in Quickbooks VS Quicken and you came up. I am trying to figure out what program to use. QB or Quicken and am confused. I hope you can help.
 
Here is the scope of my business on what I would use it for.  My wife and I are Realtors and re developers and own several rentals. We do about 20 million a year in sales under a corporation name, I do land and building development under different LLC' etc  and we have 15 residential and commercial rentals
I see with QB offers little or no property management capabilities, but Quicken has a whole program devoted to it. I would find it important to keep track of all mortgages, payoffs, expenses etc.....I do see people selling management software that is compatible with QB that I can by online
 
I would be nice to keep track of all our Stocks etc......(would not know how to do)
 
Some advise online suggests that unless I am carrying inventory in a store to keep track of then Quicken is the way to go, but I do see mainly accountants recommending QB.
 
Last question, I do not know what to do with, I am hiring a gal to process our transactions as well as bookeep all these for us, but I really do not want here to see what we are depositing as income. Is there an easy way to do that like her entering it at office then editing at home. Our office handles payroll so that is not important
 
Right not we use no programs only hand logs and some excel sheets and it is a nightmare especially at tax time, so we need to do something fast.Our accountant would be happy since I just did my taxes, luckily we paid in to much
 
I currently reside in Washington St but do have family ties to Arkansas where I see your from. I have tons of family from the Danville and Havana area's
 
Anyways any suggestions would be much appreciated
 
Thank you for your time


A:



I have addressed this issue several times.  While I used to be a proponent of Quicken, I stopped trusting it a number of years ago and only recommend QuickBooks for reliable double entry accounting.  I even forced all of our clients to switch from Quicken to QB.

QB can handle everything you need for your rental properties on its own without the need to purchase any add-on programs.  Many of our clients have dozens of rental properties each and have been able to maintain very useful books with QB; so it is entirely possible for you and your tax pro to set up your QB to properly coincide with your tax returns. Your tax pro should definitely be an integral part of the design process for your QB files.

In regard to having a bookkeeper only enter checks without the ability to see your deposits, I'm not sure how practical that would be.  It's also an obvious indication that you may not be working with a properly trustworthy individual if you aren't able to trust him/her with maintaining the confidentiality of your finances.

Good luck.  I hope this helps.

 Kerry Kerstetter 



Follow-Up:



Kerry than you very much for responding. I really appreciate it, the more I investigate I am finding all the same answers so I bought Pro 2010. Now I just got to figure out how to do it all.

  

Thank you!


My reply:



As I said previously, your professional tax advisor should be part of the process of setting up your QB, especially in regard to the Classes and Chart of Accounts.

Since our clients send us copies of their QB data files for tax planning advice mid-year and for tax prep work after the year is over, it makes things much more efficient to have the QB data synchronized with the tax return data.  You tax pro should be able to save you a lot of time in this way.

Good luck.

Kerry Kerstetter  


 


  

Wednesday, August 5, 2009

Installing QB on Multiple Computers

From A Client:

Hi Kerry,

Part of why I've been holding off on sending you the corp data file is because I have a copy of QB 2009 and that should eliminate our Accountants copy problem with my 2007 version (I think) but I'm concerned to upgrade - I have only one license to use and I'm currently running 2007 on 2 machines (yeah w/1 license still but I'm concerned that they've improved their license algorithms....can you offer any insite? i.e. has the file structure changed from 2007 - 2009 whereby I could keep 2007 on my wife's machine and her still be able to make entries?)

My Reply:

In regard to the QB installation issue, I have never had any problems installing a copy of the program on multiple computers with one user license. The user license for QB programs is more for simultaneous users of the program rather than on the number of computers it can be installed on. They do sell versions of QB for multiple simultaneous users so that several people can access a data file at the same time. That is not the same thing as having a single user version of the program installed on multiple computers. As long as you register the program with the same phone number on each computer, there shouldn't be a problem. I have been doing that for several years, including the 2009 programs.

Just in case you don't want to lose your 2007 settings, it is also possible to install multiple versions of QB on the same computer. I have every version from 1999 to the 2010 beta installed on my computer because clients upgrade at differing times. The key is to not use the default installation folders. I manually set up a main folder called QuickBooks and then I have a subfolder under that for each version of QB. When installing the program, I manually select the appropriate folder to install into. I also manually set up folders for where I want the data files to be held. This keeps each year's program nice and separate. I can also actually have multiple versions of QB open at the same time on the same computer; which I have needed to do on a few occasions.

Since you already have the 2007 program working, I wouldn't mess with its installation folders. You should set up a new folder for the 2009 program and install it into that folder.

As always, once your data file has been upgraded to work with the 2009 program, it will no longer be accessible from inside any earlier version of QB

I hope this helps. Let me know if you have any more questions or problems.

Kerry

Follow-Up:

Hello,

Thank you for the advice on QB. I now have 2009 installed and am using it for the personal and 2007 running for the corp. This way I can have both company files open at the same time having 1 set of books on 1 monitor and the other on the other - makes things easier!

Tuesday, August 4, 2009

New Password Requirement


From a client:

Not too happy with the Quickbooks new program I bought. It is now requiring a password to encrypt! Password is ******.


My Reply:

I was glad to see that you upgraded your QB program to the 2009 version. I hope it is easier for you to use

One of the new 2009 features that you used is the ability to send me QBX copies of your data files directly from within the program and via an online storage service hosted by Intuit. As you discovered, that feature does require you to add a new password security layer to prevent anyone who may accidentally download your file from being able to open that file. Once I have the file converted from the QBX format to the QBA format I actually use, the password is no longer relevant. This feature has been working well from my end for those clients using this new feature.

You also have the option of sending me files the old fashioned way. To avoid confusion, I made some short videos showing how to do this with the 2009 program. I have links to them on my website.

Thanks for your help with this.

Kerry

Thursday, June 11, 2009

Creating Accountant Review Files in QB 2009


From a client’s new bookkeeper (T):



I need the instructions as to what I do from inside quick books itself to create the zip file. I am sorry but I have never done this before.


Thank you,


 


My Reply:



What version of QB are you using (2007, 2008, 2009, etc)? There have been some changes in the process for sending Accountant Copies in the most recent versions; so I don't want to confuse you. 


 Kerry



T:



Kerry,
We upgraded from QB 2006 to QB 2009.



KMK:



Thanks for the update on the QB version you are now using.  The process for sending accountant's review copies of QB files was actually changed  quite a bit between the 2006 and 2009 programs.  There are now two main  ways to do it.
 
I am going to try to use a new software tool to make some little mini  videos on how to do this, which will hopefully be easier to follow than 
a written description.  I will send those on to you as soon as they are  done.

 Kerry


 
T:



Kerry,
Thanks for your help.  I will get the information to you as soon as you send me the videos.  Thank you so much.



KMK:



I've created and uploaded short videos showing the two ways how to create a QBX file in the QB 2009 program to send to me.

The first is the Save File function which is when you are going to send me the file yourself as an email attachment, an upload to my online storage service, or by copying onto a CD or flash drive.  The video can be found here.  




The second is the new feature that Intuit has, allowing you to send me the QBX file directly from within the program via their online storage service.  This doesn't work well if you have a very large file and/or slow internet service.  The video can be found here





I hope these are helpful. I will also be posting these to my QB blog and to my website.

Let me know if you have any problems or questions.

Kerry


 

Friday, April 24, 2009

Quicken or QB with online banking


From a client:



Subject: Quicken


Does Kerry do any taxes for people still using Quicken?  First Federal Bank has where you can download your bankstatements to Quicken but not Quickbooks.  So I have been meaning to ask about trying to use Quicken again in place of Quickbooks. 



My reply:



I used to use the online bank interface with Quicken for my accounts; so I have some experience in knowing when it makes sense and when it doesn't.

If you are going to enter all of your info into Quicken manually and use the online interface to match everything up, that will actually be a waste of time and money if the banks still charge extra for that service.  A lot of the times when this is done, the data from the bank doesn't match exactly with what you have entered in the Quicken file, so it enters the unmatched transactions as brand new entries, giving you a lot of duplicates that you then need to clean up.
If you don't want to print checks from your computer or enter your transactions yourself as you go, using the online banking interface to have the items imported into your Quicken file might make some sense. You will still need to code each entry with the proper accounts and classes, but it would save you a little time.

If you just want to check your entries against what has cleared the bank, you don't need to use the special Quicken interface.  That is what I do with our Regions and First Federal accounts.  I can see the current status of the accounts online for no additional charge and then match them up with what I have entered into our QuickBooks files.  That allows me to reconcile the bank accounts much more frequently than just once a month with a paper bank statement.

If you want to use Quicken to import transactions into your file, that would be fine with me.  You can then send me the data files.  I am no longer using Quicken, so I will probably import your data into QuickBooks in order to work with it for your tax returns.  However, if this works for you and other clients do the same thing, I may even buy myself a new copy of the latest version of Quicken and work with your data that way.
Good luck.  I hope this helps.

Kerry


 

Business Plan Pro

 

Entering bank account interest...


Q:



Subject: Bank Dividends


I am trying to add in a checking acct dividend that you would receive monthly from your bank.  Do you know how I would add this to my Quickbooks? I am from the US...I think they're a rules in how this should be done.


Help!!!


 


A:



You are actually referring to Interest income; not dividends.

I can easily think of at least three ways to enter interest income into QB.

1.  You can use a General Journal entry with a debit to the bank account and a credit to the interest income account.

2.  You can enter it with the Deposit window.

3.  While you do the bank account reconciliation, there is a place to enter the interest income, right below where you enter the service charges.


Either of those methods will achieve what you need. Just make sure you use the exact same date for the entry as the bank is showing so that your books will match up with the bank's.  FWIW, I use #3 for our accounts.

Good luck.  I hope this helps.

Kerry Kerstetter


 


 


 

New QB for a new computer?


From a client:



Subject: Computer


My laptop is dying. Should I get a new Quickbooks on the new computer?



My Reply:



According to my files, you have been using the QB 2003 program.  Technically, if you still have the original program disc, you can install it on your new computer.  The problem will be in updating it for maintenance releases that were issued after the original program CD.  Intuit doesn't provide any official support for any version of QB that is over three years old.  Support for the 2006 program is expiring in May 2009.

That means that this would probably be a good time for you to upgrade to the newest version of the program, which is 2009.  Your data can be rolled over into this new version without losing anything.  
You should actually like the newer version of QB better than the 2003 program.  It includes a very handy way to send me QBX files directly from within the program, using an Intuit online file storage service that is better integrated with the program than the one I use.

Good luck. Let me know if you have any problems or questions.

Kerry


Follow-Up:



Thanks. I will probably do that.


 

Friday, March 13, 2009

Moving from Quicken to QB

Q:

Subject: Data Transfer - Quicken to QB

Dear Kerry – I have Quicken back-up files but no longer have Quicken software. How do I transfer those back-ups to QB, please?

I hope you can help!

Kind regards

A:

It's been a while since I have worked directly with Quicken files. However, one of my big problems with that program was the fact that its backup function pretty much consisted of just making regular size copies of the multiple data files that are used by the program instead of a compressed file that could be stored and transferred much more efficiently, as has always been the case for QuickBooks.

This means that your Quicken backup files should be just as accessible to the QuickBooks conversion utility as the normal files would be. As long as you are working with a version of the QB program that is as current as the Quicken program, going into File - Import - Convert From Quicken should work for you. For example, if the Quicken data had been created using the Quicken 2005 program, you should be able to convert that data into QB by using the QB 2005, 2006, 2007, 2008 or 2009 program.

I hope this helps. Good luck.

Kerry Kerstetter

Follow-Up:

Dear Kerry - Thank you very much for getting back to me. It was a bit of a leap of faith that I got in touch with you (details from your website!) and I didn't really expect a response. I'm really pleased and grateful that you took the time and trouble to think about my problem and give me the benefit of your experience.

In the meantime, I found my Quicken software and just reloaded it. However, the day is probably not too far away when we'll move to QB - and your advice will be very useful then.

Thanks again and best wishes from Scotland.

Saturday, January 24, 2009

Compressing QB Files


Q:



Subject:  QB COMPRESS FILE


Hi Tax Guru – thanks for the info.


But……my regular file is 21 MB – when I create a portable file 16 MB and even an accountants copy only goes down to 16 MB.


And believe me – my company is pretty small – neither my accountant nor my bookkeeper have any suggestions.


Any other ideas – maybe something is set up incorrectly?


The last time I created a portable it went through e-mail at 16 MB – it’s not going through any more.


Thanks



A:



That is very strange.  I have always seen the QBM and QBX files come out at about a fifth the size of the QBW files.

What version of the QB program are you using?  Make sure it has been updated to the most current maintenance release.  If your program version is over three years old, you may also want to consider upgrading to a newer one.

I have seen clients squeeze even QBX files down to a little smaller size by zipping them, so you may want to give that a try.  The zip program should be able to shrink the file down even more.

Good luck.  I hope this helps a little.

Kerry Kerstetter



Follow-Up:



Hmm - I'll run and see if I can update my version - but it's 2007 premier.


 

Using Older QB Programs


Q:



Subject:  Quickbooks


Kerry,


My bookkeeper at the C21 was talking to QB support the other day.  They said the the 2006 version would quit working completely in the near future and recommended upgrading to the 2009 version.  Do you have any knowledge of this?  Do you recommend the 2009 version? 


Thanks a bunch,



A:



Your bookkeeper misunderstood the situation.  The QB programs will work forever.  I have several clients still using the 2001 and 2002 versions just fine.
Intuit doesn't like the fact that people are holding on to their QB programs for several years and not buying their new versions as often as they would like. In order to motivate more upgrades, a few years ago, Intuit started a sunset program, where they announced that they will only provide technical support for the most recent three versions.  That means, as of the middle of April this year, they will only answer technical questions about the 2007, 2008 and 2009 programs.  The earlier programs will continue to work just as they did before.

I don't do any payroll work, but I do understand that Intuit doesn't allow its built-in payroll for earlier versions of the QB program to be updated after a certain number of years; so that may be a motivator to upgrade to a newer version of the program if you are using QB for payroll.  If you are just doing bookkeeping, your 2006 will continue to work for several more years.

I currently have about a dozen versions of QB installed on my computers in order to maintain compatibility with client data files.  I have heard that some bookkeepers don't like the hassles of maintaining so many versions simultaneously, so they require their clients to upgrade to whatever version the bookkeepers are using.
I do have some clients who upgrade every year on their own, which is fine, but not required.  Whether you want to move to a newer version is up to you.  You won't lose any data in the transition to a newer version of the program; but you can't later roll it back to be usable in an older version of the program.
I hope this helps explain this issue for you.

Kerry


 

Quicken Reports


Q:



Subject: Quicken


Good afternoon Mr. Kerstetter.


I am a QB Pro Advisor but am not that familiar with Quicken.  I have a client that just began using Quicken, but when I was talking to her, she could not find the Reports tool bar,  I am truly embarrassed to ask, which way do you print the p&l and the balance sheet from Quicken?


A:



I recall that printing reports in Quicken was always very intuitive, much like in QuickBooks.

I don't actually use Quicken any more, but I do have the 2003 program installed on one of my old computers.  I checked and see that there is an item called "Reports" on the top menu line.  That drops down to different categories of reports.  The P&L is under the "Cash Flow" section and is actually called "Income/Expense."

I hope this helps.  You may want to explain to your clients the benefits of using QuickBooks instead of Quicken; especially the ability to more easily exchange data files with you.

Good luck.

Kerry Kerstetter