How can I remove the local currency from appearing in the foreign currency column

Hello, Aisha6.

You can export the report and manually remove the local currency in the Foreign Currency column. I'll gladly guide you on how to do this below.

Any report that show multicurrency transactions will include both local and foreign currencies. You'll have to manually remove the local currency transactions when exporting the financial report you've pulled up to get the data you need. To do this, here's how:

1. Go to Business overview and select Reports.
2. Use the Find report by name search bar to search for reports by name.
3. Select the report to open it.
4. Customise the report if necessary.
5. Select the Export icon, then choose Export to Excel.

Additionally, you can send memorised reports by email on a recurring schedule. Feel free to read this article to learn how: Set schedule and email information for a memorised report.

If there's anything else you need or you have other reporting concerns or questions about managing currencies in QBO, I'm always ready to help. Take care, and I wish you continued success.

Thank you so much for your reply! I will try this