I was installing version 2007 and somehow when I was finished neither the 2005 or 2007 version had any data past Jan. 25th. Evidently my backup CD was bad or I did something wrong.Is there anyway I can find this data?
                 Hopeful,
                     Mary Sloane

WE HAVE BEEN USING QUICKEN PREMIER HOME OFFICE 2005. WE HAVE A COMPANY & HAVE INVOICED OVER 1500 CLIENTS. WE NEED TO CONVERT TO QUICK BOOKS & WE BOT QUICKBOOKS PRO 2008. WHEN WE CONVERTED THE NAMES ADDRESS DON'T MATCH UP & I'M NOT SURE WHAT ELSE DOESN'T WORK.

WHERE DO I START TO FIGURE OUT WHAT HAS OR HASN'T CONVERTED CORRECTLY. WE HAD TRIED TO CONVERT 1.5 YRS AGO HOWEVER THE TECHS AT QUICK BOOKS LOOKED AT MY CONVERSION AND SAID IT WAS GOING TO TAKE ME ALOT OF MANUAL ENTRIES TO CORRECT. SHOULD I START OVER, SET UP MY CATEGORIES & ACCOUNTS FIRST OR WHAT?

HOW I HAVE INVOICED IS AN UNPAID INVOICES ACCOUNT. THE INVOICES HAVE THE CLIENTS BILLING INFO & JOB ADDRESS, CATEGORY, DESCRIPTION, QUANITY, PRICE, TOTAL. ONCE THE CLIENT PAYS I MOVE TO UNDEP CKS ACT THEN WHEN I MAKE MY DEPOSIT I TRANSFER FROM UNDEP CKS ACT TO BUSINESS CHECKING.

MY BILLS ARE PAID IN A BUSINESS BILLS ACT.

WE DO HAVE A SHORT-TERM LOAN ACCOUNT THAT MOVES MONEY FROM PERSONAL TO BUSINESS. I THINK EVERYTHING ELSE IS STRAIGHT FORWARD. LOAN ACCTS & ASSETS.

THANKS FOR THE HELP I'M VERY FRUSTRATED.

• jthompson (Apr 9, 2008 7:28 am)

ALWAYS MAKE A COPY OF YOUR QUICKBOOKS FILE BEFORE DOING EITHER OF THESE METHODS!

Normally, I would export your customer data in csv format. Then I would import it into MS Access and an example of customer data from a QuickBooks export file (minus the header data but including the column headings). After that, I would use queries to create a table using your old data that puts it into the correct QuickBooks format. Once this was done, you can export the file in a text, tab-delimited format and import it into QuickBooks. To do this you do need to understand little quirks, if you need help, give me a call (phone is listed on my web site).

ALWAYS MAKE A COPY OF YOUR QUICKBOOKS FILE BEFORE DOING EITHER OF THESE METHODS!

The easier method is to export your data to a Excel Spreadsheet (or a csv text file that opens with Excel). Then map the Excel file by using QuickBooks import tool found in "File/Utilities/Import/Excel Files" by browsing to your file, selecting it, select which worksheet you are importing from, and map each column to the appropriate place. I almost always start this way instead of creating transactions first. After all, without the names, the transactions don't mean a whole lot.

Then import. If the names don't line up in the addresses, etc, then move the things around a bit.

Tip: First address line should be the "Company Name" or "Customer Name" you want to address this to. (e.g. you might have to import the "Company Name" to two or three different fields within QuickBooks.).

Everytime I try to reconcile an account, as I am completing the reconciliation QB 2008 creates a new printer on my system called Intuit Intermal Printer. It appears to set this as my default printer on my system, and I get a message in Quickbooks stating that the printer cannot be found. I then have to go to my contol panel and delete the printer. This is truly a pain. Any help would be appreciated. Thanks!

• jthompson (Apr 9, 2008 8:11 am)

Actually, the internal printer is supposed to be there because QuickBooks uses it to create *.pdf documents for you. What you need to do is to let it create the new printer, and right-click on the printer you want to make default and click on "Make Default".

You also need to go into your printer setup within QuickBooks and select the printer you want to use for each area (i.e. reports, invoices, checks, etc...) instead of the internal printer.

Hope this helps!

When exporting the accountant's copies to my clients it is undoing the previous reconciliations. The only explanation I find on the QB site is . . . " reconciliations that include transactions dated on or before the dividing date will be undone when you import your accountant's changes". Does this mean they are clearing a transaction prior to the dividing date, which was already recorded prior to my taking the accountant's copy. Or does this mean that they are entering a transaction prior to the dividing date after I have already taken the accountant's copy, which I didn't think they could do.

• jthompson (Apr 9, 2008 8:55 am)

It means that any transactions that have been cleared by the client prior to the dividing date will be undone from the date they made the accountants copy to the time they re-imported the accountants copy.

If you are using 2008 accountants edition to reconcile a pre-2008 version of QuickBooks (i.e. 2007), the reconciliation will not "hold".

