AllBusiness.com
    • Starting a Business
    • Career
    • Sales & Marketing
    • AI
    • Finance & Fundraising
    • M & A
    • Tech
    • Business Resources
    • Business Directory
    1. Home»
    2. Finance»
    3. Multiple Currency Support in QuickBooks»

    Multiple Currency Support in QuickBooks

    Brandon Morris
    Finance

    One of the new features of QuickBooks 2009 is Multiple Currency support; Prior to 2009 multi-currency was only available in the Canadian version.



    We will take a brief look at it now, if you have questions please let me know and we can dive into it more if needed.



    First of all, how do you enable Multiple Currency within QuickBooks?



    Multiple Currencies may be enabled in two locations:


    • During the Easy Step Interview.
    • In Preferences under Multiple Currencies
    Now a few notes about Multiple Currencies:


    • Once Multiple Currencies is enable in a company file, it cannot be turned off
    • After selecting 'Yes' to enable Multiple Currencies, the user is warned that it cannot be disable and that a backup should be made of the company file.
    • If a 'Home Currency' other than US Dollar is selected, the user is informed that Online Banking and Payroll will not function with non-USD home currencies.
    Currency List


         New list implemented for Multiple Currencies


    • 158 QuickBooks-defined currencies available


              Includes list of all known currencies


              May not be edited or deleted


    • Four active currencies by default
    • New user-defined currencies may be created
    • List limit is 500 total currencies
    Multiple Currency Enabled Transactions



    This following list of enabled transactions is quite extensive...QuickBooks did a good job with the multiple currency support.





    • Checks
    • Transfers
    • Deposits
    • General Journal Entries
    • Credit Card Charges/Refunds
    • Sales Receipts
    • Sales Orders
    • Estimates
    • Invoices


    • Credit Memos/Refunds
    • Customer Payments
    • Purchase Orders
    • Item Recipts
    • Bills
    • Bill Credits
    • Bill Payment Checks
    • Bill Payment CCard
    • Home Currency Adjustments















    Features Which Interact:


    Time/Costs                        


    Reconcile






    Unsupported Features:


    Foreign Statement Charges


    Sales Tax Payments/Adjustments


    Foreign Registers


    Online Banking-Foreign Accounts


    Payroll - Non-US home currency


    Merchant Account Service



    Home Currency Adjustments


    • Allows user to make adjustments to home currency amounts (revalue the accounts due to the fluctuating exchange rates) to modify exchange gain or loss amounts
             Can adjust home currency amounts for customer and vendor open balances.


             Can adjust home currency amounts for bank and credit card accounts.


    • Which currency is selected affects the names & accounts displayed
            Only names and accounts of the selected currency can be adjusted at one time.


    • All amounts except Foreign Balances display in home currency
    • Adjusted Balance automatically calculates based on exchange rate entered
            Exchange Rate auto-populated from Exchange Rate Table


                 Driven by Date


                 Uses rate for transaction date if availble or most recent prior date.



    How Multi-Currency Works With Reports



    • New Reports implemented with Multi-Currency


           Realized Gain/Loss Report


                Shows the gain or loss on a cash basis based on exchange rate


                 differences between linked transactions



           Unrealized Gain/Loss Report


                Shows the expected gain or loss on unlinked transactions based


                on the exchange rate of the report date vs. transaction exchange rate


    • Reports Modified to Support Multi-Currency


           Transaction Detail Reports


                Displays in home currency by default


                Currency, Exchange Rate, Foreign Amount, Foreign Balance,Foreign Open Balance,


                   Realized Gain/Loss columns can be added


                New filters added: Currency & Foreign Amount


          


              Transaction Summary Reports


                   Displays in home currency by default


                   Can be modified to display in the currency of the transactions


                   New filters added: Currency & Foreign Amount



              List Reports


                   Displays in foreign currency by default (where applicable)



    As a quick note, I'd like to add that I am set up on twitter.  If you're not using it yet, you should look at it.  If you are on it or end up using it, I invite you to follow me my user name on twitter is qb_baron - just click on this link, it'll take you directly to my twitter homepage.



    As always, if you have a question, feel free to send it to me or make a comment right here in this column.



    Hot Stories

    Strategizing is one essential business skill

    10 Essential Business Skills for Success According to AI

    A skilled trade worker using AI

    From Chaos to Control: How the Skilled Trades Are Winning With AI

    Profile: Brandon Morris

    Brandon Morris, Advanced Certified QuickBooks ProAdvisor, is co-founder and co-owner of Barons', Inc.

    BizBuySell
    logo
    AllBusiness.com is a premier business website dedicated to providing entrepreneurs, business owners, and business professionals with articles, insights, actionable advice,
    and cutting-edge guides and resources. Covering a wide range of topics, from starting a business, fundraising, sales and marketing, and leadership, to emerging AI
    technologies and industry trends, AllBusiness.com empowers professionals with the knowledge they need to succeed.
    About UsContact UsExpert AuthorsGuest PostEmail NewsletterAdvertiseCookiesIntellectual PropertyTerms of UsePrivacy Policy
    Copyright © AliBusiness.com All Rights Reserved.
    logo
    • Experts
      • Latest Expert Articles
      • Expert Bios
      • Become an Expert
      • Become a Contributor
    • Starting a Business
      • Home-Based Business
      • Online Business
      • Franchising
      • Buying a Business
      • Selling a Business
      • Starting a Business
    • AI
    • Sales & Marketing
      • Advertising, Marketing & PR
      • Customer Service
      • E-Commerce
      • Pricing and Merchandising
      • Sales
      • Content Marketing
      • Search Engine Marketing
      • Search Engine Optimization
      • Social Media
    • Finance & Fundraising
      • Angel and Venture Funding
      • Accounting and Budgeting
      • Business Planning
      • Financing & Credit
      • Insurance & Risk Management
      • Legal
      • Taxes
      • Personal Finance
    • Technology
      • Apps
      • Cloud Computing
      • Hardware
      • Internet
      • Mobile
      • Security
      • Software
      • SOHO & Home Businesses
      • Office Technology
    • Career
      • Company Culture
      • Compensation & Benefits
      • Employee Evaluations
      • Health & Safety
      • Hiring & Firing
      • Women in Business
      • Outsourcing
      • Your Career
      • Operations
      • Mergers and Acquisitions
    • Operations
    • Mergers & Acquisitions
    • Business Resources
      • AI Dictionary
      • Forms and Agreements
      • Guides
      • Company Profiles
        • Business Directory
        • Create a Profile
        • Sample Profile
      • Business Terms Dictionary
      • Personal Finance Dictionary
      • Slideshows
      • Entrepreneur Profiles
      • Product Reviews
      • Video
    • About Us
      • Create Company Profile
      • Advertise
      • Email Newsletter
      • Contact Us
      • About Us
      • Terms of Use
      • Contribute Content
      • Intellectual Property
      • Privacy
      • Cookies