My Font Size "Magically" Changed.

Question:

I turned on my computer this morning only to find that all my settings had been “magically” changed overnight. When opening QuickBooks, the font displayed on my desktops is about a size 8. Every place that I found to change the font already shows it being at my original default setting of size 11. But that’s not what is displaying. I did a couple virus scans and restarted my computer but nothing helps. What am I missing? Thanks!

Answer:

Don't you love it when settings "magically" change. It sounds to me that it is a problem with your screen resolution settings rather than QuickBooks. Do all the other programs display text correctly? If so then you may have a virus or some other problem. Check with your network administrator.

It is obvious from your question that you found where to change the display settings. For the benefit of everyone else, here is a quote from the QuickBooks Help screen dealing with how to change screen resolution and font size in Microsoft Windows.

"From QuickBooks, you can open the Display Settings for Microsoft Windows. Changes to your Display Settings will affect other applications beyond QuickBooks.

1. From the View menu, choose Customize Desktop.

2. In the Windows Settings area, click Display.

3. Select options for Desktop Area and Font Size."

Tracking Groups of Funds in "Super-Classes"

Question:

I'm looking at the books of a non-profit that has over a dozen funds they need to track. It would be nice to create a class for each fund. It would be nice to have a super-class of similar funds, so a report could have columns like these:

Operating Fund

Endowment - Unassigned Fund

Endowment - Assigned Funds - This column would contain a total of numerous "sub-class" funds Scholarship Funds - This column would also contain a total for numerous "sub-class" funds.

I know QuickBooks permits selecting any funds to include in a report. I know that information could be consolidated in a spreadsheet, but does QuickBooks permit creating any kind of super-class or other technique so that collections of classes could be shown in one column next to other collections of classes.

Answer:

Unfortunately, I don't think that "super-classes" are possible within QuickBooks. For this, you would need to find a more robust accounting software product that is based on fund accounting. This probably is overkill for most non-profits as this fund accounting packages can cost tens of thousands of dollars. I would say that from your description you are doing the best you can with what you have. If you really need these reports, you could try to format them in excel.

My Backups are Using Too Many Disks! (Condensing Data)

Question:

How can I limit my number of disks needed for daily back ups. I started with one and now I am up six. What is the procedure? Or should I just keep adding disks?

Answer:

Here are a few suggestions to your problem:

• You can condense your data. If you have many years of transactions in your company file, then you can remove those transactions...leaving only the general ledger entries. The downside to this is that if you want to go back and see a check on your screen you will not be able to. I would keep at least 5 - 7 years of your data uncompressed. Personally I would not go this route, but I wanted to let you know it is available. How ever I not sure exactly how great the disk space savings would be.
• Do your backups on a CD. CD-RW drives are very reasonable now...I think this would be a good investment. Below is a link to a good one from amazon.com.
• Consider an online backup service. This will do two things. 1. You don't have to worry about the size as long as it fits in the size constraints of the service you are using...which is pretty big. 2. Your data will be stored off site. In the event of a disaster your data would be safe. Intuit offers one designed for QuickBooks, and there are others out there as well.
  

Help Needed!

Question:

I work with Africa for Jesus, a non-profit missionary org., and the Office Manager and I are having a problem with our QuickBooks information.

We are under the Non-Profit Navigator section of QuickBooks 2004 ed., and in inputing the support monies under donations (sales receipts), the totals are showing up in the deposits (which they should be) in the check registry, AS WELL AS payments going out. We have looked in the manual and are unable to find assistance with our problem. Christy called the Assistance line for QuickBooks and they said to enter the donations in under Payments Received, yet it is not working correctly, due to another step prior to this one which we have no idea what to do. If there is any way you can help direct us in the right direction or help us find a solution, we would greatly appreciate it very much!!!

Thank you!

Well, Michael...you have me stumped...I'm not sure that I understand the question completely, but it seems like one of those things that you would have to see to fix. Hopefully, one of our readers may have an explanation.

QuickBooks Enterprise Solutions 5.0 vs. QB Enterprise Solutions, Accountant's Edition.

Question:

What is the difference between QuickBooks Enterprise Solutions, Accountant's Edition ($849) and QuickBooks Enterprise Solutions 5.0 ($3,500)?

Thanks for your help!

Answer:

As I understand it, the accountant's edition is a single license version of the software. The regular Enterprise Edition includes the ability for up to 10 simultaneous users.

Finally Help Importing .IIF Files.

To further prove that we have the smartest readers on the internet, our readerAmos solved his own problem with importing .IIF files. Which seems to be a common problem. He points us to a QuickBooks support site that deals with this issue. Click here for the site. I hope you find it helpful, and thank you Amos for the tip.

