Partner Zone

Foreign current reconciliation/report difference

Mattan
Experienced Cover User
15 Posts
Experienced Cover User
Australia
Experienced Cover User

15Posts

0Kudos

0Solutions

Foreign current reconciliation/report difference

I am having the same issue as https://community.myob.com/t5/Multi-Currency/USD-A-c-reconciliation-printed-report-error/td-p/619057

 

The bank rec shows the correct balance but a Balance Sheet is very different.

5 REPLIES 5
ChrisMYOB
MYOB Moderator
1,133 Posts
MYOB Moderator
MYOB Moderator

1,133Posts

77Kudos

131Solutions

Re: Foreign current reconciliation/report difference

Hello @Mattan 

 

Are you able to please confirm if it it showing that there is no out-of-balance while on the Bank Reconciliation but then shows differently on the report? 

Are you able to please send me screenshots of it showing the different amounts. I have provided some steps here to be able to check this.

  • Go to Index to ReportsBankingBank rec report
  • Click advanced filters
  • On Accounts dropdown, untick all, then just tick the specific bank account and go OK
  • Then once Select By gives a dropdown change it from Entered Statement date to List of recorded statement dates
  • Select the most recent bank rec and click Run Report
  • Note/copy the Expected Balance on statement amount
  • Go to BankingReconcile Accounts, select the FX bank account
  • Put date as last reconciled date and closing statement balance as the Expected Balance amount

Please let me know how you go.

Kind regards,
Chris

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Mattan
Experienced Cover User
15 Posts
Experienced Cover User
Australia
Experienced Cover User

15Posts

0Kudos

0Solutions

Re: Foreign current reconciliation/report difference

Hi @ChrisMYOB 

 

Here is the bank reconcilation screen and a balance sheet. I can't generate the Reconciliation Report from the same date though. Not sure why

Screenshot 2022-09-20 152958.jpg

Screenshot 2022-09-20 161922.jpg

 

Regards

 

Matt

ChrisMYOB
MYOB Moderator
1,133 Posts
MYOB Moderator
MYOB Moderator

1,133Posts

77Kudos

131Solutions

Re: Foreign current reconciliation/report difference

Hello @Mattan 

 

Are you able to produce a Reconciliation Report for any other day? or are you unable to produce the report at all? Are you getting an error message popping up? Can you please give me more details about this? 

If you are able to produce the report for another day, please provide a screenshot report.

Kind regards,
Chris

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Mattan
Experienced Cover User
15 Posts
Experienced Cover User
Australia
Experienced Cover User

15Posts

0Kudos

0Solutions

Re: Foreign current reconciliation/report difference

Hi @ChrisMYOB 

 

Yes, I can produce a reconciliation report for another day, but the latest date shows this.

 

Screenshot 2022-09-21 150711.jpg

 

Here is an older date.

 

Screenshot 2022-09-21 150920.jpg

Mattan
Experienced Cover User
15 Posts
Experienced Cover User
Australia
Experienced Cover User

15Posts

0Kudos

0Solutions

Re: Foreign current reconciliation/report difference

Hi @ChrisMYOB 

 

Any suggestions on how to resolve this?

 

Thanks

 

Matt

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post