Removing Multi-Currency From a QuickBooks Desktop Company File

Once multi-currency is switched on, QuickBooks Desktop has no setting to turn it off; we explain why and lay out the routes to a single-currency file.

Multi-currency in QuickBooks Desktop is a one-way preference. Once it is switched on, no checkbox in the program switches it back off, and the setting stays with the company file for life. This page explains why the lock exists and walks through the two routes that genuinely end in a single-currency file.

Why is there no off switch?

Enabling the feature does far more than set a flag. QuickBooks assigns a currency to every customer, vendor, bank account, credit card account, and receivable or payable account. It creates an Exchange Gain or Loss account for revaluation, and it changes how every historical balance is stored.

Because those currency assignments sit inside posted transactions, Intuit made the preference permanent by design. Reversing it would orphan recorded amounts and break links across the ledger, so the program offers no way back. The vendor's position is that a file with multi-currency enabled keeps it enabled.

Before you choose either route

Both routes reach into the file at a level where mistakes are costly, so prepare once, up front. Make a full backup with a .QBB extension, not a copy of the open file, and prove it restores before anything else. Log in as admin and work in single-user mode for any operation inside the file.

Then save reference reports as of a cutover date you choose: a trial balance, A/R and A/P aging summaries, and an inventory valuation. Finish any reconciliation in progress before that date. These reports are how you will prove the end result ties.

What if the feature was never actually used?

Many files carry the setting after someone clicked through preferences once, with no foreign-currency account or transaction ever created. Nothing in the ledger depends on it in that case. The flag still blocks list merges and some conversions, so removing it remains worthwhile. It is also the simplest removal case, because there are no foreign balances to convert.

Route one: start a fresh single-currency file

  1. In the old file, export your lists: File > Utilities > Export > Lists to IIF Files. Select the chart of accounts, customers, vendors, and items.
  2. Open each IIF file in a spreadsheet and remove any currency column. Drop accounts and names that exist only in a foreign currency, because a single-currency file cannot hold them.
  3. Create the new company file with the same home currency as the old one. The home currency is also locked once chosen. Leave the multi-currency preference off.
  4. Import the cleaned lists, then compare name counts against the old file.
  5. Post opening balances as of the cutover date from your saved trial balance. For A/R and A/P, choose between one summary journal entry and opening invoices and bills per name, which preserves aging detail.
  6. Set the old file aside, read-only, for history.

The cost of this route is the history. Comparative reports that span the cutover, and reconciliation history, live in the old file only. Expect to open both files through the first year-end after the switch.

Route two: keep the history, lose the setting

The second route is a conversion. Our engineers rebuild the company file with the setting off and the transaction history intact; this is what the QuickBooks multi-currency removal service does.

Home-currency amounts already posted to the ledger stay exactly as recorded. What disappears is the foreign-currency layer: original foreign amounts, exchange rates, and the revaluation adjustments tied to them. Customers and vendors that traded abroad keep their history, expressed in home currency only.

The work starts from a backup of the file together with the admin password, and the file is evaluated before any conversion is quoted. A dormant setting is a quick job. Years of genuine foreign-currency activity take longer and deserve a close read of the revaluation history first.

How do you know it worked?

Open Edit > Preferences > Multiple Currencies and check the Company Preferences tab. The setting should read No, and the warning that it cannot be changed should be gone. Create a test customer and a test vendor; no currency field should appear on either. Run a trial balance and a balance sheet, tie the totals to your reference reports, then run Verify under File > Utilities and expect a clean result.

On the fresh-file route, add one more check: the A/R and A/P aging totals as of the cutover should match the old file to the cent.

When is removal the wrong answer?

Do not strip the setting if you still invoice or pay in a foreign currency. A single-currency file cannot hold foreign-currency receivables or payables, so removal would trade one problem for a worse one. Removal also fixes nothing else. Data damage, a balance sheet that will not tie, and file bloat are separate conditions, and the flag coming off leaves them untouched. If size is the real worry, see our engineers' notes on condensing an oversized QuickBooks Desktop company file before you convert anything. Clear those problems first, or they travel with you into the converted file.

Keep going

Your Desktop doesn’t have to end when Intuit says so.

Start with the master survival guide, or jump straight to the fix you need.