exporting .csv file to Excel

Your dedication and perseverance in addressing your concerns are valued, CJ644CJ. I understand you have invested time and effort into finding a solution to the issue you're experiencing. I'm committed to guiding you through the remaining stages so you can save the CSV file effectively.

You'll need to enable macro settings in your Excel. Macros are essentially small software programs that operate within Microsoft Excel. They enable you to automate repetitive processes and perform intricate calculations on your data without manual intervention. By enabling this, you'll unlock the ability to streamline your workflow and enhance your productivity when working with Excel.

Here's how:

1. Go to File, then Options.
2. Choose Trust Center, then Trust Center Settings.
3. Select Macro Settings, then Disable all macros with notification.
4. Click OK twice to save the settings.
5. Close and re-launch the workbook from QuickBooks Desktop.

Finally, I want to reiterate my commitment to your success, CJ644CJ. I'm here to support you throughout this process to ensure you can save the CSV file without issues. If there's anything else I can do to assist you with export-related concerns or other QuickBooks tasks, comment below. Wishing you all the best in your future endeavors.

Are you sure you have Excel 4.0? That's a truly ancient version of Excel.

In any case, to easily create a positive pay file for your bank, you can use our BRC PositivePay file Creator - QB Desktop  It integrates with QuickBooks and appears on the QuickBooks menu. It will then create positive pay files with just a few clicks, automatically pulling your check details from your QuickBooks file (or files, as multiple files are supported).

If your bank isn't directly supported (about 160 banks are), you may be able to use its feature to define your own format, or - on request - we can probably add your bank the list after reviewing their file requirements.