Huge Savings
Get our price list!
Buy with Confidence
from a Premier Intuit Reseller
Free Shipping
Direct from Intuit
No Sales Tax
(in some states)
Try it free for 30 days

Monthly Archives: April 2010

How to Import Payroll into QuickBooks

A customer of mine is trying to import an Excel spreadsheet to QuickBooks, with payroll information coming from ADP.  Are you familiar with importing Payroll Excel spreadsheets to QuickBooks?  The only problem I'm having is the mapping… It seems that we can only map customer, inventory information… but, no payroll… Let me know what you think!
You can’t use the payroll module in QuickBooks unless you have a subscription, and even if you did, you can’t import paychecks because QuickBooks SDK doesn’t support it.  This is why most people using QuickBooks also use it for payroll as well, instead of an outside service like ADP or Paychex. 

You could try to import them as regular checks, though.  Here are two add-ons that might help.

IIF Transaction Creator for QuickBooks
Transaction Pro Importer


Get free QuickBooks support and training!
LinkedIn   Google+   FaceBook

This article is provided for informational purposes and is not intended to be construed as legal, accounting, or other professional advice. For further information, please consult appropriate professional advice from your attorney and certified public accountant.

Ruth Perryman - QuickBooks Specialist Written by +Ruth Perryman

Ruth is the an Intuit Premier Reseller that offers great deals on QuickBooks POS and QuickBooks Enterprise. She has provided expert QuickBooks help to thousands of businesses all over the world since 1996.

Visit our webstore for great deals on QuickBooks and QuickBooks POS!

How to Enter Different Billing and Pay Rates for Subcontractors in QuickBooks

I have sub-contractors that are paid an hourly rate. I charge a small premium over that rate to my clients. What is the best way to book this? Do I enter my vendors time in QuickBooks? Do I just enter their invoice as a bill? If I enter time, how do I indicate a different rate on my invoice, from what I am paying the sub-contractor?
Timecard information can be fed into both invoices and bills. 

  1. Make sure your service items are double-sided.  If not, click the box next to This service is used in assemblies… and enter both an expense and income account as well as a cost and sales price.
  2. Enter your subcontractors' time on timesheets at either Customers > Enter Time or Employees > Enter Time
  3. When creating an invoice in Pro, click the Add Time/Costs button to add timesheet data to the invoice.  Premier and Enterprise also have an Invoice for Time & Expenses option. 
  4. When creating a bill, check or credit card charge, if there is time data for the vendor you'll get a popup asking if the payment is for time.  Select Yes and the appropriate dates.

You might need to adjust some of your preferences to do the above.  For instance, you'll need to select Yes under Do you track time? in Edit > Preferences > Time & Expenses > Company Preferences if you haven't already.

One last consideration.  If you have subcontractors with different cost and sales prices, you might want to add separate sub-items for each set of prices.  Otherwise, you'll sometimes have to change the default information that feeds into your invoices and/or bills. 

There is a billing level rate feature in Premier and Enterprise Contractors, Professional Services, and Accountants editions which will let you apply different billing rates for the same service item but it only works on sales transactions (invoices, sales receipts).  It doesn't work on purchase transactions (bills, checks, credit card charges).


Get free QuickBooks support and training!
LinkedIn   Google+   FaceBook

This article is provided for informational purposes and is not intended to be construed as legal, accounting, or other professional advice. For further information, please consult appropriate professional advice from your attorney and certified public accountant.

Ruth Perryman - QuickBooks Specialist Written by +Ruth Perryman

Ruth is the an Intuit Premier Reseller that offers great deals on QuickBooks POS and QuickBooks Enterprise. She has provided expert QuickBooks help to thousands of businesses all over the world since 1996.

Visit our webstore for great deals on QuickBooks and QuickBooks POS!

News Flash – Free Trial Membership to Join a Community of QuickBooks Experts

I’ve been a member of The Sleeter Group for several years and it’s been an invaluable resource.  I couldn’t live without their yahoogroup experts forum, where I not only get almost immediate answers to the toughest QuickBooks questions but also have formed incredible friendships with many of the other top ProAdvisors in the country.