The reconciliation will hold if your client has 2008 QuickBooks (not Enterprise), and you have Premier 2008 Accountant Edition of QuickBooks. However, if your client has an earlier edition than what you are using to do the reconciliation with, either they will need to upgrade or you will need to use an older edition. Changes you make using the different year versions will stay, however, the reconciliation will not.

Personally,I keep three years of QuickBooks on my machine so that I can use whatever the client needs. Prior to that I do not offer as much support with.

I have been using Quick books for the past 4 yrs. I am quick learner but did not go to a class to learn all that quick books can offer. I learned from previous boss, just what that company needed. In my current job it is the basic bill paying,invoice, p.o's etc. Well I was told by my boss that his accountant wants me to build a chart account for the loan an employee borrowed from the company. They want an opening balance and when the employee makes payments to decrease from the balance. Here is where I need help. I can go to chart accounts and create a new account. Do I use the Loan or Line of credit? and how do I enter an opening balance? and how do I enter the payment?

Please if anyone can help

• jthompson (Apr 9, 2008 9:37 am)

To track a loan to an employee:

1) Go to the chart of accounts (ctrl + "A"), and create a new account (ctrl + "N").

2) Create it as an "other current asset" since the company has already given money out that is to be paid back to the company.

3) Go to the employee item list (Employees/Manage Payroll Items ") and select "View / Edit Payroll Item List" (you can simply add a new payroll item but I prefer to look at the list to make sure it is not already there).

4) Then create a new item (ctrl + "N") and select EZ Setup and then "Other Additions".

5) Check the box, "Cash Advance" and click on "Finish".

6) Go back to the payroll item list and select the item you just created. Double-click and rename it from "Cash Advance" to "Employee Advance", click on "Next" and select the account you created earlier to track the advance.

7) Select "None" as the tax tracking type. Click "Next" and make sure no taxes are selected (otherwise the employee would pay taxes twice on this advance).

8) Click on "Next" and select the "Neither" option. Click "Next" and select "Gross Pay". Make sure to set an annual limit so that employees don't borrow too much. Select "Finish"

The employee will now be able to get an advance. To set up the payment plan, you will want to do the same thing but set it up as a "Other Deduction" and call it, "Employee Loan Repayment" or something. Point it to the same account so that the liability is gradually removed. Make sure under "Tax Tracking" you select "None". For the vendor, do not enter anything.

The major thing here is to have this deduction based on "NET" pay and not gross. Otherwise, the employee would not be paying tax on the taxable income for this loan.

Hope this helps! Please call me if you need additional assistance on this matter.

Hi Jay,

I have a client running QB Pro 2008 on a Vista PC. For the first 5 months the Shipping Manager was excellent. Now he gets the following error messages;

DBISAM Engine Error # 8961 Header information corrupt in the table "PrintableDocument"
SQL:INSERT INTO PrintableDocument (BOLD_ID, BOLD_TYPE, DocumentType, LabelFormat, MimedData, LabelWidth, LabelHeight, LableDPI, Package,Manifest)
VALUES (:BOLD_ID,:BOLD_TYPE, :DocumentType,:LabelFormat,:MimedData,:LabelWidth,:LabelHeight,:LabelDPI,:Package,:Manifest)

Upon closing QB the following appears;

TBold System. Destroy. Destrpying systemwith dirty objects (zfb_UPSBusinessClasses)

Jay, Vista was completely re-installed on the PC and the same problems exist. It appears to me that there may have been an update that has caused this to occur. PLEASE HELP

Thank you, Jim

• jthompson (Apr 9, 2008 9:52 am)

Hi Jim,

You might want to try the following that I had found online:

This is the error: DBISAM Engine Error #8961 Header information corrupt in the table 'web_log'

Problem: You may get this error message when BiblioWeb is running as Windows service or as a regular application.

Solution: Quit BiblioWeb if you are running it as a regular application.

Stop the BiblioWeb service if you are running it as Windows service by using Windows service manager.

Jay: Go to Control Panel/Administrative Tools and go down list until you find "Services". Select the "BiblioWeb" service, right-click and select, "Manual".

Quit Biblioscape as well if it is running. Run "...\Biblioscape X\Tools\Rebuild.exe" and click on the "Rebuild Global" button. Restart BiblioWeb once the rebuilding process finished. You can choose to turn off the "Keep Log" option by check off the "Keep Log" box near the satus bar of BiblioWeb window.

That's all I have in a quick answer. If you need help, please feel free to call me.

I need to know how to link a income account and an expense account, let's say I received $100 for church camp, I want to now pay the $100 out for church camp, I need to show the income going to church camp and show it going out but I can't get the two linked together. have set up a church camp income account and a church camp expense account, it will show I received the money and spent it. but the income money is still sitting there, it won't pull it out of the income account. How do I fix this.

• jthompson (Apr 10, 2008 8:00 am)

Your income account simply shows how much income you have received. It doesn't show you how you spent your income. Similarily, your expense account shows your expenses. If you do a profit & loss report (Reports/Company & Financial/Profit & Loss Starndard) you should see that the income came in for the church camp and was expensed for the church camp.

