cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
sheidari81
Level 1

QuickBooks Desktop Export Payroll data in flat-file format (i.e. csv)

Hi everyone,

 

A client sent us their payroll data to analyze but it's structured in report form and will require a lot of cleaning up to make it usable.  I'm looking for the data in flat-file format. See attached images.

 

Before we embark on cleaning the data, wondering if QuickBooks Desktop has a feature to do this through an export?

 

Thanks!

 

5 Comments 5
sheidari81
Level 1

QuickBooks Desktop Export Payroll data in flat-file format (i.e. csv)

Here's the flat file image attached to show what i'm looking for. 

 

Thanks!

Nick K
QuickBooks Team

QuickBooks Desktop Export Payroll data in flat-file format (i.e. csv)

Hey sheidari81.

 

Exporting files from QuickBooks is a quick way of sharing information with others. QuickBooks Desktop can export .CSV files, which will show you the payroll data like the screenshots you've provided. I can help walk you through how to export payroll data into a .CSV file.

 

The best way to get your clients payroll data would be to run a Payroll Summary Report by going to Reports>Employees & Payroll>Payroll Summary. Once the report is pulled, it's as simple as following these steps to export it to .CSV:

1. Select the Excel drop-down at the top of the report.
2. Select Create New Worksheet.
3. On the Send Report to Excel window, select Create a comma separated values (.csv) file.
4. Select Export.
5. Assign a file name, then choose the location where you want to save the file.

 

Once that's done, your client will need to send you the .CSV file and you can go over it at your leisure.

 

Hope that helped.

Fiat Lux - ASIA
Level 15

QuickBooks Desktop Export Payroll data in flat-file format (i.e. csv)

@sheidari81 

You may utilize a 3rd party exporter tool to get a Time Tracking data from QB Desktop.

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

The output should be like this

NameTransaction DateCustomerService ItemPayroll itemDurationClassBillableNotes
John Marks01/09/2020Nguyen, TuanLaborRegular Pay1:25   
John Smith02/09/2020Nguyen, TuanLaborRegular Pay2:00   
Karen Marks02/09/2020Links, JohnLaborRegular Pay1:25   

 

Out4Justice
Level 2

QuickBooks Desktop Export Payroll data in flat-file format (i.e. csv)

None of the data lines up and the way it is formatted is unusable. It absolutely is useless. You can't even use a pivot table on this crap.

Trish_T
QuickBooks Team

QuickBooks Desktop Export Payroll data in flat-file format (i.e. csv)

Hi Out4Justice,

 

Thanks for joining us here.  In addition to the valuable information provided above by 
Nick K,  I recommend taking a look at this helpful guide for importing and exporting CSV files in QuickBooks Desktop.  

 

If you require additional assistance, please don't hesitate to contact us.  It would be our pleasure to work with you directly and ensure you're back to business as soon as possible.

 

Feel free to reach back out if you have other questions.  We'd love to help!

Need to get in touch?

Contact us