75% off

for 3 months

Start fresh this new year with QuickBooks Online

Buy now

SALE

Buy now and
save 50% off today See plans & pricing

SALE

See plans & pricing

Start your business
Start your business
Run your business
Run your business
Grow your business
Grow your business
Accountants and Bookkeepers
Accountants and Bookkeepers
- Accountants and Bookkeepers
  Learn how accountants and bookkeepers can be productive in these articles & guides
- Learning and Development
  A range of informative content to enhance your QuickBooks experience.
Updates
Updates
- Product Updates
  Watch this space for monthly product updates.
- Intuit News
  Latest news, articles & guides

QuickBooks Blog

Need help choosing a plan?

1800 917 771 Schedule a call

Schedule call

product update

Multi-currency tips and tricks

By Lauretta Finis

November 30, 20166 min read

QuickBooks Online can help international business owners tackle common challenges, from handling 145+ currencies using Wall Street on Demand to automatically updating exchange rates every four hours.

If you would like more information on setting up the foreign currency Customer and Supplier function as well as payments, download QuickBooks Online Multi-Currency How to Guide.

QuickBooks Online downloads the exchange rates every four hours from Wall Street On Demand. With QuickBooks Multi-Currency feature, you can:

Assign a currency to customers, suppliers, bank accounts and credit cards
Track and manage currency exchange rate fluctuations
Track and reconcile your foreign bank accounts in QuickBooks Online
Manually enter other bank exchange rates and revalue them
Pay and receive payments in a supplier’s or customer’s currency
Revalue a currency

Let’s look at some other situations and some important tips.

Setting up the customer and supplier card correctly

When entering information for your customer or supplier, add the foreign currency code after the name of the customer, then choose the correct currency.

In this example we are adding a customer called Beagles and Pets. We have also added ‘USA’ after the business name, so you can easily see the card is in US dollars.

Choose the correct currency for the customer. This is found under the Payment and billing tab, then under This customer pays me with dropdown menu.

This customer pays me with will default to the home currency, so in this instance it is AUD, and by clicking on the dropdown menu you can choose the currency required.

Note: This card will only have USD transactions associated with it and you cannot change this customer back to any other currency.

Setting up foreign currency bank accounts

Ensure the Currency chosen is the foreign currency required.

Hint: Add the currency code after the bank so it is easy to find, such as USD shown below.

Receiving or paying payments

Follow these steps if customers or suppliers are paying you in the same foreign currency.

Note: The amount will differ because of bank fees.

Example: If you have an invoice of USD $2,072.00, the payment received will be USD $2,062.00:

A fee of USD $10 has been applied in this instance, as the customer has allowed the fee deduction from the total outstanding amount
Foreign currency bank accounts in USD will need to be reconciled to USD bank statements in QuickBooks Online
Use the exchange rate within QuickBooks Online – Wall Street on Demand

Step 1: Date of payment in Bank – the rate will reflect the date paid:

Deposit to: Choose the USD bank account Wells Fargo Bank USD
Amount received: Matching the bank amount that was received

Note: This will match in your online bank feeds if you have your bank account linked to QuickBooks Online.

Step 2: Apply the bank fee of USD $10.00 (this will be the outstanding amount of the invoice):

Payment date: This will reflect the USD rate on day paid
Deposit to a clearing account – ‘USD Clearing account’
This has to be moved in the AUD amount to Bank charges

Step 3: Move the bank fee into your Profit and Loss account Bank charges. Zeroing out the USD Clearing account is also required:

From your Chart of Accounts choose USD Clearing account, click into Account History right-hand side under Action column
This ledger will give you the foreign curency amount, the exchange rate and the AUD amount
The AUD amount is the bank fee charged at the currency rate used on the day of payment converted to AUD amount (the conversion has been worked out for you)
To move the AUD amount to the Bank charges account, you can process as an expense as below using the Clearing account as your bank
Add Cheque field, then add the account – bank fee adds the Payment amount and GST code and Save

Looking at the above transaction in our Exchange Gain or Loss account, QuickBooks Online has automatically posted the difference in exchange rates for both the USD $2,062 and $10 payment transactions.

