• You've already voted on this page
Intuit Blog
|
Support
GoPayment
|
Payroll
|
QuickBooks Online
|
QuickBooks
|
Website Services
Intuit
Sign In
Register
Banking Creating & Customizing Forms Importing & Exporting Data Inventory Journal Entries & Accounting Tasks Multicurrency Vendors & Vendor Center Printing in Quickbooks QuickBooks Installation, Update, & Conversion
Customers & Customer Center Reports & Report Center QuickBooks UPS, FedEx Shipping Manager QuickBooks Online Services & Features QuickBooks File, Edit & View Menu Tasks QuickBooks Performance Issues & Program Errors QuickBooks Networking & User Setup
QuickBooks Attached Documents QuickBooks Connect QuickBooks Enterprise Solutions QuickBooks for Mac QuickBooks Online (US) QuickBooks Online Suggestions for Improvement QuickBooks Point of Sale QuickBooks Simple Start Edition QuickBooks Time and Billing Manager Cash Register Plus Customer Manager
Customer Manager & Client Manager Desktop Intuit Commissions Manager Intuit Data Protect Intuit Websites Review Websites and Get Feedback GoPayment Intuit Sync Manager New Intuit Business Tools & Resources Quickbase Quicken Turbotax
Better Because of You Considering Buying QuickBooks? Quickbooks Educational Resources QuickBooks Service/Support Policies & Procedures Classifieds
QuickBooks Payroll (Desktop) Intuit Online Payroll ViewMyPaycheck
Builders & Contractors Non-profit Real Estate Retailers Service Industries Other Industries
QuickBooks Canada QuickBooks UK Desktop QuickBooks UK Online QuickBooks Singapore Online QuickBooks en Español QuickBooks Australia
  • QuickBooks Tasks
  • Intuit Products
  • Intuit Resources
  • Intuit Payroll
  • Industries
  • International
Leaderboard
Hide Advanced Search
 
All of these words
Any of these words
This exact phrase
None of these words
In this forum
With posts written by
With posts from
to
mm/dd/yy
mm/dd/yy
Show Advanced Search
Home   Help with Intuit Products   Quickbooks Tasks   Importing & Exporting Data  
hide
05/24/2012 at 04:51PM PDT
Important Announcement! A planned system-wide upgrade will take place over the Memorial Day Weekend in the US (From Thurs, May 24, 2012 at 6 pm PDT thru Tues, May 29, 2012 at 5 am PDT). This includes QuickBooks, QuickBooks Payroll, Point of Sale, & Salesforce.com. This is only for US based products. This does not affect QuickBooks Online customers! During this time, you can shop, but can’t place orders online, activate products or update account info. We apologize for the inconvenience & thank you for patience while we improve our infrastructure to better serve you. International versions are unaffected. For more info, see our community discussion.
70
214
b9kw9Zqter4izzacwZ5xHE
Subscribe RSS
kris51
kris51
Questions asked: 1
Questions answered: 9
Points earned: 19
kris51
kris51
Questions asked: 1
Questions answered: 9
Points earned: 19
New Member
02/25/11 3:04pm PST
Viewed by asker 03/03/11 2:46pm PST

HELP!!! Posted question yesterday, did what was suggested, and now certified payroll reports are GONE!

US QuickBooks Premier : 2009: Contractor

Original question: Certified payroll reports in Excel - Quickbooks will not export info to excel
QuickBooks Premier: 2009: Contractor

Worked fine a few days ago. No Quickbooks will not export Customer:Job info to Excel. The line where it says Job name is now blank and so is the drop down menu. When I try to enter a job name, its tells me to enter a valid Customer:job name

This was the suggestion: I'd recommend Repairing QuickBooks from the Windows add/remove programs control panel and also making sure you have the latest patch, which you can start to get from the QuickBooks help menu.

 

I did that now the option for certified payroll reports is GONE

Submit a reply to this question
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
 Report Abuse
16 Replies
SKeswick
SKeswick
Questions asked: 0
Questions answered: 1311
Points earned: 3764
Intuit Superstar
Intuit Superstar
Employee who makes outstanding contributions to the community
Intuit Moderator
Intuit Moderator
Mod/Co-mod
SKeswick
SKeswick
Questions asked: 0
Questions answered: 1311
Points earned: 3764
Employee
02/25/11 3:08pm PST

Try getting the entire payroll update downloaded. Go to Employees>get Payroll updates and check the option to download the entire update then get the updates. 

Hope this helps.

If this answers your question please mark this item as solved.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
kris51
kris51
Questions asked: 1
Questions answered: 9
Points earned: 19
New Member
02/25/11 3:11pm PST

Just did that, didn't do anything, still gone.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
SKeswick
SKeswick
Questions asked: 0
Questions answered: 1311
Points earned: 3764
Employee
02/25/11 3:29pm PST

what are the items listed under  Reports>Employees & Payroll in the first section do you have  a More Payroll Reports in Excel or does it stop at Time and costs in Excel?  do you have a valid payroll subscription?

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
kris51
kris51
Questions asked: 1
Questions answered: 9
Points earned: 19
New Member
02/25/11 3:35pm PST

My subscription is valid. The reports used to be under the Employees & Payroll at the bottom listed as "New! Certified Payroll Reports" now its just gone. The last report is "Paid Time Off List" Theres no More Payroll Reports in Excel option.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
SKeswick
SKeswick
Questions asked: 0
Questions answered: 1311
Points earned: 3764
Employee
02/25/11 3:40pm PST

