Load Current Payroll Data from a MYOB® File


This is an automated process - simply click this button below:



Note: STP Creator has been tested on all Classic versions of from Accounting v13 up to an including v19.16 (that's 19.sixteen) as well as their Premier / Enterprise equivalents, and on Live versions AR2013.5 to AR2023.


IMPORTANT - STP Creator does NOT make any changes to your MYOB® company file. During the loading process it establishes read-only access to the data in your company file. The company file should not be in use at the time. If MYOB® cannot be closed to allow STP Creator access, use a copy or a backup of the company file, or tick the option to use a temp local copy.




Before starting:

Ensure that all data in your MYOB® company is as complete and accurate as possible. This means:


Accessing Payroll Data from the linked MYOB® Company File


Ensure also that you know the Administrator password or get the Administrator to create a new user called STP_NAMICH - these are the only 2 user names STP Creator will allow to access the company file. Get Administrator to set relevant permissions and restrictions to match your existing permissions, and give you the password for this user. The password must not exceed 11 characters. Note that STP Creator will only allow access to payroll data (employees, payroll categories and payroll transactions) - this is irrespective of permissions allocated to STP_NAMICH. The permissions should be set to ensure should you access the company file through MYOB®, you can only access areas you are authorised to access.


See message below if someone tries to Load Data from MYOB® using a different User ID:




The Log In screen below is for allowing STP Creator to access payroll data from your MYOB® company file. Select ADMINISTRATOR and enter the administrator password from your MYOB® company file.




Sorry Password does not match password in this file:



If you do not know the Administrator password from the MYOB® company file, can you add a new user? If yes, add a new user called STP_NAMICH. You will be able to log in with that user name. This is all due to ATO confidentiality issues.


If you cannot add a new user, download FGH File Utility from link here https://www.fghtables.com/MYOB/fileutility1.php, run the download, select your company file (ensure MYOB is closed), click File Dates etc and use the reset button at bottom of screen. On next screen you will see current serial number and Alpha Number. Click Purchase Code, enter last 4 digits of serial number and Alpha Number, pay fee ($33), and a 6 digit code will soon appear on screen. Enter that code into File Utility screen and click Reset Password. This will clear the Administrator password.



Lock Files - the MYOB® may be opened by another user


If there are Lock Files in the same folder as the MYOB file, you will see this message:




Classic MYOB® uses Lock files to monitor access to the company file. Each time you log in, lock files are created, these are called Access51.flk and Lock0001.flk. The numbers change however Access and Lock files always have an .flk extension. When you log out, MYOB® deletes these Lock and Access files. If however you do not log out correctly, for example as a result of a power loss, the Lock and Access files will remain.


If the file is not currently used, the Lock files may be old. Delete them to prevent this message.


If the file is in use, ensure whoever is currently logged in, does not process transactions for the next few minutes. Give them the all clear once STP Creator has loaded the data. You will be advised how long this took and so next time you will know how long to keep other users from processes. When doing STP, the MYOB® data is normally loaded once.



More Employees


'There are more Employees in this company file than are in this Data Set file'


When you load data from a linked MYOB® company file, you may see this message.




If you have added one or more employees since you last used this Data Set file, before proceeding, from the Permanent Data Set screen select  '4. Select Payees'.

Then click 'Update from Company File' - STP Creator will update the Payee Table by adding the new employee(s). If the new employee(s) have been paid, select the employee from the bottom of the Payee table and then click 'Include in STP' - this will ensure STP Creator reports on the new employee. You should then click 'Check All STP Payees' to ensure the STP count and the Checked count match.




More Payroll Categories


'There are more Payroll Categories in this company file than are in this Data Set file'


When you load data from a linked MYOB® company file, you may see this message.




If you have added one or more Payroll Categories since you last used this Data Set file, before proceeding, from the Permanent Data Set screen select  '3. Map Payroll Categories'.


Then click 'Update from Company File' - STP Creator will update the Payroll Category Table by adding the new Payroll Category. The new Payroll Category should also be mapped to a STP Field and for W1 W2 purposes.



Payroll Year does not match



'The Payroll Year in this MYOB® company file is xxxx'


This message may appear when you Load Payroll Data from the linked MYOB® company file. This is normal and expected when you try to use the Data Set file to report the first Payroll in a new Payroll Year. In the above example, we have rolled our Payroll Year in the MYOB® company file from 2019 to 2020. However the Payroll Year setting in the Data Set file is still 2019. If you see this message after you have started a new Payroll Year in MYOB, click Yes and STP Creator will update the Payroll Year in the Data Set file to match the Payroll Year in the MYOB® company file.


When changing a Payroll Year in MYOB®, it is good practice to make a backup and appropriately label it, for example 'Backup B4 Roll to 2020 PY.zip'. This allows the correct backup to be readily identified should you need to re-issue Payment Summaries or make any other payroll changes in the Payroll Year about to be closed.


When making your MYOB® pre rollover backup, we recommend you also make a copy of your Data Set file while the Payroll Year matches the Payroll Year in MYOB®. Label it appropriately such as 'Final DataSet for 2019 PY.dsf'. Should you need to correct an STP Report from the prior year, you will have ready access to the MYOB® backup as well as the Data Set for that backup.