Accurate transaction information would help you to track your business performance efficiently, CarrieS3. To assist you better, I would like to ask for further details regarding the issue you've encountered in your Balance Sheet report.
 
Can you tell me the process you used to record the foreign currency transactions. Additionally, may I know which specific balance sheet report you accessed and how you customized it on your end? If possible, providing a screenshot would be extremely helpful for us in offering a more accurate solution. 
 

In the meantime, you can check this article to know what to do if your AR/AP balance does not match the balance sheet: Resolve accounts receivable and accounts payable balances on a cash basis balance sheet.

We are fully committed to assisting you with your concerns or questions. Your satisfaction is our priority. Simply click the Reply button, and our team will be ready to provide you with timely assistance.