Loaded is a specialised hospitality management platform that helps improve revenue, labor costs, and cost of goods. Loaded have utilised our timesheet import specification and can provide a specific file you can easily import into PaySauce.
We've worked with Loaded to write up this handy guide to help you learn how to download your timesheet data from Loaded and import into PaySauce.
Exporting timesheets to PaySauce from Loaded
You need Time permission to export time clocks and Payroll permission to be able to view pay rates. If you don't have access to this module in Loaded, ask someone with Manager's permission to update your user permissions.
You will need to have set up your Staff Roles and Staff details correctly and reviewed your Time Clocks in Loaded in order to export accurately to PaySauce.
If this is the first time you have completed an import, please read the Exporting timeclock from the Loaded article first.
Set up
First, you will need to create a Timesheet Template and Tagsets in PaySauce.
To create the Timesheet Template in PaySauce, click on the company name in top left corner, then select Settings, then Templates.
Click the + button and, enter the name "Timesheet into the Name field and select "Timesheet" in the Template Type drop down list. Lastly click OK to save the template.
To create the Tagsets, click on the Tagsets>then the + button.
You need to create two tagsets, one called Factor and another called Role (in case they already exist, you can just check & edit them as shown below)
Ensure that the Factor and Role tagsets you are creating & editing look like the samples below.
Sample of the Factor tagset:
Here is what you need to select in the Links With dropdown list (Payment, Deduction, Timeband).
You also need to click Add Tags and add a tag with Label "ORD" and value "1".
Sample of the Role tagset:
Here is what you need to select in the Links With dropdown list (Employees, Period, Timecard, Payment, Deduction, Timeband):
Then you need to click Add Tags and add Tags that would match Roles in your Loaded account. The Label and Value of each tag should match the name of a Role in Loaded. In our sample account, we add two roles, Bar and Kitchen:
Here is a sample of what the Kitchen tag looks like, both text fields match a title of the "Kitchen" role in Loaded:
Here are the roles in Loaded that we want to match to the two tags we have created for the Role tagset:
Setting up staff members
When setting up staff members in Loaded, ensure that the Staff Paycode in Loaded matches the IRD No of the Staff member in PaySauce. You also need to link the employee's allowance with the Template that you have set earlier. To do it, move to the Payments tab> click the + button to create an allowance or if there is an existing one, click on its title to edit it:
Below is a sample of how you can set up an allowance, you need to ensure that "Yes" is selected for the Use Template option and the Timesheet template is selected for the Template option:
Importing to PaySauce Payroll
Ensure you have successfully exported your timesheets from Loaded.
Click Run a Pay*>click on the Clock icon>then click the Up arrow* in PaySauce and upload the file you have exported from Loaded.
Click the Data Import button on the right-hand side then Choose file pick a file you have exported from Loaded and click Import.
After this, you can process the pay as per the instructions in the PaySauce Help Centre.