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!

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.

@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

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.

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!