Removing Multi-Currency from a QuickBooks Desktop Company File
Multi-currency prevents file merges and some conversions; discover how to restore a clean file that retains historical foreign-currency balances.
When a QuickBooks Desktop file has multi-currency enabled it cannot be disabled through the user interface. This setting blocks certain operations such as file merges, specific conversions and some third‑party integrations. The playbook below shows how to rebuild the file so that multi-currency is removed while preserving the original foreign‑currency balances and exchange rates for historical reporting.
Preparing the File
First make a verified portable copy of the company file. Use the File → Utilities → Create Portable Company File command and store the resulting .qbm file in a secure folder. Run Verify Data on the portable copy; if any issues appear, run Rebuild Data and repeat Verify until the file reports no errors. Keep the original .qbw file untouched as a fallback.
Next, gather the foreign‑currency information you will need later. Open the Currency List (Lists → Currency List) and note each active currency, its exchange rate as of the file’s closing date, and the total balance stored in each currency for accounts such as bank, accounts receivable and accounts payable. Write these values down or export them to a spreadsheet for reference.
Creating a Clean Copy
Create a new, blank company file that matches the version and edition of the original. During the New Company interview, answer “No” to the multi‑currency question so the new file starts with the feature disabled.
Import the core lists from the verified portable copy into the new file. Use File → Utilities → Import → Excel Files for the Chart of Accounts, Customers, Vendors, Items and Employees. For each list, choose “Add or update existing items” and map the fields carefully to avoid duplicates. After importing each list, run Verify Data to confirm the import succeeded without corruption.
Now import the transaction data. Export the transaction history from the portable copy as an IIF file (File → Utilities → Export → IIF Files). In the new file, use File → Utilities → Import → IIF Files and select the exported IIF. During the import, map the currency columns to the corresponding amount fields; the new file will store amounts in its home currency only. After the import completes, run Verify Data again.
Verifying Foreign-Currency Balances
To confirm that the historical foreign‑currency values are preserved, run the Balance Sheet report for a date prior to the multi‑currency activation. Change the report display to show amounts in the foreign currency by customizing the report and selecting the appropriate currency from the Display drop‑down. Compare the totals for each currency with the notes taken in the preparation phase.
Run the same check for Profit & Loss, Accounts Receivable Aging and Accounts Payable Aging reports. If any discrepancy appears, revisit the IIF import step and ensure that the exchange‑rate rows were correctly mapped. Adjust the IIF file if necessary and re‑import the affected transactions.
Final Checks and Rollback
Once the reports match the original foreign‑currency totals, run a full Verify Data on the new file. If Verify passes, run Rebuild Data as a precaution and then Verify again.
At this point the file is ready for use. Keep the original .qbw and the portable copy in a secure archive for at least thirty days. If any issue arises after going live, you can revert to the original file and repeat the process with adjusted mapping.
Expected Outcome
After completing the steps above you will have a QuickBooks Desktop company file that:
- No longer has multi‑currency enabled (the setting is greyed out and cannot be turned on).
- Retains all historical transactions, posted in the home currency with values that reflect the original foreign‑currency amounts and exchange rates.
- Passes Verify and Rebuild without errors.
- Can be merged with other files or converted to other editions without the multi‑currency block.
The resulting file supports normal day‑to‑day operations while providing clean data for mergers, conversions or third‑party integrations that require the feature to be disabled.
See our <a href="https://e-tech.ca/Quickbooks-Multi-Currency-Removal-Service.aspx\">QuickBooks multi-currency removal service for a guided approach to this procedure.