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

CSV file export for payroll

We use direct deposit for our employees paychecks.  The bank requires it own Excel format which includes "Last Name" and "First Name".  When I run the payroll report in csv format the report looks like any other Excel report and the employee names are in one column - example: lastname,firstname.  How do I get and ACTUAL csv comma delimited file so that we can manipulate the data?

2 Comments 2
JonpriL
Moderator

CSV file export for payroll

Hello @cplessel,

 

You can create a new worksheet as the destination of your payroll report before saving it as a new CSV file. Let me show you how.

  1. Go to Reports.
  2. Select Employees & Payroll.
  3. Click any payroll report you wanted to export. Say the Employee Contact List report.
  4. Under Excel, select Create New Worksheet.
  5. Select in a new workbook.
  6. Click Export.

From here, you can start manipulation the report data by removing any columns or whatnot. Then, manually save it making sure to select the Comma Delimited option as the file saving type.

 

Additionally, I've got you this helpful article for the steps in saving the customize settings of a report you pulled up: Create, access, and modify memorized reports.

 

If you have any other questions aside from generating an excel file of your report, please let me know in the comments. Stay safe!

BigRedConsulting
Community Champion

CSV file export for payroll

I don't think you can create the report you need from QuickBooks.  Not sure how, anyway.

 

If your bank will accept a NACHA / ACH file, you can use our BRC Direct Deposit File Creator  to create DD orders from your paychecks and to send to your bank.

Need to get in touch?

Contact us