Manual Exchange Rates in QuickBooks Desktop After the Rate Service Ends
When a discontinued QuickBooks Desktop stops downloading exchange rates, unrealized gains quietly go stale; here is how to keep them accurate.
Multi-currency is the part of QuickBooks Desktop that leans hardest on a live connection. When the online rate download stops, nothing crashes and no warning appears. Instead, every foreign-currency balance quietly ages, and the unrealized gain or loss line drifts away from reality. The remedy is a disciplined manual rate routine, and it takes minutes a month.
What breaks when the download stops?
Desktop fetches its rates from an online service run by the vendor whenever a refresh is requested. A version past its service date is refused, so the refresh either errors out or repeats the last rate it ever received. New transactions inherit that frozen number. Realized gains and losses on payments are computed from stored rates too. Nothing in the program tells you the data is stale, so the drift compounds silently until an accountant asks why the balance sheet moved.
Choosing a rate source you can defend
Start with your bank. The rate your bank actually applies is the one that matches the money, and most banks publish a daily rate you can cite. If a bank rate is out of reach, pick a public reference and stay with it: the European Central Bank reference rates, the Federal Reserve's H.10 release, or the Bank of Canada daily rates all work. The source matters less than consistency. Mixing a card rate one month and a mid-market rate the next creates month-to-month swings that mean nothing economically.
Updating the currency list by hand
Open the Lists menu and choose Currencies. Select the currency and edit it. Ignore the option that fetches the latest rate, because it cannot reach anything now. Type the new rate, confirm the date, and save.
The list rate feeds new transactions only. Existing transactions keep the rate they were entered with, and that is correct behavior: history should not move when the list changes. When a statement or card slip shows the exact rate your bank used, put that number on the transaction itself. Bills, invoices, and payments each carry their own exchange rate field, and a transaction-level entry overrides the list.
Which way round does the rate go?
This is where manual entry goes wrong most often. Desktop expresses the rate in one specific direction, and the convention differs between editions and home currency settings. The edit window labels the field, so read that label before typing. Then prove it to yourself. Enter a one-line transaction for a small amount, check the home currency value it produces, and delete the test. An inverted rate looks plausible on screen and is not a small error: a true rate of 1.25 typed as 0.80 shifts the recorded value by more than half. Our engineers do this sanity check once per currency and note the convention in the rate log.
How often should you refresh?
Refresh the list the same day you enter foreign-currency transactions, and refresh it again immediately before any valuation. At minimum, do it monthly before the close. Payments deserve the same care, since realized results come from the gap between the invoice-date rate and the payment-date rate. Invoicing foreign customers with a months-old rate also sends numbers on the invoice that no longer match anything.
Running the home currency adjustment
Under the Company menu, choose Manage Currency and then Home Currency Adjustment. Set the as-of date, select the accounts to revalue, typically banks, accounts receivable, and accounts payable, and review the proposed journal entries before posting. They land in the unrealized gain and loss accounts that were created when multi-currency was switched on. The adjustment is only as honest as the rate stored that day, so refresh first, adjust second. This step belongs in your month-end close routine, not in an occasional cleanup.
Keep a simple rate log alongside the file: one row per update with the date, currency, rate, and source. It turns a questioned figure into a two-minute answer.
Can multi-currency ever be switched back off?
No. Once the feature is enabled, Desktop has no setting to disable it, which is why rate hygiene matters for the life of the file. If the business no longer needs foreign currency at all, removal is a file-level job rather than a preference, and our QuickBooks multi-currency removal service handles that. For everyone else, the routine above keeps the books defensible for as long as the install keeps running.