Importing Lists.

Question:

Recently, we changed from QuickBooks Pro 2002 to QuickBooks Premier 2004 - Contractor Edition. We started from scratch and entered the opening balances to each account. When it came to lists, we imported the lists from the old program. Including the item list, which leads to my question. Previously, when I would choose an item (such as labor) to the timesheet and later to the invoice, the item description (such as: Field Engineer – ST) would show up on the invoice display and printed. Now, it does not automatically fill it in, the description field remains blank. Is this a problem that I encountered when I imported my lists instead of setting up items individually? Is there a way to rectify the situation? I knew that importing the lists would save allot of time, it was a “too good to be true” kind of thing. Am I paying for it now?!

Answer:

It seems that there are a lot of questions resulting from the importing of files/parts of files. It seems to me that Intuit should be looking at making this process easier. Your particular problem doesn't appear to be to difficult. I would first check to see if the item descriptions came over in you import. To do this go to your "Item List" (Lists - Item List). Find one of the items that is not displaying properly. Right click on it and select "Edit" and see what is in the "Description" field. If it is blank this is your problem. Now, you have two choices: 1. Try to re-import the list. 2. Spend some time with your computer and fill in the description field for each item. Considering the success I have seen with imports this may be your best bet.

Exporting Reports to Excel.

Question:

Is there a way to export a register to Excel? I'd like a list of say invoices created in May... or sales by month. Reports don't seem to offer what I'm wanting. If I had the register in a spreadsheet, I could create any report I needed.

By the way, THANKS for your blog site!!!

Answer:

Your very welcome...I have been enjoying it too.

As for exporting reports to Excel, it can be done, and in fact very easily. When you open any report in QuickBooks, there are several buttons in the header of the report such as "Modify Report", "Memorize", "Print", etc. There should also be a button "Export." If you click this button you will be asked how you want to export it...select "a new Excel workbook." You should then be able to format them until your heart is content.

One note however, as I understand it this feature is only available in QuickBooks 2002 Pro or higher. I don't believe that this is available if you have QuickBooks Basic.

Setting User Permissions.

Question:

I have set up a user with all rights except change/delete transactions. What is your opinion on the security of this? Does it later pose a problem if there is a posting error? How fail safe is this? It is my understanding that this user now is the same as Admin, just without the ability to change or delete transactions. Is this correct?

Answer:

I agree with you that there is some danger in allowing your staff permission to change transactions at will.

However, I think that you have picked up on a downfall of limiting access as well. Every time they make a keying mistake, you or one of the other administrators will have to log in and correct it...if your staff member did not catch the mistake in a single session.

It is kind of weird that this restriction works this way. Your staff member can change or delete transactions at will that they created in a single session. Once the session is closed (They logged off) they will no longer be allowed to edit or delete transactions.

You probably noticed in setting up the user permissions that you can allow editing and deleting of transactions in the current period while simultaneously denying the staff member permission to edit or delete prior period information. I would definitely use this restriction...as you know the danger of editing prior periods.

Basically, I believe that you have it right. The user you have set up is essentially an administrator. There could be problem in correcting errors, but only after a session is closed. You may still find this to be a good restriction to protect your data.

Using Quickbooks in a Networked Enviornment.

Question:

We have a small company and we are using Quick Books Pro 2005. We recently networked a laptop to the company computer for travel purposes. We are having a terrible time viewing QuickBooks on the laptop after the network connection has been unconnected. Do you know how to make it so that the laptop can view the QuickBooks files when there is no network connection?

Answer:

This question may be better answered by your network administrator, as it sounds like this is a networking problem rather than a software one.

It sounds like you are using a peer-to-peer network, and using the office desktop as the server.

Here are some things to consider when using QuickBooks in this type of networked environment:

• When both computers are connected to the network…ensure that your software is in Muti-User mode (File - Switch to Multi User Mode).
• If you are using the desktop as the server, I would store the company file on one of its drives.
• Be careful about backing up and using your company file on the road with the laptop. I have seen many clients forget to restore their changes on the main computer and get their data all messed up. One thing that has worked well for me is using Gotomypc.com. For a reasonable rate (around 20 bucks a month), you can access your computer from anywhere there is internet access.
  

As I said before, you should check with your network administrator to ensure that the way your network is set-up, as well as the way you are connecting and disconnecting from it is not causing you problems...because it sounds to me like it might be. I say this because personal experience in my practice has shown me that a Microsoft XP networked enviornment can have more quirks than you can imagine.