But, as Popeye often said, “I yam what I yam.” If you’re doing everything right, you’ve piqued my curiosity, and I’d be happy to spend a few minutes looking at it with you. This was QBDT 2019, by the way.ġ.Ěre you using a recent version year of QBDT?Ģ.ĝid you go into Enter Bills / Pay Bills and follow the proper A/P workflow? If so, you likely wouldn’t have to adjust the home currency value.ģ.
When I went into Pay Bills to apply one against the other, QBDT changed the exchange rate on me so that they’d zero out. I even tested it out with a foreign bill entered at one exchange rate and a check made out to A/P for the same vendor for the same amount of the bill at a different exchange rate (so that they’d both appear in the Unpaid Bills report, with a different home currency value). If proper workflows were followed in entering and paying the bill, you should not have had an outstanding home currency value to adjust if the foreign amount was zero. That’s because A/P and A/R are supposed to take the differential in the home currency (when there’s a change in the exchange rate) and put it to Exchange Gain or Loss when the bill or invoice is paid. (The Exchange Rate is irrelevant in this case anyway.) I check the Home Currency Adjustment box myself, enter the valuation date (Decemin this case), specify the foreign bank account (the Canadian Bank Account in my example) and the amount of the value adjustment (debit of $223 in this case to zero out the value), and on the second line, specify the E xchange Gain or Loss account and balance the entry (credit $223 in this case). So, my workaround is to open up a General Journal Entry, and leave the Currency and Exchange Rate fields untouched. This resulted in the number of foreign monetary units being unchanged (so reconciliations in that currency were unaffected), but their home currency value was changed, booked to Exchange Gain or Loss. The flip side affected the Exchange Gain or Loss account and the Home Currency Adjustmentbox in the header section of the entry was automatically checked. It’s one in which the debits or credits affected the foreign accounts (even multiple A/R customers and A/P vendors in one transaction, normally not possible in QuickBooks Desktop). If you’ve ever created a Home Currency Adjustment in the conventional way, you could see that, behind the scenes, it created a very specific type of General Journal Entry. So, QuickBooks ignores any foreign balances that are zero, such as the Canadian Bank Account in my simple example above, when it is about to create a Home Currency Adjustment revaluation transaction.īut I have a workaround. The developers obviously decided to minimize the computing power required by telling QuickBooks to ignore zero foreign balances.
Think of all the foreign bank accounts, credit cards and, more importantly, customers and vendors for each currency it would have to go through in calculating the amount of the HCA in a normal company file. When the Home Currency Adjustmentwindow is launched, it looks for non-zero foreign balances to revalue. In this example you opened a Canadian Bank Account on Dec. 31, 2015, with $10,000 CAD: I’m partial to all things Canadian (gee, I wonder why), so let’s call it a Canadian Bank Account. You open a new foreign currency bank account.
Let's look a very simple example of a multi-currency environment. Well, I have the answer – and a very simple workaround.įirst, let me explain how a zero balance foreign bank account with a non-zero home currency value can happen. But when they open the Home Currency Adjustment screen and specify the currency of that bank account, that closed bank account doesn’t appear. dollars.īecause you’ve trained them well, they figure out they need to use the Home Currency Adjustment function, because the problem has to do with fluctuating exchange rates over time. Remember, the Balance Sheet is a summary type of report and all balances are reported in the home currency, in this case, U.S. If you work with multi-currency users of QuickBooks, you more than likely have had a client call you in a panic about a foreign bank account they closed out.ĭespite the fact that the balance in a closed bank account is obviously zero (in any currency), a non-zero home currency balance (either positive or negative) appears for that account on their QuickBooks Balance Sheet.
0 kommentar(er)
