Exporting a report to CSV in csv shows the currency split in two columns instead as one figure in one column. How do i fix this?

Welcome to the QuickBooks Community, Steve213. I will be delighted to help you here! To better assist you, could you provide the report you're trying to export. In the meantime, once the column Currency is added to a report when exporting, it will appear as two separate columns. However, you can make changes for it to appear in one column using a text editor such as Notepad. Here is how:

1. Once you have created the CSV file and click Export.
2. Add your file name and select Save.
3. Open your Notepad app and select File.
4. In the File drop-down, choose Open.. and change the file extension to All Files.
5. Locate your document and select Open.
6. Once Notepad opens, remove the comma between the figure(amount) and the quotation marks around the currency, as seen below between the two highlighted examples.
7. Once making those changes, save the document. If you receive a prompt asking to replace the existing CSV file, select Yes unless you prefer to create a new text document.
8. Go to Excel and select Open. On that page, select Browse to search for the document. (You may need to change your extension to Text Files to locate it)
9. Select the document and click Open.
10. Once the file opens, you will see your amount and currency in the same column.

Please let me know if you have any questions or need a bit more clarification. Simply comment below, and my team and I will be available to assist you. You can refer to this article to learn more about CSV files when exporting and importing. I hope you enjoy the rest of your day. Take care.

Sasha, Thank you very much. I attach a report. The amount at 25 Feb 2020 should be reflected as 17936.46 in a single column. The 46 in the column Open balance is incorrect and belongs in the column Amount.  

Please assist. Regards Steve 213

Dear SashaMC

Thank you for the response.  I attach a report to illustrate my problem. I highlighted the item. The amount 17936 against the date 25 Feb 2020 should be 17936.46.  However the 46 appears in the column Open balance instead of in Amount. Please assist.

Steve213

Hi @Steve213,

I appreciate you for sharing the result. Let me help you fix the issue with the report in QuickBooks Desktop.

We can perform some basic troubleshooting to isolate and fix the issue. Let's first open a sample company file to run and export a similar report.

Here's how:

1. Open QuickBooks Desktop.
2. From the No Company Open screen, select Open a sample file. 
3. Once the company file is opened, try to run and export the same report.
4. Check the result.

If you're getting the same output, I recommend you proceed with updating QuickBooks to the latest release. Please follow these steps:

1. Open QuickBooks Desktop.
2. Click the Help tab at the top menu.
3. Select Update QuickBooks Desktop.
4. Go to the Update Now tab.
5. Put a checkmark on the box beside Reset Update.
6. Hit Get Updates. 

Also, you can run the Verify and Rebuild Data utility in the system. The tool scan data issues within the company file and self-resolves them.

To verify data:

1. Open the company file.
2. Click the File tab at the top menu.
3. Select Utilities.
4. Choose Verify Data.

For rebuild data:

1. Open the company file.
2. Click the File tab at the top menu.
3. Select Utilities.
4. Choose Rebuild Data.

For additional reference, I've attached a link you can use about how to run the QuickBooks Tool Hub: Fix common problems and errors with the QuickBooks Desktop Tool Hub.

Fill me in if you have additional questions about exporting the reports in QuickBooks. I'm always here to help. Take care always.

Hi AlcaeusF

Thank you for the advice. The sample report has the same problem. I re-run all updates. Verify and rebuilt data. the problem remains.  It is a fairly recent problem that for the first time started occurring some time between Oct 2020 and Dec 2020.

Regards

Thanks for keeping us updated how the troubleshooting went through, Steve213.

I read all the responses in this thread and it looks like all of the possible troubleshooting steps and relevant articles have already been shared. You also mentioned that you used the Verify and Rebuild Data Utility Too to no avail. 

In this case, I would recommend reaching out to our Technical Support Team. They can take a look at report and the exported file to check why it's giving you two separate columns for currency. Here's how:

1. Go to the Help menu, then select QuickBooks Desktop Help.
2. Select Contact Us.
3. Give a brief description of your issue, then select Let's talk and choose a way to connect.

You can also go to this link to reach out to them outside of QuickBooks: https://quickbooks.intuit.com/learn-support/en-us/contact.

Support for QuickBooks Pro and Premier are open from Monday to Friday, in between 6 AM to 6 PM Pacific. 

Lastly, you can check out this link for additional reference when preparing your year-end tasks: QuickBooks Desktop Year End Prep and Resources.

Don't hesitate to reach out to us again if you need anything else. 

JenoP' I have resolved the issue.  The decimal separator for the Currency setting for some reason changed to a comma from a point.   Probably with an update of Windows or QB. I went to Windows, Control panel, Clock and Region Additional and finally to the Currency setting and changed it to a point instead of a comma.  The decimal comma separator in Currency caused the report, after the comma of the separator, to become an additional column. 

Thank you for all the help and assistance.