Accounting Interface
Previous  Top  Next

 
These instructions are designed for use with RMS version 7, V8 and MYOB version 12.  
RMS support staff are not qualified to offer advice with MYOB.  
The purpose of this function is to allow the export of financial data from RMS and the import of this data into MYOB.  
You will need to purchase the MYOB interface from RMS before you can use this interface.  
 
What does the MYOB Interface Do?  
The MYOB interface provides the ability to export your sales figures from RMS in the form of SL Journal imports directly into MYOB's general ledger and is offset to debtors.  
   
This does not include cash receipts or total cash received in any form.  
   
RMS exports your sales information to a file which is then imported into MYOB using the general journal import facility - for steps on how to import files to MYOB please contact the MYOB support desk.  
   
This has the effect of increasing your sales figures for each GL-Account Code involved and offsets against Debtors.  
   
You would then need to take your Cash Transactions report or Banking figures from RMS and bank these into MYOB thus reducing the debtor's figures.  
   
Glossary of Terms  
Accounting Type:  
If you are unsure of your accounting type, we urge that you contact your accountant for this information.  
The answer to this question will determine whether you export your Cash or Charge report figures.  
   
MYOB File Name:  
Type in an appropriate file name (make sure to leave the .TXT on the end) We suggest that you use a file name in the format of MYOBddmmyy.TXT, where DD = the day in 2 figures, MM = the month in 2 figures and YY = the Year in 2 figures.  
So, the file crated for the 20th of September 2004 would be MYOB200904.TXT – this way you will have a record of all previously exported information.  
 
1. SETUP – General Information  
Go To  
Setup Menu, General Information, Modules Tab  
Enter  
Your MYOB Registration No  
This is provided by the RMS Support Team.  
Save and Exit  
   
2. RESTART – RMS  
Logout  
Of RMS  
Login  
   
3. SETUP – Account Options  
Go To  
Setup Menu, Accounts, Setup, Tax Tab  
Ensure  
Your accounting type is correct (Cash or Accrual)  
Save and Exit  
   
4. SETUP – Account Codes  
Go To  
Setup Menu, Accounts  
Ensure  
That your Account codes in RMS match that of MYOB  
Save and Exit  
   
5. OPERATION – Exporting Data from RMS  
Go To  
Reports, Management  
Select  
Cash or Charge report (depending of your setting in step 3)  
Enter  
The dates your require from & to  
Tick  
Export to MYOB  
Change  
MYOB file date if required  
Change  
MYOB file name (as per page 1)  
Select  
Build  
Record  
The path where RMS has exported your file to  
Select  
OK  
Print  
If required  
   
6. IMPORT – Your file into MYOB  
You will be required to contact the MYOB support desk for assistance with your MYOB import.  
 
The CHM file was converted to HTML by chm2web software.