Discussion:Locked QB actually isn't!
From TaxAlmanac
Discussion Forum Index --> General Chat --> Locked QB actually isn't!
Actionbsns (talk|edits) said: | 10 May 2008 |
| I had a call from a client yesterday. They are working with a consultant to increase income and the first thing they seem to be doing is attacking the QB data file. They wanted to clean up old, inactive estimates, but I've locked the data file at 12/31/07. When I returned the call, client said it's OK we figured it out!! Then she explained what they wanted to do and that they had just unlocked the data file. I was surprised and asked how she did that. It's a simple matter of going in and deleting the date the books are closed by and the password. I didn't know you could do that. So what's the point of locking the file at year end if the client can just go in and unlock it and do whatever they want to in there. Now I'm a little worried that the consultant will want to clean up something else that will affect the data file in a more profound way. And I do hope a couple other people don't figure this out!! | |
RoyDaleOne (talk|edits) said: | 10 May 2008 |
| That is why you kept a copy of the data file for comparsion if need be. | |
| May 11, 2008 | |
| Yes, Roy, but I share Action's concern. Personally, I don't like trying to figure out what was changed to prior years. I have better things to do. Now the question becomes, if that can be changed, what else can be tampered with? Is the audit trail alterable? Geez, Action, what a can of worms. | |
| 12 May 2008 | |
| They don't see them as books, it's just a computer program to them.
It amazes me nowdays. Everyone hires based upon the Software: do you know Excel, do you know QuickBooks? They ought to ask whether they know how to keep books properly (by hand if necessary). The highschool business teacher with the old bookkeeping courses actually added a lot of knowledge to American business. Today, these poor teachers are chained to computers and teaching the software du jour. | |
| 12 May 2008 | |
| Hmmmmmmmmmmmmmmmmmmmmm, imagine that. lol. QB's $249, quick, cheap and easy to work with. Hmmmmmmmmmmm. Sounds like a good time to talk software that is actually compliant with all that sarbanes-oxley thingamagongs.
Any software you use where you can alter the original transaction is not good software for clients unless they are the only ones doing data entry. If they are large enough to need a bookkeeper or a controller they should have a better program. Once again, the reason we love QB's is the same reason why we shouldn't use it. Because we can make things disappear. clients and staff can too. that is also why controllers are hesitant to switch. They know it's bad from a control standpoint, but they like it cause it can be changed and therefore their mistakes or ooooopppsies aren't seen. Accountants like it because we know it. Don't want to take time to learn new software. All of these things doesn't mean gooooooood program. Means easier to fudge, easier to hide lack of knowledge and easier to steal. For just a few dollars more, clients can get real accounting programs with the controls that should be there and lot more in the realm of capabilities. | |
| 12 May 2008 | |
| And Crow, I view software as a vehicle. I don't care whether it's a stick or automatic, put me behind the wheel and I will be able to drive it. I might chug along at first, but pretty soon I'll have that baby purring.
Excel, Quatrro Pro, Lotus, all the same. Word, Wordperfect, AmiPro QB's PeachTree, Onewrite, MAS90, Blackbaud - all different vehicles, all using a map, just many different roads that lead to the same place. | |
| 12 May 2008 | |
| The Admin user can change the password. I usually set up users for my clients and have them log in with a password. That helps when I need to look at the audit trail. I am the Admin so I set up my own password. They can't log in as the Admin without my password. | |
| 12 May 2008 | |
| oh, but you forget the quickbooks unlock password tool. if i have registration key, I can unlock any QBs file password and reset it. Not safe. | |
| 12 May 2008 | |
| quickbooks download site. i've had to use it a couple times | |
Actionbsns (talk|edits) said: | 12 May 2008 |
| Wow Fred I didn't know that one either! What else can a client do to these programs after we have put "safeguards" in place that we thought would protect the integrity of the financials? I've used true accounting software, Peachtree (DOS was my favorite for years), and QB. QB is easier for laymen, true accounting confuses the bejazus out of them even though it's better. Most people don't get journal entries. | |
| 12 May 2008 | |
| The main issues/problems with these are the same things that we like them for. Ease of use, accounting knowledge not required <just write a check and poof> and that wonderful ability to alter transactions previously entered.
We like ease and simplicity, yet complain when our clients do not give us the books in proper order. By providing our clients with the proper tools, that also have the proper safeguards, we truly serve their needs as opposed to making things as simple as possible even though the output is not right. Make sense? In my opinion, true accounting software is software that follows the transaction cycle for each type of transaction being entered. the software should not take shortcuts. For example, I sell you 100 widgets, I should have to ship those widgets before I am able to create an invoice. And if I make a mistake in that invoice, I can change it, but that change should show in the transaction as just that, changes. All original and subsequent changes should be there. You want your software to be accurate, have data and user integrity, be secure, be as real time as possible. If you have inventory and those numbers are not accurate, how many sales and dissatified customers get generated because the QB's or Peachtree allows you to bypass controls and now inventory amounts are incorrect. you should be able to access the accounting program using outside database programs <access, Excel, crystal reports> to generate the reports you need as opposed to duplicate entry into spreadsheet programs. your accounting program should <once learned> make you more efficient and also give you timely information that allows you to run your organization better. Without real time reports, the usefulness of bookkeeping programs is lessened. they become an after the fact tool to prepare tax returns with, rather than a current tool used to assist management in making quicker and more informed business decisions. In todays technology world, we need to better utilize the tools we have at our disposal or to get better tools. QB's and Peachtree are not the proper tools for those businesses where the owner isn't doing everything. | |
| May 12, 2008 | |
| Fred, I agree with almost everything you've stated. The question I have is, what software is "just a few dollars more" that goes beyond QBs and PT? One of my clients was considering a program made by Sage, and the training costs alone were outrageous. | |
| 12 May 2008 | |
| First off, you need to know what your clients needs are and also whether they needed everything being quoted to them.
Let's put it this way. you have good resellers and you have bad resellers. You have resellers that wish to sell clients the Mercedes Benz when the Camry will do. My philosophy has always been to give the client just what they need to replace what they are currently doing, then move forward and add additional modules as the client masters the ones they have. I can do a needs analysis and justify tons of modules, but will the client be able to learn and use them in a timely fashion. Probably not. So, a good reseller will start with the core modules and add things as the client becomes more and more proficient. Also, if cost is truly a factor as opposed to the owner just wanting a new hummer for the current year, there are bridge programs that are better than QB's/PT but not quite as powerful as the MAS 90/200 package or a competitors package. Yes, you are talking anywhere from $1,500 up to $30,000 and even more, but the cost has to be justified by the efficiencies realized or by additional revenue generated by switching to a new program. For instance, I had a client who would spend hours each week taking information from payroll and entering it into excel spreadsheets. I was able to create a crystal report that would pull this information out just by pressing a button. 5 hours a week saved times 52 is 260 man hours. Totally quantifiable. If, by having completely accurate online inventory the sales force can make more sales calls and by making more sales calls make more sales, then that is another quatifiable figure. The software should be treated like an investment, what is the payback period. Will this investment make me more money? Save me more money? Provide stronger controls? Sometimes it is justifiable, sometimes not. | |
| May 12, 2008 | |
| I agree again Fred. The case I referred to was for a nonprofit client, and after going through some preliminary meetings with the reseller, the bookkeeper and I both came to the same conclusion.
The one thing I really disliked about MAS90 was that only short descriptions were allowed for JEs. Has that changed? | |
| 12 May 2008 | |
| if you are talking more than 2 years ago then the entire structure has been re-written. Much better than before. I think you would be amazed at the new functionality it gives you.
Now, although I have ties to Sage Resellers and am most familiar with MAS90/200, my discussion is not based on their virtues. Whether a Sage product or a competitors product is used, the key is to make sure the client has the proper tools to do what they need to do. Sage MAS90/200 is not always a fit for all clients. But, the proper program is worth every penny the client spends. Keep in mind that when buying a more expensive software product, whether it is accounting software, or Contact Management Software or whatever kind, not only should you look at the company that makes the software, but also the structure in which it is supported. If resellers are used, you need to make sure your reseller is knowledgeable in the things your company or client needs otherwise, they aren't going to be able to properly set up and support you during the implementation process and beyond. Many resellers use salesman to sell and techno-geeks to implement. Sometimes these two groups don't talk. salesman promise the moon, implementation team can't deliver. not good. Look at resellers that have true integration within their firm. Implementation teams that have real world business experience is a huge plus. With me, I was salesperson, implementation specialist and tech support all rolled into one. I'm an accountant first, salesperson last. So I focus on client needs rather than what hits my pocketbook. Usually works out better in long run as clients appreciate the soft sell and referrals follow. | |
| May 12, 2008 | |
| Okay, Fred, so the next time one of my clients is considering a change, we'll call you. Do you make "house calls"? | |
| 13 May 2008 | |
| you can call me anytime Nat. I'd be more than happy to help them sort through proposals to get to the meat.
And yes, I do make "house calls". When you think about it, not much more expensive to fly to Hawaii than it is to Florida, or Chicago or San Diego. And with todays technology, virtual implementation and training can also take place. | |
Actionbsns (talk|edits) said: | 24 May 2008 |
| My staff person started to work in a file the other day and it was locked, by me, but I couldn't find the password, tried the unlock provision. Worked like a charm. Very Scary
Fred, we need some help with another client, though. We are trying to lock their books, at least they will get a scary message if they try to post into a prior year and it will stop them and they'll call me. Problem is, the office manager set everyone up with their own ID and password, including herself, and can't remember the password at Admin. I had originally set it up with the owner's name, but somewhere along the last several years, that was changed and nobody remembers what it is now. They can't find their original software box with the registration number. Is there a way to retreive that so we can reset the Admin password? | |
| May 24, 2008 | |
| What version of QBs is this Action? With the newer ones you don't need the registration numbers -- Intuit uses the license and product numbers now. I would suggest calling Intuit. They should have the company on file, and I think they may have the license number as well. | |
Actionbsns (talk|edits) said: | 25 May 2008 |
| This is v. 2006 Natalie. Do you think Intuit will talk to us without charging? | |
TheTinCook (talk|edits) said: | 25 May 2008 |
| I'm pretty sure ProAdvisors get unlimited free support. Maybe it's just us mainlanders. | |
Outwesttax (talk|edits) said: | 25 May 2008 |
| Sad to say, but cracking a QB file is about a 15 second process. Lot of other stuff for that matter.
http://www.lostpassword.com/quickbooks.htm Works well, been using it for years. Also goes to show that passwords are like lock on a door, they won't much slow a determined thief. | |
| 25 May 2008 | |
| outwest gave you one way to do it. The one I used was an intuit version and there were a few controls built in. free and should work. if you need the file, shoot me an email and i can send it to you. | |
| May 25, 2008 | |
| 2006 is still supported by Intuit (2005 gets sunset 5/31/08), so they should be able to provide the information for you if the two other programs mentioned do not work.
| |
Outwesttax (talk|edits) said: | 26 May 2008 |
| Well, as I said, locks only slow down a thief and sends them down the street to the next house. That said, a strong password can make a brute force attack so long it's impractical. And if you really want to lock up the info, don't rely on program passwords but something like
Doug | |
TheTinCook (talk|edits) said: | 26 May 2008 |
| I checked out truecrypt. Neat stuff! I just have to figure out a way to get working easily with QB data files. | |


