Do you want to know how to get the most out of your QuickBooks Product? Get help and advice from our expert!
Join us for an "Ask the QuickBooks Expert" event featuring Dawn Ashpole from SBA Services, Inc.. Dawn is a QuickBooks Advanced Certified Professional Advisor and QBES Solutions Provider, with over 20 years of experience helping small businesses to succeed!
***This event is closed. You will not be able to ask questions but you can still read the posts.
Question:
How do I install Quickbooks Pro 2007 on a linux server Jul 26, 2007 10:20 pm
I have been using Quickbooks 2003 for many years. On that version we merely selected the directory path to the company files which were being stored and accessed on our Linux Servers.
I am informed by Quickbooks technical support (after I purchased the upgrade of course), that the newer versions require the installation of "Server elements" on the server ..... but that the linux os is not supported.
Are you aware of a workaround or successful installation on a Linux File Server
I have just set up a new company in our Quickbooks Pro 2007 database. When I go to print out my voucher checks, it does not print the business category or the memo on the voucher. What do I need to do in order to get this to print? It prints for all my other accounts, just not the new one that I just created.
I can't believe Quickbooks will not support their own product unless you subscribe for their support. I will never purchase from them again. We have been a loyal customer for over 10 years.
Go to Edit - Preferences - Checking and click that you want the account to print on the voucher.
As to Intuit supporting their product, one of their products is their technical support.
Other than volunteering for this web page, even as a Pro Advisor I normally charge for support calls. I think you'll find the same for every accounting (and other) software programs out there.
Question:
Adding a Credit Card Acct. & Downloading from Web Jul 26, 2007 10:25 pm
Hello Dawn,
I am trying to fix some things for our company. I am in the process of getting all of the bank information posted to QB Pro 2007. One of the things that I am trying to download is our American Express statements. I have nothing set up in the Chart of Accounts.
Here are the steps I have been taking. I go to the BANKING tab and select enter credit card charges. Then QB Pro is taking me through the steps to create the American Express Co. CC. However, it wants to create the account in the COA as a liability, shouldn't it be entered as an expense account in QB Pro, rather than a liability?
Also, the company has 3 people who use this card; the two owners and our Director of Business Operations. What is your opinion, just have one account, and download the info for all three cards? Or create three different American Express CC accounts?
First of all, there is no such thing as a credit card expense. (I have to say that to all my new clients).
You used your credit card to buy WHAT? Office Supplies, postage, equipment, what?
Your AmEx card is in the Chart of Accounts as the type of account = Credit Card. It is a Liability.
You could post all of the cards into a single credit card account or create a Credit Card type account called "AMEX", Then create another credit card type account for each card and make them sub-accounts of AMEX. You can enter the charges under each card but reconcile only the "parent" account.
Question:
Quick Books Pro 2006 for Vista Jul 26, 2007 10:28 pm
I own a Pro 2006 and recently purchased a new PC ( Notebook ) with Vista operating system. Would like to know whether my 2006 Pro software will work with Microsoft Vista.
Also same question for Quicken Deluxe 2006 software?
Are you on 2007? I have found that for some reason, 2007 has been known to enter in wage adjustments and mess this up so that the system thinks the employee has had too much medicare deducted based on their wages.
From the employee center, look under transactions and see if there are any adjusments. You can double click on them and see what they are. If they're just adjusting wages I have deducted them and then everything was OK.
Question:
Can date format MM/DD/YY be changed to DD/MM/YY? Jul 26, 2007 10:34 pm
I have a client in a country where the date format is similar to Canada and UK.
By the way, do you know if Quickbooks provide same level of support to overseas clients as in the U.S.? I have considered the Quickbooks versions in the above countries including Australia. Since my client needs to use SDK for some automation and has no need for multi-currencies, I decide that the US version would be the best option. Appreciate to have your view on it.
I've never asked about the support. I do know that the Canadian version has the date format you're talking about.
I also know there are a lot of Pro Advisors who support the Canadian version.
We expected a sales tax change to begin 7/1/07 and began charging the lower rate at that time. We've now found that the sales tax will not go down until 8/1/07.....Anyhow, we owe more sales tax than collected now. I'm trying to determine how to make an adjustment to the Sales Tax Payable account so that I reflect what we actually owe the state in sales tax....
I assume you're not going to go back to the client and try to collect the difference but just pay it.
When you go to Pay Sales Tax there is an adjustment button, you can enter the additional amount and post it to an expense account. Then when you pay the Sales Tax it will be the combined amount of what you really deducted and what you're eating.
Hi, Dawn. I have been working with a floral business that also sales some apparel and gift items. They had previously been using Quicken. I have converted them to QuickBooks and set up items for their flowers. My question is in regards to the rest of the inventory. When inventory was purchased they booked it as "gift expense" and put it out on the floor. Previously when they sold items they were lumping everything into "gross sales". I have changed the income and broken it out by floral and gifts. I have no way of knowing what "gift inventory" has sold or the cost of the items. What do we do? They have only been open since May. Do we just begin inventory on all newly purchased inventory items? Thank you in advance!!
When they set up the item for "Gifts" is it an Inventory type item or a Non-inventory?
If they really want to track inventory then you'll need to edit the payments made to "Gift Expense" and change them from the expense tab to the Item tab and enter in every item, the qty and cost received.
One of the things about inventory is that each item has to be unique. Say they sell greeting cards. If they create an inventory item calls cards and then buy cards at different costs using the same item, it averages the cost of all the cards. The proper way is to create an inventory item for each price level of cards.
The quick fix is to take an inventory of everything in the store and then do an inventory adjustment, enter in the qty on hand and offset the adjustment account to the gift expense account.
When they posted the bills to the expense accounts they've overstated their costs so the adjustment will reduce the expense and increase inventory.
I'm looking for a way to automate the creation of identical invoices to multiple recipients. We need to invoice 300 homeowners for their association dues. The amount is the same for each homeowner. Is there anything comprable to a mail merge in Word?
You can duplicate an invoice but you'll still have to create one for each home owner.
Are these annual invoices, or quarterly or monthly?
First I would create a Service Item for the dues and enter in the amount on the item.
Then I would create an invoice for each customer using my dues item. I type d and it comes up with the description and amount automatically.
While on the invoice you can press Ctrl+M to memorize the invoice and set the frequency so that the next time you need to invoice the members they will all be created at the touch of a button. This works real good for quarterly & monthly invoices where the rate is the same for several billings. It may not work as well for annual invoices if the dues change every year.
We are new to QB coming over from PT. We have not been able to determine the best way to enter kind of a complicated transaction, a purchase of inventory. This is the course:
1) Issue a PO for the items along with a 50% deposit.
2) In approximately 90 days, receive the inventory and enter it with the correct costs. (Should not have changed since the PO was issued - unless credits were given.)
3) Within 3 days of receipt of merchandise, pay the balance of 50% less the acutal local shipping charges, which we in turn pay to the local shipper.
(These are items that are imported.)
We have currently placed the order and posted the downpayment as pre-paid deposits, then backed it out when we got it, but this is real messy. Wht do you think?
You need to create an item (Other Charge) for vendor prepayments and point it to an Other current Asset Account called Vendor Prepayments.
When you write the check for the deposit use the Item tab, use the vendor prepayment item. This will post post the deposit to the balance sheet.
When you enter the PO as the last item use the Vendor Prepayment and enter a qty of 1 and the amount of the deposit.
Now when you receive the inventory, receive the qty's and the vendor deposit. This will credit the Vendor Prepayment Asset account bringing it to zero. And it leaves the balance due as the correct amount.
Question:
Prepayments to vendors Aug 05, 2007 11:55 am
In a recent response re prepayments to vendors,the suggestion was to expense the check to Acct Payable, then apply the payment on receiving the supplies, and that does seem like a good way.
In my case, the prepayment is an estimated cost of goods, but the final price may vary. Is there a drawback to an alternative method of posting the check to a prepayment asset account, then adjusting the check when the final bill and supplies arrive, with any overpayment left in the asset account as a split on the check? Thus, the asset account continues to show remaining prepayment assets.
Either method works fine. The only trouble I've seen with using the Asset account is that people forget about it being there when they go to pay the vendor and end up paying twice.
