Fuego: Importing Tips to Fuego – Fourth & HotSchedules Customer Success Portal

Overview

As part of the management of the Fuego on-demand pay solution, you may be required to import tips via the Fuego Admin tool. These tip values can then be used to pay out tips to employees or be combined with hours to make up the earned wage access offer. This article covers the steps of how to create and import tips data (in CSV format) into Fuego.

Please note: If your tips are set up to flow automatically into Fuego from your POS, HotSchedules or a third-party pooling/sharing solution then you will not need to import tips into Fuego - there will be no option to do so on the Tip Management screen.

When tips data is imported, the tips can then be paid out to employees. See here for guidance - Fuego: TPO: Tip Management.

Tips File Format/Template

The default file format is CSV and the default template is shown in the table below
The file should only include data for the Location that it is being uploaded for

Please note: It may be the case you have a different file format than the default one described below. This will have been communicated during the implementation phase.

Default Template

Colum	Field	Format	Value
A	Export ID	Alphanumeric value	Employee payroll number
B	Employee Full Name	No special characters	Not required but useful for checking
C	Indirect Tips Payable	Leave blank	Not Required
D	Direct Tips Payable	Leave blank	Not Required
E	Total Tips Payable	##.##	Total value to be paid to the employee
F	Location	leave blank	Not required for manual upload
G	Business Date	Leave blank if using for a single date or MM/DD/YYYY or YYYY-MM-DD	The date will be driven by the date picker on the 'Import' pop-up If uploading tips for multiple business dates you can use this field and it will take priority over the date picker

Example File - in Microsoft Excel

Example File - in plain text

Export ID,Employee Full Name,Indirect Tips Payable,Direct Tips Payable,Total Tips Payable,Location,Business Date
UAT01,Joe Blogs,,,45,,
7892,Jane Blogs,,,35,,
83252,Amol Chowdhurry,,,112,,
KU003,Jimmy Smith,,,22.68,,

When your tips CSV file is complete and ready to import, be sure to save it in a location that can be accessed from the computer you use to import the data

Multiple rows for the same employee on the same day will be aggregated

If you upload tips to the wrong business date you can overwrite these values by uploading a file to the same business date with zero values in column E against each employee. Essentially every time you upload tips against a business date, previous values are overwritten.

Logging In and Importing Tips

The Fuego Admin Tool can be accessed via any supported browser at admin.fuegosecure.com/login
Recommendation: bookmark the address!
A full login guide can be found here: Fuego Login Guide

You will receive login details from your implementation specialist or your central Fuego administrator.

Users need the 'Manual Tips Import' permission to be able to import tips files.

Use the side menu and select Tip Management
Select the Day view, a Business Date, and then Upload File

In the 'Upload File' pop-up window that opens, the 'Business Date' will be auto-populated

Use the File Format drop-down and select either:
- Download Template format - use this if the selected file has been created from the 'Download Template' link (shown in Fig.1)
  or
- Custom Template format - use this if the file uses a custom format, set up during the implementation phase
Either drag & drop your tips file or use Browse files to find and select it
Synching Enabled - this is the default setting - manually imported tips data will be overwritten by any subsequent automatic tip imports on that date
Synching Disabled - manually imported tips data will not be overwritten by any subsequent automatic tip imports on that date
Regardless of which setting is chosen, a manual import will always overwrite any existing loaded data for that day
To apply the settings and upload the file, select Save