Follow these steps if customers or suppliers are paying you and you receive the payment in your AUD currency bank account.

Example: If you have an invoice for USD $4,490 and the current exchange rate is 1.32279 on the 15 November, when converted to AUD the invoice will be $5,939.35:

But if payment is received from the client on 20 November, the outstanding amount on the invoice will be AUD $5,657.05
A calculation is required to match the remittance advice from the bank.
AUD $5657.05 ¸ USD $4490.00 = 1.26000 as the new exchange rate
Bank credited $5642.05 only in AUD bank
Fee AUD $15, in this instance the customer has opted for the fee deduction from the total amount paid

Step 1: When you are receiving payment in US dollars:

Change the rate to the above calculation of 1.2600 and select only for this transaction

This will change the amount on the invoice to AUD $5657.05 before fees:

Apply the USD $4490.00 Amount received and Deposit to the USD Clearing account using the 22 November payment date

Step 2: USD Clearing account now has the total AUD amount, which needs to be transferred to the correct accounts for Matching:

1. Transfer AUD $5642.05 received into your AUD bank account. This will allow the transaction to Match your online bank feeds:

You can process this directly from Cheque > Add transfer or by creating a Transfer from the Global button. Make sure you choose the correct bank account to deposit these funds

2. Bank fee of $15.00 moved to Bank charges:

Note: As per balance left in USD Clearing account $15.35
This is a small currency conversion discrepancy
You can either process the 0.35 cents to Exchange Gain/Loss or, as below, move this total amount to Bank charges

Process this fee via an Expense transaction. You can create a button or process directly with the Add cheque field > Add expense, and allocate to Bank charges and total amount of $15.35, click Save, which will zero out the USD Clearing account

3. Hint: Process the amount deposited to the bank which will be matched in bank feeds first.

Step 3: Online bank feeds:

Match the amount received in the bank to the amount transferred out from the USD Clearing account in the AUD amount

Looking at this transaction, the exchange rate was manually changed in QuickBooks Online, which automatically posts this difference to the Gain/Loss account. This can be viewed from the Proft and Loss report or Reports > All Reports > Business Overview > Realised Exchange Gains & Losses report.

Transferring from your AUD to foreign currency bank account

This can be treated just as you would a transfer from bank account to bank account.

Global Create button > Other > Transfer

Example: If you transfer AUD $1000 to USD Wells Fargo Bank and use the currency exchange, this rate will be applied and USD $1356.21 will be moved into your ledger account.

Foreign currency expenses paid via a foreign currency bank account

Processing a direct expense in a foreign currency bank account is straightforward:

Choose the supplier name previously set up with the foreign currency required
Then the foreign currency and exchange rate will appear automatically underneath the supplier name
When processing the amount, the converted AUD amount will also appear in the columns

Hint: If a foreign currency expense has been paid in AUD via an AUD bank account:

Process the AUD amount
The supplier card needs to be in AUD, as this will then match in the AUD bank account

Reporting on multi-currency

Various reports can be found in QuickBooks Online for reviewing.

Reports > All reports > Business overview

Or via your Profit and Loss > click into the account Exchange Gain or Loss.

APPS: Intuit QuickBooks Online apps that intergrate with foreign currency

Use TransferMate for a faster, cheaper way to make international payments.

Using a separate clearing account for the currency being transacted creates flexibility with some of the many varying transactions that occur when receiving or making foreign currency payments.

If you have a remittance advice from the bank, it will note the date used, the currency conversion rate and the bank fee charged, which makes life easier when entering this information into QuickBooks Online.

To read more articles related to product updates, visit here.

Looking for something else?

Get QuickBooks

Smart features made for your business. We've got you covered.

See how it works

Help Me Choose

Use our product selector to find the best accounting plan for you.

Choose your product

QuickBooks Support

Get help with QuickBooks. Find articles, video tutorials, and more.

Start learning

A computer screen showing a picture of a computer.

TAKE A NO-COMMITMENT TEST DRIVE

Your free 30-day trial awaits

Our customers save an average of 9 hours per week with QuickBooks invoicing*

No credit card needed

Cancel anytime

Unlimited support

By entering your email, you are agree to our Terms and acknowledge our Privacy Statement.

