tag:blogger.com,1999:blog-55826832314265987112024-03-12T22:23:03.063-04:00TaxGuru's QuickBooks TipsThe key to good tax and financial planning is good record keeping. Nothing is easier and more accurate than QuickBooks. Kerry Kerstetter shares tips on how to best utilize QuickBooks.Kerry M. Kerstetter, MBA~CPA~ATP~ATAhttp://www.blogger.com/profile/12159545318811794036noreply@blogger.comBlogger72125tag:blogger.com,1999:blog-5582683231426598711.post-54471221106196379572015-07-27T19:11:00.001-04:002015-07-27T19:13:53.470-04:00Confusion over upgrading QB<p><strong>From a Client</strong>:</p> <blockquote> <p>Subject: Using QB on Mac</p> <p>Hi Kerry,</p> <p>I’m planning to make a QB upgrade and I’m considering moving to QB for Mac version. Do you work with Mac version of files as well? If not, do you have any clients which have QB for Mac and how do you work with them?</p> <p>I can still stay on Windows version (i.e. running QB on Windows virtual machine on Mac), if moving to Mac is going to complicate work for you. Please let me know what you think</p> <p>Thanks</p> </blockquote> <p><strong>My Reply</strong>:</p> <blockquote> <p>I'm glad you asked about this because I do have some experience, opinions and advice on it.</p> <p>We do have one corporate client in the San Francisco Bay Area who has always used nothing but Macs, including for her QuickBooks.  That was one of the reasons I bought a Mac Mini a few years ago, to be able to work on her QB data without needing to convert it. </p> <p>I was extremely disappointed in the features of the Mac version of QB. Many things that I have long taken for granted in the Window version do not exist in the Mac version.  The most critical omission is the ability of clients to send me a special Accountant's Review copy of the data and my ability to send my changes back to be imported into the client's master file.</p> <p>What I discovered was, rather than just having the Mac version of QB copy all of the features of the Windows version, Intuit developed it from the ground up, as they proudly boast.  As a computer software pro, you may better understand the logic behind that decision than I can. For my sake, I think it was a stupid decision and I avoid using the Mac version as often as possible.</p> <p>For a few years, the client would send her Mac QB data file to me and I would have my Mac Mini run the Mac QB program to convert the data file to be compatible with the Windows program.  This takes the mini several hours to actually do. <br /> <br />The Mac version of QB does have a feature to allow its data file to be converted to Windows compatible. This is what the client did this past year, saving me a lot of conversion time.  However, I am still unable to send her a change file to import; so I sent her an Audit Report and complete General Ledger and she has to manually make the adjusting entries in her file in order to keep her data in sync with what I used on the tax returns.</p> <p>Since we have plenty of Windows machines, I haven't ever tried running Windows on my Mac Mini; so I don't know how well it can handle the Windows version of QB.  If you are going to switch everything over to Mac, I would advise trying to run the Windows version of QB on your system, so that we can work more efficiently together with the data files.</p> <p>If you do have big problems doing that, you can switch to the Mac version and then use it to convert your data file to Windows before sending it to me.</p> <p>You didn't ask about using the online version of QB, which Intuit is pushing hard in order to generate much more revenue than by selling stand alone programs.  However, if you are considering that, I would strongly advise against it.  I have a few clients using QB Online and it's even worse than the Mac version.</p> <p>I hope this info helps.  Let me know if you have any other questions or issues to consider.</p> <p>Kerry </p> </blockquote> <p> <br /><strong>Follow-Up</strong>:</p> <blockquote> <p>Hi Kerry, Thanks for this excellent and detailed explanation! It helps a lot and makes my decision simple - I'm going to upgrade my QB Windows version, and will stick to running it in Virtual Machine on Mac, as I did for the past few years already. It works just fine this way. <br /> <br />BTW, the reason I'm even considering the upgrade is the Intuit's decision to stop supporting online banking access in version 2012 (the one I use) - which seems to me very offensive. We're talking here about forcing users with just 3 years old version of the product to force them into an upgrade! <br /> <br />Thanks </p> </blockquote> <p> <br /><strong>My Response</strong>:</p> <blockquote> <p>The basic bookkeeping functions in QB will work essentially forever. I just worked on a client's books yesterday who is still using the 2007 version. <br /> <br />However, you are correct that Intuit needed a way to motivate users to buy newer versions of the software, so they started a Sunset policy several years ago, under which they cease official support for any version of their program that is more than three years old. As part of this support cut-off, most optional services will also no longer function.  It happens most often with Payroll, where clients have had to upgrade to a newer version in order to continue using the QB Payroll utility.  Yours is the first case I have heard of where online banking functions have been cut off.  I don't use any of the optional QB services myself, so it's good to get this kind of info from others. <br /> <br />As I mentioned in my earlier email, Intuit hasn't been satisfied with the level of sales generated by the three year Sunset policy.  A person can buy a desktop version of the program and use it on multiple computers, with multiple company files, for three years before he bumps up against the problem you are having.  Their "solution" is the classic SAAS route with their very inferior online program, where they charge a monthly fee per company file. <br /> <br />It could be worse.  Luckily, they haven't shortened their Sunset period to one year from the current three, as some other software companies have done to force users to upgrade more frequently. <br /> <br />Good luck. Let me know if you have any problems or questions. <br /> <br />Kerry <br /></p> </blockquote> <a href="http://www.dpbolvw.net/click-7122228-11956820" target="_blank"><img border="0" alt="QuickBooks Premier 2015 Software - Enjoy $120 off! Save Time & Get Organized!" src="http://www.ftjcfx.com/image-7122228-11956820" width="468" height="60" /></a> Kerry M. Kerstetter, MBA~CPA~ATP~ATAhttp://www.blogger.com/profile/12159545318811794036noreply@blogger.comtag:blogger.com,1999:blog-5582683231426598711.post-34370800963605004712014-09-25T18:55:00.001-04:002014-09-25T18:55:34.903-04:00New Features in QB 2015 ProgramsIntuit recently posted <a href="http://youtu.be/x_oTNVJdteU" target="_blank">this 18 minute video</a>, showing the new features in the 2015 QB desktop programs, which they recently released to us ProAdvisors.<br />
<br />
<iframe allowfullscreen="" frameborder="0" height="315" src="//www.youtube.com/embed/x_oTNVJdteU?rel=0" width="560"></iframe>
Kerry M. Kerstetter, MBA~CPA~ATP~ATAhttp://www.blogger.com/profile/12159545318811794036noreply@blogger.comtag:blogger.com,1999:blog-5582683231426598711.post-66504780306985836182013-11-03T13:03:00.000-05:002013-11-03T13:03:12.110-05:00QB 2014 VideosFor those considering upgrading to the new QB 2014 program, or those who just want to see what new features are available in it, Intuit has posted several videos on their <a href="http://www.youtube.com/user/IntuitAcademy/videos" target="_blank">IntuitAcademy YouTube channel</a>.<br />
<br />
<blockquote class="tr_bq">
<b><a href="http://youtu.be/vxLv4Jh-daw" target="_blank">QuickBooks Enterprise Solutions 2014 Enhancements</a></b><br />
<br />
<a href="http://youtu.be/Suswr7z7WDY" target="_blank"><b>QuickBooks Pro, Premier and Enterprise Solutions 2014 - Customization Options</b></a> <br />
<br />
<a href="http://youtu.be/oVauefWGZvE" target="_blank"><b>QuickBooks Pro, Premier and Enterprise Solutions 2014 Transactional Improvements</b></a> <br />
<br />
<a href="http://youtu.be/ZJI_nflB5w8" target="_blank"><b>QuickBooks Pro and Premier 2014 - Job Cost Improvements</b></a>
<br />
<br />
<a href="http://youtu.be/0adWMoDxSME" target="_blank"><b>Revamped Online Banking in QuickBooks Pro, Premier and Enterprise Solutions 2014</b></a>
<br />
<br />
<a href="http://youtu.be/T-12bu7GRaQ" target="_blank"><b>QuickBooks Accountant 2014 PLUS - Client Collaborator</b></a>
<br />
<br />
<a href="http://youtu.be/R14mVD_tRVw" target="_blank"><b>QuickBooks Enterprise Solutions 2014 - Job Costing Improvements</b></a>
<br />
<br />
<a href="http://youtu.be/Kpi3-_NpmAM" target="_blank"><b>QuickBooks Accountant - Client Collaborator End-to-End</b></a> </blockquote>
<br />
<br />
<a href="http://www.infiniteskills.com/training/learning-intuit-quickbooks-2013.html?affid=3988">Beginners QuickBooks 2013 Training Videos </a><br />
<br />
<br />
<img src="http://www.infiniteskills.com/images/products-large/01761.png" /><br />
Kerry M. Kerstetter, MBA~CPA~ATP~ATAhttp://www.blogger.com/profile/12159545318811794036noreply@blogger.comtag:blogger.com,1999:blog-5582683231426598711.post-2927594202929821542013-10-31T16:31:00.001-04:002013-10-31T16:31:38.718-04:00New features in QB 2014<p><font size="2">This article from <a href="http://quickbooksusers.com/" target="_blank">QuickBooksUsers.com</a> has some links to reviews of some of the new features in the QB 2014 programs.</font></p>
<blockquote>
<p><a href="http://blog.quickbooksusers.com/quickbooks/surveying-the-reviews-of-quickbooks-2014/" target="_blank"><strong>Surveying the Reviews of QuickBooks 2014</strong></a> </p></blockquote>
<p><font size="2"></font> </p>Kerry M. Kerstetter, MBA~CPA~ATP~ATAhttp://www.blogger.com/profile/12159545318811794036noreply@blogger.comtag:blogger.com,1999:blog-5582683231426598711.post-20498523033050463302013-05-28T15:21:00.004-04:002013-05-28T15:21:29.155-04:00Installing QB on Multiple Computers <b>Q:</b><br />
<blockquote>
Subject: Quickbook 2012</blockquote>
<blockquote>
<div>
Hello there,</div>
<div>
<br /></div>
<div>
I found your blog and was reading this page:</div>
<div>
<a href="http://taxguruqbtips.blogspot.com/search/label/Multiple" target="_blank">http://taxguruqbtips.blogspot.com/search/label/Multiple</a><a href="http://taxguruqbtips.blogspot.com/search/label/Multiple"></a></div>
<div>
<br /></div>
<div>
Specifically: </div>
“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.”
<br />
<div>
<br /></div>
<div>
and am wondering if this is still the case with QB 2012?</div>
<div>
<br /></div>
<div>
Was just about to install it over my existing QB 2009 install and wanted to be sure I could install it on my 4 workstations without a problem.</div>
<div>
<br /></div>
<div>
Thanks for any guidance,</div>
</blockquote>
<br />
<b>A:</b><br />
<blockquote>
I haven't had any problems installing any QB programs on several computers, including all the way up the most current 2013 programs. <br />
<br />
I just got a new computer a few months ago and have installed all of the QB programs from 2007 up to the 2013 on it with no problems, even though these programs are also installed on four other computers with the same licenses. When I registered each one, I used the same phone number and zip-code for all of them, with no problems. <br />
<br />
I hope this eases any concerns you may have. <br />
<br />
Kerry Kerstetter </blockquote>
<br />
<a href="http://www.tkqlhce.com/click-7122228-11302658" target="_blank"><img alt="" border="0" class="odjixquvlvzrklzkbfhy" height="60" src="http://www.awltovhc.com/image-7122228-11302658" width="468" /></a>
<br />
<br />Kerry M. Kerstetter, MBA~CPA~ATP~ATAhttp://www.blogger.com/profile/12159545318811794036noreply@blogger.comtag:blogger.com,1999:blog-5582683231426598711.post-87579014425363438822013-05-28T15:03:00.001-04:002013-05-28T15:03:59.804-04:00Payments between accounts<p><font size="2"><strong>Q:</strong></font></p>
<blockquote>
<p><font size="2"><font size="3">Hi Kerry,</font></p>
<div><br /></div>
<div>I just had a question about how to handle transfers between separate bank accounts for separate QuickBooks files (same client).</div>
<div><br /></div>
<div>I was sure if I should make the deposit into an Equity account or Other Income.</div>
<div><br /></div>
<div>The money from the first account ("A") is the Business account. The client writes checks from A account to the Family Trust Account ("B").</div>
<div><br /></div>
<div>The deposit into B account is not income because it was already income in the A account. </div>
<div><br /></div>
<div>Just no sure how to categorize the deposit from A to B...</div>
<div><br /></div>
<div>Please let me know if you can help.</div>
<div><br />Thanks!</div></blockquote>
<div><br /></div></font>
<p><font size="2"></font> </p>
<p><font size="2"><strong>A:</strong></font></p>
<blockquote>
<p>How to properly handle these kinds of transfers in QB depends on the ownership of the accounts. Each QB company file should coincide to a tax return. <br /><br />If both bank accounts are owned by the same tax entity, they should both be in the same QB company file. You can then use the "Transfer Funds" function to move money between accounts. <br /><br />You mentioned the second account as being a family trust. What kind of trust is this; revocable (aka Living) or irrevocable? <br /><br />If it is a living trust, that is considered for tax purposes to be a disregarded entity (no separate tax return required) and the account should be in the same 1040 QB company file as all of the other personally owned accounts. <br /><br />If the trust is irrevocable and a 1041 is filed for it each year, it should have its own QB company file that will match up to the trust's 1041s. <br /><br />If the trust is a separate tax paying entity and has its own QB company file, it should have balance sheet accounts to handle payments between it and the trust's owners. If there are to be repayments back to the owners, a Liability account would be appropriate. For money that won't be repaid, an Equity account for the owner's investment in the trust would be appropriate. Entries into either of these accounts would have no effect on the trust's income. <br /><br />To mirror the payments to the trust, there should be Asset accounts set up in the 1040 company file; one for Loans To Trust and another for Investments in Trust. At any point in time, the balances in the 1040 accounts should match their corresponding accounts in the 1041 company file. <br /><br />Good luck. I hope this helps. As always, it would be best if the tax preparer for the 1040 and 1041 is involved in helping to set up and synchronize the QB company files with the tax returns. <br /><br /><br />Kerry Kerstetter </p></blockquote>
<p><font size="2"></font> </p>
<p><font size="2"><strong>Follow-Up:</strong></font></p>
<blockquote>
<p><font size="2"><font size="3">Great, thank you so much! I have been struggling with this and recommending for a year now to combine the accounts. I do not file their taxes, so I do not know if there is a separate return for each account. I will find out and take appropriate steps!</font></p>
<div><br /></div>
<div>Thanks again!</div></blockquote></font>
<p><font size="2"></font> </p><a href="http://www.jdoqocy.com/click-7122228-11302604" target="_blank"><img border="0" alt="" src="http://www.awltovhc.com/image-7122228-11302604" width="468" height="60" /></a>
<p><font size="2"></font> </p>Kerry M. Kerstetter, MBA~CPA~ATP~ATAhttp://www.blogger.com/profile/12159545318811794036noreply@blogger.comtag:blogger.com,1999:blog-5582683231426598711.post-29700833796245216722013-05-19T12:41:00.001-04:002013-05-19T12:41:28.772-04:00QuickBooks Video Training<p><span style="FONT-SIZE: small">I have always stressed how important good bookkeeping is for making financial decisions, as well as for preparing the most accurate tax returns. Several years ago, I made a video showing people how to best use the Quicken programs for bookkeeping and tax return preparation purposes. </span></p>
<p><span style="FONT-SIZE: small"> </span><span style="FONT-SIZE: small">I have long wanted to do a similar one for QuickBooks. While I have made some short instructional videos and guides for certain QB tasks, the program has far too many features for me to be able to cover everything it can do. Also, since I don't use a lot of the features in QB, such as invoicing, inventory and payroll, I don't feel as qualified to do as good a job on these specific topics as someone who does use them on a daily basis.</span> </p>
<p><span style="FONT-SIZE: small">I had been unable to recommend a good training video to clients and other readers who wanted to learn how to work with QB. Every time I saw an ad for a hands-on live class or seminar on QB, they were always using a two or three year old version of the program instead of the most current one.</span> </p>
<p><span style="FONT-SIZE: small">That's why I was glad to learn about a <a href="http://www.infiniteskills.com/training/learning-intuit-quickbooks-2013.html?affid=3988" target="_blank">new instructional video series</a> focusing on the QuickBooks 2013 program from a company that has a ton of excellent instructional videos. This one is broken up into 115 separate videos totaling nine and a half hours. making it easy to just focus on those aspects of QB that you need to use but are unfamiliar with. At only $99.95, it's a lot less expensive than most live seminars and much less costly than my time would be to explain these topics one on one.</span> </p>
<p><span style="FONT-SIZE: small">It's available <a href="http://www.infiniteskills.com/training/learning-intuit-quickbooks-2013.html?affid=3988" target="_blank">on DVD or as a download</a>. They also have 17 free videos from the course that you <a href="http://www.infiniteskills.com/training/learning-intuit-quickbooks-2013.html?affid=3988" target="_blank">can check out</a> to see if it will work for you.</span></p>
<p><span style="FONT-SIZE: small"></span> <a href="http://www.infiniteskills.com/training/learning-intuit-quickbooks-2013.html?affid=3988">Beginners QuickBooks 2013 Training Videos <img alt="" src="http://www.infiniteskills.com/images/products-large/01761.png" /></a> </p>Kerry M. Kerstetter, MBA~CPA~ATP~ATAhttp://www.blogger.com/profile/12159545318811794036noreply@blogger.comtag:blogger.com,1999:blog-5582683231426598711.post-24097626714674810732013-01-13T15:35:00.001-05:002013-01-13T15:35:18.302-05:00QB Videos<p>Intuit has posted a series of videos on YouTube showing the new features in the 2013 QB programs.</p>
<blockquote>
<p><a href="http://youtu.be/h5Oskd4GKak" target="_blank"><strong>Part 1</strong></a></p>
<p><a href="http://youtu.be/xQ3DLk-YU18" target="_blank"><strong>Part 2</strong></a></p>
<p><a href="http://youtu.be/BVf884Rtz6I" target="_blank"><strong>Part 3</strong></a><strong> </strong></p></blockquote>
<p> </p>Kerry M. Kerstetter, MBA~CPA~ATP~ATAhttp://www.blogger.com/profile/12159545318811794036noreply@blogger.comtag:blogger.com,1999:blog-5582683231426598711.post-36497872372675298982012-03-22T15:43:00.001-04:002012-03-22T15:43:34.950-04:00Keeping QB Up To Date<p><strong><br />From a client</strong>:</p>
<blockquote><pre wrap="">I just got an update box that popped up that reads:
"QuickBooks has recently downloaded the R14 product update. Would you like
QuickBooks to install this update now?" This is the software you sent to me
on a disc last year. Should I go ahead and install this update?
</pre></blockquote>
<p> </p>
<p><strong>My reply</strong>:</p>
<blockquote>
<p>Yes, you should install that new update. <br /><br />QB releases an update to the programs that are still being supported three or four times a year to fix bugs that they find. The QB 2012 program is already up to R6, which is five updates since the original program was released last Fall. <br /><br />A good site to check whether you have the latest update for your version of QB is at: <br /><a class="moz-txt-link-freetext" href="http://support.quickbooks.intuit.com/support/productupdates.aspx">http://support.quickbooks.intuit.com/support/productupdates.aspx</a> <br /><br />You will see that R14 is the newest update for the 2009 program. <br /><br />You can always find the version you are running by holding the Control and the 1 keys down at the same time while you are in the program. <br /><br />Good luck. I hope this helps. <br /><br />Kerry </p></blockquote>
<p> </p>
<p><a href="http://quickbooks.intuit.com/product/accounting-software/small-business-accounting-software.jsp?priorityCode=3969702399&!!!trackcode!!!&kbid=3559&img=QB12_300x250_Pro.jpg&sub="><img border="0" src="http://www.opmpros.com/host/quickbooks/images/banners//QB12_300x250_Pro.jpg" /></a> </p>
<p> </p>Kerry M. Kerstetter, MBA~CPA~ATP~ATAhttp://www.blogger.com/profile/12159545318811794036noreply@blogger.comtag:blogger.com,1999:blog-5582683231426598711.post-60625725229732289912011-12-23T17:34:00.001-05:002011-12-23T17:34:14.243-05:00Mac Shortcuts<p>I recently purchased my very first Apple computer, a Mac mini, so I could work with the QuickBooks for Mac, as well as some other Mac only software. I'm still learning my way around the Mac system, but I have had a chance to do a little work with the Mac QB program.</p>
<p>First off, I have to say that the Mac program is a crippled version of the Windows software and should only be used if you only have access to Mac computers and can't run Windows programs on them, such as with the <a href="http://en.wikipedia.org/wiki/Parallels_Desktop_for_Mac" target="_blank">Parallels program</a> that allows Macs to emulate Windows. </p>
<p>The biggest limitation of the Mac QB program is its lack of the special Accountant Review copies of data files that allow us to work with client data files while the clients continue to work with them. This is an essential feature of QB that must be added to the Mac version before I can ever feel good about recommending its use.</p>
<p>However, for those who are using the Mac QB program, I recently came across <a href="http://www.qblittlesquare.com/2011/11/keyboard-shortcuts/" target="_blank">this handy listing of the keyboard shortcuts</a> that work with it. I have printed out a copy and will refer to it when I work with that program. </p>
<p> </p>
<p><a href="http://quickbooks.intuit.com/product/accounting-software/small-business-accounting-software.jsp?priorityCode=3969702399&!!!trackcode!!!&kbid=3559&img=QB12_300x250_Pro.jpg&sub=2651"><img border="0" src="http://www.opmpros.com/host/quickbooks/images/banners//QB12_300x250_Pro.jpg" /></a></p>
<p> </p>Kerry M. Kerstetter, MBA~CPA~ATP~ATAhttp://www.blogger.com/profile/12159545318811794036noreply@blogger.comtag:blogger.com,1999:blog-5582683231426598711.post-90789998419132583402011-12-13T18:31:00.001-05:002011-12-13T18:31:41.142-05:00Sending QBX Files<p>With the newer versions of QB, it has become somewhat more confusing for clients to send me the special QBX Accountant's Review copies of their data files. I sent this quick explanation to one client who sent me a QBX file with which I was unable to even start the conversion to QBA process because the password he gave me wouldn't work.</p>
<blockquote>
<p>That password didn't work. I tried it several times and no go. <br /><br />I think the problem is how you are making the QBX file. A few years back, Intuit added a new twist to sending QBX files. There are now two main ways to do it. <br /><br />1. There is one way that sends the file to me through Intuit's online system (File - Accountant's Copy - Client Activities - Send to Accountant) where you do need to enter a special password. However, to work properly, you need to actually have the file sent via Intuit's server, not as an email attachment. <br /><br />2. The other way, in which you can send the file to me directly as an email attachment doesn't require the special password. To do this, select File - Accountant's Copy - Client Activities - <strong>Save File</strong> - Accountant's Copy. <br /><br />It seems that the best thing here would be for you to start over by canceling out the previous QBX copy (File - Accountant's Copy - Client Activities - Remove Restrictions) and then make a new QBX copy via the second option which you can then attach to an email. <br /><br />Good luck. I hope this helps. <br /><br />Kerry </p></blockquote>
<p> </p>Kerry M. Kerstetter, MBA~CPA~ATP~ATAhttp://www.blogger.com/profile/12159545318811794036noreply@blogger.comtag:blogger.com,1999:blog-5582683231426598711.post-81397170687322152892011-07-23T14:43:00.001-04:002011-07-23T14:46:38.474-04:00Keeping Your QuickBooks Program Up To Date<p>Intuit is constantly releasing updates to its programs to fix problems that arise among the real world users. These are free and are different than an <strong>upgrade</strong>, which is the new year's program (2010, 2011, 2012, etc.), which you have to pay for.</p>
<p>To tell how up to date your program is, hit the <strong>Control </strong>and <strong>1 </strong>keys while you are in the program. A Product Information window will pop up, such as the example below from my 2011 program after I ran the most recent update, Release 8.</p>
<p><a href="https://picasaweb.google.com/lh/photo/OGaLQBjNpwOu0bEz_cqgoQ?feat=embedwebsite"><img src="https://lh4.googleusercontent.com/-6EwEqCQTiE0/TisPU85NbMI/AAAAAAAABVg/qdkHTNMWekI/s800/QB2011Ctrl1%25252B7-23-2011.png" width="335" height="115" /></a> </p>
<p> </p>
<p>There are two main ways to upgrade your program. </p>
<p>First is to run the <strong>Update QuickBooks</strong> function from the <strong>Help</strong> menu in the program, which is the method I had been using until a few years ago.</p>
<p><a href="https://picasaweb.google.com/lh/photo/gYprePIeH3wUgVZb7nt2kQ?feat=embedwebsite"><img src="https://lh3.googleusercontent.com/-TEaK04CwEzY/TisQ8eUyN1I/AAAAAAAABV0/zA2IDvlV4yg/s800/QBHelpMenu-7-23-2011.png" width="331" height="320" /></a> </p>
<p> </p>
<p>My current choice for updating the program is the manual option, where I download the newest release and run it on each of the computers that has that version of the program. This means I only have to download the files, which are very large (388 mb for R8), one time instead of separately for each computer. With our very slow and limited internet service, that is very useful.</p>
<p>The other big benefit is the fact that the updates are normally available about two weeks earlier on the <a href="http://support.quickbooks.intuit.com/support/productupdates.aspx">manual update page</a> than they are in the update function from inside the program.</p>
<p>You can find updates for almost all versions of QB on the update page:</p>
<blockquote>
<p><a href="http://support.quickbooks.intuit.com/support/productupdates.aspx"><strong>http://support.quickbooks.intuit.com/support/productupdates.aspx</strong></a></p></blockquote>
<p> </p>
<table style="WIDTH: auto">
<tbody>
<tr>
<td><a href="https://picasaweb.google.com/lh/photo/tyFzhbQMZ5LBRHuFr_Wnjw?feat=embedwebsite"><img src="https://lh3.googleusercontent.com/-O43Pr2Sew-A/TisUqiNVwGI/AAAAAAAABWI/SQTvC-RrQpM/s400/QBUpdateVersions7-23-2011.png" width="400" height="353" /></a></td></tr>
<tr>
<td style="TEXT-ALIGN: right; FONT-FAMILY: arial,sans-serif; FONT-SIZE: 11px">From <a href="https://picasaweb.google.com/KMKCPA/TaxGuruSQuickBooksTips?authuser=0&feat=embedwebsite">TaxGuru's QuickBooks Tips</a></td></tr></tbody></table>
<p>Intuit usually puts out a news release when they issue new updates, but I also like to check the update page every so often to see if the dozen or more versions of QB I am running are all up to date. Since they only have back to the 2004 program, I am pretty much SOL for verifying the status of my 1999–2003 programs; but those programs are technically obsolete and shouldn't even be used nowadays.</p>
<p> </p>Kerry M. Kerstetter, MBA~CPA~ATP~ATAhttp://www.blogger.com/profile/12159545318811794036noreply@blogger.comtag:blogger.com,1999:blog-5582683231426598711.post-73823823420816434242010-12-14T22:14:00.001-05:002010-12-14T22:14:45.004-05:00Working with multiple QB files at same time...<p>One of the annoying limitations to QB has long been the inability to open more than one company file at a time. With a lot of people having multiple company files, such as one for the personal 1040 and another for the corporation 1120, being able to work on both files simultaneously to ensure consistent posting of transactions between them, is a huge time saver. I know a number of clients who actually have one entity on one version of QB (2003 for example) while their personal info is on a different version (2009 for example) because it has long been possible to have two versions of the program open at the same time.</p>
<p>Now, with the 2011 version of QB, they have finally added the capability to open two different company files in the 2011 program at the same time. You actually click on the program icon to start the program again to trigger the following pop-up window.</p>
<table style="WIDTH: auto">
<tbody>
<tr>
<td><a href="http://picasaweb.google.com/lh/photo/MnQVO_2NJ6WLy7My4McBMXhuJ_VOMQZgd5F6hyCuzlg?feat=embedwebsite"><img src="http://lh4.ggpht.com/_hmYA_PAFa6o/TQgvtWvG1QI/AAAAAAAAArE/Z56_MmuqOcM/s800/QB2011Open2ndCoFileWinCap.png" width="415" height="212" /></a></td></tr>
<tr>
<td style="TEXT-ALIGN: right; FONT-FAMILY: arial,sans-serif; FONT-SIZE: 11px">From <a href="http://picasaweb.google.com/KMKCPA/TaxGuruSQuickBooksTips?authkey=Gv1sRgCK6A_c7c6rE8&feat=embedwebsite">TaxGuru's QuickBooks Tips</a></td></tr></tbody></table>
<p>The second company file has the following in its window heading.</p>
<table style="WIDTH: auto">
<tbody>
<tr>
<td><a href="http://picasaweb.google.com/lh/photo/r7ivEck9I-L2cqTao6_20HhuJ_VOMQZgd5F6hyCuzlg?feat=embedwebsite"><img src="http://lh6.ggpht.com/_hmYA_PAFa6o/TQgvtCe57HI/AAAAAAAAArA/GJjfl5VG1F8/s800/QB20112ndCoWindowHead.png" width="440" height="75" /></a></td></tr>
<tr>
<td style="TEXT-ALIGN: right; FONT-FAMILY: arial,sans-serif; FONT-SIZE: 11px">From <a href="http://picasaweb.google.com/KMKCPA/TaxGuruSQuickBooksTips?authkey=Gv1sRgCK6A_c7c6rE8&feat=embedwebsite">TaxGuru's QuickBooks Tips</a></td></tr></tbody></table>
<p>I had heard about this new feature several months ago, but didn't have a need to use it intensely until last night, as I was working on a corp tax return and needed to match up the payments between the personal and corp files. Having each QB file open in a separate monitor (I have four active monitors on my main computer) made the process so much quicker than the old way of having to go back and forth opening and closing each company file several times. </p>
<p>Every year, the Intuit developers add a few new features to the program. This may be the one many people have been waiting for to justify upgrading from an older version of the program.</p>
<p> </p><a href="http://quickbooks.intuit.com/product/accounting-software/upgrade-quickbooks/index.jsp?priorityCode=3969702399&kbid=3559&img=quickbooks/Upgrade_to_qb_120x90_06_wh.jpg&sub=2368"><img border="0" src="http://qbgdm.intuit.com/affiliates/quickbooks/Upgrade_to_qb_120x90_06_wh.jpg" /></a>
<p> </p>
<p> </p>Kerry M. Kerstetter, MBA~CPA~ATP~ATAhttp://www.blogger.com/profile/12159545318811794036noreply@blogger.comtag:blogger.com,1999:blog-5582683231426598711.post-83614607779108858022010-09-29T18:07:00.001-04:002010-09-29T18:07:51.159-04:00Loan Payments<p> </p>
<p><strong>Q:</strong></p>
<blockquote>
<p>Subject: Quicken Tips.</p>
<p>I need some help which I am sure is quite simple but I cannot figure out what I am doing wrong! I have Quicken Rental Property Manager and in my check register I make a payment to the bank for a mortgage on the property I am renting. This payment is split category with principal having the category of the loan account [loan] and interest categorized as “Mortgage Interest Expense” The problem is only the principal shows up in my loan account. </p>
<p>Do I need to create two subcatagories under my loan account [loan] such as “principle” and “ mortgage interest expense” </p>
<p>I am lost.</p>
<p>Any help is appreciated. </p></blockquote>
<p> </p>
<p><strong>A:</strong></p>
<blockquote>
<p>It actually sounds as if you already have it set up properly. The principal portion of the loan reduces the liability balance of the loan and is the only portion of the payment that should be showing up in the loan's Quicken account register. </p>
<p>The interest portion of the payments is a period expense and should show up when you run an Income Statement (aka Profit & Loss) for a particular time period. </p>
<p>Your own professional tax advisor should be able to set up your Quicken so that it is easier to understand and coincides more closely with your tax returns. </p>
<p>Good luck. </p></blockquote>
<p> </p>
<p><strong>Follow-Up:</strong></p>
<blockquote>
<p>Thanks for the quick replay Kerry and help. With your input and my looking at it again I think I am comfortable with what I have done. </p>
<p>Thank you very much! </p></blockquote>
<p> </p>
<p> </p>Kerry M. Kerstetter, MBA~CPA~ATP~ATAhttp://www.blogger.com/profile/12159545318811794036noreply@blogger.comtag:blogger.com,1999:blog-5582683231426598711.post-85484028258157525502010-06-19T15:42:00.001-04:002010-06-19T15:50:01.795-04:00Some Client QB Tips<p>It is still the case that the bulk of my time preparing tax returns is involved in cleaning up QB data. Once the QB data is in good shape, the actual tax return prep is a snap. In order to reduce the number of adjustments needed to the QB files, I do send back comments to the clients so we can avoid repeating the same mistakes in the future. In order to avoid having to repeat myself with other clients and help other QB users to have more usable data, I want to share some of my comments that are applicable to all QB users.</p>
<blockquote>
<p>1099-MISC is only required to be submitted to IRS if you pay someone more than $600 during a calendar year for business services that you are claiming a deduction for. </p>
<p> </p>
<p>Please try not to use generic non-descriptive accounts, such as "Other" and "Misc." Add new accounts if no existing ones suffice. This is especially important with income because IRS always starts off with the presumption that every penny deposited into your bank accounts is taxable income unless you show otherwise. </p>
<p> </p>
<p>I see an expense account called "Mission Trip" with a lot of fuel and motel costs. Was this for a church sponsored trip? If so, we can deduct this as charitable deduction. [Follow-up: This was for a church sponsored trip, so I edited this account to make it a sub-account of Charitable Donations.]</p>
<p> </p>
<p>Try not to lump too many different kinds of things into "Outside Services." Large numbers attract IRS attention; so use more detailed accounts, such as Repairs & Lawn Care, which is where I moved a lot of the items for 2009. </p>
<p> </p>
<p>Only make inactive balance sheet accounts that have zero balances. Use a general journal entry to zero out any balance sheet account that you want to set as inactive. </p></blockquote>
<p> </p>Kerry M. Kerstetter, MBA~CPA~ATP~ATAhttp://www.blogger.com/profile/12159545318811794036noreply@blogger.comtag:blogger.com,1999:blog-5582683231426598711.post-91156139228389513042010-05-24T21:48:00.001-04:002010-05-24T21:48:53.598-04:00Bank Reconciliation Problem<p><br /><strong>Q:</strong></p>
<blockquote>
<p>Subject: Quicken Reconcile Question</p>
<p>Hi! Wondering if you can help? </p>
<p>Use QuickBooks for business, Quicken for Personal for many years.</p>
<p>Just entered the WRONG closing bal in a Quicken reconcile, and for the life of me, can't figure out how to fix it. Didn't like their 'fix' of adjusting the balance at end of month.</p>
<p>Have the latest Quicken 2010. </p>
<p>Any help appreciated. </p>
<p>Thanks in advance. </p></blockquote>
<p> </p>
<p><strong>A:</strong></p>
<blockquote>
<p>As I've explained several times, I haven't been using Quicken for several years, as I realized that QuickBooks is a far superior bookkeeping program for everyone's purpose, both personal and business. In fact, you would probably find things a lot easier to deal with if you only used QB for both your personal and business accounting instead of trying to cope with two different programs. <br /><br />However, I do recall that the reconciliation function in Quicken was set up the same as in QB; so there are a number of ways to fix the situation you have. <br /><br />I'm assuming you finalized the previous reconcile, with an adjusting entry put into a discrepancy account. If you didn't finalize the reconcile, you can just cancel it and start again with the correct bank balance. <br /><br />In QB, when you pop up the reconcile window, there is a button that allows you to Undo Last Reconciliation. If you have that, just undo the old one and do a new one with the correct balance. <br /><br />Another option would be to do a new reconciliation as of the same date as the previous one, using the correct bank balance. It should end up with an adjustment to the discrepancy account of the same amount in the opposite direction as your earlier adjusting entry. Those should zero each other out and bring everything into sync with your bank balance. <br /><br />Good luck. I hope this helps. <br /><br />Kerry Kerstetter </p></blockquote>
<p> </p>
<p><strong>Follow-Up:</strong></p>
<blockquote>
<p>Hi, Kerry! <br /><br />You are so kind ~ thanks so much! <br /><br />Didn't know I could 'cancel' the reconcile. <br /><br />Wish I would've read your note sooner, but I've been doing the personal on Quicken and businesses on QB Pro for many years now. <br /><br />What I ended up doing was reload the previous backup, so I just lost a month of bookkeeping. <br /><br />I don't what I can do to help you, but if you ever need a quick graphic (I was an award-winning designer for years), or a poodle skirt, please give me a holler! </p></blockquote>
<p> </p>
<p><strong>My Final Word:</strong></p>
<blockquote>
<p>You didn't specify why you are using Quicken for your personal data. If you are under the impression that you are stuck having to stay with Quicken, that isn't the case. QuickBooks has the capability to import Quicken data so you can convert without losing any of your previously entered data. <br /><br />You do need to be using a version of QB that is at least as current as the version of Quicken you have. If you are currently using Quicken 2010, that means you can only import it into QB 2010 or 2011. <br /><br />Good luck. <br /><br />Kerry Kerstetter </p></blockquote>
<p> </p>Kerry M. Kerstetter, MBA~CPA~ATP~ATAhttp://www.blogger.com/profile/12159545318811794036noreply@blogger.comtag:blogger.com,1999:blog-5582683231426598711.post-14166855710173640742010-05-24T21:30:00.001-04:002010-05-24T21:30:24.526-04:00Entering Classes<p><br /><strong>Q:</strong></p>
<blockquote>
<p>Subject: In Quickbooks, entering classes on the expense side</p>
<p>Saw your posting on the use of classes (via a Google search). We are new to Quickbooks, running a non-profit. We are attempting to use classes, and can easily see how to enter classes when entering income (deposits). However, we cannot figure out how to get to classes when we are entering expenses. We can't find anything that "gets" us to our list of classes on the expense side. Can you please help? </p>
<p>Thank you very much for your time. </p></blockquote>
<p> </p>
<p><strong>A:</strong></p>
<blockquote>
<p>There is a column with a drop-down list of classes in the windows for writing checks, entering bills, entering credit card charges and general journal entries. However, unless you have selected "Use class tracking" in the Accounting Preferences setup, that list doesn't show up. <br /><br />Which version of QB are you using? <br /><br />Kerry Kerstetter </p></blockquote>
<p> </p>
<p><strong>Follow-Up:</strong></p>
<blockquote>
<div>Kerry:</div>
<div> </div>
<div>Thank you for your help. We were able to find the drop down menu, turn on classes, and can now enter classes on the expense side. Appreciate your help. </div></blockquote>
<p> </p>
<p> </p>Kerry M. Kerstetter, MBA~CPA~ATP~ATAhttp://www.blogger.com/profile/12159545318811794036noreply@blogger.comtag:blogger.com,1999:blog-5582683231426598711.post-4191168214055532752010-05-24T21:16:00.002-04:002010-06-05T19:22:28.844-04:00QB or Quicken?<p><strong>Q:</strong><br />
<blockquote>Subject: Quicken or Quickbooks<br />
I'm a realtor in San Francisco, ran across your blog. So with all your experience, which should I buy? I have a mac also. Thanks for your help. </blockquote><br />
<strong>A:</strong><br />
<blockquote>I have a ton of info on QB and Quicken on my main website: <br />
<a class="moz-txt-link-freetext" href="http://taxguru.org/qb/quickbooks.htm" target="_blank">http://taxguru.org/qb/quickbooks.htm</a> <br />
<br />
You can see that I definitely advise everyone to use QB. However you need to coordinate whatever bookkeeping system you use with your professional tax advisor so you can keep everything in sync and make it easier to exchange data. <br />
<br />
Good luck. I hope this helps. <br />
<br />
Kerry Kerstetter </blockquote><br />
<iframe align="left" frameborder="0" marginheight="0" marginwidth="0" scrolling="no" src="http://rcm.amazon.com/e/cm?t=taxfreeexchacorp&o=1&p=8&l=bpl&asins=1595230637&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr" style="align: left; height: 245px; padding-right: 10px; padding-top: 5px; width: 131px;"></iframe>Kerry M. Kerstetter, MBA~CPA~ATP~ATAhttp://www.blogger.com/profile/12159545318811794036noreply@blogger.comtag:blogger.com,1999:blog-5582683231426598711.post-5647160013246192032010-05-24T21:07:00.001-04:002010-05-24T21:07:25.075-04:00Tracking Loans In QB<p><strong><br />Q:</strong></p>
<blockquote>
<p>Subject: Accounts Receivable</p>
<p>I have searched high and low in QBs on establishing Accounts Receivable with Amortized Loans. I have printed Amortization Schedules and could record via monthly splits but surely QBs has such an animal and can be “memorized”. Surely, Uncle Sam will want his take based on Interest Income. </p>
<p>Thanks </p></blockquote>
<p><br /><strong>A:</strong></p>
<blockquote>
<p>Actually, QB does not have a function that will automatically do the amortization between principal and interest for loans receivable. They do have that feature, called the Loan Manager, for loans payable. However, this is another of the many features in QB that I don't like or use.<br /><br />It is much easier to just split the deposit entry into two lines yourself; one for the principal portion and one for the interest portion. Use an estimated allocation if you are not positive what it is at the time of the payment and then go back later and correct it when you have coordinated your figures with the borrower's. <br /><br />For various reasons, please do not set up any loans you make as Accounts Receivable for the type of account in QB. That type of account make things very messy. I already have an Other Assets account set up for Loans Receivables, with sub-accounts for each loan. Set up a new sub-account as the need arises.</p>
<p>Good luck. I hope this helps.<br /><br />Kerry</p></blockquote>
<p> </p>Kerry M. Kerstetter, MBA~CPA~ATP~ATAhttp://www.blogger.com/profile/12159545318811794036noreply@blogger.comtag:blogger.com,1999:blog-5582683231426598711.post-42643702580865400742010-02-19T18:07:00.003-05:002010-02-19T18:31:09.807-05:00Remote HostingAs someone who has been very disappointed in the quality of Intuit's Online QuickBooks service, I have been researching the various methods of allowing clients to access their QB via a remotely hosted version of the QB <span style="font-weight: bold;">desktop</span> programs for the past several months.<br /><br />I recently saw this very interesting article on Intuit's plans to actually promote this method of working with clients' data files.<br /><br /><a style="font-weight: bold;" href="http://www.accountingweb.com/print/node/153152"><blockquote>Intuit introduces hosting program for QuickBooks</blockquote></a><br />I have already sent an email to Intuit asking them to send me info on signing up for this program. I will keep everyone posted on my progress with it.Kerry M. Kerstetter, MBA~CPA~ATP~ATAhttp://www.blogger.com/profile/12159545318811794036noreply@blogger.comtag:blogger.com,1999:blog-5582683231426598711.post-55545739247715813882009-11-15T19:55:00.001-05:002009-11-15T19:55:53.695-05:00New Features In QB<p>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</p><br /><p>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.</p><br /><p>I was reading the latest <a href="http://intuit.p.delivery.net/m/p/itu/prw/preview.asp?cid=14388305130&mid=1200644724&pid=449902" target="_blank">Intuit ProConnection Newsletter</a> and noticed that they have <a href="https://www.quickbase.com/up/betrs3sps/g/rk/ej/va/Compare%20Versions%20Chart%202010.pdf" target="_blank">a pdf chart</a> showing when many of the newest features since 2005 have been added to the program. It’s interesting for anyone considering upgrading.</p><br /><p>They also have <a href="https://www.quickbase.com/up/berzetiu5/g/rn/ej/va/Whats%20New%202010%20Brochure.pdf" target="_blank">this 7 page pdf</a> focusing on the changes specifically for QB 2010.</p><br /><p> </p>Kerry M. Kerstetter, MBA~CPA~ATP~ATAhttp://www.blogger.com/profile/12159545318811794036noreply@blogger.comtag:blogger.com,1999:blog-5582683231426598711.post-25608680003128751922009-11-15T17:30:00.001-05:002009-11-15T17:30:56.265-05:00Using QB For Rental Properties<p><br /><strong>Q:</strong></p><br /><blockquote style="MARGIN-RIGHT: 0px" dir="ltr"><br /><p>Subject: QUICKBOOKS V QUICKEN</p><br /><p>Hi Kerry,<br /> <br />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.<br /> <br />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<br />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<br /> <br />I would be nice to keep track of all our Stocks etc......(would not know how to do)<br /> <br />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.<br /> <br />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<br /> <br />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<br /> <br />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<br /> <br />Anyways any suggestions would be much appreciated<br /> <br />Thank you for your time<br /></p></blockquote><br /><p><strong>A:</strong></p><br /><blockquote style="MARGIN-RIGHT: 0px" dir="ltr"><br /><p>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. <br /><br />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. <br /><br />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. <br /><br />Good luck. I hope this helps. <br /><br /> Kerry Kerstetter </p></blockquote><br /><p><br /><strong>Follow-Up:</strong></p><br /><blockquote style="MARGIN-RIGHT: 0px" dir="ltr"><br /><div>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.</div><br /><div> </div><br /><div>Thank you!</div></blockquote><br /><p><br /><strong>My reply:</strong></p><br /><blockquote style="MARGIN-RIGHT: 0px" dir="ltr"><br /><p>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. <br /><br />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. <br /><br />Good luck. <br /><br />Kerry Kerstetter </p></blockquote><br /><p> </p><a href="http://www.nolo.com/resource.cfm/catID/E60B9A45-4B75-424C-91CDDAC9F6AB3A18/213/287/?kbid=2152&img=17.5.gif"><img border="0" src="http://www.nolo.com/images/affiliate/17.5.gif" /></a> <img border="0" src="http://www.myaffiliateprogram.com/u/nolo/showban.asp?id=2152&img=17.5.gif" /> <br /><p> </p>Kerry M. Kerstetter, MBA~CPA~ATP~ATAhttp://www.blogger.com/profile/12159545318811794036noreply@blogger.comtag:blogger.com,1999:blog-5582683231426598711.post-13470088811804157712009-08-05T20:00:00.005-04:002009-08-05T20:11:28.529-04:00Installing QB on Multiple Computers<span style="font-weight: bold;">From A Client:</span><br /><br /><blockquote>Hi Kerry,<br /><br />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?)</blockquote><br /><span style="font-weight: bold;">My Reply:</span><br /><br /><blockquote>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.<br /><br />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.<br /><br />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.<br /><br />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<br /><br />I hope this helps. Let me know if you have any more questions or problems.<br /><br />Kerry </blockquote><br /><span style="font-weight: bold;">Follow-Up:</span><br /><br /><blockquote>Hello,<br /><br />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!</blockquote>Kerry M. Kerstetter, MBA~CPA~ATP~ATAhttp://www.blogger.com/profile/12159545318811794036noreply@blogger.comtag:blogger.com,1999:blog-5582683231426598711.post-14704923231201048922009-08-04T14:09:00.001-04:002009-08-04T14:11:04.998-04:00New Password Requirement<p><br /><strong>From a client:</strong></p><blockquote style="margin-right: 0px;" dir="ltr"><p>Not too happy with the Quickbooks new program I bought. It is now requiring a password to encrypt! Password is ******.</p></blockquote><br /><p><strong>My Reply:</strong></p><blockquote style="margin-right: 0px;" dir="ltr"><p>I was glad to see that you upgraded your QB program to the 2009 version. I hope it is easier for you to use<br /><br />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.<br /><br />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 <a href="http://taxguru.org/clients/sending/datafiles/quickbooks.htm" target="_blank">my website</a>. <br /><br />Thanks for your help with this.<br /><br />Kerry </p></blockquote>Kerry M. Kerstetter, MBA~CPA~ATP~ATAhttp://www.blogger.com/profile/12159545318811794036noreply@blogger.comtag:blogger.com,1999:blog-5582683231426598711.post-22943318015570911322009-06-11T23:28:00.001-04:002009-06-11T23:28:15.054-04:00Creating Accountant Review Files in QB 2009<p><br /><strong>From a client’s new bookkeeper (T):</strong></p><br /><blockquote style="MARGIN-RIGHT: 0px" dir="ltr"><br /><p>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. </p><br /><p>Thank you, </p></blockquote><br /><p> </p><br /><p><strong>My Reply:</strong></p><br /><blockquote style="MARGIN-RIGHT: 0px" dir="ltr"><br /><p>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. </p><br /><p><span class="moz-txt-citetags"> </span>Kerry </p></blockquote><br /><p><br /><strong>T:</strong></p><br /><blockquote style="MARGIN-RIGHT: 0px" dir="ltr"><br /><p>Kerry,<br />We upgraded from QB 2006 to QB 2009.</p></blockquote><br /><p><br /><strong>KMK:</strong></p><br /><blockquote style="MARGIN-RIGHT: 0px" dir="ltr"><br /><p>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 <span class="moz-txt-citetags"> </span>quite a bit between the 2006 and 2009 programs. There are now two main <span class="moz-txt-citetags"> </span>ways to do it.<br /><span class="moz-txt-citetags"> </span><br />I am going to try to use a <a href="http://www.jingproject.com/" target="_blank">new software tool</a> to make some little mini <span class="moz-txt-citetags"> </span>videos on how to do this, which will hopefully be easier to follow than <br /><span class="moz-txt-citetags"></span>a written description. I will send those on to you as soon as they are <span class="moz-txt-citetags"> </span>done.<br /><span class="moz-txt-citetags"><br /></span><span class="moz-txt-citetags"> </span>Kerry</p></blockquote><br /><p> <br /><strong>T:</strong></p><br /><blockquote style="MARGIN-RIGHT: 0px" dir="ltr"><br /><p>Kerry, <br />Thanks for your help. I will get the information to you as soon as you send me the videos. Thank you so much. </p></blockquote><br /><p><br /><strong>KMK:</strong></p><br /><blockquote style="MARGIN-RIGHT: 0px" dir="ltr"><br /><p>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. <br /><br />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 <a href="http://www.screencast.com/t/XrIZ7odf" target="_blank">here</a>. </p><embed height="612" type="application/x-shockwave-flash" width="772" src="http://content.screencast.com/users/TaxGuru/folders/QB-Public/media/fe30e929-c904-4729-8275-30bd6c1bc43f/jingh264player.swf" quality="high" bgcolor="#FFFFFF" allowscriptaccess="always" flashvars="thumb=http://content.screencast.com/users/TaxGuru/folders/QB-Public/media/fe30e929-c904-4729-8275-30bd6c1bc43f/FirstFrame.jpg&containerwidth=772&containerheight=612&showbranding=false&content=http://content.screencast.com/users/TaxGuru/folders/QB-Public/media/fe30e929-c904-4729-8275-30bd6c1bc43f/QB09SaveAcctFileSound.mp4" allowfullscreen="true" base="http://content.screencast.com/users/TaxGuru/folders/QB-Public/media/fe30e929-c904-4729-8275-30bd6c1bc43f/" scale="showall"></embed> <br /><p><br /><br />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 <a href="http://www.screencast.com/t/gPlegjVtkX" target="_blank">here</a>. <br /></p><br /><p><br /><embed height="660" type="application/x-shockwave-flash" width="822" src="http://content.screencast.com/users/TaxGuru/folders/QB-Public/media/2848ee64-8e38-414b-b70b-c2240b8ae6cf/jingh264player.swf" quality="high" bgcolor="#FFFFFF" allowscriptaccess="always" flashvars="thumb=http://content.screencast.com/users/TaxGuru/folders/QB-Public/media/2848ee64-8e38-414b-b70b-c2240b8ae6cf/FirstFrame.jpg&containerwidth=822&containerheight=660&showbranding=false&content=http://content.screencast.com/users/TaxGuru/folders/QB-Public/media/2848ee64-8e38-414b-b70b-c2240b8ae6cf/QB09SendAcctFileSound.mp4" allowfullscreen="true" base="http://content.screencast.com/users/TaxGuru/folders/QB-Public/media/2848ee64-8e38-414b-b70b-c2240b8ae6cf/" scale="showall"></embed> <br /></p><br /><p>I hope these are helpful. I will also be posting these to my QB blog and to my website. <br /><br />Let me know if you have any problems or questions. <br /><br />Kerry </p></blockquote><br /><p> </p>Kerry M. Kerstetter, MBA~CPA~ATP~ATAhttp://www.blogger.com/profile/12159545318811794036noreply@blogger.com