QuickBooks Online Blocks Journal Entries With Mismatched Currencies

QuickBooks Online users with multi-currency books are hitting a new wall. Journal entries that use a currency other than the one assigned to the customer or vendor on the line are now refused at save time. The change arrived with a notice to affected users and a new report that lists the problem entries. We walked through the accepted fix; here is what it involves.

The rule QuickBooks Online now enforces

Multi-currency accounting in QuickBooks Online follows one fixed rule. Every transaction booked to a customer or vendor must use the currency you assigned to that name. Journal entries are not exempt. When an entry touches receivables or payables, three things must agree: the entry’s currency, the receivable or payable account, and the customer or vendor named on the line.

Entries that break the rule do quiet damage. They can leave open balances that are overstated or understated. They can also push wrong amounts into realized exchange gains and losses. The block exists to stop that damage at the source. Existing entries are not deleted or rewritten; they simply sit on the new report until you correct them.

Where do you find the entries that fail?

A report called Invalid Journal Transactions does the hunting. Open the Reports menu and look inside the standard reports grouped for accountant use. The report only appears when your file actually contains mismatched entries, so its absence is good news.

By default it covers the current fiscal year. Problems from earlier years stay hidden until you switch the date range to all dates. If your books go back a while, run that wider view once before assuming you are clear. The goal is simple: once every entry is corrected, the report comes back empty.

If an outside accountant reviews your books, the report doubles as a ready-made work list. Hand it over as printed output rather than re-keying the findings into a message.

How do you fix an entry that fails?

Work one entry at a time, and keep a copy before you change anything. Open the entry directly from the report. At the lower right of the screen, choose More, then Transaction Journal. A detailed view of the posting opens.

That view needs some setup before it tells the whole story. Click the gear icon at the top right, select the option to show more, and tick the boxes for customer, vendor, exchange rate, foreign amounts, and card credits. Add any other columns you find useful. Then export the sheet to Excel or print it.

The export is your safety record of the original posting. Use it to rebuild the entry so each line carries the currency assigned to the name on it. The corrected entry replaces the faulty one, and the report shrinks by one.

After the report runs clean

An empty report is the finish line. Balances and exchange results then rest on entries that follow the currency rule, which is the point of the exercise. Run the report again after each correction if you want the reassurance.

The habit matters more than the cleanup. Assign each customer and vendor one currency, then post every transaction in it, journals included. New mismatched entries will be refused anyway, so matching the currency up front simply saves you the rework.

One caution on scope: this enforcement applies to QuickBooks Online, and to journal entries that name a customer or vendor. Ordinary foreign-currency transactions posted the usual way are not part of the sweep.