- - QuickBooks reserves the right to change pricing, features, support and service at any time. Prices are in AUD and include GST. See our Terms of Service for further information.
  - Pricing: All prices are in AUD and include GST.
  - ProAdvisor Program: Please find the terms of our ProAdvisor program here.
  - 75% off for 3 months: For new subscribers, enjoy a 75% off price subscription on QuickBooks Online Simple Start, QuickBooks Online Essentials or QuickBooks Online Plus for the first 3 months of your subscription (Offer). The discount will applied from the date of your enrolment and will continue for 3 months. From month 4, you will be charged the then current monthly retail price for your subscription. See current prices here. QuickBooks Payroll and QuickBooks Time prices are not eligible for any discount and will be invoiced separately according to your usage on a monthly basis during your subscription. Intuit reserves the right to request information to verify the eligibility of a purchaser of the Offer. Acceptance of such verification information is at the reasonable discretion of Intuit, which may revoke the Offer and impose a monthly cost for the subscription at the then current retail prices, at any time if it considers the purchaser is ineligible for the Offer.
  - 50% off for 12 months: For new subscribers, enjoy a 50% discount off the current monthly retail price for QuickBooks Self-Employed, QuickBooks Online Simple Start, QuickBooks Online Essentials or QuickBooks Online Plus for the first 12 months of your subscription (Offer). The discount will applied from the date of your enrolment and will continue for 12 months. From month 13, you will be charged the then current monthly retail price for your subscription. See current prices here. QuickBooks Payroll and QuickBooks Time prices are not eligible for any discount and will be invoiced separately according to your usage on a monthly basis during your subscription. Intuit reserves the right to request information to verify the eligibility of a purchaser of the Offer. Acceptance of such verification information is at the reasonable discretion of Intuit, which may revoke the Offer and impose a monthly cost for the subscription at the then current retail prices, at any time if it considers the purchaser is ineligible for the Offer.
  - 75% off for 3 months (existing subscribers): For existing QuickBooks subscribers who upgrade to QuickBooks Online Essentials, Plus or Advanced, enjoy a 75% discount off the current monthly retail price for 3 months of your subscription (Offer). The discount will be applied from the date you upgrade in-product and will continue for 3 months. From month 4, you will be charged the then current monthly retail price for your subscription. See current prices here. QuickBooks Payroll and QuickBooks Time services and prices are not eligible for any discount and will be invoiced separately according to your usage on a monthly basis during your subscription. Intuit reserves the right to request information to verify the eligibility of a purchaser of the Offer. Acceptance of such verification information is at the reasonable discretion of Intuit, which may revoke the Offer and impose a monthly cost for the subscription at the then current retail prices, at any time if it considers the purchaser is ineligible for the Offer.
  - Free Trial: First thirty (30) days of subscription to QuickBooks Online, QuickBooks Self-Employed and QuickBooks Payroll (including QuickBooks Advanced Payroll), starting from the date of enrolment, is free. During the free trial, you may pay any number of employees using QuickBooks Payroll free of charge. To continue using QuickBooks after your 30-day trial, you'll be asked to present a valid credit card for authorisation and you'll be charged monthly at the then-current fee for the service(s) you've selected.
  - QuickBooks Payroll powered by Employment Hero: Payroll services are offered by a third party, Employment Hero. QuickBooks Payroll is only accessible via QuickBooks Online subscriptions. You will be charged $6.00 (incl. GST) per month for each ‘active employee’ paid using QuickBooks Payroll. An ‘active employee’ is one who has been paid at least once in the billing month. For Advanced Payroll, there is an additional monthly subscription fee of $10 (incl GST). Pricing, terms and conditions, including service options, are subject to change.
  * Employment Hero was voted the leading payroll solution for SMBs <50 employees (Australian Payroll Association 2021 Payroll Benchmarking Study)
  - Customer support: Call or chat to an expert for QuickBooks Online Accountant, QuickBooks Simple Start, Essential, Plus, and Advanced or use in-product QB Assistant and chat for QuickBooks Self-Employed. You'll also find useful resources in the QuickBooks Community.
  - Compatible Devices: QuickBooks Online, QuickBooks Self-Employed and QuickBooks Payroll require a computer with Internet Explorer 10, Firefox, Chrome, or Safari 6 and an Internet connection (a high-speed connection is recommended). The QuickBooks Online mobile app works with iPhone, iPad, and Android phones and tablets. QuickBooks Online and QuickBooks Payroll are accessible on mobile browsers on iOS, Android, and Blackberry mobile devices. Devices sold separately; data plan required. QuickBooks Payroll cannot be used on the mobile apps. Not all features are available on the mobile apps and mobile browser. QuickBooks Online mobile access is included with your QuickBooks Online subscription at no additional cost. Data access is subject to cellular/internet provider network availability and occasional downtime due to system and server maintenance and events beyond your control. Product registration required.
  - Get paid faster: Get paid 2.5x faster invoicing with PayPal
  * PayPal and QuickBooks customers get paid on average in less than 5 days, which is over 7 days faster than the average for invoices that get paid with other payment methods. Data is for paid invoices that were created in QuickBooks in Australia between 23.05.22 and 23.11.22
  - Tax deductions: Tax deductions not guaranteed due to being subject to user data entry errors. Mileage calculation provided by the Australia Taxation Office - 85 cents per kilometre for the 2023-2024 income year. To a maximum of 5,000 business kilometres per car (Deductions are only applicable to cars)
  - Customer Service Awards: Excellence in Customer Service Award at the CX Australia Awards 2022
  - Multiple file discount: Multiple file discount applies to QuickBooks Australia customers only and valid when signing up for more than one QuickBooks Online subscription in one order. Further terms and conditions available here. Not applicable to QuickBooks Self Employed.
  - Reviews: GetApp, Capterra, Google Play Store, Apple App Store reviews as at date 08/01/24.
  - Cost per day claim (annual): Based on a QuickBooks Simple Start plan at its regular retail price of $313 per year and a 365 day year.
  - Annual Billing: You may pay for your QuickBooks Online subscription on an annual, upfront basis to enjoy a discount on the current fees. If you use QuickBooks Payroll powered by Employment Hero, your payroll costs will still be charged monthly to your nominated payment method in accordance with your usage as set out here. If you cancel your QuickBooks Online subscription within the pre-paid 12 month period, you will not be eligible for a refund, but will retain full access to your QuickBooks Online subscription for the remainder of the 12-month period. Unless cancelled by you prior, your annual subscription will auto-renew on the 12 month anniversary of your sign-up date using the billing details you have given us. Discounts, prices, terms and conditions are subject to change.
  - Over 7 million customers: Based on number of global QB customers (ecosystem) (7.1m) worldwide as of October 2022.
  - Free Onboarding: Applicable to Buy Now subscriptions on QuickBooks Simple Start, Essentials and Plus plans. Not available for QuickBooks Self-Employed.
  - Save Hours: Save up to an average of 29 hours per month with QuickBooks.
  - * Based on a survey conducted by Intuit Australia Pty Ltd in September 2022. Time saving is in comparison to previous accounting method, based on 184 responses from customers that saw time savings.
  - Get access to QuickBooks Tax: ***Access QuickBooks Tax, powered by LodgeiT, by becoming a member of the QuickBooks ProAdvisor Program (it’s free to join). Find out more about the ProAdvisor Program here, including the terms of the QuickBooks Tax offer in the Program here.
  - QuickBooks Time Disclaimers & Offers for Australia: For Important pricing offers and disclaimers with further information, please see here.
  - *Full terms and conditions for access to QuickBooks Tax, powered by LodgeiT as part of the the Proadvisor Program can be found here. QuickBooks reserves the right to change pricing, features, support and service at any time.
  - **Intuit conducted a study involving 56 interviews with accountants and bookkeepers who used Books Review for BAS preparation between March to December 2021 and found that when using Books Review, participants reduced the time spent preparing their clients BAS Reports by around 40%.
  - Our Terms of Service apply to all QuickBooks Online subscriptions. Please review them carefully.

Intuit helps put more money in consumers’ and small businesses’ pockets, saving them time by eliminating work, and ensuring they have confidence in every financial decision they make.