In Gutsy, there are several methods to generate payroll, either through manual generation or by uploading an Excel file. The Excel workflow is helpful when you prefer working with structured data or need to input multiple pay items at once. It allows you to quickly populate payroll details, customise pay item names, and upload everything in bulk to employees’ records.
With a familiar spreadsheet interface and reduced manual input, it helps streamline your process while minimising errors.
This article will guide you on how to generate payroll using the Excel Workflow.
Steps
Head to the side navigation and click Generate Payroll.
Select the month and year of the payroll you wish to generate, along with the relevant payment period.
Choose Upload Excel File.
If you wish to exclude claims from this payroll generation, tick Exclude unpaid claims.
Select the company you want to generate payroll for.
Download the Excel template.
Open the template. You will see several columns available.
Use the dropdown to select the employee’s name and employee number (if applicable).
You will find columns such as Pay Item A amount, Pay Item B amount, and Pay Item C amount.
Rename these columns to match your pay items (e.g. Commission for Pay Item A).
Enter the corresponding amount for each employee (e.g. Amir = 100, Steven = 50).
In the Remark columns (e.g. Pay Item A remark), you may also edit the name and include notes for each item (e.g. “Client A”).
To add more pay items, simply copy and extend the existing columns.
If certain pay item columns are not required, you may also remove them.
Once completed, save the Excel file.
Return to the Gutsy page and upload the file.
The system will display a mapping view to match Excel pay item names/header with those in the system.
Ensure the relevant pay items are already created in advance.
You may adjust mappings, change headers, define whether fields are amounts or remarks, or remove items if needed.
Click Generate Now.
Refresh the page to view the generated payroll.
What’s next?
Once your payroll is generated, you can proceed to view, edit, delete, and publish payslips using the relevant guide here.
You’ve now learnt how to generate payroll using the Excel Workflow! With this method, you can streamline your payroll process, reduce manual effort, and stay in full control of your data.
Still exploring? Head over to our Help Centre for more in-depth guides and FAQs.
If you have any questions, feel free to reach out to us at support@gutsyhq.com. We'll get back to you from there.