Look at the top of the list of reports under Employees and Payroll the first one is Summarize Payroll Data in Excel the 4th one should be More Reports in Excel with a arrow indicating more reports click on More Reports in Excel you should see the Certified payroll as the third one from the bottom on this sub menu.

 

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
kris51
kris51
Questions asked: 1
Questions answered: 9
Points earned: 19
New Member
02/25/11 3:47pm PST

Nope there's nothing about Excel anymore. The first one is Payroll Summary and the last one is Paid Time Off List. It got worse after I installed the update.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
kris51
kris51
Questions asked: 1
Questions answered: 9
Points earned: 19
New Member
02/25/11 3:48pm PST

But I never had a "More Reports in Excel" option, even when it was working

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
SKeswick
SKeswick
Questions asked: 0
Questions answered: 1311
Points earned: 3764
Employee
02/25/11 4:02pm PST

Trying to see what else can affect it.  Found an article that has a few things to try payroll.intuit.com/support/kb/1002227.html Generally a repair and getting both the QuickBooks update and payroll update rectify it.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
kris51
kris51
Questions asked: 1
Questions answered: 9
Points earned: 19
New Member
02/28/11 10:21am PST

The certified payroll option is back now. But back to square one. Quickbooks won't export info to excel.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
IntuitCustomerAdvocate
IntuitCustomerA...
Questions asked: 11
Questions answered: 9111
Points earned: 17802
Employee
03/01/11 9:14am PST

SKeswick asked me to help here.

It sure seem to me that somehow files needed to make this work are not being installed when you get payroll updates. Or, QuickBooks is unable to process those files due to some related configuration issue.

I'd try the following, in quick succession:

1. Restart your machine

2. Without starting any other applications, launch QuickBooks and get payroll updates from the Employee menu. Choose the option to rest all updates.

3. Restart QuickBooks.

 

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
kris51
kris51
Questions asked: 1
Questions answered: 9
Points earned: 19
New Member
03/01/11 10:01am PST

Thanks for your help. Still not working. Same problem, it's telling me to enter a valid Customer:Job name, but it won't let me enter anything, and theres nothing in the drop down menu.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
IntuitCustomerAdvocate
IntuitCustomerA...
Questions asked: 11
Questions answered: 9111
Points earned: 17802
Employee
03/01/11 4:46pm PST

So, you can run the report and pull data without seeing an error message, and then when you get to the slide where you need to pick (not enter) a Customer there is nothing?

Are you sure there are customers entered on paychecks dated with the date you are pulling paychecks  for?  That's the next thing to check.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
kris51
kris51
Questions asked: 1
Questions answered: 9
Points earned: 19
New Member
03/01/11 4:56pm PST

That is correct. I have entered customer info into the paychecks. Working on the same job for a year, the customer job has been entered into every paycheck for a whole year and I've been doing the certified reports for months with no problem.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
IntuitCustomerAdvocate
IntuitCustomerA...
Questions asked: 11
Questions answered: 9111
Points earned: 17802
Employee
03/02/11 8:47am PST

It sounds to me like somehow the wrong query in QuickBooks is being run.  The only cases of this I've seen are when two versions of QuickBooks are running at the same time, or when the user has an odd OS setup, such as running off a server.

Is there anything unusual about your system setup?  For example, are you using a remote system or in a managed and restricted environment?

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
kris51
kris51
Questions asked: 1
Questions answered: 9
Points earned: 19
New Member
03/03/11 2:00pm PST

No not that I know of. We are a very small business, and my computer is the only one with Quickbooks on it. We don't have a special server or anything.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
IntuitCustomerAdvocate
IntuitCustomerA...
Questions asked: 11
Questions answered: 9111
Points earned: 17802
Employee
03/08/11 2:36pm PST
Latest post

I'm not sure.  I recommend calling support for help at this point.  I think there is something generally wrong with your payroll updates, but am not sure.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
   
 
Submit a reply to this question
 
Subscribe RSS
Tags for this topic
  • quickbooks premier
  • 2009: contractor
Use commas to add multiple tags
Add tags
Latest Site Activity
Pause Feed
skip449
40 secs ago
skip449
posted
O&G ROYALTIES
TOMNORWOOD
4 mins ago
TOMNORWOOD
posted
SNAPSHOT HISTORICAL DATA
weismann9633
6 mins ago
weismann9633
posted
Sole Proprietor paid as emp...
topgunlabs
10 mins ago
topgunlabs
posted
Help, who changed the forma...
bayplant
10 mins ago
bayplant
posted
reinstalling premier on win...
Community Home Help with Intuit Products Start & Grow Your Business Help for Accountants Small Business Blog Join us on Facebook Follow us on Twitter Watch us on YouTube Meet us on LinkedIn
About Intuit | Careers | Register Your QuickBooks | QuickBooks Affiliate Program | Privacy | Legal | Contact Us | Our Hosts
© 2012 Intuit, Inc. All rights reserved. Intuit and QuickBooks are registered trademarks of Intuit, Inc.
Terms and conditions, features, support, pricing and service options subject to change without notice.
TRUSTe - Privacy Standards and Principles
Intuit Websites - Create the perfect site
Intuit Small Business
QuickBooks Accounting Software
Small Business Grants
QuickBooks Online Accounting
Intuit Payroll Services
Intuit Credit Card Processing
Intuit Business Directory
Intuit GoPayment
Intuit Small Business Education
Intuit Small Business Blog
Love a Local Business