With the changes made in version 9.0 of Shepherds Staff, the way you export your data out of Payroll Mate has changed.
To export your data out of Payroll Mate,
- Open up the Payroll Mate Application on your Computer.
- Click on Tools at the top of the screen and click on "Export Payroll Data To". Select "General Ledger".
- You will be taken to a screen that says Export Payroll to General Ledger with three options: Report Options, Preview, and Export. Click on Report Options where you will be where you will see three steps you need to complete to set the report:
- Set the date range for the checks to include in the report
- Select the employees to include in the report
- Assign account names for your payroll items. You can either enter in the payroll item’s name for the account or enter the corresponding account number in Shepherd’s Staff for the payroll items. Our suggestion would be to copy the name of the payroll items into where it says "General Ledger Account Name" so that when you import the file into Shepherd’s Staff you can match the payroll items to the correct accounts in Shepherd’s Staff.
- You will see two options at the top that say, “Check Net Pay General Ledger Account Name” and "Payroll Liability General Ledger Account Name”. Check Net Pay corresponds to the bank account in Shepherd’s Staff that your payroll comes out of while the Payroll Liability is an account that corresponds to the portions that the employer pays for on the payroll. To make the import process easier, when matching the payroll accounts up in Shepherd’s Staff we suggest naming "Check Net Pay" to "Net Pay" and "Payroll Liability" as "Payroll Employer Liability".
- You will see two options at the top that say, “Check Net Pay General Ledger Account Name” and "Payroll Liability General Ledger Account Name”. Check Net Pay corresponds to the bank account in Shepherd’s Staff that your payroll comes out of while the Payroll Liability is an account that corresponds to the portions that the employer pays for on the payroll. To make the import process easier, when matching the payroll accounts up in Shepherd’s Staff we suggest naming "Check Net Pay" to "Net Pay" and "Payroll Liability" as "Payroll Employer Liability".
- Once you have finished getting the report set up you will then press OK and press Export button on the previous screen to create the Excel file you will be importing into Shepherd’s Staff. You will want to check the excel file to make sure that there are not any blank items under the General Ledger Account Name column, otherwise those items will be imported but show up as a blank item in the Payroll Import.
For information on importing Payroll Mate into Shepherd's Staff, please visit our article here.