Quick Search Results

    Not finding your answer?

    View More Results
    Top

    Export payroll data

    Article ID: 1000008

    Overview

    You can create a payroll data report by using the Summarize Payroll Data in Excel report option. Note that payroll data cannot be imported into QuickBooks.

    Expected Outcome

    You will have reports in Excel.

    Assumptions

    You have Microsoft Excel installed on your computer.

    Details

    Initiate Excel report from QuickBooks.

    • QuickBooks Pro and Premier: on the top menu bar, click on Reports, click Employees & Payroll, and click Summarize Payroll Data in Excel.
    • Alternatively, open the report you want to export, at the top of the report click Export, and select the desired destination and type.

    If necessary, follow the prompts to enable macros in Excel. When macros are enabled, the QuickBooks Payroll Reports Workbook window opens.

    In Excel, enter a date range, and click to clear any optional worksheets you want to exclude from the QuickBooks Payroll Reports Workbook.

    To include or exclude reports in the workbook, in the Optional Reports section, select or click to clear the appropriate checkboxes. For example, you may want to include only the payroll data you need to complete your state tax forms.

    To customize any of your workbook settings, click Options/Settings. Select or click to clear the appropriate checkboxes, and click OK.

    To retrieve the payroll data from QuickBooks, click Get QuickBooks Data. The workbook displays the data.

    2 comments

    Ceasar2/13/2013

    Need a report of tax payments by week for the years 2010 2011 & 2012 broken down.

    Reply

    Susan2/22/2013

    Hi Ceasar,

    I am an Intuit employee and saw your comment. Try this, Reports > Employees & Payroll > More Payroll Reports in Excel > Payroll Liability Accruals & Payments. I think this report will give you what you need. See Excel based payroll reports for other reports. I hope this helps. Thanks for your comment.

    Comments can not be added at this time.

    Top Answers

    Resources

    Most Used Forms

    Find and download individual and federal forms required for your business.

    Payroll Tax Support

    Stay in compliance, ensure you're up to date on all necessary tax agency information from Federal to State agency

    ViewMyPaycheck

    Give employees 24/7 access to payroll information they need.