Partner Zone

How to enter a supplier opening balance in foreign currency?

SUSAN-SMT
Contributing Cover User
7 Posts
Contributing Cover User
Australia
Contributing Cover User

7Posts

2Kudos

0Solutions

Solved: Go to Solution

How to enter a supplier opening balance in foreign currency?

Hi, I am using MYOB AR Premier and I want to create a new company file for the new financial year.  

 

Most of our sales/purchases are in USD, so I chose Multi Currency function.  But I couldn't enter the opening balance for each supplier/customer in USD, and these suppliers/customers with USD even were not shown in the supplier/customer list for entering the opening balance.

 

Can someone provide some solution for it? 

 

Thanks

Susan

4 REPLIES 4
Steven_M
MYOB Moderator
44,198 Posts
MYOB Moderator
New Zealand
MYOB Moderator

44,198Posts

6,082Kudos

6,601Solutions

Re: How to enter a supplier opening balance in foreign currency?

Hi @SUSAN-SMT 

 

Opening balances can be entered for your customers and suppliers through Setup>>Balances>>Customer Balances or Supplier Balances.  This process would only allow for local currency pre-conversion transactions to be entered - foreign currency balances ideally should be converted to the local currency amount and then be entered into that space.

Kind regards,
Steven

MYOB Community Support

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

Mike_James
Ultimate Partner
5,294 Posts
Ultimate Partner
New Zealand
Ultimate Partner

5,294Posts

1,133Kudos

682Solutions

Accepted Solution Solved

Re: How to enter a supplier opening balance in foreign currency?

Hi @SUSAN-SMT ,  a solution is to record opening balances as sales invoices and purchase bills in the foreign currency. Ideally these will be dated correctly, BUT this can only be done if the previous financial year is open. These transactions will be recorded as service sales or bills, and allocated direct to the receivable or payable control account (usually a no-no, but correct here, so that there is no GL impact).

 

If you make GST returns on a payments basis, watch out for the impact of any of these transactions that have a GST content (unlikely but possible). 


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise Report Writer - Custom Reporting from MYOB programs
(Including AccountRight Classic/Live, and exo Payroll)

SUSAN-SMT
Contributing Cover User
7 Posts
Contributing Cover User
Australia
Contributing Cover User

7Posts

2Kudos

0Solutions

Re: How to enter a supplier opening balance in foreign currency?

Steve,

 

Thank you for your reply.  

 

I hope MYOB can keep upgrading AR so as to include more functions relating to Multi Currency transactions, just like what we could do in AccountEdge.  I still miss AE which i had used for many year. 

 

Regards

Susan

SUSAN-SMT
Contributing Cover User
7 Posts
Contributing Cover User
Australia
Contributing Cover User

7Posts

2Kudos

0Solutions

Re: How to enter a supplier opening balance in foreign currency?

Hi Mike,

 

Thank you for your advice. I will follow what you suggested. 

 

Regards

Susan

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