If you are setting this up for a church, then you have to set this up differently so that your church camp payments do not show up as "income". You will more likely want to show it as an "other current liability" since you are basically holding money for someone else and then paying it out as required. You will then need to look at this from a balance sheet perspective (i.e. this is what is currently being held for camp as a liability). If you liability is positive after the event, for example, you can return money to those who didn't attend but did pay.

Is there a way to change the preset columns that show on and invoice - that are coming from the item list. The only thing that currently shows is the item#or Code the Item Description and the Price.

We are a landscape firm and I would like to add a Item Size for example #10 Pot or #15 Pot to show on the list when entering it into an invoice.

I know how to make it show on the list, but not when entering in into an invoice. Is that something that can't be changed?
Lisa

• jthompson (Apr 10, 2008 8:11 am)

I am guessing that in your item list, you are using the custom fields to define your products (Pot Size).

If this is the case, all you need to do is to go into your invoice templates (Lists/Templates) and select the invoice template you want to change. Then double-click that invoice and click on "additional customization". Click on the "column" tab and put a checkmark on the customized description (Pot Size) based on whether you want to see it on the screen, print, or both screen and print.

We are considering buying POS for our internal inventory, but I have a few questions:

1. I downloaded the trial version. If I set-up a company in the free trial, can I transfer that information if I decide to purchase POS?

2. We are only interested in the average unit cost for pricing when making a sale. I know that the ave unit cost calculates when items are received, but how do I set the ave unit cost as my default price level when making a sale?

3. Can you change a receiving voucher?

Thanks!

• jthompson (Apr 10, 2008 9:23 pm)

1) Yes, you can "transfer" the information. Actually, all you do is enter the license key...there is no actual "re-installation".

2) I'm not sure if I understand this question. Most people want to make a profit when selling items. You would not normally set your sales price equal to your average unit cost for a particular item because you would not be making any profit which is usually the purpose. You can, however, set you price to whatever you would like using the "Price Manager".

3) Once you have completed a receiving voucher and saved it, you will need to copy the voucher, change the quantity or amount, and then "reverse" the original voucher.

Re: A/R Aging Summary
How do you get the report to show only the accounts with unpaid balances? My report also shows about 4 or 5 accounts which have had small balances that we "wrote off" with credit memos. The report shows 0 balances, but I would prefer not seeing them at all.
Thank you. Bunny

• jthompson (Apr 10, 2008 9:40 pm)

If you have clients with a zero balance and they are showing up on your A/R Aging Summary report, it is most likely because you have unapplied credits that still exist for those customers. You need to "Receive payments", and apply the existing credits to the remaining balances shown. This will remove them from your report.

Hi,

Is it true there is no way to condense and/or archive the data file in Quickbooks 2008. Our data file is currently 335 MB and we would like to streamline it.

thanks

• jthompson (Apr 10, 2008 9:48 pm)

No,it isn't. You go to "File/Utilities/Clean up company data". Then select "Remove Tranactions as of a Specific Date" and select that date. Go through the wizard and select those things that you are interested in removing and QuickBooks will then create summary transactions to replace all of the individual transactions reducing the overall size of your data file.

i've been using quickbooks pro 2000 for windows. i just bought a mac and the quickbooks pro 2007 for mac. can i convert my old quickbooks files and use them in the new mac version?

• jthompson (Apr 10, 2008 10:00 pm)

What you would want to do is have someone with QuickBooks Pro or Premeir 2007. They will be able upgrade your file to their version and then save it as a Mac version. To do this, do the following (found in QuickBooks Help):

Verify that you have QuickBooks for Mac, version 2007 or later.

Open your QuickBooks for Mac application.

Press Command+1.

Important: You can only convert your company file for use with QuickBooks for Mac, version 2007 and later.

Open the company file in QuickBooks Pro or Premier for Windows.

Go to the File menu, click Utilities, and then click Copy Company File for QuickBooks Mac.

Choose a name and location for the file. The backup file must have a .qbb extension.

I use "non inventory items" where I associate my cost and the sale price (which includes a mark up). I have no accounting background and I don't understand how I can get it to give me only my profit for that item on either P&L (or any other report). If I paid $5 and sold for $10 I just want to see my $5 profit by I either see nothing or the whole $10. What do I need to do to just be able to see profits on my items?

• jthompson (Apr 10, 2008 10:11 pm)

If when you purchase those items, you do so using the item tab of the transaction form (i.e. check or bill), you will be able to see the items profitability by doing an item profitability report.

If you cannot enter the item in the transaction,it is because you have not set up the item for purchases as well as sales. You set up an item for purchases by checking, "This item is used in assemblies or is purchased for a specific customer:job." Then select the expense account that you are tracking purchases for resale in (i.e. re-sold Product Expense)

Do an item profitibility report by going to the report menu and selecting "jobs time & mileage" and then select "Item Profitability". You should have an accurate display of the profitability of the items you have.