QuickBooks Home Currency Adjustment for Stripe Balances

It is September 30. Your Stripe account holds €5,000 in a euro balance waiting for its next payout, and QuickBooks says that balance is worth $5,400. The euro closed the month at 1.1100 dollars, so the same €5,000 is worth $5,550 today. Your balance sheet is $150 light, nothing in your reconciliation flags it, and it will stay that way until somebody runs a QuickBooks home currency adjustment.

That $150 is not a sync error and it is not the transaction-level exchange rate gap most multicurrency advice is about. It is a period-end event. QuickBooks recorded each euro at the rate on the day it arrived, which is correct, and then never looked at the balance again, which is also how it is designed to work. Revaluing that balance is a separate step, and a Stripe sync has nothing to post for it, because nothing happens in Stripe when an exchange rate moves.

This post covers what the adjustment does, which accounts it touches, why a Stripe clearing account gets a real journal entry while your open invoices only get a report-level number, and what the file looks like if nobody ever runs it. If you want the Stripe side of a multicurrency setup recorded in the right currency to begin with, start a free trial.

What is a QuickBooks home currency adjustment?

A home currency adjustment restates the home-currency value of a foreign-currency balance at a new exchange rate. Intuit describes it as changing "the home currency value of your foreign balances, recalculating them based on a new rate." The foreign amount does not change. Only its value in your home currency does, and the difference is posted as an exchange gain or loss.

In QuickBooks Online the feature is called Revalue Currency, and it only exists if Multicurrency is turned on. Intuit lists three conditions: you are on Essentials, Plus or Advanced, Multicurrency is enabled, and the books for the period are not closed. Simple Start does not have Multicurrency at all, so it has nothing to revalue.

It helps to be precise about which accounts can carry a foreign balance in the first place. Intuit says you can assign a currency to "most types of accounts including customers, vendors, and accounts in the chart of accounts (like bank and credit card accounts or accounts receivable)." Income and expense accounts are always in your home currency. And once an account has a transaction posted to it, its currency cannot be changed.

So a revaluation only ever touches balance sheet accounts that hold something other than your home currency. Your revenue is never restated. What gets restated is the cash, the receivables and the payables sitting in foreign currency on the day you pick.

When a Stripe balance ends up in a foreign-currency QuickBooks account

Most Stripe accounts never create this problem. By default, Stripe converts all incoming funds into your default currency. A US business selling in euros on a single USD balance has a USD clearing account in QuickBooks, and a USD account has nothing to revalue. The rate gap on each sale is real, but it is a transaction-level gap, and our guide to Stripe multicurrency in QuickBooks covers how to book it.

The period-end problem starts when you hold the foreign currency itself. Stripe's multi-currency settlement lets an account "accrue balances and get paid out in up to 18 supported currencies," with a separate bank account for each settlement currency. Once euros stay euros inside Stripe, the sensible QuickBooks mirror is a euro-denominated clearing account for that balance and a euro-denominated bank account for its payouts.

A euro clearing account holds a balance at month end more often than people expect. Three ordinary reasons:

1. Funds still in transit. Charges from the last few days of the month are usually still pending rather than available, so they have not paid out yet.
2. The minimum payout amount. Stripe states that "you can't pay out until your balance for the currency meets the minimum payout amount." A small secondary currency can sit for weeks.
3. Balances you keep on purpose. Stripe pitches multi-currency settlement as a way to "pay suppliers, process refunds, and avoid FX fees." A balance held for those reasons is a balance still there on the 30th.

Each of those euros came into QuickBooks at the exchange rate on the day its transaction was recorded. A month of sales means a month of different rates, blended into one home-currency figure that matches no rate that ever existed.

Why a Stripe clearing account gets a realized gain, not an unrealized one

This is the detail that decides which line of your reports moves, and it is the one most explanations skip.

Intuit's own framing: the effect of a home currency adjustment "can be seen in accounts payable or accounts receivable as an unrealized gain or loss," and "in other account types, like bank accounts, as a realized gain or loss."

In practice those two outcomes look very different in your file.

For A/R and A/P, the journal entry is zero. Intuit's FAQ explains that when you revalue, QuickBooks creates entries showing no gain or loss for accounts receivable or accounts payable. The unrealized gain or loss is calculated per open transaction and shows up in your reports: Profit and Loss, Balance Sheet, customer and vendor balance detail, and cash flow. Click the amount on a report and QuickBooks lists each open invoice or bill with "the date and rate used to revalue the foreign currency" and its own unrealized figure. Intuit adds that reports have to be run after revaluing to be accurate.

For a bank-type account, the journal entry has a real amount. The FAQ says the non-zero amounts on these entries are realized gains or losses from bank or credit card adjustments. The account's home-currency balance changes, and the offset lands in Exchange Gain or Loss, the account QuickBooks sets up when you turn Multicurrency on. QuickBooks sets it up as an Other Expense account, so it reports below operating income rather than inside your gross margin.

A euro Stripe clearing account is not A/R and not A/P. It behaves like the bank account it stands in for, which means revaluing it posts a real entry. Here is the September example:

Account	Debit (USD)	Credit (USD)	EUR amount
Stripe Clearing (EUR)	150.00		0.00
Exchange Gain or Loss		150.00

Before: €5,000.00 carried at $5,400.00. After: €5,000.00 carried at $5,550.00, which is €5,000 at 1.1100. The euro side of the account is untouched, and your balance sheet now states the cash at what it was worth on the balance sheet date.

The labels are Intuit's, and they are worth squaring with your accountant. In ordinary accounting language, a gain on cash you still hold has not been realized yet. QuickBooks calls it realized because it posts it to the ledger rather than holding it as a report-level figure. The name does not change the entry. It just tells you where to look for it.

What happens if you never run it

Nothing breaks, which is the problem. Every individual transaction is right. The clearing account still reconciles in euros. The error lives only in the home-currency column, and it compounds quietly.

Follow the September balance one more step without a revaluation.

On October 2 the €5,000 pays out to your euro bank account. The transfer between two euro accounts carries its own exchange rate, say 1.1050, so $5,525.00 of home-currency value leaves the clearing account. The clearing account had been carrying $5,400.00.

Stripe Clearing (EUR)	EUR	USD
Balance, September 30 (not revalued)	5,000.00	5,400.00
Payout transfer, October 2 at 1.1050	(5,000.00)	(5,525.00)
Balance after payout	0.00	(125.00)

The clearing account now holds zero euros and minus $125. That is the symptom people eventually find: a Stripe clearing account that reconciles to zero in its own currency and still shows a balance on the home-currency balance sheet. It looks like a missing transaction. It is actually the missed rate movement on money that has already left.

Had September been revalued, the same payout would have left $25.00 behind (the $5,550.00 revalued balance minus the $5,525.00 transfer), and October's revaluation would clear that too. A euro balance of zero is worth zero dollars at any rate, so revaluing an emptied account always takes its home-currency balance back to zero.

Now multiply that by twelve months, a second currency, and a few refunds held in the euro balance. The residue does not wash out. It just sits there, and your P&L carries none of the foreign exchange movement you actually had, because none of it was posted.

There is a reporting reason to care as well as a tidiness one. IFRS (IAS 21) and US GAAP (ASC 830) both expect foreign-currency cash and receivables to be stated at the closing rate on the balance sheet date. A file that is never revalued states them at a blend of historical rates instead.

How to revalue a Stripe balance in QuickBooks Online

Intuit's procedure, from Enter home currency adjustments for your foreign balances:

1. Go to Settings, then Currencies.
2. Find the currency you want to adjust.
3. Open the dropdown under Actions and select Revalue Currency.
4. Choose the revaluation date. For a month-end close, that is the last day of the month.
5. Choose the exchange rate: the market rate, or a custom rate you enter.
6. Select the accounts to revalue. Include the Stripe clearing account for that currency, the matching bank account, and any foreign A/R or A/P.
7. Select Revalue.

A few rules shape how you use it.

One rate per account per day. Intuit states: "we can only save one exchange rate per day per account." You cannot run a morning revaluation and a corrected afternoon one on the same account.

Fixing a revaluation means deleting it. You can edit the entry number and memo on the journal entry QuickBooks creates, but not the date, amount or exchange rate. To change those, Intuit says to delete the entry and run the revaluation again.

Do it before you close the period. Intuit lists closed books as a condition that blocks the adjustment, so revalue first and set your closing date after.

Pick the rate deliberately. QuickBooks' market rate comes from its own feed, which Intuit says refreshes every four hours. Your accountant may want a specific published closing rate instead. Either works. What matters is using the same source every month, and not using the rate Stripe applied to a conversion, which carries Stripe's conversion fee.

Check the history afterwards. Intuit's FAQ points to a Revalue History tab in the currency settings that lists each revaluation with its date, rate and journal entry. It is the quickest audit trail when someone asks what moved the Exchange Gain or Loss line.

Revaluation belongs in the same week as the rest of your close. It fits naturally after you have reconciled the clearing account and before you lock the period. Our month-end close checklist for Stripe and QuickBooks walks through that clearing-account step, and this adjustment slots in right behind it.

Where Acodei fits, and where it stops

Everything above is a QuickBooks action on a QuickBooks balance. A revaluation is not triggered by anything in Stripe, so there is no Stripe transaction for a sync to post. Running it is your call or your accountant's, every period.

What a sync can do is make sure the balances you revalue are in the right currency to begin with. Acodei syncs Stripe to QuickBooks with two levels of multicurrency support, and both are enabled by the Acodei team on request rather than being self-serve toggles:

• Multicurrency Support matches each Stripe transaction's currency to the QuickBooks customer. If the currencies differ, Acodei creates a customer record per currency, such as "Acme - CAD". That is how QuickBooks structures currency per customer, not a bug.
• Invoice Multicurrency creates the QuickBooks invoice in the Stripe invoice's currency and applies exchange rates on payments, refunds, credit notes and payouts. Payouts in a currency other than your home currency are recorded as a Transfer with the exchange rate attached. Rates come from Stripe where available and from QuickBooks otherwise.

Two consequences for this post. First, if you hold more than one Stripe balance, Acodei's recommended setup is a separate holding account and a separate deposit account for each balance, using a clearing account rather than Undeposited Funds. That is exactly the structure that gives you a per-currency clearing account to revalue. Second, open invoices created in a foreign currency are foreign A/R, so they are part of the A/R revaluation, with the report-level unrealized treatment described above.

One limit to know: zero-decimal currencies such as JPY are not supported today. More detail is in our currency conversion and multicurrency documentation.

If your clearing account is carrying a home-currency balance with nothing left in it, start by revaluing the period in which that money left. Then make the revaluation part of every close. If you want the Stripe side landing in the right currency and the right accounts first, start a free trial.

Frequently asked questions

Does QuickBooks revalue foreign currency balances automatically?

No. QuickBooks records each foreign transaction at its own exchange rate and does not restate the balance afterwards. A revaluation happens only when someone runs Revalue Currency from Settings, then Currencies, for a chosen date and rate. If nobody runs it, foreign balances stay at a blend of the historical rates they arrived at.

Is the gain on a Stripe clearing account realized or unrealized in QuickBooks?

QuickBooks treats it as realized. Intuit states that home currency adjustments show on A/R and A/P as unrealized gains or losses and on other account types, like bank accounts, as realized. A foreign-currency clearing account is not A/R or A/P, so revaluing it posts a journal entry with a real amount to Exchange Gain or Loss.

Why does my Stripe clearing account show a dollar balance when it holds zero euros?

Usually because the euros arrived at one blend of exchange rates and left at another, and no revaluation ran in between. The payout transfer moves the euros out at its own rate, which leaves a home-currency remainder behind. Revaluing the account, as of any date after it empties, takes that remainder to zero and posts it to Exchange Gain or Loss.

How often should I run a home currency adjustment?

At every period end you report on, which for most businesses means monthly. Run it after the clearing account reconciles and before you set the closing date, since Intuit lists closed books as a condition that blocks it. Use the same rate source each time. QuickBooks allows one saved rate per account per day.

Do I need to revalue anything if Stripe converts all my sales to US dollars?

Usually not for Stripe itself. If your Stripe account has a single balance in your home currency, Stripe converts each sale when it settles and your clearing account is in home currency, with nothing to revalue. You may still have foreign A/R if you create invoices in other currencies, and those are revalued as unrealized gains or losses.