Because of huge impact they’ve had on me and my business, I’m more than happy to let everyone know about their latest free trial membership offer.  Now is the time to check them out!

FREE Trial Membership

Try out the Sleeter Group Consultants Network free for 45 days. Here’s what you’ll receive to get a sneak peek into what membership is all about:

    • Read-only access to their Experts Forum, powered by Yahoo! Groups
    • PDF Download of three chapters from the QuickBooks Consultant’s Reference  Guide, the must-have resource for small business accounting consultants
    • Eligibility to participate in their monthly members’ Web conference
    • SGCN News, their monthly e-newsletter
    • Subscription to The Desktop Accountant monthly e-newsletter
    • Join by May 31 and get $50 off your membership fee! Use promo code APR50

Simply phone their office at 888.484.5484 or 925.416.6300 to get started today. This offer is good for new trial memberships beginning between April 22 and May 31, 2010. Previous members are not eligible.


Get free QuickBooks support and training!
LinkedIn   Google+   FaceBook

This article is provided for informational purposes and is not intended to be construed as legal, accounting, or other professional advice. For further information, please consult appropriate professional advice from your attorney and certified public accountant.

Ruth Perryman - QuickBooks Specialist Written by +Ruth Perryman

Ruth is the an Intuit Premier Reseller that offers great deals on QuickBooks POS and QuickBooks Enterprise. She has provided expert QuickBooks help to thousands of businesses all over the world since 1996.

Visit our webstore for great deals on QuickBooks and QuickBooks POS!

News Flash – Error -6094, 0 when opening QuickBooks after downloading an update for AVG Anti-Virus software

This just in from Intuit- AVG virus software update is interfering with QuickBooks 2009. If you are getting Error -6094,0 when opening QuickBooks after downloading an update for AVG, here are the steps for fixing the problem:

 
What is Happening?

After an update has been downloaded for AVG Anti-Virus, the following error message occurs when trying to open QuickBooks:
An error occurred when QuickBooks tried to start the database server that manages access to the QuickBooks company file. Error (-6094,0)

What You Need To Do

  1. Update AVG to the latest virus definition
    Signature file 271.1.1/2832 (AVG v9.0.814) – this update was just released to correct the issue where AVG unnecessarily detects QuickBooks as infected with a virus
  2. Restore QuickBooks files that were quarantined by the anti-virus.
    ORRepair the QuickBooks installation.

Detailed Instructions

Follow these instructions to update AVG to the latest virus definition:

  1. Open the AVG Anti-Virus User Interface
  2. Click on the Update now button on the left part of the AVG user interface
    or
  3. From the Tools menu, select Update

Important: Always make sure to download the latest virus updates so that you are always protected

Restore any QuickBooks files that are in the vault :

  1. Open AVG Anti-Virus User Interface
  2. Click History from the top menu bar and select Virus Vault
  3. Locate any QuickBooks files and select one file at a time
    • Possible files include: qbw32.exe, qbdbmgr.exe, qbdbmgrn.exe
  4. Click Restore located at the bottom of the window
  5. Once finished restoring all QuickBooks files, click Close
  6. Close AVG Anti-Virus User Interface

If you are still unable to open QuickBooks, or if there were no QuickBooks files in the Virus Vault, you may need to repair the QuickBooks installation.
Click the link below for steps on repairing QuickBooks:
http://support.quickbooks.intuit.com/support/pages/knowledgebasearticle/363372

Repairing QuickBooks does not affect company data files (.QBW). The data stored in these files will remain intact.


Get free QuickBooks support and training!
LinkedIn   Google+   FaceBook

This article is provided for informational purposes and is not intended to be construed as legal, accounting, or other professional advice. For further information, please consult appropriate professional advice from your attorney and certified public accountant.

Ruth Perryman - QuickBooks Specialist Written by +Ruth Perryman

Ruth is the an Intuit Premier Reseller that offers great deals on QuickBooks POS and QuickBooks Enterprise. She has provided expert QuickBooks help to thousands of businesses all over the world since 1996.

Visit our webstore for great deals on QuickBooks and QuickBooks POS!