Skip to main content
S
Swordfish
April 29, 2020
Question

how to enter FX transactions where the totals dont completely match

  • April 29, 2020
  • 2 replies
  • 0 views

I sometimes have transactions where the totals are a bit off and I don't know how to handle that. QB doesn't mark a bill as paid unless the amount is the exact same so I don't know what to do in those cases.

 

So the most annoying transaction I have every month is a relationship this client has with their sister company. Every month there's a loan to this company, as well as a payment for services rendered. My client usually pays in two payments, but the breakdowns of the payments aren't the same as the subtotals. And the total doesn't match. So I don't know how to handle that?

 

Let me illustrate by example.

 

Loan to company: $5K

Inv from same company: $7K

 

Payment 1: $6K

Payment 2: $6100

 

So as you can see here, the subtotals are different, and the final total is slightly off. The reason for the final total being off is because of the FX. But anyway, how would one handle a transaction like this?

 

 

 

 

2 replies

AddieC
AddieC
April 29, 2020

Hi there, 

 

I know how important it is to work with a software that's flexible enough to handle various types of business transactions. An FX transaction deals with foreign exchange, and luckily QuickBooks Online has an awesome way to account for that in your books. I'll explain more about the Multicurrency feature. 

 

Multicurrency is available in QuickBooks Online Essentials and Plus. If you do have reason to turn Multicurrency on, it can be a powerful feature for your business. Once on, QuickBooks Online downloads exchange rates nightly from WSoD (Wall Street on Demand). You can also manually enter exchange rates and revalue them if needed.


Here's everything you need to know about Multicurrency: About Multicurrency.

 

Based on your example, it sounds like you're billing in one currency, and accepting payment in another. This will definitely cause discrepancies in your books, as the totals won't match and you'll be left with open balances. 


I want to make sure you're given the right information to handle this complex transaction. In this case, I'd encourage you to first consult an accountant to find out the best way to record this transaction. If you're not yet connected to an accountant, you can find one here. Then, you can reach out to our tech support team for help in recording the transaction based on your accountant's advice. 

 

The steps you'll take will largely depend on how you're creating the transactions, what currencies are involved, and your accountant's professional advice. I hope this helps get you started on the right track. 

Cheers. 

Fiat Lux - ASIA
Fiat Lux - ASIA
April 29, 2020

@Swordfish 

As another option, utilize this 3rd party payment service to deal with multi currency transaction. You may release an invoice and get paid in CAD, and your customer pay in the local currency. It supports QBO

https://veem.grsm.io/veems

 

Terms & ConditionsAccessibility statement