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?
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.
- Go to Reports.
- Select Employees & Payroll.
- Click any payroll report you wanted to export. Say the Employee Contact List report.
- Under Excel, select Create New Worksheet.
- Select in a new workbook.
- 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!