Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowWe 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?
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.
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!
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.