United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
snowleopard25
Level 2
posted
‎September 26, 2021 03:15 AM
last updated ‎September 25, 2021 10:16 AM

Shopify + Quickbooks - Converting Shopify Financial Reports Currency USD to AUD??

Hi,

 

I am based in Australia - my Shopify store is set up in USD currency (as most of my customers are US based).

 

But in order to do my bookkeeping in QB properly I need my Shopify financial reports to be converted from USD currency to AUD currency. (so all my sales, revenue etc are collected in USD)

 

I tried using a QB app to convert each Shopify order (transaction) from USD to AUD however these only go back 1 year max and I need the data from 2017 to 2021 as behind in my tax returns.

 

Which is all available in the Shopify Financial reports and my orders list - so I was wondering if anyone knew how to convert this financial report data Shopify gives us (sales, refunds, taxes, shipping) from USD to AUD and enter into QB accurately in AUD?

 

I know you do it as a journal entry, however i'm not sure 

 

a) how to actually do that 

b) as all my financial data on Shopify financial reports is in USD but my QB is in AUD.. how do I convert this data with the correct exchange rates (which would vary day to day) for 2017 to 2021?

 

Unfortunately Shopify couldn't give me a solution (they cannot change the currency of past data only future data) so I'm here to see if QB can help..

 

Thanks in advance

Solved
Reply
Best answer September 26, 2021
Solved

Best Answers
Fiat Lux - ASIA
Level 15
‎September 26, 2021 01:40 PM

Shopify + Quickbooks - Converting Shopify Financial Reports Currency USD to AUD??

@snowleopard25 

You need a 3rd party app to deal with multicurrency and multi tax rates to reconcile Shopify transactions into your QBO account.

View solution in original post

Reply
2 Comments 2
DivinaMercy_N
Moderator
Moderator
‎September 26, 2021 05:52 AM

Shopify + Quickbooks - Converting Shopify Financial Reports Currency USD to AUD??

Thanks for being detailed about your report currency concern, @snowleopard25. I'm here to give details about this. 

 

When you run financial reports in QuickBooks Online (QBO) the data are based on your home currency. For instance, if your home currency is USD, the information is based on that currency. To know more about this, visit this article: Learn about Multicurrency in QuickBooks Online. 

 

As a workaround, you can filter a report to add a column to display information for the different currencies in your company data. Let me guide you how:

 

  1. Sign in to your QBO account.
  2. Go to the Reports menu.
  3. From the search field, enter Balance Sheet Detail.
  4. Click it to open.
  5. Next, select the Customise button.
  6. Then, scroll down to the Rows/Columns section.
  7. From there, check the box for Exchange Rate, Foreign Amount and Currency.
  8. Once done, click Run report.

 

For your reference in modifying a report, check out this article: Customise reports in QuickBooks Online.

 

With regards to doing journal entry transactions, I suggest reaching out to your accountant to guide you on what action you can take. This way we can avoid messing with your books. 

 

Visit our QuickBooks Online Help page if you need any useful resources that you can bookmark for future use. There are several assistance articles and even video tutorials available on the site to help you with your QBO tasks.

 

Post again here if you have additional concerns about converting financial reports currencies. I'd be happy to assist you further. Have a great day ahead.

Reply
Fiat Lux - ASIA
Level 15
‎September 26, 2021 01:40 PM

Shopify + Quickbooks - Converting Shopify Financial Reports Currency USD to AUD??

@snowleopard25 

You need a 3rd party app to deal with multicurrency and multi tax rates to reconcile Shopify transactions into your QBO account.

Reply