
Learn how QuickBooks Online handles multiple currencies, focusing on cash, accounts receivable, and accounts payable, with U.S. dollars as the base and foreign currency revaluation using Excel.
Explore how to handle foreign currency accounts receivable in QuickBooks Online, including recognizing exchange rate gains or losses and end of period adjusting entries.
Learn how to adjust a loan payable in QuickBooks Online when using multiple currencies, revalue to the current rate, and record exchange gains or losses via adjusting entries.
Enable multiple currencies in QuickBooks Online, set up a yen checking account, and transfer US dollars to yen to pay a foreign currency loan using the spot rate.
Explore how to record a 180-day forward contract speculating that the peso will weaken using QuickBooks Online Multiple Currencies, with a receivable in USD and a payable in pesos.
Analyze a forward contract speculating currency will weaken and its impact on gains or losses through receivable and payable, end of period adjustments, pay bills in QuickBooks Online, multiple currencies.
Demonstrate managing multiple currencies in QuickBooks Online through a foreign payable and forward contract maturity, including journal entries, currency revaluation, and year-end adjustments with Excel workflows.
Learn how to get access to QuickBooks Online including a possible free 30-day trial version often offered by Intuit, the owner of QuickBooks Online.
The course will discuss accounting for multiple currencies, outlining the process in Excel to provide a more transparent look at the process. Then we will enter the transactions into QuickBooks, the software automating some of the steps required.
We will learn how to turn multicurrency on, and which accounts will be affected most by multicurrency transactions including cash account types, accounts receivable account types, and accounts payable account types.
Learners will work example problems related to the sales cycles and the purchases cycle, the sales cycle including foreign currency receivables, the purchases cycle including foreign currency payables.
We will also demonstrate transactions related to forward contracts, both for speculative purposes and to mitigate risk on foreign currency transactions.
The multiple currency feature is useful when the company is holding onto cash in a foreign currency, the software helping us to record the home currency equivalent for financial statement presentation.
Multiple currency functionality is also helpful when we make sales on account, sending an invoice, hoping to get paid in the future, tracking accounting receivable, but expecting to be paid in a foreign currency. The accounts receivable account will need to be valued in the home currency even though we will be paid in a foreign one.
We have a similar situation when we make purchases on account, promising to pay in a foreign currency at some point in the future. The accounts payable account will need to be valued in the home currency equivalence even though we will be paying in a foreign currency.