Learn more here about payrolls in Holded
- Go to Expenses from the navigation bar
- Click on Payrolls
- Access the three-point menu (⋮)
- Click on Import
Holded allows you to import your payroll list to make it easier for you to manage payrolls from a single place.
Importing payrolls to Holded
1. Download the import template
- In the pop-up window, download the sample csv/excel file to see the import format
- Open the downloaded document to be able to work on it
You can always make a copy of the template to work on it and leave the original one intact.
2. Fill in the template
Fill in the fields indicated below. The required fields are marked with an asterisk (*):
|ID document *||Enter the employee's TIN so that the employee is correctly identified
|Date dd/mm/yy*||Enter payroll issue date|
|Description||Add an explanatory text to be able to identify the payroll in the list of payrolls|
|Salary*||The total amount earned|
|Salary Account (640)||Add the account of group 640 to which you want the amount specified in the Salary column to be posted|
|Total S.S.*||The amount of S.S. payable by the company + S.S. payable by the worker|
|Total S.S. Account (476)||Specify the account of group 476 to which you want the amount specified in the Total S.S. column to be posted|
|Company S.S. Expense*||The amount of S.S. payable by the company|
|Company S.S. Expense Account (642)||Indicate the account of group 642 to which you want the amount specified in the Company S.S. Expense to be posted|
|IRPF*||The income tax amount|
|IRPF Account (4751)||Enter the account of group 4751 to which you want the amount specified in the IRPF column to be posted|
|Tags separated by -||Add the labels or tags for analytical accounting|
|Payment amount *||It is calculated as follows: (Salary + Company S.S. Expense) - (Total S.S. + IRPF)|
|To record the payroll payment. Enter the date of payment so that you can later reconcile the bank statement transaction with the recorded payment|
|Indicate the book account of the bank that you have previously created and assigned. The payment will be recorded in this bank for subsequent reconciliation|
Once you have completed the template fields, save the spreadsheet in excel or csv format to be able to import the information correctly.
In case you leave the enabled columns for the book accounts blank, Holded will automatically assign the last general account of each group. For example, if you have created 11 Wages and Salaries book accounts, 640000011 will appear. Learn more here about what book accounts are.
3. Upload the information to Holded
- From Payrolls, access the three-point menu (⋮) again
- Click on Import
- Hit Add file
- Select the spreadsheet you have previously saved with the completed fields
- Confirm the action
If you have forgotten to complete any of the fields, you will have the option to inform later from the platform.
Remember that you can generate and import recurring payrolls to avoid entering repetitive information each time. Check out this article to learn more.