Skip to main content
K
KHewitt
August 18, 2022
Question

Year-end adjusting entries - US Bank account

  • August 18, 2022
  • 1 reply
  • 0 views

My company (a Canadian company) bank accounts include both Canadian and US dollar accounts.    Year-end balance sheet is reported entirely in Canadian dollars .... but the US bank account amount ($34,xxx USD$) is reporting as over $70,xxx CDN$.   This is not correct - and the CDN equivalent should be closer to $42,xxx CDN $ based on exchange rate at year-end date.   This indicates some ongoing problem with the exchange rate (provided by Quickbooks) over the course of the year.   My auditor wants me to adjust the Balance Sheet amount on the US account without changing the actual US$ amount on the bank account line.   I do not know how to do this.   Can it be done?  

1 reply

T
Trish_T
August 18, 2022

Hi KHewitt,

 

Thanks for reaching out here.  It's important that you're able to provide the requested information to the auditor with peace of mind.  I'd be happy to point you in the right direction so you can complete you're on the right track with your work!

 

Based on the information you've provided, I recommend reaching out to your accountant for the best course of action to ensure a positive outcome on your books.  If you don't have an accountant, we can help you locate a ProAdvisor in your local area.

 

Feel free to reach back out if you have other questions.  We'd be happy to help!

K
KHewittAuthor
September 1, 2022

I have so far spoken with two Pro Advisors - neither one of which knew the solution to my problem.    I need to figure out how Quickbooks determines the exchange rate when it produces financial reports - such as a Balance Sheet.    The results I am getting are way out of whack with current exchange rates.

A
A_Cue
September 2, 2022

Try using the currency revaluation function.

 

Click on the gear > Currencies > Down arrow beside Edit currency exchange for USD > Revalue Currency > Revalue date for your period end date > Revalue and save.

 

Once done, the trial balance should reflect correctly. Be sure to uncheck "Show unrealized gain or loss" when running the Balance Sheet, A/R summary and A/P summary.

Terms & ConditionsAccessibility statement