Do you have two different copies of the same company data on your system? Maybe one is an old copy that you use just for historical reporting, and the other is your working day-to-day current file.
There is a potential danger lurking here: You could confuse the two copies and start entering data in the old one instead of the current one. I occasionally get a call from a user who says “All of a sudden, I have a nine month gap in my file — everything from January to September is missing!” This is almost always because they inadvertently started using an old file and putting current information into it. Then they didn’t discover their error until well down the road.
This problem is much easier to prevent than to fix. Basically, you need to make it so that the two copies look quite different from one another, and the old copy is password protected against accidental entry.
So here are the three steps you need to take to prevent confusion.
Let’s say that this is your working, current company file.
Now, say you have another copy of this company data on your system. And you DO NOT want to make any entries into the copy. You want it to be perfectly clear to your users which is the current working file, and which is a copy that is not to be altered.
So do the following steps on the COPY:
1. Open the COPY of your company and click on Company / My Company. Click the Edit button for Company Information. Change the Contact Name and Address to “DO NOT USE – ARCHIVE” or something of the sort. Save your changes.
2. Click Edit / Preferences / Desktop View. For Company File Color Scheme, change it to Red or some other color that will get your attention, and that is different from your normal color scheme. OK your changes.
It will look like this:
Pretty obviously not the same company, eh? That’s the point.
3. If you really want to lock down the COPY so that no one gets confused and starts entering transactions into it, click Edit / Preferences / Accounting / Company Preferences. In the Closing Date box, click Set Date/Password. Enter a Closing Date that is very far in the future. Then enter a Closing Date Password.
It will look like this.
So what you’ve done here is make it so that in order for a user to enter a transaction in the COPY, they will have to know a special password. Don’t tell anyone what this password is. It is supposed to be unknown, so that no one can make entries to this COPY file.
So between the company name change, the color change, and the transaction lockdown, it should be clear to your user team: this file is not the current working file.
[My thanks to David Warlick, a blog commenter, for the tip on color coding files.]
Do you have any advice to share on avoiding confusion with your QuickBooks files?
Please follow and like us: