/

How to Record a Foreign Currency Payment or Wire in QuickBooks

Convert a PDF bank statement to a QuickBooks file

Drop in a PDF statement and get a QBO (Web Connect) or IIF file you can import into QuickBooks Online or Desktop.

To record a foreign currency payment or wire in QuickBooks, book it in US dollars at the exchange rate in effect on the day the money moved, which is the spot rate the IRS expects for a US business that keeps its books in dollars. If you turn on Multicurrency, QuickBooks holds the foreign amount and the rate for you and calculates the dollar value automatically. If you do not, you simply enter the US dollar amount your bank actually debited or credited, including the wire fee, and no exchange tracking is needed. Either way, the number that lands in your books is the dollars that left or entered your account.

Most US small businesses do not need Multicurrency at all. If you wire a supplier in euros and your bank converts the money and debits your account $5,240, that $5,240 is the expense, full stop. Multicurrency matters when you invoice or get billed in a foreign currency and settle it later, because the rate can move between the invoice date and the payment date, and that difference is a real gain or loss you have to record. This guide covers both cases and the wire fees that ride along with them.

What exchange rate do I use for a foreign transaction in QuickBooks?

Use the spot rate on the date you receive, pay, or accrue the item. The IRS instruction for a business that keeps its books in dollars is to translate each foreign transaction at the exchange rate prevailing when it happens, so the cleanest source is the rate your own bank applied, which is printed on the wire confirmation or the statement. When your bank has already converted the money, you do not need any rate at all: you record the exact US dollars that hit your account. You only reach for a published rate when you are recording a foreign-denominated invoice or bill that has not settled yet.

Where each piece of a wire actually posts

An international wire almost never arrives as a single clean number. Between the amount you invoiced and the amount that lands in the account there are usually three or four separate deductions, each belonging in a different place in the books. Sorting them at the point of entry saves an argument with the reconciliation later.

ComponentWhat it isWhere it postsShows on the statement?
Wire fee (your bank)Flat charge for sending or receivingBank charges or bank fees expenseYes, usually a separate line
Intermediary or correspondent bank feeTaken in transit by a bank in the middle of the chainBank charges expenseNo, it is already netted out
Exchange rate spreadThe margin between the bank rate and the market rateExchange gain or lossNo, it is inside the converted amount
Realized gain or lossMovement between invoice date and payment dateExchange gain or lossNo, QuickBooks calculates it
Net proceedsWhat actually hit the accountThe bank accountYes, this is the line you reconcile to

The second row is the one that causes the most confusion. An intermediary bank can take its cut before the money reaches you, so the payment is short and nothing on your own statement explains why. If a customer insists they sent the full amount and your bank shows less, this is almost always the reason, and the shortfall is a bank charge rather than an underpayment to chase.

How do I record a wire payment to a foreign vendor in QuickBooks?

Record it as a normal expense or bill payment in US dollars for the amount your bank debited, then book the wire fee separately. Say you send $5,240 to cover a supplier invoice and the bank charges a $45 outgoing wire fee. Enter an expense from your checking account: $5,240 to the supplier expense or accounts payable, and $45 to bank charges. The total $5,285 is what left the account, so the payment matches the statement to the penny. If you are paying international suppliers regularly, an automated payables workflow can capture each bill and its wire fee so nothing is entered twice or missed at reconciliation.

How do I record a foreign currency wire received in QuickBooks?

Record the deposit for the US dollars your bank credited after conversion, and split out any fee the bank deducted. If a customer overseas wires the equivalent of $8,000 and your bank credits $7,965 after a $35 incoming wire fee, record a deposit of $8,000 to income or against the open invoice and a $35 bank charge, so the net $7,965 matches the statement. Recording only the net $7,965 would understate your revenue and hide the fee. Getting the gross amount and the fee both in is what keeps income and expenses honest.

Do I need to turn on Multicurrency in QuickBooks?

Turn on Multicurrency only if you invoice customers or receive bills in a foreign currency and settle them on a later date. It lets you assign a currency to a customer, vendor, or bank account and holds the foreign balance while tracking the rate. Two cautions: Multicurrency cannot be turned off once it is on in QuickBooks Online, and it adds complexity to every screen. If your foreign activity is just the occasional wire that your bank has already converted to dollars, skip it and record the dollar amounts directly. Reserve Multicurrency for when you genuinely carry a foreign-currency receivable or payable.

How do I record an exchange rate gain or loss in QuickBooks?

An exchange gain or loss happens when the rate moves between the date you record a foreign invoice or bill and the date you pay it. If you booked a euro bill worth $5,000 and actually paid $5,120 because the euro rose, that extra $120 is a foreign exchange loss; if you paid $4,900, it is a $120 gain. With Multicurrency on, QuickBooks calculates this automatically when you apply the payment and posts it to an Exchange Gain or Loss account. Without Multicurrency, you record the difference yourself as a small entry to an exchange gain or loss account so the bill clears to zero.

How do I record bank wire fees in QuickBooks?

Book every wire fee to a bank charges or bank fees expense account, separate from the payment or deposit it rode with. Incoming and outgoing wires usually carry a fixed fee of $15 to $50, and intermediary banks sometimes take a cut on international transfers too. Recording the gross payment plus the fee, rather than just the net, is what lets your books reconcile against the statement and shows what wire activity costs you over a year. When you import the statement, the fee appears as its own line, so you can code it directly. If the wires sit on a card rather than a checking account, the same applies when you convert a credit card statement to QuickBooks.

What is the easiest way to get foreign wires into QuickBooks accurately?

Convert the bank statement and let the transactions flow in at the exact dollar amounts, then categorize them. Wires and their fees show on the statement in the US dollars your bank actually moved, so importing them removes any guesswork about the rate. Upload the PDF to convert your bank statement to a QuickBooks file, review the wire deposits, payments, and fees it reads, and download a QBO file to import. Then apply each wire to the right invoice or bill and code the fee to bank charges. For coding the imported lines consistently, see our guide to categorizing bank transactions in QuickBooks.

How do I report foreign transactions at tax time?

Report every foreign transaction in US dollars, because the IRS requires a US business to file in dollars. Since you already recorded each wire at the dollar amount your bank moved, your profit and loss and balance sheet are tax-ready with no extra translation. The one thing to keep is documentation of the rate on each transaction, which your wire confirmations and statements provide. If you carry foreign-currency balances year-round, your accountant may also revalue open receivables and payables at year end, but a business that settles wires in dollars as they clear rarely needs to.

A simple checklist for foreign wires

Record the payment or deposit in the US dollars your bank actually moved, book the wire fee to bank charges as its own line, and reserve Multicurrency for genuine foreign-currency invoices and bills you settle later. When a rate moves between billing and payment, post the small difference to an exchange gain or loss account so the bill or invoice clears cleanly. Do that consistently and your foreign activity reconciles against the statement every month, and your year-end numbers are already in dollars and ready to file.

How do I record a wire transfer fee in QuickBooks?

Book it as a bank charge expense on the same date as the wire. If the fee came out as its own line on the statement, enter it as a separate expense so both lines reconcile cleanly. If it was deducted before the money arrived, split the deposit: record the gross amount against the invoice and the fee as a negative line coded to bank charges, so the deposit total matches what actually landed while the invoice still clears in full.

Do I need to turn on multicurrency in QuickBooks?

Only if you hold accounts or owe balances in another currency. If foreign payments simply arrive converted into dollars, you do not need it, and you are better off without it. Turn it on and you can track invoices in the customer's currency and let QuickBooks calculate exchange differences for you. The trade off is permanence: once multicurrency is enabled in QuickBooks Online it cannot be switched off, and the home currency is fixed from that point, so treat it as a one way decision rather than something to try out.

How do I record an exchange rate gain or loss?

With multicurrency on, QuickBooks does it for you. It compares the rate on the invoice date to the rate on the payment date and posts the difference to the exchange gain or loss account automatically when the payment is applied. Without multicurrency, you record the dollars that actually arrived and code the difference against the original invoice amount to the same kind of account yourself, which keeps accounts receivable clear instead of leaving small unpayable remainders behind.

Why does my foreign customer's payment never match the invoice?

Three reasons stack up, and often all three apply at once. The exchange rate moved between the invoice and the payment. Your bank applied a spread on top of the market rate. An intermediary bank took a fee in transit. None of these are errors, and none should be chased as a shortfall. Record the net amount received, code the difference to bank charges and exchange gain or loss as appropriate, and close the invoice.

Skip the manual entry

Upload a PDF bank statement and get a QBO or IIF file ready to import into QuickBooks.

Convert a Statement Free